18 Questions
What is the singular form of the word 'data'?
Datum
Which type of databases contain data focused on specific subject areas?
Discipline-specific databases
What type of database is designed primarily to support a company's day-to-day operations?
Operational database
What is the main focus of an analytical database?
Storing historical data
What is a data warehouse specialized in?
Storing data optimized for decision support
'A single fact as a datum and a set of facts as data' refers to the classification by:
Data Usage
What is the core activity for any business, government agency, service organization, or charity?
Data management
What type of database supports only one user at a time?
Single-user database
Which database type supports many users, usually more than 50 across multiple departments?
Enterprise database
What is the primary function of a Database Management System (DBMS)?
Allowing access to data in a database
In the context of databases, what is a software system that works as an interface between application programs and the data stored in the database?
Database Management System (DBMS)
What does an integrated collection of related files and details of data interpretation refer to in the context of databases?
Database system
What is the purpose of Online Analytical Processing (OLAP)?
Providing a data analysis environment for retrieving, processing, and modeling data from the data warehouse
What is metadata in the context of databases?
Data about data that integrates and manages end-user data
What do constraints represent in a database?
Predicates defining correct database states
How are databases organized by fields defined?
Through classifications by data structure records
What distinguishes semi-structured data from structured data in databases?
Semi-structured data are unprocessed raw facts while structured data are processed for storage
What does schema describe in the context of databases?
Organization of data and relationships within the database
Study Notes
Data: Backbone of an Organization
- Data is the most critical resource of an organization, consisting of raw facts that describe a particular phenomenon.
- The word "data" is often considered singular, but it is plural, with the singular form being "datum" (Latin for a given fact).
Classification of Data
- General-purpose databases contain a wide variety of data used in multiple disciplines.
- Discipline-specific databases contain data focused on specific subject areas, used mainly for academic or research purposes.
Classification by Data Usage
- Operational databases (Online Transaction Processing) support a company's day-to-day operations.
- Analytical databases focus on storing historical data and business metrics used for tactical or strategic decision-making.
- A data warehouse is a specialized database that stores data in a format optimized for decision support.
Classification by Number of Users
- Single-user databases (Desktop databases) support only one user at a time.
- Multi-user databases (Workgroup databases) support multiple users at the same time (usually fewer than 50).
- Enterprise databases support many users (more than 50, usually hundreds) across many departments.
Database System and Management
- A database system simplifies managing data and extracting useful information quickly.
- Data management is a discipline that focuses on the proper generation, storage, and retrieval of data.
- A database management system is a software system that allows access to data contained in a database.
Database Components
- A data item is a distinct piece of information.
- Relationships represent a correspondence between various data elements.
- Constraints are the predicates that define correct database states.
- A schema describes the organization of data and relationships within the database.
Types of Databases
- Unstructured data exist in their original (raw) state.
- Structured data are the result of formatting unstructured data to facilitate storage, use, and the generation of information.
- Semi-structured data are data that have already been processed to some extent (e.g., XML databases).
Database Design
- Database design focuses on the design of the database structure that will be used to store and manage end-user data.
Explore the fundamentals of Online Analytical Processing (OLAP) - a set of tools for advanced data analysis in business intelligence. Learn about end-user data, metadata, database organization, and data classifications by data structure records.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
