Database Systems: Data, Information, and Management Concepts

What is online analytical processing (OLAP)?

A technology that enables retrieving, processing, and modeling data from a data warehouse.

What are the advantages of using a DBMS?

Improved data quality, data sharing, data security, and decision making.

What is the purpose of database design?

To facilitate data management and generate accurate and valuable information.

What is the primary purpose of database systems?

To process data, reveal its meaning, and enable knowledge creation.

What is a data warehouse?

A system that stores data optimized for decision support.

What is a database?

A collection of programs that manage the database structure and control access to stored data.

What is a data dictionary?

A component of the DBMS that stores definitions of data elements and their relationships.

What is an example of raw data?

A list of temperature readings in cities over the last 5 years.

What is structural dependence in file systems?

Access to a file is dependent on its structure, meaning changes in structure affect access.

What is the difference between data and information?

Data is raw facts that have not been processed, while information is data that has been processed to reveal meaning.

What are the characteristics that data should have to support good decision making?

Data should be accurate, relevant, and timely.

What are the types of databases?

Desktop, workgroup, enterprise, single-user, multiuser, centralized, distributed, and cloud databases.

What are the disadvantages of database systems?

Increased costs, management complexity, maintaining currency, vendor dependence, and frequent upgrades.

What is the significance of data independence?

It allows changes to data storage characteristics without affecting program access.

What are the implications of data redundancy?

It can lead to poor data security, data inconsistency, and increased likelihood of data-entry errors.

What does the term 'islands of information' refer to?

Scattered data locations that lead to data redundancy and inconsistency.

What is the difference between structured and unstructured data?

Structured data is formatted for processing, while unstructured data exists in its original state.

What are manual file systems?

Systems that use physical filing methods like folders and filing cabinets.

What are computerized file systems?

Systems that use software, such as spreadsheet programs, to manage files.

What is structural independence?

The ability to change a file's structure without affecting access to the data.

What is an example of information derived from data?

The average temperature for each city over 5 years.

What is the Structured Query Language (SQL)?

The de facto query language used for accessing and managing data in a DBMS.

What is the role of a Database Management System (DBMS)?

To act as an intermediary between users and the database, enabling data sharing and managing data access.

What is the role of business intelligence in databases?

To capture and process business data to generate information that supports decision making.

What is data redundancy?

Unnecessarily storing the same data in multiple places, increasing the risk of inconsistency.

What are the types of data anomalies?

Update anomalies, insertion anomalies, and deletion anomalies.