High performance computer clusters have become popular as they are more
scalable, affordable and reliable than their centralized counterparts. Database
management
systems
are particularly suitable for distributed
architectures / however distributed DBMS are still not used widely because of the design
difficulties. In this study, we aim to help overcome these difficulties by
implementing a simulation testbed for a distributed query plan processor. This
testbed works on our departmental HPC cluster machine and is able to perform
select, project and join operations. A data generation module has also been
implemented which preserves the foreign key and primary key constraints in the
database schema. The testbed has capability to measure, simulate and estimate the
response time of a given query execution plan using specified communication
network parameters. Extensive experimental work is performed to show the
correctness of the produced results. The estimated execution time costs are also
compared with the actual run-times obtained from the testbed to verify the
proposed estimation functions. Thus, we make sure that these estimation
iv
functions can be used in distributed database query optimization and distributed
database design tools.
| Identifer | oai:union.ndltd.org:METU/oai:etd.lib.metu.edu.tr:http://etd.lib.metu.edu.tr/upload/12614311/index.pdf |
| Date | 01 May 2012 |
| Creators | Ceran, Erhan |
| Contributors | Cosar, Ahmet |
| Publisher | METU |
| Source Sets | Middle East Technical Univ. |
| Language | English |
| Detected Language | English |
| Type | M.S. Thesis |
| Format | text/pdf |
| Rights | Access forbidden for 1 year |
Page generated in 0.0019 seconds