{"entities":{"Q1885992":{"pageid":1896734,"ns":120,"title":"Item:Q1885992","lastrevid":71671866,"modified":"2026-04-13T23:47:14Z","type":"item","id":"Q1885992","labels":{"en":{"language":"en","value":"Arranging fact table records in a data warehouse to improve query performance"}},"descriptions":{"en":{"language":"en","value":"scientific article; zbMATH DE number 2115381"}},"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":"Q1885992$450C5FC6-1F12-4244-A684-F3C2CFDB9F29","rank":"normal"}],"P159":[{"mainsnak":{"snaktype":"value","property":"P159","hash":"5e7cf029ac14f9bd2f3d02b8fdaf133f0c7febcb","datavalue":{"value":{"text":"Arranging fact table records in a data warehouse to improve query performance","language":"en"},"type":"monolingualtext"},"datatype":"monolingualtext"},"type":"statement","id":"Q1885992$71F5E2B4-D718-45CB-9198-728C4F9ABCC3","rank":"normal"}],"P225":[{"mainsnak":{"snaktype":"value","property":"P225","hash":"13ba907ed1837e4cd855ddd59d57c9d29b879a10","datavalue":{"value":"1068.68054","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1885992$B2819E35-DF6C-4D47-8231-7F8E61CACD46","rank":"normal"}],"P27":[{"mainsnak":{"snaktype":"value","property":"P27","hash":"c1da64e05a4cef12bd893e315e73c7943b1688cc","datavalue":{"value":"10.1016/S0305-0548(03)00170-9","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1885992$915D9698-EC91-43F1-8DA7-EFEF1176B734","rank":"normal"}],"P16":[{"mainsnak":{"snaktype":"value","property":"P16","hash":"00c2fa12b9d717dc93e912aefddbcc5b45c43727","datavalue":{"value":{"entity-type":"item","numeric-id":1291698,"id":"Q1291698"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1885992$BEC7E8DC-BCC4-471A-9C81-96F75A3A8EB8","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P16","hash":"d26507371842a18173a2d9b40f4644465d43792d","datavalue":{"value":{"entity-type":"item","numeric-id":793591,"id":"Q793591"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1885992$454A8C7B-7DCC-4458-A0DE-6F9F8435609A","rank":"normal"}],"P200":[{"mainsnak":{"snaktype":"value","property":"P200","hash":"e630590c5ca6e787c3c7b5e291898405495fea2b","datavalue":{"value":{"entity-type":"item","numeric-id":162215,"id":"Q162215"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1885992$43F1F28D-ADC1-4CB4-8749-F79097772C12","rank":"normal"}],"P28":[{"mainsnak":{"snaktype":"value","property":"P28","hash":"34155b6cc89baaa4c39d220f89dc2297bed564ec","datavalue":{"value":{"time":"+2004-11-12T00:00:00Z","timezone":0,"before":0,"after":0,"precision":11,"calendarmodel":"http://www.wikidata.org/entity/Q1985727"},"type":"time"},"datatype":"time"},"type":"statement","id":"Q1885992$E5D78D22-62C7-49AF-8477-9A4E15CB5D87","rank":"normal"}],"P226":[{"mainsnak":{"snaktype":"value","property":"P226","hash":"bf2726c5c2109371cc10358eaa69bc4df711caf7","datavalue":{"value":"68P15","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1885992$9D5269CF-8DE1-42EE-BFAB-DC521CB89161","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P226","hash":"4399edb936883c90e4875bd660b6cebbb734bcea","datavalue":{"value":"90B99","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1885992$B3839B13-8F9A-4378-AD49-30017A5148EE","rank":"normal"}],"P1451":[{"mainsnak":{"snaktype":"value","property":"P1451","hash":"0c7ca4378bb445b67b6afcdc9a44b8b396b43198","datavalue":{"value":"2115381","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1885992$056CEC37-1CED-4F05-87E5-DF28B18523C5","rank":"normal"}],"P1450":[{"mainsnak":{"snaktype":"value","property":"P1450","hash":"ea61bff35aee831e9e6dc595a73dc5e43034dae2","datavalue":{"value":"Data warehouse","type":"string"},"datatype":"string"},"type":"statement","id":"Q1885992$DA90F3C8-8708-4E15-A20B-38279095A017","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"2c1d18634845c1d56bed6453f9a43b4e123f483f","datavalue":{"value":"Computer disk","type":"string"},"datatype":"string"},"type":"statement","id":"Q1885992$E487D8EB-6597-4F05-A1CB-AB914C219689","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"3b9397048ba06db3fabb805e25d6e356418e1309","datavalue":{"value":"Cost model","type":"string"},"datatype":"string"},"type":"statement","id":"Q1885992$C98FB004-8AD0-4512-B11C-F8AF7B88EE6A","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"58c5035cdd1e2aedef7ae96e7bbc6faf3622049b","datavalue":{"value":"Optimization","type":"string"},"datatype":"string"},"type":"statement","id":"Q1885992$09992530-08B9-4BB1-BF77-9C8508F2111A","rank":"normal"}],"P1463":[{"mainsnak":{"snaktype":"value","property":"P1463","hash":"21403b0e58561e65fe7b82759d26857a8ae8413b","datavalue":{"value":{"entity-type":"item","numeric-id":27719,"id":"Q27719"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1885992$41B78E65-F595-4310-911D-4D7B91A1EFB7","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":"Q1885992$9479B494-397F-46C7-A3AC-FBB1A69DF879","rank":"normal"}],"P223":[{"mainsnak":{"snaktype":"value","property":"P223","hash":"a4b582a3229f4a1a7f1d401a28e1a1556f36307d","datavalue":{"value":{"entity-type":"item","numeric-id":4855513,"id":"Q4855513"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1885992$F92276E0-05ED-4122-A219-59C414FAA96E","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"7fed0d1bd50705f1bbdcfcc401603396d52a3de6","datavalue":{"value":{"entity-type":"item","numeric-id":1291699,"id":"Q1291699"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1885992$949D46C1-A086-4584-B8A4-BCA24F0C9774","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"49ece79d0b3d5f5bdf98ba9b158a6c7f2676d1e2","datavalue":{"value":{"entity-type":"item","numeric-id":4023826,"id":"Q4023826"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1885992$BA477E1E-BDDD-4F3A-99F7-E46AF623DD7C","rank":"normal"}],"P205":[{"mainsnak":{"snaktype":"value","property":"P205","hash":"1d217b92e00b88c819a165a9c8252b4da13fa4d8","datavalue":{"value":"https://doi.org/10.1016/s0305-0548(03)00170-9","type":"string"},"datatype":"url"},"type":"statement","id":"Q1885992$D33DECA8-9F8B-41C3-941C-9EAF0030CD27","rank":"normal"}],"P388":[{"mainsnak":{"snaktype":"value","property":"P388","hash":"1c0591ec758b3b54dc3e4d9a8a4fb64642e662ce","datavalue":{"value":"W1964042753","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1885992$7A46429B-EC5B-4EAE-BBEA-D7D2B2F45863","rank":"normal"}],"P1643":[{"mainsnak":{"snaktype":"value","property":"P1643","hash":"4ba3bc1613cd0b6a86cefae4c3586736a24892e1","datavalue":{"value":{"entity-type":"item","numeric-id":4432753,"id":"Q4432753"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"3c0affec4ca609a61b2cdd6a65cf0adddc0c4c54","datavalue":{"value":{"amount":"+0.7407957911491394","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":"Q1885992$E32BA054-29F2-45C8-80E7-D8A84C040277","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"c6733f3f596552e418e98c1c60aefdcb1aeb76ae","datavalue":{"value":{"entity-type":"item","numeric-id":3536865,"id":"Q3536865"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"3c0affec4ca609a61b2cdd6a65cf0adddc0c4c54","datavalue":{"value":{"amount":"+0.7407957911491394","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":"Q1885992$29A4A7BC-00A8-4237-A44F-BE7827AA9EC5","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"c4129dab8ff7b51e552bcfbcd55cb4771326924d","datavalue":{"value":{"entity-type":"item","numeric-id":4813051,"id":"Q4813051"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"a7f727eb0897035846514568b1cef6ab217fc919","datavalue":{"value":{"amount":"+0.7279306054115295","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":"Q1885992$9B191685-0F96-4D05-B98F-29E14718112B","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"e2f85111e9ec1d5dc7babd9a6e9110bbb3544fd8","datavalue":{"value":{"entity-type":"item","numeric-id":4410560,"id":"Q4410560"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"f639d8c31ca60dcb348ad4fcb4419ac0eb3d6bcb","datavalue":{"value":{"amount":"+0.7256569862365723","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":"Q1885992$8CAE3E19-C3CA-4341-82FD-0D18F313E85B","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"2bb16e5619d76be779ebc19abcc5058cfb1886e1","datavalue":{"value":{"entity-type":"item","numeric-id":4552075,"id":"Q4552075"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"85281a5887e06d72236ef9e9b6b89ab22bdd3208","datavalue":{"value":{"amount":"+0.7142022848129272","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":"Q1885992$4AB1DEDB-A60B-4A35-BDD1-BCD5AD26DEE4","rank":"normal"}]},"sitelinks":{"mardi":{"site":"mardi","title":"Arranging fact table records in a data warehouse to improve query performance","badges":[]}}}}}