Backup | Data 1: Data Warehouse schema Backup
Including the database architecture and OLAP architecture;
The database includes a dimension table, fact table, and other temporary or control class tables whose structure is generated by generating SQL scripts.
Note: Its primary key, index and so on are to be generated;
The OLAP schema is saved by default in the "C:\Program Files\Microsoft Analysis Services\bin\msmdqlog.mdb" data
Library, you can back it up;
It is highly recommended that you migrate its knowledge base and save it in SQL Server, which can improve efficiency. It is not recommended to keep it in msdb, it is recommended to establish specialized knowledge
Library save, also facilitate backup;
2: Data Warehouse architecture and data backup
In ROLAP, HOLAP, MOLAP and other three ways to backup the content is different!
In 3 ways the dimension tables in the database are backed up, and in MOLAP, the fact table is not backed up; The ROLAP method also includes the build
of the cluster table;
Use a backup of the database or export the data in DTS;
OLAP backup uses the Analysis Services database archiving feature!
It includes both the architecture of the Data warehouse and the aggregation data!
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
