Re: Long-running queries

Sreenivas Gukal (gukal@cc.gatech.edu) wrote: : Hi Folks : Part of my Ph.D. thesis deals with efficiently supporting long-running : queries (maybe Decision Support System queries) without affecting : concurrent transactions in an OLTP environment. I dont know how important : and/or frequent a problem this is in real applications. If you : have encountered similar situations, can you please let me : know the context you had the problem in and what your solution was. : Regards : Sreenivas Gukal Ph: 404-853-9390 : email: gukal@cc.gatech.edu : -------------------------------------------------------------------------------- Hallo Sreenivas, the trend today seems to go to extracting all the informations from the (often very heterogenous) concern databases, which are of interest for the DSS, into one (possible very huge) database, which is optimized for long queries. The new word for such a database is "Data Warehouse". It can contain very detailed informations covering not only todays data but also all the history of the corporation (Some people think of Terabytes of data - Database vendors and hard disk manufacturers will be delighted). The most interesting thing in Data Warehousing is not to make only long running queries, but to have and use tools which analyse the data - find trends, say what would have been under modified circumstances and finally how are certain parameters to be changed to get some desired results- the so called OnLine Analytical Processing (OLAP). The technology for such large databases is available, the development of appropriate tools is at the beginning. Look into the group comp.databases.olap. Good luck for Your Ph. D. thesis, Alfred ----------------------------------------------- Alfred Jockisch, University of Regensburg, Germany Phone +49 941 944 5878 E-mail: alfred.jockisch@rz.uni-regensburg.de -----------------------------------------------