-
公开(公告)号:US20130007069A1
公开(公告)日:2013-01-03
申请号:US13206316
申请日:2011-08-09
申请人: Kishore R. Chaliparambil , Chi Kit Chan , Imran Mohiuddin , Bryan Dove , Mehul Y. Shah , Umesh Madan , Ali Emami , Robert A. May , Eric Gunnerson
发明人: Kishore R. Chaliparambil , Chi Kit Chan , Imran Mohiuddin , Bryan Dove , Mehul Y. Shah , Umesh Madan , Ali Emami , Robert A. May , Eric Gunnerson
IPC分类号: G06F17/30
摘要: The described implementations relate to updating views in a database system. One implementation can identify an active view that retrieves records from a database and determine one or more physical tables in the database that are referenced by the active view. The implementation can track one or more columns in the physical tables that are used by the active view and identify a change to the physical tables in a transaction log of the database. If the change does not affect the one or more columns, the change can be treated as an ignorable change for the active view.
-
公开(公告)号:US08818944B2
公开(公告)日:2014-08-26
申请号:US13172889
申请日:2011-06-30
申请人: Kishore R. Chaliparambil , Chi Kit Chan , Imran Mohiuddin , Bryan Dove , Mehul Y. Shah , Umesh Madan , Ali Emami , Robert A. May , Eric Gunnerson
发明人: Kishore R. Chaliparambil , Chi Kit Chan , Imran Mohiuddin , Bryan Dove , Mehul Y. Shah , Umesh Madan , Ali Emami , Robert A. May , Eric Gunnerson
IPC分类号: G06F17/30
摘要: The described implementations relate to updating views in a database system. One implementation can identify an active view that retrieves records from a database and determine one or more physical tables in the database that are referenced by the active view. The implementation can track one or more columns in the physical tables that are used by the active view and identify a change to the physical tables in a transaction log of the database. If the change does not affect the one or more columns, the change can be treated as an ignorable change for the active view.
摘要翻译: 所描述的实现涉及更新数据库系统中的视图。 一个实现可以标识从数据库检索记录并确定数据库中由活动视图引用的一个或多个物理表的活动视图。 该实现可以跟踪活动视图使用的物理表中的一个或多个列,并标识对数据库的事务日志中的物理表的更改。 如果更改不影响一个或多个列,则更改可以被视为活动视图的可忽略的更改。
-
公开(公告)号:US20130006963A1
公开(公告)日:2013-01-03
申请号:US13172889
申请日:2011-06-30
申请人: Kishore R. Chaliparambil , Chi Kit Chan , Imran Mohiuddin , Bryan Dove , Mehul Y. Shah , Umesh Madan , Ali Emami , Robert A. May , Eric Gunnerson
发明人: Kishore R. Chaliparambil , Chi Kit Chan , Imran Mohiuddin , Bryan Dove , Mehul Y. Shah , Umesh Madan , Ali Emami , Robert A. May , Eric Gunnerson
IPC分类号: G06F17/30
摘要: The described implementations relate to updating views in a database system. One implementation can identify an active view that retrieves records from a database and determine one or more physical tables in the database that are referenced by the active view. The implementation can track one or more columns in the physical tables that are used by the active view and identify a change to the physical tables in a transaction log of the database. If the change does not affect the one or more columns, the change can be treated as an ignorable change for the active view.
摘要翻译: 所描述的实现涉及更新数据库系统中的视图。 一个实现可以标识从数据库检索记录并确定数据库中由活动视图引用的一个或多个物理表的活动视图。 该实现可以跟踪活动视图使用的物理表中的一个或多个列,并标识对数据库的事务日志中的物理表的更改。 如果更改不影响一个或多个列,则更改可以被视为活动视图的可忽略的更改。
-
公开(公告)号:US08972459B2
公开(公告)日:2015-03-03
申请号:US13206316
申请日:2011-08-09
申请人: Kishore R. Chaliparambil , Chi Kit Chan , Imran Mohiuddin , Bryan Dove , Mehul Y. Shah , Umesh Madan , Ali Emami , Robert A. May , Eric Gunnerson
发明人: Kishore R. Chaliparambil , Chi Kit Chan , Imran Mohiuddin , Bryan Dove , Mehul Y. Shah , Umesh Madan , Ali Emami , Robert A. May , Eric Gunnerson
摘要: The described implementations relate to updating views in a database system. One implementation can identify an active view that retrieves records from a database and determine one or more physical tables in the database that are referenced by the active view. The implementation can track one or more columns in the physical tables that are used by the active view and identify a change to the physical tables in a transaction log of the database. If the change does not affect the one or more columns, the change can be treated as an ignorable change for the active view.
摘要翻译: 所描述的实现涉及更新数据库系统中的视图。 一个实现可以标识从数据库检索记录并确定数据库中由活动视图引用的一个或多个物理表的活动视图。 该实现可以跟踪活动视图使用的物理表中的一个或多个列,并标识对数据库的事务日志中的物理表的更改。 如果更改不影响一个或多个列,则更改可以被视为活动视图的可忽略的更改。
-
公开(公告)号:US20130006664A1
公开(公告)日:2013-01-03
申请号:US13206365
申请日:2011-08-09
申请人: Kishore R. Chaliparambil , Chi Kit Chan , Imran Mohiuddin , Bryan Dove , Mehul Y. Shah , Umesh Madan , Ali Emami , Robert A. May , Eric Gunnerson
发明人: Kishore R. Chaliparambil , Chi Kit Chan , Imran Mohiuddin , Bryan Dove , Mehul Y. Shah , Umesh Madan , Ali Emami , Robert A. May , Eric Gunnerson
IPC分类号: G06Q50/00
摘要: The described implementations relate to updating views in a database system. One implementation can identify an active view that retrieves records from a database and determine one or more physical tables in the database that are referenced by the active view. The implementation can track one or more columns in the physical tables that are used by the active view and identify a change to the physical tables in a transaction log of the database. If the change does not affect the one or more columns, the change can be treated as an ignorable change for the active view.
摘要翻译: 所描述的实现涉及更新数据库系统中的视图。 一个实现可以标识从数据库检索记录并确定数据库中由活动视图引用的一个或多个物理表的活动视图。 该实现可以跟踪活动视图使用的物理表中的一个或多个列,并标识对数据库的事务日志中的物理表的更改。 如果更改不影响一个或多个列,则更改可以被视为活动视图的可忽略的更改。
-
公开(公告)号:US20110320433A1
公开(公告)日:2011-12-29
申请号:US12823145
申请日:2010-06-25
申请人: Imran Mohiuddin , Mahmood Gulam Qadir , Yi Miao , Bryan Jason Dove , Jonathan Alan Handler , Craig F. Feied , Mehul Y. Shah
发明人: Imran Mohiuddin , Mahmood Gulam Qadir , Yi Miao , Bryan Jason Dove , Jonathan Alan Handler , Craig F. Feied , Mehul Y. Shah
IPC分类号: G06F17/30
CPC分类号: G06F16/24535
摘要: Described is associating metadata with different sources of data (e.g., database tables) that allows a single view of data from the sources to be created. An administrator creates baseviews corresponding to database tables and associates metadata with the baseviews, including primary key metadata for the baseviews and meta-tags for one or more of the columns of each baseview. A user selects fields (corresponding to table columns) from a starting baseview, along with fields from any other baseview that has metadata that matches the starting baseview's metadata. A join mechanism automatically creates the view if a metadata match is detected.
摘要翻译: 描述了将元数据与不同的数据源(例如,数据库表)相关联,其允许创建来自源的单个数据视图。 管理员创建与数据库表相对应的基本视图,并将元数据与基本视图相关联,包括基本视图的主键元数据和每个基本视图的一个或多个列的元标记。 用户从起始基本视图中选择字段(对应于表列),以及来自任何其他具有与起始基本视图元数据匹配的元数据的基本视图的字段。 如果检测到元数据匹配,连接机制将自动创建视图。
-
-
-
-
-