Extract. Load. Transform
SAND CDBMS Data Transform is designed to deal with the large data volumes that result from the proliferation of web site, email server, call detail record, and application logs. While this data can be valuable in understanding business processes and customer behavior, it is usually not presented in a format suitable for business analysis, for example, web logs will contain IP addresses, but lack the information necessary to analyze traffic based on demographics such as city or country.
SAND CDBMS’ unique column-oriented architecture and compression technology allows the Data Tranform option to efficiently restructure (denormalize) and store massive volumes of data so that it is easily usable for analysis, while enriching it with the appropriate demographic information for maximum analytic power.
Decrease size. Increase value.
SAND CDBMS Data Transform is a valuable solution for any situation in which large amounts of data require complex join operations to enable business intelligence. It features:
- Very small data footprint
- Self-defining compressed files
- No need to maintain external catalog structures
- Historical data is enriched with demographic data
- Adapts to deal with issues of slowly changing dimensions, such as reassignment of IP addresses
- The compressed and enriched data files can be used to feed any ETL process or database.
Data can be fully denormalized very quickly, with no inflation of disk space requirements, enabling a huge reduction in TCO without sacrificing data agility.
Learn more
To receive more information from SAND, please complete and submit the following form: