{"entities":{"Q797313":{"pageid":799161,"ns":120,"title":"Item:Q797313","lastrevid":42700603,"modified":"2025-07-08T15:05:56Z","type":"item","id":"Q797313","labels":{"en":{"language":"en","value":"Querying fragmented relations in a distributed database"}},"descriptions":{"en":{"language":"en","value":"scientific article; zbMATH DE number 3868670"}},"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":"Q797313$EEB5ADAE-B778-414D-9F53-3459AE5D200C","rank":"normal"}],"P159":[{"mainsnak":{"snaktype":"value","property":"P159","hash":"aa190af9300e815d455098add3ab39bd72baa7ba","datavalue":{"value":{"text":"Querying fragmented relations in a distributed database","language":"en"},"type":"monolingualtext"},"datatype":"monolingualtext"},"type":"statement","id":"Q797313$6B22869E-A4BE-4296-813F-617F21C3A106","rank":"normal"}],"P225":[{"mainsnak":{"snaktype":"value","property":"P225","hash":"149e43f03b33062dfc2243b33596bd4ede09291b","datavalue":{"value":"0545.68093","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q797313$7ACFCBA8-84DB-4C70-85D7-00D5FB6FA242","rank":"normal"}],"P27":[{"mainsnak":{"snaktype":"value","property":"P27","hash":"d072d0afdf3889e7bb3c0e9cfd26df6bf01eaefc","datavalue":{"value":"10.1007/BF00264226","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q797313$20288464-00F1-4ECA-AE21-C409FCB33720","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":"Q797313$F955D1A3-5E7A-4914-8ABD-9650336679AD","rank":"normal"}],"P28":[{"mainsnak":{"snaktype":"value","property":"P28","hash":"3c94df5c9af0ede578c52141befd29044de13172","datavalue":{"value":{"time":"+1985-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":"Q797313$C034F4F6-F211-4540-8A46-5130C80FF466","rank":"normal"}],"P1448":[{"mainsnak":{"snaktype":"value","property":"P1448","hash":"1609f549b09ecba75dc1fc8c361a4a056cbaa69a","datavalue":{"value":"The paper discusses the query optimization problem in a distributed database system supporting a complex fragmentation schema. The global relations can be fragmented horizontally and vertically; in addition, the fragmentation predicate of a fragment can be expressed in terms of attributes which are not contained in the fragment itself, and different fragments can share the same set of data, since no hypothesis of mutual exclusiveness is set on fragmentation predicates and fragment attribute lists. Several copies of the same fragment can be stored redundantly at the sites of the computer network on which the database is distributed. The fragmentation and the distribution of data are assumed to be transparent to the user, which queries the database in terms of the global relations. In this context, the problem of optimizing the processing of a query stated on a single fragmented relation is discussed, and a method for its solution is presented. The method is based on an algorithm which calculates a set of virtual fragments that can alternatively be used to answer the query. A virtual fragment is a relation obtained by combining the fragments derived from the queried global relation.","type":"string"},"datatype":"string"},"type":"statement","id":"Q797313$14BDC5E1-6176-4E5C-9922-ABFE5598D926","rank":"normal"}],"P226":[{"mainsnak":{"snaktype":"value","property":"P226","hash":"a762d1a2468ec8882180d0d1124f12b94f8eb1b0","datavalue":{"value":"68P20","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q797313$FA93D695-779B-4F93-9872-729FF0B6F005","rank":"normal"}],"P1451":[{"mainsnak":{"snaktype":"value","property":"P1451","hash":"1eabfc2b24c75531e25435353ee013fd11d56761","datavalue":{"value":"3868670","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q797313$F7835DB6-D46F-41D7-94C1-40381C9A3358","rank":"normal"}],"P1450":[{"mainsnak":{"snaktype":"value","property":"P1450","hash":"979e2e8c35d2089152d9adc9f2441c0e78da961a","datavalue":{"value":"query optimization","type":"string"},"datatype":"string"},"type":"statement","id":"Q797313$25A70FEE-D89D-4B0E-BEB2-14BAB38D5D6E","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"fdac7ff8742151d20722c0cb53f011600da6d00c","datavalue":{"value":"distributed database system","type":"string"},"datatype":"string"},"type":"statement","id":"Q797313$8A8909DB-F962-4052-AA36-78784622B763","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"7608dda43f771f93d1353ce2208b3455b4ff905d","datavalue":{"value":"complex fragmentation schema","type":"string"},"datatype":"string"},"type":"statement","id":"Q797313$254BAB9F-4124-40F4-B6F5-F3623CC34F9C","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"94972d89ba4503b868daad8e0a5b1c846954d436","datavalue":{"value":"relations","type":"string"},"datatype":"string"},"type":"statement","id":"Q797313$36F5EE37-8243-4F0D-8FC4-91B58F7339B1","rank":"normal"}],"P16":[{"mainsnak":{"snaktype":"value","property":"P16","hash":"b8457f41793a594d38c63eeb8714c30d5451244d","datavalue":{"value":{"entity-type":"item","numeric-id":676447,"id":"Q676447"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q797313$CE0155ED-87DD-4991-8523-6136294F1E23","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P16","hash":"ac7e6da889edc1007e27431c9fe05df609d2883c","datavalue":{"value":{"entity-type":"item","numeric-id":676448,"id":"Q676448"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q797313$49A1A588-500B-45BF-8532-928CD36B9F2A","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":"Q797313$47AE12F4-4E37-4EE6-B616-6023EA8FFB43","rank":"normal"}],"P223":[{"mainsnak":{"snaktype":"value","property":"P223","hash":"5b8793493983ef79387cdf9085bcee0c585bc4d0","datavalue":{"value":{"entity-type":"item","numeric-id":3347338,"id":"Q3347338"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q797313$DA4F3DC9-F6AF-4C52-9A4B-979F2DE826B2","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"dc759f4f8ac538d27cdb0db4fcd884e5633f18fd","datavalue":{"value":{"entity-type":"item","numeric-id":4179821,"id":"Q4179821"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q797313$D4778259-2A59-4E93-A6A0-50502FBA3D52","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"48e947640ce679137b03782b882d786c01f6be2c","datavalue":{"value":{"entity-type":"item","numeric-id":3313317,"id":"Q3313317"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q797313$26C342FF-1948-4E0C-98DC-7BA518496AEA","rank":"normal"}],"P205":[{"mainsnak":{"snaktype":"value","property":"P205","hash":"40939492edbaddd6a7dd5c286fa9d7f589c35458","datavalue":{"value":"https://doi.org/10.1007/bf00264226","type":"string"},"datatype":"url"},"type":"statement","id":"Q797313$266E74EB-3708-4E51-A0AB-0987E9B32A9C","rank":"normal"}],"P388":[{"mainsnak":{"snaktype":"value","property":"P388","hash":"6aae33cae14c78ba2b8fb58acbe5ae7f12aa2f4f","datavalue":{"value":"W1980624604","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q797313$59D58C36-F6F3-4A24-A84D-76390683C884","rank":"normal"}],"P1643":[{"mainsnak":{"snaktype":"value","property":"P1643","hash":"381766f0ca14b71ebcd231b04291a2850005c710","datavalue":{"value":{"entity-type":"item","numeric-id":2835068,"id":"Q2835068"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"6e459f4beaad328354b6a3739e49189a267a8622","datavalue":{"value":{"amount":"+0.90591085","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"ac3c626774dcd0d16f89557f66586245841a01db","datavalue":{"value":{"entity-type":"item","numeric-id":6767936,"id":"Q6767936"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q797313$9D6608DC-93D9-45AA-97DB-CBE5FDA9F0AC","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"13a2c4c0a9c32b91fcfd9e13f7bb67806f4fe0a9","datavalue":{"value":{"entity-type":"item","numeric-id":4298457,"id":"Q4298457"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"d8bd2cf9c18253576a2e601ed93f97a523cb1373","datavalue":{"value":{"amount":"+0.9021656","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"ac3c626774dcd0d16f89557f66586245841a01db","datavalue":{"value":{"entity-type":"item","numeric-id":6767936,"id":"Q6767936"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q797313$3109376A-6E6A-4C08-8A32-094086562907","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"9347409389c2b89bbfba157c8c51b516db181fcb","datavalue":{"value":{"entity-type":"item","numeric-id":1096417,"id":"Q1096417"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"ba58f6d8173cadb09680ed9ade8bea0487366bd9","datavalue":{"value":{"amount":"+0.9000094","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"ac3c626774dcd0d16f89557f66586245841a01db","datavalue":{"value":{"entity-type":"item","numeric-id":6767936,"id":"Q6767936"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q797313$D8E962D3-A8EC-4362-95A5-1E8C4B5022F6","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"ec1967a1463eed0b3a66b6cc33468713edbc96ff","datavalue":{"value":{"entity-type":"item","numeric-id":1903394,"id":"Q1903394"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"10935eeadaf43ab69035aacd4f6e22d57a4e4e9b","datavalue":{"value":{"amount":"+0.8971839","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"ac3c626774dcd0d16f89557f66586245841a01db","datavalue":{"value":{"entity-type":"item","numeric-id":6767936,"id":"Q6767936"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q797313$43DFB21C-5A34-4AA5-B76C-752061A0C0E2","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"fd2eaadca8b2aab75c573c0b232ec98ac4a7913a","datavalue":{"value":{"entity-type":"item","numeric-id":1362219,"id":"Q1362219"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"e31bebf62dc26bed6829793e9c9a6aedc3e57ecf","datavalue":{"value":{"amount":"+0.89222836","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"ac3c626774dcd0d16f89557f66586245841a01db","datavalue":{"value":{"entity-type":"item","numeric-id":6767936,"id":"Q6767936"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q797313$1789CA7D-0E89-4148-A9C7-72B14A4C9D83","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"688e5ab8e5eaef1625ee85b6b144ef267c07218c","datavalue":{"value":{"entity-type":"item","numeric-id":1606562,"id":"Q1606562"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"79ced475c9d8d47584353baf3f05b89abcf71eda","datavalue":{"value":{"amount":"+0.8869382","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"ac3c626774dcd0d16f89557f66586245841a01db","datavalue":{"value":{"entity-type":"item","numeric-id":6767936,"id":"Q6767936"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q797313$F82B7B48-4A5F-4543-8A61-D784C1EE54D7","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"ecffb8355040467160c3a64be6cd7ce5a27ab94a","datavalue":{"value":{"entity-type":"item","numeric-id":3686087,"id":"Q3686087"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"4142ac41ee1f9d40ec013b824c07338882575a19","datavalue":{"value":{"amount":"+0.88637567","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"ac3c626774dcd0d16f89557f66586245841a01db","datavalue":{"value":{"entity-type":"item","numeric-id":6767936,"id":"Q6767936"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q797313$5D7C7175-A64D-423F-8394-35978ABF12CC","rank":"normal"}]},"sitelinks":{"mardi":{"site":"mardi","title":"Publication:797313","badges":[],"url":"https://portal.mardi4nfdi.de/wiki/Publication:797313"}}}}}