Abstract: A method executed by a plurality of processors in a database system to implement temporal aggregate queries. The database system has a temporal table. A plurality of consecutive temporal partitions are defined and allocated to the respective processors. A query is received to aggregate at least one attribute of the temporal table. In response to the query, a plurality of timestamps are identified in the temporal table, the respective timestamps are allocated to the respective temporal partitions, the value changes in the at least one attribute at the plural timestamps are computed within each partition using the respective processors to which each partition is allocated, and the value changes within each partition are aggregated using the respective processors to which each partition is allocated to produce an aggregate value for the query.

Abstract: A method of providing enterprise applications with shared access to a data warehouse. A web service request is issued over a data network from a first client enterprise application to a second server enterprise application. A database query is then constructed at the second server enterprise application. It is then determined whether a response to the web service request will include the results of posing the database query against the data warehouse, or the SQL syntax necessary to pose the query. If the response is to include the results of posing then the second server enterprise application poses the query against the data warehouse and issues the results to the first client enterprise application. If the response to the request is to include the SQL syntax necessary to pose the query, then the second server enterprise application provides the database query syntax to the first client enterprise application.