Saturday, 3 October 2020

Advanced database systems


Advanced database systems, database management systems, perform the tasks expected of creating an archive very quickly and with high accuracy and even add to the features that an archiver would not have dreamed of if he worked in the traditional way.


Advanced database systems, Database Management System (Database Management System), which is always abbreviated as DBMS, is a system, and by this, I mean that I convey the idea that database management systems are ordinary systems, but we change its name to DBMS when you perform certain tasks, you can create a database management system according to your concept after developing your model.


The main tasks of this system that you can develop are:


  • Clarify the relationships between archived data. If a master file has subfiles, these relationships are stored and managed.
  • Managing data storage methods, as the system user does not know how the data is stored and with what structure, but the system is concerned with this matter.
  • The possibility of storing and retrieving data and this means transferring the data from its natural structure to its storage structure and then retrieving it as it was before without change.
  • One of the most important tasks that represented suffering for every archivist is to provide protection for this data, and it is also one of the most important tasks that the database management system must provide.
  • Managing multiple access to databases without affecting the integrity of the data, and this is one of the beautiful characteristics of databases. The traditional archive does not allow multiple access, and allowing multiple access while preserving the integrity of the data is a very great task that needs an intelligent policy to manage it.
  • The ability to backup and restore previous data according to the previous backup. This feature allows database management systems to reduce losses in cases where losses occur.
  • After providing all these characteristics, does not require providing a way to retrieve this stored data, the database management system must provide a standard language for retrieving the data intact without changing, losing, or retrieving unwanted data, such as SQL.
  • That this system provides an interface for different systems to communicate with databases. When you store a large number of data, you may need to use it today with a developed system in Java and tomorrow with a developed system in C ++ language.


Who is the inventor of database management systems

The idea of ​​database management systems began in the second half of the previous century, in the sixties of the last century, when IBM, a pioneer in several fields, especially information systems, took care of issuing the first database management system called IMS. This system relies on a very simple idea, which is tree Bilateral.


Examples of database management systems

The IMS database management system was based on an ancient principle that any novice in the programming world can design today, but with the development of technology and the continuous development there are today dozens of internationally known database management systems, I mention, for example:


  • Microsoft SQL Server.
  • Microsoft SQL Server Express.
  • Mysql.
  • SQLite.
  • SQL Anywhere.
  • Amazon Aurora.

No comments:

Post a comment


Contact Us


Email *

Message *