Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-10-10
2006-10-10
Alam, Shahid (Department: 2168)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07120638
ABSTRACT:
Disclosed is a method, system, program, and data structure for performing a clean operation on an input table. The input table to clean is indicated in an input data table name. At least one rule definition is processed to clean the input table. Each rule definition indicates a find criteria, a replacement value, and an input data column in the input table. For each rule definition, the input data column is searched for any fields that match the find criteria. The replacement value for the particular rule definition is inserted in the fields in the input data column that match the find criteria. Subsequent applications of additional rule definitions applied to the same input data column operate on replacement values inserted in the input data column during previously applied rule definitions.
REFERENCES:
patent: 4876733 (1989-10-01), Lavin
patent: 4930071 (1990-05-01), Tou et al.
patent: 5196924 (1993-03-01), Lumelsky et al.
patent: 5282147 (1994-01-01), Goetz et al.
patent: 5299304 (1994-03-01), Williams et al.
patent: 5321797 (1994-06-01), Morton
patent: 5367675 (1994-11-01), Cheng 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: 5596752 (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: 5737600 (1998-04-01), Geiner et al.
patent: 5742806 (1998-04-01), Reiner et al.
patent: 5905982 (1999-05-01), Carey et al.
patent: 5987474 (1999-11-01), Sandifer
patent: 6178421 (2001-01-01), Dahlen et al.
patent: 6185552 (2001-02-01), DeLong et al.
patent: 6266663 (2001-07-01), Fuh et al.
patent: 6282540 (2001-08-01), Goldensher et al.
patent: 6298342 (2001-10-01), Graefe et al.
patent: 6308177 (2001-10-01), Israni et al.
patent: 6370522 (2002-04-01), Agarwal 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
Ressell Borland, Microsoft 97, 1997, Microsoft Corporation, pp. 97-123.
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, Efficient Logging of Transactions on Persistent Information tin General and Data bases in Particular, vol. 40,No. 11, Nov. 1997 (c) 1997; pp. 117-120.
IBM Technical Disclosure Bulletin, Transformation of an Entity-Relationship Model into a System Object Model, Nov., 1994, pp. 631-634.
IBM Technical Disclosure Bulletin, Branch Set Preserving Transformations 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.
Hohenstein, U. and C. Korner. “A Graphical Tool for Specifying Semantic Enrichment of Relational Databases.” Database Applications Semantics. Proceedings of the IFIP WG 2.6 Working Conference on Database Applications Semantics (DS-6), May 30-Jun. 2, 1995, pp. 389-420, Published: London, UK, 1997, vii+610 pp., Chapman & Hall (Abstract).
Dendrinos, MN. “A Case Study for the Management of a Set of Spectrally Analysed Signals Based on OODBMS.” Proceedings IDEAS '97. International Database Engineering and Applications Symposium (Cat. No. 97TB100166), Aug. 25-27, 1997, pp. 121-125, Published: Los Alamitos, CA, USA, 1997, xii+403 pp., IEEE (Abstract).
Correl, S. and DP Miranker. “On Isolation, Concurrency and the Venus Rule Language.” Proceedings of the 1995 ACM CIKM International Conference on Information and Knowledge Management, Nov. 28-Dec. 2, 1995, pp. 281-289, Published: New York, NY, USA, 1995, xvi+418 pp., ACM (Abstract).
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 Relational 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.
Cesare Mark Anthony
Christopher Tom Robert
Jerves Julie Ann
Mandel, III Richard Henry
Alam Shahid
International Business Machines - Corporation
Konrad Raynes & Victor LLP
Pham Hung
Victor David W.
LandOfFree
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.
Profile ID: LFUS-PAI-O-3714746