DATABASE: Definition, Components and Database Systems (Database)
Sunday, 11 August 2019
Understanding Database - Database consists of base words and data. Base can be interpreted as a headquarters or warehouse. While data is a record of a collection of real-world facts that represent objects such as humans, goods, animals, concepts, events and so on which are manifested in the form of letters, numbers, symbols, images, texts, sounds or their combinations.
As an entity, the understanding of database or commonly called database is as follows:
As an entity, the understanding of database or commonly called database is as follows:
Understanding Database
- The set of data groups that are interconnected and organized in such a way that they can later be reused quickly and easily.
- Data collection in the form of files / tables / archives that are interconnected and stored in electronic storage media, for ease in organizing, sorting, grouping and organizing data as intended.
With a database a person can store a piece of information, such as student data, staffing or products, into electronic storage media such as magnetic discs (disks) through a computer device, for then we can use these data as needed.
The database has 8 basic operations including Create database, Drop database, create table, Drop table, Insert, Read, Update and Delete.
Understanding Database Systems
In short, the system is a collection of components that are interconnected and put together to achieve a certain goal.
The database is an object that cannot move on its own, it needs a program / application as the activator or manager. So that the combination of both (database and application) can produce a system.
Understanding Database Systems
A database system is a system consisting of a collection of interconnected data tables and a collection of programs that allow several users or other programs to access and manipulate these data tables.
Database System Components
1. Hardware
Hardware or hardware that is generally contained in a database system is a computer, hard disk, offline secondary memory (removable disk, fd), network communication devices.
2. Operating System
An operating system is a program that is designed to activate a computer system and control all of its resources including basic computer operations. like Windows, Unix and Linux.
3. Database
A component is a collection of data that is well organized so that the data is easily stored, accessed, and can also be manipulated. Database systems can consist of several databases that have their respective data.
4. Database Management System or DBMS
DBMS or database management system is a special application program that is designed to create and also manage available databases. This system contains a collection of data and sets of programs used to access the database.
DBMS is software that plays a role in managing, storing, and retrieving data again. The mechanism used as a complement is data security, data consistency and shared data users.
Examples of DBMS are Microsoft Access, MySql, Oracle Database, Sybase, Borland-Interbasi, PostgreSQL etc.
5. User
The user is a database component that interacts directly with the database. There are several types of users, including application programmers, advanced users (casual users), general users (end users) and special users (specialized users)
6. Other Applications or Devices
This application depends on needs, database users can be made a special program for filling, changing or retrieving data that is easy to use. There are programs that are available directly in the DBMS or created using other applications such as Visual Basic.
Database Language
Database language is a data language that can be embedded into other programming languages, call it Java, Pascal, Fortran and so on. The language in which the data base is attached is called a host. Some components of the data base language according to function are divided into three, namely:
1. Data Definition Language
Data definition language is a set of definitions stored in a data dictionary.
2. Data Manipulation Language
Data Manipulation Language contains the accumulation of database manipulation operations performed. This is commonly called the query language because it is usually used to request information from the database.
Database Functions and Purposes
Database functions quite a lot and its scope is broad in supporting the existence of institutions or organizations, including:
Availability
The first database function is to provide important data when needed. Yes, this is an important function of a database that even though it is not located in one location, and is stored on disk, but with a systematic storage method, the information is easy to obtain.
Easy and Fast / Speed
Furthermore, the function of this database is so that you as a user can easily access it when you need it. No need to wait later, let alone have to allocate a certain time to call him.
Completeness / Completeness
The database must store complete data, which can serve the needs of its users as a whole. Although the complete word used here is relative, but at least the data helps make it easier to add to the collection of data, and ensures the user is easy to modify existing data structures, just call the data fields available.
Accuracy and Security
The next data base function is for accuracy. So, so that errors can be suppressed as much as possible, you can do a good organization of database files to avoid errors in the data entry process and also in the storage or datastore process.
In addition, the database function is for security. There are data security facilities provided by a good database system so that data cannot be modified, accessed, modified or deleted by those who do not have the right to do so.
Storage Efficiency
Data organizing is done well with the aim to avoid duplication of data that affects the increased storage space of the database. coding and data relations are also useful for saving storage space in the database.