Database Environment Flashcards
It is a software system that is used to create, maintain, and provide controlled access to user database
Data Management System
Name the 6 functions of the DBMS
- Maintains the database
- Ensures what we store are persistently stored in the database
- Data manipulation
- Sharing of data to different users
- Enforces rules to avoid data duplication and inconsistency
- Security for data
Name the 3 cons of using DBSM
- Expensive
- Requires frequent update and maintenance
- Requires a database administrator (DBA) to maintain DB
What is a Database Environment
shows the components that affect data management and the database itself
What are the components of a Database Environment?
- Hardware
- Software
- Data
- People
- Procedure
This database component involves the use of physical devices in data management
Hardware
This database component uses an operating system in which the DBMS and database will be working with
Software
This database component describes the clients and technical users of the database system
People
Give 2 meanings of procedure
- Set of task, functions, processes of clients that will affect data management
- Set of task, functions, processes of technical users to ensure that the database system is what the client needs
Who are the people in the Database Environment?
- Non technical users
- Technical users
Who are the non technical users?
Clients or end users
Who are the technical users?
- Database administrator
- System administrator
- Database architect/designer
- System analyst
- Application developer
Define the categories that the technical users are divided in:
- Development
- Deployment
Who belongs to the development team?
- System analyst
- Database architects/designers
- Application developer
Who belongs to the deployment team?
- Database administrator
- System administrator
This person identifies the requirements that will be the basis of a database system
System Analyst
This person designs the database
Database architect/ designers
This person programs the application to its intended use and functionality
Application Developer
This person manages the DBSM and the database
Database Administrator
This person manages the database system and other infrastructure where the database system is deployed on
System Administrator
This person uses SQL DDL SELECT to generate reports
Database Operator
This person uses SQL DDL to enable applications to interact with database
This person alsu uses advanced structures in DB to enhance data management capabilities, make queries run
faster, and implement rules followed by the DB
Database Developer
This person uses advanced structures and methods in DB
to implement ETL to populate Analytics DB
Data engineer
What are the 3 levels of the Three Schema Architecture
- External View
- Conceptual View
- Internal View
What is the goal of the Three Schema Architecture?
To separate the user applications and the physical database
This level describes the physical storage structure of the database
Internal
This level hides the details of the physical storage structure and concentrates on describing entities, data types, etc
Conceptual
This level describes the part of the database that the user is interested in and hides the rest of the database from the group
External
What are the top database server products in the market
- Oracle DB
- MySql DB
- IBM DB/2
When we interact with the database, do we see the physical representation of the data storage? If yes or no, why?
No because we only see the logical representation of storage. Such as for relational databases, we only see tables
Do all the components of the database system need to be in one computer machine?
No the database server can be on a different machine
Are there other logical representations of data storage? Give examples
Yes
Tables are found in relational databases
Objects are found in Object Database
Trees are found in Network Database
Documents are found in Document Databases
