Методика проектирования корпоративного хранилища данных на базе платформы SAP Net Weaver Business Warehouse

Методика проектирования корпоративного хранилища данных…

ISSN 0236-3933. Вестник МГТУ им. Н.Э. Баумана. Сер. Приборостроение. 2016. № 4

Просьба ссылатьсяна эту статьюследующимобразом:

Тоноян С.А., Высочанский В.А. Методика проектирования корпоративного хранилища

данных на базе платформы SAP NetWeaver Business Warehouse // Вестник МГТУ

им. Н.Э. Баумана. Сер. Приборостроение. 2016. № 4. C. 33–48.

DOI: 10.18698/0236-3933-2016-4-33-48

ENTERPRISE DATA WAREHOUSE DESIGN METHOD USING SAP NET

WEAVER BUSINESS WAREHOUSE

S.A. Tonoyan

tonoyansl@mail.ru

V.A. Vysochanskiy

Bauman Moscow State Technical University, Moscow, Russian Federation

Abstract

Keyword

Data warehouse is an informational system optimized to store

large amounts of data and create analytical reports for decision

support. Principles of classic data warehouse architecture

cannot be applied for enterprise data warehouses (EDW) based

on key performance indicators (KPI). In this article we offer a

methodology that takes into account the KPI, we review and

justify the enterprise data warehouse design technique using

SAP NetWeaver Business Warehouse. Our step by step guide

to data warehouse design features SAP LSA (Layered Scalable

Architecture) standard. It consists of 7 layers, each serving the

particular purpose of EDW functionality. LSA is flexible; it can

be easily modified to fit various kinds of business processes.

We provide a practical example of an EDW design for customs

department of an oil and gas company

Data warehouse, SAP, multidi-

mensional data model, star-

schema, OLAP, OLTP, info-

cube, aggregation, LSA

REFERENCES

[1] Baldin A.V., Tonoyan S.A., Eliseev D.V. Analysis of temporal data storage redundancy by

means of RDBMS.

Jelektr. nauchno-tekh. izd. “Inzhenernyy zhurnal: nauka i innovacii”

[El.

Sc.-Tech. Publ. “Eng. J.: Science and Innovation”], 2014, iss. 4.

DOI: 10.18698/2308-6033-2014-4-1273 Available at:

http://engjournal.ru/eng/catalog/it/

hidden/1273.html

[2] Tonoyan S.A., Saraev D.V. Temporal database models and their properties.

Jelektr. nauch-

no-tekh. izd. “Inzhenernyy zhurnal: nauka i innovacii”

[El. Sc.-Tech. Publ. “Eng. J.: Science and

Innovation”], 2014, iss. 12. DOI: 10.18698/2308-6033-2014-12-1333

Available at:

http://engjournal.ru/eng/catalog/it/hidden/1333.html

[3] Haupt Juergen. LSA. SAP NetWeaver, RIG BI EMEA, 2009. 43 p.

[4] Ballard C., Herreman D., Schau D., Bell R., Kim E., Valencic A. Data modeling technigues

for data warehousing. International Technical Support Organization, IBM, 1998. 216 p.

[5] Baldin A.V., Tonoyan S.A., Eliseev D.V. Query language to mivar representation of rela-

tional databases, containing information archive from previous human resources systems.

Jelektr. nauchno-tekh. izd. “Inzhenernyy zhurnal: nauka i innovacii”

[El. Sc.-Tech. Publ. “Eng.