Aktuelle Änderungen
Printable View
Änderungen
Bearbeiten
DBTransformation > DLR > DynamicLanguageRuntime > DSL > DomainSpecificLanguages > DVCS > DistributedVersionControlSystem > DataAbstraction > DataBinding > DataCleaning > DataCrunching > DataDriven > DataDrivenProgramming > DataSets > DataSet > DatabaseDesign > DatabaseGlossaryClear Trail
DBMS
SQL
- catalog
- ANSI-SQL term for database
Metadata on the schemata (see database-catalog).
cluster == catalog == database if only 1 cluster and 1 catalog exist in the databasecluster(database).catalog(database).schema(owner)
- cluster
- he top level of the SQL Object hierarchy (the next level is the Catalog level, then comes the Schema level, then Objects such as Tables or Domains). Most DBMSs do not support multiple Clusters, therefore there is usually no need to use [cluster.] as a Catalog qualifier. [1]
- database
- [1] The collection of Catalogs, Schemas, Tables, Constraints, Domains, rows, etc. i.e.: the data plus the description of the data. [2] A Cluster. [2]
- database-catalog
- The collection of system tables, tables that store metadata about that specific database. [3]
also system catalog
- owner
- SQLServer term for schema.
- schema
- a collection of database entities that forms a single namespace [4]
The overall logical organization of a database. [5]
The structure or template of the data in a database. [6]
A schema is a collection of database objects (as far as this hour is concerned—tables) associated with one particular database username. This username is called the schema owner, or the owner of the related group of objects. You may have one or multiple schemas in a database. Basically, any user who creates an object has just created his or her own schema. [7]
The level of the SQL Object hierarchy below a Catalog. A named group of Tables/Domains/Constraints/Character sets/etc. which is owned by a single user. [8]
Links