What are facts that have not yet been processed to reveal their meaning?

A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database

1. Data Dictionary Management- Any changes made in a database structure are automatically recorded in the data dictionary, freeing you from having to modify all the programs that access the changed structure

2. Data Storage Management- DBMS creates and manages complex structures required for data storage, relieving you of defining and programming physical data characteristics.

3. Data Transformation and Presentation- DBMS transforms entered data to conform to required data structures. relieves you of distinguishing between logical and physical data formats.

4. Security Management- DBMS enforces user security and data privacy

5. Multiuser Access Control- DBMS uses sophisticated algorithms to ensure multiple users can access database concurrently without compromising Integrity

6. Backup and Recovery Management- DBMS provides backup and data recovery to ensure data safety and integrity

7. Data Integrity Management- DBMS promotes and enforces integrity rules, minimizing data redundancy and maximizing data consistency

8. Database Access Languages and Application Programming Interfaces- Provides data access through a query language: SQL

9. Database Communication Interfaces- DBMS accepts end-user requests via multiple, different network environments

Recommended textbook solutions

Fundamentals of Database Systems

7th EditionRamez Elmasri, Shamkant B. Navathe

687 solutions

Service Management: Operations, Strategy, and Information Technology

7th EditionJames Fitzsimmons, Mona Fitzsimmons

103 solutions

Service Management: Operations, Strategy, and Information Technology

7th EditionJames Fitzsimmons, Mona Fitzsimmons

103 solutions

Computer Organization and Design MIPS Edition: The Hardware/Software Interface

5th EditionDavid A. Patterson, John L. Hennessy

220 solutions

1-DATABASE SYSTEMS

data

Raw facts, or facts that have not yet been processed to reveal their meaning to the end user.

information

The result of processing raw data to reveal its meaning. Information consists of transformed data and facilitates

decision making.

knowledge

The body of information and facts about a specific subject. Knowledge implies familiarity, awareness, and

understanding of information as it applies to an environment. A key characteristic is that new knowledge can be

derived from old knowledge.

data management

A process that focuses on data collection, storage, and retrieval. Common data management functions include

addition, deletion, modification, and listing.

database

A shared, integrated computer structure that houses a collection of related data. A database contains two types of

data: end-user data (raw facts) and metadata.

metadata

Data about data; that is, data about data characteristics and relationships. See also data dictionary.

Database management system (DBMS)

The collection of

programs that manages the database structure and controls access to the data stored in the database.

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.

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 is 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.

What do you call a data that is not yet processed?

What is used to reveal the meaning of data?

Which term means processed facts?

What is data that has not been processed for use quizlet?