{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,27]],"date-time":"2025-03-27T18:50:56Z","timestamp":1743101456120,"version":"3.40.3"},"publisher-location":"Cham","reference-count":21,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783031157424"},{"type":"electronic","value":"9783031157431"}],"license":[{"start":{"date-parts":[[2022,1,1]],"date-time":"2022-01-01T00:00:00Z","timestamp":1640995200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2022,1,1]],"date-time":"2022-01-01T00:00:00Z","timestamp":1640995200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2022]]},"DOI":"10.1007\/978-3-031-15743-1_45","type":"book-chapter","created":{"date-parts":[[2022,8,28]],"date-time":"2022-08-28T23:03:43Z","timestamp":1661727823000},"page":"487-499","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Stored and Inherited Relations with PKN Foreign Keys"],"prefix":"10.1007","author":[{"given":"Witold","family":"Litwin","sequence":"first","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2022,8,29]]},"reference":[{"key":"45_CR1","doi-asserted-by":"crossref","unstructured":"Litwin, W.: SQL for stored and inherited relations. In: 21st International Conference on Enterprise Information Systems, (ICEIS 2019) (2019). 12 p. http:\/\/www.iceis.org\/?y=2019","DOI":"10.5220\/0007676700370048"},{"key":"45_CR2","doi-asserted-by":"publisher","first-page":"624","DOI":"10.1016\/j.procs.2019.11.037","volume":"160","author":"W Litwin","year":"2019","unstructured":"Litwin, W.: Manifesto for improved foundations of relational model (EICN-2019). Proc. Comput. Sci. 160, 624\u2013628 (2019)","journal-title":"Proc. Comput. Sci."},{"key":"45_CR3","doi-asserted-by":"crossref","unstructured":"Litwin, W.:\u00a0Natural stored and inherited relations. In: (EUSPN-ICTH 2021), November 1-4, Procedia Computer Science, vol. 198. Elsevier, pp. 171\u2013178 (2022).","DOI":"10.1016\/j.procs.2021.12.225"},{"key":"45_CR4","unstructured":"Litwin, W.: Stored and Inherited Relations. arXiv preprint arXiv:1703.09574 (2017)"},{"key":"45_CR5","unstructured":"Litwin, W.: Supplier-Part Databases with Stored and Inherited Relations Simulated on MS Access. Lamsade Tech. E-Note (2016)"},{"key":"45_CR6","unstructured":"Codd, E.F.: Derivability, Redundancy and Consistency of Relations Stored in Large Data Banks. IBM Res. Rep. RJ 599 #12343 (1969)"},{"key":"45_CR7","doi-asserted-by":"publisher","first-page":"6","DOI":"10.1145\/362384.362685","volume":"13","author":"EF Codd","year":"1970","unstructured":"Codd, E.F.: A relational model of data for large shared data banks. CACM 13, 6 (1970)","journal-title":"CACM"},{"key":"45_CR8","unstructured":"Date, C.J.: An Introduction to Database Systems. Pearson Education Inc. (2004). ISBN 0-321-18956-6"},{"key":"45_CR9","unstructured":"Date, C.J., Darwen, H.: Watch out for outer join. In: Date and Darwen Relational Database Writings (1991)"},{"key":"45_CR10","unstructured":"Date, C.J.: View Updating and Relational Theory. O\u2019Reilly (2012)"},{"key":"45_CR11","unstructured":"Date, C.J.: Type Inheritance & Relational Theory. O\u2019Reilly (2016)"},{"key":"45_CR12","unstructured":"Date, C.J.: E.F. Codd and Relational Theory. Lulu (2019)"},{"key":"45_CR13","doi-asserted-by":"crossref","unstructured":"Goldstein, J., Larson, P.: Optimizing Queries Using Materialized Views: A Practical, Scalable Solution. ACM SIGMOD (2001)","DOI":"10.1145\/375663.375706"},{"key":"45_CR14","doi-asserted-by":"publisher","first-page":"270","DOI":"10.1007\/s007780100054","volume":"10","author":"AY Halevy","year":"2001","unstructured":"Halevy, A.Y.: Answering queries using views: a survey. VLDB J. 10, 270\u2013294 (2001)","journal-title":"VLDB J."},{"issue":"1","key":"45_CR15","doi-asserted-by":"publisher","first-page":"34","DOI":"10.1007\/BF01932129","volume":"30","author":"S Jajodia","year":"1990","unstructured":"Jajodia, S., Springsteel, F.N.: Lossless outer joins with incomplete information. BIT 30(1), 34\u201341 (1990)","journal-title":"BIT"},{"key":"45_CR16","doi-asserted-by":"crossref","unstructured":"Larson, P., Zhou J.: Efficient Maintenance of Materialized Outer-Join Views. ICDE (2007)","DOI":"10.1109\/ICDE.2007.367851"},{"key":"45_CR17","unstructured":"Litwin, W., Ketabchi, M., Risch, T.: Relations with Inherited Attributes. HPL. Palo Alto, CA. Tech. Rep. HPL-DTD-92-45, 30 (1992)"},{"issue":"2","key":"45_CR18","doi-asserted-by":"publisher","first-page":"283","DOI":"10.1145\/329.318580","volume":"9","author":"D Maier","year":"1984","unstructured":"Maier, D., Ullman, J.D., Vardi, M.Y.: On the foundations of the universal relation model. ACM-TODS 9(2), 283\u2013308 (1984)","journal-title":"ACM-TODS"},{"key":"45_CR19","unstructured":"Postgres SQL. https:\/\/www.postgresql.org\/"},{"key":"45_CR20","unstructured":"Stonebraker, M., Moore, D.: Object-Relational DBMSs: The Next Great Wave, 2nd edn. Morgan Kaufmann (1998)"},{"key":"45_CR21","unstructured":"Litwin, W.: Stored and Inherited Relations with Natural or Declared Foreign Keys. Lamsade Res. Rep. Report June 16, 2020. Latest update: 11 August 2022. 12p. https:\/\/www.lamsade.dauphine.fr\/~litwin\/Designing%20an%20RDB%20with%20SIRs.pdf"}],"container-title":["Communications in Computer and Information Science","New Trends in Database and Information Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-031-15743-1_45","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,3,7]],"date-time":"2024-03-07T12:44:09Z","timestamp":1709815449000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-031-15743-1_45"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022]]},"ISBN":["9783031157424","9783031157431"],"references-count":21,"URL":"https:\/\/doi.org\/10.1007\/978-3-031-15743-1_45","relation":{},"ISSN":["1865-0929","1865-0937"],"issn-type":[{"type":"print","value":"1865-0929"},{"type":"electronic","value":"1865-0937"}],"subject":[],"published":{"date-parts":[[2022]]},"assertion":[{"value":"29 August 2022","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"ADBIS","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"European Conference on Advances in Databases and Information Systems","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Turin","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Italy","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2022","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"5 September 2022","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"8 September 2022","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"26","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"adbis2022","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/adbis2022.polito.it\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Single-blind","order":1,"name":"type","label":"Type","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"EasyChair","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"90","order":3,"name":"number_of_submissions_sent_for_review","label":"Number of Submissions Sent for Review","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"23","order":4,"name":"number_of_full_papers_accepted","label":"Number of Full Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"28","order":5,"name":"number_of_short_papers_accepted","label":"Number of Short Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"26% - The value is computed by the equation \"Number of Full Papers Accepted \/ Number of Submissions Sent for Review * 100\" and then rounded to a whole number.","order":6,"name":"acceptance_rate_of_full_papers","label":"Acceptance Rate of Full Papers","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"3.12","order":7,"name":"average_number_of_reviews_per_paper","label":"Average Number of Reviews per Paper","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"3.4","order":8,"name":"average_number_of_papers_per_reviewer","label":"Average Number of Papers per Reviewer","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"Yes","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"28 short papers are included in the CCIS volume","order":10,"name":"additional_info_on_review_process","label":"Additional Info on Review Process","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}