Systems and methods for organizing and validating data in documents
First Claim
1. A system for validating and organizing data in a design document, comprising:
- a database including a previous document table with data of the document, an internal document table with validated data of the document;
a computer programmed to as follows;
compare data of the document with data of the previous table;
define a change based on the compare, replace the data of the previous document table with the element of the document, and validate the data and replace the data of internal document table.
2 Assignments
0 Petitions
Accused Products
Abstract
The invention relates to information exchange when a design organization sends a design document to a manufacturer. The design documents may have errors and, once detected, the errors may not be corrected by the design organization. The documents may be resent with a small number of changes or perhaps no changes at all, but may have errors that have been seen before. The documents may have many items that are not important to the receiving organization. A dictionary is used to validate and correct the documents. Changes in the dictionary may require changes in the information used by the manufacturer. The invention provides a system and method for use with a computer that aids in the validation and correction of the information contained in the document, in that it detect changes in the document when resent so that the changes are validated or corrected, filters the document so that only relevant information is processed, detects changes in the dictionary so that only changes are processed, and filters the dictionary so that only relevant information in the dictionary is processed. In addition, the invention provides means to initialize the information that are in use and assumed to be valid to avoid the validation and correction of the information.
-
Citations
5 Claims
-
1. A system for validating and organizing data in a design document, comprising:
-
a database including a previous document table with data of the document, an internal document table with validated data of the document;
a computer programmed to as follows;
compare data of the document with data of the previous table;
define a change based on the compare, replace the data of the previous document table with the element of the document, and validate the data and replace the data of internal document table. - View Dependent Claims (2, 3, 4)
-
-
5. A method of validating information comprising data in a design document in a relational database, comprising:
-
storing a table named Past containing the most recent design document sent to the relational database;
storing a table named Data to Use containing validated or corrected data to be used in manufacturing based on the design document;
initializing the table Past and the table Data to Use by setting the data contained to null values;
receiving a table New Version of the design document;
comparing the table New Version to the table Past to detect any change, wherein the data contained in the table New Version does not match the data in the table Past;
setting the table Past to the table New Version;
validating and correcting the data in the table New Version based on changing the data to correspond to a dictionary of correct data; and
setting the table Data to Use to a table Validated/Corrected New Version.
-
Specification