Database performance in the real world: TPC-D and SAP R/3
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
SilkRoute: A framework for publishing relational data in XML
ACM Transactions on Database Systems (TODS)
Efficient Bulk Deletes in Relational Databases
Proceedings of the 17th International Conference on Data Engineering
Efficiently publishing relational data as XML documents
The VLDB Journal — The International Journal on Very Large Data Bases
Hi-index | 0.00 |
According to a survey of the University of Berkeley,about 5 Exabytes of new information has been created in2002. This information explosion affects also the databasevolumes of enterprise resource planning (ERP) systems likeSAP R/3, the market leader for ERP systems. Just like theoverall information explosion, the database volumes of ERPsystems are growing at a tremendous rate and some of themhave reached a size of several Terabytes. OLTP (OnlineTransaction Processing) databases of this size are hard tomaintain and tend to perform poorly. One way to limit thesize of a database is data staging, i.e., to make use of anSAP technique called archiving. That is, data which arenot needed for every-day operations are demoted from thedatabase (disks) to tertiary storage (tapes). In cooperationwith our research group, SAP is adapting their archivingtechniques to accelerate the archiving process by integratingnew technologies like XML and advanced database features.However, so far no benchmark existed to evaluate differentarchiving scenarios and to measure the impact of a changein the archiving technique. We therefore designed and implementeda generic benchmark which is applicable to manydifferent system layouts and allows the users to evaluate variousarchiving scenarios.