CUBRID

from Wikipedia, the free encyclopedia
CUBRID

logo
Basic data

developer NHN Search Solutions
Publishing year November 20, 2008
Current  version 10.1.3
( August 27, 2019 )
operating system Linux , Windows
programming language C.
category RDBMS
License GNU General Public License for the server engine and BSD license for APIs and user interface tools
German speaking No
www.cubrid.org
www.cubrid.com

CUBRID ( kjuːbrɪd ) is an open-source - SQL -based relational database management system developed by NHN Corporation for web applications . The name CUBRID is a combination of the English words for cube and bridge. The cube symbolizes the security aspect of CUBRID, while the bridge stands for a data bridge .

Licensing policy

Unlike other open source - DBMS no commercial software license, but an open-source license exists for CUBRID. There are separate licenses for the server engine and the interface . The engine is subject to the GNU GPL v2.0 or more recent versions of the license, which allows acquisition, distribution and modification. The programming interface and the graphical user interface are subject to the BSD license . This means that programs that are distributed in binary form and are based on CUBRID are not obliged to publish the source code . The reason for using two different licenses is to reduce barriers for ISVs to develop and distribute CUBRID based applications.

architecture

CUBRID is an object-relational database system that can be assigned to the three-tier architecture . The three components are a database server, a so-called connection broker and the CUBRID manager.

Database server

The database server is the core of the CUBRID database management system, as it is responsible for data storage and the execution of instructions . The server processes queries entered by the user and manages the objects within the database. With logging and locking mechanisms, several users can use the database at the same time. Database backups are also supported.

Connection broker

The broker is a CUBRID-specific middleware that is responsible for transferring the data from the database server to external applications. The main roles of this tier of service are:

  • Management of connections from client-side applications
  • Intermediate storage and forwarding of information
  • Syntax analysis of the queries, optimizations and the generation of execution plans

Since CUBRID is not tied to the same machine as the database server, CUBRID can take advantage of the hardware resources of several machines while the queries are performed on a database.

CUBRID Manager

The CUBRID Manager is a graphical user interface that manages the database and the connection broker. It contains an editor that allows the user to execute SQL queries on the database. The SQL syntax in CUBRID is very similar to MySQL and Oracle , since CUBRID complies with the SQL-92 standard. The 90 percent coverage with MySQL means that most SQL queries can be executed without modifications.

Functions

High availability

CUBRID High Availability, the built-in availability function, is one of the greatest advantages of CUBRID. It is based on transaction log replication and enables reliable failover and failback functions, based on CUBRID Heartbeat.

Database fragmentation

Since CUBRID 8.4.3, database fragmentation has been a built-in function in CUBRID. It allows the data to be distributed over several database instances. The fragmentation interface is implemented by a special broker called CUBRID SHARD. Since communication works in the same way as with a normal broker, the same programming interface can be used. The distribution logic of these horizontal fragments (also known as shards) resides in CUBRID SHARD, which determines which fragment should be used to store or load data.

performance

API level load balancing

Connection brokers can be assigned to four different modes (read-write, read-only, slave-only, preferred host read only). The list of the various hosts that the user has made available via the connection URL can be used to balance the load. When using this API level load balancing, the client API randomly selects one of the connection URLs, apart from the last used to connect. If the selected server is not available, the selection of a suitable server is continued until all servers are classified as inaccessible. In such a case the driver will display an error message.

Query plan caching

Query Execution Plan Cache is an implementation at the broker to skip compilation steps for frequently used queries. This process leads to an improvement in performance, as a cached evaluation plan can be shared between transactions, sessions and even different clients at the same time.

Easy development

To support the development of a project with CUBRID, many materials are provided by the developers. There are online and offline instructions, API documentation, release notes, tutorials and technology reviews.

There is an extended list of programming interfaces for CUBRID. There are drivers for PHP , PDO , Python , Perl , Ruby , ADO.NET , ODBC , OLE DB , JDBC , Node.js , NHibernate and the TCP / IP communication protocol .

Versions

version Release date Beta release date Additional
10.1 July 2017
9.3.0 5th June 2014
9.2.0 October 27, 2013
8.4.4 22nd August 2013
9.1.0 15 March 2013
9.0 October 2012 Internationalization support, function index, filter index, index skip scan, MERGE statement, window functions.
8.4.3 November 20, 2012 Database fragmentation , API level load balancing, integrated web manager with monitoring support
8.4.1 February 24, 2012 February 1, 2012 Performance optimizations , SQL extensions, REGEXP operator.
8.4.0 July 1, 2011 May 12, 2011 High availability improvements, CUBRID C API improvements, performance optimizations, global index
3.1 December 31, 2010 November 12, 2010 BLOB and CLOB support, High Availability Monitoring Support, driver ( JDBC , ODBC and CUBRID C API) improvements
3.0 4th October 2010 July 19, 2010 SQL enhancements, high availability improvements
2.2 April 30, 2010 High availability improvements, CUBRID C API improvements, increased performance
2.1 December 2009
2.0 August 2009
1.4 March 2009
1.3 February 2009
1.2 January 2009
1.1 November 2008 CUBRID becomes an open source project
1.0 October 2008 First stable version

Applications

The following applications and websites are based on CUBRID:

See also

Portal: Free Software  - Overview of Wikipedia content on the subject of Free Software

