US6785666B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and system for parsing navigation information
Assignee: Revenue Science Inc
•
Filing: 2000-07-11
•
Granted: 2004-08-31
•
Expires: 2020-07-11
Abstract
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.
Inventors
- 👤 Krishnamohan Nareddy
- 👤 Radha Krishna Uppala
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 01:38
CPC Classifications
G; G06; G06Q; G06Q30/00; G06Q30/02; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99936; Y10S707/99937; Y10S707/99951; Y10S707/99952; Y10S707/99954
Claims Analysis
Total Claims: 34
Claim 1
Independent Claim
112 words
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; analyzing the entries stored in the created fact table and dimension table; 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.
Claim 2
Independent Claim
112 words
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; analyzing the entries stored in the created fact table and dimension table; 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.
Claim 3
Dependent Claim
16 words
The method of claim 1 wherein the parsed information relates to user interactions with web pages.
Claim 4
Dependent Claim
24 words
The method of claim 1 including updating data in the main database based on the entries in the created fact table and dimension table.
Claim 5
Dependent Claim
18 words
The method of claim 1 wherein the created fact table and dimension table are stored in main memory.
Claim 6
Dependent Claim
17 words
The method of claim 1 wherein the created fact and dimension table are stored in non-persistent memory.
Claim 7
Dependent Claim
17 words
The method of claim 1 wherein the created fact and dimension table are stored in temporary memory.
Claim 8
Dependent Claim
30 words
The method of claim 1 wherein the created fact and dimension table are destroyed after information in the main database is updated based on the created fact and dimension table.
Claim 9
Dependent Claim
23 words
The method of claim 1 wherein the data in the main database is updated based on an ordering of fact and dimension tables.
Claim 10
Dependent Claim
114 words
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.
Claim 11
Dependent Claim
114 words
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.
Claim 12
Dependent Claim
17 words
The computer-readable medium of claim 9 wherein the parsed information relates to user interactions with web pages.
Claim 13
Dependent Claim
25 words
The computer-readable medium of claim 9 including updating data in the main database based on the entries in the created fact tables and dimension tables.
Claim 14
Dependent Claim
19 words
The computer-readable medium of claim 9 wherein the created fact tables and dimension tables are stored in main memory.
Claim 15
Dependent Claim
19 words
The computer-readable medium of claim 9 wherein the created fact tables and dimension tables are stored in non-persistent memory.
Claim 16
Dependent Claim
18 words
The computer-readable medium of claim 9 wherein the created fact and dimension tables are stored in temporary memory.
Claim 17
Dependent Claim
31 words
The computer-readable medium of claim 9 wherein the created fact and dimension tables are destroyed after information in the main database is updated based on the created fact and dimension tables.
Claim 18
Dependent Claim
24 words
The computer-readable medium of claim 9 wherein the data in the main database is updated based on an ordering of fact and dimension tables.
Claim 19
Dependent Claim
181 words
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.
Claim 20
Dependent Claim
181 words
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.
Claim 21
Dependent Claim
19 words
The parser of claim 17 wherein the local fact table and local dimension table are store in main memory.
Claim 22
Dependent Claim
37 words
The parser of claim 17 wherein the transferring of information includes generating a main dimension identifier for the main dimension table and replacing the local dimension identifier with the generated main dimension identifier in the transferred information.
Claim 23
Dependent Claim
29 words
The parser of claim 17 wherein the transferring of information includes adding an entry to the main dimension table corresponding to the entry added to the local dimension table.
Claim 24
Dependent Claim
23 words
The parser of claim 17 wherein the transferring includes identifying an existing main dimension identifier that corresponds to the generated local dimension identifier.
Claim 25
Dependent Claim
17 words
The parser of claim 17 wherein the processed data relates to navigation information of a web site.
Claim 26
Dependent Claim
14 words
The parser of claim 17 wherein the processed data relates to click stream data.
Claim 27
Dependent Claim
146 words
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.
Claim 28
Dependent Claim
146 words
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.
Claim 29
Dependent Claim
20 words
The computer system of claim 24 wherein the local fact table and local dimension table are store in main memory.
Claim 30
Dependent Claim
38 words
The computer system of claim 24 wherein the transferring of information includes generating a main dimension identifier for the main dimension table and replacing the local dimension identifier with the generated main dimension identifier in the transferred information.
Claim 31
Dependent Claim
30 words
The computer system of claim 24 wherein the transferring of information includes adding an entry to the main dimension table corresponding to an entry added to the local dimension table.
Claim 32
Dependent Claim
23 words
The computer system of claim 24 wherein the transferring includes identifying an existing main dimension identifier that corresponds to a local dimension identifier.
Claim 33
Dependent Claim
18 words
The computer system of claim 24 wherein the processed data relates to navigation information of a web site.
Claim 34
Dependent Claim
15 words
The computer system of claim 24 wherein the processed data relates to click stream data.
References Cited (Backward Citations)
US5930786A
Cited
US5864871A
Cited
US5796633A
Cited
US5787425A
Cited
US6112238A
Cited
US5899992A
Cited
US6553416B1
Cited
US5905985A
Cited
US6205447B1
Cited
US6233573B1
Cited
US5987135A
Cited
US6003024A
Cited
US5960428A
Cited
US6000832A
Cited
US6470386B1
Cited
US6151601A
Cited
US6151584A
Cited
US6078924A
Cited
US6480836B1
Cited
US6199063B1
Cited
US6460037B1
Cited
US6212524B1
Cited
US6189004B1
Cited
US6161103A
Cited
US6477564B1
Cited
US6502132B1
Cited
US6192364B1
Cited
US6178418B1
Cited
US20020188584A1
Cited
US6192357B1
Cited
US6341290B1
Cited
US6665682B1
Cited
US6408292B1
Cited
US6105020A
Cited
US6484179B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2007-08-31 | 2008-03-01 | 2008-08-31 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2011-08-31 | 2012-03-01 | 2012-08-31 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2015-08-31 | 2016-03-01 | 2016-08-31 | $7700.00 | Window Closed / Lapsed |