Thursday, December 16, 2010

INTRODUCTION TO DATABASE

Database:
The set of group data (files) that are interconnected, which was organized in such a way that can later be used again quickly.
Component Database Systems:
a. Hardware (Hardware)
Computer, memory, storage (hard drive), peripherals, etc..
b. Operating System (Operating System)
Programs that run the computer system, controls the computer resources and perform various basic operations of computer systems.
c. Data Base (Database)
Save various database objects (tables structure, indexes, etc.)
d. DBMS (Database Management System)
The software that maintains large amounts of data.
e. User (User)
The user database.
f. Applications (software) other.
Other programs in a DBMS.
Language Database
DBMS is an intermediary between user and database.
 communication mode is set in a specific language set by the DBMS.
Example: SQL, dBase, QUEL, etc..
Language database, divided into 2 forms:
- Data Definition Language (DDL)
Used in creating new tables, indexes, changing table, determine the structure of tables, etc..
- Data Manipulation Language (DML)
a.Digunakan in manipulating and loading data in the database.
b.Manipulasi data, may include:
- The invitation to the data stored in the database (query)
- Insertion / addition of new data to the database
- Elimination of data from the database
- Changing data in the database

No comments:

Post a Comment