International Business Machines Corporation

Informix Software, Inc.

Kevin B Mayfield

Christopher W Maloney

Brian D Jackson

Srinivasa Bhagavan

Kent A Tracy

Nelson R Corcoran

Mark A Mills

A system and method are used for updating software to include new versions of the software without losing the ability to return to the prior software in the event of flaws or deficiencies in the new version. A framework organizes conversion and reversion codes into major components responsible for conversion of the data entities. The components are ordered based on their dependence on other components first completing their conversions. Each component implements an interface allowing a framework to process sequentially through all components and sequentially retrieve handles for their respective entities, and accessing the version of the entity. The framework processes an ordered set of interfaces representing the conversion/reversion, checks for progressively newer versions. As data structures are changed for a single component, a new version is appended to that component's ordered set of version interfaces. Restart of a conversion or reversion following an interrupt is also provided.

Data migration between versions of software

Logical schemas are used to allow an end user the ability to access and manipulate relational database data without knowledge of the structure of the relational database. A logical schema is first created specifying which tables are available to an end user, and the relationships between columns of those tables. The logical schema defines a structure for the data fields having a master level and a plurality of detail levels. An end user may manipulate the logical schema using a graphical interface to build customized forms, reports, and queries. An end user is not required to be familiar with a database query language, such as SQL, or the structure of the relational database.

Logical schema to allow access to a relational database without using

Growing community of inventors

Lenexa, KS, United States of America

Kevin B Mayfield