Skip to main content

Posts

Showing posts with the label DBMS

Write a PL SQL code for reverse digits of given number at run time

To Write a PL SQL code for reverse digits of given number at run time you can use below code.

What is DBMS? what are the benefits of DBMS ?

DBMS stands for Database management system. DBMS consists of a collection of interrelated data and set of in build standard programs to access those data. Goal of DBMS is to provide environment that is convenient and efficient to use in retrieving and storing data. Some  benefits of DBMS are Reduced data redundancy and inconsistency. Data can be shared in DBMS. Standards of DBMS can be enforced. Security restriction can be applied. Integrity of data can be maintained. Data independence  or Abstraction could be achieved.

DBMS features and capabilities and DBMS building blocks

DBMS building blocks A DBMS includes four main parts: modeling language, data structure, database query language, and transaction mechanisms: 1)Modeling language A data modeling language to define the schema of each database hosted in the DBMS, according to the DBMS database model. The four most common types of models are the: * hierarchical model, * network model, * relational model, and * object model. 2)Data structure Data structures (fields, records, files and objects) optimized to deal with very large amounts of data stored on a permanent data storage device (which implies relatively slow access compared to volatile main memory) 3) Database query language A database query language and report writer allows users to interactively interrogate the database, analyze its data and update it according to the users privileges on data. It also controls the security of the database. Data security prevents unauthorized users from viewing or updating the database. Using pass...