GDBase is a database built into the AdvancedMiner system compliant with the ANSI-SQL standard. GDBase implements most features of the SQL-92 standard. Transactions are atomic, consistent, isolated and durable (ACID) even after system crashes and power failures. GDBase supports triggers and the most complex queries.
GDBase was designed as a part of the AdvancedMiner system and is tailored for data-mining and analytic tasks. It is based on the SQLite relational database management system.While AdvancedMiner supports many types of databases, only GDBase is fully supported.
The key advantages of GDBase include:
the ability to set up the database in a directory on the local hard drive as well as through a network connection with a remote server;
an integreted "row-by-row" processing language based on Python;
built-in library of string, numeric, date and time, and aggregate functions;
no limitations on the size of tables - GDBase was tested with tables as large as 320GB;
the ability to work with huge number of columns - GDBase was tested with tables containing up to 100 000 columns.
This document is intented mainly as a reference for GDBase users. Occasionally, hints and usage tricks are provided in the form of examples. GDBase is based on the SQLite relational database management system, but in some areas the functionality has been significantly changed. Most sections of this document are devoted to the details of how SQL is implemented in GDBase. Other points worth indicating are:
How to set up GDBase from the AdvancedMiner client is described in the GDBase setup section.
Security and administartion topics are described in the GDBase Administration chapter.
Methods of transfering data to and from other databases are described in the Importing and Exporting Data chapter.
The use of Python/Gython for processing data is decribed in the CREATE TABLE ... TRANSFORM section.
Built-in functions are described in the Core Functions section.