logo image

Database Management Systems (DBMS)

Database
link info together for purpose and control in safe and secure way; represent some aspect of real world
DBMS
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
DDL
Data Definition Language; define database structure
DML
Data Manipulation Language; manage data w/in database; also known as query language
Schema
logical structure how info put together
Physical schema
database designed at the physical level
Logical schema
database designed at the logical level
Instance
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
schema
description of particular collection of data, using the given data model
relationship model of data
most widely used model today
SQL
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.
transaction
collection of operations performs single logical function in database application
utilities
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 .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
Signup & Access Essays

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