This database is very unstable, but there is no point to make an analysis.
1. Connect the database through the Java to do data access;
2. Record each access time by log4j;
3. Import the logging into the database by SQL Server DTS to prepare the analysis;
4. Due to the size of the data, the analysis is also made on your own SQL Server, so I don't use Analysis Service;
5. Use the Excel PivotTable to access SQL Server to create a CUBE analysis file;
6. Define the analysis structure to obtain the analysis icon, analysis, and write analysis conclusions.