{"entities":{"Q750144":{"pageid":751993,"ns":120,"title":"Item:Q750144","lastrevid":64092963,"modified":"2026-04-11T17:35:16Z","type":"item","id":"Q750144","labels":{"en":{"language":"en","value":"A temporal relational model and a query language"}},"descriptions":{"en":{"language":"en","value":"scientific article; zbMATH DE number 4174322"}},"aliases":{},"claims":{"P31":[{"mainsnak":{"snaktype":"value","property":"P31","hash":"fd5912e4dab4b881a8eb0eb27e7893fef55176ad","datavalue":{"value":{"entity-type":"item","numeric-id":56887,"id":"Q56887"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q750144$9E8441A1-2381-4855-990B-19A287822A66","rank":"normal"}],"P159":[{"mainsnak":{"snaktype":"value","property":"P159","hash":"75a735229906d73b0990bbb1cea492d7240030d6","datavalue":{"value":{"text":"A temporal relational model and a query language","language":"en"},"type":"monolingualtext"},"datatype":"monolingualtext"},"type":"statement","id":"Q750144$73DA03A5-3D42-49CD-9AB4-00FEB00302E1","rank":"normal"}],"P225":[{"mainsnak":{"snaktype":"value","property":"P225","hash":"e4c35f29cf9d0b63bb3c50ed1a15c97a7dd04dfa","datavalue":{"value":"0713.68022","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q750144$24ED0573-F75D-43ED-947D-49347EA69A55","rank":"normal"}],"P27":[{"mainsnak":{"snaktype":"value","property":"P27","hash":"d2357e6bb0d2352e9ca63377e7bc5e74fc2a6fcd","datavalue":{"value":"10.1016/0020-0255(89)90026-1","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q750144$67FFB946-FA01-4E75-B538-9D82CB239F67","rank":"normal"}],"P16":[{"mainsnak":{"snaktype":"value","property":"P16","hash":"14f0f80e5fa9517c00fab01a0925f2ace7cb1fca","datavalue":{"value":{"entity-type":"item","numeric-id":750143,"id":"Q750143"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q750144$5F0BD7E1-64AA-472C-9D5B-BECDFB0512EE","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P16","hash":"b9cae987104f4880dde94f32d5f423e0698c228d","datavalue":{"value":{"entity-type":"item","numeric-id":205024,"id":"Q205024"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q750144$9604F5D1-797B-47AA-849F-73D61962F65F","rank":"normal"}],"P200":[{"mainsnak":{"snaktype":"value","property":"P200","hash":"c144f0fb88440afe4b13555aedcc8676a016b6d2","datavalue":{"value":{"entity-type":"item","numeric-id":70466,"id":"Q70466"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q750144$27FCA55B-0170-4887-A57B-2AAEFC4E7A24","rank":"normal"}],"P28":[{"mainsnak":{"snaktype":"value","property":"P28","hash":"7211ad5ca16eb0d22cd0051fff3d0f3af254ceb6","datavalue":{"value":{"time":"+1989-00-00T00:00:00Z","timezone":0,"before":0,"after":0,"precision":9,"calendarmodel":"http://www.wikidata.org/entity/Q1985727"},"type":"time"},"datatype":"time"},"type":"statement","id":"Q750144$D9CD7BA9-60CA-420E-B7F4-D0A8725659E3","rank":"normal"}],"P1448":[{"mainsnak":{"snaktype":"value","property":"P1448","hash":"b3f01bb736b065d5f8ce6144ac1c725849189af2","datavalue":{"value":"In Section 1 the authors give a list of current approaches to time modelling in databases and their critical evaluation.    Section 2 describes a new temporal data model (TRM) that attempts to overcome problems of previous models. The TRM supports a variation of attribute time-stamping within the framework of classical relational theory. With notions of synchronous and asynchronous time-varying attributes the notion of temporal dependency is defined. As these dependencies can induce update and retrieval anomalies, the authors introduce a time normal form of a relation. The notion extends the well- known BCNF.    In Section 3 a new temporal query language TSQL is formulated. The TSQL extends the relational language SQL by some time aspects such as the WHEN clause, retrieval of timestamp values and temporally ordered information, specification of time domain using the TIME-SLICE clause, etc.    The suggested framework gives a coherent and consistent framework for management of time-varying as well as non-time-varying information. It also offers a number of open problems for investigation.","type":"string"},"datatype":"string"},"type":"statement","id":"Q750144$3AEAADB0-5801-42D1-8BA3-7009FEC5E52A","rank":"normal"}],"P226":[{"mainsnak":{"snaktype":"value","property":"P226","hash":"bf2726c5c2109371cc10358eaa69bc4df711caf7","datavalue":{"value":"68P15","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q750144$588F868D-86D7-4CF7-96BC-02F613A3204D","rank":"normal"}],"P1451":[{"mainsnak":{"snaktype":"value","property":"P1451","hash":"96e33bb52757a062480f8b83e2b799142bda8ba2","datavalue":{"value":"4174322","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q750144$00F27C19-7C53-4FE1-A09F-6C8741853571","rank":"normal"}],"P1450":[{"mainsnak":{"snaktype":"value","property":"P1450","hash":"ced2f39064bb481535ca6466cc746ac3c110701a","datavalue":{"value":"temporal dependency","type":"string"},"datatype":"string"},"type":"statement","id":"Q750144$B7D2C336-DEA1-45BF-BAE1-03FC6153489E","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"94af5a75c61fff93b226845e8c23d7765cf92b9a","datavalue":{"value":"time normal form","type":"string"},"datatype":"string"},"type":"statement","id":"Q750144$BB4BE709-06E9-4648-BD21-C8F862025997","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"b7e99bd48e7bd8be68eabd17896f05a3a74ed6d8","datavalue":{"value":"temporal query language","type":"string"},"datatype":"string"},"type":"statement","id":"Q750144$8D1453B3-5310-4765-A4A0-9BF2BEDB270E","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"5ae57e18a3538dee74fda15f4e46fdfdee7b2810","datavalue":{"value":"relational language SQL","type":"string"},"datatype":"string"},"type":"statement","id":"Q750144$AA2870BB-1280-4F81-A88E-803AF991165A","rank":"normal"}],"P1447":[{"mainsnak":{"snaktype":"value","property":"P1447","hash":"41927d0273d17be217af24d3bf572ac62623d210","datavalue":{"value":{"entity-type":"item","numeric-id":590760,"id":"Q590760"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q750144$6BF0C0CA-1FB3-4DBD-9DC6-9AA4EE653DC9","rank":"normal"}],"P1460":[{"mainsnak":{"snaktype":"value","property":"P1460","hash":"57f7fea50d2ce1b39b695c4a1313582eed405e38","datavalue":{"value":{"entity-type":"item","numeric-id":5976449,"id":"Q5976449"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q750144$E0196561-B8B7-42C8-BD84-478234654835","rank":"normal"}],"P205":[{"mainsnak":{"snaktype":"value","property":"P205","hash":"f98a18f2154af8368b3c9654f3d55014878d77fd","datavalue":{"value":"https://doi.org/10.1016/0020-0255(89)90026-1","type":"string"},"datatype":"url"},"type":"statement","id":"Q750144$7D934731-E5BE-4729-B621-D1B4A72A5098","rank":"normal"}],"P388":[{"mainsnak":{"snaktype":"value","property":"P388","hash":"d236fab772f9736afcb6439355149e77ece6871c","datavalue":{"value":"W2081102106","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q750144$0C557062-B181-47A2-A0E9-3551572BF896","rank":"normal"}],"P223":[{"mainsnak":{"snaktype":"value","property":"P223","hash":"6b00c51201f67e59e740260c694a944ba5779880","datavalue":{"value":{"entity-type":"item","numeric-id":5607609,"id":"Q5607609"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q750144$C3C74DAB-566C-4E6E-9F7C-FE519CA5E417","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"a3eb039d256abc4d7d9b383e6ed71f969c1c4518","datavalue":{"value":{"entity-type":"item","numeric-id":4050126,"id":"Q4050126"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q750144$760616C4-8DF1-49BB-85FE-CB837D879AA6","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"491997c65356f3eb4b6dbf9d8240f8670ca2e479","datavalue":{"value":{"entity-type":"item","numeric-id":750144,"id":"Q750144"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q750144$7207C46C-2CB8-4602-98DE-9F1D22514725","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"bdf7cd31426a223f04b1fa86ff37921b5f4b4035","datavalue":{"value":{"entity-type":"item","numeric-id":3821645,"id":"Q3821645"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q750144$178F28DD-E89D-4A43-A909-9A9C910A0D6F","rank":"normal"}],"P1643":[{"mainsnak":{"snaktype":"value","property":"P1643","hash":"634777ee013cd8d71ea1bdde44d686c1e1d6e80e","datavalue":{"value":{"entity-type":"item","numeric-id":3821645,"id":"Q3821645"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"2dba1a8e00d3cdf05680841c13ab2034fc6b2dac","datavalue":{"value":{"amount":"+0.8605181574821472","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"a327a09ea0305e98d5cf33bd4036320e19f2aed0","datavalue":{"value":{"entity-type":"item","numeric-id":6821328,"id":"Q6821328"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q750144$6FFB9EC7-51AC-445E-A71D-DABC6475E1AF","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"52594e53b70e0dcbcbd9a4a877f72b76c1b1e2ba","datavalue":{"value":{"entity-type":"item","numeric-id":4508950,"id":"Q4508950"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"5fc7862ea6cb1adcc03a5e205ff69c8271ed1666","datavalue":{"value":{"amount":"+0.8452601432800293","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"a327a09ea0305e98d5cf33bd4036320e19f2aed0","datavalue":{"value":{"entity-type":"item","numeric-id":6821328,"id":"Q6821328"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q750144$799ECA15-97AD-4A3C-876C-65463BF29BE0","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"54c55fd97e5d244a158e9be97ae453673f309610","datavalue":{"value":{"entity-type":"item","numeric-id":4518429,"id":"Q4518429"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"e30c9d7535adfdd708d4fac828878ec9572b1cd9","datavalue":{"value":{"amount":"+0.8452600240707397","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"a327a09ea0305e98d5cf33bd4036320e19f2aed0","datavalue":{"value":{"entity-type":"item","numeric-id":6821328,"id":"Q6821328"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q750144$01519D16-7902-45DF-81BE-0CCCF22D3B18","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"e5ab9d66e3c74af1abd85ef588abf11e770fa583","datavalue":{"value":{"entity-type":"item","numeric-id":1094156,"id":"Q1094156"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"3cdf30ca210f75b2adadff9192aad6b997f762f9","datavalue":{"value":{"amount":"+0.8218572735786438","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"a327a09ea0305e98d5cf33bd4036320e19f2aed0","datavalue":{"value":{"entity-type":"item","numeric-id":6821328,"id":"Q6821328"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q750144$E1D8C5D5-42A1-4606-AEED-5A4C7B1DE6EF","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"14359aa692740cdb9515b619545a3c8225f9f8c8","datavalue":{"value":{"entity-type":"item","numeric-id":4518442,"id":"Q4518442"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"3b16af385127de6df0fda03458926d9ed8832b8b","datavalue":{"value":{"amount":"+0.8216879963874817","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"a327a09ea0305e98d5cf33bd4036320e19f2aed0","datavalue":{"value":{"entity-type":"item","numeric-id":6821328,"id":"Q6821328"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q750144$3B98EF3E-73C7-4098-98AA-E15DAB61EC37","rank":"normal"}]},"sitelinks":{"mardi":{"site":"mardi","title":"A temporal relational model and a query language","badges":[],"url":"https://portal.mardi4nfdi.de/wiki/A_temporal_relational_model_and_a_query_language"}}}}}