preview

DBMS and IRS

Satisfactory Essays
Difference between DBMS and IRS by focusing on their functionalities.
A Database Management System (DBMS) is a software system that uses a standard way of classifying, retrieving, and running queries on data. The DBMS functions is to manage any incoming data, organize it, and provide ways for the data to be modified or extracted by users or other programs. Some examples of DBMS are PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle,Clipper and FoxPro. Since there are so many database management systems are available, so it is important to ensure that they communicate with each other. This is because, most database software comes with an Open Database Connectivity (ODBC) driver which allows the database to incorporate with other databases.

A DBMS perform several important functions that guarantee the integrity and consistency of the data in the database. Most of these functions are transparent to end users, and most can be achieved only through the use of a DBMS. They including the data dictionary management, data store management, security management and also backup and recovery management.

A data dictionary is a place where the DBMS stores definitions of the data elements and their metadata. All programs that access the data in the database will work through the DBMS. It uses the data dictionary to look up the required data component structures and relationships, thus the users do not have to code such complex relationships in each program. In addition, any changes made in database structure will be automatically recorded in the data dictionary, thereby freeing the users from having to modify all the programs that access the changed structure.

Besides, the DBMS also functioning to create and manage the complex stru...

... middle of paper ...

...nvenient data point can be called as structured data. Non-structured data is definitely more interesting and archiving data. Some other examples of structured data including database, data warehouses and also enterprise system such as CRM and ERP while the other examples of unstructured data is the excel spreadsheet and RSS feeds.
According to Robert Primer, the term structured data is generally applied to database while the unstructured data is applied to everything else. Mostly, the unstructured data is related to information that is not to be in column-row database and not to be stored in database. This type of data often including the text and multimedia such as email, video, audio file and photo. Nowadays, there are lots of company that use the unstructured data as it helps the company to manage their storage space including software and hardware efficiently.
Get Access