Architecture of database management systems

What is a database?

A database is a shared collection of logically related data and its description.

What is the purpose of a database?

To meet the information needs of an organization.

What is the purpose of integrating data from several sources in a company?

To standardise data formats for multiple applications.
Enables seamless data sharing across departments.

definition: database management system

a database management system is a software system that enables users to define, create, maintain and control access to the database

What is a database management system (DBMS)?

A general-purpose software used to manage electronically stored databases.

How does a DBMS interact with application programs?

It maintains data independently of application programs.

What is one benefit of using a DBMS for data management?

It minimizes data redundancy.

Can you give examples of DBMS software?

Examples include MS Access and MySQL.

How does a DBMS enable data sharing?

It allows re-use and sharing of the data by many users.

What assurances does a DBMS provide for data?

It ensures data consistency and integrity.

How does a DBMS handle user access?

It enables concurrent access for many users and provides data access control appropriate to individual users.

what does a database system consist of

database,DBMS ,computer hardware

why reduce redundancy

data redundancy can lead to inconsistencies

data consistency

same data across applications, same data even when replicated

integrity

up-to-date data,correct data

A simplified database system environment

roles and skills in a db environment

database administrator (dba)
database designer
app programmers
end users

database administrators

oversee and manage resources: vm, utilized hardware
authorization: for common usage
security policy: app dependant
performance, tuning: can change over time

database designers

identify data to be stored and structured to be used
identify constraints
design structural and functional aspects

application programmers

develop and implement end-user requirements

end users

may be sophisticated/naive, regular/casual.
varying degrees of access

stages in database development

problem analysis
database design
database implementation
database monitoring/tuning