Database: Open source is fierce!

xiaoxiao2021-03-05  20

With the famous open source database MySQL in this quarter released its version 5.0, the discussion of the open source database has started a new round of hot discussions in the arrangement. The new version of this launched version is functionally seen, and there seems to be no reason to make people don't choose it!

Open source movements in IT industry have become popular topics in the field of software development. Under this trend, MySQL has now become the most popular open source database in the world.

All missing enterprise characteristics will be included in Mysql5.0. According to mysql, the founder David Axmark said, "Since we started Mysql in 1995, people have been complaining that they do not support it, triggers, and views are not supported. Ten years, a sword, the new version will solve all the problems in one fell swoop. It is the most important version in our company. "

According to the survey of Evans Data Corporation, MySQL has 40% of the open source market, followed by Firebird (39%) and PostgreSQL (11%). Axmark believes that new versions will be considerable in the increase in market share, and users can be expected to increase by 10 times.

In the past two years, some large companies in the United States have adopted an open source database, which often uses commercial databases at headquarters, while adopting open source products on the LINUX server of the branch. These databases have all be unique in addition to cost. The open database structure is simple compared to commercial products (such as Oracle, IBM DB2), so the reading operation is fast; if it is managed, it does not even require a full-time administrator.

Due to the performance of open source database performance, less license fee, low management costs, and even large companies like Cisco, Yahoo.

In the boom of open source movements, we can see the figure of the source database everywhere. MySQL, PostgreSQL, SAPDB, Interbase, Berkeley DB ... They like a star starfish in the night sky.

At present, the main open source database products are:

Product Name Field Latest Version Vendor or Background Main Features Mysql Enterprise Apply, General Relations Database Mysql 5.0 Sweden Mysql Comprehensive Support View, Trigger, Stored Procedure. PostgreSQL General Object - Relational Database Management System PostgreSQL 8.0PostgreSQL originated in PostgreSQL The earliest Ingres project started from BSD, developed by the University of California Berkeley, Postgres V4.2, currently as an open source project, continued to develop by volunteers, followed by BSD license. The conventional version formally supported platforms are limited to UNIX-based operating systems. Direct support, time recovery point, table space, table space, storage process, view, trigger, foreign key ingres General relational database INGRES R3 INGRES is born in California University Berkeley, the main designer is the famous Michael Professor Stonebraker; high availability cluster of CA; upgradeable database cluster; table partition and index function; parallel query processing; online table and index identification; fully utilize the ability of 64-bit environmental resources; fully support UNICODE format Firebird (Interbase) 20001.3: Borland Announces Interbase 6 open source; Firebird is derived from Borland's Interbase 6 Open Source version with free version / simple easy-to-use / operation stable / maintenance costs low / easy to quickly install cross-platform, multiple networks agreement.

Berkeley

Inclusive database management system for DB open source code

Berkeley

DB

4.3.27

转载请注明原文地址:https://www.9cbs.com/read-38881.html

New Post(0)