{"entities":{"Q1094156":{"pageid":1104908,"ns":120,"title":"Item:Q1094156","lastrevid":49110409,"modified":"2026-01-06T14:56:35Z","type":"item","id":"Q1094156","labels":{"en":{"language":"en","value":"Adding time dimension to relational model and extending relational algebra"}},"descriptions":{"en":{"language":"en","value":"scientific article; zbMATH DE number 4024834"}},"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":"Q1094156$B2B71818-51AD-4CE2-8E95-F271B35BF4CB","rank":"normal"}],"P159":[{"mainsnak":{"snaktype":"value","property":"P159","hash":"92a5188654d67b2eb910cc074114e25cdfac0879","datavalue":{"value":{"text":"Adding time dimension to relational model and extending relational algebra","language":"en"},"type":"monolingualtext"},"datatype":"monolingualtext"},"type":"statement","id":"Q1094156$04AB9EA5-FE02-40F8-A558-28349EC9D418","rank":"normal"}],"P225":[{"mainsnak":{"snaktype":"value","property":"P225","hash":"8b40f08362eb82cdaea05252c2c74f40aae83a0c","datavalue":{"value":"0629.68094","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1094156$16D65595-71E4-4E07-AFC5-A0C1E4CD4E59","rank":"normal"}],"P27":[{"mainsnak":{"snaktype":"value","property":"P27","hash":"89ed3a2b0d92470806184e6392d0ac6e946da44b","datavalue":{"value":"10.1016/0306-4379(86)90014-1","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1094156$8A92B8FD-5AFC-4966-84F5-49427ACCA0BE","rank":"normal"}],"P16":[{"mainsnak":{"snaktype":"value","property":"P16","hash":"798f9de20a57e19a39500678ea701f1c17ab2f76","datavalue":{"value":{"entity-type":"item","numeric-id":1094155,"id":"Q1094155"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1094156$ACBB4FCB-D59F-4FF6-B7DC-9CA47F27AE12","rank":"normal"}],"P200":[{"mainsnak":{"snaktype":"value","property":"P200","hash":"62e0251915bd7b9ecd6daf39f97f5bb27a9c612e","datavalue":{"value":{"entity-type":"item","numeric-id":82364,"id":"Q82364"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1094156$2DCE4F47-F8E5-4DA1-9674-34E962420C1B","rank":"normal"}],"P28":[{"mainsnak":{"snaktype":"value","property":"P28","hash":"63df7153432d81fa42019fcabb076c89649b0b5b","datavalue":{"value":{"time":"+1986-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":"Q1094156$C9B7383C-E569-4238-9182-118B32ADAC2C","rank":"normal"}],"P1448":[{"mainsnak":{"snaktype":"value","property":"P1448","hash":"9305ebfc29f6470b7a4ef4020d6c7abb65326139","datavalue":{"value":"A new method of incorporating time information into database relations is proposed. While earlier approaches attached time-instant or -interval annotations to tuples, this method (optionally) attaches begin and end times to individual attribute values. The model also allows attribute values that are sets of basic values or time-annotated basic values. The advantage over other approaches is that time-series data on an entity can be collected into a single tuple, rather than spread over multiple tuples, where key and interval ordering considerations complicate extracting time-series data on a single entity. The presence of set- valued attributes means relations in the model are not in first normal form. However, the model here is not as general as other non-first normal models, since nested sets are prohibited. Possibly a simpler system and exposition would have resulted if set constructs were independent of time-attachment, and nesting of sets were allowed.    The bulk of the paper is definitions of operations in a relational algebra over time-annotated relations. There are analogs of standard algebraic operators (select, project, join, Cartesian product, union, intersection, difference) that deal with time intervals and set-valued attributes. Nest and unnest operations convert between a set-valued attribute and a collection of tuples with simple attribute values. Other operations convert time annotations to independent attributes and vice- versa. The algebra also contains aggregation operations, and operations to split and combine time intervals. The paper concludes with identities on expressions over the algebra.","type":"string"},"datatype":"string"},"type":"statement","id":"Q1094156$0E81C480-7A22-432F-A088-E2C31401CD6F","rank":"normal"}],"P226":[{"mainsnak":{"snaktype":"value","property":"P226","hash":"a762d1a2468ec8882180d0d1124f12b94f8eb1b0","datavalue":{"value":"68P20","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1094156$EE719684-483E-411F-9918-302A3DE683C3","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P226","hash":"14cf74de25853c940589b125137b792dfb2d092b","datavalue":{"value":"68P05","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1094156$91425B12-2E97-48DF-9128-C423782E8C98","rank":"normal"}],"P1451":[{"mainsnak":{"snaktype":"value","property":"P1451","hash":"fe3d149ec8cefeecb70eb43f84b0789d9230419f","datavalue":{"value":"4024834","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1094156$6B4F9D5C-DABA-4AED-B768-B43F0715691F","rank":"normal"}],"P1450":[{"mainsnak":{"snaktype":"value","property":"P1450","hash":"f6368aedce8b68b5d4de68a3c0dc29041f076d55","datavalue":{"value":"relational database theory","type":"string"},"datatype":"string"},"type":"statement","id":"Q1094156$83750039-396F-4520-A2A4-B7FA4FEA8799","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"acbbfb80fc6c00a476248f7c1ea671151e423935","datavalue":{"value":"historical database","type":"string"},"datatype":"string"},"type":"statement","id":"Q1094156$6F10714C-BAF9-4EE5-BFEE-2CAE7676EA1D","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"aa99b99a43a116d6427665749051c0891969bf26","datavalue":{"value":"non-first normal form","type":"string"},"datatype":"string"},"type":"statement","id":"Q1094156$ED44BB8A-0F47-4130-8065-E3CA2ED785F8","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"3f93e6903294c5a763f32fc08b1a17fcbb4af671","datavalue":{"value":"time information","type":"string"},"datatype":"string"},"type":"statement","id":"Q1094156$97091571-08E2-4687-8495-1DABA2CA3BE1","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"f37a034e647f80843b21640ec1d9b6824b15e6b5","datavalue":{"value":"relational algebra","type":"string"},"datatype":"string"},"type":"statement","id":"Q1094156$AA5A6423-5341-4C2C-8369-F616EE7933C7","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":"Q1094156$EB665077-B081-48D1-B651-D60735C24E1F","rank":"normal"}],"P205":[{"mainsnak":{"snaktype":"value","property":"P205","hash":"0aec4ddbb5ac0255dcab4002c88b474a9c7f942e","datavalue":{"value":"https://doi.org/10.1016/0306-4379(86)90014-1","type":"string"},"datatype":"url"},"type":"statement","id":"Q1094156$B8DD2E36-86BE-40D2-B14A-53D200B2EDAE","rank":"normal"}],"P388":[{"mainsnak":{"snaktype":"value","property":"P388","hash":"3e7b3038d3b3f09ef78af4b1e70d4bb5b2b59f3a","datavalue":{"value":"W1977662461","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1094156$B03701E3-46B1-4C86-A1ED-4AFF17E2E702","rank":"normal"}],"P1643":[{"mainsnak":{"snaktype":"value","property":"P1643","hash":"be20f8346a56d8d24c3f7ce68f4cae212ea6a757","datavalue":{"value":{"entity-type":"item","numeric-id":4717042,"id":"Q4717042"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"d53b9bdc11b2c26ee2737f5b03ce807e8772954c","datavalue":{"value":{"amount":"+0.8273530006408691","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":"Q1094156$A6AC73B9-D98E-4FCA-A314-87268D50DD63","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"160c78ee094b5d882929b12b81daa921dab9dcc0","datavalue":{"value":{"entity-type":"item","numeric-id":750144,"id":"Q750144"},"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":"Q1094156$13162A33-09D5-4B3A-A680-1CA4B2ABCD7F","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"f27c6b5655cebb135a5f2975e8e2a63ed90287e2","datavalue":{"value":{"entity-type":"item","numeric-id":1114451,"id":"Q1114451"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"3c6a9006ba55e5fc9d203dd5b77cadedee921958","datavalue":{"value":{"amount":"+0.8172855377197266","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":"Q1094156$D923606E-79E1-46DC-8F2B-D11E7B452CA6","rank":"normal"},{"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":"695d683a252db66df8ca6351ac21d5949df79ce9","datavalue":{"value":{"amount":"+0.8047177791595459","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":"Q1094156$64822191-51BD-42BC-B3FC-A80E9C45C775","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"5f541b4ef1c8aaee3da3663fec799a0420d0772f","datavalue":{"value":{"entity-type":"item","numeric-id":3122515,"id":"Q3122515"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"0709f356acd2b7e4842cae0f286346c3ff439127","datavalue":{"value":{"amount":"+0.7847187519073486","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":"Q1094156$E27ACBB3-A30D-41E1-B01B-89DA5DA1D953","rank":"normal"}]},"sitelinks":{"mardi":{"site":"mardi","title":"Publication:1094156","badges":[],"url":"https://portal.mardi4nfdi.de/wiki/Publication:1094156"}}}}}