TY - GEN
T1 - DBCache
T2 - 2002 ACM SIGMOD International Conference on Management of Data, SIGMOD 2002
AU - Altinel, Mehmet
AU - Luo, Qiong
AU - Krishnamurthy, Sailesh
AU - Mohan, C.
AU - Pirahesh, Hamid
AU - Lindsay, Bruce G.
AU - Woo, Honguk
AU - Brown, Larry
N1 - Publisher Copyright:
© 2002 ACM.
PY - 2002/6/3
Y1 - 2002/6/3
N2 - Many e-Business applications today are being developed and deployed on multi-tier environments involving browser-based clients, web application servers and backend databases. The dynamic nature of these applications necessitates generating web pages on-demand, making middle-tier database caching an effective approach to achieve high scalability and performance [3]. In the DBCache project, we are incorporating a database cache feature in DB2 UDB by modifying the engine code and leveraging existing federated database functionality. This allows us to take advantage of DB2's sophisticated distributed query processing power for database caching. As a result, the user queries can be executed at either the local database cache or the remote backend server, or more importantly, the query can be partitioned and then distributed to both databases for cost optimum execution.DBCache also includes a cache initialization component that takes a backend database schema and SQL queries in the workload, and generates a middle-tier database schema for the cache. We have implemented an initial prototype of the system that supports table level caching. As DB2's functionality is extended, we will be able to support subtable level caching, XML data caching and caching of execution results of web services.
AB - Many e-Business applications today are being developed and deployed on multi-tier environments involving browser-based clients, web application servers and backend databases. The dynamic nature of these applications necessitates generating web pages on-demand, making middle-tier database caching an effective approach to achieve high scalability and performance [3]. In the DBCache project, we are incorporating a database cache feature in DB2 UDB by modifying the engine code and leveraging existing federated database functionality. This allows us to take advantage of DB2's sophisticated distributed query processing power for database caching. As a result, the user queries can be executed at either the local database cache or the remote backend server, or more importantly, the query can be partitioned and then distributed to both databases for cost optimum execution.DBCache also includes a cache initialization component that takes a backend database schema and SQL queries in the workload, and generates a middle-tier database schema for the cache. We have implemented an initial prototype of the system that supports table level caching. As DB2's functionality is extended, we will be able to support subtable level caching, XML data caching and caching of execution results of web services.
UR - https://www.scopus.com/pages/publications/85134340141
U2 - 10.1145/564691.564765
DO - 10.1145/564691.564765
M3 - Conference contribution
AN - SCOPUS:85134340141
T3 - Proceedings of the 2002 ACM SIGMOD International Conference on Management of Data, SIGMOD 2002
SP - 612
BT - Proceedings of the 2002 ACM SIGMOD International Conference on Management of Data, SIGMOD 2002
PB - Association for Computing Machinery, Inc
Y2 - 3 June 2002 through 6 June 2002
ER -