, Attributes (. 6).
Attributes. New, Rename Delete , .
, Attribute name, ' - Column name.
Primary key , , , Datatype - .
. 6. ij
3.5. '.
' ' [], - , - .
' [] ' []. ' , .
: 㳺 , , ' 5-8 IDEF1X CASE-㳿 .
. 7 .
. 7.
3.6. .
Table Properties /.
, .
3.6.1. Dimensional (. 8).
' ERwin , ., ( , ) (. .4).
Calculate Automatically.
(Dimension table), ', , , , .
. 8.
, . ERwin ( Slowly Changing):
1 - , .
2 - . , .
|
|
|
3 - . . , - .
3. 6.2.
Data Movement (. 9), ( ) :
( Refresh ), ( Append ), ( Backup ),
( Recovery ), ( Archiving ), ( Purge ).
. 9. ³
, ' (Rule name), (), Definition, Attachment (.10) , ' .
. 10. ij
ERwin :
- ;
- , , , , .
3. 7.1.
Data Warehouse Sourses, Model/Data Sources (. 11).
, , :
Ø General: ' , , , ;
Ø Detail: - , , ;
Ø Definition: .
. 11. ij
Data Source (. 12) ( Model/Colums),
, Data Source, : [], Select
3. 7.2.
Transform Comment : , , , , .
. 12. ( )
3.8.
, Took/Report Builder, , : , .
Ø Report template (.13),
|
|
|
. 13. ³
New , (Output type): HTML, RTF, TXT.
: Report template builder (. 14) [] :
Ø ;
Ø ;
Ø ;
Ø ;
Ø ;
Ø ;
Ø ;
Ø .
. ' ϲ , .
. 14. ³ Report template builder
(Available sections) [>] .
[X].
: (Report Layout) (Property Tree) , .
Report Template Builder Physical ' Table .
Table Filter (. 15), Data Warehouse Rule Column/Data Warehouse Source.
, Section, .
[|].
. 15. ij
3.9.
1. .
2. .
3. () .
4. .
5. .
6. .
7. .
8. .
9. .
10. , .
4
: CASE- ERwin AllFussion Modeling Suite " ".
: " " CASE- ERwin AllFussion Modeling Suite.
:
ERwin OLAP , 2 , :
Ø ;
Ø ;
Ø ;
Ø ;
Ø ';
Ø ( Dimensional, );
Ø ( , );
Ø .
ճ :
1. .
2. MS Word, :
|
|
|
Ø ; , ;
Ø ;
Ø OLAP ;
Ø ERwin File/Print Setup File/Print (' , ϲ );
Ø ( .8 ).
Ø .
5. ˳
1. . Oracle Express OLAP. , , . .: _, 2000 -320.
2. . . : . / . . , . . , . . , . . , . . . 3- ., . .- .: -, 2009. 512 .: .
3. ., . ., ., . Microsoft SQL Server 2005 Analysis Services. OLAP . BHV, 2007.
4. . . AllFusion Modeling Suite. - 2- ., . . - .: -, 2007 -400 .
5. , SQL, . .- , 2003.-644 .
6. . ., . . -: : . . 2- ., -. . - .: , 2013. - 704 .
7. .. , , 2013.-416 .
8. . . MS SQL Server Analysis Services 2008 . MSDN Library http://msdn.microsoft.com
9. . , , , , . SQL Server 2008: . Apress, 2009.
10. .. : . . .: , 2004. -348.
11. .., .. : .-. . .... .: , 2005. -264.
12. . . , . .1. , 2001, 400 ., .
7.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17. Curricula Recommendations [ ]. - URL:
http://www.acm.org/education/education/curricula-recommendations
( 04.02.2013).
18. 003:2010
19. .., .., .. . . [ ]. -URL:
https://testprovidercontent.blob.core.windows.net/documents/standarts.pdf
20. ( SWEBOK) [ ]. - URL: http://swebok.sorlik.ru/software_engineering.html ( 04.02.2013).
21. . .: - , http://2005.it-edu.ru/docs/1/1-08. Morozova.doc, - " 㳿 - ", , 19-22.09.2005, http://2005.it-edu.ru/docs
22. - . [ ]. -URL:
http://repetitor.org.ua/vedushhie-ukrainskie-it-kompanii-razrabotali-professionalnyie-standartyi-chtobyi-v-vuzah-uchili-realno-vostrebovannyim-navyikam ( 14.01.2016).
