Mapping data sets to a target structure

Details Mapping data sets to a target structure Mapping data sets to a target structure

2007-12-25

2007-12-25

Breene, John (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C715S252000

Reexamination Certificate

active

10831974

ABSTRACT:
According to the present invention there is provided a user interface for mapping data sets to a target data structure. Each data set comprises data segments separated by a separator. The target data structure comprises target data fields. The user interface comprises: 1) a segment display section in which data segments of one data set are displayed; 2) a target display section in which possible target fields to which data segments can be associated/mapped are displayed; 3) a selection device for associating a predetermined data segment with a target field; and 4) a contents preview display section in which the different values contained in one selected data segment of all data sets is displayed. Furthermore, there is provided a method and computer system.

REFERENCES:
patent: 5689699 (1997-11-01), Howell et al.
patent: 6128617 (2000-10-01), Lowry
patent: 2002/0046248 (2002-04-01), Drexler
patent: 2002/0056075 (2002-05-01), Hamilton et al.
patent: 2002/0184609 (2002-12-01), Sells et al.
patent: 2002/0194196 (2002-12-01), Weinberg et al.
patent: 2003/0004945 (2003-01-01), Teng et al.
patent: 0458179 (1991-11-01), None
patent: 1217540 (2002-06-01), None
patent: 03/012611 (2003-02-01), None
Chaudhuri, Surajit, et al., “An Overview of Data Warehousing and OLAP Technology,”SIGMOD Record, SIGMOD, New York, USA, vol. 26, No. 1, Mar. 1997, pp. 65-74, XP002193792.
Squire, Cass, “Data Extraction and Transformation for the Data Warehouse,”ACM Proceedings of SIGMOD, International Conference on Management of Data, vol. 24, No. 1, Mar. 1, 1995, pp. 446-447, XP002091745.
White, Colin, “Data Warehousing: Cleaning and Transforming Data,” INFO DB, Iowa City, USA, vol. 10, No. 6, Apr. 6, 1997, pp. 11-12, XP002091743.
White, Colin, “Managing Data Transformations,”Byte, McGraw-Hill Inc., St. Petersborough, USA, Dec. 1, 1997, pp. 53-54, XP000728707.

Affiliated with

Also associated with

Rating

Mapping data sets to a target structure does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Mapping data sets to a target structure, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Mapping data sets to a target structure will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3873413