Free databases in the open source world.
Release time: 20111-22 09: 34: 30 source: CSDN comments: 0 clicks: 1476 times font size: large, medium and small.
QQ Space Sina Weibo Tencent Weibo Renren.com Douban.com Baidu Space Baidu Search Kaixin.com Copy More 0
Open source database MySQL MySQL is a small open source relational database management system, which was developed by Swedish MySQL AB company. At present, MySQL is widely used in small and medium-sized websites on the Internet. Because of its small size, high speed and low total cost of ownership, it is especially open source. ...
Open source database MySQL
MySQL is an open source small relational database management system, which was developed by MySQL AB Company in Sweden. At present, MySQL is widely used in small and medium-sized websites on the Internet. Because of its small size, high speed and low total cost of ownership, especially open source, many small and medium-sized websites choose MySQL as the website database to reduce the total cost of ownership.
Inventory: those free database software in the open source community.
MySQL provides APIs for many programming languages, including C, C++, C#, Delphi, Eiffel, Java, Perl, PHP, Python, Ruby and Tcl. Moreover, it is written in C and C++, and has been tested by various compilers, so MySQL can ensure that the source code has strong portability. Such a database can naturally support almost all operating systems, from Unix, Linux to Windows, including AIX, BSDi, FreeBSD, HP -UX, Linux, Mac OS, Novell Netware, NetBSD, OpenBSD, OS/2 Wrap, Solaris, SunOS, Windows and other operating systems. Most importantly, it is a large database that can handle tens of millions of records.
At the same time, MySQL has also made many branch versions of the database, which is also highly recommended.
The first is MariaDB, which is a branch version of MySQL with Maria storage engine. It is a free and open source database server developed by the company founded by Michael Widenius, the original author of MySQL. Compared with MySQL, MariaDB has more engines, including Maria storage engine, PBXT storage engine, XtraDB storage engine and FederatedX storage engine. It can replicate query processing faster, run faster, perform better functional tests, and support Unicode sorting.
Secondly, rcona, which improves the MySQL database server, has significantly improved its function and performance compared with MySQL. This version improves the performance of InnoDB under high load. At the same time, it also provides some very useful performance diagnostic tools for DBA, and provides many parameters and commands to control server behavior.
The third is Percona Server, which uses google-mysql-tools, ProveScaling and Open Query to transform mysql. Moreover, it only contains the server version of MySQL, and does not provide corresponding improvements to MySQL connectors and GUI tools.
Non-relational database NoSQL
Literally speaking, NoSQL is not just SQL, it is regarded as a brand-new database revolution movement by the industry. Earlier, it was suggested that the development trend in 2009 would be higher and higher. NoSQL advocates the use of non-relational data storage. Compared with the overwhelming use of relational databases, this concept is undoubtedly an injection of new thinking.
Inventory: those free database software in the open source community.
Of course, NoSQL can make great progress only with the rise of Internet Web2.0 website. The key requirement is that the traditional relational database should be able to cope with Web2.0 websites, especially >:>
Which open source database should I choose?
If you plan to choose a free open source database for your project, you may hesitate between MySQL and PostgreSQL. MySQL and PostgreSQL are free, open source and powerful databases. Your main question may be: which is the best open source database, MySQL or PostgreSQL? Which open source database should I choose?
When choosing a database, you have to make a long-term decision, because it is very difficult and expensive to change this decision in the future. You want to make the right choice from the beginning. MySQL and PostgreSQL, two popular open source databases, are often the last choice products. A high-level overview of these two open source databases will help you choose the one that best suits your needs.
relational database
MySQL is relatively young and first appeared in 1994. It claims to be the most popular open source database. MySQL is the M in LAMP (a software package developed by Web, including Linux, Apache and Perl/PHP/Python). Most applications based on LAMP stack will use MySQL, including those well-known applications such as WordPress, Drupal, Zend and phpBB.
At first, MySQL was designed as the fast back-end of Web server, which used the fast index sequential access method (ISAM) and did not support ACID. After early rapid development, MySQL began to support more storage engines, and realized ACID through InnoDB engine. MySQL also supports other storage engines, provides the function of temporary tables (using memory storage engine), and realizes high-speed reading of databases through MyISAM engine, in addition to other core storage engines and third-party engines.
MySQL has a wealth of documents, including many high-quality free reference manuals, books and online documents, as well as training and support from Oracle and third-party suppliers.
MySQL has experienced ownership changes and some dramatic events in recent years. Originally developed by MySQL AB, it was sold to Sun Company in 2008 at a price of $65.438 billion, and Sun Company was acquired by Oracle in 2065.438+00. Oracle supports multiple versions of MySQL: Standard Edition, Enterprise Edition, Classic Edition, Cluster Edition, Embedded Edition and Community Edition. Some are downloaded for free, and some are charged. Its core code is based on GPL license, and commercial license is also available for developers and manufacturers who don't want to use GPL license.
Now, there are more databases to choose from based on the original MySQL code, because several core MySQL developers have released MySQL branches. Michael "Monty" Widenius, one of the original founders of MySQL, seems to regret selling MySQL to Sun, so he developed his own MySQL branch MariaDB, which is free and based on GPL license. Mao Mao Rain is a branch created by Brian Aker, a well-known MySQL developer, and has done a lot of rewriting, especially for multi-CPU, cloud, network applications and high concurrency.
A database system
PostgreSQL boasts of being the most advanced open source database in the world. Some PostgreSQL fans say that it is comparable to Oracle, and it is not so expensive and arrogant in customer service. It has a long history and was originally developed by the University of California at Berkeley at 1985 as the successor of Ingres database.
PostgreSQL is a completely community-driven open source project maintained by more than 1000 contributors worldwide. It provides a single full-featured version, unlike MySQL, which provides multiple different community, business and enterprise versions. PostgreSQL is based on a free BSD/MIT license. Organizations can use, copy, modify and redistribute code by providing copyright notices.
Reliability is the highest priority of PostgreSQL. This is rock-solid quality and ... >>
Which open source database should I choose? Which is better?
Access is a desktop database, which is only suitable for applications with small data. It is very good and efficient when dealing with a small amount of data and databases accessed by a single computer. But it cannot access more than four clients at the same time. Microsoft Access database has certain restrictions. If the data reaches about 100M, it is easy to cause the server iis to fake death, or consume the server memory to cause the server to crash, which means "the service is unavailable" in English.
MS SQL Server is a medium-sized database based on server, which can be suitable for the application of large-capacity data and is much better than Microsoft Access in function management. It has powerful efficiency in dealing with massive data, flexibility and expansibility in background development. Because now the database is managed by standard SQL language, if it is a standard SQL language, both of them can be basically used. Microsoft SQL Server has many extensions, which can use stored procedures, and the database size is not limited.
MySql is short and pithy. It is a file-based database like access, but it is a hundred times stronger than access. It is a real multi-user and multi-task database system. It is transplanted from Linux, and its security is very good. However, most operations are carried out under dos. Although there is a graphical interface developed by a third party, it is not easy to use. MySQL is a multi-platform database management software, which can run on LINUX, nt, UNIX and other systems, and can support command and graphical management. It is enough for the general database, which occupies less system resources, is faster, and is open source.
Oracle Bone Inscriptions is mature in all aspects, but it has high requirements for hardware. It can be used in occasions with high requirements for data integrity and security. It can run on all mainstream platforms, fully support all industrial standards, and adopt a completely open strategy. Can let customers choose the most suitable solution and give developers full support. Parallel server expands the capabilities of the server by sharing the work among a group of nodes in the same cluster, provides a cluster solution with high availability and scalability, obtains the highest certification level of iso standard certification, supports a variety of industrial standards, can connect with network clients such as ODBC, JDBC, OCI, etc., which is complicated, and provides gui and command line at the same time. The operation under windows and unix is the same. If windows can't meet the needs, users can migrate the database to unix. Its operation and setting are complicated, and it is suitable for users with certain operating experience.
Db2 can run on all major platforms (including windows). Most suitable for massive data. DB2 is the most widely used enterprise. In the world's 500 largest enterprises, almost 85% use DB2 database server, while in China, the figure of 1997 is only 5%.
In short, each mainstream database has its own advantages and emphases. For beginners, it is recommended to start learning from MS SQL Server. As we all know, Microsoft's things are easy to understand.
Which open source database should I choose?
If you plan to choose a free open source database for your project, you may hesitate between MySQL and PostgreSQL. Both MySQL and PostgreSQL are free.
Expensive, open source and powerful database. Your main question may be: which is the best open source database, MySQL or PostgreSQL? Which open source database should I choose?
And then what?
When choosing a database, you have to make a long-term decision, because it is very difficult and expensive to change this decision in the future. You want to make the right choice from the beginning. Two fashions
Open source databases MySQL and PostgreSQL are usually the last choice products. A high-level overview of these two open source databases will help you choose the one that best suits your needs.
relational database
MySQL is relatively young and first appeared in 1994. It claims to be the most popular open source database. MySQL is LAMP (a software package for Web development, including
Linux, Apache and Perl/PHP/Python). Most applications built on the LAMP stack will use MySQL, including those well-known applications, such as
WordPress, Drupal, Zend and phpBB, etc.
At first, MySQL was designed as a fast Web server backend, using.
The fast index sequential access method (ISAM) does not support ACID. After the early rapid development, MySQL began to support more storage engines, which were implemented by InnoDB engine.
Acid. MySQL also supports other storage engines, provides the function of temporary tables (using memory storage engine), and realizes high-speed reading of databases through MyISAM engine, and so on.
Core storage engine and third-party engine.
MySQL has a wealth of documents, including many high-quality free reference manuals, books and online documents, as well as training and support from Oracle and third-party suppliers.
MySQL has experienced ownership changes and some dramatic events in recent years. Originally developed by MySQL.
AB, which was later sold to Sun Company in 2008 at a price of 65.438+0 billion US dollars, and Sun Company was acquired by Oracle Bone Inscriptions in 2065.438+00. Oracle supports multiple versions of MySQL.
Ben: standard, enterprise, classic, cluster, embedded and community. Some of them are downloaded for free, and there is another one.
Others are charged. Its core code is based on GPL license, and commercial license is also available for developers and manufacturers who don't want to use GPL license.
Now, based on the original
MySQL code has more databases to choose from, because several core MySQL developers have released MySQL branches. Michael, one of the founders of MySQL
"Monty"
Widenius seems to regret selling MySQL to Sun, so he developed his own MySQL branch MariaDB, which is free and based on GPL license. known
Mao Mao Yu, a branch of MySQL developer Brian Aker, has done a lot of rewriting, especially for multi-CPU, cloud, network applications and high concurrency.
A database system
PostgreSQL boasts of being the most advanced open source database in the world. Some PostgreSQL fans say that it is comparable to Oracle, and it is not so expensive and arrogant in customer service. It has a long history and was originally developed by the University of California at Berkeley at 1985 as the successor of Ingres database.
PostgreSQL is a completely community-driven open source project maintained by more than 1000 contributors worldwide. It provides a single, fully functional version, rather than multiple versions like MySQL.
Different community edition, business edition and enterprise edition. PostgreSQL is based on a free BSD/MIT license. Organizations can use, copy, modify and redistribute code, and only need to provide one ... >; & gt
What open source graphic databases are there at present?
The first is MariaDB, which is a branch version of MySQL with Maria storage engine. It is a free and open source database server developed by the company founded by Michael Widenius, the original author of MySQL. Compared with MySQL, MariaDB has more engines, including Maria storage engine, PBXT storage engine, XtraDB storage engine and FederatedX storage engine. It can replicate query processing faster, run faster, perform better functional tests, and support Unicode sorting.
Secondly, rcona, which improves the MySQL database server, has significantly improved its function and performance compared with MySQL. This version improves the performance of InnoDB under high load. At the same time, it also provides some very useful performance diagnostic tools for DBA, and provides many parameters and commands to control server behavior.
The third is Percona Server, which uses google-mysql-tools, ProveScaling and Open Query to transform mysql. Moreover, it only contains the server version of MySQL, and does not provide corresponding improvements to MySQL connectors and GUI tools.
What is an open source database?
Open source is unencrypted open source.
Open source database means that the database is not encrypted and the code is open.
The function of database is a website developed by dynamic language.
What open source POI databases are there?
There are many of them. Apache is definitely a leader in open source, such as: classified project name interpretation development language server (***20) Apache HTTP Server, the world's number one HTTP server C/C++ TomcatJava Web Server Java James Mail Server Java Spamassassin Anti-Spam C/C++Perlacache. ...
Introduce several good object-oriented databases, preferably open source.
db4o
Is there an open source implementation of Java connecting multiple databases?
1. If there are multiple data instances in MySQL, you can use schema.table when operating the database.
2. If MySQL database and other databases are used at the same time, you need to configure multiple data sources (it jobs) in Spring.
Which open source database should I choose? Which is better?
1.MySQL 5
As one of the most popular open source databases, MySQL database provides users with a relatively simple solution, which is suitable for a wide range of application deployments and can reduce the TCO of users. MySQL is a multi-threaded structured query language (SQL) database server. MySQL has high execution performance, fast running speed and easy to use.
MySQL includes the following main advantages:
Reliable performance and service MySQL provides the public with all the early versions of database server software, which were released for production after several months of open source testing.
Easy to use and deploy MySQL structured system is easy to customize and run quickly. Its unique multi-storage engine structure provides flexibility for enterprise customers, compactness and stability for database management system, and is easy to deploy.
◆ Free source code can access MySQL source code at any time, and its strategy ensures freedom and avoids locking in a company or platform.
◆ Cross-platform support MySQL can be used on more than 20 different platforms, including major Linux systems, Mac OS X, Unix and Windows.
◆ Reliable development power MySQL has a huge user base and a high-quality and experienced development team.
Meet the needs of enterprises MySQL structure system is easy to use, extremely fast, and can handle most of the application requirements of enterprise databases.
On February 8th, 65438, Sun Microsystems announced that it would officially provide MySQL 5. 1 software, which is an extremely important new version of MySQL, the most popular open source database in the world. MySQL version 5. 1 GA now provides the following three modes to meet the special needs of different users:
◆ Free and open source version of MySQL database of MySQL community server Sun. The target users of this full-featured software authorized by GPL are personal technical users, and do not need commercial support or enjoy preferential on-board service.
◆ MySQL enterprise server-it is provided as part of MySQL enterprise subscription. It is the most reliable and secure, providing the latest version of MySQL database, and the target users are IT users with legal person status. In this mode, users can get the fast software upgrade service every month and the "service package" of the latest patch every quarter-they can also access the monitoring tools for preview only and enjoy 24/7 production technical support.
◆ MySQL embedded server-This is a commercial licensing model of MySQL software, which allows ISVs and OEMs to embed or package a high-speed and small-space database into their products without free GPL license.
2. A database system
PostgreSQL is a fully functional open source object relational database management system (ORDBMS). At present, the stable version of PostgreSQL is version 8.4, which has rich characteristics and the characteristics of commercial database management system. This is a leap to a high-quality large-scale database management system. PostgreSQL is a distinctive open source database management system, and its features cover SQL-2/SQL-92 and SQL-3/SQL-99.
Rich data type PostgreSQL contains rich data type support, some of which are not even available in commercial databases, such as IP types and geometric types.
◆ Full-featured PostgreSQL is a full-featured open source software database, which fully supports features such as transaction, sub-query, multi-version parallel control system and data integrity check.
◆ Active development team PostgreSQL has an active development team. With their efforts, the quality of PostgreSQL is improving day by day, and people's confidence in using PostgreSQL is enhanced.
◆ Rich interfaces PostgreSQL supports almost all types of database client interfaces.
Supporting multi-platform PostgreSQL is one of the most supported database management systems at present, with more than a dozen platforms, including different systems and different hardware systems.
◆ Meet business needs ... >>