1032 lines
58 KiB
Clojure
1032 lines
58 KiB
Clojure
{:highlights [{:id #uuid "649ca3d0-1121-47ae-ad65-ca00199e6ef3",
|
||
:page 4,
|
||
:position {:bounding {:x1 0,
|
||
:y1 -2,
|
||
:x2 468.6233825683594,
|
||
:y2 107.85417175292969,
|
||
:width 532,
|
||
:height 688.4705882352941},
|
||
:rects ({:x1 0,
|
||
:y1 -2,
|
||
:x2 0,
|
||
:y2 18,
|
||
:width 532,
|
||
:height 688.4705882352941}
|
||
{:x1 405.60394287109375,
|
||
:y1 73.828125,
|
||
:x2 468.6233825683594,
|
||
:y2 89.49479675292969,
|
||
:width 532,
|
||
:height 688.4705882352941}
|
||
{:x1 62.60416793823242,
|
||
:y1 92.1875,
|
||
:x2 208.95849227905273,
|
||
:y2 107.85417175292969,
|
||
:width 532,
|
||
:height 688.4705882352941}),
|
||
:page 4},
|
||
:content {:text "Statement Optimisation Component"},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649ca4b9-aa79-4413-ac91-46eeb8c5f8dc",
|
||
:page 4,
|
||
:position {:bounding {:x1 0,
|
||
:y1 46.00000238418579,
|
||
:x2 617.3121134340763,
|
||
:y2 363.9791793823242,
|
||
:width 700,
|
||
:height 905.8823529411765},
|
||
:rects ({:x1 0,
|
||
:y1 46.00000238418579,
|
||
:x2 0,
|
||
:y2 66.00000238418579,
|
||
:width 700,
|
||
:height 905.8823529411765}
|
||
{:x1 493.88053384423256,
|
||
:y1 333.3698043823242,
|
||
:x2 617.3121134340763,
|
||
:y2 347.3698043823242,
|
||
:width 700,
|
||
:height 905.8823529411765}
|
||
{:x1 82.38021340966225,
|
||
:y1 349.9791793823242,
|
||
:x2 533.907007843256,
|
||
:y2 363.9791793823242,
|
||
:width 700,
|
||
:height 905.8823529411765}),
|
||
:page 4},
|
||
:content {:text " At the same time, they provide use benefits of working with the SQL and the NoSQL databases simultaneously."},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649ca4c5-3c26-44f3-b714-09a0cc0d1ced",
|
||
:page 4,
|
||
:position {:bounding {:x1 0,
|
||
:y1 78.00000381469727,
|
||
:x2 617.8783365786076,
|
||
:y2 397.19271087646484,
|
||
:width 700,
|
||
:height 905.8823529411765},
|
||
:rects ({:x1 0,
|
||
:y1 78.00000381469727,
|
||
:x2 0,
|
||
:y2 98.00000381469727,
|
||
:width 700,
|
||
:height 905.8823529411765}
|
||
{:x1 488.70313516259193,
|
||
:y1 366.58333587646484,
|
||
:x2 617.8783365786076,
|
||
:y2 380.58333587646484,
|
||
:width 700,
|
||
:height 905.8823529411765}
|
||
{:x1 82.38021340966225,
|
||
:y1 383.19271087646484,
|
||
:x2 144.79764810204506,
|
||
:y2 397.19271087646484,
|
||
:width 700,
|
||
:height 905.8823529411765}),
|
||
:page 4},
|
||
:content {:text "hybrid databases’ query optimisation"},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649e88a7-6cd2-48fd-bdf2-5fd9cf1acb75",
|
||
:page 4,
|
||
:position {:bounding {:x1 0,
|
||
:y1 109.99999618530273,
|
||
:x2 720.336706161499,
|
||
:y2 501.6187858581543,
|
||
:width 816,
|
||
:height 1056},
|
||
:rects ({:x1 0,
|
||
:y1 109.99999618530273,
|
||
:x2 0,
|
||
:y2 129.99999618530273,
|
||
:width 816,
|
||
:height 1056}
|
||
{:x1 447.8806209564209,
|
||
:y1 465.86249923706055,
|
||
:x2 720.336706161499,
|
||
:y2 482.2624931335449,
|
||
:width 816,
|
||
:height 1056}
|
||
{:x1 96.03124809265137,
|
||
:y1 485.2187614440918,
|
||
:x2 326.133825302124,
|
||
:y2 501.6187858581543,
|
||
:width 816,
|
||
:height 1056}),
|
||
:page 4},
|
||
:content {:text "r, a process model for the application of hybrid statements’ optimisation was designed"},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649e88c7-a2a2-48d6-a0ae-b8b62f20c7d8",
|
||
:page 4,
|
||
:position {:bounding {:x1 0,
|
||
:y1 126.00000953674316,
|
||
:x2 864.5075225830078,
|
||
:y2 625.3374881744385,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 126.00000953674316,
|
||
:x2 0,
|
||
:y2 146.00000953674316,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 606.9569244384766,
|
||
:y1 582.5062503814697,
|
||
:x2 864.5075225830078,
|
||
:y2 602.1062870025635,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23750305175781,
|
||
:y1 605.737512588501,
|
||
:x2 348.6233673095703,
|
||
:y2 625.3374881744385,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 4},
|
||
:content {:text " extended architecture for work with the hybrid SQL/NoSQL databas"},
|
||
:properties {:color "yellow"}}
|
||
{:id #uuid "649e91fc-ccf6-4562-af97-1dd6ecd1c84e",
|
||
:page 5,
|
||
:position {:bounding {:x1 0,
|
||
:y1 61.99998474121094,
|
||
:x2 743.2085327208042,
|
||
:y2 366.78126525878906,
|
||
:width 841.9999999999999,
|
||
:height 1089.6470588235293},
|
||
:rects ({:x1 0,
|
||
:y1 61.99998474121094,
|
||
:x2 0,
|
||
:y2 81.99998474121094,
|
||
:width 841.9999999999999,
|
||
:height 1089.6470588235293}
|
||
{:x1 648.1900390684605,
|
||
:y1 329.96876525878906,
|
||
:x2 743.2085327208042,
|
||
:y2 346.7687530517578,
|
||
:width 841.9999999999999,
|
||
:height 1089.6470588235293}
|
||
{:x1 99.08750000596046,
|
||
:y1 349.9812774658203,
|
||
:x2 473.5755981504917,
|
||
:y2 366.78126525878906,
|
||
:width 841.9999999999999,
|
||
:height 1089.6470588235293}),
|
||
:page 5},
|
||
:content {:text " it is not always easy nor optimal to choose one data management technology."},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649e9240-4b40-4e81-a1b3-a5cc084a1e5a",
|
||
:page 5,
|
||
:position {:bounding {:x1 0,
|
||
:y1 46.00000190734863,
|
||
:x2 743.6399292051792,
|
||
:y2 497.37501335144043,
|
||
:width 841.9999999999999,
|
||
:height 1089.6470588235293},
|
||
:rects ({:x1 0,
|
||
:y1 46.00000190734863,
|
||
:x2 0,
|
||
:y2 66.00000190734863,
|
||
:width 841.9999999999999,
|
||
:height 1089.6470588235293}
|
||
{:x1 702.9346069395542,
|
||
:y1 460.60001945495605,
|
||
:x2 743.6399292051792,
|
||
:y2 477.4000072479248,
|
||
:width 841.9999999999999,
|
||
:height 1089.6470588235293}
|
||
{:x1 99.08750000596046,
|
||
:y1 480.57499504089355,
|
||
:x2 555.1788696348667,
|
||
:y2 497.37501335144043,
|
||
:width 841.9999999999999,
|
||
:height 1089.6470588235293}),
|
||
:page 5},
|
||
:content {:text "hybrid databases enable integration and concurrent use of different technologies."},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649e924b-0bc5-4cfa-b6a7-79af99908af1",
|
||
:page 5,
|
||
:position {:bounding {:x1 195.9580902159214,
|
||
:y1 500.5562572479248,
|
||
:x2 492.8680023252964,
|
||
:y2 517.3562450408936,
|
||
:width 841.9999999999999,
|
||
:height 1089.6470588235293},
|
||
:rects ({:x1 195.9580902159214,
|
||
:y1 500.5562572479248,
|
||
:x2 492.8680023252964,
|
||
:y2 517.3562450408936,
|
||
:width 841.9999999999999,
|
||
:height 1089.6470588235293}),
|
||
:page 5},
|
||
:content {:text "best functionalities of different database types"},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649e940e-5bd6-4f13-91d6-a49aad143466",
|
||
:page 5,
|
||
:position {:bounding {:x1 0,
|
||
:y1 62,
|
||
:x2 863.4581832885742,
|
||
:y2 823.3187561035156,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 62,
|
||
:x2 0,
|
||
:y2 82,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 343.5813522338867,
|
||
:y1 780.4875183105469,
|
||
:x2 863.4581832885742,
|
||
:y2 800.0874938964844,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 803.71875,
|
||
:x2 359.88134384155273,
|
||
:y2 823.3187561035156,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 5},
|
||
:content {:text "he following research questions led to the hybrid SQL/NoSQL database extension presented in this paper:"},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649e9433-c26d-4d1d-b362-e82c9d89841f",
|
||
:page 5,
|
||
:position {:bounding {:x1 776.1978378295898,
|
||
:y1 839.8187561035156,
|
||
:x2 840.8364486694336,
|
||
:y2 859.4187622070312,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 776.1978378295898,
|
||
:y1 839.8187561035156,
|
||
:x2 840.8364486694336,
|
||
:y2 859.4187622070312,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 5},
|
||
:content {:text "improve "},
|
||
:properties {:color "yellow"}}
|
||
{:id #uuid "649e946d-4898-4ccc-bc4c-ed67d2d18d79",
|
||
:page 5,
|
||
:position {:bounding {:x1 233.06780242919922,
|
||
:y1 909.3187561035156,
|
||
:x2 407.8989791870117,
|
||
:y2 928.9187316894531,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 233.06780242919922,
|
||
:y1 909.3187561035156,
|
||
:x2 407.8989791870117,
|
||
:y2 928.9187316894531,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 5},
|
||
:content {:text "adjust the architecture"},
|
||
:properties {:color "yellow"}}
|
||
{:id #uuid "649e948f-4798-4f88-8411-1d2d56a0d863",
|
||
:page 5,
|
||
:position {:bounding {:x1 172.8312530517578,
|
||
:y1 1002.1062316894531,
|
||
:x2 444.65562438964844,
|
||
:y2 1021.7062683105469,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 172.8312530517578,
|
||
:y1 1002.1062316894531,
|
||
:x2 444.65562438964844,
|
||
:y2 1021.7062683105469,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 5},
|
||
:content {:text "duration of the statement execution"},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649e9baa-7f3a-4251-a8d5-38575eb8c9f0",
|
||
:page 7,
|
||
:position {:bounding {:x1 0,
|
||
:y1 -2,
|
||
:x2 863.7871322631836,
|
||
:y2 157.19375610351562,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 -2,
|
||
:x2 0,
|
||
:y2 18,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 345.68416595458984,
|
||
:y1 116.05624389648438,
|
||
:x2 863.7871322631836,
|
||
:y2 135.65625,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 137.59375,
|
||
:x2 299.4574089050293,
|
||
:y2 157.19375610351562,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 7},
|
||
:content {:text "e hybrid SQL/NoSQL databases and presented dedicated components of the extended ER model."},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649e9bca-6a93-4690-b524-e12377ec92bb",
|
||
:page 8,
|
||
:position {:bounding {:x1 0,
|
||
:y1 14,
|
||
:x2 864.3825302124023,
|
||
:y2 1129.9875183105469,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 14,
|
||
:x2 0,
|
||
:y2 34,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 350.5088424682617,
|
||
:y1 1087.1625061035156,
|
||
:x2 864.3825302124023,
|
||
:y2 1106.7625427246094,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 1110.3875427246094,
|
||
:x2 274.917537689209,
|
||
:y2 1129.9875183105469,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 8},
|
||
:content {:text "Section confirmed the purposefulness of further hybrid database optimisation research"},
|
||
:properties {:color "yellow"}}
|
||
{:id #uuid "649e9ca7-bd76-4ef1-b1ca-581976b855b0",
|
||
:page 9,
|
||
:position {:bounding {:x1 0,
|
||
:y1 142,
|
||
:x2 863.5239486694336,
|
||
:y2 612.6625213623047,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 142,
|
||
:x2 0,
|
||
:y2 162.00001525878906,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 513.3606491088867,
|
||
:y1 571.5624847412109,
|
||
:x2 863.5239486694336,
|
||
:y2 591.1625213623047,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 593.0624847412109,
|
||
:x2 318.4879722595215,
|
||
:y2 612.6625213623047,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 9},
|
||
:content {:text "herefore, none of the NoSQL database subtypes have their unique language. "},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649e9ce6-a2d9-4283-b819-905f0a9cd976",
|
||
:page 9,
|
||
:position {:bounding {:x1 0,
|
||
:y1 46,
|
||
:x2 864.2683944702148,
|
||
:y2 797.4000244140625,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 46,
|
||
:x2 0,
|
||
:y2 66,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 703.6176986694336,
|
||
:y1 756.2937622070312,
|
||
:x2 864.2683944702148,
|
||
:y2 775.8937377929688,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 777.7999877929688,
|
||
:x2 175.76902770996094,
|
||
:y2 797.4000244140625,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 9},
|
||
:content {:text " its decomposition and analysis."},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649e9d3c-a5aa-4bb0-a1eb-b63bf20775f1",
|
||
:page 9,
|
||
:position {:bounding {:x1 343.59093475341797,
|
||
:y1 1104.2437744140625,
|
||
:x2 806.0404281616211,
|
||
:y2 1123.84375,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 343.59093475341797,
|
||
:y1 1104.2437744140625,
|
||
:x2 806.0404281616211,
|
||
:y2 1123.84375,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 9},
|
||
:content {:text "e input statement (SELECT, INSERT, UPDATE, DELETE), the "},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649e9d59-bb93-4fe3-9ff8-2190926461ad",
|
||
:page 10,
|
||
:position {:bounding {:x1 0,
|
||
:y1 14,
|
||
:x2 864.4342880249023,
|
||
:y2 178.6937484741211,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 14,
|
||
:x2 0,
|
||
:y2 34.00000762939453,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 501.17208099365234,
|
||
:y1 137.59375762939453,
|
||
:x2 864.4342880249023,
|
||
:y2 157.1937484741211,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 159.09374237060547,
|
||
:x2 752.006175994873,
|
||
:y2 178.6937484741211,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 10},
|
||
:content {:text "ested statements (i.e. UPDATE with subquery or DELETE with subquery) is not supported by the current version of the architecture."},
|
||
:properties {:color "purple"}}
|
||
{:id #uuid "649e9dd2-452c-4ec7-96e8-a47f83d53b72",
|
||
:page 10,
|
||
:position {:bounding {:x1 0,
|
||
:y1 94,
|
||
:x2 863.0100479125977,
|
||
:y2 1085.2562561035156,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 94,
|
||
:x2 0,
|
||
:y2 114,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 808.8772964477539,
|
||
:y1 1044.1499938964844,
|
||
:x2 863.0100479125977,
|
||
:y2 1063.75,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23750305175781,
|
||
:y1 1065.65625,
|
||
:x2 522.1642608642578,
|
||
:y2 1085.2562561035156,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 10},
|
||
:content {:text "parallel optimisation of different parts of the input statement."},
|
||
:properties {:color "yellow"}}
|
||
{:id #uuid "649ea279-fba6-419e-9d15-79f55de27ebf",
|
||
:page 12,
|
||
:position {:bounding {:x1 532.143669128418,
|
||
:y1 845.5749969482422,
|
||
:x2 664.0707015991211,
|
||
:y2 865.1750335693359,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 532.143669128418,
|
||
:y1 845.5749969482422,
|
||
:x2 664.0707015991211,
|
||
:y2 865.1750335693359,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 12},
|
||
:content {:text "“multiple” records"},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "649ea2a5-80c2-4d4b-87ab-95db901d8f3f",
|
||
:page 12,
|
||
:position {:bounding {:x1 482.1943054199219,
|
||
:y1 1032.7500305175781,
|
||
:x2 492.6849670410156,
|
||
:y2 1052.7500305175781,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 482.1943054199219,
|
||
:y1 1032.7500305175781,
|
||
:x2 492.6849670410156,
|
||
:y2 1052.7500305175781,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 12},
|
||
:content {:text "."},
|
||
:properties {:color "red"}}
|
||
{:id #uuid "649ea2e1-c889-413f-bb86-770c9c71ca0a",
|
||
:page 13,
|
||
:position {:bounding {:x1 0,
|
||
:y1 14,
|
||
:x2 863.8603630065918,
|
||
:y2 200.20001220703125,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 14,
|
||
:x2 0,
|
||
:y2 34,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 0,
|
||
:y1 30,
|
||
:x2 0,
|
||
:y2 50,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 458.580078125,
|
||
:y1 137.59375,
|
||
:x2 863.6041870117188,
|
||
:y2 157.19378662109375,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 159.09375,
|
||
:x2 863.8603630065918,
|
||
:y2 178.69378662109375,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 180.60003662109375,
|
||
:x2 579.2480583190918,
|
||
:y2 200.20001220703125,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 13},
|
||
:content {:text " As in the case of stating the hint for non-adequate and non-optimal indexes during query execution, the stated PARALLEL hint gets neglected, and the statement is executed without an error occurring due to the forwarded hint"},
|
||
:properties {:color "yellow"}}
|
||
{:id #uuid "649ea3ad-9bab-47b2-b016-1a130602119f",
|
||
:page 13,
|
||
:position {:bounding {:x1 115.23749923706055,
|
||
:y1 300.7937316894531,
|
||
:x2 306.3981742858887,
|
||
:y2 320.3937683105469,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 115.23749923706055,
|
||
:y1 300.7937316894531,
|
||
:x2 306.3981742858887,
|
||
:y2 320.3937683105469,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 13},
|
||
:content {:text "hybrid database extension"},
|
||
:properties {:color "yellow"}}
|
||
{:id #uuid "649ea688-37eb-4efe-a3d1-853c4798294f",
|
||
:page 13,
|
||
:position {:bounding {:x1 0,
|
||
:y1 14,
|
||
:x2 864.4994049072266,
|
||
:y2 569.4625091552734,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 14,
|
||
:x2 0,
|
||
:y2 34,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 0,
|
||
:y1 30,
|
||
:x2 0,
|
||
:y2 50,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 0,
|
||
:y1 46,
|
||
:x2 0,
|
||
:y2 66,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 0,
|
||
:y1 62,
|
||
:x2 0,
|
||
:y2 82,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 0,
|
||
:y1 78,
|
||
:x2 0,
|
||
:y2 97.99999237060547,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23750305175781,
|
||
:y1 442.5375061035156,
|
||
:x2 864.4795684814453,
|
||
:y2 462.1374969482422,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23750305175781,
|
||
:y1 464.0375061035156,
|
||
:x2 864.1584014892578,
|
||
:y2 483.6374969482422,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23750305175781,
|
||
:y1 485.5437469482422,
|
||
:x2 863.4226226806641,
|
||
:y2 505.1437530517578,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23750305175781,
|
||
:y1 507.0500030517578,
|
||
:x2 863.8680572509766,
|
||
:y2 526.6500091552734,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23750305175781,
|
||
:y1 528.3625030517578,
|
||
:x2 864.4994049072266,
|
||
:y2 547.9625091552734,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23750305175781,
|
||
:y1 549.8625030517578,
|
||
:x2 235.0834732055664,
|
||
:y2 569.4625091552734,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 13},
|
||
:content {:text "At this time, creating a fully comprehensive solution for optimising all types of databases that a single hybrid can encompass is extremely challenging to do. It is not an easy task to determine the number of domain-specific languages used by all NoSQL databases currently available on the market. Even if there were an estimate, without the language standardisation by the leading NoSQL manufacturers, there would not be a comprehensive solution for implementing the optimisation techniques for the whole hybrid database."},
|
||
:properties {:color "yellow"}}
|
||
{:id #uuid "649ea7ad-938f-4d56-acc6-777ce8a3b251",
|
||
:page 14,
|
||
:position {:bounding {:x1 111.19999694824219,
|
||
:y1 730.599609375,
|
||
:x2 862.1999969482422,
|
||
:y2 798.599609375,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects (),
|
||
:page 14},
|
||
:content {:text "[:span]", :image 1688119210696},
|
||
:properties {:color "yellow"}}
|
||
{:id #uuid "64a29c98-a362-44ae-8cfa-47c71f2f4f0d",
|
||
:page 13,
|
||
:position {:bounding {:x1 0,
|
||
:y1 29.606251001358032,
|
||
:x2 899.9824333190918,
|
||
:y2 815.4562873840332,
|
||
:width 1019.9999999999999,
|
||
:height 1319.9999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 29.606251001358032,
|
||
:x2 0,
|
||
:y2 50.00625252723694,
|
||
:width 1019.9999999999999,
|
||
:height 1319.9999999999998}
|
||
{:x1 598.788890838623,
|
||
:y1 772.6594123840332,
|
||
:x2 899.9824333190918,
|
||
:y2 793.0593757629395,
|
||
:width 1019.9999999999999,
|
||
:height 1319.9999999999998}
|
||
{:x1 120.03750228881836,
|
||
:y1 795.0562629699707,
|
||
:x2 282.3698844909668,
|
||
:y2 815.4562873840332,
|
||
:width 1019.9999999999999,
|
||
:height 1319.9999999999998}),
|
||
:page 13},
|
||
:content {:text " integration and uniform use of all hybrid database components"},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "64a29cae-b6b0-41ba-92ca-de1c150f7f65",
|
||
:page 13,
|
||
:position {:bounding {:x1 511.03498458862305,
|
||
:y1 839.6531867980957,
|
||
:x2 857.530345916748,
|
||
:y2 860.053150177002,
|
||
:width 1019.9999999999999,
|
||
:height 1319.9999999999998},
|
||
:rects ({:x1 511.03498458862305,
|
||
:y1 839.6531867980957,
|
||
:x2 857.530345916748,
|
||
:y2 860.053150177002,
|
||
:width 1019.9999999999999,
|
||
:height 1319.9999999999998}),
|
||
:page 13},
|
||
:content {:text "lack of support for the statement optimisation"},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "64a2e58c-bab3-4f30-9360-3b6f1cf7278d",
|
||
:page 13,
|
||
:position {:bounding {:x1 0,
|
||
:y1 109.99996948242188,
|
||
:x2 864.3781242370605,
|
||
:y2 1074.8874816894531,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 109.99996948242188,
|
||
:x2 0,
|
||
:y2 129.99996948242188,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 0,
|
||
:y1 125.99996948242188,
|
||
:x2 0,
|
||
:y2 145.99996948242188,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 643.0781478881836,
|
||
:y1 1012.28125,
|
||
:x2 863.5459213256836,
|
||
:y2 1031.8812561035156,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 1033.7875061035156,
|
||
:x2 864.3781242370605,
|
||
:y2 1053.3874816894531,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 1055.2875061035156,
|
||
:x2 257.3617973327637,
|
||
:y2 1074.8874816894531,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 13},
|
||
:content {:text " The motivation was to provide the comfort of using a single query language and to free the user from thinking about which component has requested data."},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "64a2e622-e577-47b2-ab14-1117283772be",
|
||
:page 15,
|
||
:position {:bounding {:x1 190.27136993408203,
|
||
:y1 180.60000610351562,
|
||
:x2 818.1420974731445,
|
||
:y2 200.20001220703125,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 190.27136993408203,
|
||
:y1 180.60000610351562,
|
||
:x2 818.1420974731445,
|
||
:y2 200.20001220703125,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 15},
|
||
:content {:text "the whole hybrid database, with all its components, represents a single logical database."},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "64a3d756-ef2f-49b7-9400-2b678a5716db",
|
||
:page 17,
|
||
:position {:bounding {:x1 395.14696502685547,
|
||
:y1 773.5750122070312,
|
||
:x2 469.10997772216797,
|
||
:y2 793.1749877929688,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 395.14696502685547,
|
||
:y1 773.5750122070312,
|
||
:x2 469.10997772216797,
|
||
:y2 793.1749877929688,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 17},
|
||
:content {:text "consists fo"},
|
||
:properties {:color "red"}}
|
||
{:id #uuid "64a3d84b-cb6b-490d-9d15-402fc8ace928",
|
||
:page 18,
|
||
:position {:bounding {:x1 0,
|
||
:y1 206,
|
||
:x2 864.5353507995605,
|
||
:y2 1038.9875183105469,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 206,
|
||
:x2 0,
|
||
:y2 226.00003051757812,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 0,
|
||
:y1 222.00003051757812,
|
||
:x2 0,
|
||
:y2 242.00003051757812,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 747.5442123413086,
|
||
:y1 972.9187774658203,
|
||
:x2 864.2347640991211,
|
||
:y2 992.5187683105469,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 996.1500244140625,
|
||
:x2 864.5353507995605,
|
||
:y2 1015.7500305175781,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 1019.3875427246094,
|
||
:x2 659.4742546081543,
|
||
:y2 1038.9875183105469,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 18},
|
||
:content {:text " Table 3 displays the use case id, a statement type, a destination component of the hybrid, a statement description and a statement syntax before and after applying the supported optimisation rules"},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "64a3d97f-362b-49a7-98fd-ebef7b13aa44",
|
||
:page 16,
|
||
:position {:bounding {:x1 241.75625610351562,
|
||
:y1 116.05624389648438,
|
||
:x2 520.8761291503906,
|
||
:y2 135.65625,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 241.75625610351562,
|
||
:y1 116.05624389648438,
|
||
:x2 520.8761291503906,
|
||
:y2 135.65625,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 16},
|
||
:content {:text "Optimisation Rules repository structure"},
|
||
:properties {:color "red"}}
|
||
{:id #uuid "64a3d9ce-f38f-4200-a01e-d99143306478",
|
||
:page 16,
|
||
:position {:bounding {:x1 0,
|
||
:y1 46,
|
||
:x2 864.4638671875,
|
||
:y2 658.5500030517578,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 46,
|
||
:x2 0,
|
||
:y2 66,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 730.2565307617188,
|
||
:y1 617.6374969482422,
|
||
:x2 864.4638671875,
|
||
:y2 637.2375030517578,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23750114440918,
|
||
:y1 638.9499969482422,
|
||
:x2 259.95853996276855,
|
||
:y2 658.5500030517578,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 16},
|
||
:content {:text "as well as to show the effects of its use"},
|
||
:properties {:color "red"}}
|
||
{:id #uuid "64a3dacc-eb7d-4f2d-a8da-c6a5a3fbab07",
|
||
:page 20,
|
||
:position {:bounding {:x1 0,
|
||
:y1 126.0000057220459,
|
||
:x2 864.5153121948242,
|
||
:y2 614.5875377655029,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 126.0000057220459,
|
||
:x2 0,
|
||
:y2 146.0000057220459,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 167.79668426513672,
|
||
:y1 571.9437389373779,
|
||
:x2 864.5153121948242,
|
||
:y2 591.5437755584717,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23750305175781,
|
||
:y1 594.9875011444092,
|
||
:x2 741.3741607666016,
|
||
:y2 614.5875377655029,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 20},
|
||
:content {:text "What follows is the display and the analysis of the average execution times of the use cases chosen for testing, focusing on the execution times before and after the optimisation rules use."},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "64a3db91-ad7a-4313-9df4-2ead0ad100b4",
|
||
:page 21,
|
||
:position {:bounding {:x1 210.65296173095703,
|
||
:y1 932.0249938964844,
|
||
:x2 387.9308395385742,
|
||
:y2 951.6250305175781,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 210.65296173095703,
|
||
:y1 932.0249938964844,
|
||
:x2 387.9308395385742,
|
||
:y2 951.6250305175781,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 21},
|
||
:content {:text "slight syntax adjustment."},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "64a3dbce-7ccf-4bb2-8280-40b9f7444822",
|
||
:page 21,
|
||
:position {:bounding {:x1 463.07604217529297,
|
||
:y1 1024.7624816894531,
|
||
:x2 811.857536315918,
|
||
:y2 1044.3625183105469,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 463.07604217529297,
|
||
:y1 1024.7624816894531,
|
||
:x2 811.857536315918,
|
||
:y2 1044.3625183105469,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 21},
|
||
:content {:text "ncrease in the number of statement characters"},
|
||
:properties {:color "yellow"}}
|
||
{:id #uuid "64a3dc16-2f5f-4072-969b-2a52eeed144b",
|
||
:page 24,
|
||
:position {:bounding {:x1 115.23750305175781,
|
||
:y1 116.05624389648438,
|
||
:x2 226.2530288696289,
|
||
:y2 135.65628051757812,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 115.23750305175781,
|
||
:y1 116.05624389648438,
|
||
:x2 226.2530288696289,
|
||
:y2 135.65628051757812,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 24},
|
||
:content {:text "generalisation"},
|
||
:properties {:color "yellow"}}
|
||
{:id #uuid "64a3dc8f-37b3-4528-bf4f-209a289e55b9",
|
||
:page 24,
|
||
:position {:bounding {:x1 0,
|
||
:y1 14,
|
||
:x2 864.5812492370605,
|
||
:y2 439.48126220703125,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 14,
|
||
:x2 0,
|
||
:y2 34,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 0,
|
||
:y1 30,
|
||
:x2 0,
|
||
:y2 50,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 373.5625,
|
||
:x2 864.5812492370605,
|
||
:y2 393.16253662109375,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 396.8375244140625,
|
||
:x2 864.3576164245605,
|
||
:y2 416.4375,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 419.88128662109375,
|
||
:x2 254.64866256713867,
|
||
:y2 439.48126220703125,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 24},
|
||
:content {:text "However, the obvious trend observed was that the hybrid database with the SOC component required less time for test statements execution when the number of records increased, in comparison to the hybrid without SOC"},
|
||
:properties {:color "green"}}
|
||
{:id #uuid "64a3dcc9-e85b-4fcd-b64d-6ea17254cea0",
|
||
:page 24,
|
||
:position {:bounding {:x1 0,
|
||
:y1 45.999996185302734,
|
||
:x2 864.1482772827148,
|
||
:y2 753.8187599182129,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998},
|
||
:rects ({:x1 0,
|
||
:y1 45.999996185302734,
|
||
:x2 0,
|
||
:y2 65.99999618530273,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 377.56404876708984,
|
||
:y1 710.9875221252441,
|
||
:x2 864.1482772827148,
|
||
:y2 730.5874977111816,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}
|
||
{:x1 115.23749923706055,
|
||
:y1 734.2187843322754,
|
||
:x2 713.570629119873,
|
||
:y2 753.8187599182129,
|
||
:width 979.1999999999999,
|
||
:height 1267.1999999999998}),
|
||
:page 24},
|
||
:content {:text "The current version still does not support the unified execution of multiple different statements (i.e. UPDATE with subquery or DELETE with subquery)"},
|
||
:properties {:color "yellow"}}],
|
||
:extra {:page 2}}
|