Search

Amando Isip Phones & Addresses

  • 1873 Nelson Ranch Loop, Cedar Park, TX 78613
  • 1204 Serenade Ln, Richardson, TX 75081
  • Orlando, FL

Publications

Us Patents

Method For Maintaining Exception Tables For A Check Utility

View page
US Patent:
20010016844, Aug 23, 2001
Filed:
Oct 27, 1998
Appl. No.:
09/179533
Inventors:
AMANDO B. ISIP - RICHARDSON TX, US
International Classification:
G06F017/30
US Classification:
707/007000
Abstract:
A method for maintaining exception tables for a CHECK utility includes generating a control statement including key words and associated values for predetermined exception table parameters. The control statement is parsed by the CHECK utility which automatically builds and executes SQL statements required to create and drop exception tables.

System And Method For Reorganizing Stored Data

View page
US Patent:
20020147736, Oct 10, 2002
Filed:
Apr 9, 2001
Appl. No.:
09/829164
Inventors:
Amando Isip - Richardson TX, US
International Classification:
G06F012/00
US Classification:
707/200000
Abstract:
A method for reorganizing data is described. The method includes the steps of reading each record of a source file and writing each record to a destination file. The method also includes the step of creating a log file containing selected log records. Each log record is associated with a change to be made to the destination file. The method further includes the steps of reading each log record of the log file and processing each record of the log file, thereby effecting the associated change to the destination file. The method still further includes the step of replacing the source file with the destination file. An apparatus and article of manufacture are also disclosed for implementing the steps of the method.

Method And System For Reorganizing A Tablespace In A Database

View page
US Patent:
20040215632, Oct 28, 2004
Filed:
Aug 27, 2003
Appl. No.:
10/649393
Inventors:
Amando Isip - Richardson TX, US
Stephen Weaver - Lisle IL, US
Joseph Zelenka - Itasca IL, US
Assignee:
Computer Associates Think, Inc.
International Classification:
G06F007/00
US Classification:
707/100000
Abstract:
A method of reorganizing a tablespace in a database may include reading a row of data from the database, analyzing the row of data read out from the database, determining whether to eliminate or retain the row of data based on at least one predetermined rule, reloading the row of data into the database when it is determined that the row of data complies with the at least one predetermined rule, eliminating the row of data when it is determined that the row of data does not comply with the at least one predetermined rule, and rebuilding an index related to the database to include keys that correspond to the reloaded row of data. The determining, reloading, eliminating and rebuilding steps are repeated for each row of data in the database.

Dynamic Determination Of Optimal Process For Enforcing Constraints

View page
US Patent:
6295539, Sep 25, 2001
Filed:
Sep 14, 1998
Appl. No.:
9/151750
Inventors:
Amando B. Isip - Richardson TX
Assignee:
Computer Associates Think, Inc. - Islandia NY
International Classification:
G06F 1730
US Classification:
707201
Abstract:
Performance of constraint checking is enhanced by dynamically determining an optimal process to perform the checking operation. If additional dataspace can be allocated, the parent index values are stored in the dataspace and a binary search is performed between the extracted foreign keys and the dataspace, thereby eliminating the need for a sort operation on extracted foreign keys to perform constraint checking. If all of the parent indexes needed for constraint enforcement cannot be stored in dataspace, then as many parent indexes as possible are stored in dataspace and multiple reader and multiple sort tasks are utilized to process the remaining parent indexes. Depending on the availability of resources and the characteristics of the database table, determined dynamically, complete or partial optimization of the constraint checking operation is accomplished.

Method For Enforcing Integrity Constraints In A Database Table Using An Index

View page
US Patent:
63048760, Oct 16, 2001
Filed:
Jun 5, 1998
Appl. No.:
9/092683
Inventors:
Amando B. Isip - Richardson TX
Assignee:
Computer Associates Think, Inc. - Islandia NY
International Classification:
G06F 1730
US Classification:
707100
Abstract:
Constraint enforcement identifies rows containing a value violating a constraint. A SQL DELETE statement is generated for each row violating the constraint utilizing an index value associated with each row. Initialization of a CHECK utility performing constraint enforcement includes identifying an index defined for the table to be checked as well as the column name for the index value to facilitate generation of the SQL DELETE statements using the index column name and value. Generating the SQL delete statement utilizing an index value associated with each row in the database table rather than by utilizing the value causing the constraint violation eliminates the need to read the entire database table to execute the DELETE statement.

Method For Repairing Constraint Violations In A Database Management System

View page
US Patent:
61890103, Feb 13, 2001
Filed:
Jun 10, 1998
Appl. No.:
9/095449
Inventors:
Amando B. Isip - Richardson TX
Assignee:
Platinum Technology, Inc. - Oakbrook Terrace IL
International Classification:
G06F 1730
US Classification:
707100
Abstract:
In response to a constraint violation in a row of a database table, an output file is generated including the characteristics of the table containing the row in error as well as an SQL UPDATE statement for the row. The SQL UPDATE statement includes the column values in the row which can be corrected by the user, the user modified SQL UPDATE statement being subsequently executed to repair the constraint violation.

Method For Checking Tablespaces Involved In Referential Integrity

View page
US Patent:
61157228, Sep 5, 2000
Filed:
Dec 9, 1998
Appl. No.:
9/208118
Inventors:
Amando B. Isip - Richardson TX
Christopher F. Parker - Oswego IL
Stephen J. Weaver - Lisle IL
Assignee:
Computer Associates Think, Inc. - Islandia NY
International Classification:
G06F 1730
US Classification:
707202
Abstract:
A recover or reload utility determines if a check utility is to be executed. If a check utility is to be executed, the recover or reload utility records the dependent tablespace names to virtual storage allocated to a job step instead of to virtual storage allocated to a subtask. After the recover or reload utility performs its function, if a check utility is next, the database operating system will not freemain the virtual storage (e. g, data area) into which the recover or reload utility has recorded the names of the dependent tablespaces when the subtask ends. Upon termination of the recover or reload utility, the persistent data area is available for the check utility to use.
Amando B Isip from Cedar Park, TX, age ~77 Get Report