logo image

Database Management Systems (DBMS)

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

Need essay sample on "Database Management Systems (DBMS)"? We will write a custom essay sample specifically for you for only $ 13.90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
Complete Buyer Protection
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy

We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy