Хранилище данных, SAP, многомерная модель данных, витрина данных, схема–звезда, OLAP, OLTP, инфокуб Это необходимо для обеспечения перехода в отчеты детальных данных (drill-down).


Чтобы посмотреть этот PDF файл с форматированием и разметкой, скачайте его и откройте на своем компьютере.
ISSN 0236-3933.   . ..  . . . 2016.  4 33
[email protected] 10.1;69;J0236-3933-2016-4-33-4;
$)  ) # 7  ) # / 9 3 j
.. 8 .. /
34 ISSN 0236-3933.   . ..  . . . 2016.  4
X&[. &  # $  $''8 $,( $
$ )+ (8  '8 $ -
 �'  $ ( ' X:?[8 ',( "-
/ /8  $' $# ', OLAP-.
:$ ( ' $' /   
 " " # $8   $"# '
$'$     :.
 $$   $"  ' ' -
#+ ( ' $ $'$/    SAP BW. 
'/ 8 $'" /  $/ SAP    -
8 ( " $, $+$ $  (
'8   $#, $ $ :?  #
:.  # 8 # '   '8 ,(/ $-
+) :?  # = SAP BW $ $ ( '.
 '&  !&!  (   J +(   SAP B|.
� -
/ / ," ( '   ' -
/      OLAP8 "' #  '  -
" " #. ?     +$+ " /
' # '8 $#,(/ 
, ' $# -
+/ # '  / $,  #+8  #'/-
  OLTP- 8    #+/  
  \28 3]. )  SAP BW $' / !/  -
  OLAP8    = ' $ OLAP- X-
)   " SAP[.
# =' OLTP-  OLAP-   #  ' ETL-$+
XExtract8 Transform8 Load #
8 $#8 #"#[8  -
 #=  $#  . 1.
' $ $
" ( '
ISSN 0236-3933.   . ..  . . . 2016.  4 35
%/ +/ )  + )8  / -
=,  8 #  ' '/!" # \4]. %'8
 ' $ ," )   $ 8  '-
)+,( '/ )8    #/8 #,(
".  SAP BW $  ) '=  + # /8  
 #, $#   ' $'  -
+ ) \5].  # 8 # $#  /
 + # , $/ # /.
 " OLAP-8  #   /##'/8
$'  . 2.
: "  ' OLAP-
 SAP BW $# !  ##'8  -
  /    8  # $   
+ # /.  SAP-  '
='" $ " 
# / "/ , XSID[8 / #  , $ 
+ # .  # 8  ) " # 
$# '   = $  + # / \2]. *!
 ##'8 $#   SAP BW8 $'  . 3.
