Database Management Systems

Data lineage encompasses the history of how data has been transformed and integrated, the relationships between different data elements, and the rules and processes used to integrate data. It provides a comprehensive understanding of the data's origins, transformations, and dependencies, enabling data analysts and engineers to trace data back to its source and identify potential issues or inconsistencies.

Continuous data types can take on any value within a range, such as height or weight.

Discrete data types can only take on specific values, such as gender or occupation.

Genomic data is typically not collected in medical informatics, as it is more commonly associated with genetic testing and research.

Administrative data can be collected by government agencies, businesses, and researchers.

The object-oriented data model represents data in the form of objects, which are entities with attributes and methods. Objects are linked together through relationships, forming a network of interconnected objects.

Normalization is the process of organizing data into a logical structure that minimizes redundancy and ensures data integrity. It involves dividing data into tables and establishing relationships between them based on common attributes.

A table is a collection of related data stored in a database. It consists of rows and columns, where each row represents a record and each column represents a field or attribute of that record.

The transaction manager is responsible for managing concurrent access to data and ensuring data integrity. It ensures that transactions are executed atomically, consistently, isolated, and durably (ACID properties).

The storage manager is responsible for managing the physical storage of data on disk. It allocates space for data files, manages free space, and handles data placement and retrieval.

The query processor is responsible for parsing and validating SQL statements. It converts the SQL statement into an internal representation, optimizes the query plan, and executes the query against the database.

The transaction manager is responsible for maintaining the consistency of data in the database. It ensures that transactions are executed atomically, consistently, isolated, and durably (ACID properties).

The buffer manager is responsible for managing the allocation and deallocation of memory for data structures. It allocates buffers for data pages and manages the replacement of pages in the buffer pool when necessary.

A schema is a collection of related tables in a database. It defines the structure of the database, including the names of the tables, the columns within each table, and the relationships between the tables.

The query processor is responsible for optimizing the execution of queries. It generates an efficient query plan that minimizes the cost of executing the query, taking into account factors such as the size of the tables, the availability of indexes, and the type of query being executed.