| D3
M U L T I -V A L U E D A T A B A S E
Raining
Data's D3 multi-value database, also known as a
multidimensional database, has many advanced features including:
| Unlimited
DBMS |
Files
may consist of an unlimited number of records. Records
may have up to two billion fields. Fields may be up to
2GB (numeric or string). A process may open up to 32,000
files. System-wide, open files are unlimited.
|
| Dynamic
DBMS |
Fields
can change dynamically, thus having no length or data type
restrictions. Restructuring is not required when fields
are added. |
INTEGRATED
DATA
| Dictionaries
|
Field
definitions are stored in an integrated data dictionary
providing for conversions, formatting and self-documentation.
Multiple definitions may be used on all fields. The dictionaries
also provide the interface for database triggers.
|
| Multi-value
DBMS |
Transcending
the limitations of the two-dimensional relational model,
the Pick multi-value data model adds additional
dimensions to reflect true business data modeling. These
multi-values along with their possible sub-values and associated-multi-values
permit the stacking of data and/or keys within a field or
fields. This eliminates the need for dependent tables and
joins. |
DATA
ACCESS
| AQL™
|
The
D3 Access Query Language is an English-like
query and command language. It is most powerfully used
for creating result sets and reports. |
| Applications
|
The
D3 development tools are intimately knowledgeable
of the multi-value data structure, which facilitates rapid
development without needing to deal with low-level functions.
D3 also has multiple avenues to move or access
data including OSFI (Open System File Interface which allows
connectivity to other databases and file systems), SQL/ODBC,
VBSQL, D3 ActiveX development class libraries
and more. |
FILE
SYSTEM
| Disk
|
The
File System may reside on top of a group of host-system
files or on a raw storage device for maximum performance.
Additional storage devices may be added at any time without
rebuilding the D3 database. |
| Rapid
Data Access |
A
hashed indexing scheme on primary record keys assures access
to data elements with a minimum of disk reads regardless
of database size. This D3 distributed disk management
enhances performance. |
| Secondary
Indexing |
Cross-indexing
is supported for fast access to records via secondary keys.
B-tree index maintenance and synchronization is performed
automatically by the system during all updates. |
| On-line
File Resizing |
An
online file resizing utility is provided to keep files in
an optimal state without interrupting processing or user
access to data. |
SYSTEM
| Security
|
Multilevel
security supports user and account passwords and file
access restrictions. |
| Memory
|
Through
shared program object code usage and virtual memory management,
D3 requires as little as 1/5 the memory per user
of other database products. |
| Portability
|
Complete
portability between versions of D3 makes data
and programs transportable between development and various
production systems. |
|
|
