SAND CDBMS

This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these messages) The topic of this article may not meet Wikipedia's general notability guideline. Please help to demonstrate the notability of the topic by citing reliable secondary sources that are independent of the topic and provide significant coverage of it beyond a mere trivial mention. If notability cannot be shown, the article is likely to be merged, redirected, or deleted. Find sources: "SAND CDBMS" – news · newspapers · books · scholar · JSTOR (May 2017) (Learn how and when to remove this message) This article relies excessively on references to primary sources. Please improve this article by adding secondary or tertiary sources. Find sources: "SAND CDBMS" – news · newspapers · books · scholar · JSTOR (May 2017) (Learn how and when to remove this message) This article may require cleanup to meet Wikipedia's quality standards. The specific problem is: Non-wikified lists, lack of wikilinks, unsourced content, etc. Please help improve this article if you can. (May 2017) (Learn how and when to remove this message) (Learn how and when to remove this message)

SAND Nucleus CDBMS is a column-oriented DBMS software system optimized for business intelligence applications, delivering the data warehousing component, developed by SAND Technology Inc.

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^[1] on “Bit string compressor with boolean operation processing capability.”^[2]

Originally encoded on firmware, the application is now completely software based.

SAND Technology is now a division of N. Harris Computer Corporation.

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 64 bit Windows or the following 64 bit Linux/Unix environments: HP-UX, IBM-AIX, Red Hat Linux, SuSE Linux and Sun Solaris.

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.^[3] This provides an isolated environment for developing and testing changes to a database, where upon dismounting, the entire environment is removed.

• SAND Technology Inc. website