 Methods, apparatus, and articles of manufacture for analyzing memory use |
| Systems, methods, and articles of manufacture consistent with the present invention track accesses ... |
|
| Method and system for report presentation and navigation in a computer system |
| The present invention is a method and system for report presentation and navigation in a computer ... |
|
| Web based data mining and location data reporting and system |
| The database reporting and data mining system that is the subject of this invention is implemented, ... |
|
| Fast refresh of snapshots |
| One aspect of the invention is a method of refreshing a snapshot defined by a snapshot definition ... |
|
| Document management system for automating operations performed on documents in data storage areas |
| In accordance with the present invention, there is provided a document management system with an ... |
|
| Method and apparatus for providing multi-level searching in an electronic book |
| What is claimed is: 1. In a method for providing user access to stored textual information in a ... |
|
| Detection of cholesterol deposits in arteries |
| According to the present invention, a 5 MHz ultrasonic beam is directed from a transmitting ... |
|
| Disease simulation system and method |
| The invention presents a system and method for simulating a disease control parameter and for ... |
|
| Method and system for modeling interaction of objects |
| The present invention provides a method for modeling interactions between models. A first ... |
|
| Image sequence compression featuring independently coded regions |
| The invention summarized above and defined by the enumerated claims may be better understood by ... |
|
|
Method, system, program, and data structure for cleaning a database table
| Details |
Inventors: Cesare, Mark Anthony; Christopher, Tom Robert; Jerves, Julie Ann; Mandel, III, Richard Henry;
Assignee: International Business Machines Corporation (Armonk, NY)
Primary Examiner: Alam; Shahid
Assistant Examiner: Pham; Hung
Attorney, Agent or Firm: Victor; David W. Konrad Raynes & Victor LLP
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. |
|
DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS In the following description, reference is made to the accompanying drawings which form a part hereof and which illustrate several embodiments of the present invention.
It is understood that other embodiments may be utilized and structural and operational changes may be made without departing from the scope of the present invention.
Computing Environment FIG.
1 illustrates a computing environment 2 in which preferred embodiments are implemented.
The environment 2 includes a server 4 and client 6.
The server 4 and client 6 would include an operating system, such as MICROSOFT WINDOWS 98 and WINDOWS NT, AIX, OS/390, OS/400, OS/2, and SUN SOLARIS,** and may be comprised of any suitable server and client architecture known in the art.
The server 4 and client 6 include a database program 8a and 8b, wherein 8a comprises the server 4 side of the database program and 8b comprises the client 6 side.
The server 4 and client 6 may communicate via any communication means known in the art, such as a telephone line, dedicated cable or network line, etc, using any protocol known in the art including TCP/IP network (e.
g.
, an Intranet, the Internet), LAN, Ethernet, WAN, System Area Network (SAN), Token Ring, etc.
Alternatively, there may be separate and different networks between the servers 4 and client 6.
**Microsoft, Windows, Windows NT are registered trademarks and Microsoft SQL Server is a trademark of Microsoft Corporation; DB2, AIX, OS/390, OS/400, and OS/2 are registered trademarks of IBM; and Oracle8 is a trademark of Oracle Corporation; and Solaris is a trademark of Sun Microsystem, Inc.
The client/server database programs 8a, b, may be comprised of any client/server database program known in the art, such as DB2, Oracle Corporation's ORACLE 8, Microsoft SQL Server,** etc.
The database programs 8a and 8b are used to access operations and perform operations with respect to information maintained in one or more databases 10.
The database(s) 10 would consist of multiple tables having rows and columns of data, e
|
| Related patents |
|
|
System for distributing a plurality of threads associated with a process initiating by one data processing station among data processing stations
We claim: 1. A computer network comprising: a communications medium; a plurality of data processing stations each having one or more processors, a communication device ...
|
|
|
Hosting a network service on a cluster of servers using a single-address image
The present invention provides methods and apparatus for hosting a network service on a cluster of servers. All of the servers in a server cluster configured in ...
|
|
|
Computer system for creating semantic object models from existing relational database schemas
The present invention is a computer system programmed to automatically create a semantic object model from an existing relational database schema. The schema is analyzed ...
|
|
|
System and method for managing data privacy in a database management system including a dependently connected privacy data mart
To address the requirements described above, the present invention discloses a method and apparatus for managing consumer notification and access and a means of ...
|
|
|
Integrated customer interface for web based data management
The present invention is directed to a Web-based, integrated customer interface system for data management. The customer interface system is provided with a graphical ...
|
|
|
Graphical user interface for relational database
Referring now to FIG. 1, there is illustrated a block diagram describing an exemplary computer architecture 100, configurable in accordance with an embodiment of the ...
|
|
|
Selection and storage of policies in network management
The present invention is directed to the user interface and policy loading aspects of a policy-based, outsourced, network management system. In one aspect, a user ...
|
|
|
Method and apparatus for providing a highly interactive transaction environment in a distributed network
In one embodiment of the invention, in a multithreaded computing environment, a platform independent method for providing a highly interactive transaction session ...
|
|
|
Intelligent agent with negotiation capability and method of negotiation therewith
OF THE ILLUSTRATED EMBODIMENTS Turning to the Drawing, wherein like parts are denoted by like numbers throughout the several views, FIG. 1 illustrates a networked ...
|
|
|
Method and system for forecasting events and threats based on geospatial modeling
The present invention provides a forecasting engine and method which assists in forecasting occurrences of identifiable events and/or threats based on signature and/or ...
|
|
|
Databases 
