Unisys Corporation

Kung Yi Lin

Subramaniam Ramamurthi

Donald Ralph Hart

Johnny Hu

Minh-Nguyet Tran

Courtney Chi Hoang

Vikki Mei-Whey Lai

Douglas Marshall Tolbert

Alma Navarro De Jesus

Randy Alan Steuckrath

Shawmo Edmund Lin

Jennifer Erin Kays

Alma DeJesus

James Allen Dodds

Valerie Renee Schmidt

Shirley Jean Ritsch

Systems and methods are disclosed that perform dynamic database schema modification. A database system may receive a request to change a schema. In response to receiving the request to perform the dynamic schema modification, the database system may complete pending transactions and begin modifying the database schema. Any requests to access the database received prior to completion of the modification may be paused, thereby allowing the database to remain online and continue receiving requests while the modification is in progress. After completion of the modification, the paused requests may be resumed.

Dynamic modification of database schema

Data on a storage device may be marked as sensitive data and this marked sensitive automatically destroyed (e.g., scrubbed) upon erasure. For example, when sensitive data is erased, new data may be immediately written over the erased sensitive data. To destroy the erased data, random characters and/or a fixed sequence of characters may be written over the erased data. The storage device, the operating system, and/or other software may share tasks related to tracking and scrubbing sensitive data. Scrubbing may include writing a fixed sequence, such as zeroes, or writing random characters of data.

Sensitive data file attribute

Methods and systems are disclosed to perform dynamic disk data redistribution in a database environment. The methods and systems disclosed herein provide for the transparent redistribution of data across multiple physical disks of a database while maintaining accessibility to the database. Methods and systems are also disclosed for handling requests to perform database operations on data that is in the process of being redistributed.

Dynamic disk redistribution

A data management system is provided with a database which has internal tanks for storing large object data according to the size of the data involved. An analysis method and system is provided which will search out and calculate the space of each of the tank files involved and will report on how the space of each tank file is being used in terms of existing large objects, in terms of unused and available space, and in terms of deleted large object spaces.

Method for analyzing status of specialized tank files which store and handle large objects

A specialized server holding a hierarchical database works with a Graphical User Interface to transform a hierarchical schema by utilizing an XMI file which is used with a modeling tool to develop a relational schema for display and use in a relational database in the Graphical User Interface.

Method and system for converting hierarchical database schemas into relational database schemas

An Enterprise Server Data Management System provides for the handling of large data objects (LOB) according to the data size required for the large object. Methods are provided to find a particular object that is stored or to delete such an object. But particularly the method arranges for data storage of Large Objects in a structured database, depending on the number of kilobytes forming the Large Object (LOB).

System and method to manipulate large objects on enterprise server data management system

A method for creating multiple QUIESCE DATABASE Copies (QDC) on a single server by mirroring a disk copy of a live database that is in a quiesced state and splitting them from their source, and then bringing the mirrored disks containing online snapshots back online to the server.

System and method for creating multiple QUIESCE database copies at a single server

A method for providing a program which enables the identification and compatibility of software versions. The method includes the steps of performing a security verification and check to receive server software version. The program then retrieves database creation timestamp and database version, and then returns this information to the client. Finally, the program returns the information about the various software version levels that are residing in multiple databases.

Method for identification of version levels of components across heterogeneous systems while eliminating mis-matched versions

A method for providing a program which executes a sequence for handling a suspended task. The method includes the steps of performing a security check on a mainframe server. The program then detects a response from the suspended task, and then monitors and handles the response. Finally, the program re-activates the suspended task with the response.

Method for handling multiple program exceptions across heterogeneous systems

An on-line primary database is momentarily QUIESCED to enable a physically consistent snapshot of the primary database to be mirrored to a secondary database as a backup while allowing the primary database to continue on servicing multiple user applications.

Growing community of inventors

Irvine, CA, United States of America

Kung Yi Lin