Introduction to Databases and MySQL Architecture
1.Data: Data is numeric, textual, visual, or audio information that
describes real-world systems.
2.analog: Historically, data was mostly analog, encoded as continuous
variations on various physical media.
3.digital: Today, data is mostly digital, encoded as zeros and ones on
electronic and magnetic media.
4.database: A database is a collection of data in a structured format.
5.database system / database management system / DBMS: A database
sys- tem, also known as a database management system or DBMS, is
software that reads and writes data in a database.
6.query language: A query language is a specialized programming
language, designed specifically for database systems.
7.database application: A database application is software that helps
business users interact with database systems.
8.database administrator: A database administrator is responsible for
securing the database system against unauthorized users.
9.database designer: A database designer determines the format of
each data element and the overall database structure.
10.database programmer: A database programmer develops computer
programs that utilize a database.
11.database user: A database user is a consumer of data in a database.
12.transaction: A transaction is a group of queries that must be either
completed or rejected as a whole.
13.architecture: The architecture of a database system describes the
internal components and the relationships between components.
14.query processor: The query processor interprets queries, creates a
plan to modify the database or retrieve data, and returns query results
to the application.
15.query optimization: The query processor performs query
optimization to en- sure the most efficient instructions are executed
on the data.
16. storage manager: The storage manager translates the query
processor instruc- tions into low-level file-system commands that
modify or retrieve data.
17.indexes: The storage manager uses indexes to quickly locate data.
18.transaction manager: The transaction manager ensures transactions
are prop- erly executed.
19.log: The log is a file containing a complete record of all inserts,
updates, and deletes processed by the database.
, Introduction to Databases and MySQL Architecture
20.catalog / data dictionary: The catalog, also known as a data
dictionary, is a directory of tables, columns, indexes, and other
database objects.
, Introduction to Databases and MySQL Architecture
21.relational database: A relational database stores data in tables,
columns, and rows, similar to a spreadsheet.
22.SQL: SQL stands for Structured Query Language and includes
statements that read and write data, create and delete tables, and
administer the database system.
23.big data: The growth of the internet in the 1990s generated massive
volumes of online data, called big data, often with poorly structured or
missing information.
24.NoSQL: The newer non-relational systems are called NoSQL, for 'not
only SQL', and are optimized for big data.
25.Open source: Open source software is software that anyone can
inspect, copy, and modify with no licensing fee.
26.query: A query is a command for a database that typically inserts
new data, retrieves data, updates data, or deletes data from a
database.
27.CRUD: The four common queries are sometimes referred to as
CRUD opera- tions, an acronym for Create, Read, Update, and Delete
data.
28.Structured Query Language / SQL: Structured Query Language, or
SQL, is the standard query language of relational database systems.
29.statement: An SQL statement is a database command, such as a
query that inserts, selects, updates, or deletes data.
30.INSERT: INSERT inserts rows into a table.
31.SELECT: SELECT retrieves data from a table.
32.UPDATE: UPDATE modifies data in a table.
33.DELETE: DELETE deletes rows from a table.
34.CREATE TABLE: The SQL CREATE TABLE statement creates a new
table by specifying the table and column names.
35.data type: Each column is assigned a data type that indicates the
format of column values.
36.database design: A database design is a specification of database
objects such as tables, columns, data types, and indexes.
37.analysis: The analysis phase specifies database requirements
without regard to a specific database system.
38.ER diagrams: Entities, relationships, and attributes are depicted in
ER dia- grams.
39.logical design: The logical design phase implements database
requirements in a specific database system.
40.key: A key is a column used to identify individual rows of a table.
, Introduction to Databases and MySQL Architecture
41.table diagram: The logical design is depicted in a table diagram.
42.schema: The logical design, as specified in SQL and depicted in a
table dia- gram, is called a database schema.
1.Data: Data is numeric, textual, visual, or audio information that
describes real-world systems.
2.analog: Historically, data was mostly analog, encoded as continuous
variations on various physical media.
3.digital: Today, data is mostly digital, encoded as zeros and ones on
electronic and magnetic media.
4.database: A database is a collection of data in a structured format.
5.database system / database management system / DBMS: A database
sys- tem, also known as a database management system or DBMS, is
software that reads and writes data in a database.
6.query language: A query language is a specialized programming
language, designed specifically for database systems.
7.database application: A database application is software that helps
business users interact with database systems.
8.database administrator: A database administrator is responsible for
securing the database system against unauthorized users.
9.database designer: A database designer determines the format of
each data element and the overall database structure.
10.database programmer: A database programmer develops computer
programs that utilize a database.
11.database user: A database user is a consumer of data in a database.
12.transaction: A transaction is a group of queries that must be either
completed or rejected as a whole.
13.architecture: The architecture of a database system describes the
internal components and the relationships between components.
14.query processor: The query processor interprets queries, creates a
plan to modify the database or retrieve data, and returns query results
to the application.
15.query optimization: The query processor performs query
optimization to en- sure the most efficient instructions are executed
on the data.
16. storage manager: The storage manager translates the query
processor instruc- tions into low-level file-system commands that
modify or retrieve data.
17.indexes: The storage manager uses indexes to quickly locate data.
18.transaction manager: The transaction manager ensures transactions
are prop- erly executed.
19.log: The log is a file containing a complete record of all inserts,
updates, and deletes processed by the database.
, Introduction to Databases and MySQL Architecture
20.catalog / data dictionary: The catalog, also known as a data
dictionary, is a directory of tables, columns, indexes, and other
database objects.
, Introduction to Databases and MySQL Architecture
21.relational database: A relational database stores data in tables,
columns, and rows, similar to a spreadsheet.
22.SQL: SQL stands for Structured Query Language and includes
statements that read and write data, create and delete tables, and
administer the database system.
23.big data: The growth of the internet in the 1990s generated massive
volumes of online data, called big data, often with poorly structured or
missing information.
24.NoSQL: The newer non-relational systems are called NoSQL, for 'not
only SQL', and are optimized for big data.
25.Open source: Open source software is software that anyone can
inspect, copy, and modify with no licensing fee.
26.query: A query is a command for a database that typically inserts
new data, retrieves data, updates data, or deletes data from a
database.
27.CRUD: The four common queries are sometimes referred to as
CRUD opera- tions, an acronym for Create, Read, Update, and Delete
data.
28.Structured Query Language / SQL: Structured Query Language, or
SQL, is the standard query language of relational database systems.
29.statement: An SQL statement is a database command, such as a
query that inserts, selects, updates, or deletes data.
30.INSERT: INSERT inserts rows into a table.
31.SELECT: SELECT retrieves data from a table.
32.UPDATE: UPDATE modifies data in a table.
33.DELETE: DELETE deletes rows from a table.
34.CREATE TABLE: The SQL CREATE TABLE statement creates a new
table by specifying the table and column names.
35.data type: Each column is assigned a data type that indicates the
format of column values.
36.database design: A database design is a specification of database
objects such as tables, columns, data types, and indexes.
37.analysis: The analysis phase specifies database requirements
without regard to a specific database system.
38.ER diagrams: Entities, relationships, and attributes are depicted in
ER dia- grams.
39.logical design: The logical design phase implements database
requirements in a specific database system.
40.key: A key is a column used to identify individual rows of a table.
, Introduction to Databases and MySQL Architecture
41.table diagram: The logical design is depicted in a table diagram.
42.schema: The logical design, as specified in SQL and depicted in a
table dia- gram, is called a database schema.
