Database creation and/or reorganization over multiple database backends.
McGhee, Deborah A.
Hsiao, David K.
Wu, Thomas C.
MetadataShow full item record
To create a record in a database, one uses the INSERT command. However, in the Multi-Backend Database System (MBDS), the insert command only inserts one record at a time. When creating very large databases consisting of thousands or millions of records, the use of the INSERT command is a time-consuming process. Once a database is created, some of the records of the database may be tagged for deletion. MBDS uses the DELETE command to tag these records. Over some period of time, those records tagged for deletion should be physically removed from the database. Hence, removing tagged records is in essence creating new databases from untagged records. In this thesis, we present a methodology to efficiently create very large databases in gigabytes on parallel computers and to reorganize them when they have been tagged for deletion. Specifically, we design a utility program to by-pass the system's INSERT command, to load the data of the database directly onto disks and create all the necessary base data and meta data of the database.
RightsThis publication is a work of the U.S. Government as defined in Title 17, United States Code, Section 101. Copyright protection is not available for this work in the United States.
Showing items related by title, author, creator and subject.
Stewart, Rosemary Ellen (Monterey, California. Naval Postgraduate School, 1991);At the Naval Postgraduate School, computer science students are currently working on a multimedia database management (MDBMS) project. This prototype designed in 1988, has the ability to capture, store, manage, retrieve ...
Performance comparison of relational and native-xml databases using the semantics of the land command and control information exchange data model (LC2IEDM) Dieter, Jahn (Monterey, California. Naval Postgraduate School, 2005-09);Efforts to improve the military decision and action cycle have centered on automating the command and control process and improving interoperability among joint and coalition forces. However, information automation by ...
Implementation of the primary operation, retrieve-common, of the multi-backend database system (MBDS). Hunt, Andrew L. (1986);The multi-backend database system(MBDS) is a research effort conducted jointly by the Naval Postgraduate School and Ohio State University with the sponsorship of the STARS foundation. The MBDS is designed to overcome ...