Matches in SemOpenAlex for { <https://semopenalex.org/work/W588228081> ?p ?o ?g. }
Showing items 1 to 84 of
84
with 100 items per page.
- W588228081 abstract "Big Data is an expanding topic in information technology based on the huge amounts of data which are generated by IT systems. The ability to store structured and unstructured data at petabyte scale will improve the efforts of business intelligence and widely expand the type of questions which can be answered with these systems. To address changes in data management for large data warehouses (DWH) several new products are released on top of the Hadoop ecosystem. We focus on storing data for business analytics concerned questions and running queries against it. Where the Hadoop distributed file system (HDFS) has its strengths at parallel processing and reading files in a sequential access pattern, we are interested in getting answers to business related questions based on aggregations. Answering these questions calls for range queries accessing subsets of data. The problem of dealing with files in Hadoop needs knowledge of the Map-Reduce principle and different languages are used to access the data. Enterprises have to invest time and money in new systems and know-how for Big Data systems. A new way is to provide the well known ANSI SQL standard for querying data on Hadoop platforms. Already done investment on the analytics side could be reused on the new platform. We have analyzed the capabilities of IBM BigSQL. To compare performance and semantic differences between IBM BigSQL and a traditional relational DWH solution, we built up a distributed IBM DB2 cluster based on IBM Database Partitioning Feature (DPF) technology and used an IBM BigInsights cluster to execute analytical queries. We have selected the TPC-H benchmark simulating a typical OLAP workload as use case. We have measured performance of query execution as well as scaling out characteristics. The results show us that in some cases processing an analytical query on a Big Data platform could be more efficient than on relational DWH systems. The Hadoop ecosystem owns lot of potential but brings along lot of drawbacks as well. But with these in mind, a cost-efficient DWH can be established. Beside the established traditional way many hadoop-based solutions are in development to avoid the negative aspects of the Map-Reduce principle. After our research and measurements during this thesis we came to the conclusion that all of the investigated products could be used in a production environment. A recommendation which product could be used for analytical queries depends of many different factors like costs, query execution time and diversity." @default.
- W588228081 created "2016-06-24" @default.
- W588228081 creator A5047320602 @default.
- W588228081 creator A5087200493 @default.
- W588228081 date "2013-12-20" @default.
- W588228081 modified "2023-09-27" @default.
- W588228081 title "Relational Data Access on Big Data" @default.
- W588228081 cites W1473922327 @default.
- W588228081 cites W1978660499 @default.
- W588228081 cites W2110086534 @default.
- W588228081 cites W2110528713 @default.
- W588228081 cites W2119738171 @default.
- W588228081 hasPublicationYear "2013" @default.
- W588228081 type Work @default.
- W588228081 sameAs 588228081 @default.
- W588228081 citedByCount "0" @default.
- W588228081 crossrefType "dissertation" @default.
- W588228081 hasAuthorship W588228081A5047320602 @default.
- W588228081 hasAuthorship W588228081A5087200493 @default.
- W588228081 hasConcept C111919701 @default.
- W588228081 hasConcept C135572916 @default.
- W588228081 hasConcept C136764020 @default.
- W588228081 hasConcept C1668388 @default.
- W588228081 hasConcept C171250308 @default.
- W588228081 hasConcept C192562407 @default.
- W588228081 hasConcept C201932085 @default.
- W588228081 hasConcept C2522767166 @default.
- W588228081 hasConcept C2767350 @default.
- W588228081 hasConcept C2779599972 @default.
- W588228081 hasConcept C2781252014 @default.
- W588228081 hasConcept C41008148 @default.
- W588228081 hasConcept C47487241 @default.
- W588228081 hasConcept C510870499 @default.
- W588228081 hasConcept C5655090 @default.
- W588228081 hasConcept C70388272 @default.
- W588228081 hasConcept C75684735 @default.
- W588228081 hasConcept C77088390 @default.
- W588228081 hasConcept C79158427 @default.
- W588228081 hasConceptScore W588228081C111919701 @default.
- W588228081 hasConceptScore W588228081C135572916 @default.
- W588228081 hasConceptScore W588228081C136764020 @default.
- W588228081 hasConceptScore W588228081C1668388 @default.
- W588228081 hasConceptScore W588228081C171250308 @default.
- W588228081 hasConceptScore W588228081C192562407 @default.
- W588228081 hasConceptScore W588228081C201932085 @default.
- W588228081 hasConceptScore W588228081C2522767166 @default.
- W588228081 hasConceptScore W588228081C2767350 @default.
- W588228081 hasConceptScore W588228081C2779599972 @default.
- W588228081 hasConceptScore W588228081C2781252014 @default.
- W588228081 hasConceptScore W588228081C41008148 @default.
- W588228081 hasConceptScore W588228081C47487241 @default.
- W588228081 hasConceptScore W588228081C510870499 @default.
- W588228081 hasConceptScore W588228081C5655090 @default.
- W588228081 hasConceptScore W588228081C70388272 @default.
- W588228081 hasConceptScore W588228081C75684735 @default.
- W588228081 hasConceptScore W588228081C77088390 @default.
- W588228081 hasConceptScore W588228081C79158427 @default.
- W588228081 hasLocation W5882280811 @default.
- W588228081 hasOpenAccess W588228081 @default.
- W588228081 hasPrimaryLocation W5882280811 @default.
- W588228081 hasRelatedWork W109998294 @default.
- W588228081 hasRelatedWork W1591949849 @default.
- W588228081 hasRelatedWork W1777383459 @default.
- W588228081 hasRelatedWork W2021724486 @default.
- W588228081 hasRelatedWork W2035697975 @default.
- W588228081 hasRelatedWork W2220172898 @default.
- W588228081 hasRelatedWork W2333671020 @default.
- W588228081 hasRelatedWork W2737369045 @default.
- W588228081 hasRelatedWork W2740463104 @default.
- W588228081 hasRelatedWork W2768195657 @default.
- W588228081 hasRelatedWork W2784053383 @default.
- W588228081 hasRelatedWork W2910860878 @default.
- W588228081 hasRelatedWork W2978110785 @default.
- W588228081 hasRelatedWork W3030462878 @default.
- W588228081 hasRelatedWork W3115006142 @default.
- W588228081 hasRelatedWork W864904335 @default.
- W588228081 hasRelatedWork W1904816165 @default.
- W588228081 hasRelatedWork W2186378240 @default.
- W588228081 hasRelatedWork W2277428945 @default.
- W588228081 hasRelatedWork W2945921199 @default.
- W588228081 isParatext "false" @default.
- W588228081 isRetracted "false" @default.
- W588228081 magId "588228081" @default.
- W588228081 workType "dissertation" @default.