Topics: Database, SQL, Database management system Pages: 6 (1422 words) Published: September 16, 2013
Casestudy: cubeSQL

Greggy G. Conti
Technological Institute of the Philippines
#26M lantana St. Cubao
Quezon City

Michael Angelo A. Esteves
Technological Institute of the Philippines
# 12A Samat Rd. Garcia
HTS Luzon Ave.
Quezon City

Jerick C. Pascua
Technological Institute of the Philippines
#6575 384 Shoe Avenue Conception., Marikina City

1.1 History of cubeSQL

Italian developer SQLabs has unveiled CubeSQL, a full-featured sqlite-based relational database management system (RDMS) that is intended as an affordable way for developers to create applications reliant on multiuser database connections. The program runs on all three major platforms, can be embedded into iOS and Cocoa applications, and is easily accessed with any JSON client, PHP, native C SDK and even with what the developer describes as a "highly optimized" RealStudio plug-in.

The CubeSQL database management system is fast with a small footprint, uses strong AES encryption, is multi-core and multi-processor aware, fully ACID compliant, supports unlimited connections, sqlite 3 databases and databases up to 2TB in size. It features automatic logging and compression, restore and backup support, runs native in either 32- or 64-bit environments and offers full support for triggers and transactions, with multi-version currency control. The platform-independent storage engine supports plug-ins for extending the SQL language and custom commands that are supported by the server, and includes a journal engine for crash recovery.

The CubeSQL Developer Edition is completely free of charge, enabling developers to create an application on the program without any fees until they are ready to deploy. Commercial licenses start at $300. The program requires either Mac OS X 10.5 or higher (universal for PPC or Intel), Windows XP or higher or Linux kernel version 2.6.2 or higher. A free download is available from the company website.

2. Description/Overview of cubeSQL
cubeSQL is a fully featured and high performance relational database management system built on top of the sqlite database engine. We developed the first commercial grade DBMS based on sqlite back in 2005 and over the years we continued to improve our server to better suit all our customer's needs. cubeSQL is the final result of all our efforts.

It is the ideal database server for both developers who want to convert a single user database solution to a multi-user project and for companies looking for an affordable, easy to use and easy to maintain database management system.

cubeSQL is incredibly fast, has a small footprint, is highly reliable and runs on Windows, Mac and Linux (32 bit and 64 bit for all platforms). cubeSQL can be accessed with PHP, JSON, REAL Studio and with the native C SDK.

3. Features And Functionalities
cubeSQL is fully ACID compliant. ACID stands for atomic, consistent, isolated, and durable and it deals with reliability of database transactions. This is important because it means that you don't have to worry about users accessing the database in an unfinished state. Users can't see changes that are being made but have not been committed. If the server loses power or crashes in the middle of a transaction, the server is restored to its untouched state automatically. ACID compliance is critical to any database you depend on. Database triggers enable DBSA's (Database Administrators) to create additional relationships between separate tables. For example, the modification of a record in one table could trigger the modification of a record in a second table. cubeSQL supports the creation of triggers that can execute when rows are inserted, updated or deleted on a table by table basis.

The cubeSQL Admin application has an all new, easy to use and intuitive interface with far more functionality than ever before....
Continue Reading

Please join StudyMode to read the full document

Become a StudyMode Member

Sign Up - It's Free