Friday, January 6, 2017

Understanding Database

Understanding Database - Database or database is a collection of data that is stored systematically in the computer that can be processed or manipulated using the software (application program) to produce information. Defining database includes specification of data types, data structures and also the limits of data to be stored. The database is a very important aspect in information systems that the database is a repository of data to be processed further. The database is important because it can organize the data, avoid duplication of data, relationships between data that is not clear and also updates complicated.

a set of data that has been prepared in such a way with the conditions or specific rules that relate to each other making it easier for users to manage it also makes it easier to obtain information. Besides those that define a database as a collection of files, tables, or archive interconnected stored in the electronic media.

The database has many types and the following explanation of some types of database:

  • The relational database is a database of the most popular types. Relational databases allow users to access, update, and search for information based on the relationship data stored in different tables.

  • Analytical Database (or OLAP-On Line Analytical Processing) is a storage database archives or historical data can only be read (read-only database), and used for analysis.

  • Operational databases (also called OLTP-On Line Transaction Processing), in general be used to manage data bit more dynamic.