DAT 390 Wk 3 – Practice: Reading

0 items
DAT 390 Wk 3 - Practice: Reading
DAT 390 Wk 3 – Practice: Reading
$6.00
  • Description

DAT 390 Wk 3 – Practice: Reading

Accurately complete the 3.1 to 3.7 Reading, Participation, and Challenge Activities to receive full points for this practice. You have unlimited attempts. The points you see in zyBooks do not reflect the points you receive in the gradebook.

Architecture describes the components of a computer system and the relationships between components. This section describes MySQL architecture. Other relational databases have similar components, but component details and relationships vary greatly.

MySQL components are organized in four layers:

  • Tools interact directly with database users and administrators, and send queries to the query processor.
  • The query processor manages connections from multiple users and compiles queries into low-level instructions for the storage engine.
  • The storage engine executes instructions, manages indexes, and interacts with the file system. Some storage engines support database transactions, described elsewhere in this material.
  • The file system contains system and user data, such as log files, tables, and indexes.

MySQL is available in a free version, called MySQL Server, and a paid version, called MySQL Enterprise Edition. The Enterprise Edition includes MySQL Server and components for high-end commercial installations, such as:

  • Monitor collects and displays information on CPU, memory, and index utilization, as well as queries and results. Database administrators use Enterprise Monitor to manage and tune large databases with many users.
  • Audit keeps track of all database changes. For each change, Audit tracks the time of change and who made the change. Audit supports government and business audit requirements for sensitive databases such as financial, medical, and defense.

Additional Enterprise Edition components provide advanced support for backup, security, encryption, and firewall. Enterprise Edition components are intended for database administrators, not users.