Method for creating a relational description of a formatted tran

Details Method for creating a relational description of a formatted tran Method for creating a relational description of a formatted tran

1997-01-13

1999-03-02

Amsbury, Wayne

Data processing: database and file management or data structures

Database design

Data structure types

G06F 1730

Patent

active

058784195

ABSTRACT:
Methods for creating and using a relational description of a formatted transaction while maintaining data element context are provided. The formatted transaction can be in electronic data interchange (EDI) format or another structured transaction format. A computer receiving the formatted transaction generates or is provided with a set of assignments of unique persistent tags to all possible data element contexts that are of interest. As the transaction is being parsed, each of its data elements is tagged with the appropriate unique persistent tag that identifies its context. Each data element is then written to a field in a relation in which the column name of the field matches the unique persistent tag. Data elements that can occur only once in a transaction are written to a root relation, while data elements that can occur multiple times are written to a subrelation. Data elements that can occur multiple times within a group of data elements that itself can iterate as a group are written to a nested subrelation, up to any depth of nesting allowed by the transaction format definition. The invention also provides a method for constructing a transaction from a relational description.

REFERENCES:
patent: 4769772 (1988-09-01), Dwyer
patent: 4805099 (1989-02-01), Huber
patent: 4891785 (1990-01-01), Donohoo
patent: 4930071 (1990-05-01), Tou et al.
patent: 4951196 (1990-08-01), Jackson
patent: 5202977 (1993-04-01), Pasetes, Jr. et al.
patent: 5212787 (1993-05-01), Baker et al.
patent: 5230075 (1993-07-01), Premerlani et al.
patent: 5257366 (1993-10-01), Adair et al.
patent: 5265065 (1993-11-01), Turtle
patent: 5367675 (1994-11-01), Cheng et al.
patent: 5375070 (1994-12-01), Hershey et al.
patent: 5398199 (1995-03-01), Lefons
patent: 5408652 (1995-04-01), Hayashi et al.
patent: 5410675 (1995-04-01), Shreve et al.
patent: 5416917 (1995-05-01), Adair et al.
patent: 5499358 (1996-03-01), Nevarez
patent: 5535322 (1996-07-01), Hecht
patent: 5608874 (1997-03-01), Ogawa et al.
patent: 5712989 (1998-01-01), Johnson et al.
patent: 5715397 (1998-02-01), Ogawa et al.
"Electronic Data Interchange", Draft, ANSI ASC X12 Committee, American Standards Institute, Dec. 1990, Selected Pages.

Affiliated with

Also associated with

Rating

Method for creating a relational description of a formatted tran does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for creating a relational description of a formatted tran, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for creating a relational description of a formatted tran will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-433508