The Data Warehouse Challenge

In today's world, effective government increasingly requires the ability to store, access and analyze very large volumes of data. The primary challenge is to find the right data and to make it responsive to user requirements. Whether it's responding to a fast-breaking demand from an elected representative or addressing the ongoing need for meaningful reports, the pressures of governing demand flexibility and performance, with a growing emphasis on productivity.

The SAND/DNA Solution

SAND/DNA enables customers in government to cost-effectively retain massive amounts of compressed data in a nearline repository for extended periods, in accordance with any applicable business rules and regulatory requirements and to rapidly retrieve just the information they need, whenever it is needed. A centralized data management solution with unparalleled performance and storage efficiency, the SAND/DNA suite dramatically reduces costs and management complexity while ensuring continuous data availability.

SAND/DNA can act as the platform for high-performance analytic applications in areas such as:

  • Law Enforcement and Security
  • Constituent Services
  • Financial Control

Or, it can be implemented to enhance data warehouse performance through application of Intelligent Information Management principles to warehouse design and data storage practices.

More Information

For more information on how SAND/DNA can help you Reduce TCO, increase performance, and meet Service Level Agreements, please complete and submit the following form (fields marked with * are mandatory):

Business emails only please. Free/Personal ISP or Web-based accounts (i.e. YAHOO, HOTMAIL, GMAIL, MSN, FREESERVE etc.) can NOT be processed.

  1. Please also send me:















Canada

Customer Success

Human Resources and Social Development Canada (HRSDC) was created in 1993 to provide an integrated approach to Canada's national investment in people. HRSDC administers programs supporting the income of Canadians and human resources programs linked to the requirements of the national economy and labour market.

Business Challenge

HRSDC needed to implement a system that would enable high-performance ad hoc analytics and reporting against a large amount of financial data. However, the existing data warehouse was not able to handle ad-hoc queries run against very large data tables, and creating the indexes required to coax adequate performance out of this warehouse for such queries would require significant effort from a number of highly-skilled DBA's. In fact, the existing system was already having trouble meeting the department's requirements for timely reports.

SAND/DNA Solution

HRSDC implemented SAND/DNA alongside the main warehouse to provide efficient storage of the data for analysis and to support the required query and reporting functionality. This solution cost-effectively satisfied the urgent need of analysts for faster response to their ad hoc queries.

Overall benefits included: ease and speed of ad hoc reporting to satisfy complex reporting needs, efficiency and speed of loading large volumes of production data, and freeing of much-needed disk space on the department's mainframe system.

Get the case study ›



SAND/Times Newsletter