US6128624A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Collection and integration of internet and electronic commerce data in a database during web browsing
Assignee: NCR Voyix Corp
•
Filing: 1997-11-12
•
Granted: 2000-10-03
•
Expires: 2017-11-12
Abstract
Abstract A system integrates data elements from an operational database of an Internet Service Provider (ISP) and Commerce Service Provider (CSP) into a predetermined format for supporting collection of the Internet and/or electronic commerce data. The system includes a database storing the electronic commerce data for interrogation by the ISP/CSP, a user station, and a design database. The design database includes a logical data model providing a description of the database facilitating the integration of the Internet and/or electronic commerce data and facilitating query and report access of the database. The design database also includes a formatted file library providing classifications including at least one of process characterizations, customer descriptions, preference determinations, and behavior patterns, the classifications being reusable for at least one of different technical processes and different customer problems. An optional a user interface is also provided which is capable of providing the functions of query access and report access of the design database.
Inventors
- 👤 Karen A. Papierniak
- 👤 James E. Thaisz
- 👤 Luo-Jen Chiang
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-05 02:04
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/258; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943; Y10S707/99944; Y10S707/99945; Y10S707/99948
Claims Analysis
Total Claims: 32
Claim 1
Independent Claim
272 words
In a computer system for supporting and analyzing Internet and electronic commerce data over the World Wide Web for service providers, the computer system including at least one user station transmitting a user request, at least one server, connectable to said at least one user station, said at least one server providing said at least one user station access to external data sources being in a plurality of different data formats, and at least one data collection and analysis system, a system of integrating data elements from an operational database of the service provider including at least one of an Internet service provider (ISP) and a commerce service provider (CSP) into a predetermined format for supporting collection and integration of the Internet and electronic commerce data, comprising: a database storing the integrated electronic commerce and Internet data for interrogation by the service provider wherein the electronic commerce data is merchant transaction data recording a specific purchasing transaction and the Internet data is data collected during web browsing by a user; and a user station, responsively connectable to said database and including a design database storing: a logical data model providing a description of the database facilitating the integration of the plurality of different formats of Internet and electronic commerce data and facilitating query and report access of the database; a formatted file library providing classifications including at least one of process characterizations, customer descriptions, preference determinations, and behavior patterns, the classifications being reusable for at least one of different technical processes and different customer problems; and a user interface capable of providing the query access and report access of the design database.
Claim 2
Dependent Claim
272 words
In a computer system for supporting and analyzing Internet and electronic commerce data over the World Wide Web for service providers, the computer system including at least one user station transmitting a user request, at least one server, connectable to said at least one user station, said at least one server providing said at least one user station access to external data sources being in a plurality of different data formats, and at least one data collection and analysis system, a system of integrating data elements from an operational database of the service provider including at least one of an Internet service provider (ISP) and a commerce service provider (CSP) into a predetermined format for supporting collection and integration of the Internet and electronic commerce data, comprising: a database storing the integrated electronic commerce and Internet data for interrogation by the service provider wherein the electronic commerce data is merchant transaction data recording a specific purchasing transaction and the Internet data is data collected during web browsing by a user; and a user station, responsively connectable to said database and including a design database storing: a logical data model providing a description of the database facilitating the integration of the plurality of different formats of Internet and electronic commerce data and facilitating query and report access of the database; a formatted file library providing classifications including at least one of process characterizations, customer descriptions, preference determinations, and behavior patterns, the classifications being reusable for at least one of different technical processes and different customer problems; and a user interface capable of providing the query access and report access of the design database.
Claim 3
Dependent Claim
90 words
A system of integrating data elements from an operational database of a service provider into a predetermined format for supporting collection of the Internet and electronic commerce data according to claim 1, wherein the electronic commerce data includes environmental data, and the environmental data includes at least one of how long files are kept on a server without deleting, how current is the data, how often is the data refreshed, how the data is updated, how the data is manipulated over time, the physical location, and the point of presence.
Claim 4
Dependent Claim
72 words
A system of integrating data elements from an operational database of a service provider into a predetermined and extendable format for supporting collection of the Internet and electronic commerce data according to claim 1, wherein the Internet and electronic commerce data includes business data, and the business data includes at least one of pre-paid user services, how the user purchases services and products, user discounts, billing rates, free subscriptions, and free information.
Claim 5
Dependent Claim
62 words
A system of integrating data elements from an operational database of a service provider into a predetermined and extendable format for supporting collection of the Internet and electronic commerce data according to claim 1, wherein the design database stores information source requirements, and the information source requirements include at least one of physical location and logical location where the information is located.
Claim 6
Dependent Claim
63 words
A system of integrating data elements from an operational database of a service provider into a predetermined format for supporting collection of the Internet and electronic commerce data according to claim 1, wherein the design database stores core business rules, and the core business rules include a minimum predetermined set of rules used to conduct customer business operation including administering a customer account.
Claim 7
Dependent Claim
66 words
A system of integrating data elements from an operational database of a service provider into a predetermined format for supporting collection of the Internet and electronic commerce data according to claim 1, wherein the design database stores core data sources, and the core data sources include a minimum predetermined data set which the customer is required to supply to perform the subsequent retrieval of the information.
Claim 8
Dependent Claim
55 words
A system of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 1, wherein the Internet and electronic commerce data information is retrieved from a distributed on-line, and interactive environment including multiple client browsers.
Claim 9
Dependent Claim
51 words
A system of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 7, wherein the multiple clients or client browsers are capable of accessing a SmartEC decisions server storing information.
Claim 10
Dependent Claim
55 words
A system of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 8, wherein the multiple client browsers are capable of accessing a server storing information including customer support material and sales campaign schedules.
Claim 11
Dependent Claim
77 words
A system of integrating data elements from an operational database of a service provider into a predetermined but flexible format for supporting collection of the Internet and electronic commerce data according to claim 1, wherein the logical data model and the formatted file library comprise metadata, and the metadata is used to WebTrack and define the Internet and electronic commerce data stored in said database and sources of the Internet and electronic commerce data feeding said database.
Claim 12
Dependent Claim
52 words
A system of integrating data elements from an operational database of a service provider into a predetermined but flexible format for supporting collection of the Internet and electronic commerce data according to claim 1, wherein said system is capable of reading a dataset and integrating the dataset into said database as metadata.
Claim 13
Dependent Claim
56 words
A system of integrating data elements from an operational database of a service provider into a predetermined format for supporting collection of the Internet and electronic commerce data according to claim 1, further comprising a translator providing an access function to access the logical data model and the formatted file library stored in said design database.
Claim 14
Dependent Claim
64 words
A system of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 1, wherein the logical data model and the formatted file library comprise metadata, and the metadata includes a description of elements stored in said database in accordance with a core design.
Claim 15
Dependent Claim
48 words
A system of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 13, wherein the core design provides an information structure that supports pre-defined decision support functionality.
Claim 16
Dependent Claim
70 words
A system of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 1, wherein the logical data model and the formatted file library comprise metadata, and the metadata provides a comprehensive description of each component and source of the Internet and electronic commerce data used to populate said database.
Claim 17
Dependent Claim
61 words
A system of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 1, wherein the logical data model and the formatted file library comprise metadata, and the metadata comprises schema for Internet/web data sources, and schema for operational data sources.
Claim 18
Dependent Claim
63 words
A system of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 16, wherein the schema for Internet/web data sources includes type of system logs, description of each log, location of each log, data format for each log entry, and operational considerations.
Claim 19
Dependent Claim
56 words
A system of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the electronic commerce data according to claim 16, wherein the schema for operational data sources includes tables, files and/or data elements that must be added to said database to enable decision-support functionality.
Claim 20
Independent Claim
193 words
A method of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection and integration of the Internet and electronic commerce data being in a plurality of different data formats using a computer, comprising the steps of: (a) storing the integrated electronic commerce and Internet data for interrogation by the service provider in a database wherein the electronic commerce data is merchant transaction data recording a specific purchasing transaction and the Internet data is data collected during web browsing by a user; (b) storing in a design database a logical data model providing a description of the database facilitating the integration of the plurality of different data formats of the Internet and electronic commerce data and facilitating query and report access of at least one of the databases and the design database; (c) storing a formatted file library providing classifications including at least one of process characterizations, customer descriptions, preference determinations, and behavior patterns, the classifications being reusable for at least one of different technical processes and different customer problems; and (d) providing the query access and report access to the design database.
Claim 21
Independent Claim
193 words
A method of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection and integration of the Internet and electronic commerce data being in a plurality of different data formats using a computer, comprising the steps of: (a) storing the integrated electronic commerce and Internet data for interrogation by the service provider in a database wherein the electronic commerce data is merchant transaction data recording a specific purchasing transaction and the Internet data is data collected during web browsing by a user; (b) storing in a design database a logical data model providing a description of the database facilitating the integration of the plurality of different data formats of the Internet and electronic commerce data and facilitating query and report access of at least one of the databases and the design database; (c) storing a formatted file library providing classifications including at least one of process characterizations, customer descriptions, preference determinations, and behavior patterns, the classifications being reusable for at least one of different technical processes and different customer problems; and (d) providing the query access and report access to the design database.
Claim 22
Dependent Claim
77 words
A method of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 19, wherein the logical data model and the formatted file library comprise metadata, and the metadata is used to track and define the Internet and electronic commerce data stored in said database and sources of the Internet and electronic commerce data feeding said database.
Claim 23
Dependent Claim
52 words
A method of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 19, wherein said method is capable of reading a dataset and integrating the dataset into said database as metadata.
Claim 24
Dependent Claim
58 words
A method of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 19, further comprising a translator providing an access function to access the logical data model and the formatted file library stored in said design database.
Claim 25
Dependent Claim
64 words
A method of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 19, wherein the logical data model and the formatted file library comprise metadata, and the metadata includes a description of elements stored in said database in accordance with a core design.
Claim 26
Dependent Claim
47 words
A method of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 23, wherein the core design provides an information structure that supports pre-defined decision-support functionality.
Claim 27
Dependent Claim
70 words
A method of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 19, wherein the logical data model and the formatted file library comprise metadata, and the metadata provides a comprehensive description of each component and source of the Internet and electronic commerce data used to populate said database.
Claim 28
Dependent Claim
61 words
A method of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 19, wherein the logical data model and the formatted file library comprise metadata, and the metadata comprises schema for Internet/web data sources, and schema for operational data sources.
Claim 29
Dependent Claim
63 words
A method of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 26, wherein the schema for Internet/web data sources includes type of system logs, description of each log, location of each log, data format for each log entry, and operational considerations.
Claim 30
Dependent Claim
58 words
A method of integrating data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection of the Internet and electronic commerce data according to claim 26, wherein the schema for operational data sources includes tables, files and/or data elements that must be added to said database to enable decision-support functionality.
Claim 31
Dependent Claim
184 words
A computer program memory, storing computer instructions to integrate data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection and integration of the Internet and electronic commerce data over one or more networks, the integrated electronic commerce and Internet data being in a plurality of different data formats, the computer instructions including: (a) storing in a design database a logical data model providing a description of the database facilitating the integration of the plurality of different data formats of Internet and electronic commerce data and facilitating at least one of query and report access to the design database, the electronic commerce data is merchant transaction data recording a specific purchasing transaction and the Internet data is data collected during web browsing by a user; (b) storing a formatted file library providing classifications including at least one of process characterizations, customer descriptions, preference determinations, and behavior patterns, the classifications being reusable for at least one of different technical processes and different customer problems; and (c) providing the query access and report access to the design database.
Claim 32
Dependent Claim
184 words
A computer program memory, storing computer instructions to integrate data elements from an operational database of a service provider into a predetermined and expandable format for supporting collection and integration of the Internet and electronic commerce data over one or more networks, the integrated electronic commerce and Internet data being in a plurality of different data formats, the computer instructions including: (a) storing in a design database a logical data model providing a description of the database facilitating the integration of the plurality of different data formats of Internet and electronic commerce data and facilitating at least one of query and report access to the design database, the electronic commerce data is merchant transaction data recording a specific purchasing transaction and the Internet data is data collected during web browsing by a user; (b) storing a formatted file library providing classifications including at least one of process characterizations, customer descriptions, preference determinations, and behavior patterns, the classifications being reusable for at least one of different technical processes and different customer problems; and (c) providing the query access and report access to the design database.
References Cited (Backward Citations)
US5819092A
Cited
US5701400A
Cited
US5809144A
Cited
US5710887A
Cited
US5671279A
Cited
US5729594A
Cited
US5812668A
Cited
US5862223A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-10-03 | 2004-04-03 | 2004-10-03 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-10-03 | 2008-04-03 | 2008-10-03 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-10-03 | 2012-04-03 | 2012-10-03 | $7700.00 | Window Closed / Lapsed |