Data Warehousing

Whether assembling longitudinal medical records or historical agricultural research data, Waratah has the expertise to design systems that efficiently store and, more importantly, provide access to mission-critical information. In the rush to design systems intended to capture and retain the exploding volume of electronic information available to corporations, insufficient consideration is often given to ensuring data are stored in a manner that allows them to support business decisions today and tomorrow. Most data sources are transactional in nature and ad hoc queries of typical data structures have profound impacts on performance.

Waratah has designed and deployed a variety of relational and denormalized data models and schemas for transactional and reporting applications. Waratah has considerable experience with Oracle and Microsoft database products and tools, and with a wide variety of integration, OLAP and reporting tools.