Databases Chapter 1

data

facts that are recorded and kept because they are considered to be of use

information

refers to the data that is accessed by a user for some particular purpose

metadata

data that describes the structure and the properties of the data

databse

structured collection of related data stored on a computer medium

database metadata

represents the structure of the database

database management system (DBMS)

software used

for:

• Creation of databases

• Insertion, storage, retrieval, update, and deletion of the data in the

database

• Maintenance of databases

database system

computer-based system whose

purpose is to enable an efficient interaction between the

users and the information captured in a database

front end applications

provide a mechanism for easy

interaction between the users and the DBMS

end users (business users)

users using a database

system to support their tasks and processes

direct interaction

end-user communicating with the

database directly through DBMS

indirect interaction

end-user communicating with the

database through front-end applications

relational database

most widely implemented today

• Data stored in tables

• Rows – 1 record representing an something containing 1 to many

values

• Column – values

noSQL

more recently introduced to support faster

processing and larger data stores

• Document

• Key-Value

• Columnar

• Graph

requirements, collection, definition, and visualization

esults in the requirements specifying which data the future

database system will hold and in what fashion, and what the

capabilities and functionalities of the database system will

be

• The collected requirements should be clearly defined and stated in

a written document, and then visualized

conceptual database model

a visualization of requirements by

using a conceptual data modeling technique (such as entity-

relationship [ER] modeling

database modeling (logical database modeling)

creation of the database model that is implementable in a

given DBMS software

• Logical database modeling follows conceptual database modeling

• When implementing in RDBMS – Relational Scheme

• When implementing in Document DBMS – JSON Schem

database implementation

using a DBMS to implement

the database model as an actual database

developing front end applications

designing and

creating applications for indirect use by the end-users

• Front-end applications are based on the database model and the

requirements specifying the front-end functionalities

• Front-end applications contain interfaces (such as forms and reports)

accessible via a navigation mechanism (such as a menu)

database deployment

releasing the database system for use by the end users

database use

the insertion, modification, deletion and

retrieval of the data in the database system

database administration and maintenance

performing

activities that support the database end user, including

dealing with technical issues, such as:

• Providing security for the information contained in the database

• Ensuring sufficient hard-drive space for the database content

• Implementing the backup and recovery procedures

operational information

he information collected and used in support of day-to-day

operational needs in businesses and other organizations

operational database

collects and presents operational

information in support of daily operational procedures and

processes

analytical information

the information collected and used

in support of analytical tasks

• Analytical information is based on operational (transactional)

information

analytical database

collects and presents analytical

information in support of analytical tasks