Creation of Gene Database and Implementation of Transaction Processing
Main Article Content
Abstract
A rich set of concepts and techniques has been used in the context of gene database creation and transaction processing along with
performance and tuning for the efficient and robust execution of queries. So far, this work has mostly focused on issues related to data-retrieval
queries. However, update operations can also exhibit a number of query processing issues, depending on the complexity of the operations and the
volume of data to process. Such issues include lookup and matching of values, navigational vs. set-oriented algorithms and trade-offs between plans
that do serial or random I/Os .In this paper we present an overview of the basic techniques used to support SQL DML (Data Manipulation
Language) in ORACLE database 10g. Our focus is on the collection of gene information and implementation of some concepts of transaction
operations and performance and tuning operation into the gene database and cancer database. Although atomicity is a well studied topic in transaction
processing and business workflows, such an important capability needs to be revisited in a scientific workflow environment. Atomicity needs to be
defined in dataflow-oriented scientific workflow model. The basic principles of all transaction-processing systems are the same. However, the
terminology may vary from one transaction-processing system to another.
Â
Keywords: GeneBank, SQL DML, DB Transaction Management, Tuning.
Downloads
Article Details
COPYRIGHT
Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
- The journal allows the author(s) to retain publishing rights without restrictions.
- The journal allows the author(s) to hold the copyright without restrictions.