{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,10,22]],"date-time":"2023-10-22T20:45:02Z","timestamp":1698007502741},"reference-count":7,"publisher":"Wiley","issue":"2","license":[{"start":{"date-parts":[[2007,3,21]],"date-time":"2007-03-21T00:00:00Z","timestamp":1174435200000},"content-version":"vor","delay-in-days":7749,"URL":"http:\/\/onlinelibrary.wiley.com\/termsAndConditions#vor"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Systems &amp; Computers in Japan"],"published-print":{"date-parts":[[1986,1]]},"abstract":"<jats:title>Abstract<\/jats:title><jats:p>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\u2010speed 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 the procedure program size. The following conclusions are drawn from the experiments.<\/jats:p><jats:p>(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.<\/jats:p>","DOI":"10.1002\/scj.4690170202","type":"journal-article","created":{"date-parts":[[2007,7,7]],"date-time":"2007-07-07T11:17:19Z","timestamp":1183807039000},"page":"12-20","source":"Crossref","is-referenced-by-count":0,"title":["Data Abstraction Technique for Relational Database Query Processing"],"prefix":"10.1002","volume":"17","author":[{"given":"Takumi","family":"Ohtani","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Takanobu","family":"Baba","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Masayuki","family":"Inagawa","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Takao","family":"Iwasaki","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kenzo","family":"Okuda","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Katsuhirc","family":"Yamazaki","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"311","published-online":{"date-parts":[[2007,3,21]]},"reference":[{"key":"e_1_2_1_2_2","first-page":"4","volume-title":"An object\u2014oriented approach to database system implementation","author":"Baroody A. J.","year":"1981"},{"key":"e_1_2_1_3_2","article-title":"Query processing by the schema conversion approach, Technical Group on Database Systems","volume":"34","author":"Ohtani T.","year":"1983","journal-title":"Information Processing Society of Japan"},{"key":"e_1_2_1_4_2","doi-asserted-by":"publisher","DOI":"10.1145\/320473.320476"},{"key":"e_1_2_1_5_2","doi-asserted-by":"publisher","DOI":"10.1145\/320141.320158"},{"key":"e_1_2_1_6_2","doi-asserted-by":"publisher","DOI":"10.1145\/320455.320457"},{"key":"e_1_2_1_7_2","unstructured":"D. D.Chamberlin A. M.Gilbertet al. A history of system R and SQL\/DATA system Proc. 7th VLDB pp.456\u2013464(1981)."},{"key":"e_1_2_1_8_2","first-page":"6","article-title":"Architecture of a two\u2010level microprogrammed computer MUNAP","volume":"64","author":"Baba T.","year":"1981","journal-title":"Trans. I.E.C.E., Japan"}],"container-title":["Systems and Computers in Japan"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.wiley.com\/onlinelibrary\/tdm\/v1\/articles\/10.1002%2Fscj.4690170202","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/pdf\/10.1002\/scj.4690170202","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,10,21]],"date-time":"2023-10-21T05:50:08Z","timestamp":1697867408000},"score":1,"resource":{"primary":{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/10.1002\/scj.4690170202"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1986,1]]},"references-count":7,"journal-issue":{"issue":"2","published-print":{"date-parts":[[1986,1]]}},"alternative-id":["10.1002\/scj.4690170202"],"URL":"https:\/\/doi.org\/10.1002\/scj.4690170202","archive":["Portico"],"relation":{},"ISSN":["0882-1666","1520-684X"],"issn-type":[{"value":"0882-1666","type":"print"},{"value":"1520-684X","type":"electronic"}],"subject":[],"published":{"date-parts":[[1986,1]]}}}