Database Management Systems (DBMS) – Flashcards
Unlock all answers in this set
Unlock answersquestion
link info together for purpose and control in safe and secure way; represent some aspect of real world
answer
Database
question
software package designed to store and manage databases
answer
DBMS
question
support storage of very large amounts of data over long period of time
answer
Persistent storage
question
gives users ability to query and modify the data
answer
Programming interface
question
controls access to data from many users at once (ACID property of transactions)
answer
Transaction management
question
how hardware set up, how record stored
answer
Physical layer
question
program/application interface
answer
Conceptual layer
question
occurs between physical and conceptual layer; provide key semantic and logical information around data
answer
Logical layer
question
defines logical structure
answer
Conceptual schema
question
describes files and indexes used
answer
Physical schema
question
Data Definition Language; define database structure
answer
DDL
question
Data Manipulation Language; manage data w/in database; also known as query language
answer
DML
question
logical structure how info put together
answer
Schema
question
database designed at the physical level
answer
Physical schema
question
database designed at the logical level
answer
Logical schema
question
actual content of database at particular point in time
answer
Instance
question
ability modify physical schema w/out change application programs
answer
Physical Data Independence
question
ability modify logical schema w/out change application programs
answer
Logical Data Independence
question
collection of concepts for describe info
answer
data model
question
description of particular collection of data, using the given data model
answer
schema
question
most widely used model today
answer
relationship model of data
question
common used database language, translate for database to use
answer
SQL
question
crash while undergoing transaction will not make changes
answer
Transaction concept
question
provide interface b/w low level data stored in database and the application programs and queries submitted to the system
answer
Storage Management
question
A method of dealing with a situation in which two or more people need to access the same record in a database at the same time.
answer
concurrency control
question
collection of operations performs single logical function in database application
answer
transaction
question
logical design and data dictionary tools, loading physical design and file organization, backup/recover
answer
utilities
question
client programs using ODBC/JDBC communicate w/ databse
answer
2-tier architecture
question
web based app. and app. build using "middleware"
answer
3-tier architecture
