发明授权
US07542979B2 System, method and apparatus for loading text data in a database
有权
用于在数据库中加载文本数据的系统,方法和装置
- 专利标题: System, method and apparatus for loading text data in a database
- 专利标题(中): 用于在数据库中加载文本数据的系统,方法和装置
-
申请号: US10956665申请日: 2004-10-01
-
公开(公告)号: US07542979B2公开(公告)日: 2009-06-02
- 发明人: Atul Gupta , Amar Singh
- 申请人: Atul Gupta , Amar Singh
- 申请人地址: US TX Houston
- 专利权人: Schlumberger Technology Corporation
- 当前专利权人: Schlumberger Technology Corporation
- 当前专利权人地址: US TX Houston
- 代理机构: Osha Liang LLP
- 代理商 Bryan P. Galloway
- 主分类号: G06F17/00
- IPC分类号: G06F17/00
摘要:
The present invention includes an apparatus, method and system for loading data into a database. The invention includes a spreadsheet dataset, having data in the form of one or more records, a control file containing a set of rules, each rule having a condition and a spreadsheet loader. The spreadsheet dataset and the control file are inputs to the spreadsheet loader. Each rule in the control file is evaluated for each record to determine if the condition is true for the record, and the records are parsed if the condition is true. The spreadsheet loader sends the parsed data to the database. The invention includes a user interface to facilitate creation of the control file.
公开/授权文献
信息查询