|
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. |
|
|
|
