Method and system for parsing navigation information

A computer-readable medium containing instructions for controlling a computer system to parse information before updating data in a main database, the main database having fact tables and dimension tables, by a method comprising:

• creating fact tables and dimension tables corresponding to fact tables and dimension tables of the main database;
• identifying from the information entries for the created fact tables and dimension tables;
• storing the identified entries in the created fact tables and dimension tables;
• analyzing the entries stored in the created fact tables and dimension tables;
• and
• after analyzing the entries, transferring information from the created fact table and dimension table to the corresponding fact table and dimension table of the main database.

A parser for processing data before updating a database based on the processed data, the database having a main fact table and a main dimension table with a main dimension identifier for each entry in the main dimension table, comprising:

• a component that creates a local fact table and a local dimension table corresponding to the main fact table and the main dimension table;
• a component that adds an entry to the local dimension table with a generated local dimension identifier, the added entry corresponding to an entry to be added to the main dimension table;
• a component that adds an entry to the local fact table that references an entry in the local dimension table using the generated local dimension identifier;
• a component that analyzes the entries of the local fact table and the local dimension table;
• and
• a component that, after entries of the local fact table and the local dimension table are analyzed, transfers information from the local fact table and the local dimension table to the main fact table and the main dimension table of the database.

A computer system for processing data to be stored in a database having a main fact table and a main dimension table, comprising:

• means for creating a local fact table and a local dimension table corresponding to the main fact table and the main dimension table;
• means for adding entries to the local dimension table with a local dimension identifier for an entry derived from the data to be stored in the main dimension table;
• means for adding an entry derived from the data to the local fact table, the added entry referencing an entry in the local dimension table using the local dimension identifier;
• and
• means for, after adding entries to the local fact table and the local dimension table, transferring information from the local fact table and the local dimension table to the main fact table and the main dimension table of the database.