Intro to Database Pt.1 Flashcards
Limitation of File-Based Approach
Users of one program may be unaware of potentially useful data held by other programs.
Separation and Isolation of Data
Limitation of File-Based Approach
Same data is held by different programs.
Duplication of Data
Limitation of File-Based Approach
File structure is defined in the program code.
Data Dependence
Limitation of File-Based Approach
Programs are written in different languages and so cannot easily access each others files.
Incompatible file formats
Limitation of File-Based Approach
Any new requirement needs a new program.
Fixed Queries
Definition of data was embedded in application programs, rather than being stored separately and independently.
DATABASE APPROACH
It is unordered and meaningless fact/s. It does not convey any message.
Data
It is ordered and meaningful facts.
Information
Shared collection of logically related data and a description of this data, designed to meet the information needs of an organization.
Database
Logically related data comprises entities, attributes and relationships of an organizations information.
Database
The information that describes and explains data.
Metadata
The data stored in a structured way
Data Dictionary or System Catalog
A software system that enables users to define, create, maintain and control access to the database.
Database Management System (DBMS)
TYPES OF DBMS
a type of database that supports only user at the time
Single-user database
TYPES OF DBMS
a single user that runs on a personal computer.
Desktop database
TYPES OF DBMS
a type of database that supports multiple users at the same time.
Multiuser database
TYPES OF DBMS
a type of database that supports a relatively small number of users or a specific department within the organization.
Workgroup database
TYPES OF DBMS
a type of database that is used by the entire organization and
support many users across many departments.
Enterprise database
TYPES OF DBMS
a type of database that supports data located at a single site.
Centralized database
TYPES OF DBMS
a type of database that supports data distributed across several different sites.
Distributed database
TYPES OF DBMS
a database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS.
Cloud database
TYPES OF DBMS
a database that contains a wide variety of data used in multiple discipline.
General-purpose database
DATABASE APPROACH Responsibilities
providing a way to define and build the database.
Data Definition
DATABASE APPROACH Responsibilities
providing a way to insert and update data in the database.
Data Manipulation.
DATABASE APPROACH Responsibilities
retrieving information from the data in the database
Query Execution
DATABASE APPROACH Responsibilities
ensuring that data stored is well-formed
Data Integrity
DATABASE APPROACH Responsibilities
enforcing restrictions about who is able to access what data
Data Security
DATABASE APPROACH Responsibilities
logging capabilities to provide an audit trail for data changes
Provenance
DATABASE APPROACH Responsibilities
supporting the activities of many users at the same
Multiuser Concurrency
