Method and system for parsing navigation information
First Claim
1. A method of processing data before updating a database based on the processed data, the database having a main table with a main identifier for each entry in the main table, the method comprising:
- identifying an entry that should be in the main table;
generating a local identifier for the entry;
adding the entry with the local identifier to a local table;
generating information to be stored in the database that references the entry in the local table using the local identifier; and
after generating the information, generating a main identifier for the entry;
adding an entry with the main identifier to the main table; and
storing the generated information in the database with the local identifier replaced with the main identifier.
3 Assignments
0 Petitions
Accused Products
Abstract
A method and system for providing customers with access to and analysis of the navigation data collected at customer web sites is provided. In one embodiment, a data warehouse system collects customer data from the customer web sites and stores the data at a data warehouse server. The customer data may include navigation data (e.g., click stream log files), user attribute data of users of the customer web site (e.g., name, age, and gender), product data (e.g., catalog of products offered for sale by the customer), shopping call data (i.e., identification of the products currently in a user'"'"'s shopping call), and so on. 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. For example, the data warehouse server may analyze low-level navigation events (e.g., each HTTP request that is received by the customer web site) to identify high-level events (e.g., a user session). The data warehouse server then stores the converted data into a data warehouse.
6 Citations
49 Claims
-
1. A method of processing data before updating a database based on the processed data, the database having a main table with a main identifier for each entry in the main table, the method comprising:
-
identifying an entry that should be in the main table;
generating a local identifier for the entry;
adding the entry with the local identifier to a local table;
generating information to be stored in the database that references the entry in the local table using the local identifier; and
after generating the information, generating a main identifier for the entry;
adding an entry with the main identifier to the main table; and
storing the generated information in the database with the local identifier replaced with the main identifier. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A method in a computer system for parsing information before updating data in a main database, the main database having fact tables and dimension tables, the method comprising:
-
creating a fact table and a dimension table corresponding to a fact table and dimension table of the main database;
identifying from the information entries for the created fact table and dimension table;
storing the identified entries in the created fact table and dimension table; and
analyzing the entries stored in the created fact table and dimension table. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17)
-
-
18. A method in a computer system for identifying navigation paths through web pages based on user navigation information, the method comprising:
-
analyzing the user navigation information to identify entries associated with the same user; and
for each user, identifying the web pages that are accessed by the user; and
storing an indication of the identified web pages as a navigation path in a persistent database. - View Dependent Claims (19, 20)
-
-
21. A method in a computer for processing navigation information for web pages, the method comprising:
-
selecting an entry of the navigation information;
identifying a uniform resource identifier of the selected entry; and
when the identified uniform resource identifier satisfies a match criterion, storing in a persistent database an indication that the entry matches the criterion. - View Dependent Claims (22, 23, 24)
-
-
25. A method in a computer system for identifying a user who accesses a web page, the method comprising:
-
providing an indication of a request for a second web page, the request including second information identifying a user who requested the second web page and first information identifying a user who requested a first web page that included a reference to the second web page; and
indicating the first information and the second information identify the same user. - View Dependent Claims (26, 27, 28, 29)
-
-
30. A method in a computer system for identifying high-level events from low-level events, the method comprising:
-
providing a plurality of event definitions that map low-level events to high-level events; and
for each low-level event, determining whether the low-level event matches a provided event definition; and
when a low-level event matches an event definition, persistently storing an indication of the high-level event associated with the matching event definition. - View Dependent Claims (31, 32, 33)
-
-
34. A method in a computer system for processing click steam data, the method comprising:
-
receiving time synchronization information for the click stream data;
adjusting times associated with the click stream data based on the received time synchronization information; and
persistently storing the adjusted times. - View Dependent Claims (35, 36, 37)
-
-
38. 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; and
analyzing the entries stored in the created fact tables and dimension tables. - View Dependent Claims (39, 40, 41, 42, 43, 44, 45)
-
-
46. A method in a computer system for processing of search strings, the method comprising:
-
identifying a search sting in a log file;
identifying a canonical form of the search string; and
storing the identified canonical from so that subsequent processing of the search string uses the canonical form. - View Dependent Claims (47, 48, 49)
-
Specification