WO2004092976A3 - System and method in a data table for exporting and importing recursive scalable templates - Google Patents

System and method in a data table for exporting and importing recursive scalable templates Download PDF

Info

Publication number
WO2004092976A3
WO2004092976A3 PCT/EP2004/003035 EP2004003035W WO2004092976A3 WO 2004092976 A3 WO2004092976 A3 WO 2004092976A3 EP 2004003035 W EP2004003035 W EP 2004003035W WO 2004092976 A3 WO2004092976 A3 WO 2004092976A3
Authority
WO
WIPO (PCT)
Prior art keywords
objects
child
equal
filiation
exporting
Prior art date
Application number
PCT/EP2004/003035
Other languages
French (fr)
Other versions
WO2004092976A2 (en
Inventor
Jean-Jacques Aureglia
Frederic Bauchot
Original Assignee
Ibm
Cie Ibm Framce
Jean-Jacques Aureglia
Frederic Bauchot
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 Ibm, Cie Ibm Framce, Jean-Jacques Aureglia, Frederic Bauchot filed Critical Ibm
Priority to EP04715320A priority Critical patent/EP1618490A2/en
Publication of WO2004092976A2 publication Critical patent/WO2004092976A2/en
Publication of WO2004092976A3 publication Critical patent/WO2004092976A3/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention is directed to a method, system and program for exporting, from a source electronic data table comprising a plurality of objects having parent-child relationships to a destination electronic data table, one or several of objects with their filiation. The method for use in a computer comprises the steps of : defining objects and associating with each object one or a plurality of parent objects or one or a plurality of child objects or both; associating with each object a unique object reference (OR) equal to a prime number; determining for each object whether said object is associated with at least a child object or not : if said object is not associated with at least one child object, defining a filiation reference (FR) equal to 1; if said object is associated with at least one child object, defining a filiation reference (FR) equal to the product of two terms : a first term, equal to the product of each object reference (OR) associated with each child object of said object: a second term equal to the least common multiplier (LCM) of the filiation references of the child objects associated with said object : receiving an export command for exporting one or a plurality of selected objects with associated child objects; associating with each object, a selected children variable (SC) for determining whether or not said object belongs to the set of child objects associated with selected objects, said selected children variable being equal to : a first Boolean value if the least common multiplier (LCM) of the filiation references of the one or plurality of selected objects is a multiple of the own object reference: a second Boolean value if the least common multiplier (LCM) of the filiation references of the one or plurality of selected objects is not a multiple of the own object reference: exporting to the destination data table, the selected objects and the objects with a selected children variable (SC) equal to said first Boolean value.
PCT/EP2004/003035 2003-04-18 2004-02-27 System and method in a data table for exporting and importing recursive scalable templates WO2004092976A2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
EP04715320A EP1618490A2 (en) 2003-04-18 2004-02-27 System and method in a data table for exporting and importing recursive scalable templates

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
EP03368036.4 2003-04-18
EP03368036 2003-04-18

Publications (2)

Publication Number Publication Date
WO2004092976A2 WO2004092976A2 (en) 2004-10-28
WO2004092976A3 true WO2004092976A3 (en) 2005-08-18

Family

ID=33186003

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/EP2004/003035 WO2004092976A2 (en) 2003-04-18 2004-02-27 System and method in a data table for exporting and importing recursive scalable templates

Country Status (3)

Country Link
EP (1) EP1618490A2 (en)
CN (1) CN1774710A (en)
WO (1) WO2004092976A2 (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11023668B2 (en) * 2015-11-02 2021-06-01 Microsoft Technology Licensing, Llc Enriched compound data objects
US10713428B2 (en) 2015-11-02 2020-07-14 Microsoft Technology Licensing, Llc Images associated with cells in spreadsheets
CN107679096B (en) * 2017-09-08 2020-06-05 北京京东尚科信息技术有限公司 Method and device for sharing indexes among data marts
CN107862023B (en) * 2017-10-31 2021-12-24 四川巧夺天工信息安全智能设备有限公司 Method for analyzing data in EDB database source file
CN112163024B (en) * 2020-09-11 2024-03-19 重庆誉存大数据科技有限公司 Configuration information export and import method based on hierarchical association structure
CN112711629B (en) * 2020-12-30 2022-10-21 浙江中控技术股份有限公司 Data and associated data import and export method, device, equipment and storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5033009A (en) * 1989-03-03 1991-07-16 Dubnoff Steven J System for generating worksheet files for electronic spreadsheets
US20010049683A1 (en) * 1997-07-04 2001-12-06 Masazumi Yoshikawa Data calculator performing automatic recalculation based on data structure network
WO2003014987A2 (en) * 2001-08-09 2003-02-20 International Business Machines Corporation Spreadsheet system and method for transferring the content of input cells between scalable template instances

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5033009A (en) * 1989-03-03 1991-07-16 Dubnoff Steven J System for generating worksheet files for electronic spreadsheets
US20010049683A1 (en) * 1997-07-04 2001-12-06 Masazumi Yoshikawa Data calculator performing automatic recalculation based on data structure network
WO2003014987A2 (en) * 2001-08-09 2003-02-20 International Business Machines Corporation Spreadsheet system and method for transferring the content of input cells between scalable template instances

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
DJANG R W ET AL: "Similarity inheritance: a new model of inheritance for spreadsheet VPLs", VISUAL LANGUAGES, 1998. PROCEEDINGS. 1998 IEEE SYMPOSIUM ON HALIFAX, NS, CANADA 1-4 SEPT. 1998, LOS ALAMITOS, CA, USA,IEEE COMPUT. SOC, US, 1 September 1998 (1998-09-01), pages 134 - 141, XP010297367, ISBN: 0-8186-8712-6 *
HENRION: "WHAT'S WRONG WITH SPREADSHEETS - AND HOW TO FIX THEM WITH ANALYTICA", 14 July 2004 (2004-07-14), XP002333472, Retrieved from the Internet <URL:http://www.lumina.com/dlana/papers/Whats%20wrong%20with%20spreadsheets.pdf> [retrieved on 20050624] *
XIAODONG WU ET AL: "A prime number labeling scheme for dynamic ordered XML trees", DATA ENGINEERING, 2004. PROCEEDINGS. 20TH INTERNATIONAL CONFERENCE ON BOSTON, MA, USA 30 MARCH - 2 APRIL 2004, PISCATAWAY, NJ, USA,IEEE, 30 March 2004 (2004-03-30), pages 66 - 78, XP010714273, ISBN: 0-7695-2065-0 *

Also Published As

Publication number Publication date
EP1618490A2 (en) 2006-01-25
WO2004092976A2 (en) 2004-10-28
CN1774710A (en) 2006-05-17

Similar Documents

Publication Publication Date Title
Logendran et al. Group scheduling in flexible flow shops
HK1060632A1 (en) Method and device for producing a fingerprint and method and device for identifying an audio signal
WO2005036351A3 (en) Systems and methods for search processing using superunits
WO2004092974A3 (en) System and method in a data table for managing insertion operations in recursive scalable template instances
WO2004077223A3 (en) Method and apparatus for creating a report
CA2386272A1 (en) Collaborative design
WO2001075790A3 (en) Method, system, and computer program product for representing object relationships in a multidimensional space
CA2232938A1 (en) Method and apparatus for performing a join query in a database system
EP0860786A3 (en) System and method for hierarchically grouping and ranking a set of objects in a query context
TW200511051A (en) Retrieving a replica of an electronic document in a computer network
CA2158153A1 (en) Method and apparatus for configuring systems
WO2004034230A3 (en) A data management interface and related methods
WO2002006919A3 (en) System, method and computer program product for mapping data of multi-database origins
WO2002057926A8 (en) Data transfer and/or transformation system and method
WO2001098874A3 (en) Electronic virtual certification by data processing method via a communication network
EP1182597A3 (en) Electronic sourcing system
WO2004070626A3 (en) System method and computer program product for obtaining structured data from text
WO2002029522A3 (en) Collaborative fulfillment in a distributed supply chain environment
WO2003052560A3 (en) Method and system for leased asset management
WO2003079139A3 (en) System, method, and computer program product for network-based part management system
WO2003040888A3 (en) Method and system for identifying purchasing cost savings
AU2003253561A1 (en) A computer program product and associated methods for searching a database of objects, connecting objects in such a database, and exporting data from at least one arbitrary database
WO2004092976A3 (en) System and method in a data table for exporting and importing recursive scalable templates
WO2000039725A3 (en) System, method and article of manufacture for producing item compatible recommendations
CN110287223A (en) Information storage means and device, electronic device and storage medium

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BW BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE EG ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NA NI NO NZ OM PG PH PL PT RO RU SC SD SE SG SK SL SY TJ TM TN TR TT TZ UA UG US UZ VC VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): BW GH GM KE LS MW MZ SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IT LU MC NL PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

DPEN Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed from 20040101)
121 Ep: the epo has been informed by wipo that ep was designated in this application
WWE Wipo information: entry into national phase

Ref document number: 2004715320

Country of ref document: EP

Ref document number: 20048103924

Country of ref document: CN

WWP Wipo information: published in national office

Ref document number: 2004715320

Country of ref document: EP

WWW Wipo information: withdrawn in national office

Ref document number: 2004715320

Country of ref document: EP