Development of a Laboratory Information Management System for Medical Genetic Investigations (LIMS)

Studying the genetic factor underlying a set of diseases with modern high- throughput techniques generates huge amounts of data, posing a challenge for data management. In this thesis a database management system called FIDB based on MySQL was developed to handle clinical and experimental genetic data. For the convenience of the users, a web interface was developed to insert, update, delete and display the data. In addition security aspects were taken care of. Currently FIDB is able to organise and store data gathered by analysing 150 consanguineous families with autosomal recessive mental retardation

Design and Implementation of a World Wide Web Interface to Query and Update a Relational Database

World Wide Web (WWW) is widely used today. It can show static information, and provide interactive information. WWW users can access the system anywhere, anytime. In this thesis, we designed and implement a WWW interface 'to query and update a relational database. We use Microsoft Windows NT Server 4.0 Network Operating System, Microsoft SQL Server 6.0; Microsoft Internet Information Server 3.0(MS ITS) for our server. MS Windows NT Server supports network and security. MS SQL Server is used to integrate a Relational Database Management System (RDBMS) with WWW to handle the database queries and other operations. MS ITS and MS Windows NT Server provide an excellent platform for developing web sites

An integrated concurrency control in object-oriented database systems.

First, the dissertation discusses three important issues of concurrency control in OODBs. These include conflict among methods, class hierarchy locking, and nested method invocations. The previous works for each issue are presented, and their advantages and disadvantages are also discussed. Then, an integrated concurrency control which addresses all three issues is proposed. For conflict among methods, a finer locking granularity, such as an attribute and an individual class object, is adopted for instance access and class definition access so that higher concurrency is achieved. Especially, for instance access, higher concurrency is obtained using run-time information. Also, locks are required for instance method invocations instead of atomic operation invocations so that locking overhead is reduced. For class hierarchy locking, locking overheads are reduced using special classes which are based on access frequency information on classes. Finally, for nested method invocations, semantic information is used in order to provide higher concurrency among methods. Also, parent/children parallelism is adopted for better performance.Finally, a performance study is conducted by means of simulation using the 007 benchmark. The simulation results show that, in terms of transaction response time and lock waiting time, the proposed scheme performs the best, Malta the second best, and Orion the worst.Object-oriented databases (OODBs) have been adopted for non-standard applications requiring advanced modeling power, in order to handle complex data and relationships among such data. One of the important characteristics in database system is manipulation of shared data. That is, database systems, including OODBs, allow shared data to be accessed by multiple users at the same time. Concurrency control is a mechanism used to coordinate access to the multi-user databases so that the consistency of the database is maintained. In order to provide good performance, it is very important that concurrency control schemes incur low overhead and increase concurrency among users. This dissertation presents a concurrency control scheme in OODBs that meets those requirements.Secondly, an analytical model is constructed to measure the performance of concurrency control in an OODB system. Using this model, the proposed technique is then compared with the two existing techniques, Orion and Malta. The analytical results show that the proposed scheme gives the best transaction response time, Malta the second best, and Orion the worst

A DBMS query language in natural Chinese language form.

