\contentsline {chapter}{List of Tables}{vi}
\contentsline {chapter}{List of Figures}{viii}
\contentsline {chapter}{Abstract}{1}
\contentsline {chapter}{Acknowledgments}{3}
\contentsline {chapter}{\numberline {1}Introduction}{1}
\contentsline {section}{\numberline {1.1}Prerequisite Knowledge}{2}
\contentsline {section}{\numberline {1.2}Research Question}{2}
\contentsline {section}{\numberline {1.3}Thesis Structure}{2}
\contentsline {chapter}{\numberline {2}Relational Databases}{4}
\contentsline {section}{\numberline {2.1}Introduction}{4}
\contentsline {section}{\numberline {2.2}Strengths}{5}
\contentsline {section}{\numberline {2.3}Weaknesses}{5}
\contentsline {chapter}{\numberline {3}Complex Data Structures}{7}
\contentsline {section}{\numberline {3.1}Introduction}{7}
\contentsline {section}{\numberline {3.2}Aggregation vs Association}{8}
\contentsline {section}{\numberline {3.3}Object-Oriented Database Management Systems}{10}
\contentsline {section}{\numberline {3.4}Object-Relational Database Management Systems}{11}
\contentsline {chapter}{\numberline {4}Transformation Methodologies or Mapping Techniques}{13}
\contentsline {section}{\numberline {4.1}Introduction}{13}
\contentsline {section}{\numberline {4.2}Persistence Modeling Process Pattern (PMPP)}{14}
\contentsline {section}{\numberline {4.3}Mediators}{15}
\contentsline {section}{\numberline {4.4}Object-Relational Transformation Methodology (ORTM)}{16}
\contentsline {subsection}{\numberline {4.4.1}Mapping Association to Relational logical models}{18}
\contentsline {subsection}{\numberline {4.4.2}Mapping Aggregation to Relational logical models}{18}
\contentsline {subsection}{\numberline {4.4.3}Existence Dependance and Ordered Composition}{19}
\contentsline {chapter}{\numberline {5}Client-Server Architecture}{23}
\contentsline {section}{\numberline {5.1}Introduction}{23}
\contentsline {section}{\numberline {5.2}Client-Server Design Issues}{24}
\contentsline {subsection}{\numberline {5.2.1}Database Design}{24}
\contentsline {subsection}{\numberline {5.2.2}Query Structuring}{25}
\contentsline {subsection}{\numberline {5.2.3}Query Processing}{26}
\contentsline {section}{\numberline {5.3}Summary}{27}
\contentsline {chapter}{\numberline {6}Methodology}{28}
\contentsline {section}{\numberline {6.1}Relational Databases Used in Study}{28}
\contentsline {section}{\numberline {6.2}A Multi-level Composite Object}{29}
\contentsline {section}{\numberline {6.3}Aggregate Relations}{30}
\contentsline {section}{\numberline {6.4}Composite Indices}{31}
\contentsline {section}{\numberline {6.5}Implemented Optimization Techniques}{32}
\contentsline {section}{\numberline {6.6}Indexing}{33}
\contentsline {section}{\numberline {6.7}Stored Procedures}{33}
\contentsline {section}{\numberline {6.8}Temporary Databases}{35}
\contentsline {section}{\numberline {6.9}Database Connection}{35}
\contentsline {section}{\numberline {6.10}ActiveX Data Object Model}{36}
\contentsline {section}{\numberline {6.11}OLE DB}{37}
\contentsline {section}{\numberline {6.12}Client Application Development}{38}
\contentsline {section}{\numberline {6.13}Limitations of Study}{39}
\contentsline {section}{\numberline {6.14}Aims of study}{41}
\contentsline {chapter}{\numberline {7}Analysis of Results}{42}
\contentsline {section}{\numberline {7.1}Composite Index Size}{43}
\contentsline {section}{\numberline {7.2}Direct Implementation of ORTM}{44}
\contentsline {section}{\numberline {7.3}Affect of ADO on study}{45}
\contentsline {section}{\numberline {7.4}Introduction of a Non-Clustered Secondary Index to Composite Index}{46}
\contentsline {section}{\numberline {7.5}Introduction of a Clustered Index to Composite Index}{48}
\contentsline {section}{\numberline {7.6}Introduction of a Stored Procedure to Retrieve Composite Index}{49}
\contentsline {section}{\numberline {7.7}Introduction of a Indexed Stored Procedure to Retrieve Composite Index}{51}
\contentsline {section}{\numberline {7.8}Insertion of Composite Index into RAM}{52}
\contentsline {section}{\numberline {7.9}Evaluation of Optimization Techniques}{54}
\contentsline {chapter}{\numberline {8}Conclusion}{56}
\contentsline {section}{\numberline {8.1}Research Assessment}{56}
\contentsline {section}{\numberline {8.2}Area of Future Work}{57}
\contentsline {chapter}{Appendix 1: Actual Study Results}{62}
\contentsline {chapter}{Appendix 2: Application Source Code}{66}
\contentsline {chapter}{Appendix 3: Database Creation Statements}{86}
\contentsline {chapter}{Appendix 4: Composite Index Creation}{106}
\contentsline {chapter}{Appendix 5: Database Audit Information}{110}
\contentsline {chapter}{Appendix 6: Optimization Technique Implementation}{113}