Lesson 1 Flashcards
Database
A shared, integrated computer structure that stores a collection of related data.
Data Management
A process that focuses on data collection, storage, and retrieval.
Common data management functions include addition, deletion, modification, and listing
What are the two types of data in a database?
- end-user data (raw facts)
- Metadata
Metadata
Data about data; that is, data about data characteristics and relationships
Database Management Systems (DBMS)
The collection of programs that manages the database structure and controls access to the data stored in the database.
What are six advantages of a DBMS?
- Improved data security
- Better data integration
- Minimized data inconsistency
- Improved data access
- Improved decision making
- Increased end-user productivity
Data inconsistency
A condition in which different versions of the same data yield different (inconsistent) results.
Query
- A question or task asked by an end user of a database in the form of SQL code.
- A specific request for data manipulation issued by the end user or the application to the DBMS.
Ad hoc query
A “spur-of-the-moment” question
Query result set
The collection of data rows returned by a query.
Data quality
A comprehensive approach to ensuring the accuracy, validity, and timeliness of data.
Single-user database
A database that supports only one user at a time
Desktop database
A single-user database that runs on a personal computer.
Multiuser database
A database that supports multiple concurrent users
Workgroup database
A multiuser database that usually supports:
- Fewer than 50 users or
- Used for a specific department in an organization.
Enterprise database
The overall company data representation, which provides support for present and expected future needs.
Centralized database
A database located at a single site
Distributed database
A logically related database that is stored in two or more physically independent sites.
Cloud database
A database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS
General-purpose database
A database that contains a wide variety of data used in multiple disciplines.
Discipline-specific database
A database that contains data focused on specific subject areas
Operational database
A database designed primarily to support a company’s day-to-day operations.
An operational database is also known as: 3
- online transaction processing database (OLTP)
- Transactional database
- production database
Data warehouse
- A specialized database that stores historical and aggregated data.
- The data format is optimized for decision support.