EP1580671A3 - Data mapping with nested tables - Google Patents
Data mapping with nested tables Download PDFInfo
- Publication number
- EP1580671A3 EP1580671A3 EP05102141A EP05102141A EP1580671A3 EP 1580671 A3 EP1580671 A3 EP 1580671A3 EP 05102141 A EP05102141 A EP 05102141A EP 05102141 A EP05102141 A EP 05102141A EP 1580671 A3 EP1580671 A3 EP 1580671A3
- Authority
- EP
- European Patent Office
- Prior art keywords
- path
- parent
- spreadsheet list
- payload data
- branch bottom
- 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.)
- Ceased
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/10—Complex mathematical operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/103—Formatting, i.e. changing of presentation of documents
- G06F40/117—Tagging; Marking up; Designating a block; Setting of attributes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/131—Fragmentation of text files, e.g. creating reusable text-blocks; Linking to fragments, e.g. using XInclude; Namespaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/14—Tree-structured documents
- G06F40/143—Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
-
- 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
Abstract
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/805,896 US20050172217A1 (en) | 2004-02-04 | 2004-03-22 | System and method for schemaless data mapping with nested tables |
US805896 | 2004-03-22 |
Publications (2)
Publication Number | Publication Date |
---|---|
EP1580671A2 EP1580671A2 (en) | 2005-09-28 |
EP1580671A3 true EP1580671A3 (en) | 2006-06-28 |
Family
ID=34862024
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
EP05102141A Ceased EP1580671A3 (en) | 2004-03-22 | 2005-03-18 | Data mapping with nested tables |
Country Status (18)
Country | Link |
---|---|
US (2) | US20050172217A1 (en) |
EP (1) | EP1580671A3 (en) |
JP (1) | JP4711708B2 (en) |
KR (1) | KR101122841B1 (en) |
CN (1) | CN100435143C (en) |
AU (1) | AU2005200999B2 (en) |
BR (1) | BRPI0501150A (en) |
CA (1) | CA2501608A1 (en) |
CO (1) | CO5680122A1 (en) |
IL (1) | IL167313A (en) |
MX (1) | MXPA05003138A (en) |
MY (1) | MY154396A (en) |
NO (1) | NO333083B1 (en) |
NZ (1) | NZ538934A (en) |
RU (1) | RU2370808C2 (en) |
SG (1) | SG115773A1 (en) |
TW (1) | TWI353527B (en) |
ZA (1) | ZA200502315B (en) |
Families Citing this family (25)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8126889B2 (en) | 2002-03-28 | 2012-02-28 | Telecommunication Systems, Inc. | Location fidelity adjustment based on mobile subscriber privacy profile |
US9460129B2 (en) | 2013-10-01 | 2016-10-04 | Vmware, Inc. | Method for tracking a schema in a schema-less database |
US20050172217A1 (en) * | 2004-02-04 | 2005-08-04 | Yiu-Ming Leung | System and method for schemaless data mapping with nested tables |
US6985105B1 (en) | 2004-10-15 | 2006-01-10 | Telecommunication Systems, Inc. | Culled satellite ephemeris information based on limiting a span of an inverted cone for locating satellite in-range determinations |
US7836104B2 (en) * | 2005-06-03 | 2010-11-16 | Sap Ag | Demonstration tool for a business information enterprise system |
US7825780B2 (en) | 2005-10-05 | 2010-11-02 | Telecommunication Systems, Inc. | Cellular augmented vehicle alarm notification together with location services for position of an alarming vehicle |
US7899450B2 (en) * | 2006-03-01 | 2011-03-01 | Telecommunication Systems, Inc. | Cellular augmented radar/laser detection using local mobile network within cellular network |
US9167553B2 (en) | 2006-03-01 | 2015-10-20 | Telecommunication Systems, Inc. | GeoNexus proximity detector network |
US9330149B2 (en) * | 2007-12-18 | 2016-05-03 | Oracle International Corporation | Techniques for query and DML over relational tables using spreadsheet applications |
US8001155B2 (en) * | 2008-06-20 | 2011-08-16 | Microsoft Corporation | Hierarchically presenting tabular data |
US20090327213A1 (en) * | 2008-06-25 | 2009-12-31 | Microsoft Corporation | Document index for handheld application navigation |
WO2010044837A1 (en) | 2008-10-14 | 2010-04-22 | Telecommunication Systems, Inc. | Location based proximity alert |
US8892128B2 (en) | 2008-10-14 | 2014-11-18 | Telecommunication Systems, Inc. | Location based geo-reminders |
US8423512B2 (en) * | 2009-09-08 | 2013-04-16 | Oracle International Corporation | Leveraging XML capabilities of a database to enhance handling of document data |
US8365066B2 (en) * | 2010-02-09 | 2013-01-29 | Konica Minolta Laboratory U.S.A., Inc. | Systems and methods for processing markup language specified spreadsheet styles |
US8359308B2 (en) * | 2010-04-01 | 2013-01-22 | Microsoft Corporation | Inline data correlation and hierarchical datasets |
US8315599B2 (en) | 2010-07-09 | 2012-11-20 | Telecommunication Systems, Inc. | Location privacy selector |
US8649806B2 (en) | 2011-09-02 | 2014-02-11 | Telecommunication Systems, Inc. | Aggregate location dynometer (ALD) |
US10546057B2 (en) * | 2011-10-28 | 2020-01-28 | Microsoft Technology Licensing, Llc | Spreadsheet program-based data classification for source target mapping |
US20130311864A1 (en) * | 2012-05-16 | 2013-11-21 | N. Nagaraj | Intelligent and robust context based XML data parsing from spreadsheets |
US10191955B2 (en) * | 2013-03-13 | 2019-01-29 | Microsoft Technology Licensing, Llc | Detection and visualization of schema-less data |
CN105069542A (en) * | 2015-06-25 | 2015-11-18 | 中铁四局集团有限公司 | Responsibility cost budget drafting method and system |
CN104881762A (en) * | 2015-06-25 | 2015-09-02 | 中铁四局集团有限公司 | Engineering quantity list decomposition method and system |
CN104978307A (en) * | 2015-06-25 | 2015-10-14 | 中铁四局集团有限公司 | List processing method and apparatus |
CN116050362B (en) * | 2023-03-23 | 2023-07-04 | 青岛诺亚信息技术有限公司 | Web form dynamic data binding method, medium and system |
Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6502101B1 (en) * | 2000-07-13 | 2002-12-31 | Microsoft Corporation | Converting a hierarchical data structure into a flat data structure |
Family Cites Families (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
NZ239657A (en) | 1991-09-03 | 1995-07-26 | Norman Michael Rorke | Transferring data from database to spreadsheet file cells |
WO2000023915A1 (en) | 1998-10-16 | 2000-04-27 | Commontown Pte Ltd | A virtual space |
US6920608B1 (en) * | 1999-05-21 | 2005-07-19 | E Numerate Solutions, Inc. | Chart view for reusable data markup language |
US6631497B1 (en) * | 1999-07-19 | 2003-10-07 | International Business Machines Corporation | Binding data from data source to cells in a spreadsheet |
US6766330B1 (en) * | 1999-10-19 | 2004-07-20 | International Business Machines Corporation | Universal output constructor for XML queries universal output constructor for XML queries |
US6941510B1 (en) * | 2000-06-06 | 2005-09-06 | Groove Networks, Inc. | Method and apparatus for efficient management of XML documents |
US6941511B1 (en) * | 2000-08-31 | 2005-09-06 | International Business Machines Corporation | High-performance extensible document transformation |
US6804677B2 (en) * | 2001-02-26 | 2004-10-12 | Ori Software Development Ltd. | Encoding semi-structured data for efficient search and browsing |
US6947947B2 (en) * | 2001-08-17 | 2005-09-20 | Universal Business Matrix Llc | Method for adding metadata to data |
AU2002334721B2 (en) * | 2001-09-28 | 2008-10-23 | Oracle International Corporation | An index structure to access hierarchical data in a relational database system |
US6925470B1 (en) * | 2002-01-25 | 2005-08-02 | Amphire Solutions, Inc. | Method and apparatus for database mapping of XML objects into a relational database |
US20030188264A1 (en) * | 2002-03-29 | 2003-10-02 | Full Degree, Inc. | Method and apparatus for XML data normalization |
US7457810B2 (en) * | 2002-05-10 | 2008-11-25 | International Business Machines Corporation | Querying markup language data sources using a relational query processor |
US7017112B2 (en) * | 2003-02-28 | 2006-03-21 | Microsoft Corporation | Importing and exporting markup language data in a spreadsheet application document |
US7421646B1 (en) * | 2004-02-04 | 2008-09-02 | Microsoft Corporation | System and method for schemaless data mapping |
US20050172217A1 (en) * | 2004-02-04 | 2005-08-04 | Yiu-Ming Leung | System and method for schemaless data mapping with nested tables |
-
2004
- 2004-03-22 US US10/805,896 patent/US20050172217A1/en not_active Abandoned
-
2005
- 2005-03-04 AU AU2005200999A patent/AU2005200999B2/en not_active Ceased
- 2005-03-07 TW TW094106847A patent/TWI353527B/en not_active IP Right Cessation
- 2005-03-08 IL IL167313A patent/IL167313A/en not_active IP Right Cessation
- 2005-03-09 SG SG200501674A patent/SG115773A1/en unknown
- 2005-03-16 MY MYPI20051103A patent/MY154396A/en unknown
- 2005-03-17 CO CO05025183A patent/CO5680122A1/en not_active Application Discontinuation
- 2005-03-18 ZA ZA200502315A patent/ZA200502315B/en unknown
- 2005-03-18 NZ NZ538934A patent/NZ538934A/en not_active IP Right Cessation
- 2005-03-18 MX MXPA05003138A patent/MXPA05003138A/en active IP Right Grant
- 2005-03-18 JP JP2005080091A patent/JP4711708B2/en not_active Expired - Fee Related
- 2005-03-18 EP EP05102141A patent/EP1580671A3/en not_active Ceased
- 2005-03-21 NO NO20051482A patent/NO333083B1/en not_active IP Right Cessation
- 2005-03-21 CA CA002501608A patent/CA2501608A1/en not_active Abandoned
- 2005-03-21 CN CNB2005100590955A patent/CN100435143C/en not_active Expired - Fee Related
- 2005-03-21 RU RU2005107873/02A patent/RU2370808C2/en not_active IP Right Cessation
- 2005-03-22 BR BR0501150-7A patent/BRPI0501150A/en not_active IP Right Cessation
- 2005-03-22 KR KR1020050023677A patent/KR101122841B1/en not_active IP Right Cessation
-
2007
- 2007-01-03 US US11/649,460 patent/US8584003B2/en not_active Expired - Fee Related
Patent Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6502101B1 (en) * | 2000-07-13 | 2002-12-31 | Microsoft Corporation | Converting a hierarchical data structure into a flat data structure |
Non-Patent Citations (3)
Title |
---|
JOHN R. DURANT: "Importing XML Maps, XML Lists, and Dynamic Chart Sources in Excel 2003", 2003, Online, XP002380149, Retrieved from the Internet <URL:http://web.archive.org/web/20031214103720/http://msdn.microsoft.com/office/understanding/excel/technicalarticles/default.aspx?pull=/library/en-us/odc_xl2003_ta/html/odc_xmllists.asp> [retrieved on 20060508] * |
KUNICKI C: "XML in Office XP: Part I", ONLINE, May 2001 (2001-05-01), XP002278863 * |
RICE F C: "Transform XML Files with XSLT When Importing into Microsoft Excel 2002", ONLINE, July 2001 (2001-07-01), XP002366506 * |
Also Published As
Publication number | Publication date |
---|---|
BRPI0501150A (en) | 2005-11-01 |
AU2005200999B2 (en) | 2010-05-20 |
RU2370808C2 (en) | 2009-10-20 |
US20070124318A1 (en) | 2007-05-31 |
US8584003B2 (en) | 2013-11-12 |
CO5680122A1 (en) | 2006-09-29 |
JP4711708B2 (en) | 2011-06-29 |
NO20051482L (en) | 2005-09-23 |
MXPA05003138A (en) | 2005-10-05 |
EP1580671A2 (en) | 2005-09-28 |
IL167313A (en) | 2014-01-30 |
KR101122841B1 (en) | 2012-03-22 |
MY154396A (en) | 2015-06-15 |
CN100435143C (en) | 2008-11-19 |
NO333083B1 (en) | 2013-02-25 |
TW200540651A (en) | 2005-12-16 |
AU2005200999A1 (en) | 2005-10-06 |
RU2005107873A (en) | 2006-10-10 |
CA2501608A1 (en) | 2005-09-22 |
NO20051482D0 (en) | 2005-03-21 |
JP2005302008A (en) | 2005-10-27 |
NZ538934A (en) | 2007-05-31 |
US20050172217A1 (en) | 2005-08-04 |
SG115773A1 (en) | 2005-10-28 |
KR20060044561A (en) | 2006-05-16 |
CN1677398A (en) | 2005-10-05 |
TWI353527B (en) | 2011-12-01 |
ZA200502315B (en) | 2006-12-27 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
EP1580671A3 (en) | Data mapping with nested tables | |
EP1580669A3 (en) | Dynamic reference repository | |
ZA202006547B (en) | Molecule having pesticidal utility, and compositions, and processes, related thereto | |
WO2006133050A3 (en) | Relationship networks | |
EP1871109A3 (en) | Sub-frame metadata distribution server | |
WO2006130540A3 (en) | Content distribution to wireless clients with differentiated pricing | |
EP1605367A3 (en) | Method,system, and apparatus for making available workbook ranges as data sources | |
WO2007014341A3 (en) | Patent mapping | |
EP1679588A3 (en) | Prescribed navigation using topology metadata and navigation path | |
EP2146274A3 (en) | Methods and apparatus to bind properties in a process control system | |
EP1536350A3 (en) | System and method for creating dynamic internet bookmark | |
WO2006031748A3 (en) | System and method for connection optimization | |
EP1575244A3 (en) | Update distribution system architecture and method for distributing software | |
WO2007061975A3 (en) | Dynamically editable electronic product catalogs | |
TW200707279A (en) | Task scheduling to devices with same connection address | |
WO2008036302A3 (en) | A method and an apparatus to perform feature similarity mapping | |
WO2008049066A3 (en) | Electronic catalog | |
WO2005115203A3 (en) | Floral easel | |
MXPA05003055A (en) | Macromolecular compounds with a core-shell structure. | |
EP1691285A3 (en) | Communication channel model | |
WO2005048138A3 (en) | System, method, and computer program product for storing test results in a database | |
EP1783647A3 (en) | Database techniques for storing biochemical data items | |
DE602004029319D1 (en) | CONNECTION WITH PHOSHORYL CHOLINING GROUP, THE POLYMER, AND METHOD FOR THE PRODUCTION THEREOF | |
DE602005004607D1 (en) | METHOD FOR PRODUCING GRANULATE COMPOSITIONS | |
DE602004018370D1 (en) | POLYMORPHOS OF 1-CYCLOPROPYL-7- (ÄS, SÜ-2,8-DIAZADICYCLO Ä4.3.0Ü NON-8-YL) -6-FLUOR-1,4-DIHYDRO-8-METHOXY-4-OXO-3-CHINOLINCARBOXYLIC ACID HYDROCHLORIDE AND METHOD FOR THE PRODUCTION THEREOF |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PUAI | Public reference made under article 153(3) epc to a published international application that has entered the european phase |
Free format text: ORIGINAL CODE: 0009012 |
|
AK | Designated contracting states |
Kind code of ref document: A2 Designated state(s): AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IS IT LI LT LU MC NL PL PT RO SE SI SK TR |
|
AX | Request for extension of the european patent |
Extension state: AL BA HR LV MK YU |
|
PUAL | Search report despatched |
Free format text: ORIGINAL CODE: 0009013 |
|
REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1082067 Country of ref document: HK |
|
AK | Designated contracting states |
Kind code of ref document: A3 Designated state(s): AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IS IT LI LT LU MC NL PL PT RO SE SI SK TR |
|
AX | Request for extension of the european patent |
Extension state: AL BA HR LV MK YU |
|
17P | Request for examination filed |
Effective date: 20061221 |
|
17Q | First examination report despatched |
Effective date: 20070126 |
|
AKX | Designation fees paid |
Designated state(s): AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IS IT LI LT LU MC NL PL PT RO SE SI SK TR |
|
RAP1 | Party data changed (applicant data changed or rights of an application transferred) |
Owner name: MICROSOFT TECHNOLOGY LICENSING, LLC |
|
STAA | Information on the status of an ep patent application or granted ep patent |
Free format text: STATUS: THE APPLICATION HAS BEEN REFUSED |
|
18R | Application refused |
Effective date: 20160917 |
|
REG | Reference to a national code |
Ref country code: HK Ref legal event code: WD Ref document number: 1082067 Country of ref document: HK |