{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,2,21]],"date-time":"2025-02-21T00:53:00Z","timestamp":1740099180288,"version":"3.37.3"},"publisher-location":"Cham","reference-count":18,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783030008468"},{"type":"electronic","value":"9783030008475"}],"license":[{"start":{"date-parts":[[2018,1,1]],"date-time":"2018-01-01T00:00:00Z","timestamp":1514764800000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2018]]},"DOI":"10.1007\/978-3-030-00847-5_27","type":"book-chapter","created":{"date-parts":[[2018,9,25]],"date-time":"2018-09-25T08:11:26Z","timestamp":1537863086000},"page":"382-396","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":5,"title":["A Semantic Framework for Designing Temporal SQL Databases"],"prefix":"10.1007","author":[{"given":"Qiao","family":"Gao","sequence":"first","affiliation":[]},{"given":"Mong Li","family":"Lee","sequence":"additional","affiliation":[]},{"given":"Gillian","family":"Dobbie","sequence":"additional","affiliation":[]},{"given":"Zhong","family":"Zeng","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2018,9,26]]},"reference":[{"key":"27_CR1","unstructured":"Elmasri, R., El-Assal, I., Kouramajian, V.: Semantics of temporal data in an extended ER model. In: ER (1990)"},{"key":"27_CR2","unstructured":"Elmasri, R., Wuu, G.T.J.: A temporal model and query language for ER databases. In: IEEE ICDE (1990)"},{"key":"27_CR3","unstructured":"Ferg, S.: Modelling the time dimension in an entity-relationship diagram. In: ER (1985)"},{"key":"27_CR4","doi-asserted-by":"crossref","unstructured":"Gao, Q., Lee, M.L., Ling, T.W., Dobbie, G., Zeng, Z.: A semantic framework for designing temporal SQL databases. Technical report, TRB3\/18, NUS (2018)","DOI":"10.1007\/978-3-030-00847-5_27"},{"key":"27_CR5","unstructured":"Gregersen, H., Jensen, C.: Conceptual modeling of time-varying information. Technical report, TimeCenter TR-35 (1998)"},{"key":"27_CR6","first-page":"464","volume":"11","author":"H Gregersen","year":"1999","unstructured":"Gregersen, H., Jensen, C.S.: Temporal entity-relationship models - a survey. IEEE TKDE 11, 464\u2013497 (1999)","journal-title":"IEEE TKDE"},{"key":"27_CR7","unstructured":"Gregersen, H., Mark, L., Jensen, C.S.: Mapping temporal ER diagrams to relational schemas. Technical report, TimeCenter TR-39 (1998)"},{"key":"27_CR8","first-page":"528","volume":"26","author":"V Khatri","year":"2014","unstructured":"Khatri, V., Ram, S., Snodgrass, R.T., et al.: Capturing telic\/atelic temporal data semantics: Generalizing conventional conceptual models. IEEE TKDE 26, 528\u2013548 (2014)","journal-title":"IEEE TKDE"},{"key":"27_CR9","unstructured":"Klopprogge, M.R.: TERM: an approach to include time dimension in the entity-relationship model. In: ER (1981)"},{"key":"27_CR10","doi-asserted-by":"publisher","first-page":"34","DOI":"10.1145\/2380776.2380786","volume":"41","author":"K Kulkarni","year":"2012","unstructured":"Kulkarni, K., Michels, J.E.: Temporal features in SQL: 2011. Sigmod Rec. 41, 34\u201343 (2012)","journal-title":"Sigmod Rec."},{"key":"27_CR11","doi-asserted-by":"publisher","first-page":"6","DOI":"10.1145\/190675.190676","volume":"25","author":"VS Lai","year":"1994","unstructured":"Lai, V.S., Kuilboer, J.P., Guynes, J.L.: Temporal databases: model design and commercialization prospects. ACM SIGMIS Database 25, 6\u201318 (1994)","journal-title":"ACM SIGMIS Database"},{"key":"27_CR12","unstructured":"Ling, T.W.: A normal form for entity-relationship diagrams. In: ER (1985)"},{"key":"27_CR13","doi-asserted-by":"publisher","first-page":"309","DOI":"10.1007\/BF01976278","volume":"4","author":"TW Ling","year":"1994","unstructured":"Ling, T.W., Yan, L.: NF-NR: a practical normal form for nested relations. J. Syst. Integr. 4, 309\u2013340 (1994)","journal-title":"J. Syst. Integr."},{"key":"27_CR14","doi-asserted-by":"crossref","DOI":"10.7551\/mitpress\/1131.001.0001","volume-title":"Advances in Object-Oriented Data Modeling","author":"M Papazoglou","year":"2000","unstructured":"Papazoglou, M., Spaccapietra, S., Tari, Z.: Advances in Object-Oriented Data Modeling. MIT Press, Cambridge (2000). Chap. 7"},{"key":"27_CR15","volume-title":"Developing Time-Oriented Database Applications in SQL","author":"RT Snodgrass","year":"2000","unstructured":"Snodgrass, R.T.: Developing Time-Oriented Database Applications in SQL. Morgan Kaufmann Publishers, San Francisco (2000). Chap. 11"},{"key":"27_CR16","unstructured":"Tauzovich, B.: Towards temporal extensions to the entity-relationship model. In: ER (1991)"},{"key":"27_CR17","doi-asserted-by":"publisher","first-page":"401","DOI":"10.1016\/0306-4379(91)90031-4","volume":"16","author":"C Theodoulidis","year":"1991","unstructured":"Theodoulidis, C., Loucopoulos, P., Wangler, B.: A conceptual modelling formalism for temporal database applications. Inf. Syst. 16, 401\u2013416 (1991)","journal-title":"Inf. Syst."},{"key":"27_CR18","unstructured":"Zimanyi, E., Parent, C., Spaccapietra, S., Pirotte, A.: TERC+: a temporal conceptual model. In: International Symposium Digital Media Information Base (1997)"}],"container-title":["Lecture Notes in Computer Science","Conceptual Modeling"],"original-title":[],"link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-030-00847-5_27","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,10,24]],"date-time":"2019-10-24T16:38:57Z","timestamp":1571935137000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-030-00847-5_27"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2018]]},"ISBN":["9783030008468","9783030008475"],"references-count":18,"URL":"https:\/\/doi.org\/10.1007\/978-3-030-00847-5_27","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2018]]},"assertion":[{"value":"ER","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Conceptual Modeling","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Xi'an","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"China","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2018","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"22 October 2018","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"25 October 2018","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"37","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"er2018","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/www.nwpu-bioinformatics.com\/ER2018\/index.php#content","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}