MySQL database software is a relation (relational database management system or RDBMS), such as ORACLE, Postgresql, MS SQL, and so on. MySQL AB refer to the product as the most popular open source database in the world. Based on the research revealed that that the Web platform, and good for the category of open source and public, MySQL is a database of the most widely used. According to the company's developers, MySQL has been installed in about 3 million computers. Tens to hundreds of thousands of sites relying on MySQL to work day and night to pump data for the visitors.
MySQL Features
When MySQL starts at 3:22 series adopted a lot of people and increased user population, then at 3:23 and the 4.0-series there was a considerable increase from the technology. It is inseparable from the demands of users who increasingly rely on MySQL, but need the features more.
Series 3.23. At 3:23 MySQL series adds three new table types: first MyISAM, which until now become the default table type; both BerkeleyDB, the first to add transactional capabilities to MySQL and third InnoDB, potential new prima donna.
Series 4.x. In the new series goes up to 4.0 alpha stage, the MySQL developers promised to make the MySQL one degree higher. These features are always asked to be granted, such as subselek (at 4.1), union (4.0), foreign key constraint (4.0 or 4.1-though InnoDB already provides this in 3.23.x), stored procedure (4.1), view (4.2 ), cursor (4.1 or 4.2), trigger (4.1). MySQL AB remains dedicated to develop and improve MySQL and MySQL to maintain as most popular open source database.
Advantages of MySQL
The main cause of MySQL is so popular among the Web is because it is suitable to work in that environment. First, MySQL is available on various Linux platforms and various Unix variants. Something that does not have access, for example-while Access is very popular on the Windows platform. Many Unix-based Web servers, this makes the automated Access can not be used because he did not have the ability client-server/networking.
Second, the features that MySQL is normally held in great demand in Web applications. For example, its SQL LIMIT clause, practical to perform paging. Or FULLTEXT index type field, for full text searching. Or call it wealth builtinnya functions, ranging from the format and manipulate dates, processing strings, regex, encryption and hashing. The latter for example, practical to perform the password storage site members.
Third, MySQL has a low overhead connection. To speed the transaction or performance at high load conditions may be debated by a variety of different benchmarks, but when it comes to this one MySQL was the champion. These characteristics make MySQL suitable to work with CGI applications, where on every request script will establish a connection, send one or more SQL commands, and then disconnect again. Try doing this with Interbase or Oracle. So with a few requests per second load alone web server / database you may soon give up because they can not offset this burden.
MySQL Features
When MySQL starts at 3:22 series adopted a lot of people and increased user population, then at 3:23 and the 4.0-series there was a considerable increase from the technology. It is inseparable from the demands of users who increasingly rely on MySQL, but need the features more.
Series 3.23. At 3:23 MySQL series adds three new table types: first MyISAM, which until now become the default table type; both BerkeleyDB, the first to add transactional capabilities to MySQL and third InnoDB, potential new prima donna.
Series 4.x. In the new series goes up to 4.0 alpha stage, the MySQL developers promised to make the MySQL one degree higher. These features are always asked to be granted, such as subselek (at 4.1), union (4.0), foreign key constraint (4.0 or 4.1-though InnoDB already provides this in 3.23.x), stored procedure (4.1), view (4.2 ), cursor (4.1 or 4.2), trigger (4.1). MySQL AB remains dedicated to develop and improve MySQL and MySQL to maintain as most popular open source database.
Advantages of MySQL
The main cause of MySQL is so popular among the Web is because it is suitable to work in that environment. First, MySQL is available on various Linux platforms and various Unix variants. Something that does not have access, for example-while Access is very popular on the Windows platform. Many Unix-based Web servers, this makes the automated Access can not be used because he did not have the ability client-server/networking.
Second, the features that MySQL is normally held in great demand in Web applications. For example, its SQL LIMIT clause, practical to perform paging. Or FULLTEXT index type field, for full text searching. Or call it wealth builtinnya functions, ranging from the format and manipulate dates, processing strings, regex, encryption and hashing. The latter for example, practical to perform the password storage site members.
Third, MySQL has a low overhead connection. To speed the transaction or performance at high load conditions may be debated by a variety of different benchmarks, but when it comes to this one MySQL was the champion. These characteristics make MySQL suitable to work with CGI applications, where on every request script will establish a connection, send one or more SQL commands, and then disconnect again. Try doing this with Interbase or Oracle. So with a few requests per second load alone web server / database you may soon give up because they can not offset this burden.
0 komentar:
Posting Komentar