DB - Les01

Known facts that can be recorded and that have implicit meaning

• Data

• Data model

• Information

• Virtual data

Data of the same type.

• Data records

• Data model

• Database

• Logical data

Specifying the data types, structures, and constraints of the data to be stored in the database

• Logical design

• Transaction

• Definition

• Data model

The characteristic that allows program - data independence and program - application independence

• Canned transactions

• Physical design

• Transaction

• Data abstraction

Users who maintain personal databases by using ready-made program packages that provide easy to use menu-based or graphics based interfaces.

• Sophisticated End users

• DBMS system designers and implementors

• Parametric users

• Administrators

A collection of related data.

• Big data

• NoSQL

• Transaction

• Database

When the multiuser DBMS allows multiple users to access the database at the same time.

• 
  Parallel exection

• Shared data

• Concurrency control

• Transaction system

Changes to the data do not require changing all programs that access it.

• Canned transaction

• Program-data Independence

• Client protection

• Concurrency

The database definition or descriptive information stored in the DBMS in the form of a database catalog or dictionary.

• Data model

• Data abstraction

• Big data

• Meta-data

A different perspective of the database.

• Query

• Data model

• View

• Meta-data