Edition-based redefinition for tables

    公开(公告)号:US09715516B1

    公开(公告)日:2017-07-25

    申请号:US14084356

    申请日:2013-11-19

    CPC classification number: G06F17/30339 G06F8/65 G06F8/656

    Abstract: Embodiments of the present invention are directed to an improved apparatus, system and method of edition-based redefinition for tables. When a new edition of an application is created, editions on the tables pertaining to the application are created. These tables typically store application configuration/reference data that control what the application does. These tables are altered to contain a new “edition” column. Keys on these tables include the “edition” column. Each table is partitioned on the “edition” column such that cleaning up data used by an edition is easy. Views are created on these tables, which make the “edition” column invisible by the application while ensuring that only data that can be accessed is the data for the correct edition. The current “edition” of the application stays fully operational while the application is upgraded because the configuration data in the tables does not change until the new “edition” is turned on.

Patent Agency Ranking