This Is The Explanation Of Databases And Software
Database (database) or as a database is a collection of information stored in a computer system systematically so that it can be checked using a computer program to get information from that database. The software used to manage and invoke database queries is called a database management system (DBMS) in a database system that can be studied in information science.
This term database originated from computer science, although then the meaning is increasingly broad to include things outside the field of electronics. For similarities in this database actually existed before the industrial revolution in the form of ledgers, receipts and data sets related to business.
The basic concept of a database is a collection of notes or pieces of knowledge. A database has a structural explanation of the types of facts stored in it, the explanation is by the scheme. Schema describes an object that is represented by a database and has a relationship between these objects. There are many ways to organize a schema or to model a database structure, this is known as a database model or data model. Usually the model that is commonly used now is the relational model which the term layman represents all information in the form of interconnected tables where each table consists of rows and columns (the actual definition uses mathematical terminology). In this model the relationships between tables are represented by using the same values between tables. Other models such as the hierarchical model and the network model use a more explicit way to represent relationships between tables.
For the term database refers to the collection of data that are interconnected and the software should refer to as a database management system (data management system / DBMS). If the context is clear many administrators and programmers use the term database for both meanings.
Database Design Stages
Database design (database) is an effort to build a database in a business environment, to build a database there are stages that need to be passed, namely:
Database planning (database)
Defines the system
Analyze and collect needs
Database (database) design
Application design
Make a prototype
Implementation
Data conversion
Testing
Operational maintenance
Database Software (Database)
Database software (database) which is widely used in programming
MySQL
It is a multithread, multi-user database management system for SQL or DBMS (database management system) with around 6 million installations worldwide. MySQLAB makes MySQL available as free software under the GNU General Public License (GPL) but they also sell under a commercial license for cases where its use does not match the use of the GPL. Unlike projects such as Apache where software is developed by the general community, and copyrights for source code are owned by their respective authors, MySQL is owned and sponsored by a Swedish commercial company MySQL AB, which holds copyright almost all of its source code . The two Swedish and one Finnish who founded MySQL AB is David Axmark. Allan Larson and Michael Monty Widenius.
Microsoft SQL Server
A relational personal database management system (RDBMS) for Microsoft products. The main query language is Transact-SQL which is an implementation of the ANSI / ISO standard SQL used by Microsoft and Sybase. Which is generally used in the SQL Server business world that has a small to medium-scale database, but later developed with the use of SQL Server in large databases. Microsoft SQL Server and Sybase / ASE can communicate over the network using the TDS (Tabular Data Stream) protocol. Apart from that Microsoft SQL Server also supports ODBC (Open Database Connectivity) and has a JDBC driver for the Java programming language. Another feature of SQL Server is its ability to create database mirroring and clustering. In the previous version, MS SQL Server 2000 was attacked by the SQL Slammer computer worm, which caused delays in internet access.
Relational Database Management System (RDBMS)
MySQL is a Relational database management system (RDBMS) that is distributed free of charge under the GPL (General Public License) license where everyone is free to use MySQL but may not be made a commercial derivative product. MySQL is actually a derivative of one of the main concepts in the database for a long time, especially for the selection or selection and entry of data that allows data operations to be done easily automatically. The reliability of a database (DBMS) can be known from the way the optimizer works in the process of SQL commands made by the user and application programs. As a database server, MySQL can be said to be superior compared to other database servers in querying data. This is proven for querty performed by a single user, MySQL query speed is ten times faster than postgreSQL and five times faster than interbase.
Clipper
XBase family computer programming language that is used to create the main computer program that runs on the DOS operating system. More specifically, clipper is generally used to create programs related to databases / businesses such as savings / loan management, accounting and others. The history of clipper was first introduced in 1985 by Nantucket which was later sold to Computer Association as a compiler for Dbase III which was very popular at that time. Dbase code compilation means changing it from interpretation code (source code that can be read by humans) that must be interpreted by the computer every time each line is run, into a P-code (or pseudo-code) that uses a virtual machine to process the p-code that is has compiled it. Although p-code is not faster than machine code produced by other language compilers (C ++), overall p-code is still much faster than interpreters.