How do you handle very large amounts of data with fast query and calculation performance?
Response: The EDW is built upon a Microsoft SQL Server Platform, which is capable of handling large amounts of data and performing calculations while maintaining performance. Furthermore, fundamental to Health Catalyst’s EDW design is the concept of a Late-Binding™ Data Warehouse.
This Late-Binding™ architecture avoids unnecessary complexity that delays time to value and leads to a very fragile and inflexible data warehouse infrastructure that could not adapt to rapidly changing analytic use cases or new data content. This has proven many times more scalable and adaptable to new analytic use cases and data content than the methodologies that utilize early binding, tightly coupled data models and vocabulary management. (For more information on our Late-Binding™ warehouse, please see our website.)
The late binding of attributes allows users to adjust or modify as needed. This leads to higher performance and enables the data to be loaded into multiple visualization applications for further analysis, summary, and drill-down.