Data Base System on Basic [ENG Version]

Data base system is a computerized storage log. Where saved data are persistent data or long term type data, so data base system usually used by large agency such as banks, universities, hospitals, government departments, etc.

Whereas data base in common defined is an electronic archive box to keep data. Data base can be able to use by single-user or multi-user depend on data base capacity provided. Like a manual storage box, data base also can do several operations, such as:

1. Retrieval operation
2. Insert operation, insert a new-empty folder or insert a new data into an existing folder.
3. Change operation
4. Delete operation
5. Move operation, from a data base to another data base

To do these operations above, data base user must use SQL language (Structured Query Language). SQL is a standard language to interact with a data base.

Main purpose using data base are to keep information and allowing user to retrieve, and or or change the data based on the request.

Advantages use data base:

1. Paperless, we don’t have to provide many papers to record all the data manually
2. Search and find data quickly
3. Easy to keep bunch of data for a long term
4. Actual and accurate information given

Data base include:

1. Data that keeps inside
2. Hardware, like: storage media and processor
3. Software, like: data base manager or data base server or we usually herd Data Base Management System (DBMS). DBMS is a system to control a data base. DBMS is the most important component in a data base system. A DBSM must have capability to:
   • Receive data definition
   • Understand many kind of data definition language (complete with DDL and DML processor, DDL and DML compiler)
   • Provide data dictionary that inform “data about a data” or called metadata/descriptor
   • Provide user interface
4. User, include:

• Application programmer, job desk: write program in C++, Java, or many more. Usually people call it a Data Base Administrator (DBA). DBA is a person or are several professional IT staffs that made a data base operated beautifully. Their jobs:
  • Define conceptual scheme from a data base (logic data base design) or with different words, define information to be recorded. Conceptual scheme is a manifestation from whole data base information content that written with DLL conceptual language.
  • Define internal scheme (physical data base design) or deciding how data previews look a like. Internal scheme is a manifestation of low level from a whole data base.
  • Make sure all the saved data is available.
  • Establishing policy of backup and restore in a data base
• End user
• Third party/Data Administrator (DA), is someone that have responsibility of the data (must understood the data clearly), include data security policy.

Kind of data base distributing process:

1. Server and client work on different machine
   
   

   

   
   
2. A server machine accommodating several clients across work communication network.
   
   

   

   
   
3. Every client has their own data base server that connected on work communication network.
   
   

   

   
   

Untuk versi Bahasa Indonesia, klik disini.

Source:

Date C.J, Pengenalan Sistem Basisdata Jilid 1, Jakarta. 

Author:

Nathasia Austin Wijaya (12.02.0052)

Fisrt Semester student on Soegijapranata Catholic University, Faculty of Computer Science, Game Technology Program, year 2012

For Computer Organization assignment.