Systems and methods for organizing and validating data in documents

• US 20060047676A1
• Filed: 10/08/2005
• Published: 03/02/2006
• Est. Priority Date: 12/21/2001
• Status: Active Grant

• Current Assignee: Juniper Networks Incorporated
• Original Assignee: Juniper Networks Incorporated
• Inventors: Ouchi, Norman Ken
• Granted Patent: US 8,788,469 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99954 Version management

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.

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.

2. The system of claim 1, wherein the document includes an indicator, the previous document table with the data having an identifier, the internal document table with data having an identifier, and the computer is further programmed to as follows:

compare the document indicator with the previous document table data identifiers and determine the set of internal document data elements used by the database.

3. The system of claim 1, wherein the database includes a table with the changed data.

4. The system of claim 1, wherein the database includes an internal format and the computer is further programmed to modify the changed data to match the internal format.

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.