smart energy process and architecture · 2020-04-08 · customers oracle database tabk oracle...
TRANSCRIPT
![Page 1: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/1.jpg)
Smart Energy Process and Architecture
ESSNet Big Data II
![Page 2: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/2.jpg)
• WPD overview
• Business process
• Information Architecture draft
• Application Architecture draft
• Common Sensor Data Architecture
Summary2
![Page 3: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/3.jpg)
• 4 countries: Estonia, Norway, Sweden, Denmark
• 3 statistical products:
- electricity statistics of businesses (EE, DK, SE)
- electricity statistics of households (DK, SE)
- identifying vacant or seasonally vacant dwelling (EE, NO)
WPD overview3
![Page 4: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/4.jpg)
Business process and architecture4
AS-IS processes Common visionof the process
Reference architecture for future projects
![Page 5: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/5.jpg)
WPD Business process 1/45
• Modeling language: BPMN 2.0
• Modeling software: Bizagi Modeler
• Used approach: Excel template and process mapping
![Page 6: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/6.jpg)
WPD Business process 2/46
• Acquisition and Recording, Data Representation
![Page 7: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/7.jpg)
WPD Business process 3/47
• Data wrangling
![Page 8: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/8.jpg)
WPD Business process 4/48
• Shape output, Modeling and Interpretation, Integrate Survey & Register Data
![Page 9: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/9.jpg)
Daily electricity consumption in Estonia (Household)9
![Page 10: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/10.jpg)
Daily electricity consumption in Estonia (Business)10
![Page 11: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/11.jpg)
Electricity consumption in Estonia (by sector)11
![Page 12: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/12.jpg)
Information Architecture draft12
![Page 13: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/13.jpg)
Application Architecture draft13
![Page 14: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/14.jpg)
Common Sensor Data Architecture14
![Page 15: Smart Energy Process and Architecture · 2020-04-08 · CUSTOMERS Oracle database tabk Oracle STATDW database, FOR 50307 schema, CUSTOMERS table Based on the address information fields](https://reader035.vdocuments.us/reader035/viewer/2022081406/5f17b841b246624d076e9b4f/html5/thumbnails/15.jpg)
Thank you!Frederik Bogdanovits, Tauno Tamm
[email protected], [email protected]
Statistics Estoniawww.stat.eeTatari 51, 10134 Tallinn
15