Individual evidence

  1. ↑ github.com . (accessed on September 6, 2019).
  2. ↑ CUBRID License . Archived from the original on January 16, 2013. Info: The archive link was inserted automatically and has not yet been checked. Please check the original and archive link according to the instructions and then remove this notice. Retrieved June 13, 2014. @1@ 2Template: Webachiv / IABot / www.cubrid.org
  3. ^ CUBRID Architecture . In: CUBRID . Retrieved June 13, 2014.
  4. ↑ a b CUBRID Important facts about CUBRID . Archived from the original on June 26, 2014. Info: The archive link was inserted automatically and has not yet been checked. Please check the original and archive link according to the instructions and then remove this notice. Retrieved June 13, 2014. @1@ 2Template: Webachiv / IABot / www.cubrid.org
  5. ↑ CUBRID HA . Retrieved June 13, 2014.
  6. ↑ CUBRID database fragmentation . Retrieved June 13, 2014.
  7. ↑ CUBRID 8.4.3 API level load balancing . In: CUBRID Blog . November 20, 2012. Retrieved June 13, 2014.
  8. ↑ Shared Query Plan Caching in CUBRID . Archived from the original on June 22, 2014. Info: The archive link was automatically inserted and has not yet been checked. Please check the original and archive link according to the instructions and then remove this notice. Retrieved June 13, 2014. @1@ 2Template: Webachiv / IABot / www.cubrid.org
  9. ↑ CUBRID functions . Retrieved June 13, 2014.
  10. ↑ CUBRID Wiki APIs . Archived from the original on June 26, 2014. Info: The archive link was inserted automatically and has not yet been checked. Please check the original and archive link according to the instructions and then remove this notice. Retrieved June 13, 2014. @1@ 2Template: Webachiv / IABot / www.cubrid.org
  11. ↑ New CUBRID 9.0.0 . CUBRID Official Blog. October 30, 2012. Retrieved November 8, 2012.
  12. ↑ CUBRID 8.4.3 with DB Sharding and API level Load Balancing is here . CUBRID Official Blog. November 20, 2012. Retrieved December 25, 2012.
  13. ↑ New CUBRID 8.4.1 is 70% faster . CUBRID Official Blog. February 1, 2012. Retrieved February 2, 2012.
  14. ↑ CUBRID 8.4.0 has arrived w / x2 faster database engine! . CUBRID Official Blog. May 13, 2011. Archived from the original on May 20, 2011. Info: The archive link was inserted automatically and has not yet been checked. Please check the original and archive link according to the instructions and then remove this notice. Retrieved May 17, 2011. @1@ 2Template: Webachiv / IABot / blog.cubrid.org
  15. ↑ CUBRID 8.4.0 GA is now available for download . CUBRID Official Blog. July 4, 2011. Archived from the original on August 25, 2011. Info: The archive link was automatically inserted and not yet checked. Please check the original and archive link according to the instructions and then remove this notice. Retrieved July 14, 2011. @1@ 2Template: Webachiv / IABot / blog.cubrid.org
  16. ↑ CUBRID 3.1 Stable is now available! . CUBRID Official Blog. December 31, 2010. Archived from the original on January 7, 2011. Info: The archive link was automatically inserted and not yet checked. Please check the original and archive link according to the instructions and then remove this notice. Retrieved January 3, 2011. @1@ 2Template: Webachiv / IABot / blog.cubrid.org
  17. ↑ CUBRID 3.0 Stable has arrived! . CUBRID Official Blog. October 4, 2010. Archived from the original on October 8, 2010. Info: The archive link was automatically inserted and not yet checked. Please check the original and archive link according to the instructions and then remove this notice. Retrieved October 5, 2010. @1@ 2Template: Webachiv / IABot / blog.cubrid.org
  18. ↑ New CUBRID 2008 R3.0 Beta has been released . CUBRID Official Blog. July 20, 2010. Archived from the original on August 27, 2011. Info: The archive link was automatically inserted and not yet checked. Please check the original and archive link according to the instructions and then remove this notice. Retrieved July 21, 2010. @1@ 2Template: Webachiv / IABot / blog.cubrid.org
  19. ↑ New Version Release - CUBRID 2008 R2.2 . CUBRID Official Blog. Archived from the original on July 25, 2011. Info: The archive link was inserted automatically and has not yet been checked. Please check the original and archive link according to the instructions and then remove this notice. Retrieved May 7, 2010. @1@ 2Template: Webachiv / IABot / blog.cubrid.org
  20. ↑ How to simulate MySQL INSERT statement extensions . Lukas Eder. May 15, 2012. Retrieved February 4, 2013.
  21. ↑ SOFA Statistics . sofastatistics.com. November 20, 2012. Retrieved November 17, 2010.
  22. ↑ Sidu Incredibly Simple Intuitive Web Based SQL client . sidu.sourceforge.net. May 25, 2012. Retrieved February 4, 2013.
  23. ^ ART Simple Yet Effective Open Source Reporting Tool . art.sourceforge.net. June 10, 2012. Retrieved February 4, 2013.
  24. ↑ Package scriptella.driver.cubrid . Retrieved February 11, 2013.
  25. ↑ Run Your Own Whois Server With JWhoisServer . Klaus Zerwes. July 6, 2012. Retrieved February 4, 2013.
  26. ↑ RedBeanPHP Super Easy to Use PHP ORM . redbeanphp.com. July 8, 2012. Archived from the original on March 29, 2013. Info: The archive link was automatically inserted and not yet checked. Please check the original and archive link according to the instructions and then remove this notice. Retrieved February 4, 2013. @1@ 2Template: Webachiv / IABot / redbeanphp.com

Web links