'Shared-Nothing' Cloud Data Warehouse Architecture

Energy management systems from Romania do not have the capabilities of energy specific management due to lack of technology for real-time monitoring. As was the case in many other countries, the advent of smart metering technology will increase the level of energy data significantly. Therefore, the...

Full description

Bibliographic Details
Main Author: Janina POPEANGA
Format: Article
Language:English
Published: Bucharest University of Economic Studies 2015-03-01
Series:Database Systems Journal
Subjects:
Online Access:http://www.dbjournal.ro/archive/18/18_1.pdf
_version_ 1797709292108775424
author Janina POPEANGA
author_facet Janina POPEANGA
author_sort Janina POPEANGA
collection DOAJ
description Energy management systems from Romania do not have the capabilities of energy specific management due to lack of technology for real-time monitoring. As was the case in many other countries, the advent of smart metering technology will increase the level of energy data significantly. Therefore, the purpose of this paper is to present solutions that need to be taken to solve problems linked with the increasing amount of data recorded by sensors. For a better demonstration of theoretical elements exposed, we considered a data warehouse specific to utility companies. Section 2 of this article defines the three widely used parallel data warehouse architectures, while in Section 3 we clarify what architecture is suited to develop a data warehouse in the cloud. In the last part we transposed our tables in a "shared-nothing" architecture, trying to analyze queries performance.
first_indexed 2024-03-12T06:34:24Z
format Article
id doaj.art-b3f8ea91a64043d688c403ef6c837f1b
institution Directory Open Access Journal
issn 2069-3230
2069-3230
language English
last_indexed 2024-03-12T06:34:24Z
publishDate 2015-03-01
publisher Bucharest University of Economic Studies
record_format Article
series Database Systems Journal
spelling doaj.art-b3f8ea91a64043d688c403ef6c837f1b2023-09-03T01:25:55ZengBucharest University of Economic StudiesDatabase Systems Journal2069-32302069-32302015-03-01V4311'Shared-Nothing' Cloud Data Warehouse ArchitectureJanina POPEANGA0Bucharest Academy of Economic StudiesEnergy management systems from Romania do not have the capabilities of energy specific management due to lack of technology for real-time monitoring. As was the case in many other countries, the advent of smart metering technology will increase the level of energy data significantly. Therefore, the purpose of this paper is to present solutions that need to be taken to solve problems linked with the increasing amount of data recorded by sensors. For a better demonstration of theoretical elements exposed, we considered a data warehouse specific to utility companies. Section 2 of this article defines the three widely used parallel data warehouse architectures, while in Section 3 we clarify what architecture is suited to develop a data warehouse in the cloud. In the last part we transposed our tables in a "shared-nothing" architecture, trying to analyze queries performance.http://www.dbjournal.ro/archive/18/18_1.pdfShared-nothing architectureData WarehouseReplicationDistributionCloud
spellingShingle Janina POPEANGA
'Shared-Nothing' Cloud Data Warehouse Architecture
Database Systems Journal
Shared-nothing architecture
Data Warehouse
Replication
Distribution
Cloud
title 'Shared-Nothing' Cloud Data Warehouse Architecture
title_full 'Shared-Nothing' Cloud Data Warehouse Architecture
title_fullStr 'Shared-Nothing' Cloud Data Warehouse Architecture
title_full_unstemmed 'Shared-Nothing' Cloud Data Warehouse Architecture
title_short 'Shared-Nothing' Cloud Data Warehouse Architecture
title_sort shared nothing cloud data warehouse architecture
topic Shared-nothing architecture
Data Warehouse
Replication
Distribution
Cloud
url http://www.dbjournal.ro/archive/18/18_1.pdf
work_keys_str_mv AT janinapopeanga sharednothingclouddatawarehousearchitecture