The Community for Technology Leaders
RSS Icon
Subscribe
Issue No.11 - Nov. (2012 vol.24)
pp: 1937-1949
Xinyuan Zhao , Iowa State University, Ames
Shashi K. Gadia , Iowa State University, Ames
ABSTRACT
We have developed a platform, called Cyclone Database Implementation Workbench (CyDIW), that can be used to implement new database prototypes, use existing command-based systems, and conduct experiments. The workbench allows seamless integration of multiple systems and provides useful services. To support database implementation page-based storage and buffer managers are built-in. A scripting language for batches of commands is included. Experiments are encapsulated as batches of commands on multiple systems. A simple and easy to use GUI is available that acts as an editor and a launchpad for execution of batches of commands. Emphasis in CyDIW is on simplifying the logistics surrounding setting up experiments that are comprehensive and self-contained. The benchmarking services in CyDIW can be used for lightweight benchmarking, where a benchmark consisting of a data set and a suite of commands is given. A benchmarking experiment collects performance statistics from multiple systems based on varying parameters and plots benchmarking results without leaving the GUI. Setup for the system is easy. All configuration settings are recorded in XML documents that are highly portable and readily visible. Once installed, batches representing experiments can be exchanged as text files and executed on CyDIW on any computer.
INDEX TERMS
database implementation, Benchmarking, experimentation
CITATION
Xinyuan Zhao, Shashi K. Gadia, "A Lightweight Workbench for Database Benchmarking, Experimentation, and Implementation", IEEE Transactions on Knowledge & Data Engineering, vol.24, no. 11, pp. 1937-1949, Nov. 2012, doi:10.1109/TKDE.2011.169
REFERENCES
[1] S. Ma, "Implementation of a Canonical Native Storage for XML," master's thesis, Dept. of Computer Science, Iowa State Univ., Dec. 2004.
[2] D. Patanroi, "Binary Page Implementation of a Canonical Native Storage for XML," master's thesis, Dept. of Computer Science, Iowa State Univ., Dec. 2005.
[3] S.K. Gadia, "A Homogeneous Relational Model and Query Languages for Temporal Databases," ACM Trans. Database Systems, vol. 13, no. 4, pp. 418-448, 1988.
[4] S.K. Gadia and S.S. Nair, "Algebraic Identities and Query Optimization in a Parametric Model for Relational Temporal Databases," IEEE Trans. Knowledge and Data Eng, vol. 10, no. 5, pp. 793-807, Sept./Oct. 1998.
[5] S.K. Gadia and S.S. Nair, "Temporal Databases: A Prelude to Parametric Data," Temporal Databases: Theory, Design and Implementation, A.U. Tansel, J. Clifford, S.K. Gadia, S. Jajodia, A. Segev, and R.T. Snodgrass, eds., pp. 28-66, Benjamin/Cummings, 1993.
[6] Oracle Database, http://www.oracle.com/us/products/ database index.htm, 2010.
[7] A. Sahuguet, "Kweelt, The Making of: The Mistakes Made and the Lessons Learned," technical report, Dept. of Information and Computer Science, Univ. of Pennsylvania, 2000.
[8] D. Chamberlin, J. Robie, and D. Florescu, "QUILT: An XML Query Language for Heterogeneous Data Sources," Proc. Conf. Web and Databases (WebDB '00), pp. 1-25, 2000.
[9] A. Schmidt, F. Waas, M. Kersten, M.J. Carey, I. Manolescu, and R. Busse, "XMark: A Benchmark for XML Data Management," Proc. 28th Int'l Conf. Very Large Data Bases, pp. 974-985, 2002.
[10] OSDL DBT Suite, http:/osdldbt.sourceforge.net, 2011.
[11] BenchmarkSQL, http:/benchmarksql.sourceforge.net, 2011.
[12] Quest Software's Benchmark Factory for Databases, http://www.quest.combenchmark-factory, 2011.
[13] TPC-C Benchmark, http://www.tpc.orgtpcc, 2011.
[14] Database Benchmarking, Oracle Wiki, http://wiki.oracle.com/pageDatabase+Benchmarking , 2010.
[15] L. Afanasiev, M. Franceschet, M. Marx, and E. Zimuel, "XCheck: A Platform for Benchmarking XQuery Engines," Proc. 32nd Int'l Conf. Very Large Data Bases, pp. 1247-1250, 2006.
[16] BumbleBee, http://www.xquery.combumblebee, 2011.
[17] XML/SWF Charts, http://www.maani.usxml_charts, 2011.
[18] JDBC, http://java.sun.com/productsjdbc, 2011.
[19] XQJ, http://www.xqjapi.comjavadoc, 2011.
[20] XQBench, http://fifthelement.inf.ethz.ch:8083xqbench /, 2011.
[21] Saxon, http:/www.saxonica.com, 2011.
[22] MXQuery, http:/mxquery.org/, 2011.
[23] XBird, http://code.google.com/pxbird/, 2011.
[24] R Environment, http:/www.r-project.org/, 2011.
[25] Batch Execution of R, http://stat.ethz.ch/R-manual/R-patched/library/ utils/htmlBATCH.html, 2011.
[26] R. Ramakrishnan and J. Gehrke, Database Management Systems. McGraw-Hill, 2003.
5 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool