The Fundamentals of databases Revealed: Any collection of related data is known as database or it is a logically, persistent collection of meaningful data relevant to some aspects of the real world. DBMS (Database management system) is a collection of programs which allows users to maintain or create a database. It is a bunch of data that gathers figures and facts and produce correct information. DBMS stores data that becomes very easier to manipulate, retrieve and produce information.
What is does do: DBMS provides several and simple file management functions which allow users, to control security, control redundancy, allow concurrency, allow data independence, maintain data integrity, provide for recovery and backup, perform automatic query optimization and provide non procedural language.
DBMS interacts: There are many different kinds of people are associated with database management system over its life such as, users, system analysts, application developers, database designers and administrators.
Database system components: DBMS has many components which are known as, DDL compiler, Application programs, direct user queries, database administrator, DML processor, database manager, file manage, concurrent access tables, description tables, authorization tables, metadata database, physical system database, system catalogue.
Characteristics: As we know that, in old days the data was maintained or organized in file formats but later on the concept has changed by the DBMS system and it has replaced the old traditional method.
Real world entity: DBSM uses real world entities and realistic design and at the same time it used attributes and behavior too. For instance, in schools data base student age is considered as an attribute and students as an entity.
Relation based tables: DBMS allows relations and entities among from the tables in which users can easily understand the database architecture just by looking at the name at the table.
Less redundancy: Rules of normalization are followed by the DBMS which splits an attributes and relation when having redundancy in value. Normalization is a scientific and mathematically rich process that reduces data redundancy.
Consistency: Consistency is the area when each and every relation remains consistent although there are techniques and methods that can attempt and detect of leaving database inconsistency. As compared to earlier forms of data storing application like processing system A DBMS can provide greater consistency.
Concurrent access and multi user: DBSM system allows multi users and supports different environment and also allow users to manipulate and access data parallel. When users attempt the same data items, some restriction on these kinds of transactions but most of the users is always unaware of them.