发明授权
US07490093B2 Generating a schema-specific load structure to load data into a relational database based on determining whether the schema-specific load structure already exists
有权
基于确定模式特定的负载结构是否已经存在,生成模式特定的负载结构以将数据加载到关系数据库中
- 专利标题: Generating a schema-specific load structure to load data into a relational database based on determining whether the schema-specific load structure already exists
- 专利标题(中): 基于确定模式特定的负载结构是否已经存在,生成模式特定的负载结构以将数据加载到关系数据库中
-
申请号: US10718823申请日: 2003-11-21
-
公开(公告)号: US07490093B2公开(公告)日: 2009-02-10
- 发明人: Namit Jain , Nipun Agarwal , Ravi Murthy
- 申请人: Namit Jain , Nipun Agarwal , Ravi Murthy
- 申请人地址: US CA Redwood Shores
- 专利权人: Oracle International Corporation
- 当前专利权人: Oracle International Corporation
- 当前专利权人地址: US CA Redwood Shores
- 代理机构: Bingham McCutchen LLP
- 主分类号: G06F17/00
- IPC分类号: G06F17/00 ; G06F17/30
摘要:
Described is a method and system for storing data into a database, where a determination is made if schema metadata that is used to load the data into the database already exists, and where the existing schema metadata is used to load the data into the database if the schema metadata already exists. If the appropriate schema metadata does not exist, then it is generated and cached so that a later load operation for the same schema type will not need to re-generate this information. In this way, the cost to generate the schema metadata is amortized over multiple load operations to load data of the same schema type. The approach is protocol neutral so that multiple different protocol-based loads can operate with the same schema metadata information and load structures.
公开/授权文献
- US20050050074A1 Efficient loading of data into a relational database 公开/授权日:2005-03-03