EA200600651A1 - SYSTEM, METHOD AND DEVICE FOR DOWNLOADING TEXT DATA INTO THE DATABASE - Google Patents
SYSTEM, METHOD AND DEVICE FOR DOWNLOADING TEXT DATA INTO THE DATABASEInfo
- Publication number
- EA200600651A1 EA200600651A1 EA200600651A EA200600651A EA200600651A1 EA 200600651 A1 EA200600651 A1 EA 200600651A1 EA 200600651 A EA200600651 A EA 200600651A EA 200600651 A EA200600651 A EA 200600651A EA 200600651 A1 EA200600651 A1 EA 200600651A1
- Authority
- EA
- Eurasian Patent Office
- Prior art keywords
- database
- spreadsheet
- control file
- data
- condition
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
Настоящее изобретение включает в себя устройство, способ и систему для загрузки данных в базу данных. Изобретение включает в себя набор данных электронной таблицы с данными в форме одной или более записей, управляющий файл, содержащий набор правил, причем каждое правило содержит условие, и загрузчик электронной таблицы. Набор данных электронной таблицы и управляющий файл являются входными данными для загрузчика электронной таблицы. Каждое правило и управляющий файл вычисляются для каждой записи, чтобы определить, истинно ли условие для записи, и, если условие истинно, выполняется разбор записей. Загрузчик электронной таблицы направляет разобранные данные в базу данных. Изобретение включает в себя пользовательский интерфейс, чтобы облегчить создание управляющего файла.The present invention includes a device, method and system for loading data into a database. The invention includes a data set of a spreadsheet with data in the form of one or more records, a control file containing a set of rules, each rule contains a condition, and a spreadsheet loader. The spreadsheet dataset and control file are input to the spreadsheet loader. Each rule and control file is evaluated for each record to determine if the condition for the record is true, and, if the condition is true, the records are parsed. The spreadsheet loader sends the parsed data to the database. The invention includes a user interface to facilitate the creation of a control file.
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US50757603P | 2003-10-01 | 2003-10-01 | |
PCT/US2004/032188 WO2005033980A1 (en) | 2003-10-01 | 2004-10-01 | A system, a method and an apparatus for importing text data in a database |
Publications (2)
Publication Number | Publication Date |
---|---|
EA200600651A1 true EA200600651A1 (en) | 2007-10-26 |
EA010400B1 EA010400B1 (en) | 2008-08-29 |
Family
ID=34421635
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
EA200600651A EA010400B1 (en) | 2003-10-01 | 2004-10-01 | A system, a method and an apparatus for importing text data in a database |
Country Status (7)
Country | Link |
---|---|
EP (1) | EP1671248A1 (en) |
CA (1) | CA2540812C (en) |
EA (1) | EA010400B1 (en) |
GB (1) | GB2423391A (en) |
MX (1) | MXPA06003684A (en) |
NO (1) | NO339507B1 (en) |
WO (1) | WO2005033980A1 (en) |
Families Citing this family (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7685152B2 (en) | 2006-01-10 | 2010-03-23 | International Business Machines Corporation | Method and apparatus for loading data from a spreadsheet to a relational database table |
US7849108B1 (en) * | 2007-03-13 | 2010-12-07 | Fundriver, Inc. | Methods and systems for establishing a database |
US9922295B2 (en) * | 2008-01-17 | 2018-03-20 | International Business Machines Corporation | Method for evolving shared to-do lists into business processes |
US9626392B2 (en) * | 2013-03-29 | 2017-04-18 | Schlumberger Technology Corporation | Context transfer for data storage |
US9489386B2 (en) | 2014-03-19 | 2016-11-08 | International Business Machines Corporation | Inferred operations for data analysis |
Family Cites Families (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020046248A1 (en) * | 2000-10-13 | 2002-04-18 | Honeywell International Inc. | Email to database import utility |
WO2003036847A2 (en) * | 2001-10-23 | 2003-05-01 | Electronic Data Systems Corporation | System and method for managing compliance with strategic business rules |
-
2004
- 2004-10-01 EA EA200600651A patent/EA010400B1/en not_active IP Right Cessation
- 2004-10-01 WO PCT/US2004/032188 patent/WO2005033980A1/en active Application Filing
- 2004-10-01 EP EP04793918A patent/EP1671248A1/en not_active Ceased
- 2004-10-01 GB GB0608392A patent/GB2423391A/en not_active Withdrawn
- 2004-10-01 CA CA2540812A patent/CA2540812C/en not_active Expired - Fee Related
- 2004-10-01 MX MXPA06003684A patent/MXPA06003684A/en active IP Right Grant
-
2006
- 2006-04-28 NO NO20061923A patent/NO339507B1/en not_active IP Right Cessation
Also Published As
Publication number | Publication date |
---|---|
NO20061923L (en) | 2006-06-30 |
GB0608392D0 (en) | 2006-06-07 |
WO2005033980A1 (en) | 2005-04-14 |
GB2423391A (en) | 2006-08-23 |
CA2540812A1 (en) | 2005-04-14 |
EA010400B1 (en) | 2008-08-29 |
CA2540812C (en) | 2011-01-25 |
EP1671248A1 (en) | 2006-06-21 |
NO339507B1 (en) | 2016-12-27 |
MXPA06003684A (en) | 2007-03-26 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
Baltes et al. | Sotorrent: reconstructing and analyzing the evolution of stack overflow posts | |
AU2018272840B2 (en) | Automated dependency analyzer for heterogeneously programmed data processing system | |
CN105808284B (en) | A kind of method for updating increment and the server using it | |
CN100535894C (en) | Database object script generation method and system | |
CN101727320B (en) | Methods and tools for identifying impact of database changes on an application | |
CN102810057B (en) | A kind of method of log | |
CN100520775C (en) | Integrating best practices into database design | |
SE0300833D0 (en) | A device for restoring at least one of files, directories and application oriented files in a computer to previous state | |
JP2011512571A5 (en) | ||
Buffalo | Bioinformatics data skills: Reproducible and robust research with open source tools | |
US9208322B1 (en) | Privacy leak detection in .NET framework | |
CN104537012B (en) | Data processing method and device | |
US20100242027A1 (en) | Identifying groups and subgroups | |
EA200600651A1 (en) | SYSTEM, METHOD AND DEVICE FOR DOWNLOADING TEXT DATA INTO THE DATABASE | |
WO2005062779A3 (en) | System and method for information creation, management and publication of documentation from a single source | |
KR100840844B1 (en) | System and its method for searching private information stored in user's terminal | |
KR20060078095A (en) | Method for weaving code fragments using code fragment numbering from programs | |
JP2005339549A (en) | Method and system for wrapping data | |
Risch et al. | Measuring and facilitating data repeatability in web science | |
CN102279735A (en) | Implementation method for integration of file management software and application software | |
CN104298698B (en) | Data management apparatus and data managing method | |
Ghaderi et al. | mHealth platform for breast cancer risk assessment | |
Jakus et al. | Grand Staircase Escalante Economic Effects Data | |
Chikwanda et al. | Call center management systems | |
Bazzicalupo et al. | Data from: Over the hills, but how far away? estimates of mushroom geographic range extents |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
MM4A | Lapse of a eurasian patent due to non-payment of renewal fees within the time limit in the following designated state(s) |
Designated state(s): AM BY KG MD TJ |
|
MM4A | Lapse of a eurasian patent due to non-payment of renewal fees within the time limit in the following designated state(s) |
Designated state(s): AZ KZ TM RU |