{"entities":{"Q1124388":{"pageid":1135137,"ns":120,"title":"Item:Q1124388","lastrevid":69697446,"modified":"2026-04-13T08:47:20Z","type":"item","id":"Q1124388","labels":{"en":{"language":"en","value":"Null values in nested relational databases"}},"descriptions":{"en":{"language":"en","value":"scientific article; zbMATH DE number 4112082"}},"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":"Q1124388$1D66B86E-139F-4145-9F28-A557EA6F9C1C","rank":"normal"}],"P159":[{"mainsnak":{"snaktype":"value","property":"P159","hash":"e41e4f0f99097a9dbd010ab89a1feb767059a7de","datavalue":{"value":{"text":"Null values in nested relational databases","language":"en"},"type":"monolingualtext"},"datatype":"monolingualtext"},"type":"statement","id":"Q1124388$5AD1581F-9A4A-4E54-88EE-773776942F12","rank":"normal"}],"P225":[{"mainsnak":{"snaktype":"value","property":"P225","hash":"036206fc458e2dcd470200f484fc9ce22e4a7191","datavalue":{"value":"0678.68110","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1124388$7DDC6A5F-97BD-48A6-AC74-99805167CABB","rank":"normal"}],"P27":[{"mainsnak":{"snaktype":"value","property":"P27","hash":"3bd50cc1b74f7448b5a01394195c6bbc79e66700","datavalue":{"value":"10.1007/BF00288974","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1124388$EEB2CA1B-B564-4602-BBA6-9647F49F5975","rank":"normal"}],"P16":[{"mainsnak":{"snaktype":"value","property":"P16","hash":"9ef08a5943ab9b3ae2613f32e31695ac86149912","datavalue":{"value":{"entity-type":"item","numeric-id":1124387,"id":"Q1124387"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$59E69F5B-FFE4-4E89-B44F-0619DFC3575C","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P16","hash":"f5c0340e9f25b2889ebd44dfd177979607829c9e","datavalue":{"value":{"entity-type":"item","numeric-id":918691,"id":"Q918691"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$12B2AD8E-B7C2-4698-8324-0A3C1EE7D3F3","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P16","hash":"6f5ab188a50b654494a56f4562778300798f8d64","datavalue":{"value":{"entity-type":"item","numeric-id":919841,"id":"Q919841"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$6E7F8855-F6F4-47EF-975B-61725CFC42D5","rank":"normal"}],"P200":[{"mainsnak":{"snaktype":"value","property":"P200","hash":"7d0f02e85530cd06ceb2c58a40dc9c2e0258e194","datavalue":{"value":{"entity-type":"item","numeric-id":161641,"id":"Q161641"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$33E4E639-D6A9-475A-A004-A59A799B6407","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":"Q1124388$145B4FA9-FA05-429F-AE22-E4BB60BE7154","rank":"normal"}],"P1448":[{"mainsnak":{"snaktype":"value","property":"P1448","hash":"a0f05886672d7751aeaa2b7872396201d8cb8bd0","datavalue":{"value":"A definition of the nested relational model is presented based on the review of concepts studied by various researchers including the authors of this paper. Three types of null values in first NF and nested relations (no-information, unknown, nonexistent) are studied. Relationships ``more informative'', ``subsume'', ``information-wise equivalent'' are defined on tuples and relations with null values. Nested relational algebra operating on relations with null values in the partitioned normal form is introduced. Criteria used to establish the correctness of extended operators are defined. Proofs of some properties of extended operators are given. The effects of null values addition on functional dependencies in nested relations and on multivalued dependencies in first NF relations are studied. It is shown that the traditional axiomatization is valid in the presence of nulls. Further work is needed on select, project and join operators for nested relations.","type":"string"},"datatype":"string"},"type":"statement","id":"Q1124388$3A39F0E2-81C3-4870-9843-164EF73F0829","rank":"normal"}],"P226":[{"mainsnak":{"snaktype":"value","property":"P226","hash":"a762d1a2468ec8882180d0d1124f12b94f8eb1b0","datavalue":{"value":"68P20","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1124388$CBA8D7E5-C4EB-4C73-A239-767D80258754","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P226","hash":"14cf74de25853c940589b125137b792dfb2d092b","datavalue":{"value":"68P05","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1124388$2757F40F-EC6D-4E9A-A711-447CD14A2EBE","rank":"normal"}],"P1451":[{"mainsnak":{"snaktype":"value","property":"P1451","hash":"10b68a84018e42af3c1462a6457928f874cc12db","datavalue":{"value":"4112082","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1124388$420EA897-C4E6-4878-B438-3250C00A7D61","rank":"normal"}],"P1450":[{"mainsnak":{"snaktype":"value","property":"P1450","hash":"a2b9cd7a052cc48ac5d2199e10915b3c9a98308d","datavalue":{"value":"null values","type":"string"},"datatype":"string"},"type":"statement","id":"Q1124388$44643004-DCE4-4504-9300-CDEC052BC1BC","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"f46f0232eee4bb70d433e9dbc194d128e7ecffb1","datavalue":{"value":"nested relational databases","type":"string"},"datatype":"string"},"type":"statement","id":"Q1124388$51E02120-6895-42BE-9D8B-40AFDFAF4676","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":"Q1124388$BA8ECEF2-D1FD-4CD0-872B-6023B7B30D97","rank":"normal"}],"P223":[{"mainsnak":{"snaktype":"value","property":"P223","hash":"f0972ba882a214c0c3e2012cb3a83507ad4b4e44","datavalue":{"value":{"entity-type":"item","numeric-id":797002,"id":"Q797002"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$E49E7298-1958-403E-A7E7-3D2B9E27B375","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"c7c6781735c13ab5b80904660a67e47129b757f4","datavalue":{"value":{"entity-type":"item","numeric-id":3950001,"id":"Q3950001"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$D153D012-A457-4B7F-BFDD-C4B9E758815E","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"b577d08ccd514d106aef6448d3d43d248533905a","datavalue":{"value":{"entity-type":"item","numeric-id":1245581,"id":"Q1245581"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$B9D15472-EE29-40FC-A4EF-2EFD9CB7F83F","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"dbf320e73801e4587394d54864994a53a737e80e","datavalue":{"value":{"entity-type":"item","numeric-id":1062474,"id":"Q1062474"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$CA79D898-E577-4ACB-B1B4-C6543C1FDD7C","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"1adb9b8cb046f54bbbd361517a79c3c1b644ad05","datavalue":{"value":{"entity-type":"item","numeric-id":3731049,"id":"Q3731049"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$19329D85-DC3B-4590-8149-16CD2298B24F","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"3a44dde30560aa2abe97955563fa765bddd026c0","datavalue":{"value":{"entity-type":"item","numeric-id":3945621,"id":"Q3945621"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$2B093DE0-0708-4E2A-9A7A-883FF6741092","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"4f77a25b0798a066fa1d5f637d6e09c5f0b18b2a","datavalue":{"value":{"entity-type":"item","numeric-id":3916039,"id":"Q3916039"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$6CAB38FD-4C88-4D05-BD46-535FEE484F3D","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"143421a0cbe4ba34cedbed6f5fa70d101952a550","datavalue":{"value":{"entity-type":"item","numeric-id":3668890,"id":"Q3668890"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$830BE2DA-BA85-4921-A498-5ABF6C765C27","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"77edc9141bc55dde8ce7f070b30c91d4be947f05","datavalue":{"value":{"entity-type":"item","numeric-id":3770001,"id":"Q3770001"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$AD113C91-BC56-47BB-866F-6FE5F13CFC5D","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"80968684c63305a20ba2db314ea71acb0a7de57c","datavalue":{"value":{"entity-type":"item","numeric-id":3814847,"id":"Q3814847"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$7F45B529-55A7-441F-BF21-C45C4ADF03FA","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"4170545cd61965223cd46f758fb3fd6fb73b9e0a","datavalue":{"value":{"entity-type":"item","numeric-id":1074345,"id":"Q1074345"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$E847AD61-4270-43BA-A478-08908FC6D516","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"4919b9152737b38d46c5c39a144096287e15bdc8","datavalue":{"value":{"entity-type":"item","numeric-id":3786046,"id":"Q3786046"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$C5AA9B93-7F4E-476A-A946-BDE96447AE42","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"b0960832af23dc5ac843eed8171366406a9f0b86","datavalue":{"value":{"entity-type":"item","numeric-id":3947170,"id":"Q3947170"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$16F4CE25-DD01-447B-ACE4-1EDA96DA1391","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"a942d3cb3a64798a188cc04261315e41d0efdd1c","datavalue":{"value":{"entity-type":"item","numeric-id":1067417,"id":"Q1067417"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1124388$526793B3-FB15-40C4-8A19-F1CECB4A61E2","rank":"normal"}],"P1643":[{"mainsnak":{"snaktype":"value","property":"P1643","hash":"b819c3c566bfca9ad7b4e355cfac911b2afa53ec","datavalue":{"value":{"entity-type":"item","numeric-id":1067417,"id":"Q1067417"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"1c7a7eb71287ec2c3f60bbb453297aecb330ffad","datavalue":{"value":{"amount":"+0.8597568869590759","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":"Q1124388$E8BEC585-D2F8-439E-B9B7-A17E1BC4F12E","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"3615cefebae31f3c39463e0c3c49c6e9700d073b","datavalue":{"value":{"entity-type":"item","numeric-id":3779794,"id":"Q3779794"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"8fca09af421426a62a92d8c677cc62b5ba191f15","datavalue":{"value":{"amount":"+0.8455681800842285","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":"Q1124388$EACDAB8D-480F-4303-AD2E-EDEDF704894A","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"bcc9ec8e586c2cdfb371123e91e17d892bce03a6","datavalue":{"value":{"entity-type":"item","numeric-id":4271917,"id":"Q4271917"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"00aa50c37287e11ea65b17ad8bce54ebafbfdee3","datavalue":{"value":{"amount":"+0.8410316705703735","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":"Q1124388$B1B9F9BB-070F-4350-9565-04029C3EB1C1","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"4d087d2f61535e94df8564d9b3a9a4948a22b1d3","datavalue":{"value":{"entity-type":"item","numeric-id":1262790,"id":"Q1262790"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"8aa57d56321db7fe5f420215edc76cf431cebac9","datavalue":{"value":{"amount":"+0.8354505896568298","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":"Q1124388$39878862-51F8-45ED-A3EC-2D1B46636BC1","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"477376f421eb794392e90e44e44fe128ad8bece6","datavalue":{"value":{"entity-type":"item","numeric-id":1175713,"id":"Q1175713"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"5da121e96e2bda52c7d2ec9733fca00c3721bef8","datavalue":{"value":{"amount":"+0.8325967788696289","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":"Q1124388$5A9ED77A-21D5-4146-A6A1-5CA9B6760D53","rank":"normal"}]},"sitelinks":{"mardi":{"site":"mardi","title":"Null values in nested relational databases","badges":[],"url":"https://portal.mardi4nfdi.de/wiki/Null_values_in_nested_relational_databases"}}}}}