SAND CDBMS
Encyclopedia
SAND CDBMS is a column-oriented DBMS
software system optimized for business intelligence
applications, delivering the data warehousing
component, developed by SAND Technology Inc.
SAND CDBMS traces its roots to developments by Nucleus International Corporation research and eventual patent issued to, among others, Edward L. Glaser on “Bit string compressor with boolean operation processing capability.””
Originally encoded on firmware, the application is now completely software based.
This architecture exhibits the following characteristics:
- All columns act as if they are indexed
- Actual data values are stored only once and referenced by their token
- Columns use lossless data compression when stored
- Only columns requested in a query are accessed from the database
- Queries are done directly on the compressed columns and only the result set is decompressed.
Platform agnostic, SAND CDBMS runs on 32 and 64 bit Windows or the following 64 bit Linux/Unix environments:
Database space allocation and core management are done by the database engine. This means typical database administration is focused on data modeling, data content, managing the data life cycle and managing the user profiles and access permissions.
Data loading is straight forward and only requires pointing to the source and destination in load scripts. There are multiple data manipulation functions and commands available, but all internal structure optimizations are automatically managed by the database engine.
While data load performance can be slower than row based databases, it is mitigated by not having to build any indexes or run post-load administration routines once complete. Parallel load processing or segmented pre-load processing can also be used to improve load performance.
A core feature of SAND CDBMS is its support of “virtual” mounting of a database ””. This provides an isolated environment for developing and testing changes to a database, where upon dismounting, the entire environment is removed.
Column-oriented DBMS
A column-oriented DBMS is a database management system that stores its content by column rather than by row. This has advantages for data warehouses and library catalogues where aggregates are computed over large numbers of similar data items....
software system optimized for business intelligence
Business intelligence
Business intelligence mainly refers to computer-based techniques used in identifying, extracting, and analyzing business data, such as sales revenue by products and/or departments, or by associated costs and incomes....
applications, delivering the data warehousing
Data warehouse
In computing, a data warehouse is a database used for reporting and analysis. The data stored in the warehouse is uploaded from the operational systems. The data may pass through an operational data store for additional operations before it is used in the DW for reporting.A data warehouse...
component, developed by SAND Technology Inc.
Company History
SAND Technology was founded in 1983.SAND CDBMS traces its roots to developments by Nucleus International Corporation research and eventual patent issued to, among others, Edward L. Glaser on “Bit string compressor with boolean operation processing capability.””
Originally encoded on firmware, the application is now completely software based.
Description
A fully tokenized, bit array encoded and compressed database, data storage is column-oriented using domains across schemas/tables rather than as rows of data within tables. This results in an optimized platform for data analytics and data mining, although not suitable for transaction processing.This architecture exhibits the following characteristics:
- All columns act as if they are indexed
- Actual data values are stored only once and referenced by their token
- Columns use lossless data compression when stored
- Only columns requested in a query are accessed from the database
- Queries are done directly on the compressed columns and only the result set is decompressed.
Platform agnostic, SAND CDBMS runs on 32 and 64 bit Windows or the following 64 bit Linux/Unix environments:
- HP-UX
- IBM-AIX
- OSF/1
- Red Hat Linux
- SuSE Linux
- Sun Solaris
Administration
SAND/DNA Analytics is managed via ANSI standard SQL and DML commands.Database space allocation and core management are done by the database engine. This means typical database administration is focused on data modeling, data content, managing the data life cycle and managing the user profiles and access permissions.
Data loading is straight forward and only requires pointing to the source and destination in load scripts. There are multiple data manipulation functions and commands available, but all internal structure optimizations are automatically managed by the database engine.
While data load performance can be slower than row based databases, it is mitigated by not having to build any indexes or run post-load administration routines once complete. Parallel load processing or segmented pre-load processing can also be used to improve load performance.
A core feature of SAND CDBMS is its support of “virtual” mounting of a database ””. This provides an isolated environment for developing and testing changes to a database, where upon dismounting, the entire environment is removed.