IDENTIFYING CONTENT AND STRUCTURE OF OLAP DIMENSIONS FROM A SPREADSHEET

Patent №

US 11,720,596

Granted

2023-08-08

Filed 2020

Owner

INTERNATIONAL BUSINESS MACHINES CORPORATION

+1 more

Lab

IBM Research

AI components

nlp · planning · hardware

Assignment

Recorded

Dataset

AIPD

2023_r1 edition

Application

16797007

View graph

Proposed are concepts for identifying OLAP dimensions from a spreadsheet. Such a concept may determine contents and structure of an OLAP dimension from a spreadsheet using position, formatting, data and formulae. This may, for example, facilitating creation of an OLAP mode in a manner that would otherwise not be possible with the existing tools.

Natural language Planning AI hardwareG06F 16/283G06F 16/221G06F 16/2465G06F 16/282G06F 16/285G06F 40/18G06F 40/30G06N 5/01+1 more

Google Patents

AI classification

Natural language0.95

AI hardware0.79

Planning0.76

Machine learning0.04

Knowledge representation0.01

Evolutionary computation0.00

Vision0.00

Speech0.00

Ownership

INTERNATIONAL BUSINESS MACHINES CORPORATION

assignment · 518830869

UNIVERSITY OF YORK

assignment · 549190973

Assignors

NELMES, ANDREW THOMAS, CO, JONATHAN, KOMNINOS, ALEXANDROS

On an employer assignment, the assignors are typically the inventors.

From the same owner

METRIC LEARNING PREDICTION OF SIMULATION PARAMETERSUS 12,691,869 · 2026 DETERMINATION AND ALLEVIATION OF ROOT CAUSES FOR EMISSION OF POLLUTANTS FROM VEHICLESUS 12,693,686 · 2026 TRAINING AND USING A SENTIMENT MACHINE LEARNING MODULE TO RECEIVE AS INPUT HAPTIC METRIC VALUES TO DETERMINE A SENTIMENT SCORE FOR TEXT TO PROVIDE TO AN INTERACTIVE PROGRAMUS 12,693,779 · 2026 DOMAIN-SPECIFICITY PREDICTION FOR NATURAL LANGUAGE PROCESSINGUS 12,694,208 · 2026 USER INTERFACE AUTOMATION USING NATURAL LANGUAGEUS 12,694,222 · 2026 NATURAL LANGUAGE DATA GENERATION USING AUTOMATED KNOWLEDGE DISTILLATION TECHNIQUESUS 12,694,236 · 2026 NEURAL NETWORK SYSTEMS FOR ABSTRACT REASONINGUS 12,694,281 · 2026 ACCELERATING INFERENCE OF NEURAL NETWORK MODELS VIA DYNAMIC EARLY EXITSUS 12,694,283 · 2026

Cites (34)

DETECTING ERRORS IN SPREADSHEETSUS 11,210,463 · 2021 GENERATING CHARTS FROM DATA IN A DATA TABLEUS 11,093,703 · 2021 AUTOMATIC DATA WAREHOUSE GENERATION USING AUTOMATICALLY GENERATED SCHEMAUS 10,885,051 · 2021 VISUAL FOCUS-AWARE TECHNIQUES FOR VISUALIZING DISPLAY CHANGESUS 10,203,926 · 2019 PROCEDURALLY SPECIFYING CALCULATED DATABASE FIELDS, AND POPULATING THEMUS 10,083,016 · 2018 Deep Integration of Programming Language and Markup Language ConstructsUS 9,886,518 · 2018 Constructing Reports Using Metric-Attribute CombinationsUS 9,652,516 · 2017 AUTOMATIC DATA WAREHOUSE GENERATION USING AUTOMATICALLY GENERATED SCHEMAUS 9,483,537 · 2016 SYSTEM AND METHOD FOR MANAGEMENT OF AN AUTOMATIC OLAP REPORT BROADCAST SYSTEMUS 9,477,740 · 2016 METHODS, SYSTEMS, AND ARTICLES OF MANUFACTURE FOR USING MULTIPLE MODES DURING EXECUTION OF A PROGRAMUS 9,367,423 · 2016 METHOD AND COMPUTING DEVICE FOR MAINTAINING DEPENDENCIES AMONG REFERENCE ELEMENTSUS 9,158,832 · 2015 SYSTEMS AND METHODS FOR PROVIDING CONTENT AWARE DOCUMENT ANALYSIS AND MODIFICATIONUS 9,104,659 · 2015 SELECTIVE GENERATION AND DISPLAY OF DATA ITEMS ASSOCIATED WITH A SPREADSHEETUS 9,069,748 · 2015 AUTOMATIC RELATIONSHIP DETECTION FOR SPREADSHEET DATA ITEMSUS 8,990,675 · 2015 CONVERTING STRUCTURED REPORTS TO FORMULASUS 7,792,847 · 2010 GENERATING FREE FORM REPORTS WITHIN A DATA ARRAYUS 7,747,939 · 2010 SYSTEM AND METHOD FOR AUTOMATICALLY BUILDING AN OLAP MODEL IN A RELATIONAL DATABASEUS 7,716,167 · 2010 MAPPING OF AN RDBMS SCHEMA ONTO A MULTIDIMENSIONAL DATA MODELUS 7,664,777 · 2010 INCORPORATION OF SPREADSHEET FORMULAS OF MULTI-DIMENSIONAL CUBE DATA INTO A MULTI-DIMENTIONAL CUBEUS 7,530,012 · 2009 MAPPING OF AN RDBMS SCHEMA ONTO A MULTIDIMENSIONAL DATA MODELUS 7,181,440 · 2007 SYSTEMS AND METHODS PROVIDING DYNAMIC SPREADSHEET FUNCTIONALITYUS 7,082,569 · 2006 METHODOLOGY FOR TESTING SPREADSHEETSUS 6,948,154 · 2005 AUTOMATIC DETERMINATION OF OLAP CUBE DIMENSIONSUS 6,829,621 · 2004 SYSTEM AND METHODOLOGY PROVIDING COMPILER-ASSISTED REFACTORINGUS 6,804,682 · 2004 METHODS FOR ABSTRACTING DATA FROM VARIOUS DATA STRUCTURES AND MANAGING THE PRESENTATION OF THE DATAUS 6,775,675 · 2004

and 9 more

Related research

Semi-structured data extraction and modelling: the WIA ProjectarXiv Retracted: Exploring Dimensionality Reduction Techniques for On-line Analytical ProcessingOpenAlex Ontology Engineering Based on Spreadsheet Data TransformationOpenAlex Spreadsheet-based complex data transformationSemantic Scholar A Semi-Automatic Design Methodology for (Big) Data Warehouse Transforming Facts into DimensionsSemantic Scholar

Full text

Google Patents