Publications by Eric Lo
2010
VLDB J., January 2010
@inproceedings{abc, author = {Eric Lo and Carsten Binnig and Donald Kossmann and M. Tamer {\"O}zsu and Wing-Kai Hon}, booktitle = {VLDB J.}, title = {A framework for testing DBMS features.}, url = {http://dx.doi.org/10.1007/s00778-009-0157-y}, year = {2010} }
2008
Proceedings of the 24th International Conference on Data Engineering, ICDE 2008, Cancún, México, January 2008
@inproceedings{abc, author = {Carsten Binnig and Donald Kossmann and Eric Lo and Angel Saenz-Badillos}, booktitle = {Proceedings of the 24th International Conference on Data Engineering, ICDE 2008}, title = {Automatic Result Verification for the Functional Testing of a Query Language.}, url = {http://dx.doi.org/10.1109/ICDE.2008.4497614}, venue = {Canc{\'u}n, M{\'e}xico}, year = {2008} }
Proceedings of the 1st International Workshop on Testing Database Systems, DBTest 2008, Vancouver, BC, Canada, January 2008
@inproceedings{abc, author = {Carsten Binnig and Donald Kossmann and Eric Lo}, booktitle = {Proceedings of the 1st International Workshop on Testing Database Systems, DBTest 2008, Vancouver, BC, Canada}, title = {Multi-RQP: generating test databases for the functional testing of OLTP applications.}, url = {http://doi.acm.org/10.1145/1385269.1385276}, year = {2008} }
IEEE Data Eng. Bull., January 2008
@inproceedings{abc, author = {Carsten Binnig and Donald Kossmann and Eric Lo}, booktitle = {IEEE Data Eng. Bull.}, title = {Towards Automatic Test Database Generation.}, url = {http://sites.computer.org/debull/A08mar/binnig.pdf}, year = {2008} }
2007
Proceedings of the 23rd International Conference on Data Engineering, ICDE 2007, The Marmara Hotel, Istanbul, Turkey, January 2007
@inproceedings{abc, author = {Carsten Binnig and Donald Kossmann and Eric Lo}, booktitle = {Proceedings of the 23rd International Conference on Data Engineering, ICDE 2007, The Marmara Hotel, Istanbul, Turkey}, title = {Reverse Query Processing.}, url = {http://dx.doi.org/10.1109/ICDE.2007.367896}, year = {2007} }
Proceedings of the ACM SIGMOD International Conference on Management of Data, Beijing, China, January 2007
@inproceedings{abc, author = {Carsten Binnig and Donald Kossmann and Eric Lo and M. Tamer {\"O}zsu}, booktitle = {Proceedings of the ACM SIGMOD International Conference on Management of Data, Beijing, China}, title = {QAGen: generating query-aware test databases.}, url = {http://doi.acm.org/10.1145/1247480.1247520}, year = {2007} }
VLDB J., January 2007
@inproceedings{abc, author = {Florian Haftmann and Donald Kossmann and Eric Lo}, booktitle = {VLDB J.}, title = {A framework for efficient regression tests on database applications.}, url = {http://dx.doi.org/10.1007/s00778-006-0028-8}, year = {2007} }
ETH Zürich, Diss. Nr. 17271, January 2007
Supervised by: Prof. Gustavo Alonso
Supervised by: Prof. Gustavo Alonso
Testingis the process of checking the correctness,completeness, security,and quality of a piece of Computer Software. With the increasing importanceand prevalence of testing, many tests have to be carried throughout the whole product cycle. With possibly thousands or even millions of tests to be executed, it is necessary to devise tools or techniques to automate and optimize the testing process. This dissertation examines several issues related to testing database applications and database systems.
The first issue is related to the efficiency of testing database applications. Given that testing is the most expensivepart of the Software development cycle, it is necessary to fully utilize the available resources so as to minimize the testing time. The first part of this dissertation presents a framework for efficient test execution.
The second issue is related to the generation of test data to test functional features of database applications. Today, all database generators generate test data without considering the application queries; therefore, the generateddata hardly return meaningful query results which could be used to test different code paths of an application. In order to solve this problem, the second part of this dissertation presents a database generator that accepts an application query and the expected query results as input, and generates a test database that meets the test requirements as output.
The last part of this dissertation focuses on testing database Systems. In order to test individual componentsof a database System (e.g., query optimizer, Operators' algorithms), it is necessaryto execute the same test query on differentdatabase instances to obtain different query results. However, it is indeed difficult to obtain differentquery results for the same test query because it requires manual tuning on the database content. To this end, this dissertation presents a query-aware database generator to automate this task.
@phdthesis{abc, abstract = {Testingis the process of checking the correctness,completeness, security,and quality of a piece of Computer Software. With the increasing importanceand prevalence of testing, many tests have to be carried throughout the whole product cycle. With possibly thousands or even millions of tests to be executed, it is necessary to devise tools or techniques to automate and optimize the testing process. This dissertation examines several issues related to testing database applications and database systems. The first issue is related to the efficiency of testing database applications. Given that testing is the most expensivepart of the Software development cycle, it is necessary to fully utilize the available resources so as to minimize the testing time. The first part of this dissertation presents a framework for efficient test execution. The second issue is related to the generation of test data to test functional features of database applications. Today, all database generators generate test data without considering the application queries; therefore, the generateddata hardly return meaningful query results which could be used to test different code paths of an application. In order to solve this problem, the second part of this dissertation presents a database generator that accepts an application query and the expected query results as input, and generates a test database that meets the test requirements as output. The last part of this dissertation focuses on testing database Systems. In order to test individual componentsof a database System (e.g., query optimizer, Operators{\textquoteright} algorithms), it is necessaryto execute the same test query on differentdatabase instances to obtain different query results. However, it is indeed difficult to obtain differentquery results for the same test query because it requires manual tuning on the database content. To this end, this dissertation presents a query-aware database generator to automate this task.}, author = {Eric Lo}, school = {17271}, title = {Test Automation for Database Management Systems and Database Applications}, year = {2007} }
2006
Proceedings of the ACM SIGMOD International Conference on Management of Data, Chicago, Illinois, USA, January 2006
@inproceedings{abc, author = {Carsten Binnig and Donald Kossmann and Eric Lo}, booktitle = {Proceedings of the ACM SIGMOD International Conference on Management of Data, Chicago, Illinois, USA}, title = {Testing database applications.}, url = {http://doi.acm.org/10.1145/1142473.1142572}, year = {2006} }
2005
Proceedings of the 31st International Conference on Very Large Data Bases, Trondheim, Norway, January 2005
@inproceedings{abc, author = {Florian Haftmann and Donald Kossmann and Eric Lo}, booktitle = {Proceedings of the 31st International Conference on Very Large Data Bases, Trondheim, Norway}, title = {Parallel Execution of Test Runs for Database Application Systems.}, url = {http://www.vldb2005.org/program/paper/thu/p589-haftmann.pdf}, year = {2005} }