C-A1-03: Considerations in the Design and Use of an Oracle-based Virtual Data Warehouse
| Autor: | Christine Bredfeldt, Lela McFarland |
|---|---|
| Jazyk: | angličtina |
| Rok vydání: | 2011 |
| Předmět: |
Community and Home Care
education.field_of_study SQL Oracle Unified Method Database Computer science Population General Medicine computer.software_genre Oracle Data warehouse SELECTED ABSTRACTS - HMORN 2011: Virtual Data Warehouse Data access Data retrieval Relational database management system Data mining education computer computer.programming_language |
| Popis: | Background/Aims The amount of clinical data available for research is growing exponentially. As it grows, increasing the efficiency of both data storage and data access becomes critical. Relational database management systems (rDBMS) such as Oracle are ideal solutions for managing longitudinal clinical data because they support large-scale data storage and highly efficient data retrieval. In addition, they can greatly simplify the management of large data warehouses, including security management and regular data refreshes. However, the HMORN Virtual Data Warehouse (VDW) was originally designed based on SAS datasets, and this design choice has a number of implications for both the design and use of an Oracle-based VDW. From a design standpoint, VDW tables are designed as flat SAS datasets, which do not take full advantage of Oracle indexing capabilities. From a data retrieval standpoint, standard VDW SAS scripts do not take advantage of SAS pass-through SQL capabilities to enable Oracle to perform the processing required to narrow datasets to the population of interest. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|