A Database Array Algebra for Spatio-Temporal Data and Beyond
NGIT '99 Proceedings of the 4th International Workshop on Next Generation Information Technologies and Systems
Hosting the .NET Runtime in Microsoft SQL server
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
.NET database programmability and extensibility in microsoft SQL server
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Distribution rules for array database queries
DEXA'05 Proceedings of the 16th international conference on Database and Expert Systems Applications
MPI-DB, a parallel database services software library for scientific computing
EuroMPI'11 Proceedings of the 18th European MPI Users' Group conference on Recent advances in the message passing interface
An architecture for a data-intensive computer
Proceedings of the first international workshop on Network-aware data management
Graywulf: a platform for federated scientific databases and services
Proceedings of the 25th International Conference on Scientific and Statistical Database Management
Hi-index | 0.00 |
This paper outlines certain scenarios from the fields of astrophysics and fluid dynamics simulations which require high performance data warehouses that support array data type. A common feature of all these use cases is that subsetting and preprocessing the data on the server side (as far as possible inside the database server process) is necessary to avoid the client-server overhead and to minimize IO utilization. Analyzing and summarizing the requirements of the various fields help software engineers to come up with a comprehensive design of an array extension to relational database systems that covers a wide range of scientific applications. We also present a working implementation of an array data type for Microsoft SQL Server 2008 to support large-scale scientific applications. We introduce the design of the array type, results from a performance evaluation, and discuss the lessons learned from this implementation. The library can be downloaded from our website at http://voservices.net/sqlarray/.