Basic Operation Data Base
In a disk, the database can be created and can also be eliminated. In a disk, we can also put some (more than one) database. While in a database we can put one or more files / tables. In the file / table is in fact the data is stored / placed.
A general database created to represent a specific universe of data. For example databases of personnel, academic databases, inventory databases (warehousing) and so on. In academic databases, for example, we can put the files of subjects, teachers' files, schedule files, the file value and so on.
Therefore, the basic operations we can do regarding the databases may include:
- Creating a new database (create database) which is identical to the creation rasip new cabinet.
- Elimination of the database (drop database) which is identical with the destruction rasip closet.
- Making the file / new table to a database (create table), identical with the addition of new file folder.
- Elimination of the file / table from a database (drop table).
- Addition / new data charging to a file / table in a database.
- Retrieving data from a file / table.
- Changing the data from a file / table.
- Elimination of data from a file / table.
Operations relating to the making of the object (and database tables) is an initial operation performed only once and applies onwards, while the operations associated with filling the table is the routine operations carried out repeatedly and therefore operations This represents a more appropriate management activities (Management) and processing (processing) data in the database.
Destination Database
It was mentioned that the main purpose of the database pengelolaaan in a database is that we can rediscover our search ynag data easily and quickly. A more complete utilization of the database is to fulfill some purpose (objective) such as:
1. The speed and ease (speed)
Utilization of the database allows us to be able to save data or make changes / manipulation of data or display the returned data faster and easier, than we store data manually (non electronic).
2. Storage Space Efficiency (Space)
Because of close linkages between groups in the database, then the redundancy (repetition) of data must always be there. With databases, the efficiency / optimalisai use of storage space can be done because we can do emphasis the amount of data redundancy, either apply a number of encoding or creating relationships (in the form of files) between groups of interconnected data.
3. Accuracy (Accuracy)
Utilization of the coding or the formation of relationships between the data together with the application of rules / constraints (constraints) data type, data domain, the uniqueness of the data and the like which can be applied strictly in a database, it is useful to suppress the inaccuracies / data storage.
4. Availability (Availability)
The growth of data over time will increasingly require large storage space. And not all the data we always use / need. Hence, we can perform sorting of data, so the data we use is rare that we can move into the storage media off-line. On the other hand, because the interests of data usage, a database may have data spread across many geographic locations. For example, a bank customer data separated and stored in separate locations in accordance with the presence of customers. With the use of computer network technology, data residing in a location / branch, can also be accessed (to be available / avaible) for other locations.
5. Completeness (Completeness)
To accommodate the needs of the completeness of data is growing, so we are not only able to add data records, but also can make changes in database structure, both in the addition of new objects (tables) or by the addition of new field-filed at a table.
6. Security (Security)
There are a number of systems (applications) database managers that do not implement the security aspects in a database. But for a large system and serious, security aspects can also be applied strictly. That way, we can determine no one (user) is allowed to use its database objects in it and determine the types of operations what to do.
7. Togetherness Usage (Sharebility)
The user database is often not limited to one user only, or in one location only by a single application system. Employee data in the personnel database, for example, can be used by many users, from a number of departments within the company or by multiple systems (payroll systems, accounting systems, inventory systems and so on). The database is managed by the system (application) which supports multiuser environments will be able to meet this need, but still with maintaining / avoid the emergence of new problems such as data inconsistencies (due to the same data can be modified by many users at a time bers0amaan) or a deadlock condition ( because many users wait for each other to use the data)
In a disk, the database can be created and can also be eliminated. In a disk, we can also put some (more than one) database. While in a database we can put one or more files / tables. In the file / table is in fact the data is stored / placed.
A general database created to represent a specific universe of data. For example databases of personnel, academic databases, inventory databases (warehousing) and so on. In academic databases, for example, we can put the files of subjects, teachers' files, schedule files, the file value and so on.
Therefore, the basic operations we can do regarding the databases may include:
- Creating a new database (create database) which is identical to the creation rasip new cabinet.
- Elimination of the database (drop database) which is identical with the destruction rasip closet.
- Making the file / new table to a database (create table), identical with the addition of new file folder.
- Elimination of the file / table from a database (drop table).
- Addition / new data charging to a file / table in a database.
- Retrieving data from a file / table.
- Changing the data from a file / table.
- Elimination of data from a file / table.
Operations relating to the making of the object (and database tables) is an initial operation performed only once and applies onwards, while the operations associated with filling the table is the routine operations carried out repeatedly and therefore operations This represents a more appropriate management activities (Management) and processing (processing) data in the database.
Destination Database
It was mentioned that the main purpose of the database pengelolaaan in a database is that we can rediscover our search ynag data easily and quickly. A more complete utilization of the database is to fulfill some purpose (objective) such as:
1. The speed and ease (speed)
Utilization of the database allows us to be able to save data or make changes / manipulation of data or display the returned data faster and easier, than we store data manually (non electronic).
2. Storage Space Efficiency (Space)
Because of close linkages between groups in the database, then the redundancy (repetition) of data must always be there. With databases, the efficiency / optimalisai use of storage space can be done because we can do emphasis the amount of data redundancy, either apply a number of encoding or creating relationships (in the form of files) between groups of interconnected data.
3. Accuracy (Accuracy)
Utilization of the coding or the formation of relationships between the data together with the application of rules / constraints (constraints) data type, data domain, the uniqueness of the data and the like which can be applied strictly in a database, it is useful to suppress the inaccuracies / data storage.
4. Availability (Availability)
The growth of data over time will increasingly require large storage space. And not all the data we always use / need. Hence, we can perform sorting of data, so the data we use is rare that we can move into the storage media off-line. On the other hand, because the interests of data usage, a database may have data spread across many geographic locations. For example, a bank customer data separated and stored in separate locations in accordance with the presence of customers. With the use of computer network technology, data residing in a location / branch, can also be accessed (to be available / avaible) for other locations.
5. Completeness (Completeness)
To accommodate the needs of the completeness of data is growing, so we are not only able to add data records, but also can make changes in database structure, both in the addition of new objects (tables) or by the addition of new field-filed at a table.
6. Security (Security)
There are a number of systems (applications) database managers that do not implement the security aspects in a database. But for a large system and serious, security aspects can also be applied strictly. That way, we can determine no one (user) is allowed to use its database objects in it and determine the types of operations what to do.
7. Togetherness Usage (Sharebility)
The user database is often not limited to one user only, or in one location only by a single application system. Employee data in the personnel database, for example, can be used by many users, from a number of departments within the company or by multiple systems (payroll systems, accounting systems, inventory systems and so on). The database is managed by the system (application) which supports multiuser environments will be able to meet this need, but still with maintaining / avoid the emergence of new problems such as data inconsistencies (due to the same data can be modified by many users at a time bers0amaan) or a deadlock condition ( because many users wait for each other to use the data)
