Saturday, 2 April 2011

Data Base Management

  

    
Data:
        Fact,raw or isolated facts from which the required information is processed.


Data Warehouse:
      Collection of data organised to support management.

Information:


        Processed,Organised  and Summarized data defined collection of related data which communicate meaningful and useful message.


Database System:


           Data Base system is collection of inter related data and set of program that allow uses to access an modify these data.




Data Mining:
          Data Mining is used to "extracting the knowledge" from the database.



Distributed Database:
        Distributed database system consists of multiple and independent databases that operate on two or more computers that are connected and share data over a network.



Database Manager:
       Data Base  Manager is a program module which provides the interface between the low-level data stored in the database .


Database Administrator:
      The person who has central control over the system is called as database Administrator.


Keys: 
       Keys allows us to indentify a set of attribute and thus distinguishes entities from each other.
     
Structured Query Language:
      SQL is non-procedural language.It is used to communicate with relational database management systems.


SQL Commands:


     DDL-Data Definition Language is used to creating the table,add the new fields,modify the data type or increasing the value size ,create new table from existing table and delete the table.
        create table ,
        alter table......add,
        alter table ...modify,
        create table  ...as select,
        drop table,
        Truncate,
        Rename.

    DML -Data Manipulation Language is used to insert new rows,update the existing rows and remove unwanted rows.
       Insert,
       Delete
       Update.


   DQL- Data Query Language is used to retrieve data from the database.
       Select- select the database


  DCL-Data Control Language   gives and removes rights to database objects.
       Grant
       Revoke


 These are basic commands set used in database management.

1 comment: