Data Abstraction Technique for Relational Database Query Processing.
Saved in:
| Title: | Data Abstraction Technique for Relational Database Query Processing. |
|---|---|
| Authors: | Ohtani, Takumi1, Baba, Takanobu1, Inagawa, Masayuki1, Iwasaki, Takao1, Okuda, Kenzo1, Yamazaki, Katsuhiro1 |
| Source: | Systems & Computers in Japan. Feb86, Vol. 17 Issue 2, p12-20. 9p. |
| Subjects: | Relational databases, Microprogramming, Databases, Programming languages, Interfaces (Physical sciences) |
| Abstract: | This paper proposes a schema conversion approach for relational database query processing. The approach not only maintains high data independence by encapsulating the data and its physical structures for a query with the procedures that manipulate them, but also aims to achieve high-speed processing by dedicating the procedures to individual functions. This approach is experimentally compared with the interpretive and compilation methods in terms of data independence, performance and procedure program size. The following conclusions are drawn from the experiments. (1) Although the effect of the change in physical structure is greater than that of the interpretive approach in regard to data independence, only a limited number of parts are affected and they are easily reorganized by each dedicated procedure. (2) The performance is extremely close to that of the compilation approach regardless of the kind of computer and programming language. Furthermore, the overhead for calling the procedures can be further reduced with the use of microprograms and hardware. (3) Although the number of specialized procedures increases, this is compensated by the relatively small program size of each procedure. [ABSTRACT FROM AUTHOR] |
| Copyright of Systems & Computers in Japan is the property of Wiley-Blackwell and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) | |
| Database: | Engineering Source |
| FullText | Links: – Type: pdflink Text: Availability: 0 |
|---|---|
| Header | DbId: egs DbLabel: Engineering Source An: 14044257 AccessLevel: 6 PubType: Academic Journal PubTypeId: academicJournal PreciseRelevancyScore: 0 |
| IllustrationInfo | |
| Items | – Name: Title Label: Title Group: Ti Data: Data Abstraction Technique for Relational Database Query Processing. – Name: Author Label: Authors Group: Au Data: <searchLink fieldCode="AR" term="%22Ohtani%2C+Takumi%22">Ohtani, Takumi</searchLink><relatesTo>1</relatesTo><br /><searchLink fieldCode="AR" term="%22Baba%2C+Takanobu%22">Baba, Takanobu</searchLink><relatesTo>1</relatesTo><br /><searchLink fieldCode="AR" term="%22Inagawa%2C+Masayuki%22">Inagawa, Masayuki</searchLink><relatesTo>1</relatesTo><br /><searchLink fieldCode="AR" term="%22Iwasaki%2C+Takao%22">Iwasaki, Takao</searchLink><relatesTo>1</relatesTo><br /><searchLink fieldCode="AR" term="%22Okuda%2C+Kenzo%22">Okuda, Kenzo</searchLink><relatesTo>1</relatesTo><br /><searchLink fieldCode="AR" term="%22Yamazaki%2C+Katsuhiro%22">Yamazaki, Katsuhiro</searchLink><relatesTo>1</relatesTo> – Name: TitleSource Label: Source Group: Src Data: <searchLink fieldCode="JN" term="%22Systems+%26+Computers+in+Japan%22">Systems & Computers in Japan</searchLink>. Feb86, Vol. 17 Issue 2, p12-20. 9p. – Name: Subject Label: Subjects Group: Su Data: <searchLink fieldCode="DE" term="%22Relational+databases%22">Relational databases</searchLink><br /><searchLink fieldCode="DE" term="%22Microprogramming%22">Microprogramming</searchLink><br /><searchLink fieldCode="DE" term="%22Databases%22">Databases</searchLink><br /><searchLink fieldCode="DE" term="%22Programming+languages%22">Programming languages</searchLink><br /><searchLink fieldCode="DE" term="%22Interfaces+%28Physical+sciences%29%22">Interfaces (Physical sciences)</searchLink> – Name: Abstract Label: Abstract Group: Ab Data: This paper proposes a schema conversion approach for relational database query processing. The approach not only maintains high data independence by encapsulating the data and its physical structures for a query with the procedures that manipulate them, but also aims to achieve high-speed processing by dedicating the procedures to individual functions. This approach is experimentally compared with the interpretive and compilation methods in terms of data independence, performance and procedure program size. The following conclusions are drawn from the experiments. (1) Although the effect of the change in physical structure is greater than that of the interpretive approach in regard to data independence, only a limited number of parts are affected and they are easily reorganized by each dedicated procedure. (2) The performance is extremely close to that of the compilation approach regardless of the kind of computer and programming language. Furthermore, the overhead for calling the procedures can be further reduced with the use of microprograms and hardware. (3) Although the number of specialized procedures increases, this is compensated by the relatively small program size of each procedure. [ABSTRACT FROM AUTHOR] – Name: AbstractSuppliedCopyright Label: Group: Ab Data: <i>Copyright of Systems & Computers in Japan is the property of Wiley-Blackwell and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract.</i> (Copyright applies to all Abstracts.) |
| PLink | https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=egs&AN=14044257 |
| RecordInfo | BibRecord: BibEntity: Identifiers: – Type: doi Value: 10.1002/scj.4690170202 Languages: – Code: eng Text: English PhysicalDescription: Pagination: PageCount: 9 StartPage: 12 Subjects: – SubjectFull: Relational databases Type: general – SubjectFull: Microprogramming Type: general – SubjectFull: Databases Type: general – SubjectFull: Programming languages Type: general – SubjectFull: Interfaces (Physical sciences) Type: general Titles: – TitleFull: Data Abstraction Technique for Relational Database Query Processing. Type: main BibRelationships: HasContributorRelationships: – PersonEntity: Name: NameFull: Ohtani, Takumi – PersonEntity: Name: NameFull: Baba, Takanobu – PersonEntity: Name: NameFull: Inagawa, Masayuki – PersonEntity: Name: NameFull: Iwasaki, Takao – PersonEntity: Name: NameFull: Okuda, Kenzo – PersonEntity: Name: NameFull: Yamazaki, Katsuhiro IsPartOfRelationships: – BibEntity: Dates: – D: 01 M: 02 Text: Feb86 Type: published Y: 1986 Identifiers: – Type: issn-print Value: 08821666 Numbering: – Type: volume Value: 17 – Type: issue Value: 2 Titles: – TitleFull: Systems & Computers in Japan Type: main |
| ResultId | 1 |
