Tutorials

Introduction Three Schema Architecture DBMS Languages DBMS Interfaces Data Model E-R Data Model Relational Model Bigening of DBMS Coding Joins of Tables
Next Page->>


Introduction to DBMS

  • Full form of DBMS - Data-Base Managment System.

  • To Overcome the Drawbacks of File Management system our Technology Invented this DBMS.

  • By DBMS we can talk to the Physical Database.

  • DBMS is actually a software that is used to Create and Manipulate the Database.

    • Drawbacks of File Management

  • Redundancy Occurs in file.

  • Volatile in Nature.

  • For vast data it is not Feasible.

  • Not Secure.

  • Data Dependency Occurts.

  • Changes in data require Changes in Coding.

    • Drawbacks of Oracle

  • Application is very small DBMS is not required.

  • Maintainance cost is very high.

  • Training is needed.

    • Applicartion of DBMS

  • Program Data Independence.

  • Authorized Implementation or Accesses.

  • High Level Security.

  • Controlling Redundancy.

  • Persistance storage for objects.

  • We can implement Index.

    • Characteristics of DBMS

  • The 1st Characteristic is Program Data Independence.

  • Table of content or Structure of data is known as data Dictionary as well as Meta-Data.

  • Persistance Storage for Object, Objects were be there as long as data base exist.

  • Sharable and Multi User Transaction Processing.

  • Multiple Views.

    •  


    Note:  Some Examples or Data is taken from Various Resourses.When you find any Difficulties/problem then contact us We are trying our best for easy learning.