Database and Database Users Flashcards
A database is a collection of _________ data.
related
Implicit Properties of a database.
- Represent an aspect of the real world.
- Logically coherent collection of data with some inherent meaning.
- Designed, build, and populated with data for a specific purpose.
- Can be of any size and complexity.
- May be generated and maintained manually or computerized.
DMBS
Database Management System
A computerized system that enables users to create and maintain a database.
DBMS
General purpose of DMBS
To facilitate the process of DEFINING, CONSTRUCTING, MANIPULATING, and PROTECTING AND MAINTAINING DATABASES.
Specifying data types, structures, and constraints of data to be stored in the database.
Defining a database.
Process of storing the data on a storage medium which is controlled by the DMBS.
Constructing a database.
Fetching or querying the database to retrieve specific data updating database information to reflect change and generate reports.
Manipulating a database
System protection against hardware or software malfunction or crashes, and security protection against unauthorized and malicious access.
Protecting a database
Allowing the database system to evolve as requirements change over time.
Maintaining a database.
Review function diagram
-
Characteristics of the Database Approach
- Self describing nature
- Insulation between programs, data, and data abstraction.
- Support for multiple views of data.
- Sharing data and multi us transaction processing.
Complete definitions or description of the database structure and constraints.
Self describing nature.
Structure of data files is stored in the DBMS catalogs separately from the access programs.
Insulation between programs, data, and data abstraction.
Implementation of the operation is specified separately and can be changed without affecting the interface.
Insulation between programs, data, and data abstraction.
A multi user DBMS has a variety of distinct applications. Provides facilitate for multiple views.
Support for Multiple views of data.
A subset of data that may contain virtual data that is derived from the database but not explicitly stored.
View
Allows multiple users to access the database at the same time.
Sharing data and multiuser transaction processing.
Concurrency control to ensure that several users trying to update the same data are correct.
Sharing data and multiuser transaction processing.
Responsible for authorizing access to the database, coordinating, and monitoring the use and acquisition of software and hardware resource.
Database Administrators.
Accountable for problems such as security breaches and poor system response time.
Database Administrators.
Identifies the data to be stored in the database. Chooses the appropriate structures to represent and store data.
Database Designers.
People whose jobs require access to the database for querying, updating, and generating reports.
End users
Occasional access to the database. Uses a sophisticated database query interface to specify request and are typically middle or high level managers.
Casual End users.
