OneStopGate.Com
OnestopGate   OnestopGate

  JOIN GATE GROUP, Looking for GATE Preparation Materials? Join & Get GATE Preparation Materials now!, JOIN GATE GROUP
OnestopGate
Home | Overview | Syllabus | Tutorials | FAQs | Downloads | Advertise | Contact Us | Forum
OneStopGate

GATE Overview
  arrow to indicate  Overview
  arrow to indicate  GATE Eligibility
  arrow to indicate  Structure Of GATE
  arrow to indicate  GATE Coaching       Centers
  arrow to indicate  Colleges Providing M.Tech/M.E.
  arrow to indicate  GATE Score
  arrow to indicate  GATE Results
  arrow to indicate  PG with Scholarships
  arrow to indicate  Article On GATE
  arrow to indicate  GATE Forum

GATE 2009 Exclusive
  arrow to indicate  GATE 2009 Syllabus
  arrow to indicate  GATE Organizing Institute
  arrow to indicate  Important Dates
  arrow to indicate  How to Apply
  arrow to indicate  Discipline Codes

GATE Syllabus
  arrow to indicate  Aerospace Engg..
  arrow to indicate  Agricultural Engg..
  arrow to indicate  Architecture and Planning
  arrow to indicate  Chemical Engg..
  arrow to indicate  Chemistry
  arrow to indicate  Civil Engg..
  arrow to indicate  Computer Science / IT
  arrow to indicate  Electronics & Communication Engg..
  arrow to indicate  Electrical Engg..
  arrow to indicate  Engineering Sciences
  arrow to indicate  Geology and Geophysics
  arrow to indicate  Instrumentation Engineering
  arrow to indicate  Life Sciences
  arrow to indicate  Mathematics
  arrow to indicate  Mechanical Engg..
  arrow to indicate  Metallurgical Engg..
  arrow to indicate  Mining Engg..
  arrow to indicate  Physics
  arrow to indicate  Production & Industrial Engg..
  arrow to indicate  Pharmaceutical Sciences
  arrow to indicate  Textile Engineering and Fibre Science

GATE Study Material
  arrow to indicate  Aerospace Engg..
  arrow to indicate  Agricultural Engg..
  arrow to indicate  Chemical Engg..
  arrow to indicate  Chemistry
  arrow to indicate  Civil Engg..
  arrow to indicate  Computer Science /       IT
  arrow to indicate  Electronics &       Communication Engg..
  arrow to indicate  Electrical Engg..
  arrow to indicate  Engineering Sciences
  arrow to indicate  Instrumentation       Engg..
  arrow to indicate  Life Sciences
  arrow to indicate  Mathematics
  arrow to indicate  Mechanical Engg..
  arrow to indicate  Physics
  arrow to indicate  Pharmaceutical       Sciences
  arrow to indicate  Textile Engineering        and Fibre Science

GATE Preparation
  arrow to indicate  GATE Pattern
  arrow to indicate  GATE Tips N Tricks
  arrow to indicate  Compare Evaluation
  arrow to indicate  Sample Papers
  arrow to indicate  GATE Downloads
  arrow to indicate  Experts View

CEED 2009
  arrow to indicate  CEED Exams
  arrow to indicate  Eligibility
  arrow to indicate  Application Forms
  arrow to indicate  Important Dates
  arrow to indicate  Contact Address
  arrow to indicate  Examination Centres
  arrow to indicate  CEED Sample Papers

Discuss GATE
  arrow to indicate  GATE Forum
  arrow to indicate  Exam Cities
  arrow to indicate  Contact Details
  arrow to indicate  Bank Details

Miscellaneous
  arrow to indicate  GATE FAQs
  arrow to indicate  Advertisment
  arrow to indicate  Contact Us

Home » Gate Study Material » Computer Science & IT » Data Base Management System » Study Material

Database

Looking for GATE Preparation Material? Join & Get here now!
Discussion Center

Discuss/
Query

Papers/
Syllabus

Feedback/
Suggestion

Yahoo
Groups

Sirfdosti
Groups

Contact
Us
  Print
<<Previous Next>>
Database System Concept

The term database originated within the computing discipline. Although its meaning has been broadened by popular use, even to include non-electronic databases, this article is about computer databases.

A computer database is astructured collection of records or data that is stored in a computer system so that a computer program or person using a query language can consult it to answer queries href="http://en.wikipedia.org/wiki/Database#_note-0">[1]. The records retrieved in answer to queries are information that can be used to make decisions.

The computer program used to manage and query a database is known as a database management system (DBMS). The properties and design of database systems are included in the study of information science.

A typical query could be a question such as, How many hamburgers with two or more beef patties were sold in the month of March in New Jersey?". To answer such a question, the database would have to store information about hamburgers sold, including number of patties, sales date, and the region.

