Advertisement
Published in:
2021 | OriginalPaper | Chapter
Hadoop/Hive Data Query Performance Comparison Between Data Warehouses Designed by Data Vault and Snowflake Methodologies
Authors : Yuri Grigoriev, Evgeny Ermakov, Oleg Ermakov
Published in: Modern Information Technology and IT Education
Publisher: Springer International Publishing
Activate our intelligent search to find suitable subject content or patents.
Select sections of text to find matching patents with Artificial Intelligence. powered by
Select sections of text to find additional relevant content using AI-assisted search. powered by
Abstract
The article discusses the difference between Data Vault and Snowflake methodologies in Hadoop infrastructure. The history of Data Vault methodology development from the original version to the modern is showed. The main components of Data Vault are described: hubs, communications, satellites. A comparison of the Data Vault approach with the classic star and snowflake approaches is performed. TPC-H test schema is designed using the Data Vault methodology: business entities are identified and converted to hubs, their rela-tionships are allocated to satellites. Result storage size and query execution time comparison between Data Vault and Snowflake is performed.