Select a forum to post in:

Database Management System

Helpful topics on HTML, C++

Moderators: Jessica, Teachers

Database Management System

Post Number: #1  Postby Jessica » July 30th, 2014, 9:20 pm



Database Management System or DBMS in short, refers to the technology of storing and retriving users data with utmost efficiency along with safety and security features. DBMS allows its users to create their own databases which are relevant with the nature of work they want. These databases are highly configurable and offers bunch of options.


Database is collection of data which is related by some aspect. Data is collection of facts and figures which can be processed to produce information. Name of a student, age, class and her subjects can be counted as data for recording purposes.

Mostly data represents recordable facts. Data aids in producing information which is based on facts. For example, if we have data about marks obtained by all students, we can then conclude about toppers and average marks etc.

A database management system stores data, in such a way which is easier to retrieve, manipulate and helps to produce information.

Overview



Architecture
Image

Database (Data) Tier: At this tier, only database resides. Database along with its query processing languages sits in layer-3 of 3-tier architecture. It also contains all relations and their constraints.

Application (Middle) Tier: At this tier the application server and program, which access database, resides. For a user this application tier works as abstracted view of database. Users are unaware of any existence of database beyond application. For database-tier, application tier is the user of it. Database tier is not aware of any other user beyond application tier. This tier works as mediator between the two.

User (Presentation) Tier: An end user sits on this tier. From a users aspect this tier is everything. He/she doesn't know about any existence or form of database beyond this layer. At this layer multiple views of database can be provided by the application. All views are generated by applications, which resides in application tier.
  • 0

Tales of Ostlea : ImageImageImageImageImageImageImage
Dragon Cave : Image
Magistream : ImageImageImageImageImageImageImageImageImage
Leetle Adoptables : Image
Internetometer : Image
User avatar
Jessica
Board Owner
Topic Author

Founder
Sapphire
Sapphire
 
6 years of membership6 years of membership6 years of membership6 years of membership6 years of membership6 years of membership
 
Posts: 3,431
Topics: 1,244
Articles: 30
Joined: December 22nd, 2010, 8:04 pm
Local time: September 19th, 2017, 6:15 pm
Last Visit: Today, 5:08 pm
Location: Pennsylvania
Gender: Female
Cash on hand: 4,377.69
Bank: 119,769.08
Reputation: 148
Medals: 18
#1: July 2012 1st Place (1) R-Contest #1 First Place (1) Best staff member 2013 (1) Easter Egg Hunt 2013 (1) Graphic Drawing Participant (1) 1 Year (1) 2 Years (1) 3 Years (1) 4 Years (1) 5 Years (1)
6 Years (1) Founder (1) Highest Rep (1) Referrer (1) Top poster (1) Facebook group (1) Pin-Board (1) Article Author (1)
Referrals: 27
Blog: View Blog (447)
Subject(s): Chinese, Math
Global Moderator
Admin
Moderator

Return to ICT Topics

Login  •  Register
cron
Reputation System ©'