GB2423391A - A system, a method and an apparatus for importing text data in a database - Google Patents

A system, a method and an apparatus for importing text data in a database Download PDF

Info

Publication number
GB2423391A
GB2423391A GB0608392A GB0608392A GB2423391A GB 2423391 A GB2423391 A GB 2423391A GB 0608392 A GB0608392 A GB 0608392A GB 0608392 A GB0608392 A GB 0608392A GB 2423391 A GB2423391 A GB 2423391A
Authority
GB
United Kingdom
Prior art keywords
database
spreadsheet
control file
text data
condition
Prior art date
Legal status (The legal status 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 status listed.)
Withdrawn
Application number
GB0608392A
Other versions
GB0608392D0 (en
Inventor
Atul Gupta
Amar Singh
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Gemalto Terminals Ltd
Schlumberger Holdings Ltd
Original Assignee
Gemalto Terminals Ltd
Schlumberger Holdings Ltd
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 Gemalto Terminals Ltd, Schlumberger Holdings Ltd filed Critical Gemalto Terminals Ltd
Publication of GB0608392D0 publication Critical patent/GB0608392D0/en
Publication of GB2423391A publication Critical patent/GB2423391A/en
Withdrawn legal-status Critical Current

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
    • G06F17/30286—

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 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.

Description

GB 2423391 A continuation (74) Agent and/or Address for Service: (56) cont
D Young & Co RAHM E AND DO H-H: "Data Cleaning: Problems and Holborn, LONDON, EC1N 2DY, Current Approaches" QUARTERLY BULLETIN OFTHE United Kingdom OM PUTER SOCI flY OF THE IEEE TECHNICAL OMMITTEEON DATA ENGINEERING, THE COMMITTEE, WASHINGTON, DC,, US, December 2000 (2000-12), pages 1-11, XP002284896 ISSN: 1053-1238 page 3, line 1 - page 4, line 29
(58) Field of Search by ISA:
NT CL GO6F Other: EPO-Internal database
GB0608392A 2003-10-01 2004-10-01 A system, a method and an apparatus for importing text data in a database Withdrawn GB2423391A (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
GB0608392D0 GB0608392D0 (en) 2006-06-07
GB2423391A true GB2423391A (en) 2006-08-23

Family

ID=34421635

Family Applications (1)

Application Number Title Priority Date Filing Date
GB0608392A Withdrawn GB2423391A (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

Citations (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
US20030130878A1 (en) * 2001-10-23 2003-07-10 Kruk Jeffrey M. System and method for managing spending

Patent Citations (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
US20030130878A1 (en) * 2001-10-23 2003-07-10 Kruk Jeffrey M. System and method for managing spending

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
ANONYMOUS: "ORACLE WAREHOUSE BUILDER: A TECHNICAL OVERVIEW" ORACLE TECHNICAL WHITE PAPER, XX, XX, 2000, pages 1-21, XP002249154 page 7, line 16 - page 7, line 24, page 9, line 21 - page 13, line 4 *
CHAMBERLIN D: "A complete guide to DB2 universal database" COMPLETE GUIDE TO DB2 UNIVERSAL DATABASE, XX, XX, 1998, pages 1-35, page 643, line 1 - page 644, line 28, page 646, line 31 - page 649, line 9 XP002239913 *
RAHM E AND DO H-H: "Data Cleaning: Problems and Current Approaches" QUARTERLY BULLETIN OF THE COMPUTER SOCIETY OF THE IEEE TECHNICAL COMMITTEE ON DATA ENGINEERING, THE COMMITTEE, WASHINGTON, DC,, US, December 2000 (2000-12), pages 1-11, XP002284896 ISSN: 1053-1238 page 3, line 1 - page 4, line 29 *

Also Published As

Publication number Publication date
CA2540812A1 (en) 2005-04-14
EP1671248A1 (en) 2006-06-21
NO20061923L (en) 2006-06-30
MXPA06003684A (en) 2007-03-26
EA200600651A1 (en) 2007-10-26
WO2005033980A1 (en) 2005-04-14
GB0608392D0 (en) 2006-06-07
EA010400B1 (en) 2008-08-29
CA2540812C (en) 2011-01-25
NO339507B1 (en) 2016-12-27

Similar Documents

Publication Publication Date Title
US8380671B2 (en) System and method for creating a new annotation for a data source
EP2570974A1 (en) Automatic crowd sourcing for machine learning in information extraction
CN103810212A (en) Automated database index creation method and system
CN106681739A (en) Method for automatically generating intelligent contract
EP1385100A2 (en) Mapping a class hierarchy to a relational database system
US20090198677A1 (en) Document Comparison Method And Apparatus
US20130007749A1 (en) Method and apparatus for managing a working task based on a communication message
US20040054744A1 (en) Method and apparatus for semantic qualification and contextualization of electronic messages
WO2018097846A1 (en) Edge store designs for graph databases
US20120158742A1 (en) Managing documents using weighted prevalence data for statements
US20180357328A1 (en) Functional equivalence of tuples and edges in graph databases
GB2423391A (en) A system, a method and an apparatus for importing text data in a database
JPH1145284A (en) Preparation method for profile and computer readable recording medium recording program for making computer execute respective processes of the method
EP1383055A2 (en) Map and data location provider
JP2013050896A (en) Faq preparation support system and program
CN110263140B (en) Method and device for mining subject term, electronic equipment and storage medium
JP3980974B2 (en) Schedule information extracting and editing apparatus and method
CN102171696A (en) Producing method and device for ordered material
JP2003150762A (en) Cooperation method for project information and its system
CN113919352A (en) Database sensitive data identification method and device
CN110046352A (en) Address Standardization method and device
JP2001147923A (en) Device and method for retrieving similar document and recording medium
Jessen Special issues involving electronic discovery
Weiser et al. Temporal expressions extraction in sms messages
JP3672473B2 (en) Individual name extraction device, extraction method, and recording medium

Legal Events

Date Code Title Description
APTC Appeals to the court
S1Z Appeal to the court of appeal (novelty of the patent)

Free format text: IN AN ORDER OF THE HIGH COURT DATED 21 JANUARY 2009, THE APPEAL LODGED ON 28 MAY 2008 AGAINST A DECISION OF THE COMPTROLLER DATED 30 APRIL 2008, WAS DISMISSED

WAP Application withdrawn, taken to be withdrawn or refused ** after publication under section 16(1)