Tuesday, May 7, 2013

A database is an organized collection of data. The data is typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies).
Wherever there is a system management of the same is required.This requirement gave rise to database management system.
A collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are examples of database applications:
  • computerized library systems
    • automated teller machines
  • flight reservation systems
    • computerized parts inventory systems
    From a technical standpoint, DBMSs can differ widely. The terms relational, network, flat, and hierarchical all refer to the way a DBMS organizes information internally. The internal organization can affect how quickly and flexibly you can extract information.
    Requests for information from a database are made in the form of a query, which is a stylized question. For example, the query
    select * from employee where emp_name ='&emp';
     this will return from the employee table the row which has emp_name as the one entered during run time.
    The set of rules for constructing queries is known as a query language. Different DBMSs support different query languages, although there is a semi-standardized query language called SQL (structured query language). Sophisticated languages for managing database systems are called fourth-generation languages, or 4GLs for short.
    The information from a database can be presented in a variety of formats. Most DBMSs include a report writer program that enables you to output data in the form of a report. Many DBMSs also include a graphics component that enables you to output information in the form of graphs and charts.
     

    No comments:

    Post a Comment