{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,8,20]],"date-time":"2024-08-20T17:10:57Z","timestamp":1724173857708},"reference-count":33,"publisher":"Elsevier BV","issue":"1","license":[{"start":{"date-parts":[[1987,1,1]],"date-time":"1987-01-01T00:00:00Z","timestamp":536457600000},"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":[[1987,1]]},"DOI":"10.1016\/0306-4379(87)90021-4","type":"journal-article","created":{"date-parts":[[2003,8,7]],"date-time":"2003-08-07T21:31:39Z","timestamp":1060291899000},"page":"99-114","source":"Crossref","is-referenced-by-count":98,"title":["SQL\/NF: A query language for \u00ac1NF relational databases"],"prefix":"10.1016","volume":"12","author":[{"given":"Mark A.","family":"Roth","sequence":"first","affiliation":[]},{"given":"Henry F.","family":"Korth","sequence":"additional","affiliation":[]},{"given":"Don S.","family":"Batory","sequence":"additional","affiliation":[]}],"member":"78","reference":[{"key":"10.1016\/0306-4379(87)90021-4_BIB1","article-title":"Extended algebra and calculus for \u00ac1NF relational databases","author":"Roth","year":"1984"},{"issue":"6","key":"10.1016\/0306-4379(87)90021-4_BIB2","doi-asserted-by":"crossref","first-page":"560","DOI":"10.1147\/rd.206.0560","article-title":"SEQUEL 2: A unified approach to data definition, manipulation, and control","volume":"20","author":"Chamberlin","year":"1976","journal-title":"IBMJ. Res. Del."},{"issue":"3","key":"10.1016\/0306-4379(87)90021-4_BIB3","doi-asserted-by":"crossref","first-page":"8","DOI":"10.1145\/984549.984551","article-title":"A critique of the SQL database language","volume":"14","author":"Date","year":"1984","journal-title":"Ass. Comput. Mach. SIGMOD Rec."},{"issue":"3","key":"10.1016\/0306-4379(87)90021-4_BIB4","doi-asserted-by":"crossref","first-page":"1","DOI":"10.1145\/984549.984550","article-title":"Some principles of good language design with especial reference to the design of database languages","volume":"14","author":"Date","year":"1984","journal-title":"Ass. Comput. Mach. SIGMOD Rec."},{"key":"10.1016\/0306-4379(87)90021-4_BIB5","series-title":"X3H2-84-2, (Draft proposed) relational database language","year":"1984"},{"key":"10.1016\/0306-4379(87)90021-4_BIB6","series-title":"Proc. 3rd Int. Conf. on Very Large Databases","first-page":"447","article-title":"A consideration on normal form of not-necessarily-normalized relation in the relational data model","author":"Makinouchi","year":"1977"},{"key":"10.1016\/0306-4379(87)90021-4_BIB7","series-title":"Pro. ACM SIGACT-SIGMOD Symp. on Principles of Database Systems","first-page":"124","article-title":"Remarks on the algebra of non first normal form relations","author":"Jaeschke","year":"1982"},{"key":"10.1016\/0306-4379(87)90021-4_BIB8","series-title":"The Theory of Databases","article-title":"Nested relational structures","author":"Thomas","year":"1985"},{"key":"10.1016\/0306-4379(87)90021-4_BIB9","doi-asserted-by":"crossref","first-page":"201","DOI":"10.1016\/0020-0255(83)90016-6","article-title":"Synthesis of unnormalized relations incorporating more meaning","volume":"29","author":"Kambayashi","year":"1983","journal-title":"Inform. Sci."},{"key":"10.1016\/0306-4379(87)90021-4_BIB10","series-title":"Pro. 11th Int. Conf. on Very Large Databases","first-page":"171","article-title":"Determining when a structure is a nested relation","author":"Fischer","year":"1985"},{"key":"10.1016\/0306-4379(87)90021-4_BIB11","series-title":"Proc. ACM SIGACT-SIGMOD Symp. on Principles of Database Systems","first-page":"266","article-title":"Weak multivalued dependencies","author":"Fischer","year":"1984"},{"key":"10.1016\/0306-4379(87)90021-4_BIB12","series-title":"Proc. 2nd Int. (LBL) Conf. on Statistical Database Management","first-page":"202","article-title":"An extension of relational algebra for summary tables","author":"\u00d6zsoyo\u01e7lu","year":"1983"},{"key":"10.1016\/0306-4379(87)90021-4_BIB13","series-title":"Proc. ACM SIGACT-SIGMOD Symp. on Principles of Database Systems","first-page":"251","article-title":"A normal form for nested relations","author":"\u00d6zsoyo\u01e7lu","year":"1985"},{"key":"10.1016\/0306-4379(87)90021-4_BIB14","article-title":"Non first normal form relations: an algebra allowing data restructuring","author":"Abiteboul","year":"1984"},{"key":"10.1016\/0306-4379(87)90021-4_BIB15","article-title":"Nonrecursive algebra for relations with relation valued attributes","author":"Jaeschke","year":"1985"},{"key":"10.1016\/0306-4379(87)90021-4_BIB16","article-title":"Recursive algebra for relation valued attributes","author":"Jaeschke","year":"1985"},{"key":"10.1016\/0306-4379(87)90021-4_BIB17","series-title":"Sprachen f\u00fcr Datenbanken","article-title":"Eine sequelarige Sprachschnittstelle f\u00fcr das NF2-Modell","author":"Pistor","year":"1983"},{"key":"10.1016\/0306-4379(87)90021-4_BIB18","series-title":"Int. Conf. on Foundations of Data Organization","first-page":"173","article-title":"Towards a basic relational NF2 algebra processor","author":"Schek","year":"1985"},{"key":"10.1016\/0306-4379(87)90021-4_BIB19","article-title":"An algebra for the relational model with relation-valued attributes","author":"Schek","year":"1984"},{"key":"10.1016\/0306-4379(87)90021-4_BIB20","series-title":"Sprachen f\u00fcr Datenbanken","article-title":"Die NF2-Relationen-algebra zur einheitlichen Manipulation externer, Konzeptueller und interner Datenstrukturen","author":"Schek","year":"1983"},{"key":"10.1016\/0306-4379(87)90021-4_BIB21","series-title":"Applied Database Logic I: Fundamental Database Issues","author":"Jacobs","year":"1984"},{"key":"10.1016\/0306-4379(87)90021-4_BIB22","first-page":"243","article-title":"SEQUEL as a language for document retrieval","author":"Macleod","year":"1979","journal-title":"J. Am. Soc. Inform. Sci."},{"key":"10.1016\/0306-4379(87)90021-4_BIB23","article-title":"Null values in \u00ac1NF relational databases","author":"Roth","year":"1985"},{"key":"10.1016\/0306-4379(87)90021-4_BIB24","series-title":"ICOD-2 Proc. 2nd Int. Conf. on Databases","first-page":"76","article-title":"The outer join","author":"Date","year":"1983"},{"key":"10.1016\/0306-4379(87)90021-4_BIB25","series-title":"Information Retrieval Research","first-page":"218","article-title":"Methods for the administration of textual data in database systems","author":"Schek","year":"1981"},{"issue":"1","key":"10.1016\/0306-4379(87)90021-4_BIB26","doi-asserted-by":"crossref","first-page":"140","DOI":"10.1145\/319540.319561","article-title":"The functional model and the data language DAPLEX","volume":"6","author":"Shipman","year":"1981","journal-title":"Ass. comput. Mach. Trans. Database Systems"},{"key":"10.1016\/0306-4379(87)90021-4_BIB27","series-title":"Proc. ACM-SIGMOD Conf. on Management of Data","first-page":"207","article-title":"The database language GEM","author":"Zaniolo","year":"1983"},{"key":"10.1016\/0306-4379(87)90021-4_BIB28","series-title":"Proc. 7th Int. Computer Software Application Conf.","first-page":"571","article-title":"A unified query-by-example information manipulation language based on functional data model","author":"Hsieh","year":"1983"},{"issue":"1","key":"10.1016\/0306-4379(87)90021-4_BIB29","doi-asserted-by":"crossref","first-page":"40","DOI":"10.1109\/TSE.1983.236169","article-title":"A generalized query-by-example data manipulation language based on database logic","volume":"9","author":"Jacobs","year":"1983","journal-title":"IEEE Trans. Software Enging"},{"key":"10.1016\/0306-4379(87)90021-4_BIB30","series-title":"Applied Database Logic II: Heterogeneous Distributed Query Processing","author":"Jacobs","year":"1985"},{"issue":"2","key":"10.1016\/0306-4379(87)90021-4_BIB31","doi-asserted-by":"crossref","first-page":"65","DOI":"10.1007\/BF00993194","article-title":"Application of SQL\/N to the attribute-relation associations implicit in functional dependencies","volume":"12","author":"Bradley","year":"1983","journal-title":"Int. J. Comput. Inform. Sci."},{"key":"10.1016\/0306-4379(87)90021-4_BIB32","article-title":"A database language for sets, lists, and tables","author":"Pistor","year":"1985"},{"key":"10.1016\/0306-4379(87)90021-4_BIB33","series-title":"Proc. 8th Int. Conf. on Very Large Databases","first-page":"197","article-title":"Data structures for an integrated database management and information retrieval system","author":"Schek","year":"1982"}],"container-title":["Information Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0306437987900214?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0306437987900214?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2019,3,15]],"date-time":"2019-03-15T00:53:16Z","timestamp":1552611196000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/0306437987900214"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1987,1]]},"references-count":33,"journal-issue":{"issue":"1","published-print":{"date-parts":[[1987,1]]}},"alternative-id":["0306437987900214"],"URL":"https:\/\/doi.org\/10.1016\/0306-4379(87)90021-4","relation":{},"ISSN":["0306-4379"],"issn-type":[{"value":"0306-4379","type":"print"}],"subject":[],"published":{"date-parts":[[1987,1]]}}}