Data WarehousingOnce scientific data have been quality controlled for reliability, users need to be able to ask questions of the data and obtain answers quickly. Text files, spreadsheets, and traditional relational databases do not allow convenient, high performance querying of data. Data warehousing provides the best technology for the analysis and reporting of large data sets. STI data specialists create custom applications based on Microsoft SQL Server and Oracle database management systems to create and manage data warehouses. We have extensive experience in designing queries and reports using advanced tools such as Microsoft’s Analysis Services. These tools allow us to store client data using efficient, time-tested data warehouse design methodologies. |
