What is SAND Nucleus CDBMS?

"A world class Enterprise Analytic Database, the SAND Platform is a patented columnar database management system (CDBMS) delivering optimal performance for every user. "

SAND CDBMS is an Analytics database optimized for data mining, statistical analysis, pattern identification, and ad hoc queries.

SAND is a software-based solution designed to do more with less – using intelligence to deliver operational efficiency rather than brute strength. The ‘Load and Go’ operation gives business users access to data immediately without the need for extensive database design and performance tuning requirements. SAND databases have a small footprint due to data compression and can run on low-cost commodity hardware. Simple access via standard SQL and ODBC/JDBC allow existing front-end applications to perform high volume complex SQL queries with ease.

Column Based

  • Data is decomposed into individual columns with vertical partitioning
  • Column orientation is well suited to analytic operations
  • Only the columns involved in a query are used

Tokenization

  • Each data value is tokenized and stored only once within a domain of unique values
  • Reduces the amount of data stored
  • Separates the data from its use

Bit Vector Encoding

  • Each occurrence of each value has a unique position in a "bit vector"
  • Columns are represented as a compressed set of run length encoded bit vectors

Boolean Logic

  • Data operations are Boolean operations on encoded bit vectors
  • Bit vectors are never decompressed

SAND Nucleus CDBMS scored 58/100 in the Analytics category. This is based on press buzz (28/100), recent user trends (falling), and other relevant information on SAND Nucleus CDBMS gathered from around the web.

The score for this service has improved over the past month. What is this?

  • SAND Nucleus CDBMS

SAND Nucleus CDBMS Product Overview

  • The ability to export data to SCT (Sand Compressed Table) and Parquet file formats, providing excellent compression compared to flat file format, and faster re-load times.

  • The use of SAND Domains, tokens, and compression resulting in a small database footprint.

  • Low overhead for DBA administration, with few knobs to turn for a basic setup.

  • Excels at ad-hoc analytics on large datasets, with our column-aware query optimizer enabling the best possible plan for any query submitted.

  • Automatically 100% indexed—all the time—by way of the database's internal structure.

  • A database that's load-and-go with minimal configuration


Languages: English
THE ULTIMATE Software Buyer Guide 2018

The Ultimate Analytics Software Buyer Guide 2018

Product recommendations, vendor rankings, market overview and tips on how to select Analytics software for business. Published in September 2018.

Businesses today gather large volumes of data, ranging from customer information to something as basic as the client location. The process of converting the data into actionable information is called analytics. Analytics software analyzes each bit of data y...

FREE DOWNLOAD

SAND Nucleus CDBMS Features

  • 2-Factor Authentication
  • A/B Testing
  • Analytics
  • API
  • Batch Permissions & Access
  • Big Data
  • Calendar Management
  • Contact Management
  • Conversion Tracking
  • Customer Management
  • Dashboard
  • Data Export
  • Data Import
  • Data Mining
  • Data Visualization
  • External Integrations
  • File Sharing
  • File Transfer
  • Forecasting
  • Inventory Tracking
  • Keyword Tracking
  • Link Tracking
  • Multi-Site
  • Multi-User
  • Notifications
  • Project Management
  • Referral Tracking
  • Scheduling
  • SEO
  • Supplier Management
  • Third-Party Plugins/Add-Ons

SAND Nucleus CDBMS FAQs

Does SAND Nucleus CDBMS offer guides, tutorials and or customer support?

SAND provides comprehensive product documentation as well as excellent customer support.

Who are the main user groups of SAND Nucleus CDBMS?

Data analysts, data scientists, finance groups, marketing and promotion groups, manufacturing and QA groups, billing, taxation and tolling, among many others.

What are some applications SAND Nucleus CDBMS is commonly used in tandem with?

Any ODBC/JDBC interface to reporting and analysis front-ends—such as Microstrategy, Hummingbird, Tableau, and Crystal Reports—as well as an extension to other database systems such as Oracle, SQL Server, and MySQL, as a means to perform faster, in-depth analysis of data that many DBMS struggles with.

Does SAND Nucleus CDBMS integrate with any other apps?

Fully supports JDBC/ODBC connectivity.

Does SAND Nucleus CDBMS offer an API?

Yes, SQL with ODBC/JDBC and 'C' function interfaces.

Does SAND Nucleus CDBMS offer multi-user capability (e.g. teams)?

The database itself is highly scalable and supports multi-user connectivity. It is not in itself a service that uses collaboration.

What platforms does SAND Nucleus CDBMS support?

Linux and Windows.

What is SAND Nucleus CDBMS generally used for?

Any and all data collection and analysis activities.

on
Page last modified:

SAND Nucleus CDBMS User Reviews

No reviews yet. Rate this app or be the first to review!
Back to top