Megabase: call accounting database
MegaBase is a flexible, relational, in-memory
database management system with special referential-access optimization.
Because the database is maintained in memory, it allows for fast data insertion (hundreds of records per second)
and for fast scanning (tens of thousands of records per second).
The MegaBase database system was originally developed to accomodate very large-volume
call traffic environments. As a result it provides mainframe-comparable performance from a micro-computer system.
Database Control
MegaBase has a "startup" that can be used whether or not other background
tasks are in operation. It provides different levels of "shutdown" to support different needs and activities.
Data is routinely backed up automatically, and restores are easy to perform when needed..
MegaBase also includes advanced database commands that allow such features as
viewing live processing of call records and sending database contents to an ASCII data file.
Database Definitions
A new MegaBase database is defined and created using the Database Definition Language
(DDL) and Utility (not provided with runtime-only licenses) that provides the following features:
The DDL allows a database schema to be defined, including which tables and fields
will be included in the database and their types and sizes. Table sizes, in terms of numbers of records, are initial
sizes. The actual size is determined in runtime.
Field types include:
- Alphanumeric text string
- Numeric
- Currency
- Binary-coded decimal
- Date and time stamp
- Duration
- Bit flag
- Pointer
Records can be populated with bit-oriented fields or byte-oriented fields.
Various table organizations are supported, including static sorted, freelist-linked
list, dynamically-allocated list and viewable virtual tables.
Data Manipulation
A data manipulation language (DML) interpreter provides low level access to the
database for adjusting field and record data, and provides the following features:
- Displays a list of collections of tables, a list of tables, a table's header,
a table's fields, the titles of a table's fields and the contents of a record.
- Selects a current record as first, last, next, and previous.
- Finds a record by key or by database record ID.
- Deletes, inserts or updates a record.
- Zaps all records in a table.
- Gets and puts values from fields into a record.
- Opens and closes tables.
- Locks and unlocks the database.
- Logs in and out of MegaBase.
Report Generation
A flexible, powerful report generator is included with MegaBase (see the Report Generator Product Data Page
for more details).
Data Import
The MegaBase database system provides a utility for importing ASCII flat files
into the database. The import itself is driven by a command language that specifies:
- The format of the data as fixed record format or delimited format
- Which MegaBase table or tables receive which ASCII flat file fields.
- Constant values, and which fields receive the values instead of data from ASCII
flat files.
- How to decode relational information from the input records.
- The number of input records to skip before loading, and a limit, if applicable,
on the number of records loaded.
- What action to take in the event of duplicate records and in the event of errors
during load.
|
