- CUBRID
-
CUBRID Developer(s) Search Solutions Written in C, C++ Operating system Cross-platform Available in English, Korean, Japanese, Chinese Type RDBMS License GNU General Public License for server engine and BSD license for APIs and CUBRID Manager tool Website www.cubrid.org CUBRID is a comprehensive open source relational database management system (RDBMS) highly optimized for Web applications, especially when complex business services process large amount of data and generate huge concurrent requests. By providing unique optimized features, CUBRID enables to process much more parallel requests at much less response time.[1]
In CUBRID users can create unlimited number of databases, tables, and rows. There can be 6400 columns in each row, and the length of a column name is limited to 254 characters. Users can also insert unlimited size BLOB / CLOB data into a CUBRID table.[2]
Contents
License Policy
CUBRID has a separate license for its server engine and its interfaces. The server engine adopts the GPL v2.0 or later license, which allows distribution, modification, and acquisition of the source code. The API interfaces have the Berkeley Software Distribution license in which there is no obligation of opening derivative works. The reason of adopting two separate license systems is that CUBRID does not want to create any limitations to Independent software vendors (ISV) for developing and distributing various CUBRID based applications.
The CUBRID license policy is different from that of other vendors. To distribute or sell MySQL applications, it is required to open the source code of applications or to purchase commercial license. However, CUBRID has two different license policies for interface and server to address the limitations of the traditional open source DBMS and provide excellent cost savings to companies.[3]
Product Name Origin
The name "CUBRID" is a combination of two words "Cube" and "Bridge".[citation needed] In case of CUBRID, "Bridge" stands of the "data bridge", while "Cube" is a sealed box which provides security for its contents. Thus, CUBRID means a secure software which holds sensitive information.[citation needed]
Platforms and Interfaces
The CUBRID server and official libraries are implemented in C and C++, while CUBRID Manager[4], the CUBRID database administration tool, is implemented in Java. All CUBRID Tools are developed at [Sourceforge.net http://sourceforge.net/projects/cubridtools/].
CUBRID runs on Linux and Microsoft Windows platforms and provides language-specific APIs, including JDBC, PHP, ODBC, Ruby, Python and C-API. All CUBRID Interfaces are developed at [Sourceforge.net http://sourceforge.net/projects/cubridinterface/].
In addition, CUBRID provides command-line interface called CSQL[5]. There is also a web-based database administration tool CUBRID WebQuery[6].
Supported Features
The latest version as of November 2010 is CUBRID 2008 R3.1 Beta, which supports the following features[7]:
- SQL 92 Standard
- Transaction ACID support
- Cross-platform support
- Multiple granularity locking
- Partition
- Replication
- High Availability support (shared-nothing clustering, fail-over and fail-back automatically) and monitoring tools
- Hot Backup
- Sub-SELECTs (i.e. nested SELECTs)
- Hierarchical Queries
- Query plan caching
- Triggers
- Counter
- Updatable Views
- Java Stored procedures
- True varchar support
- Cursors
- Unlimited size BLOB and CLOB data types1
- HA Monitoring Tool
- Covering Index
Note (1): Only CUBRID and Oracle provide unlimited size BLOB/CLOB feature.
Product Development History
- July 1, 2011 - CUBRID 8.4.0 Stable release[8]
- May 12, 2011 - CUBRID 8.4.0 Beta release[9]
- December 31, 2010 - CUBRID 3.1 Stable release[10]
- November 12, 2010 - CUBRID 3.1 Beta release[11]
- October 4, 2010 - CUBRID 3.0 Stable release[12]
- July 19, 2010 - CUBRID 2008 R3.0 Beta release[13]
- April 30, 2010 - CUBRID 2008 R2.2 stable release[14].
- February, 2010 - CUBRID Cluster alpha version was released.
- December, 2009 - CUBRID 2008 R2.1 stable release.
- October, 2009 - CUBRID Project web site lunched at Sourceforge.net. Opened Official Open Source Community web site at www.cubrid.org.
- September, 2009 - CUBRID Cluster Project has been started.
- August, 2009 - CUBRID 2008 R2.0 stable release.
- March, 2009 - CUBRID 2008 R1.4 stable release.
- February, 2009 - CUBRID 2008 R1.3 stable release.
- January, 2009 - CUBRID 2008 R1.2 stable release.
- November, 2008 - CUBRID became an open source project. CUBRID 2008 R1.1 stable was released.
- October, 2008 - First internal release followed by CUBRID 2008 R1.0 stable release.
- 2006 - The development of CUBRID DBMS started.
See also
- Comparison of relational database management systems
- Comparison of object-relational database management systems
- List of relational database management systems
Other RDBMS:
- Comparison of relational database management systems
- Drizzle
- Firebird (database server)
- HSQLDB
- MySQL
- Ingres (database)
- PostgreSQL
References
- ^ "About CUBRID". CUBRID.org. http://www.cubrid.org/about. Retrieved 2010-09-27.
- ^ "CUBRID RDBMS Size Limits". CUBRID.org. 2011-03-22. http://www.cubrid.org/cubrid_size_limits. Retrieved 2011-03-22.
- ^ "Meet CUBRID: One of Korea’s Top Open Source Projects". Open Source Buzz. 2010-06-21. http://opensourcebuzz.technetra.com/2010/06/21/meet-cubrid-one-of-koreas-top-open-source-projects/. Retrieved 2010-10-05.
- ^ "CUBRID Manager". CUBRID.org. http://www.cubrid.org/cubrid_manager. Retrieved 2011-01-03.
- ^ "CSQL - Command Line SQL Interpreter". CUBRID.org. 2010-07-06. http://blog.cubrid.org/cubrid-story/csql-interpreter/. Retrieved 2010-09-27.
- ^ "CUBRID WebQuery". CUBRID.org. http://www.cubrid.org/about_cubrid_web_query. Retrieved 2010-11-17.
- ^ "CUBRID Key Features". CUBRID.org. http://www.cubrid.org/key_features. Retrieved 2010-09-27.
- ^ "CUBRID 8.4.0 GA is now available for download". CUBRID Official Blog. 2011-07-04. http://blog.cubrid.org/news/cubrid-8-4-0-ga-is-now-available-for-download/. Retrieved 2011-07-14.
- ^ "CUBRID 8.4.0 has arrived w/ x2 faster database engine!". CUBRID Official Blog. 2011-05-13. http://blog.cubrid.org/news/cubrid-8-4-0-has-arrived-w-x2-faster-database-engine/. Retrieved 2011-05-17.
- ^ "CUBRID 3.1 Stable is now available!". CUBRID Official Blog. 2010-12-31. http://blog.cubrid.org/news/cubrid-3-1-stable-is-now-available/. Retrieved 2011-1-3.
- ^ "CUBRID 3.1 Beta: New Data Types. New Functions.". CUBRID Official Blog. 2010-11-12. http://blog.cubrid.org/news/cubrid-3-1-beta-new-data-types-new-functions/. Retrieved 2010-11-17.
- ^ "CUBRID 3.0 Stable has arrived!". CUBRID Official Blog. 2010-10-04. http://blog.cubrid.org/news/cubrid-3-0-stable-has-arrived/. Retrieved 2010-10-05.
- ^ "New CUBRID 2008 R3.0 Beta has been released". CUBRID Official Blog. 2010-07-20. http://blog.cubrid.org/notice/new-cubrid-2008-r3-0-beta-has-been-released/. Retrieved 2010-07-21.
- ^ "New Version Release - CUBRID 2008 R2.2". CUBRID Official Blog. http://blog.cubrid.org/notice/new-version-release-cubrid-2008-r2-2/. Retrieved 2010-05-07.
External links
Categories:- Open source database management systems
- Cross-platform software
- SQL
Wikimedia Foundation. 2010.