Historical vehicle parts database system
First Claim
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 data preprocessing unit and programmed to store the historical vehicle replacement part database records in a database system 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 responding party client system, the service including an interface for receiving a user query from the responding party client system, the user query having data corresponding to information contained in a subrogation claim received from a demanding party, different from the responding party, the user query data including a first vehicle parts list representing vehicle parts in a repair estimate or which were actually used to repair a motor vehicle damaged in an accident involving a first motorist insured by the responding party and a second motorist insured by the demanding party, the repair estimate or the repair being authorized by only the demanding party;
a make, model and year of the vehicle;
a historical date of when the damage occurred or when the repair occurred; and
a geographic area of interest, the geographic area of interest consisting of a sub-region of an area covered by the historical vehicle replacement part database records having the historical chronology of vehicle parts availability information, the sub-region including a geographic location of the repair,the web server further programmed to provide to the responding party client system and the demanding party a database query result having a second vehicle parts list including those parts corresponding to the parts in the first vehicle parts list and which were suitable for use on the make, model and year of the vehicle that was damaged in the accident and which were available on the historical date when the damage occurred or when the repair occurred, were located within the geographic area of interest on the historical date when the damage occurred or when the repair occurred, and which conform to a rule set, the database query 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,the web server being further programmed to verify automatically the accuracy of the subrogation claim by comparing the database query result with the subrogation claim information to generate a subrogation claim accuracy verification result, and to generate automatically an independent subrogation claim value based only on the subrogation claim accuracy verification result, the subrogation claim accuracy verification result and the independent subrogation claim value being adapted to provide a documentation basis for negotiating the subrogation claim; and
an application server programmed to connect operatively 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 only upon the database query result, the subrogation claim accuracy verification result and the independent subrogation claim value.
10 Assignments
0 Petitions
Accused Products
Abstract
A computer system, method and computer readable media for processing historical vehicle replacement part database queries is disclosed. The system can include a data preprocessing unit, a database server coupled to the data preprocessing unit, a web server and an application server programmed to connect operatively to the database server and to the web server. The application server can be programmed to generate dynamic content including a user interface adapted to receive user input and to output result data based upon a database query result, a subrogation claim accuracy verification result and an independent subrogation claim value.
103 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 data preprocessing unit and programmed to store the historical vehicle replacement part database records in a database system 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 responding party client system, the service including an interface for receiving a user query from the responding party client system, the user query having data corresponding to information contained in a subrogation claim received from a demanding party, different from the responding party, the user query data including a first vehicle parts list representing vehicle parts in a repair estimate or which were actually used to repair a motor vehicle damaged in an accident involving a first motorist insured by the responding party and a second motorist insured by the demanding party, the repair estimate or the repair being authorized by only the demanding party;
a make, model and year of the vehicle;
a historical date of when the damage occurred or when the repair occurred; and
a geographic area of interest, the geographic area of interest consisting of a sub-region of an area covered by the historical vehicle replacement part database records having the historical chronology of vehicle parts availability information, the sub-region including a geographic location of the repair,the web server further programmed to provide to the responding party client system and the demanding party a database query result having a second vehicle parts list including those parts corresponding to the parts in the first vehicle parts list and which were suitable for use on the make, model and year of the vehicle that was damaged in the accident and which were available on the historical date when the damage occurred or when the repair occurred, were located within the geographic area of interest on the historical date when the damage occurred or when the repair occurred, and which conform to a rule set, the database query 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, the web server being further programmed to verify automatically the accuracy of the subrogation claim by comparing the database query result with the subrogation claim information to generate a subrogation claim accuracy verification result, and to generate automatically an independent subrogation claim value based only on the subrogation claim accuracy verification result, the subrogation claim accuracy verification result and the independent subrogation claim value being adapted to provide a documentation basis for negotiating the subrogation claim; and an application server programmed to connect operatively 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 only upon the database query result, the subrogation claim accuracy verification result and the independent subrogation claim value. - 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 data preprocessing unit; receiving a user query at a web server, the user query being transmitted by a responding party client system, the user query having data corresponding to information contained in a subrogation claim received from a demanding party, different from the responding party, the user query data 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 connect operatively 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 database query result from the database server at the application server, the database query result being responsive to the querying, the database 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; verifying automatically, at the application server, the accuracy of the subrogation claim by comparing the database query result with the subrogation claim information to generate a subrogation claim accuracy verification result; generating automatically, at the application server, an independent subrogation claim value based only on the subrogation claim accuracy verification result; generating dynamic content for transmitting to the client system using the application server, the dynamic content including a portion of the database query result and the independent subrogation claim value; 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 non-transitory 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 data 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 responding party client system, the user query having data corresponding to information contained in a subrogation claim received from a demanding party, different from the responding party, the user query data 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 connect operatively 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 database query result from the database server at the application server, the database query result being responsive to the querying, the database 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 database query result and an independent subrogation claim value based only on the subrogation claim accuracy verification result generated by comparing the database query result with the subrogation claim information to generate a subrogation claim accuracy verification 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