{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,7,10]],"date-time":"2024-07-10T15:22:20Z","timestamp":1720624940451},"reference-count":38,"publisher":"Elsevier BV","license":[{"start":{"date-parts":[[2003,4,1]],"date-time":"2003-04-01T00:00:00Z","timestamp":1049155200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"},{"start":{"date-parts":[[2013,7,29]],"date-time":"2013-07-29T00:00:00Z","timestamp":1375056000000},"content-version":"vor","delay-in-days":3772,"URL":"http:\/\/creativecommons.org\/licenses\/by-nc-nd\/3.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Electronic Notes in Theoretical Computer Science"],"published-print":{"date-parts":[[2003,4]]},"DOI":"10.1016\/s1571-0661(04)81007-7","type":"journal-article","created":{"date-parts":[[2004,9,29]],"date-time":"2004-09-29T12:47:47Z","timestamp":1096462067000},"page":"82-99","source":"Crossref","is-referenced-by-count":3,"special_numbering":"C","title":["Three approaches to partiality in the sketch data model1 1Research partially supported by the Australian Research Council and NSERC Canada."],"prefix":"10.1016","volume":"78","author":[{"given":"Michael","family":"Johnson","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Robert","family":"Rosebrugh","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"78","reference":[{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB1","series-title":"Category theory for computing science","author":"Barr","year":"1995"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB2","doi-asserted-by":"crossref","first-page":"147","DOI":"10.1017\/S0960129500000426","article-title":"A categorical approach to database semantics","volume":"4","author":"Baclawski","year":"1994","journal-title":"Mathematical Structures in Computer Science"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB3","series-title":"Handbook of Categorical Algebra 3","author":"Borceux","year":"1994"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB4","first-page":"9","volume":"2","author":"Chen","year":"1976","journal-title":"The Entity-Relationship Model\u2013-Toward a Uni\u00e9d View of Data"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB5","series-title":"Date Relational Database Writings","first-page":"1991","article-title":"Date Much ado about nothing","author":"Codd","year":"1995"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB6","unstructured":"C. N. G. Dampney and Michael Johnson. TIME Compliant Corporate Data Model Validation. Consultants' report to Telecom Australia, 1991."},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB7","unstructured":"C. N. G. Dampney and Michael Johnson. Fibrations and the DoH Data Model. Consultants' report to NSW Department of health, 1999."},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB8","unstructured":"C. N. G. Dampney and Michael Johnson. A formal method for enterprise interoperablity: A case study in a major health informatics information system. Proceedings of the Thirteenth International Conference on Software and Systems Engineering, CNAM Paris, vol 3, 12\u20135, 1\u20136, 2000."},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB9","unstructured":"C. N. G. Dampney and Michael Johnson. Half-duplex interoperations for cooperating information systems. In Advances in Concurrent Engineering, IN-1, 7pp, International Institute of Concurrent Engineering, ISBN 09710461-0-7, 2001."},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB10","unstructured":"C. N. G. Dampney, Michael Johnson and G. M. McGrath. Audit and Enhancement of the Caltex Oil Australia, 1994."},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB11","unstructured":"C. N. G. Dampney, Michael Johnson, and Robert Rosebrugh. View Updates in a Semantic Data Model Paradigm. Proceedings of the Twelfth Australasian Database Conference ADC2001, 29\u201336, IEEE Press, 2001."},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB12","unstructured":"C.N.G Dampney, Graham Pegler and Michael Johnson. Harmonising Health Information Models - a critical analysis of current practice. Proceedings of the Health Informatics Conference 2001, 8pp. ISBN: 0 9585370 8 9"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB13","series-title":"NOT is not \u201cNot\u201d! in Date Relational Database Writings","first-page":"1985","author":"Date","year":"1990"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB14","series-title":"EXISTS is not \u201cExists\u201d!(Some logical aws in SQL). in Date RElational Database Writings","first-page":"1985","author":"Date","year":"1990"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB15","series-title":"Watch out for outer join. in Date and Darwen Relational Database Writings","first-page":"1989","author":"Date","year":"1992"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB16","series-title":"Oh no not Nulls again. in Date and Darwen Relational Database Writings","first-page":"1989","author":"Date","year":"1992"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB17","series-title":"Faults and defaults (in \u00a3ve parts). in Date, Darwen and McGoveran Relational Database Writings","first-page":"1994","author":"Date","year":"1998"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB18","series-title":"Introduction to Database Systems","author":"Date","year":"2000"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB19","volume":"21","author":"Dey","year":"1996","journal-title":"A probabilistic relational model and algebra"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB20","unstructured":"Zinovy Diskin and Boris Cadish. Algebraic graph-based approach to management of multidatabase systems. In Proceedings of The Second International Workshop on Next Generation Information Technologies and Systems (NGITS'95), 1995."},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB21","series-title":"Data and Knowledge Engineering","article-title":"Variable set semantics for generalised sketches: Why ER is more object oriented than OO","author":"Diskin","year":"2000"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB22","doi-asserted-by":"crossref","DOI":"10.1145\/244810.244812","article-title":"Outerjoin simpli\u00a3cation and reordering for query optimization","volume":"22","author":"Galindo-Legaria","year":"1997","journal-title":"ACM TODS"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB23","doi-asserted-by":"crossref","unstructured":"P. Goel and B. Iyer. SQL query optimization reordering for a general class of queries. In Proceedings of ADDM SIGMOD, 1996.","DOI":"10.1145\/233269.233318"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB24","doi-asserted-by":"crossref","first-page":"369","DOI":"10.1145\/111197.111200","article-title":"Towards a semantic view of an extended entity-relationship model","volume":"16","author":"Gogolla","year":"1991","journal-title":"ACM TODS"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB25","doi-asserted-by":"crossref","unstructured":"A. Islam and W. Phoa. Categorical models of relational databases I: Fibrational formulation, schema integration. Proceedings of TACS94. Eds M. Hagiya and J. C. Mitchell. Lecture Notes in Computer Science, 789, 618\u2013641, 1994","DOI":"10.1007\/3-540-57887-0_118"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB26","doi-asserted-by":"crossref","unstructured":"Michael Johnson and C. N. G. Dampney. On the value of commutative diagrams in information modelling. In Algebraic Methodology and Software Technology, springer Workshops in Computing, 1994.","DOI":"10.1007\/978-1-4471-3227-1_5"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB27","doi-asserted-by":"crossref","unstructured":"Michael Johnson and Robert Rosebrugh. View updatability based on the models of a formal speci\u00a3cation. Proceedings of FME 2001, 534\u2013549, Lecture Notes in Computer Science 2021, 2001.","DOI":"10.1007\/3-540-45251-6_31"},{"issue":"6","key":"10.1016\/S1571-0661(04)81007-7_NEWBIB28","first-page":"1","volume":"Volume 61","author":"Johnson","year":"2002","journal-title":"Sketch Data Models, Relational Schema and Data Speci\u00a3cations"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB29","first-page":"2","article-title":"Database interoperability through state based logical data independence","volume":"16 number","author":"Johnson","year":"2003","journal-title":"International Journal of Computer Applications in Technology"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB30","first-page":"94","article-title":"Entity-relationship models and sketches","volume":"10","author":"Johnson","year":"2002","journal-title":"Theory and Applications of Categories"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB31","doi-asserted-by":"crossref","first-page":"262","DOI":"10.1007\/BFb0084225","article-title":"Algebras for the partial map classi\u00e9r monad","volume":"1488","author":"Kock","year":"1991","journal-title":"Lecture Notes in Mathematics"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB32","doi-asserted-by":"crossref","first-page":"31","DOI":"10.1051\/ita\/1996300100311","article-title":"A category theoretical approach to conceptual data modelling","volume":"30","author":"Lippe","year":"1996","journal-title":"RAIRO Theoretical Informatics and Applications"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB33","doi-asserted-by":"crossref","DOI":"10.1145\/77643.77644","article-title":"Inde\u00a3nite and maybe information in relational databases","volume":"15","author":"Liu","year":"1990","journal-title":"ACM TODS"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB34","first-page":"159","article-title":"Categorical data Speci\u00a3cations","volume":"1","author":"Piessens","year":"19925","journal-title":"Theory and Applications of Categories"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB35","doi-asserted-by":"crossref","unstructured":"F. Piessens and Eric Steegmans. Selective Attribute Elimination for Categorical Data Speci\u00a3cations. Proceedings of the 6th International AMAST 424-436, Lecture Notes in Computer Science, 1349, 1997.","DOI":"10.1007\/BFb0000487"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB36","unstructured":"Robert Rosebrugh and R. J. Wood. Relational databases and indexed categories. In Proceedings of the International Category Theory Meeting 1991, CMS Conference Proceedings 13, 391\u2013407, American Mathematical Society, 1992."},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB37","author":"Southon","year":"1999","journal-title":"Lessons from a failed information systems initiative: issues for complex organisations. International Journal of Medical Informatics, Elsevier Science"},{"key":"10.1016\/S1571-0661(04)81007-7_NEWBIB38","first-page":"217","author":"Tuijn","year":"1996","journal-title":"CGOOD, a categorical graph-oriented object data model. it Theoretical Computer Science 160"}],"container-title":["Electronic Notes in Theoretical Computer Science"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S1571066104810077?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S1571066104810077?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2019,2,3]],"date-time":"2019-02-03T05:53:55Z","timestamp":1549173235000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/S1571066104810077"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2003,4]]},"references-count":38,"alternative-id":["S1571066104810077"],"URL":"https:\/\/doi.org\/10.1016\/s1571-0661(04)81007-7","relation":{},"ISSN":["1571-0661"],"issn-type":[{"value":"1571-0661","type":"print"}],"subject":[],"published":{"date-parts":[[2003,4]]}}}