by Lam Chin-keung.Thesis (M.Phil.)--Chinese University of Hong Kong, 1995.Includes bibliographical references (leaves 129-135 (2nd gp.)).ACKNOWLEDGMENTS --- p.IABSTRACT --- p.IITABLE OF CONTENTS --- p.IIILIST OF FIGURES --- p.VILIST OF TABLES --- p.VIIIChapter CHAPTER 1 --- INTRODUCTION --- p.1Chapter 1.1 --- Motivations --- p.1Chapter 1.2 --- Objectives --- p.3Chapter 1.3 --- More to go --- p.3Chapter 1.4 --- Chapter Summary --- p.4Chapter CHAPTER 2 --- RELATED WORK --- p.6Chapter 2.1 --- Chinese Related Work --- p.6Chapter 2.1.1 --- Chinese Natural Language --- p.6Chapter 2.1.2 --- Chinesized Query Language From English --- p.7Chapter 2.2 --- High Level Database Query Language --- p.8Chapter 2.2.1 --- Relational Algebra vs Relational Calculus --- p.9Chapter 2.2.2 --- Procedural vs Declarative --- p.10Chapter 2.2.3 --- Natural Language (NL) vs Restricted Natural Language (RNL) --- p.11Chapter 2.3 --- Database Query Interface --- p.13Chapter 2.3.1 --- Linear Textual Interface --- p.13Chapter 2.3.2 --- Form-based Interface --- p.14Chapter 2.3.3 --- Graphical Interface --- p.14Chapter 2.4 --- Remarks --- p.14Chapter CHAPTER 3 --- DESIGN PRINCIPLES --- p.16Chapter 3.1 --- Underlying Data Model of the new language --- p.16Chapter 3.2 --- Problems Under Attack --- p.17Chapter 3.2.1 --- Naturalness --- p.17Chapter 3.2.2 --- Procedural vs Declarative --- p.19Chapter 3.2.3 --- Supports of Chinese Characters --- p.21Chapter 3.3 --- Design Principles --- p.22Chapter 3.4 --- Chapter Summary --- p.26Chapter CHAPTER 4 --- LANGUAGE DEFINITION --- p.28Chapter 4.1 --- Language Overvew --- p.28Chapter 4.2 --- The Data Manipulation Language --- p.29Chapter 4.2.1 --- Relational Operators --- p.30Chapter 4.2.2 --- Rail-Track Diagram of Chiql --- p.32Chapter 4.2.3 --- The 11-template --- p.33Chapter 4.2.4 --- Chiql Examples --- p.37Chapter 4.2.5 --- Common Language Constructs --- p.39Chapter 4.2.6 --- ONE issue about GROUP BY and RESTRICTION --- p.41Chapter 4.3 --- Other Language Features --- p.42Chapter 4.3.1 --- Aggregate Functions --- p.43Chapter 4.3.2 --- Attribute Alias --- p.44Chapter 4.3.3 --- Conditions in Chinese --- p.45Chapter 4.3.4 --- Unquantifed Predicates --- p.45Chapter 4.3.5 --- sorting --- p.47Chapter 4.4 --- Treatment of Quantified Predicates --- p.48Chapter 4.5 --- The Data Definition Language --- p.52Chapter 4.5.1 --- Create Table --- p.52Chapter 4.5.2 --- Drop Table --- p.54Chapter 4.5.3 --- Alter Table --- p.54Chapter 4.5.4 --- Insert Row --- p.56Chapter 4.5.5 --- Delete Row --- p.56Chapter 4.5.6 --- Update Row --- p.57Chapter 4.5.7 --- Remarks on DDL --- p.58Chapter 4.6 --- Chapter Summary --- p.59Chapter CHAPTER 5 --- END-USER INTERFACE --- p.61Chapter 5.1 --- EUI Overview --- p.61Chapter 5.2 --- Design Principles --- p.62Chapter 5.2.1 --- Language Independent Aspects --- p.62Chapter 5.2.2 --- Language Dependent Aspects --- p.64Chapter 5.3 --- Complex Condition Handling --- p.68Chapter 5.4 --- Input Sequences of the EUI --- p.71Chapter 5.5 --- Query Formulation： An Example --- p.73Chapter 5.6 --- Chapter Summary --- p.85Chapter CHAPTER 6 --- CHIQL TO SQL TRANSLATIONS --- p.86Chapter 6.1 --- Related Work --- p.87Chapter 6.2 --- Translation Overview --- p.87Chapter 6.2.1 --- "Pass One:Mapping( Input = Chiql, Output = multi-statement SQL)" --- p.89Chapter 6.2.2 --- "Pass Two:Nesting(Input = multi-statement SQL, Output = single statement SQL)" --- p.92Chapter 6.2.3 --- Technical Difficulties in Chiql/SQL Translation --- p.99Chapter 6.3 --- Chapter Summary --- p.106Chapter CHAPTER 7 --- EVALUATION --- p.108Chapter 7.1 --- Expressiveness Test --- p.108Chapter 7.1.1 --- Results --- p.109Chapter 7.1.2 --- Implications --- p.111Chapter 7.2 --- Usability Evaluation --- p.111Chapter 7.2.1 --- Evaluation Methodology --- p.112Chapter 7.2.2 --- Result:Completion Time --- p.113Chapter 7.2.3 --- Result: Additional Help --- p.116Chapter 7.2.4 --- Result： Query Error --- p.116Chapter 7.2.5 --- Result： Overall Score --- p.118Chapter 7.2.6 --- User Comments --- p.120Chapter 7.3 --- Chapter Summary --- p.120Chapter CHAPTER 8 --- CONCLUSIONS --- p.122Chapter 8.1 --- Thesis Conclusions --- p.122Chapter 8.2 --- Future Work --- p.124REFERENCESAPPENDI