Advantages of Data Base Management System (DBMS)
Storing data in the form of a DBMS has many benefits and advantages compared to storing in a flat file or spreadsheet, including:
Performance that is obtained by storing in the form of a DBMS is quite large, very much different from the performance data stored in the form of flat files. Besides having a better performance, it will also get efficient use of storage media and memory
Data integrity is more guaranteed with the use of DBMS. Redundancy problems often occur in DBMS. Redundancy is the recurrence of data or the same data set in a database that results in wasteful storage media.
Independence. Changes in database structure are possible without having to change the application that accesses them so that making interfaces into the data will be easier with the use of DBMS.
Centralization. Centralized data would simplify database management. the ease of sharing with DBMS and the consistency of data accessed together will be more secure than data stored in scattered files or worksheets.
Security. DBMS has a security system that is more flexible than security on operating system files. Security in the DBMS will give flexibility in granting access rights to users.
Benefits of Data Base Management System (DBMS)
Data independence, the DBMS provides an approach that makes changes in the data not making the program must be changed.
Efficient access to data, DBMS provides a variety of sophisticated techniques so that data storage and retrieval is carried out efficiently.
Data security and integrity, because data is controlled by the DBMS, the DBMS can impose data integrity constraints. Anything that does not fit the definition of a field and the restraints attached to the field will be rejected. For example, if the Gender_Field field is declared as P or W, then saving L to that field will automatically be rejected by the DBMS.
Data administration, if a number of users share data, centralizing administration can improve significant improvements. In this way, data duplication or redundancy can be minimized.
Concurrent access and recovery against failure, the DBMS provides a mechanism so that the same data can be accessed by a number of people at the same time. In addition, the DBMS protects the user from the effects of system failure. If a system failure occurs, the DBMS can restore data as it was before the failure.
Shortest application development time, DBMS offers many facilities that make it easy to arrange applications so that application development time can be shortened.
Weakness of Data Base Management System (DBMS)
High & Expensive DBMS Costs & Prices The need to obtain the right software and hardware is quite expensive, including the maintenance costs and the human resources that manage the database.
Very complex. The database system is more complex than the file process, so that errors can be easily made and more difficult to maintain data.
Centralized data risk. Data that is centralized in one location can risk data loss during the application process.
Requires a large storage media
Requires large computer memory
Requires high / specific hardware specifications
Requires a long time for system conversion
Sometimes the performance of the DBMS is low performance
The risk of failure is quite high
DBMS Architecture and Components
Data Base Management System Architecture (DBMS)
This architecture is known as a three-schema architecture where this function is to separate the physical database from the user application program. These schemes are as follows:
Internal level is an internal scheme that contains a description of the database storage structure and uses a physical data model and defines in detail the data storage in the database, as well as the data access path.
The conceptual level is a scheme that contains a description of the overall database structure for all users. This scheme only contains descriptions of entities, attributes, relationships and constraints, without loading detailed data descriptions.
An external level is an external scheme (user view) that defines the data view of a group of users (local view) by hiding other data that is not needed by that user group.
Component Data Base Management System (DBMS)
Interface, which includes data manipulation language (data definition language) for external schemes, conceptual schemes and internal schemes.
Database control system (Database Control System) that accesses the database due to commands from the data manipulation language.
Hardware (Hardware) Hardware that is usually contained in a database system is the hard disk secondary memory.
Operating System (Operating System) Operating System (Operating System) is a program that activates or functions a computer system, controls all resources (resources) and perform operations in a computer. Operating systems that are widely used such as: MS-DOS, MS-Windows 95, MS Windows NT, and Unix.
Database (Database) A database (Database) can have multiple databases. Each database can contain or have a number of database objects such as files or tables.
User (User) For users can interact with databases and manipulate data in programs written in programming languages.
Database administrator is the person or group responsible for implementing the database system within an organization
End users are people who are in front of the workstation and interact directly with the system.
Application programmers, people who interact with databases in different ways.
Examples of languages using these components are SQL (Structured Query Language). SQL is the standard language used by most DBMS applications.