Essay On Database System

776 Words2 Pages

Legacy system: It means old technology used in systems or old computer softwares or applications.
Now the tern legacy database system means that all the historic overview of database systems that which type of models and navigational systems were there in a database systems. Before going to the historic overview it is important to know about the database system introduction in complete detail then we will move to its model details of them.
Databse: The term database generally refers to the organized collection of well defined data.
Database Management Systems (DBMSs): Database management systems (DBMSs) are user made softwares that interacts with the user and the database itself to capture and analyze all the data. Normally DBMS is a software system that is designed for creation, querying, update, and administration of databases. Some well known databases are MySQL, MariaDB, PostgreSQL, SQLite, Microsoft SQL Server, Oracle, FoxPro, FileMaker Pro. Database generally can’t interact with different datbase management systems but different database management systems like SQL and ODBC or JDBC can allow single database to interact with multiple database management systems. Databases are made to operate all type of informations by storing, retrieving and managing that informations. Databases are made so that user can interact with databases itself. DBMS is usually responsible for mainting all the data in a system and if that data lost then DBMS will restore the data itself. Databases are used for business operations but increasing number of database systems are usually made for more stable interaction with the users. Some users of database applications are end users means they don’t know about any of its in processing applications they ...

... middle of paper ...

... used to speak to information in information warehouses in a manner that information could be effectively abridged utilizing online expository handling, or OLAP questions. In the dimensional model, a database outline comprises of a solitary vast table of truths that are portrayed utilizing dimensions and measures. A dimension gives the setting of a certainty, (for example) when and where it happened, and its write) and is utilized within inquiries to assembly related realities together. Dimensions have a tendency to be discrete and are regularly hierarchical; for instance, the area may incorporate the building, state, and nation. A measure is an amount depicting the truth, for example, income. It is vital that measures might be definitively accumulated for instance, the income from diverse areas could be included.
Now we will discuss the main and important databases

Open Document