Method, system, program, and data structure for cleaning a...

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C707S793000, C707S793000

Reexamination Certificate

active

06965888

ABSTRACT:
Disclosed is a method, system, program, and data structure for performing a clean operation on an input table. An input data table name indicates the input table. A first column in a table including a plurality of entries and at least one rule definition are processed. Each rule definition indicates a look-up column including a plurality of entries and a clean operation. A determination is made, for each record in the input table column, whether the record matches one entry in the look-up column. If so, the clean operation indicated in the rule definition is performed on each record that matches one entry in the look-up column.

REFERENCES:
patent: 4876733 (1989-10-01), Lavin
patent: 4930071 (1990-05-01), Tou et al.
patent: 5113342 (1992-05-01), Zamora
patent: 5196924 (1993-03-01), Lumelsky et al.
patent: 5226158 (1993-07-01), Horn et al.
patent: 5282147 (1994-01-01), Goetz et al.
patent: 5299304 (1994-03-01), Williams et al.
patent: 5321606 (1994-06-01), Kuruma et al.
patent: 5321797 (1994-06-01), Morton
patent: 5367675 (1994-11-01), Cheng et al.
patent: 5546576 (1996-08-01), Cochrane et al.
patent: 5548749 (1996-08-01), Kroenke et al.
patent: 5548754 (1996-08-01), Pirahesh et al.
patent: 5548755 (1996-08-01), Leung et al.
patent: 5548758 (1996-08-01), Pirahesh et al.
patent: 5560005 (1996-09-01), Hoover et al.
patent: 5584024 (1996-12-01), Schwartz
patent: 5588150 (1996-12-01), Lin et al.
patent: 5590321 (1996-12-01), Lin et al.
patent: 5590324 (1996-12-01), Leung et al.
patent: 5594899 (1997-01-01), Knudsen et al.
patent: 5598559 (1997-01-01), Chaudhuri
patent: 5615361 (1997-03-01), Leung et al.
patent: 5687362 (1997-11-01), Bhargava et al.
patent: 5694591 (1997-12-01), Du et al.
patent: 5701454 (1997-12-01), Bhargava et al.
patent: 5724570 (1998-03-01), Zeller et al.
patent: 5724575 (1998-03-01), Hoover et al.
patent: 5737592 (1998-04-01), Nguyen et al.
patent: 5742806 (1998-04-01), Reiner et al.
patent: 5873075 (1999-02-01), Cochrane et al.
patent: 5905982 (1999-05-01), Carey et al.
patent: 6298342 (2001-10-01), Graefe et al.
patent: 6523040 (2003-02-01), Lo et al.
patent: 7182179 (1995-07-01), None
patent: 7244603 (1995-09-01), None
patent: 8241330 (1996-09-01), None
patent: 9179882 (1997-07-01), None
patent: 9636003 (1996-11-01), None
Referential Integrity Implementation Details and Advantages, IBM, Mar. 1995, 477-488.
Gevers, T. and A.W.M. Smeulders. “Transformation Invariant Image Indexing and Retrieval for Image Databases.” In Proceedings of the SPIE—The International Society for Optical Engineering, vol. 2357, pt. 1, pp. 303-310, 1994.
Drake, P.R., A.D. Jennings, R.I. Grosvenor and D. Whittleton. “A Data Acquisition System for Machine Tool Condition Monitoring.” In Quality and reliability Engineering International, vol. 11, No. 1, pp. 15-26, Jan.-Feb. 1995.
Design and Implementation of Derivation Rules in Information Systems, by R. Winter. Data & Knowledge Engineering, vol. 26, (1998), pp. 225-241.
Realizing Object-Relational Databases by Mixing Tables with Objects., by C. Liu, et al. CRC for Distributed Systems Technology, School of Information Technology, The University of Queensland, Brisbane, Australia, pp. 335-346.
SuperSQL: An Extended SQL for Database Publishing and Presentation., by M. Toyama. Department of Information and Computer Science, Keio University, Yokohama, JP, pp. 584-586.
A Starburst is Born, by G. Lapis, et al. IBM Almaden Research Center, San Jose, CA. 1 page.
Datalog Rule Evaluation in Associative Computers and Massively Parallel SIMD Machines, by O. Cho, et al. Department of Computer Science, The University of Queensland, Brisbane, Australia, pp. 56-.
Framework for Query Optimization in Distributed Statistical Databases, by Sadreddini, M.H., et al. Information and Software Technology, vol. 34, No. 6, Jun. 1992, pp. 363-377.
ACM, 1983. Incomplete Information and Dependencies in Relation Databases* (*Preliminary Version), by T. Imielinski. Sigmod Record Issue Vo. 13, No. 4, pp. 178-184.
Abstraction in Query Processing, by T. Imielinski. Journal of the Association for Computing, vol. 38, No. 3, Jul. 1991, pp. 534-558.
International Business Machines Corporation, IBM's Data Mining Technology, White Paper; Data Management Solutions,(c) 1996.
International Business Machines Corporation, IBM Visual Warehouse for Windows NT, Managing Visual Warehouse, (c) 1998.
IBM Technical Disclosure Bulletin, Transformation of an Entity-Relationship Model into a System Obect Model, Nov., 1994, pp. 631-634.
IBM Technical Disclosure Bulletin, Branch Set Preserving Transformation of Hierarchical Data Structure, vol. 23, No. 7B, Dec. 1980, (c) 1980; pp. 3090-3094.
IBM Technical Disclosure Bulletin, Intelligent Miner, vol. 40, No. 02, Feb, 1997; pp. 121-125.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Method, system, program, and data structure for cleaning a... 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, system, program, and data structure for cleaning a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system, program, and data structure for cleaning a... will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-3518569

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.