Method and system for parsing navigation information

• US 6,873,981 B2
• Filed: 12/16/2002
• Issued: 03/29/2005
• Est. Priority Date: 07/11/2000
• Status: Expired due to Term

• Current Assignee: Revenue Science
• Original Assignee: Revenue Science
• Inventors: Nareddy, Krishnamohan, Uppala, Radha Krishna
• Primary Examiner(s): Le, Uyen
• Assistant Examiner(s): THAI, HANH B
• Application Number:
  US10/320,092
• Publication Number:
  US 20030144988A1
• Time in Patent Office: 834 Days
• Field of Search: 707 3- 6, 707/200, 709/200, 709/202
• US Class Current: 707/769
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99937 Sorting
• CPC Class Codes: Y10S 707/99954 Version management

Abstract

A method and system for providing customers with access to and analysis of event data is provided. The event data may be stored in log files and supplemented with data from other sources, such as product databases and customer invoices. A data warehouse system collects customer data from the customer web sites and stores the data at a data warehouse server. The data warehouse server interacts with the customer servers to collect to the customer data on a periodic basis. The data warehouse server may provide instructions to the customer servers identifying the customer data that is to be uploaded to the data warehouse server. When the data warehouse server receives customer data, it converts the customer data into a format that is more conducive to processing by decision support system applications by which customers can analyze their data.

Claims

1. A method in a computer system for providing information relating to entries of log files, the method comprising:

receiving a plurality of log files;

for each entry of each log file,

determining whether the entry contains a query; and

when it is determined that the entry contains a query,

normalizing the query; and

storing the normalized query in a database in association with other information of the entry;

receiving from a user a request for information based on analysis of the log files;

identifying information responsive to the received request based on the normalized queries stored in the database; and

sending the identified information to the user.

2. The method of claim 1 including:

identifying entries of the log files that represent requests for web pages;

identifying a user associated with each identified entry; and

for each identified user, selecting the identified entries associated with the identified user as a navigation path of web pages for the identified user.

3. The method of claim 2 wherein the identified information responsive to the received request is further based on a navigation path of the identified user.

4. The method of claim 1 wherein the database is a main database and wherein the storing of the normalized query in the main database includes:

providing a fact table and a dimension table corresponding to a fact table and a dimension table of the main database;

storing the normalized queries in the provided fact table with a reference to the provided dimension table;

analyzing the normalized queries stored in the provided fact table; and

after analyzing the normalized queries, transferring the normalized queries to the fact table of the main database with a reference to the dimension table of the main database.

5. The method of claim 1 wherein a query has an associated time and including:

sending to servers that provide log files a request for the current time of that server;

receiving from each server the current time of that server; and

storing a time associated with each normalized query based on differences in times between the servers.

6. The method of claim 1 wherein determining whether the entry contains a query includes:

providing customer-specific event definitions for a customer; and

determining from the customer-specific event definitions when an entry contains a query.

7. A computer-readable medium containing instructions for controlling a computer system to provide information relating to entries of log files, by a method comprising:

for each entry of each log file,

determining whether the entry contains a query; and

when it is determined that the entry contains a query,

normalizing the query; and

storing the normalized query in a database in association with other information of the entry;

generating information based on the normalized queries stored in the database; and

providing the generated information to a user.

8. The computer-readable medium of claim 7 wherein the database is a main database and wherein the storing of the normalized query in the main database includes:

providing a fact table and a dimension table corresponding to a fact table and a dimension table of the main database;

storing the normalized queries in the provided fact table with a reference to the provided dimension table;

analyzing the normalized queries stored in the provided fact table; and

after analyzing the normalized queries, transferring the normalized queries to the fact table of the main database with a reference to the dimension table of the main database.

9. The computer-readable medium of claim 7 wherein a query has an associated time and including:

sending to servers that provide log files a request for the current time of that server;

receiving from each server the current time of that server; and

storing a time associated with each normalized query based on differences in times between the servers.

10. The computer-readable medium of claim 7 wherein determining whether the entry contains a query includes:

providing customer-specific event definitions for a customer; and

determining from the customer-specific event definitions when an entry contains a query.

11. The computer-readable medium of claim 7 including:

identifying entries of the log files that represent requests for web pages;

identifying a user associated with each identified entry; and

for each identified user, selecting the identified entries associated with the identified user as a navigation path of web pages for the identified user.

12. The computer-readable medium of claim 11 wherein the identified information responsive to the received request is further based on a navigation path of the identified user.