:    8  OLAP- $ # ' #-
$  "' ' #+ \4]. %'  8 #  '-
 $$,  ( X..  )[   $ $ -
!  $+$ @  $ 8 ERP-  #,  +-
 # '  /  / ) .  #8  =' -
( '  '/  / '= ( $ =/
8 $#,(/ ) +, # $  "" \4].
%  ' ' ,
" (8    
8  OLTP- 8    / $"  $'
SAP $' $) / RJ3. ? #' $ ' =' -
.. 8 .. /
36 ISSN 0236-3933.   . ..  . . . 2016.  4
*!  ##' SAP BW
' $ $
" ( '
ISSN 0236-3933.   . ..  . . . 2016.  4 37
1. Y# ' # + OLTP-   $ (,  #-
   +8 ,( $+   (-
,( + # '.
2. # # ' $' ' $-
+/ X$'  '"/ ) [  $" 8 $   �-
- # ABAP.
3. "#  ( '.
) "  &  & " H 9.
:$ ( '8
   "8 '= '= ' #/ $ ""-
.  #8  '   = #$8 # # '/ -
8   :?   @
[ # $'  '# ) +_
[ $ = $' ' "" $ 
$# 8 $ @    #    
$  8 . . , $# / 8   $-
# _
[  $' ' '   (-
 '8    " $,', #  .
%,' '8  ' $ :? ' $# -
  )8  =' #  # OLAP-8   $-
'   $#  '   '  '#+.
',(  :?  , $#/ &))-
.    $#/ " ( '8 $,-
( $# '/   X 8 � 8 8 '8 $-
  . $.[8 :   =,  #. %'8 
+$+ : $'#  =,     # '
X"' '  '" : , ' # # # -
 [8  $' ,  ( .
: $8 :? ', ' $ $'$'-
8 =,( $' # &))   '
$'$/. %,' '8  ' :? #'   '-
 ! ( ' ' (8 ) ,(
:    / ' \48 5].  # '  
# / "+   #  $ ( :.
%#  $ #/   
X[ ' =  :?  " ( \68 7]. :
$8  ='/  ' #' / OLAP-8  /
$',  "" #$ X'  ! �   /
) +[ $ #  $
' .     )-
8 /  ' $# ' $ OLAP- " -
/ +,    '8   $$
= $# ' 8 $ 8 $"# #/ \2].
.. 8 .. /
3; ISSN 0236-3933.   . ..  . . . 2016.  4
 # 8 ' #+ :?  "# / $'-
'8 ,(/ "   $'$",(/ " $# 
  $" $'$.
  &  +(+" &  & " H 9.
( '
  8 $#,( " OLAP8 =  # $'-
 '" # ',( $+$8 ,( $ $'
(   OLAP-   +ROLAP/
'   +/
# '8   + )  # / OLAP-. ? "#+
"" '  #' ' +.
'   OLAP-   +MOLAP
[ ) + '= $-
'  $' "   XOLAP-[  ' #-
/ $#/8 =  )"  # -
/. :     MOLAP , ' ##'  =.
#  7  OLAP-   +HOLAP/
 "/ ROLAP 
MOLAP8  ' '   +/ # '8 
"" ' '   "  .
' ' $   ( ' X?[ &
 8 & ,(  ( '  '   (,-
(, OLTP-    '"   '  $'/
Xview[.  ( ?  # = )  -
/  # "#+     $+ $-
# '  / ) .   8  ' '
?   "#  OLTP-  $  $#'-
/ X$ ,     OLAP-  [  / -
 #$8  = # =     ' .
)  SAP BW $# #' ( ' $ $+$
"' OLAP- .  (     $ $-
 ( ' = '  ($# $'-
'8 $       +.  (  ,
$'' #  #.
  '/ )+ ', ',( $''  $-
, :?.
@Q7      7  4    7 
XFederated Data
WarehouseJFederated Data Mart[ & $''8 /  ' #
8   $'$",(/ $ ( '  $'$-
.    FDWJFDM  $'$ $#,  -
 ( '8  # =' / 
(  $@   '8 � -
 ' XDSO    SAP BW[  .
'. ?/ $'' $# $-
 $, #8 $,(, $ '8
 $='  =, ) +, ' $'$.
' $ $
" ( '
ISSN 0236-3933.   . ..  . . . 2016.  4 39
*     7 
$'#  $# $+-
$ $'' #8 .
. #' ' ( ' -
 ""  ' ' ' $ /
  =' $'#'. /  $' -
  '8   #"=, #$ '   $ (,
ETL-$+.    # $' +#-
 ( '8 ( # '"   OLAP-8
#    ' #   � $ ="
.  # 8    $#/ ) -
,   '"  '. "' ', $-
+$ #  ' $'' # "  '-
 '  '  #-$ 8 '  $'-
  "' # ' '  $#/.
!    
' =   #' $'-
' #8  $ &  ' :?8 (" #
' / $ $''= $/ ' $'#'/
 $.  '   $, ' -
(8 '8 $ /   '8  =,
  ' $'$
 $+#  '-
 ' .  &  ' '  $-$=  
' ( '8  " +  $
) +.  &  ', $ $#/8 
# #   '
. '8 $+$
 '/   '/ #,,   8  $-
, # = "/ / /  $'#'-
/8  = $' "#    ='   '8 
  # = #-# (  #$  '  .
+(+ SAP LSA &  & " H 9.
" !-
  SAP Layered Scalable Architecture XLSA[ & ' $-
 " ! 
( '8 #/
 $/ SAP ' $   :? \38 9].    # $'' SAP
Enterprise Data Warehouse XEDW $ ( '[8 '-
 " $ !   # $#' $
 " $ '.
:$ ( '8 $ $ $+$ LSA8 -
 #   / X[8 $'  . 5. '  8  
LSA  $#, �  Operational Data Store XODS[
+ # '8 �',( ,
 $  $
 $'# ' $ ="  '.
1.   ' XDAL Data Acquisition Layer[8    -
 ( '8 $# ' $' ) + #  
.
.. 8 .. /
40 ISSN 0236-3933.   . ..  . . . 2016.  4
2.    " #+ ' XHL uality }
Harmonization Layer[  #  =   8 "'
 $' '  $'  ) @ $ 8  '-
 $$, # #'  8    $#  (-
 '.
3.  $/ $  XCML Corporate Memory Layer[ -
 ' #" $  . ?  & 
  ! ' .
4.  $ ' XDPL Data Propagation Layer[ -
$# '  " #' #$/.
5.  #-) + ' XBTL Business Transformation
Layer[ = ' #+ #-"  $ (, ) +/ '-
 =' �  .
6.     ' XFRL Flexible Reporting Layer_
DRL Data mart Reporting Layer[ $'# '  '#-
 " #' '  )  � .
7.  #+ XVRL Virtualization Reporting Layer[ '=
$/' 8 �',(  )  �-
   '/  ) +.
  SAP LSA
  $'/ "//  ( $# -
$ $     $, :?  '-
  #  '#+.  "8   $'-
 # / $# # = $#
$#/ '   ' ' :. Y$# -
 ' =  # =  SAP LSA8   #
$( $+  "+.  #   8  =' 
 $ '/  / = '"8 $    ''
$#/.
' $ $
" ( '
ISSN 0236-3933.   . ..  . . . 2016.  4 41
? " )  +$+ SAP LSA = $'
#  ' @ FRL  DRL. ?   8     -
    '#
' XFRL[8 $'  '
  # . %  ! =   8  -
 $'  8  /  $ 
#$/  !  \18 ;].  $   ' $'-
  /  "" '   DRL.
)  SAP BW $'  #' $+# )-
 "  8 $   ' = @ #"# '
# $''("  X#"#[  '  #$/ #  X$-
[ \98 10]. *= #"#8 )8 $ )+ -
" )8  = $ $'# ' '  )
$ $#/   $"# $#/   (-
,( '.  $'' LSA  '/ # =   VRL8  
 $# )  '  #   $"# :
  # $/' \68 118 12].
$+ &  & "  9  "  +(+ SAP LSA.
?
$!/ #+ :?8    $+$  $'' SAP LSA8
'  $'= ',( !"8 $    ' #'
'  '8   ' ( '  $'$
X. 6[.
1. %$' $ , $#/ &))8 
"      $ '  . ?/ &$
$'$" $' ' 8 $ &  = -
 $   # "  #-$+ .
2. *#+   '
 XDAL[ $ #' 
'  ' &. % " # $ & ) -
   ERP- 8     SAP BW # $  $-
# $/ + SAP RJ3  )-�.
3. #' )-�    SAP BW    $/
+/   /    $" !.
! $#  $# "
,  " 
' #' � .
4. #' /   $/ $   ' DSO  $-
#+/ #$.  DSO '= '= )-�8 ,(
 $ &8  $#  ' '  -
!/ $ '#+.
5. #' '/ DSO   #+   )-
�8     #-, ,(/ "$$
$#/.  & &$ $' #'  $ ' $ ,
( $#  :. $ 8 #
(" "  ' ERP-
  " )  # "$$ $#/@ ' #  -
=, �  $' 8  '"   $'=.
.. 8 .. /
42 ISSN 0236-3933.   . ..  . . . 2016.  4
 :?
' $ $
" ( '
ISSN 0236-3933.   . ..  . . . 2016.  4 43
6. ? $ # '" $#/  ' $' 
:  ) + $' ' DSO  $'.
  !"  $#/   #-) + -
 #  ' DSO X$ '   =', "$$ $#/[.
 ) + $' &  DSO ' #  '  8 -
#  )  : &    8 "' $" 
& ' ' #+ "  $' $#.
7. *#+    '  $' @ '  ""-
 '. ? ' ' #', )8 $  
 # '=  "$$ $#/8 $' -
. * ' #' "$$ $#/  "  X $ 8
$ !, $#/     
   ERP- [.   
(  )   / #,   # .
 "" '  ' )8 '/ ) +-
     )  ' '.   ,   )-
�8  '  ' /  $'$.
;. #' $/' X [   -
#+ $ '   =', $, "$$ $#/ X . $. 7[8 
=' #    , ) ""  '
'.  '  ' $ $'   ' '
Xdrill-down[. ?$  (    #+.
  $# '/ '  #+ $-
" ( ' '  =" )  $'#'
)"#/  $.    $'= $''  $-
' ',( .
1. )  $$ , $#/ &))  -
  )  #-� $'$@  = $! #
#/ "#   = $! # # $' $-
. #' $ !  $' $ " 
#   ' $#/.
2.      $" !  OLTP-  SAP
RJ3 #' &  = '+8 �',(/ $ # 
+ # '@ ?8  )  '  #$. ? #-
 #$/ # + #' $"   # ABAPJ4.
3.  $# +  /8 $/  $
!8 #' $# X$
[  $#    SAP BW.
4. #' DSO  $ #+/ #$    #8
# "   #$/ '/    ) 
(.
5.  #+ $' ' DSO   $-
#  $#/ '/  8 '  '  :.
  #' ' '   '8  #,
$    )  , $#/.
.. 8 .. /
44 ISSN 0236-3933.   . ..  . . . 2016.  4
6.   #$/8 $!'! # ) #-"8 $
  : # (  ' DSO  $'.
7.    (   #+. OLAP- Drill
Down '= ' ' $ :8 . .   !/  #-
/ $ ,  OLAP- "" '.
;. #' $/'8 $/   OLAP-. ? )-
 #$ $'#  ""+8 ='/ '= -
  $#  $#8  '  '  .
 #  #' :?8  "8 $'
 . 68 $,  $+$ +$+ LSA.
  $  $' '" ' OLAP- Drill
Down  . 7.
#' :? = $    " (8
  /    $" ?    ' & #-
= #  )+ $ ' #    -
 X = '+8  )8 ) '  
, '"[8 #  )  / ( , '-
. '8 # $( $+ '  ,-
 $#/ X   (,( $[    '.
 "8  # =  : #  $  '
OLAP- "" '.
 # 8 $' ' $ :? = 
$!  $ #  ' SAP BW8 $ & $ 
&$ "  # /  ($/
$ SAP LSA.
#"+.
" $ $'$8 $#,(  $= -
  ERP-  SAP RJ38  ', :?  # SAP BW '
&))/ $''= $ " !/ $  
!    $  '.   8  "' '
'=   $,  :?  ' $'-
$ /  ( '8 , $( #-
   '.
'= $''8 $#,(/ #' :? , !  =-
8 $ &  $#   # = "+
 '"    .
 (   $! $# '" SAP LSA '
$ :? '#8  ( '  '-
/ $''. %' ='/ '/ $ :?  ' # -
 ''/    LSA8 ,(/ 
#-$+ " $'$.
'= '   ' '. -$8 $ #-
   ' #-#  '   = :8 $'-
  OLAP- #/ '#+. -8 $  
' $ $
" ( '
ISSN 0236-3933.   . ..  . . . 2016.  4 45
?" ' OLAP- Drill Down
.. , \b.. \b\t\n \f\n\r
ISSN 0236-3933. \b\n\r  . .. \f\f\f. . \n. 2016.  4
\n \r \f\t! ! \n!
"\f# $#\t %\r \f 
 \n.  \n$\t \n\f\r \n\n\t \n &'(  \n$$\t
\n\r \f))\f* \f\t! \f \f"
\t! ! \f! $ \n% 
%\f) \f\f$"\f \f\t!, +\f# \f\f$ \n\r  \t.
\b
 \b.\t., \n  \f \r.\b.,  .\t.
\f$" "\t \n !\f %\f$#\t!
\f\t! \n\n\f $*\t! ( // 5
7\t 7\f$: \f
\r\f  \f*.
2014.  4. DOI: 10.18698/2308-6033-2014-4-12;3 URL: http://engjournal.ru/catalog/it/
\n  \f \r.\b., \r .\t.
%\f$#\t $ \f"\t \f\t!  ! \n\n\f // 57-
\t 7\f$: \f\r\f  \f*. 2014.  12. DOI: 10.18698/2308-6033-2014-12-1333
URL: http://engjournal.ru
/catalog/it/hidden/1333.html
)\f \f\n\f\f \f
\t\n \r \r\n\t
„ \n \r\f+\t «\n\t \f\r -
+\f*  %\f$»  . ..
\f\f\f =H\n\n\n\r\f X\f*, 10K00K,
\n\r\f, 2- \f\f\n\r\f �$., . K.
\b\t \n \b \f\t\r \b \n
 \t\f\r  \t\r\t \t\r\rƒ
ISSN 0236-3933. \r\b  . .. \t\t\r\t.  .  !  \r. 2016. " 4
\b \t\n\b \f \r\b    \b  \n \b:
\r\r .#., $\t\r\b% .#. \b\t
\n \b \f\t\r \b \n
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
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/
[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
2014, iss. 12. DOI: 10.18698/2308-6033-2014-12-1333
ng/catalog/it/hidden/1333.html
.. 8 .. /
4; ISSN 0236-3933.   . ..  . . . 2016.  4
20138 iss. 11. [email protected] 10.1;69;J230;-6033-2013-11-1053 Available
[email protected] [email protected]
\6] Patel B.8 Palekar A.8 Shiralkar Sh. SAP Net Weaver Business Warehouse XBW[ 7. [email protected]
Galileo Press8 200;. 6;9 p.
\7] Paklin N.B.8 Oreshkov V.I. Biznes [email protected] ot dannykh k znaniyam \Business intelligence
From data to knowledge]. St. Petersburg8 Piter Publ.8 2013. 704 p.
\;] Barsegyan A.A. Analiz dannykh i protse
ssov \Analysis of data and processes].

Приложенные файлы

  • pdf 4632931
    Размер файла: 778 kB Загрузок: 0

Добавить комментарий