Andoza:Data warehouses: Versiyalar orasidagi farq
Qiyofa
{{navbox with collapsible groups | |||
| name = Data warehouses | |||
| title = [[Data warehouse]]s | |||
| state = {{{state<includeonly>|autocollapse</includeonly>}}} | |||
| bodyclass = hlist | |||
| selected = {{{1|}}} | |||
{{ | | group1 = Creating a data warehouse | ||
| list1 = {{Navbox|child| groupwidth = | |||
| group1 = Concepts | |||
| list1 = | |||
*[[Database]] | |||
*[[Dimension (data warehouse)|Dimension]] | |||
*[[Dimensional modeling]] | |||
*[[Fact (data warehouse)|Fact]] | |||
*[[Online analytical processing|OLAP]] | |||
*[[Star schema]] | |||
*[[Snowflake schema]] | |||
*[[Reverse star schema]] | |||
*[[Aggregate (data warehouse)|Aggregate]] | |||
*[[Single version of the truth]] | |||
| group2 = Variants | |||
| list2 = | |||
*[[Column-oriented DBMS]] | |||
*[[Data hub]] | |||
*[[Data mesh]] | |||
* Ensemble modeling patterns | |||
**[[Anchor modeling]] | |||
**[[Data vault modeling]] | |||
**[[Focal point modeling]] | |||
*[[HOLAP]] | |||
*[[MOLAP]] | |||
*[[ROLAP]] | |||
*[[Operational data store]] | |||
| group3 = Elements | |||
| list3 = | |||
*[[Data dictionary]]/[[Metadata]] | |||
*[[Data mart]] | |||
*[[Sixth normal form]] | |||
*[[Surrogate key]] | |||
| group4 = Fact | |||
| list4 = | |||
*[[Fact table]] | |||
*[[Early-arriving fact]] | |||
*[[Measure (data warehouse)|Measure]] | |||
| group5 = Dimension | |||
| list5 = | |||
*[[Dimension table]] | |||
*[[Degenerate dimension|Degenerate]] | |||
*[[Slowly changing dimension|Slowly changing]] | |||
| group6 = Filling | |||
| list6 = | |||
*[[Extract, transform, load|Extract, transform, load (ETL)]] | |||
*[[Extract, load, transform|Extract, load, transform (ELT)]] | |||
*[[Data extraction|Extract]] | |||
*[[Data transformation|Transform]] | |||
*[[Data loading|Load]] | |||
}} | |||
| group2 = Using a data warehouse | |||
| list2 = {{Navbox|child| groupwidth = | |||
| group1 = Concepts | |||
| list1 = | |||
*[[Business intelligence]] | |||
*[[Dashboard (business)|Dashboard]] | |||
*[[Data mining]] | |||
*[[Decision support system|Decision support system (DSS)]] | |||
*[[OLAP cube]] | |||
*[[Data warehouse automation]] | |||
| group2 = Languages | |||
| list2 = | |||
*[[Data Mining Extensions|Data Mining Extensions (DMX)]] | |||
*[[MultiDimensional eXpressions|MultiDimensional eXpressions (MDX)]] | |||
*[[XML for Analysis|XML for Analysis (XMLA)]] | |||
| group3 = Tools | |||
| list3 = | |||
*[[Business intelligence software]] | |||
*[[List of reporting software|Reporting software]] | |||
*[[Spreadsheets|Spreadsheet]] | |||
}} | |||
| group3 = Related | |||
| list3 = {{Navbox|child| groupwidth = | |||
| group1 = People | |||
| list1 = | |||
*[[Bill Inmon]] | |||
**[[Corporate information factory|Information factory]] | |||
*[[Ralph Kimball]] | |||
**[[Enterprise bus matrix|Enterprise bus]] | |||
*[[Dan Linstedt]] | |||
| group2 = Products | |||
| list2 = | |||
*[[Comparison of OLAP servers]] | |||
*[[:Category:Data warehousing products|Data warehousing products and their producers]] | |||
}} | |||
}}<noinclude> | |||
{{Documentation}} | |||
[[Category:Computing navigational boxes]] | |||
</noinclude> | |||
$2, $3 dagi (joriy) koʻrinishi
| Tajriba oʻtkazish uchun qumloq va test sahifasidan foydalaning. Iltimos, turkumlarni hujjat sahifasiga va intervikilarni vikimaʼlumotlarga joylashtiring. Ushbu andoza ostsahifalari. |