Changes for version 0.67 - 2006-10-22

  • Added SQLTest for simple, log-based scripted testing.
  • SQL scalar functions: fixes for crypt, pack, sprintf, rindex, int, log.
  • Added lpad, ltrim, rpad, rtrim, translate, replace, soundex.
  • Added mod, power, round, sign, trunc, logN.

Documentation

Generate SQL Parser
line mode for Genezzo database system
Genezzo database exporter

Modules

an extensible database with SQL and DBI
Row Directory Block Array interface
Row Directory Block Adjunct tied hash class. This class adds array-like splice capabilities to Genezzo::Block::RDBlock. Genezzo::Block::RDBArray uses this class as the basis of a tied array.
Row Directory Block Not Null (array) tied hash class.
Row Directory Block tied hash class. A class that lets you treat the contents of a block (byte buffer) as a hash.
row directory
Standard Block
Block Utility functions
A simple in-memory buffer cache for multiple files for a single process, without locking.
A simple in-memory buffer cache for a single process, without locking.
Buffer Cache Element
Detect modifications to scalar
detect destruction of scalar
The Genezzo data dictionary
an extensible database with SQL and DBI
Cry Havok! And Let Slip the Dogs of War!
some basic functions
debug functions
some example havok functions
some example havok functions
scalar SQL functions
load the SysHook table
load the UserExtend table
load the user_functions table
basic btree
persistent btree
btree Hash tied hash class. Makes a persistent btree based upon Genezzo::Block::RDBlock look like a conventional hash.
SQL parser
Parsing, Planning and Execution
Convert a SQL parse tree to relational algebra
Perform checks on relational algebra representation
Perform checks on relational algebra representation
a 90% pure virtual class module that extends hierarchical "push hash" Genezzo::PushHash::hph with Row/Block methods. These methods facilitate the construction of classes that manipulate data blocks directly, such as index access methods and functions that split rows over multiple blocks..
Push Hash Array implementation
fixed-size push hash
Push Hash that only supports delete and insert
an impure virtual class module that defines a "push hash", a hash that generates its own unique key for each value. Values are "pushed" into the hash, similar to pushing into an array.
an impure virtual class module that defines a *hierarchical* "push hash", a hash that generates its own unique key for each value. Values are "pushed" into the hash, similar to pushing into an array. Hierarchical pushhashes must be supplied with a factory method which manufactures additional pushhashes as necessary.
Genezzo Raw IO
Row Source Block
Row Source Dual (single row) table
Row Source Expression Evaluation
Row Source File tied hash class.
Row Source InDeX tied hash class. A hierarchical pushhash (see Genezzo::PushHash::hph) class that stores a pushhash as a btree via Genezzo::Row::RSTable.
Row Source Expression Evaluation
Row Source TABle tied hash class.
Extent Space Management
File Space Management
FreeBlock Space Management
Extent Space Management
Table Space Hash
a class that defines a tablespace, the relationship between a collection of files on disk and a set of tables in the dictionary.
Test SQL scripts
setup functions for testing
Utility functions
Execution and Expression Evaluation
Perform checks on relational algebra representation
perform DDL ALTER

Provides

in lib/Genezzo/GenDBI.pm
in lib/Genezzo/Index/bt2.pm
in lib/Genezzo/Row/RSDual.pm
in lib/Genezzo/Row/RSExpr.pm
in lib/Genezzo/Row/RSJoinA.pm
in lib/Genezzo/Row/RSTab.pm
in lib/Genezzo/Row/RSIdx1.pm
in lib/Genezzo/TSHash.pm
in lib/Genezzo/Index/btHash.pm
in lib/Genezzo/Parse/SQL.pm