{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,9,4]],"date-time":"2023-09-04T15:48:58Z","timestamp":1693842538665},"reference-count":29,"publisher":"Elsevier BV","issue":"3","license":[{"start":{"date-parts":[[1985,1,1]],"date-time":"1985-01-01T00:00:00Z","timestamp":473385600000},"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 Systems"],"published-print":{"date-parts":[[1985,1]]},"DOI":"10.1016\/0306-4379(85)90021-3","type":"journal-article","created":{"date-parts":[[2003,8,8]],"date-time":"2003-08-08T01:31:39Z","timestamp":1060306299000},"page":"279-288","source":"Crossref","is-referenced-by-count":10,"title":["Removing redundant join operations in queries involving views"],"prefix":"10.1016","volume":"10","author":[{"given":"Nikolaus","family":"Ott","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Klaus","family":"Horl\u00e4nder","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"78","reference":[{"key":"10.1016\/0306-4379(85)90021-3_BIB1","doi-asserted-by":"crossref","DOI":"10.1145\/320083.320091","article-title":"The theory of joins in relational databases","volume":"4","author":"Aho","year":"1979","journal-title":"ACM Transactions on Database Systems"},{"key":"10.1016\/0306-4379(85)90021-3_BIB2","series-title":"Data Base Systems","article-title":"Further normalization of the data base relational model","author":"Codd","year":"1972"},{"key":"10.1016\/0306-4379(85)90021-3_BIB3","series-title":"Information Processing","article-title":"An overview of the relational data theory","author":"Delobel","year":"1980"},{"key":"10.1016\/0306-4379(85)90021-3_BIB4","doi-asserted-by":"crossref","DOI":"10.1147\/rd.175.0374","article-title":"Decomposition of a data base and the theory of Boolean switching functions","author":"Delobel","year":"1973","journal-title":"IBM Journal of Research and Develop."},{"issue":"3","key":"10.1016\/0306-4379(85)90021-3_BIB5","doi-asserted-by":"crossref","DOI":"10.1145\/320557.320571","article-title":"Multivalued dependencies and a new normal form for relational databases","volume":"2","author":"Fagin","year":"1977","journal-title":"ACM Transactions on Database Systems"},{"key":"10.1016\/0306-4379(85)90021-3_BIB6","doi-asserted-by":"crossref","DOI":"10.1145\/582095.582120","article-title":"Normal forms and relational database operators","author":"Fagin","year":"1979"},{"key":"10.1016\/0306-4379(85)90021-3_BIB7","series-title":"Proc. 5th Int. Conf. on Very Large Data Bases","article-title":"Generalized mutual dependencies and the decomposition of database relations","author":"Mendelzon","year":"1979"},{"key":"10.1016\/0306-4379(85)90021-3_BIB8","series-title":"Proc. 4th Int. Conf. on Very Large Data Bases","article-title":"Mutual dependencies and some results on undecomposable relations","author":"Nicolas","year":"1978"},{"issue":"4","key":"10.1016\/0306-4379(85)90021-3_BIB9","doi-asserted-by":"crossref","DOI":"10.1145\/320576.320580","article-title":"Independent components of relations","volume":"2","author":"Rissanen","year":"1977","journal-title":"ACM Transactions on Database Systems"},{"key":"10.1016\/0306-4379(85)90021-3_BIB10","series-title":"AICA Congress","article-title":"Denormalization: a performance oriented database design technique","author":"Schkolnick","year":"1980"},{"key":"10.1016\/0306-4379(85)90021-3_BIB11","article-title":"Optimization of single expressions in a relational data base system","volume":"3","author":"Hall","year":"1976","journal-title":"IBM Journal of Res. and Dev."},{"key":"10.1016\/0306-4379(85)90021-3_BIB12","article-title":"Query optimization for relational database systems","author":"Kim","year":"1981"},{"issue":"3","key":"10.1016\/0306-4379(85)90021-3_BIB13","doi-asserted-by":"crossref","DOI":"10.1147\/rd.233.0286","article-title":"An access specification language for a relational data base system","volume":"23","author":"Lorie","year":"1979","journal-title":"IBM Journal of Res. and Dev."},{"key":"10.1016\/0306-4379(85)90021-3_BIB14","doi-asserted-by":"crossref","DOI":"10.1145\/582095.582099","article-title":"Access path selection in a relational database management system","author":"Selinger","year":"1979"},{"issue":"3","key":"10.1016\/0306-4379(85)90021-3_BIB15","doi-asserted-by":"crossref","DOI":"10.1145\/320473.320479","article-title":"Decomposition\u2014a strategy for query processing","volume":"1","author":"Wong","year":"1976","journal-title":"ACM Transactions on Database Systems"},{"key":"10.1016\/0306-4379(85)90021-3_BIB16","series-title":"Proc. 9th Annual ACM Symp. on the Theory of Computing","article-title":"Optimal implementation of conjunctive queries in relational data bases","author":"Chandra","year":"1976"},{"key":"10.1016\/0306-4379(85)90021-3_BIB17","series-title":"Proc. Int. Symp. on Very Large Data Bases","article-title":"Equivalence among relational expressions with the union and difference operations","author":"Sagiv","year":"1978"},{"key":"10.1016\/0306-4379(85)90021-3_BIB18","doi-asserted-by":"crossref","DOI":"10.1137\/0208017","article-title":"Equivalences among relational expressions","author":"Aho","year":"1979","journal-title":"SIAM Journal on Computing"},{"key":"10.1016\/0306-4379(85)90021-3_BIB19","series-title":"Principles of Database Systems","author":"Ullman","year":"1980"},{"key":"10.1016\/0306-4379(85)90021-3_BIB20","doi-asserted-by":"crossref","DOI":"10.1016\/0022-0000(84)90081-3","article-title":"Testing containment of conjunctive queries under functional and inclusion dependencies","volume":"28","author":"Johnson","year":"1984","journal-title":"Journal of Computer and System Sciences"},{"key":"10.1016\/0306-4379(85)90021-3_BIB21","article-title":"Elimination of redundant operations in relational queries with general selection operators","author":"Majster-Cederbaum","year":"1983","journal-title":"IBM Heidelberg Scientific Center Technical Report, TR 83.04.002"},{"key":"10.1016\/0306-4379(85)90021-3_BIB22","series-title":"Proceedings ACM-SIGMOD","article-title":"An optimizing front end of a relational query system","author":"Jarke","year":"1984"},{"key":"10.1016\/0306-4379(85)90021-3_BIB23","doi-asserted-by":"crossref","DOI":"10.1147\/rd.206.0560","article-title":"SEQUEL2: a unified approach to data definition, manipulation, and control","volume":"20","author":"Chamberlin","year":"1976","journal-title":"IBM Journal of Res. and Dev."},{"issue":"3","key":"10.1016\/0306-4379(85)90021-3_BIB24","doi-asserted-by":"crossref","DOI":"10.1007\/BF00995890","article-title":"A theory of data dependencies over relational expressions","volume":"12","author":"Casanova","year":"1983","journal-title":"International Journal of Computer and Information Sciences"},{"key":"10.1016\/0306-4379(85)90021-3_BIB25","article-title":"The theory of data dependencies\u2014a survey","author":"Fagin","year":"1984"},{"key":"10.1016\/0306-4379(85)90021-3_BIB26","doi-asserted-by":"crossref","DOI":"10.1016\/0022-0000(84)90079-5","article-title":"Independent database schemas","volume":"28","author":"Graham","year":"1984","journal-title":"Journal of Computer and System Sciences"},{"key":"10.1016\/0306-4379(85)90021-3_BIB27","article-title":"USL\u2014An experimental information system based on natural language","volume":"Vol. 2","author":"Ott","year":"1979"},{"key":"10.1016\/0306-4379(85)90021-3_BIB28","series-title":"Noten am Gymnasium: Zufall oder Notwendigkeit Suedwestdeutsche Schulblaetter 79","author":"Schuetz","year":"1980"},{"key":"10.1016\/0306-4379(85)90021-3_BIB29","article-title":"On optimizing an SQL-like nested query","author":"Kim","year":"1981"}],"container-title":["Information Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0306437985900213?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0306437985900213?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2019,3,15]],"date-time":"2019-03-15T04:52:56Z","timestamp":1552625576000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/0306437985900213"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1985,1]]},"references-count":29,"journal-issue":{"issue":"3","published-print":{"date-parts":[[1985,1]]}},"alternative-id":["0306437985900213"],"URL":"https:\/\/doi.org\/10.1016\/0306-4379(85)90021-3","relation":{},"ISSN":["0306-4379"],"issn-type":[{"value":"0306-4379","type":"print"}],"subject":[],"published":{"date-parts":[[1985,1]]}}}