About Oracle

Oracle Data Base is a relational database that consists of a collection of data in a database management system RDBMS. Oracle software company to market this type of data base for various applications that can run on many types and brands of computer hardware (platform). Oracle data base was first developed by Larry Ellison, Bob Miner and Ed Oates through his consulting company called Software Development Laboratories (SDL) in 1977. In 1983, the company changed its name to Oracle Corporation until now.
 

Advantages And Disadvantages of Oracle: Pros: Can be a fairly large process data quickly. Disadvantages: The price is very expensive for a database.
MY SQL MySQL is a software SQL database management system (English: database management system) or the DBMS is multithreaded, multi-user, with about 6 million installations worldwide. MySQL AB makes MySQL available as free software under the GNU General Public License (GPL), but they are also sold under a commercial license for those cases where its use is incompatible with the GPL.
Not the same with projects such as Apache, where the software was developed by the general community, and the copyright for the source code are owned by their respective authors, MySQL is owned and sponsored by a Swedish commercial company MySQL AB, which holds the copyright on all code almost source. Both Swedes and the Finns who founded MySQL AB is: David Axmark, Allan Larsson and Michael "Monty" Widenius.
MySQL is a Relational Database Management System (RDBMS) that is distributed for free under the GPL (General Public License). Where everyone is free to use MySQL, but should not be a derivative product that is closed source or commercial. MySQL is actually a derivative of one of the main concepts in the database for a long time, namely the SQL (Structured Query Language). SQL is a database operation concept, especially for the election or selection and data entry, allowing easy operation of the data done automatically. Reliability of a database system (DBMS) can be determined from the workings of the optimizer his way to perform SQL commands, which are made by the user and application programs. As a database server, MySQL can be said to be more superior than any other database server in the query data. This proved to queries made by a single user, the speed of MySQL query can be ten times faster than PostgreSQL and five times faster than Interbase.
A relational database management system or in English known as the relational database management system (RDBMS) is a computer program (or, more typical is a set of computer programs) designed to regulate / manage a database as a set of data that is stored in a structured, and do operations on data at the request of users. Examples of the use of DBMS and there are a lot of work in various fields, such as accounting, human resources management, and so forth. Although initially the DBMS only owned by large companies that have computer equipment in accordance with standard specifications are required (at the time required standards can be said to be very high) to support a large amount of data, the current implementation is already very much and adaptatif by a rational need for data specification can sehinggal owned and implemented by all circles as part of an investment company.
Multi-user is a term in the operating system or software application that allows access by multiple users at the same time to the operating system or application. The term opponent of the single-user refers to an operating system that can only be used by one user at any time.
In addition MySQL also has several features, among others: • Portability: MySQL can run stable on a variety of operating systems like Windows, Linux, FreeBSD, Mac Os X Server, Solaris, Amiga, and many more. • Open Source: MySQL is distributed as open source (free), under the GPL license so it can be used free of charge. • Multiuser: MySQL can be used by several users at the same time without experiencing any problems or conflicts. • Performance tuning: MySQL has an amazing speed in dealing with simple queries, in other words more SQL can process per unit time. • Column types: MySQL has a very complex type of the column, such as signed / unsigned integer, float, double, char, text, date, timestamp, etc. • Command and functions: MySQL has a full service and functionality that support the command Select and Where in the query. • Security: MySQL has several layers of security such as the level subnetmask, host name, and permits access to user with a detailed licensing system as well as encrypted passwords. • Scalability and Limits: MySQL database capable of handling large scale, with the number of records more than 50 million and 60 thousand and 5 billion row table. Also limit the index that can be accommodated up to 32 indexes on each table.
• Connectivity: MySQL can not connect with the client using TCP / IP, Unix sockets (UNIX), or Named Pipes (NT). • Localisation: MySQL can detect an error message on the client by using more than twenty languages. Nevertheless, the Indonesian language has not been included therein. • Interface: MySQL has an interface (interface) to a variety of applications and programming languages ​​by using the API (Application Programming Interface). • Clients and tools: MySQL is equipped with various tools that can be used for database administration, and at every tool that is included instructions online. • Structure table: MySQL has a table structure that is more flexible in dealing with ALTER TABLE, compared to other databases like PostgreSQL or Oracle.
Advantages And Disadvantages My SQL: Pros: very fast data processing, open source. Disadvantages: Data are increased in size to have compromised the process, so there should be a database management. SQL SERVER Microsoft SQL Server is a relational database management system (RDBMS) Microsoft products. Primary query language is Transact-SQL is an implementation of the SQL standard ANSI / ISO are used by Microsoft and Sybase. SQL Server is generally used in the business world that has a data base of small to medium scale, but then developed with the use of SQL Server on a large data base.
Microsoft SQL Server and Sybase / ASE can communicate over the network by using the TDS protocol (Tabular Data Stream). Apart from that, Microsoft SQL Server also supports ODBC (Open Database Connectivity), and has a JDBC driver for Java programming language. Other features of SQL Server is its ability to create a database mirroring and clustering.
By applying the principles of database servers, all data processing starting from the search, update, deletion, addition, arrive at the complex queries performed on the server computer, so in addition to the credibility of the data is maintained there is also sharing the workload between the client computer and server computer data. So that the client computer functions only as a media input and output data alone, the rest is handled by the server by using structured query language known as Structured Query Language (SQL), this is the language used by the client computer to communicate with the server computer requests data from the data, update, delete, and so forth.
Advantages And Disadvantages of SQL Server: Pros: SQL Server holds the top TPC-C performance and price / performance results. Disadvantages: The cost that would be required for the operation is quite large.

