Service change frequency based data warehouse modeling method and device
The invention provides a service change frequency based data warehouse modeling method and device. The method includes the steps: 102, setting service change frequency ranges; 104, analyzing service change frequency of each attribute of a service database source data table according to the service c...
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Patent |
| Sprache: | eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| Zusammenfassung: | The invention provides a service change frequency based data warehouse modeling method and device. The method includes the steps: 102, setting service change frequency ranges; 104, analyzing service change frequency of each attribute of a service database source data table according to the service change frequency ranges; 106, setting the number of database tables according to the number of the service change frequency ranges of the service change frequency; 108, adding Hash fields to each database table so as to judge whether the database table is changed or not; S110, establishing corresponding data warehouse models according to all the database tables. Through the method and device, data history integrity is guaranteed, data redundancy or change frequency can be reduced effectively, influence on a whole data warehouse due to changes of the service data can be shielded effectively, data extraction performance is improved, and further stability of the data warehouse is guaranteed. |
|---|