{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2022,4,2]],"date-time":"2022-04-02T07:56:38Z","timestamp":1648886198500},"reference-count":61,"publisher":"Elsevier BV","issue":"3","license":[{"start":{"date-parts":[[1990,8,1]],"date-time":"1990-08-01T00:00:00Z","timestamp":649468800000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Information Sciences"],"published-print":{"date-parts":[[1990,8]]},"DOI":"10.1016\/0020-0255(90)90029-a","type":"journal-article","created":{"date-parts":[[2003,6,30]],"date-time":"2003-06-30T17:28:37Z","timestamp":1056994117000},"page":"263-288","source":"Crossref","is-referenced-by-count":1,"title":["A knowledge-based system for performance optimization of a relational database system"],"prefix":"10.1016","volume":"51","author":[{"given":"Rokia","family":"Missaoui","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Claude","family":"Frasson","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"78","reference":[{"issue":"1","key":"10.1016\/0020-0255(90)90029-A_BIB1","doi-asserted-by":"crossref","first-page":"68","DOI":"10.1145\/320521.320537","article-title":"Minimum cost selection of secondary indexes for formatted files","author":"Anderson","year":"1977","journal-title":"ACM Trans. Database Systems"},{"key":"10.1016\/0020-0255(90)90029-A_BIB2","series-title":"Proceedings of IFIP '74","first-page":"580","article-title":"Dependency structures of database relationship","author":"Armstrong","year":"1974"},{"key":"10.1016\/0020-0255(90)90029-A_BIB3","first-page":"487","article-title":"Performance of the System R access path selection mechanism","volume":"80","author":"Astrahan","year":"1980","journal-title":"Inform. Process."},{"key":"10.1016\/0020-0255(90)90029-A_BIB4","series-title":"Expos\u00e9 \u00c9l\u00e9mentaire","article-title":"Pratique de l'Analyse des Donn\u00e9es. Analyse des Corespondances","author":"Benzekri","year":"1980"},{"issue":"1","key":"10.1016\/0020-0255(90)90029-A_BIB5","doi-asserted-by":"crossref","first-page":"25","DOI":"10.1145\/322234.322238","article-title":"Using semi-joins to solve relational queries","author":"Bernstein","year":"1981","journal-title":"J. Assoc. Comput. Mach."},{"issue":"4","key":"10.1016\/0020-0255(90)90029-A_BIB6","doi-asserted-by":"crossref","first-page":"363","DOI":"10.1147\/sj.164.0363","article-title":"Storage and access in relational bases","volume":"16","author":"Blasgen","year":"1977","journal-title":"IBM System J."},{"key":"10.1016\/0020-0255(90)90029-A_BIB7","author":"Bobrow","year":"1983"},{"key":"10.1016\/0020-0255(90)90029-A_BIB8","series-title":"On Conceptual Modelling. Perspectives from Artificial Intelligence, Databases and Programming Languages","year":"1984"},{"key":"10.1016\/0020-0255(90)90029-A_BIB9","series-title":"Proceedings of the ACM SIGACT-SIGMOD Conference on Principles of Database Systems","first-page":"171","article-title":"Inclusion dependencies and their interaction with functional dependencies","author":"Casanova","year":"1982"},{"key":"10.1016\/0020-0255(90)90029-A_BIB10","series-title":"Proceedings of the 3rd VLDB Conference","first-page":"3","article-title":"Design and performance tools for data base systems","author":"Chen","year":"1977"},{"key":"10.1016\/0020-0255(90)90029-A_BIB11","doi-asserted-by":"crossref","unstructured":"S. Christodoulakis, Estimating block transfers and join sizes, in Proceedings of the SIGMOD 1983 Conference, San Jose, Calif., 23\u201326 May, ACM, New York, pp. 40\u201354.","DOI":"10.1145\/582192.582204"},{"key":"10.1016\/0020-0255(90)90029-A_BIB12","doi-asserted-by":"crossref","unstructured":"C. J. Date and P. Hopewell, Storage structure and physical data independence, in Proceedings of the 1971 ACM SIGFIDET Workshop on Data Description, Access and Control.","DOI":"10.1145\/1734714.1734725"},{"key":"10.1016\/0020-0255(90)90029-A_BIB13","volume":"Vol. I","author":"Date","year":"1986"},{"key":"10.1016\/0020-0255(90)90029-A_BIB14","series-title":"presented at International Symposium and Exhibition","article-title":"Determination of an optimal set of secondary keys for formatted files, Online 72","author":"Delobel","year":"1972"},{"key":"10.1016\/0020-0255(90)90029-A_BIB15","series-title":"Proceedings of the 6th Conference on VLDB","first-page":"55","article-title":"Estimation of the number of tuples satisfying a query expressed in predicate calculus language","author":"Demolombe","year":"1980"},{"key":"10.1016\/0020-0255(90)90029-A_BIB16","series-title":"VIe Journ\u00e9es Informatiques","first-page":"73","article-title":"Amelioration des performances des SGBD relationnels","author":"Demolombe","year":"1982"},{"key":"10.1016\/0020-0255(90)90029-A_BIB17","doi-asserted-by":"crossref","unstructured":"E. A. Feigenbaum, Knowledge engineering: The applied side, in Intelligent Systems, the Unprecedented Opportunity, J. E. Hayes and D. Michie, Eds., Wiley, pp. 37\u201355.","DOI":"10.1111\/j.1749-6632.1984.tb16513.x"},{"key":"10.1016\/0020-0255(90)90029-A_BIB18","series-title":"Advances in Information Technology","article-title":"A dependency principle in database systems, presented at Trends and Applications 1982","author":"Frasson","year":"1982"},{"key":"10.1016\/0020-0255(90)90029-A_BIB19","series-title":"VIe Journ\u00e9es Informatiques","first-page":"103","article-title":"M\u00e9thodes d'\u00e9valuation de performance dans les SGBD","author":"Frasson","year":"1982"},{"key":"10.1016\/0020-0255(90)90029-A_BIB20","series-title":"International Conference on Modelling Techniques and Tools for Performance Analysis '85, AFCET, ACM, IEEE","article-title":"Performance administration using an expert system approach","author":"Frasson","year":"1986"},{"key":"10.1016\/0020-0255(90)90029-A_BIB21","series-title":"Logic and Databases","author":"Gallaire","year":"1978"},{"issue":"2","key":"10.1016\/0020-0255(90)90029-A_BIB22","doi-asserted-by":"crossref","first-page":"153","DOI":"10.1145\/356924.356929","article-title":"Logic and Databases: A deductive approach","volume":"16","author":"Gallaire","year":"1984","journal-title":"Comput. Surveys"},{"key":"10.1016\/0020-0255(90)90029-A_BIB23","series-title":"Proceedings of the ACM SIGMOD International Conference on Management of Data","first-page":"55","article-title":"Computing joins of relations","author":"Gotlieb","year":"1975"},{"key":"10.1016\/0020-0255(90)90029-A_BIB24","series-title":"ACM SIGMOD Conference","first-page":"26","article-title":"The semantic data model: A modelling mechanism fordatabase models","author":"Hammer","year":"1978"},{"key":"10.1016\/0020-0255(90)90029-A_BIB25","series-title":"Building Expert Systems","year":"1983"},{"key":"10.1016\/0020-0255(90)90029-A_BIB26","first-page":"296","article-title":"An optimizing prolog front-end to a relational query system","author":"Jarke","year":"1984"},{"issue":"2","key":"10.1016\/0020-0255(90)90029-A_BIB27","doi-asserted-by":"crossref","first-page":"111","DOI":"10.1145\/356924.356928","article-title":"Query optimization in relational database systems","volume":"16","author":"Jarke","year":"1984","journal-title":"Comput. Surveys"},{"key":"10.1016\/0020-0255(90)90029-A_BIB28","series-title":"ACM SIGMOD Conference","first-page":"55","article-title":"Query processing utilizing dependencies and horizontal decomposition","author":"Kambayashi","year":"1983"},{"key":"10.1016\/0020-0255(90)90029-A_BIB29","doi-asserted-by":"crossref","unstructured":"W. Kim, A new way to compute the product and join of relations, in Proceedings of the ACM SIGMOD International Conference on Management of Data, Santa Monica, Calif., 14\u201316 May, ACM, New York, pp. 179\u2013187.","DOI":"10.1145\/582250.582278"},{"issue":"3","key":"10.1016\/0020-0255(90)90029-A_BIB30","doi-asserted-by":"crossref","first-page":"443","DOI":"10.1145\/319732.319745","article-title":"On optimizing an sql-like nested query","volume":"17","author":"Kim","year":"1982","journal-title":"ACM Trans. Database Systems"},{"key":"10.1016\/0020-0255(90)90029-A_BIB31","series-title":"Query Processing in Database Systems","year":"1985"},{"key":"10.1016\/0020-0255(90)90029-A_BIB32","series-title":"Report STAN-CS-81-857, Doctoral Dissertation","article-title":"Query Optimization by Semantic Reasoning","author":"King","year":"1981"},{"key":"10.1016\/0020-0255(90)90029-A_BIB33","series-title":"Proceedings of the 5th VLDB Conference","first-page":"328","article-title":"New Orleans Data Base Design Workshop report","author":"Lum","year":"1979"},{"key":"10.1016\/0020-0255(90)90029-A_BIB34","series-title":"Proceedings of ACM SIGMOD '86, International Conference on Management of Data","first-page":"84","article-title":"R\u2217 Optimizer validation and performance evaluation for local queries","author":"Mackert","year":"1986"},{"key":"10.1016\/0020-0255(90)90029-A_BIB35","series-title":"ACM SIGMOD","first-page":"52","article-title":"A mathematical modelling approach to the automatic selection of data bases designs","author":"March","year":"1978"},{"key":"10.1016\/0020-0255(90)90029-A_BIB36","article-title":"Why Sort-Merge Gives the Best Implementation of the Natural Join","author":"Merrett","year":"1981","journal-title":"Technical Report SOCS-81-37"},{"key":"10.1016\/0020-0255(90)90029-A_BIB37","series-title":"Optimisation d'un Syst\u00e8me de Bases de Donn\u00e9es Relationnel par Syst\u00e8me Expert, Document de travail 172","author":"Missaoui","year":"1985"},{"issue":"3","key":"10.1016\/0020-0255(90)90029-A_BIB38","first-page":"338","article-title":"Une approache d'acquisition de connaissances pour l'optimisation d'une base de donn\u00e9es relationnelle","volume":"27","author":"Missaoui","year":"1989","journal-title":"INFOR"},{"key":"10.1016\/0020-0255(90)90029-A_BIB39","series-title":"ACM Annual Conference","first-page":"439","article-title":"A detailed statistical model for relational query optimization","author":"Muthuswamy","year":"1985"},{"key":"10.1016\/0020-0255(90)90029-A_BIB40","series-title":"Oracle Database Administrator's Guide: Version 5.1","year":"1986"},{"key":"10.1016\/0020-0255(90)90029-A_BIB41","series-title":"Proceedings of the Logic Programming Workshop","first-page":"271","article-title":"Database management, knowledge base management and expert system development in Prolog","author":"Parsaye","year":"1983"},{"key":"10.1016\/0020-0255(90)90029-A_BIB42","doi-asserted-by":"crossref","unstructured":"P. Richard, Evaluation of the size of a query expressed in relational algebra, Proceedings of the ACM SIGMOD International Conference on Management of Data, Ann Arbor, Mich., 29 Apr.\u20131 May, ACM, New York, pp. 155\u2013163.","DOI":"10.1145\/582318.582343"},{"issue":"No. 3","key":"10.1016\/0020-0255(90)90029-A_BIB43","article-title":"Modeling the information space in physical storage at different levels of detail","volume":"20","author":"Scheuermann","year":"1977","journal-title":"Comput. J."},{"key":"10.1016\/0020-0255(90)90029-A_BIB44","series-title":"Proceedings of the 4th International Conference on VLDB","first-page":"474","article-title":"A survey of physical data base design methodology and techniques","author":"Schkolnick","year":"1978"},{"issue":"2","key":"10.1016\/0020-0255(90)90029-A_BIB45","doi-asserted-by":"crossref","first-page":"163","DOI":"10.1145\/3857.3863","article-title":"Estimating the cost of updates in a relational database","volume":"10","author":"Schkolnick","year":"1985","journal-title":"ACM Trans. Database Systems"},{"key":"10.1016\/0020-0255(90)90029-A_BIB46","series-title":"Proceedings of ACM SIGMOD International Conference on Management of Data","first-page":"23","article-title":"Access path selection in a relational database management system","author":"Selinger","year":"1979"},{"key":"10.1016\/0020-0255(90)90029-A_BIB47","series-title":"Systems for Large Data Bases","first-page":"79","article-title":"diam-ii and levels of abstraction, the physical device level: A general model for access methods","author":"Senko","year":"1976"},{"key":"10.1016\/0020-0255(90)90029-A_BIB48","series-title":"Proceedings of the 7th International Conference on VLDB","first-page":"182","article-title":"Database system performance prediction using an analytical model","author":"Sevcik","year":"1981"},{"issue":"10","key":"10.1016\/0020-0255(90)90029-A_BIB49","doi-asserted-by":"crossref","first-page":"568","DOI":"10.1145\/361020.361025","article-title":"Optimizing the performance of a relational algebra database interface","volume":"18","author":"Smith","year":"1975","journal-title":"Comm. ACM"},{"key":"10.1016\/0020-0255(90)90029-A_BIB50","series-title":"Proceedings of the Logic Programming Workshop","first-page":"217","article-title":"Knowledge representation in an efficient deductive information system","author":"Stabler","year":"1983"},{"issue":"2","key":"10.1016\/0020-0255(90)90029-A_BIB51","doi-asserted-by":"crossref","first-page":"167","DOI":"10.1145\/319983.319984","article-title":"Performance enhancements to a relational database system","volume":"8","author":"Stonebraker","year":"1983","journal-title":"ACM Trans. Database Systems"},{"key":"10.1016\/0020-0255(90)90029-A_BIB52","series-title":"The ANSI\/X3\/SPARC DBMS framework: Report of the Study Group on Data Base Management Systems","volume":"Vol. 3","year":"1978"},{"key":"10.1016\/0020-0255(90)90029-A_BIB53","series-title":"Principles of Database Systems","author":"Ullman"},{"key":"10.1016\/0020-0255(90)90029-A_BIB54","doi-asserted-by":"crossref","unstructured":"Y. Vassiliou, J. Clifford and M. Jarke, Database access requirements of knowledge-based systems, in [31], pp. 156\u2013170.","DOI":"10.1007\/978-3-642-82375-6_9"},{"key":"10.1016\/0020-0255(90)90029-A_BIB55","series-title":"Proceedings of 7th International Conference on VLDB","first-page":"272","article-title":"Efficient processing of interactive relational database queries expressed in logic","author":"Warren","year":"1981"},{"key":"10.1016\/0020-0255(90)90029-A_BIB56","series-title":"A Guide to Expert Systems","author":"Waterman","year":"1986"},{"key":"10.1016\/0020-0255(90)90029-A_BIB57","series-title":"Proceedings of ACM SIGMOD","first-page":"66","article-title":"Evaluation of database access paths","author":"Yao","year":"1978"},{"issue":"2","key":"10.1016\/0020-0255(90)90029-A_BIB58","doi-asserted-by":"crossref","first-page":"133","DOI":"10.1145\/320071.320072","article-title":"Optimization of query evaluation algorithms","volume":"4","author":"Yao","year":"1979","journal-title":"ACM Trans. Database Systems"},{"key":"10.1016\/0020-0255(90)90029-A_BIB59","series-title":"Proceedings of the 3rd VLDB Conference","first-page":"16","article-title":"Toward a design methodology for DBMS: A Software engineering approach","author":"Yeh","year":"1977"},{"key":"10.1016\/0020-0255(90)90029-A_BIB60","series-title":"Proceedings of the 5th International Conference on VLDB","first-page":"409","article-title":"Query processing in a relational database management system","author":"Youssefi","year":"1979"},{"key":"10.1016\/0020-0255(90)90029-A_BIB61","series-title":"International Conference on Management of Data ACM SIGMOD","first-page":"280","article-title":"Adaptive information system design one query at a time","author":"Yu","year":"1985"}],"container-title":["Information Sciences"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:002002559090029A?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:002002559090029A?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2020,3,24]],"date-time":"2020-03-24T15:51:49Z","timestamp":1585065109000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/002002559090029A"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1990,8]]},"references-count":61,"journal-issue":{"issue":"3","published-print":{"date-parts":[[1990,8]]}},"alternative-id":["002002559090029A"],"URL":"https:\/\/doi.org\/10.1016\/0020-0255(90)90029-a","relation":{},"ISSN":["0020-0255"],"issn-type":[{"value":"0020-0255","type":"print"}],"subject":[],"published":{"date-parts":[[1990,8]]}}}