In: Computer Science
What is a Data Dictionary?
What is a Database Engine?
What is a Query Processor/Analyzer?
What is a Forms Generator?
What is a Reports writer?
What is a DBMS?
What is the difference between DB and DBMS?
What is a Data Dictionary?
Data Dictionary:-
----------------
->The data dictionary is a set of database tables used to store
information about a database’s definition.
->A data dictionary contains a list of all files in the
database, the number of records in each file, and the names and
types of each field i.e It contains information about database
objects such as tables, indexes, columns, datatypes, and
views.
->Which Contains the Metadata i.e Data About the Data.
->Oracle Server uses the database dictionary to verify SQL
statements.that means used to validate Each And Every Column
refernces in Different Rables.
->Mostly DBMS keep the data dictionary hidden from users to
prevent them from accidentally destroying its contents.
What is a Database Engine?
DataBase Engine:-
-----------------
DataBase Engine is an API,that enables you to directly control the
engine without going through the DBMS's
->Which improves performance of processing Speed.
->If we want Connect to the Database,we cant connect directly to
the Database for that DataBase Engine will helpful to connect with
the database.
why because The Database have so many Connectivities,instead of
Giving Access for Every Client Will Supply DataBaseEngine to
Control.
What is a Query Processor/Analyzer?
Query Processor/Analyzer:-
----------------------------
Query Processing is a procedure of transforming a high-level query
(such as SQL) into a correct and efficient execution plan expressed
in low-level language.
->A query processing select a most appropriate plan that is used
in responding to a database request.
What is a Forms Generator?
Forms Generator:-
--------------------
Forms Generator is a library for Node.js that helps with HTML
forms.
->Which is Predefined library that is used to create Creative
Forms.
What is a Reports writer?
Reports Writer:-
---------------
Reports Writer is used to extracts information from one or more
files and presents the information in a specified format.
->Which allows us to select records that meet certain conditions
and to display selected fields in rows and columns.
What is a DBMS?
DBMS(DataBase Management system):-
----------------------------------
DBMS Stands for Database Management System provides a platform to
store and Keep the Track of Data in Secure Manner and Accessing the
data by Efficiently.
->DBMS is Software To create a Database and Accessing the
Database.Which applications store data as file.
->which is a collection of programs that facilitates users to
create and maintain a database.
->DBMS has to provide some uniform methods to access the stored
information.
->Which Uses the Tables To Store the data.
->It overcomes the drawbacks of Traditional file Processing
system,In that Scenario of Storing data,Accessing the data,Fetching
the Data,Modifying the Data,
View the Data is easily by applyig simple Query.Which introduces
SQL Language to perform all these kind of operations.
What is the difference between DB and DBMS?
difference between DataBase and DBMS:-
---------------------------------------
Where DB Stands for Database,which is an organized collection of
data.We can create Database to Store Well defined Objects.
for that we need one specific platform to Access the Data.i.e
Called DBMS(DataBase Management System).
Database handlers create database in such a way that only one set
of software program provide access of data to all the users.
Where as DBMS Stands for Database Management System
which is a collection of programs that facilitates users to create
and maintain a database.