HISTORICAL VEHICLE PARTS DATABASE SYSTEM
First Claim
Patent Images
1. A computer system for processing historical vehicle replacement part database queries, the computer system comprising:
- a data preprocessing unit programmed to receive raw vehicle parts inventory data as input data, the raw vehicle parts inventory data including a digital representation of a supplier'"'"'s vehicle parts inventory available at one or more given locations on a given date, and to preprocess the input data into historical vehicle replacement part database records, each record corresponding to a vehicle part in the supplier'"'"'s inventory such that the database records represent availability of specific parts at the one or more given locations on the given date;
a database server coupled to the preprocessing unit and programmed to store the historical vehicle replacement part database records in a database system so as to create a historical chronology of vehicle parts availability information and to perform processing to retrieve historical vehicle replacement part records from the database system;
a web server programmed to provide a service to a client system, the service including an interface for receiving a user query including a first vehicle parts list, a make model and year of a vehicle, a historical date, and a geographic area of interest, the web server further adapted to provide to the client a result having a second vehicle parts list including those parts corresponding to the parts in the first vehicle parts list and which are suitable for use on the make, model and year of the vehicle and which were available on the historical date, were located within the geographic area of interest, and which conform to a rule set, the result including data received from the database server in response to a database query comprising information from the user query and information from the rule set; and
an application server programmed to operatively connect to the database server and to the web server and to generate dynamic content for transmitting to the client system, the dynamic content including a user interface adapted to receive user input and to output result data based upon the result of the database query.
10 Assignments
0 Petitions
Accused Products
Abstract
A historical vehicle replacement part database system is disclosed.
-
Citations
16 Claims
-
1. A computer system for processing historical vehicle replacement part database queries, the computer system comprising:
-
a data preprocessing unit programmed to receive raw vehicle parts inventory data as input data, the raw vehicle parts inventory data including a digital representation of a supplier'"'"'s vehicle parts inventory available at one or more given locations on a given date, and to preprocess the input data into historical vehicle replacement part database records, each record corresponding to a vehicle part in the supplier'"'"'s inventory such that the database records represent availability of specific parts at the one or more given locations on the given date; a database server coupled to the preprocessing unit and programmed to store the historical vehicle replacement part database records in a database system so as to create a historical chronology of vehicle parts availability information and to perform processing to retrieve historical vehicle replacement part records from the database system; a web server programmed to provide a service to a client system, the service including an interface for receiving a user query including a first vehicle parts list, a make model and year of a vehicle, a historical date, and a geographic area of interest, the web server further adapted to provide to the client a result having a second vehicle parts list including those parts corresponding to the parts in the first vehicle parts list and which are suitable for use on the make, model and year of the vehicle and which were available on the historical date, were located within the geographic area of interest, and which conform to a rule set, the result including data received from the database server in response to a database query comprising information from the user query and information from the rule set; and an application server programmed to operatively connect to the database server and to the web server and to generate dynamic content for transmitting to the client system, the dynamic content including a user interface adapted to receive user input and to output result data based upon the result of the database query. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A computerized method for processing historical vehicle replacement part database queries, the computerized method comprising:
-
receiving input data at a data preprocessing unit, the input data including a digital representation of vehicle parts in a supplier'"'"'s vehicle parts inventory; preprocessing the input data using the data preprocessing unit to generate historical vehicle replacement part database records each corresponding to one of the vehicle parts in the supplier'"'"'s vehicle parts inventory, the preprocessing including converting part name and description information for each part into a unique part identifier associated with each part record to permit location of a part record using translation of the part name and description information into a corresponding part identifier; storing each historical vehicle replacement part database record in a database system using a database server coupled to the preprocessing unit; receiving a user query at a web server, the user query being transmitted by a client system and including a first vehicle parts list, a vehicle make, model and year, a historical date, and a geographic area of interest; transmitting the user query to an application server coupled to the web server by a data network, the application server being programmed to operatively connect to the database server and to the web server over the data network; generating a database query comprising information from the user query and information from a rule set, the database query being generated by the application server; querying, at the application server, the database system by sending the database query to the database server; receiving a query result from the database server at the application server, the query result being responsive to the querying, the query result including a second list of vehicle parts matching the database query, the second list of vehicle parts including those parts corresponding to the parts in the first vehicle parts list and which are suitable for use on the vehicle make, model and year and which were available on the historical date, were located within the geographic area of interest, and which conform to a rule set; generating dynamic content for transmitting to the client system using the application server, the dynamic content including a portion of the query result; and transmitting the dynamic content to the client system in response to the user query received from the client over an external communication link. - View Dependent Claims (8, 9, 10, 11, 12, 13)
-
-
14. A computer readable medium having stored thereon software instructions for processing historical vehicle replacement part database queries, the software instructions including a first portion, a second portion, a third portion and a fourth portion,
the first portion, when executed by a first processor, causes the first processor to perform operations comprising: -
receiving input data at a data preprocessing unit, the input data including a digital representation of vehicle parts in a supplier'"'"'s vehicle parts inventory; preprocessing the input data using the data preprocessing unit to generate historical vehicle replacement part database records each including a part identifier corresponding to one of the vehicle parts in the supplier'"'"'s vehicle parts inventory, the part identifier being generated based on part name and description; the second portion, when executed by a second processor, causes the second processor to perform operations comprising; storing each historical vehicle replacement part database record in a database system using a database server coupled to the preprocessing unit; retrieving one or more historical vehicle replacement part database records based on a received query; the third portion, when executed by a third processor, causes the third processor to perform operations comprising; receiving a user query at a web server, the user query being transmitted by a client system and including a first vehicle parts list, a vehicle make, model and year, a historical date range, and a geographic area of interest; transmitting the user query to an application server coupled to the web server by a data network, the application server being programmed to operatively connect to the database server and to the web server over the data network; the fourth portion, when executed by a fourth processor, causes the fourth processor to perform operations comprising; generating a database query comprising information from the user query and information from a rule set, the database query being generated by the application server; querying the database system using the database query at the application server; receiving a query result from the database server at the application server, the query result being responsive to the querying, the query result including a second list of vehicle parts matching the database query, the second vehicle parts list including those parts corresponding to the parts in the first vehicle parts list and which are suitable for use on the make, model and year of the vehicle and which were available during the historical date range, were located within the geographic area of interest, and which conform to a rule set; generating dynamic content for transmitting to the client system using the application server, the dynamic content including result data based upon the query result; and transmitting the dynamic content to the web server in response to the user query received from the client such that the web server provides the dynamic content to the client over an external communication link in response to the user query. - View Dependent Claims (15, 16)
-
Specification