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 at present, 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 can't cope with Web2.0 websites, especially the super-large and highly concurrent SNS web2.0 pure dynamic website, which exposes many insurmountable problems, while the non-relational database develops very rapidly due to its own characteristics.

The first recommendation is Oracle NoSQL database, which is a community version. Oracle Bone Inscriptions's NoSQL database is one of the components of the big data device published in Oracle Bone Inscriptions Global Book on June 4th, 65438. Big data machine is a system that integrates Hadoop, NoSQL database, Hadoop adapter of Oracle database, Hadoop Loader of Oracle database and R language.

The second recommendation is Membase. Membase is a heavyweight new member of NoSQL family. Membase is an open source project, the source code is authorized by Apache2.0, and the project is hosted on GitHub. Source tarballs, you can download the beta version of Linux binary package at present. The product was mainly developed by members of the memcached core team of North Scale, including engineers from two major contributors, Zynga and NHN, both of which are providers of online games and community cyberspace.

In addition, Membase is easy to install and operate, and can be easily extended from a single node to a cluster. Moreover, the plug-and-play function of memcached (wired protocol compatibility) is realized, which provides a lower threshold for developers and operators in application. Memcached, as a caching solution, has been widely used in different types of fields (especially large-capacity Web applications), and some basic codes of Memcached have been directly applied to the front end of Membase server. Membase is compatible with various programming languages and frameworks and has good reusability. In terms of installation and configuration, Membase provides an effective graphical interface and programming interface, including configurable alarm information.

The goal of Membase is to provide external linear scalability, including replication of unified nodes, to increase cluster capacity. In addition, the stored data still needs to be redistributed.

The third recommendation is Shibari. Hibari, which means "lark" in Japanese, is a database engine specially designed for high reliability and big data storage, and can be used in cloud computing environments, such as webmail and SNS, which need T/P data storage. Hibari also supports clients in Java, C/C++, Python, Ruby and Erlang languages.

The fourth recommendation is memcachedb B, an open source project opened by developers in Sina.com. Berkeley DB's persistent storage mechanism and asynchronous primary and secondary replication mechanism are added to memcached distributed cache server, which makes memcached have transaction recovery ability, persistence ability and distributed replication ability, and is very suitable for application scenarios that require ultra-high performance reading and writing speed, but have no strict transaction constraints, such as applying Memcached to Sina blog.

The fifth recommendation is Leveldb. This is a very efficient kv database implemented by Google, and the current version of 1.2 can support billions of data. On this order of magnitude, it still has very high performance, which is mainly due to its good design, especially LSM algorithm. LevelDB is a single-process service with very high performance. On four Q6600 CPU machines, the data written per second exceeds 40w, while the performance of random reading exceeds 10w per second.

Advantages of XML database

XML database is a data management system, which supports the storage and query of documents in XML format. In this system, developers can query, export and serialize XML documents in the database. At present, there are three types of XML databases: XMLEnabledDatabase(XEDB), which can process XML; NativeXMLDatabase(NXD), that is, pure XML database; HybridXMLDatabase(HXD), that is, hybrid XML database.

The first generation of XML support in relational databases is to segment (or decompose) documents to fit relational tables, or to store documents as characters or binary large objects (CLOB or BLOB) intact. Both methods try to transform the XML model into a relational model. However, these two methods have great limitations in function and performance. The hybrid model stores XML in a DOM-like model. XML data is formatted as a buffered data page for quick navigation, query execution and simplified indexing.

The first XML database recommended here is Sedna. It claims to be an original ecological XML database, providing full-featured core database services, including persistent storage, ACID transactions, indexing, security, hot standby, UTF8 and so on. The W3C XQuery specification is implemented, which supports full-text search and node-level update operations.

The second XML database is BaseX. The database is used to store compact XML data, which provides efficient implementation of XPath and XQuery, and also provides a front-end operation interface.

Inventory: those free database software in the open source community.

The third recommendation is XMLDB. This database uses a relational database to store arbitrary XML documents. Because of the storage mechanism adopted, the search speed of documents is particularly fast, and the XSL transformation is also quite fast. XMLDB also provides a PHP module that can be used in Web applications.

The fourth recommendation is X-Hive/DB. This is a powerful dedicated XML database designed for software developers who need advanced XML data processing and storage functions. The X-Hive/DB Java API contains methods for storing, querying, retrieving, transforming and publishing XML data.

Compared with the traditional relational database, XML database has the following advantages: First, XML database can effectively access and manage semi-structured data. For example, web content is a kind of semi-structured data, and traditional relational databases cannot manage semi-structured data as effectively as web content. Second, provide operations on labels and paths. Traditional database languages allow data element values to be manipulated, but not element names. Semi-structured database provides operations on label names, including operations on paths. Thirdly, when the data itself has hierarchical characteristics, because the XML data format can clearly express the hierarchical characteristics of the data, the XML database is convenient to operate the hierarchical data. XML database is suitable for managing data sets with complex data structures. If the information has been stored in XML format, XML database is beneficial to the storage and retrieval of documents. It can search documents in a convenient and practical way and provide a high-quality full-text search engine. In addition, XML database can store and query heterogeneous document structures and provide support for heterogeneous information access.