Selasa, 15 Mei 2012

Know the Database

Database (database) is a collection of information stored on the computer in a systematic way. These data can be checked using a computer program to obtain information from the database. The software used to manage calls and queries (query) the database is called database management system (database management system).The term database (database) originated from computer science. The term was eventually extended to many fields. Actually, the record is similar to the data base already existed before the industrial revolution. These notes form ledgers, receipts, and collection of data related to the business.A collection of notes and pieces of knowledge is the basic concept of the database. A structured database has an explanation of the types of facts stored in it. Such an explanation is called the scheme, which describes an object that is represented in the database and the relationships between those objects.There are many ways in which to organize a scheme or model the database structure. The relational model is a model commonly used today. This model represents all the information in the form of related tables and each table consists of rows and columns.In the relational model, relations antarkabel represented using the same value antarkabel. Models such as hierarchical and network models, using a more explicit way to represent the relationship antarkabel.The term database refers to the collection of data that are interconnected and the software refers to a database management system. If the context is clear, the programmers and database administrators use the term to the second meaning.

Database Software 

Database software that is widely used in programming and databases, including the high level is as follows.

Microsoft SQL Server 

Microsoft SQL Server is a relational database management system (RDMBS) Microsoft products. This system is used in the business world with a database of small-scale, medium, and grown on a large database.SQL Server can communicate over the network by using the TDS protocol (Tabular Data Stream), supports the ODBC (Open Database Connectivity), and has a JDBC driver for the Java programming language. In addition, SQL Server also has the ability to create a database mirroring and clustering.

Oracle 

Oracle is a relational database that consists of a collection of data in a database management system RDBMS. Oracle software companies selling this type of data base for a wide range of applications that can run on many types and brands of computer hardware (platform).

Firebird 

Or FirebirdSQL Firebird is a relational database management system and offers the features contained in the ANSI SQL-2003 standard. RDBMS is running well on Linux, Windows, and in a number of Unix platforms. Firebirds is a derivative of Interbase Borland's open source version.

MySQL 

MySQL is a soft peangkat SQL database management system or DBMS is multithreaded and multi-user with 6 million installations worldwide. MySQL AB makes MySQL available as free software under the GNU General Public Licence (GPL).Any user with the free use of MySQL. Actually, MySQL is an instance of one of the main concepts in the database that already exists, SQL (Structured Query Language).As stewards of data base, the software supports a transactional database operations and the operation of non-transactional database. In the non-transactional operation, MySQL is superior in terms of performance compared with the database software competitors.

Tidak ada komentar:

Posting Komentar