NO20061923L - Method, arrangement and system for importing text data into a database - Google Patents

Method, arrangement and system for importing text data into a database

Info

Publication number
NO20061923L
NO20061923L NO20061923A NO20061923A NO20061923L NO 20061923 L NO20061923 L NO 20061923L NO 20061923 A NO20061923 A NO 20061923A NO 20061923 A NO20061923 A NO 20061923A NO 20061923 L NO20061923 L NO 20061923L
Authority
NO
Norway
Prior art keywords
database
spreadsheet
data
control file
arrangement
Prior art date
Application number
NO20061923A
Other languages
Norwegian (no)
Other versions
NO339507B1 (en
Inventor
Atul Gupta
Amar Singh
Original Assignee
Logined Bv
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 Logined Bv filed Critical Logined Bv
Publication of NO20061923L publication Critical patent/NO20061923L/en
Publication of NO339507B1 publication Critical patent/NO339507B1/en

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

Foreliggende oppfinnelse gjelder en anordning, fremgangsmåte og system for import av data til en database (35). Oppfinnelsen omfatter et regnearkdatasett (20) som har data i form av en eller flere dataposter (21), en styrefil (30) som inneholder et sett regler, idet hver regel (100) har en betingelse og en regnearklaster (10). Regnearkdatasettet og styrefilen tilføres regnearklasteren. Hver regel i styrefilen evalueres for hver datapost for å avgjøre om betingelsen er sann for posten og postene analyseres med hensyn til syntaks dersom betingelsen er sann. Regnearklasteren sender de analyserte data til databasen. Oppfinnelsen omfatter et brukergrensesnitt som letter det å skape styrefilen.The present invention relates to a device, method and system for importing data into a database (35). The invention comprises a spreadsheet dataset (20) having data in the form of one or more data records (21), a control file (30) containing a set of rules, each rule (100) having a condition and a spreadsheet loader (10). The spreadsheet dataset and control file are added to the spreadsheet cluster. Each rule in the control file is evaluated for each data record to determine if the condition is true for the record and the records are analyzed for syntax if the condition is true. The spreadsheet sends the analyzed data to the database. The invention comprises a user interface which facilitates the creation of the control file.

NO20061923A 2003-10-01 2006-04-28 Method, device and system for importing text data into a database NO339507B1 (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
NO20061923L true NO20061923L (en) 2006-06-30
NO339507B1 NO339507B1 (en) 2016-12-27

Family

ID=34421635

Family Applications (1)

Application Number Title Priority Date Filing Date
NO20061923A NO339507B1 (en) 2003-10-01 2006-04-28 Method, device and system for importing text data into 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
EP1500009A4 (en) * 2001-10-23 2006-02-15 Electronic Data Syst Corp System and method for managing contracts using text mining

Also Published As

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

Similar Documents

Publication Publication Date Title
US10817621B2 (en) Anonymization processing device, anonymization processing method, and program
US9202085B2 (en) Private information storage system
Ewers et al. Using landscape history to predict biodiversity patterns in fragmented landscapes
Sutter et al. Nonmetric cranial trait variation and prehistoric biocultural change in the Azapa Valley, Chile
US7177875B2 (en) System and method for creating and using computer databases having schema integrated into data structure
Zaman Optimal campaign in the smoking dynamics
CN109740317A (en) A kind of digital finger-print based on block chain deposits card method and device
Avolio et al. Determinants of community compositional change are equally affected by global change
NO20080375L (en) Generator for electronic data snapshots
US20130226879A1 (en) Detecting Inconsistent Data Records
NO20061923L (en) Method, arrangement and system for importing text data into a database
TWI256556B (en) Distributed concurrent version management system and method
NO20093357L (en) Neural network for use in drilling simulation
NO20093283L (en) Inversion of 4D seismic data
WO2006086146A3 (en) Multi-dimensional surrogates for data management
Donoghue Saving the stem group—a contradiction in terms?
AU2003283448A1 (en) Priorization of management objects
CN102057616B (en) Computer device for the time-based management of digital documents
Oliveira Early epidemic spread, percolation and Covid-19
US20090282083A1 (en) configuration of multiple database audits
US20040139087A1 (en) Method, computer program product and article of manufacture for providing service-to-role assignment to launch application services in role-based computer system
Shin Nikolai Medtner's Forgotten Melodies, Op. 38: Sources, Analysis, and Interpretation
Liu et al. Infectiousness of places–Impact of multiscale human activity places in the transmission of COVID-19
DE602005024118D1 (en) VERIFICATION OF IDENTITY BASED SIGNATURES
Devine et al. The development and sensitivity analysis of the 2010 demographic analysis estimates

Legal Events

Date Code Title Description
MM1K Lapsed by not paying the annual fees