US6643635B2
Expired / Lapsed
US
⏱️ 0.0 years remaining
Methods for dynamically accessing, processing, and presenting data acquired from disparate data sources
Assignee: SAGEMETRICS Inc
•
Filing: 2001-03-15
•
Granted: 2003-11-04
•
Expires: 2021-03-15
Abstract
Abstract Methods for acquiring and transforming data for business analysis, and computer readable media having program instructions for enabling the same are provided. One exemplary method identifies a set of data sources to be accessed for a user, loads the raw data from each of the data sources to raw data type specific locations and then verifies the integrity of the acquired raw data. Next the acquired raw data is transformed to a uniform data type and then stored as processed data into processed data type specific locations. Some notable advantages of the discussed methods of acquiring and presenting data for business analysis purposes is the ability to efficiently extract, organize and present the data as requested by a customer over a world wide computer network. Examples of such efficiency include the ability to convert data acquired from disparate sources to a uniform format, thus allowing centralization of the data and eliminating the need to continually access various data sources to provide requested reports. The customer can thus be provided with dynamic reports in real-time, thereby allowing for time sensitive and mission critical business decisions to be made with current data.
Inventors
- 👤 E. Kenneth Nwabueze
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-31 06:02
CPC Classifications
G; G06; G06Q; G06Q10/00; G06Q10/06; G06F; G06F16/00; G06F16/90; G06F16/95; G06F16/953; G06F16/9535; H; H04; H04L; H04L67/00; H04L67/50; H04L67/75; H04L69/00; H04L69/30; H04L69/32; H04L69/322; H04L69/329; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99941; Y10S707/99942; Y10S707/99944; Y10S707/99945; Y10S707/99948
Claims Analysis
Total Claims: 20
Claim 1
Independent Claim
233 words
A method for acquiring and presenting data for business analysis, comprising: identifying a set of data sources to be accessed; accessing each of the set of data sources; acquiring raw data from each of the accessed set of data sources; storing the acquired raw data into raw data type specific compartments, such that each raw data type specific compartment is associated with each of the set of data sources; pre-processing the acquired raw data to ensure data integrity; transferring the acquired raw data from each of the raw data type specific compartments to processed data type specific compartments to define processed data, the transferring being configured to detect a data type of each raw data type specific compartment and load data components of each raw data type specific compartment into the respective processed data type specific compartment based on the detected data type, the transferring further including, converting the data types of each raw data type specific compartment into a single data type, so that each processed data type specific compartment has the same single data type; transferring the processed data from each processed data type specific compartment to a temporary database; applying display rules, the display rules being configured to define a format and content of a requested report; outputting the requested report, the outputting includes, referencing the temporary database; and acquiring data elements from the temporary database using the display rules.
Claim 2
Independent Claim
233 words
A method for acquiring and presenting data for business analysis, comprising: identifying a set of data sources to be accessed; accessing each of the set of data sources; acquiring raw data from each of the accessed set of data sources; storing the acquired raw data into raw data type specific compartments, such that each raw data type specific compartment is associated with each of the set of data sources; pre-processing the acquired raw data to ensure data integrity; transferring the acquired raw data from each of the raw data type specific compartments to processed data type specific compartments to define processed data, the transferring being configured to detect a data type of each raw data type specific compartment and load data components of each raw data type specific compartment into the respective processed data type specific compartment based on the detected data type, the transferring further including, converting the data types of each raw data type specific compartment into a single data type, so that each processed data type specific compartment has the same single data type; transferring the processed data from each processed data type specific compartment to a temporary database; applying display rules, the display rules being configured to define a format and content of a requested report; outputting the requested report, the outputting includes, referencing the temporary database; and acquiring data elements from the temporary database using the display rules.
Claim 3
Dependent Claim
43 words
A method for acquiring and presenting data for business analysis as recited in claim 1 , wherein pre-processing the acquired raw data to ensure data integrity further comprises: determining if a file is compressed; and uncompressing the file if the file is compressed.
Claim 4
Dependent Claim
40 words
A method for acquiring and presenting data for business analysis as recited in claim 2 , wherein pre-processing the acquired raw data to ensure data integrity further comprises: opening the file; and ensuring expected data is inside each open file.
Claim 5
Dependent Claim
32 words
A method for acquiring and presenting data for business analysis as recited in claim 2 , wherein pre-processing the acquired raw data to ensure data integrity further comprises: counting and logging records.
Claim 6
Dependent Claim
44 words
A method for acquiring and presenting data for business analysis as recited in claim 1 , wherein transferring the acquired raw data from each of the raw data type specific compartments to processed data type specific compartments further comprises: performing a memory map transfer.
Claim 7
Dependent Claim
51 words
A method for acquiring and presenting data for business analysis as recited in claim 1 , wherein transferring the acquired raw data from each of the raw data type specific compartments to processed data type specific compartments further comprises: transferring the raw data type specific compartments to an initial temporary database.
Claim 8
Dependent Claim
25 words
A method for acquiring and presenting data for business analysis as recited in claim 1 , wherein the single data type has a uniform format.
Claim 9
Dependent Claim
31 words
A method for acquiring and presenting data for business analysis as recited in claim 1 , wherein applying display rules further comprises: applying one of business rules and data mining rules.
Claim 10
Dependent Claim
38 words
A method for acquiring and presenting data for business analysis as recited in claim 1 , wherein the raw data type specific compartments and the processed data type specific compartments are stored in a network attached storage unit.
Claim 11
Dependent Claim
50 words
A method for acquiring and presenting data for business analysis as recited in claim 1 , wherein outputting the requested report further comprises: generating the requested report in one of a spreadsheet format, a world wide web interactive format, an Internet browser compatible format and an electronic mail file format.
Claim 12
Dependent Claim
37 words
A method for acquiring and presenting data for business analysis as recited in claim 1 , wherein outputting the requested report further comprises: communicating the requested report to a remote user over a land or wireless network.
Claim 13
Dependent Claim
38 words
A method for acquiring and presenting data for business analysis as recited in claim 1 , wherein the acquired raw data is associated to a unique identification defining a customer and source path for the acquired raw data.
Claim 14
Dependent Claim
42 words
A method for acquiring and presenting data for business analysis as recited in claim 1 , wherein the identifying set of data sources to be accessed further comprises: setting a time and frequency to access each of the set of data sources.
Claim 15
Independent Claim
173 words
A method for retrieving, organizing and presenting data for business intelligence purposes, comprising: locating a set of data sources containing raw data files; setting a time and frequency to access each of the set of data sources; retrieving the raw data files from the set of data sources, the raw data files containing raw data; storing each of the retrieved raw data files in a storage file; processing each of the retrieved raw data files, the processing including; loading each of the retrieved raw data files in a loader, where the loader contains a set of processing rules, and applying the set of processing rules to each of the retrieved raw data files to convert each of the retrieved raw data files to a processed data file having a uniform format, and storing each of the processed data files in the storage file; transferring each of the processed data files to a database; accessing the database in response to a customer report request; presenting a report in a desired format to the customer.
Claim 16
Independent Claim
173 words
A method for retrieving, organizing and presenting data for business intelligence purposes, comprising: locating a set of data sources containing raw data files; setting a time and frequency to access each of the set of data sources; retrieving the raw data files from the set of data sources, the raw data files containing raw data; storing each of the retrieved raw data files in a storage file; processing each of the retrieved raw data files, the processing including; loading each of the retrieved raw data files in a loader, where the loader contains a set of processing rules, and applying the set of processing rules to each of the retrieved raw data files to convert each of the retrieved raw data files to a processed data file having a uniform format, and storing each of the processed data files in the storage file; transferring each of the processed data files to a database; accessing the database in response to a customer report request; presenting a report in a desired format to the customer.
Claim 17
Dependent Claim
28 words
The method of retrieving, organizing and presenting data for business analysis as recited in claim 14 , wherein the loader contains a format detector and a temporary database.
Claim 18
Dependent Claim
27 words
The method of retrieving, organizing and presenting data for business analysis as recited in claim 15 , wherein the temporary database can be one or more databases.
Claim 19
Dependent Claim
38 words
The method of retrieving, organizing and presenting data for business analysis as recited in claim 15 , further including transferring the retrieved raw data files in the loader to the temporary database by performing a parallel memory map.
Claim 20
Dependent Claim
36 words
The method of retrieving, organizing and presenting data for business analysis as recited in claim 15 , further including applying a set of display rules to the stored processed data files to obtain processed display data.
References Cited (Backward Citations)
US5261080A
Cited
US4864497A
Cited
US5319777A
Cited
US5359468A
Cited
US5403639A
Cited
US5611066A
Cited
US5761696A
Cited
US5870733A
Cited
US6334126B1
Cited
US6338056B1
Cited
US6519598B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2006-11-03 | 2007-05-05 | 2007-11-04 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2010-11-03 | 2011-05-05 | 2011-11-04 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2014-11-03 | 2015-05-05 | 2015-11-04 | $7700.00 | Window Closed / Lapsed |