EP3176706A3 - Automated analysis of data reports to determine data structure and to perform automated data processing - Google Patents

Automated analysis of data reports to determine data structure and to perform automated data processing Download PDF

Info

Publication number
EP3176706A3
EP3176706A3 EP16002445.1A EP16002445A EP3176706A3 EP 3176706 A3 EP3176706 A3 EP 3176706A3 EP 16002445 A EP16002445 A EP 16002445A EP 3176706 A3 EP3176706 A3 EP 3176706A3
Authority
EP
European Patent Office
Prior art keywords
elements
data
reports
automated
tree structure
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.)
Granted
Application number
EP16002445.1A
Other languages
German (de)
French (fr)
Other versions
EP3176706A2 (en
EP3176706B1 (en
Inventor
Patrick Azoulay
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.)
SAP SE
Original Assignee
SAP SE
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 SAP SE filed Critical SAP SE
Publication of EP3176706A2 publication Critical patent/EP3176706A2/en
Publication of EP3176706A3 publication Critical patent/EP3176706A3/en
Application granted granted Critical
Publication of EP3176706B1 publication Critical patent/EP3176706B1/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2228—Indexing structures
    • G06F16/2246—Trees, e.g. B+trees
    • 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/23—Updating
    • G06F16/2365—Ensuring data consistency and integrity
    • 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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24564—Applying rules; Deductive queries
    • G06F16/24566—Recursive queries
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/93—Document management systems
    • 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/137—Hierarchical processing, e.g. outlines
    • 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

Abstract

A computer-implemented method for building a hierarchy of elements depending on data disclosed in reports includes identifying one or more areas containing one or more elements in each of multiple reports which contain data, where the elements comprise parent elements and child elements. The method includes parsing the data of each of the elements to simulate relationship operations between the parent elements and the child elements until consistent aggregations are found, identifying data with a same unit and adjusting the data to have a same scale or a same precision, recursively searching the aggregated data by applying the found relationship operations to build a tree structure having at least a portion of the elements of each report built in the tree structure arranged in a hierarchy of elements and storing the tree structure, including a level of each of the elements and the relationship operation.
EP16002445.1A 2015-11-18 2016-11-17 Automated analysis of data reports to determine data structure and to perform automated data processing Active EP3176706B1 (en)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US14/944,840 US10089343B2 (en) 2015-11-18 2015-11-18 Automated analysis of data reports to determine data structure and to perform automated data processing

Publications (3)

Publication Number Publication Date
EP3176706A2 EP3176706A2 (en) 2017-06-07
EP3176706A3 true EP3176706A3 (en) 2017-09-06
EP3176706B1 EP3176706B1 (en) 2024-01-24

Family

ID=57389145

Family Applications (1)

Application Number Title Priority Date Filing Date
EP16002445.1A Active EP3176706B1 (en) 2015-11-18 2016-11-17 Automated analysis of data reports to determine data structure and to perform automated data processing

Country Status (2)

Country Link
US (1) US10089343B2 (en)
EP (1) EP3176706B1 (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109886804B (en) * 2019-02-25 2023-09-05 创新先进技术有限公司 Task processing method and device
WO2021022553A1 (en) * 2019-08-08 2021-02-11 Microsoft Technology Licensing, Llc Spreadsheet table transformation
US11532174B2 (en) * 2019-12-03 2022-12-20 International Business Machines Corporation Product baseline information extraction
US20210303404A1 (en) * 2020-03-30 2021-09-30 Microstrategy Incorporated Systems and methods for database migration
CN111522819A (en) * 2020-04-24 2020-08-11 上海用天网络科技有限公司 Method and system for summarizing tree-structured data
KR102516206B1 (en) * 2020-11-16 2023-03-29 이현주 Method for constructing a database based on ontology, method for responding to an user query using the database, and system in which the methods are implemented

Family Cites Families (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5412804A (en) * 1992-04-30 1995-05-02 Oracle Corporation Extending the semantics of the outer join operator for un-nesting queries to a data base
US6134706A (en) * 1997-08-14 2000-10-17 International Business Machines Corporation Software business objects in a multi-level organizational structure
US6499064B1 (en) * 1997-08-14 2002-12-24 International Business Machines Corporation Method of using decoupled chain of responsibility
US7293175B2 (en) * 2000-06-29 2007-11-06 Lockheed Martin Corporation Automatic information sanitizer
US9600842B2 (en) * 2001-01-24 2017-03-21 E-Numerate Solutions, Inc. RDX enhancement of system and method for implementing reusable data markup language (RDL)
US20090055477A1 (en) * 2001-11-13 2009-02-26 Flesher Kevin E System for enabling collaboration and protecting sensitive data
US7653871B2 (en) * 2003-03-27 2010-01-26 General Electric Company Mathematical decomposition of table-structured electronic documents
KR100758288B1 (en) * 2006-02-10 2007-09-13 한국과학기술연구원 Apparatus, system and method for inputting and outputting data based on hand operation
US7904571B1 (en) * 2006-05-31 2011-03-08 At&T Intellectual Property Ii, L.P. Method and apparatus for generating a set of aggregates
US9047379B2 (en) * 2006-06-12 2015-06-02 Zalag Corporation Methods and apparatuses for searching content
WO2008130983A1 (en) * 2007-04-16 2008-10-30 Attune Systems, Inc. File aggregation in a switched file system
US8838628B2 (en) * 2009-04-24 2014-09-16 Bonnie Berger Leighton Intelligent search tool for answering clinical queries
US8834389B2 (en) * 2011-11-25 2014-09-16 Tepsync Temperature based fertility monitoring system and related method

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
"Communications in computer and information science", vol. 538, 1 January 2015, SPRINGER, DE, ISSN: 1865-0929, article ALEXEY SHIGAROV: "Rule-Based Table Analysis and Interpretation", pages: 175 - 186, XP055366418, DOI: 10.1007/978-3-319-24770-0_16 *
NIKITA ASTRAKHANTSEV: "Extracting Objects and Their Attributes from Tables in Text Documents", PROCEEDINGS OF THE SPRING YOUNG RESEARCHER'S COLLOQUIUM ON DATABASE AND INFORMATION SYSTEMS SYRCODIS, 1 January 2011 (2011-01-01), XP055366385, Retrieved from the Internet <URL:http://ceur-ws.org/Vol-735/paper6.pdf> [retrieved on 20170421] *
VANESSA LONG: "An Agent-Based Approach to Table Recognition and Interpretation", 23 May 2010 (2010-05-23), XP055365977, Retrieved from the Internet <URL:http://comp.mq.edu.au/~rdale/students/VanessaLong/dissertation_revised_2010-05-23.pdf> [retrieved on 20170420] *

Also Published As

Publication number Publication date
EP3176706A2 (en) 2017-06-07
US20170139966A1 (en) 2017-05-18
EP3176706B1 (en) 2024-01-24
US10089343B2 (en) 2018-10-02

Similar Documents

Publication Publication Date Title
EP3176706A3 (en) Automated analysis of data reports to determine data structure and to perform automated data processing
EP2846175A3 (en) Seismic survey analysis
CN106537429A8 (en) System and method for providing optimization or corrective measure for one or more buildings
WO2015191731A8 (en) Systems and methods for software analytics
WO2016164680A3 (en) Automated model development process
WO2014121092A3 (en) Data records selection
WO2015195676A3 (en) Computer-implemented tools and methods for extracting information about the structure of a large computer software system, exploring its structure, discovering problems in its design, and enabling refactoring
WO2018013247A3 (en) Physics informed learning machine
WO2017176356A3 (en) Partitioned machine learning architecture
MX2017015844A (en) System and method for the generation of an adaptive user interface in a website building system.
EP2413259A3 (en) Methods and systems for test automation of forms in web applications
WO2017085694A3 (en) Driveline modeller
EP3021239A3 (en) Display apparatus and method for summarizing of document
EP2363817A3 (en) Method and apparatus for discrete element modeling with a virtual geometry object
WO2012114199A3 (en) Image reconstruction based on parametric models
WO2012116309A3 (en) System, method &amp; computer program product for constructing an optimized factor portfolio
WO2015092588A3 (en) Spectral image data processing
BR112018012996A2 (en) ? method for modeling an underground formation, and profiling system?
EP2949860A3 (en) Method and apparatus for communicating incremental depth and other useful data to downhole tool
GB2534705A (en) Automated horizon auto-picking on multiple volumes
AU2015364405A8 (en) Methods for simultaneous source separation
GB2568405A (en) Point-vector based modeling of petroleum reservoir properties for a gridless reservoir simulation model
WO2012003249A3 (en) System and method of analyzing business process events
EP4300501A3 (en) Methods of sequencing data read realignment
WO2015185696A3 (en) Method of estimating well productivity along a section of a wellbore

Legal Events

Date Code Title Description
AK Designated contracting states

Kind code of ref document: A2

Designated state(s): AL AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HR HU IE IS IT LI LT LU LV MC MK MT NL NO PL PT RO RS SE SI SK SM TR

AX Request for extension of the european patent

Extension state: BA ME

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

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: THE APPLICATION HAS BEEN PUBLISHED

PUAL Search report despatched

Free format text: ORIGINAL CODE: 0009013

AK Designated contracting states

Kind code of ref document: A3

Designated state(s): AL AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HR HU IE IS IT LI LT LU LV MC MK MT NL NO PL PT RO RS SE SI SK SM TR

AX Request for extension of the european patent

Extension state: BA ME

RIC1 Information provided on ipc code assigned before grant

Ipc: G06F 17/22 20060101AFI20170803BHEP

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: REQUEST FOR EXAMINATION WAS MADE

17P Request for examination filed

Effective date: 20180215

RBV Designated contracting states (corrected)

Designated state(s): AL AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HR HU IE IS IT LI LT LU LV MC MK MT NL NO PL PT RO RS SE SI SK SM TR

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: EXAMINATION IS IN PROGRESS

17Q First examination report despatched

Effective date: 20200224

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: EXAMINATION IS IN PROGRESS

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: EXAMINATION IS IN PROGRESS

REG Reference to a national code

Ref country code: DE

Ref legal event code: R079

Ref document number: 602016085443

Country of ref document: DE

Free format text: PREVIOUS MAIN CLASS: G06F0017220000

Ipc: G06F0040137000

Ref country code: DE

Ref legal event code: R079

Free format text: PREVIOUS MAIN CLASS: G06F0017220000

RIC1 Information provided on ipc code assigned before grant

Ipc: G06F 16/93 20190101ALI20230627BHEP

Ipc: G06F 40/177 20200101ALI20230627BHEP

Ipc: G06F 40/137 20200101AFI20230627BHEP

GRAP Despatch of communication of intention to grant a patent

Free format text: ORIGINAL CODE: EPIDOSNIGR1

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: GRANT OF PATENT IS INTENDED

INTG Intention to grant announced

Effective date: 20230811

GRAS Grant fee paid

Free format text: ORIGINAL CODE: EPIDOSNIGR3

GRAA (expected) grant

Free format text: ORIGINAL CODE: 0009210

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: THE PATENT HAS BEEN GRANTED

AK Designated contracting states

Kind code of ref document: B1

Designated state(s): AL AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HR HU IE IS IT LI LT LU LV MC MK MT NL NO PL PT RO RS SE SI SK SM TR

REG Reference to a national code

Ref country code: GB

Ref legal event code: FG4D

REG Reference to a national code

Ref country code: CH

Ref legal event code: EP

REG Reference to a national code

Ref country code: IE

Ref legal event code: FG4D

REG Reference to a national code

Ref country code: DE

Ref legal event code: R096

Ref document number: 602016085443

Country of ref document: DE