Abstract:

Through realtime monitoring police system log, the detail data of operational data store ODS are realtime elicited from system log to ODS, meanwhile this mechanism synchronizes the ODS data and business system database in second grade. Realtime ODS based mechanism establishes a LogODSDW threelevel model Police DW system, realtime OLAP based query, the cubes of ODS and DW fresh data dynamically, serving realtime OLAP service. The authors put forward a dynamic DW infrastructure which can offer realtime police decision analysis with the features of little burthen on business system, real time, rapid query and meet a need of police system.

Key words:  operational data store (ODS), data warehouse (DW), online analytical process (OLAP), data mart