COMPARISON BETWEEN ORACLE, MY SQL, SQL SERVER AND
Comparison of MySQL with SQL Server: If we often create a database program with a command that we store in the database as a stored procedure, function, or trigger is sometimes there are differences between the programming language on MySQL with SQL Server. Here we will discuss some of the differences between these database applications. For the parameters in the SQL Server always uses the prefix '@', while in the MySQL parameters we can identify with any character and we can even make the local parameters without declared beforehand, by adding the character "@" in the prefix parameter was made. In SQL Server we can type the command 'DECLARE v1 [datatype], v2 [datatype], v3 [datatype] "but in MySQL you must type the command 'DECLARE v1 [datatype]; DECLARE v2 [datatype]; DECLARE v3 [datatype]' SQL Server does not need to type the command 'BEGIN ... END' to limit a Stored Procedure or Function. But in MySQL we need to type the command 'BEGIN ... END "for Stored Procedure or Function with more than one command line. Example: DELIMITER $ CREATE PROCEDURE proc1 (id int) BEGIN [Statement 1]; [Statement 2]; END $ DELIMITER; In SQL Server we do not have to type the character ';' (semicolon) at the end of each command. But in MySQL takes the characters ';' at each end of the command, because MySQL is a console application that requires a barrier to any command that is written to be limiting with other commands in a procedure or function. SQL Server has a function 'SET NOCOUNT' and '@ @ ROWCOUNT' to obtain the number of row execute results. While in MySQL has no command to 'SET NOCOUNT', but it has a function 'ROW_COUNT ()' to get the number of rows of query results execute delete, insert, or update, 'found_rows ()' to get a number of rows of query result SELECT execute. SQL Server has a command loop 'BEGIN WHILE ...'. While MySQL has a command loop 'WHILE ... DO'. SQL Server can use the command 'SELECT' or 'SET' to populate the data into a variable. Example: Int DECLARE @ v1, @ v2 int SELECT @ v1 = 10, @ v2 = 20
While MySQL can only use the command 'SET' to populate the data into a variable.
Example: DECLARE v1 int; DECLARE v2 int; SET v1 = 10; SET v2 = 20;

Posted in: news