EA200600651A1 - SYSTEM, METHOD AND DEVICE FOR DOWNLOADING TEXT DATA INTO THE DATABASE - Google Patents

SYSTEM, METHOD AND DEVICE FOR DOWNLOADING TEXT DATA INTO THE DATABASE

Info

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
Application number
EA200600651A
Other languages
Russian (ru)
Other versions
EA010400B1 (en
Inventor
Атул Гупта
Амар Сингх
Original Assignee
Шлюмбергер Холдингз Лимитед
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Шлюмбергер Холдингз Лимитед filed Critical Шлюмбергер Холдингз Лимитед
Publication of EA200600651A1 publication Critical patent/EA200600651A1/en
Publication of EA010400B1 publication Critical patent/EA010400B1/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, 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.

EA200600651A 2003-10-01 2004-10-01 A system, a method and an apparatus for importing text data in a database EA010400B1 (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

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