DBMS
DATABASE ARCHITECTURE
DATABASE CONCEPTS
Figure 1.1 – Main Concepts of a DBMS
Database is an organized collection of data.
Database management system (DBMS) is a computer program (or more typically, a suite of them) designed to manage a database, a large set of structured data, and run operations on the data requested by numerous users.
Data Manipulation Language (DML) is a family of syntax elements similar to a computer programming language used for inserting, deleting and updating data in a database.
Data Definition Language or Data Description Language (DDL) is a syntax similar to a computer programming language for defining data structures, especially database schemas.
Database schema is a set of formulas (sentences) called integrity constraints imposed on a database.
Metadata refers to "data about data".
Metacontent are defined as the data providing information about one or more aspects of the data, such as:
Means of creation of the data
Purpose of the data
Time and date of creation
Creator or author of the data
Location on a computer network where the data were created
Standards used
Fundamental concepts (types) of Metadata
Structural metadata is about the design and specification of data structures and is more properly called "data about the containers of data".
Descriptive metadata is about individual instances of application data, the data content. "data about data content" or "content about content"
Some Examples of Software Modules (DB Manager Program)
Structured Query Language (SQL) server
MySQL Database
FoxPro
Microsoft Access
Data Dictionary is a software utility that catalogs an organization's data resources: what data exist where they originate who uses them what are their format, etc.
Data dictionary not only tells where the data are located in the database, but also which application programs process the data, and closely coordinates with the DBMS in controlling access to the database.
DATABASE CONCEPTS
Figure 1.1 – Main Concepts of a DBMS
Database is an organized collection of data.
Database management system (DBMS) is a computer program (or more typically, a suite of them) designed to manage a database, a large set of structured data, and run operations on the data requested by numerous users.
Data Manipulation Language (DML) is a family of syntax elements similar to a computer programming language used for inserting, deleting and updating data in a database.
Data Definition Language or Data Description Language (DDL) is a syntax similar to a computer programming language for defining data structures, especially database schemas.
Database schema is a set of formulas (sentences) called integrity constraints imposed on a database.
Metadata refers to "data about data".
Metacontent are defined as the data providing information about one or more aspects of the data, such as:
Means of creation of the data
Purpose of the data
Time and date of creation
Creator or author of the data
Location on a computer network where the data were created
Standards used
Fundamental concepts (types) of Metadata
Structural metadata is about the design and specification of data structures and is more properly called "data about the containers of data".
Descriptive metadata is about individual instances of application data, the data content. "data about data content" or "content about content"
Some Examples of Software Modules (DB Manager Program)
Structured Query Language (SQL) server
MySQL Database
FoxPro
Microsoft Access
Data Dictionary is a software utility that catalogs an organization's data resources: what data exist where they originate who uses them what are their format, etc.
Data dictionary not only tells where the data are located in the database, but also which application programs process the data, and closely coordinates with the DBMS in controlling access to the database.