Kenneth Ziervogel

US Patent:

20050114404, May 26, 2005

Filed:

Nov 21, 2003

Appl. No.:

10/718863

Inventors:

Kevin Pintar - Round Rock TX, US
Kenneth Ziervogel - Cedar Park TX, US
James Magill - Cedar Creek TX, US

Assignee:

BMC Software, Inc. - Houston TX

International Classification:

G06F012/00

US Classification:

707200000

Abstract:

Techniques to extract, or unload, data from a database table based on a specific version of the table are described. Modern database management systems permit a user to change a databases' table structure or schema in response to changing operating conditions without blocking users' access to the underlying table or its data. Once modified, these database management systems permit data retrieval only in terms of a table's most recent version. Applications written to process a table's data in a first version may not be able to process data when that data is conformed to a later version. By providing a means to extract data from a table based on prior versions of that table, the invention permits users to evolve their database structure as needs require, while maintaining the ability to unload data for historical applications.