The central concept of a database is that of a collection of records, or pieces of information. Typically, for a given database, there is a structural description of the type of facts held in that database: this description is known as a schema. The schema describes the objects that are represented in the database, and the relationships among them. There are a number of different ways of organizing a schema, that is, of modeling the database structure: these are known as database models(or data models). The model in most common use today is the relational model, which in layman's terms represents all information in the form of multiple related tables each consisting of rows and columns (the formal definition uses mathematical terminology). This model represents relationships by the use of values common to more than one table. Other models such as the hierarchical model and the network model use a more explicit representation of relationships.

The term database refers to the collection of related records, and the software should be referred to as the database management system or DBMS. When the context is ambiguous, however, many database administrators and programmers use the term database to cover both meanings.

Many professionals consider a collection of data to constitute a database only if it has certain properties: for example, if the data is managed to ensure its integrity and quality, if it allows shared access by a community of users, if it has a schema, or if it supports a query language. However, there is no definition of these properties that is universally agreed upon.

Database management systems are usually categorized according to the data model that they support: relational, object-relational, network, and so on. The data model will tend to determine the query languages that are available to access the database. A great deal of the internal engineering of a DBMS, however, is independent of the data model, and is concerned with managing factors such as performance, concurrency, integrity, and recovery from hardware failures. In these areas there are large differences between products.

<<Previous Next>>

MEMBERS LOGIN
  
EmailId:
Password:

  Forgot Password?
 New User? Register!
A D V E R T I S E M E N T
INTERVIEW EBOOK
Get 9,000+ Interview Questions & Answers in an eBook. Interview Question & Answer Guide
  • 9,000+ Interview Questions
  • All Questions Answered
  • 5 FREE Bonuses
  • Free Upgrades
START YOUR WEBSITE
India's Best Web Hosting Company
GATE RESOURCES
 
  • Gate Books
  • Training Institutes
  • Gate FAQs
  • GATE Exam, Gate 2009, Gate Papers, Gate Preparation & Related Pages


    GATE Overview | GATE Eligibility | Structure Of GATE | GATE Training Institutes | Colleges Providing M.Tech/M.E. | GATE Score | GATE Results | PG with Scholarships | Article On GATE | GATE Forum | GATE 2009 Exclusive | GATE 2009 Syllabus | GATE Organizing Institute | Important Dates for GATE Exam | How to Apply for GATE | Discipline / Branch Codes | GATE Syllabus for Aerospace Engineering | GATE Syllabus for Agricultural Engineering | GATE Syllabus for Architecture and Planning | GATE Syllabus for Chemical Engineering | GATE Syllabus for Chemistry | GATE Syllabus for Civil Engineering | GATE Syllabus for Computer Science / IT | GATE Syllabus for Electronics and Communication Engineering | GATE Syllabus for Engineering Sciences | GATE Syllabus for Geology and Geophysics | GATE Syllabus for Instrumentation Engineering | GATE Syllabus for Life Sciences | GATE Syllabus for Mathematics | GATE Syllabus for Mechanical Engineering | GATE Syllabus for Metallurgical Engineering | GATE Syllabus for Mining Engineering | GATE Syllabus for Physics | GATE Syllabus for Production and Industrial Engineering | GATE Syllabus for Pharmaceutical Sciences | GATE Syllabus for Textile Engineering and Fibre Science | GATE Preparation | GATE Pattern | GATE Tips & Tricks | GATE Compare Evaluation | GATE Sample Papers | GATE Downloads | Experts View on GATE | CEED 2009 | CEED 2009 Exam | Eligibility for CEED Exam | Application forms of CEED Exam | Important Dates of CEED Exam | Contact Address for CEED Exam | CEED Examination Centres | CEED Sample Papers | Discuss GATE | GATE Forum of OneStopGATE.com | GATE Exam Cities | Contact Details for GATE | Bank Details for GATE | GATE Miscellaneous Info | GATE FAQs | Advertisement on GATE | Contact Us on OneStopGATE |
    Copyright © 2009. One Stop Gate.com. All rights reserved Privacy Policies | About Us
    Our Portals : Academic Tutorials | Best eBooksworld | Beyond Stats | City Details | Interview Questions | Discussions World | Excellent Mobiles | Free Bangalore | Give Me The Code | Gog Logo | Indian Free Ads | Jobs Assist | New Interview Questions | One Stop FAQs | One Stop GATE | One Stop GRE | One Stop IAS | One Stop MBA | One Stop SAP | One Stop Testing | Quick2Host | Quick2Host Mirror | Quick Site Kit | Sirf Dosti | Source Codes World | Tasty Food | Tech Archive | Testing Interview Questions | Tests World | The Galz | Top Masala | Vyom | Vyom eBooks | Vyom International | Vyom Links | Vyoms | Vyom World
    C Interview Questions | C++ Interview Questions | Send Free SMS | Placement Papers | SMS Jokes