BR112016013584A8 - sistema de computação, método executado por processador, meio de armazenamento legível por computador e dispositivo de armazenamento para construção de consultas para execução através de estruturas de dados multidimensionais - Google Patents

sistema de computação, método executado por processador, meio de armazenamento legível por computador e dispositivo de armazenamento para construção de consultas para execução através de estruturas de dados multidimensionais Download PDF

Info

Publication number
BR112016013584A8
BR112016013584A8 BR112016013584A BR112016013584A BR112016013584A8 BR 112016013584 A8 BR112016013584 A8 BR 112016013584A8 BR 112016013584 A BR112016013584 A BR 112016013584A BR 112016013584 A BR112016013584 A BR 112016013584A BR 112016013584 A8 BR112016013584 A8 BR 112016013584A8
Authority
BR
Brazil
Prior art keywords
execution
processor
computer
computing system
data structures
Prior art date
Application number
BR112016013584A
Other languages
English (en)
Other versions
BR112016013584B1 (pt
BR112016013584A2 (pt
Inventor
Tristan St -Cyr Alexandre
Szyperski Clemens
Mohamood Faisal
Hughes Gregory
Dumitru Marius
J Coulson Michael
Palmer-Boroski Theresa
Original Assignee
Microsoft Technology Licensing Llc
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 Microsoft Technology Licensing Llc filed Critical Microsoft Technology Licensing Llc
Publication of BR112016013584A2 publication Critical patent/BR112016013584A2/pt
Publication of BR112016013584A8 publication Critical patent/BR112016013584A8/pt
Publication of BR112016013584B1 publication Critical patent/BR112016013584B1/pt

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/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
    • 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/235—Update request formulation
    • 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/242—Query formulation
    • G06F16/2423—Interactive query statement specification based on a database schema
    • 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/242—Query formulation
    • G06F16/2425—Iterative querying; Query formulation based on the results of a preceding query
    • 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/242—Query formulation
    • G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
    • 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/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • 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/25—Integrating or interfacing systems involving database management systems
    • 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/903—Querying
    • G06F16/9032—Query formulation
    • 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/903—Querying
    • G06F16/90335—Query processing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Human Computer Interaction (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

a presente invenção refere-se a várias tecnologias pertencendo à construção de uma consulta para execução através de um cubo. dados tabulares são apresentados em uma tela de vídeo, onde os dados tabulares representam pelo menos parte de um cubo de dados. é recebida entrada com respeito aos dados tabulares, e em reposta à entrada ser recebida, é construída uma consulta baseada na entrada. a consulta é executada através do cubo de dados, resultando em aprovisionamento de uma nova tabela.
BR112016013584-9A 2013-12-20 2014-12-18 Sistema de computação e método executado por processador BR112016013584B1 (pt)

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
US201361919349P 2013-12-20 2013-12-20
US61/919,349 2013-12-20
US14/325,642 US9619581B2 (en) 2013-12-20 2014-07-08 Constructing queries for execution over multi-dimensional data structures
US14/325,642 2014-07-08
PCT/US2014/071004 WO2015095429A1 (en) 2013-12-20 2014-12-18 Constructing queries for execution over multi-dimensional data structures

Publications (3)

Publication Number Publication Date
BR112016013584A2 BR112016013584A2 (pt) 2017-08-08
BR112016013584A8 true BR112016013584A8 (pt) 2020-05-19
BR112016013584B1 BR112016013584B1 (pt) 2023-01-17

Family

ID=53400301

Family Applications (1)

Application Number Title Priority Date Filing Date
BR112016013584-9A BR112016013584B1 (pt) 2013-12-20 2014-12-18 Sistema de computação e método executado por processador

Country Status (7)

Country Link
US (2) US9619581B2 (pt)
EP (1) EP3084644A1 (pt)
JP (1) JP6652490B2 (pt)
CN (1) CN105849725B (pt)
BR (1) BR112016013584B1 (pt)
RU (1) RU2679977C1 (pt)
WO (1) WO2015095429A1 (pt)

Families Citing this family (26)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9619581B2 (en) 2013-12-20 2017-04-11 Microsoft Technology Licensing, Llc Constructing queries for execution over multi-dimensional data structures
US20160063047A1 (en) * 2014-08-29 2016-03-03 Mckesson Financial Holdings Method and Apparatus for Providing a Data Manipulation Framework
US10102269B2 (en) * 2015-02-27 2018-10-16 Microsoft Technology Licensing, Llc Object query model for analytics data access
US9760618B2 (en) * 2015-03-16 2017-09-12 International Business Machines Corporation Distributed iceberg cubing over ordered dimensions
US12013895B2 (en) 2016-09-26 2024-06-18 Splunk Inc. Processing data using containerized nodes in a containerized scalable environment
US11604795B2 (en) * 2016-09-26 2023-03-14 Splunk Inc. Distributing partial results from an external data system between worker nodes
US11860940B1 (en) 2016-09-26 2024-01-02 Splunk Inc. Identifying buckets for query execution using a catalog of buckets
CN108268193B (zh) * 2017-01-04 2021-03-02 珠海金山办公软件有限公司 电子表格中函数对应的提示信息的显示方法及装置
US12118009B2 (en) 2017-07-31 2024-10-15 Splunk Inc. Supporting query languages through distributed execution of query engines
US11989194B2 (en) 2017-07-31 2024-05-21 Splunk Inc. Addressing memory limits for partition tracking among worker nodes
US11675761B2 (en) 2017-09-30 2023-06-13 Oracle International Corporation Performing in-memory columnar analytic queries on externally resident data
US10366915B2 (en) 2017-11-15 2019-07-30 Taiwan Semiconductor Manufacturing Co., Ltd. FinFET devices with embedded air gaps and the fabrication thereof
US10509805B2 (en) * 2018-03-13 2019-12-17 deFacto Global, Inc. Systems, methods, and devices for generation of analytical data reports using dynamically generated queries of a structured tabular cube
US10956384B2 (en) * 2019-03-05 2021-03-23 International Business Machines Corporation Assessing aggregated data quality
US10895973B2 (en) 2019-04-23 2021-01-19 Google Llc Browsing hierarchical datasets
US10884599B2 (en) 2019-05-23 2021-01-05 Amadeus S.A.S. Graphical user interface for refocusing the scope of a series of queries
US11734308B2 (en) 2019-09-12 2023-08-22 Oracle International Corporation Autonomous caching for views
US11630848B2 (en) * 2019-09-20 2023-04-18 International Business Machines Corporation Managing hypercube data structures
US11494380B2 (en) 2019-10-18 2022-11-08 Splunk Inc. Management of distributed computing framework components in a data fabric service system
US11232158B2 (en) * 2019-10-29 2022-01-25 Google Llc Single view presentation of multiple queries in a data visualization application
US11797520B2 (en) 2019-11-29 2023-10-24 Oracle International Corporation ROWID elimination rewrite
US11461328B2 (en) 2020-09-21 2022-10-04 Oracle International Corporation Method for using a sematic model to transform SQL against a relational table to enable performance improvements
US11556533B2 (en) 2020-11-12 2023-01-17 Oracle International Corporation Method for generating views based on a semantic model, that allows for autonomous performance improvements and complex calculations
US12072939B1 (en) 2021-07-30 2024-08-27 Splunk Inc. Federated data enrichment objects
US20230195095A1 (en) * 2021-12-17 2023-06-22 Honeywell International Inc. Industrial knowledge graph and contextualization
US12093272B1 (en) 2022-04-29 2024-09-17 Splunk Inc. Retrieving data identifiers from queue for search of external data system

Family Cites Families (57)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5752016A (en) * 1990-02-08 1998-05-12 Hewlett-Packard Company Method and apparatus for database interrogation using a user-defined table
JPH0756933A (ja) * 1993-06-24 1995-03-03 Xerox Corp 文書検索方法
US5832475A (en) * 1996-03-29 1998-11-03 International Business Machines Corporation Database system and method employing data cube operator for group-by operations
US5983218A (en) * 1997-06-30 1999-11-09 Xerox Corporation Multimedia database for use over networks
US6711585B1 (en) * 1999-06-15 2004-03-23 Kanisa Inc. System and method for implementing a knowledge management system
US6750864B1 (en) 1999-11-15 2004-06-15 Polyvista, Inc. Programs and methods for the display, analysis and manipulation of multi-dimensional data implemented on a computer
US6704740B1 (en) * 2000-08-10 2004-03-09 Ford Motor Company Method for analyzing product performance data
US7174342B1 (en) * 2001-08-09 2007-02-06 Ncr Corp. Systems and methods for defining executable sequences to process information from a data collection
CA2372092C (en) * 2002-02-15 2010-04-06 Cognos Incorporated A queuing model for a plurality of servers
US8015143B2 (en) * 2002-05-22 2011-09-06 Estes Timothy W Knowledge discovery agent system and method
US7162470B2 (en) 2002-06-07 2007-01-09 Oracle International Corporation Contextual search interface for business directory services
US7383513B2 (en) * 2002-09-25 2008-06-03 Oracle International Corporation Graphical condition builder for facilitating database queries
US7698441B2 (en) * 2002-10-03 2010-04-13 International Business Machines Corporation Intelligent use of user data to pre-emptively prevent execution of a query violating access controls
US6938036B2 (en) * 2002-10-24 2005-08-30 International Business Machines Corporation Query modification analysis
US7644361B2 (en) * 2002-12-23 2010-01-05 Canon Kabushiki Kaisha Method of using recommendations to visually create new views of data across heterogeneous sources
US8200612B2 (en) * 2003-05-07 2012-06-12 Oracle International Corporation Efficient SQL access to multidimensional data
US7305408B2 (en) * 2003-08-12 2007-12-04 Oracle International Corporation System and method for cross attribute analysis and manipulation in online analytical processing (OLAP) and multi-dimensional planning applications by dimension splitting
US7707045B2 (en) * 2003-08-28 2010-04-27 Cerner Innovation, Inc. System and method for multi-dimensional extension of database information
FR2859552B1 (fr) 2003-09-10 2006-03-31 Granite Software Procede et systeme de manipulation de donnees issues de bases de donnees multidimensionnelles a l'aide d'un tableur
US7188098B2 (en) * 2003-09-24 2007-03-06 International Business Machines Corporation Query transformation for union all view join queries using join predicates for pruning and distribution
US7337163B1 (en) 2003-12-04 2008-02-26 Hyperion Solutions Corporation Multidimensional database query splitting
US7809678B2 (en) * 2004-07-09 2010-10-05 Microsoft Corporation Fact dimensions in multidimensional databases
US20060112123A1 (en) 2004-11-24 2006-05-25 Macnica, Inc. Spreadsheet user-interfaced business data visualization and publishing system
US7800613B2 (en) * 2004-12-02 2010-09-21 Tableau Software, Inc. Computer systems and methods for visualizing data with generation of marks
US8150893B2 (en) * 2004-12-29 2012-04-03 Alcatel Lucent Method and apparatus for incremental evaluation of schema-directed XML publishing
US7640237B2 (en) * 2005-01-11 2009-12-29 International Business Machines Corporation System and method for database query with on demand database query reduction
US7694212B2 (en) * 2005-03-31 2010-04-06 Google Inc. Systems and methods for providing a graphical display of search activity
US8935273B2 (en) * 2005-06-23 2015-01-13 International Business Machines Corporation Method of processing and decomposing a multidimensional query against a relational data source
US7543003B2 (en) * 2005-08-25 2009-06-02 Microsoft Corporation Providing change notifications to an entity-regarding a change of a specific type to data in a relational database
US7581189B2 (en) 2005-09-09 2009-08-25 Microsoft Corporation Dynamically generating a database report during a report building process
US20070078823A1 (en) * 2005-09-30 2007-04-05 Microsoft Corporation Expression templates and object classes for multidimensional analytics expressions
US8180789B1 (en) * 2005-12-05 2012-05-15 Teradata Us, Inc. Techniques for query generation, population, and management
US7844603B2 (en) * 2006-02-17 2010-11-30 Google Inc. Sharing user distributed search results
US20080016041A1 (en) * 2006-07-14 2008-01-17 Frost Brandon H Spreadsheet-based relational database interface
US8589357B2 (en) * 2006-10-20 2013-11-19 Oracle International Corporation Techniques for automatically tracking and archiving transactional data changes
US7779031B2 (en) * 2007-02-15 2010-08-17 International Business Machines Corporation Multidimensional query simplification using data access service having local calculation engine
US8121975B2 (en) * 2008-02-20 2012-02-21 Panorama Software Inc. Creating pivot tables from tabular data
US8073869B2 (en) * 2008-07-03 2011-12-06 The Regents Of The University Of California Method for efficiently supporting interactive, fuzzy search on structured data
US8229923B2 (en) * 2008-09-26 2012-07-24 Microsoft Corporation Multidimensional data space queries with expression evaluation
US8706681B2 (en) 2008-10-01 2014-04-22 Prophix Software Inc. System and method for processing and/or analyzing OLAP based data according to one or more parameters
US20170060856A1 (en) * 2008-12-10 2017-03-02 Chiliad Publishing Incorporated Efficient search and analysis based on a range index
US8234344B2 (en) * 2009-05-06 2012-07-31 Business Objects S.A. Providing analytical view of email information
US8825601B2 (en) * 2010-02-01 2014-09-02 Microsoft Corporation Logical data backup and rollback using incremental capture in a distributed database
US8924379B1 (en) * 2010-03-05 2014-12-30 Google Inc. Temporal-based score adjustments
US9262482B2 (en) * 2010-04-19 2016-02-16 Facebook, Inc. Generating default search queries on online social networks
US8542205B1 (en) * 2010-06-24 2013-09-24 Amazon Technologies, Inc. Refining search results based on touch gestures
US8655841B1 (en) * 2010-12-31 2014-02-18 Symantec Corporation Selection of one of several available incremental modification detection techniques for use in incremental backups
US8825620B1 (en) * 2011-06-13 2014-09-02 A9.Com, Inc. Behavioral word segmentation for use in processing search queries
US9462040B2 (en) * 2011-12-07 2016-10-04 Cisco Technology, Inc. Network-based dynamic data management
US9424282B2 (en) * 2012-03-05 2016-08-23 Hasso-Plattner-Institut Fur Softwaresystemtechnik Gmbh Online reorganization of hybrid in-memory databases
US9501550B2 (en) * 2012-04-18 2016-11-22 Renmin University Of China OLAP query processing method oriented to database and HADOOP hybrid platform
US8930374B2 (en) * 2012-06-29 2015-01-06 Nokia Corporation Method and apparatus for multidimensional data storage and file system with a dynamic ordered tree structure
GB2505183A (en) * 2012-08-21 2014-02-26 Ibm Discovering composite keys
US9659082B2 (en) * 2012-08-27 2017-05-23 Microsoft Technology Licensing, Llc Semantic query language
US20140101147A1 (en) * 2012-10-01 2014-04-10 Neutrino Concepts Limited Search
US20150134676A1 (en) * 2013-11-11 2015-05-14 International Business Machines Corporation Amorphous data query formulation
US9619581B2 (en) 2013-12-20 2017-04-11 Microsoft Technology Licensing, Llc Constructing queries for execution over multi-dimensional data structures

Also Published As

Publication number Publication date
CN105849725B (zh) 2019-10-01
WO2015095429A1 (en) 2015-06-25
RU2016124134A (ru) 2017-12-21
BR112016013584B1 (pt) 2023-01-17
BR112016013584A2 (pt) 2017-08-08
JP6652490B2 (ja) 2020-02-26
RU2679977C1 (ru) 2019-02-14
JP2017500664A (ja) 2017-01-05
US9619581B2 (en) 2017-04-11
US20150178407A1 (en) 2015-06-25
CN105849725A (zh) 2016-08-10
EP3084644A1 (en) 2016-10-26
US20170228451A1 (en) 2017-08-10
US10565232B2 (en) 2020-02-18

Similar Documents

Publication Publication Date Title
BR112016013584A8 (pt) sistema de computação, método executado por processador, meio de armazenamento legível por computador e dispositivo de armazenamento para construção de consultas para execução através de estruturas de dados multidimensionais
BR112019007458A8 (pt) Melhorias de eficiência em aplicativos de gerenciamento de tarefas
BR112018073496A2 (pt) sistemas e métodos para localizar um dispositivo sem fio
BR112015022493A2 (pt) sistema de determinação de contexto demográfico
BR112017014135A2 (pt) métodos e sistemas para gerenciar permissões para acessar recursos de dispositivo móvel
JP2014508983A5 (pt)
BR112015027756A8 (pt) método, sistema e um ou mais meios de armazenamento não transitórios legíveis por computador para uso de operadores inversos para consultas em redes sociais online
WO2014120687A3 (en) Performing application search based on entities
BR112016009470A2 (pt) métodos, sistemas e produtos de programa de computador para o uso de uma base de memória associativa distribuída para determinar correlações e convergências de dados na mesma
BR112015026928A2 (pt) seleção de interface de usuário de dispositivo cruzado
MX2016004126A (es) Sistemas y metodos para sistemas de manejo de respuesta a demanda mejorados (drms).
JP2017528846A5 (pt)
GB2538457A (en) High performance distributed computing environment particularly suited for reservoir modelling and simulation
BR112015003406A8 (pt) Método implementado por computador e sistema de computação
BR112016007295A8 (pt) Método de otimizar execução de consultas em um armazenamento de dados, servidor para otimizar execução de consultas em um armazenamento de dados e meio legível por computador não transitório
BR112017011763A2 (pt) dispositivos de controle e de comunicação por rádio, e, método de controle de comunicação.
WO2012170729A3 (en) Interfaces for displaying an intersection space
BR112017023396A2 (pt) coleta e produção de metadados avançados
WO2015017276A3 (en) Method and system for providing recommended terms
BR112016004403A8 (pt) sistema, método e meio de armazenamento legível por computador para refinamento inteligente de pesquisa
BR112017005646B8 (pt) Método implementado por um dispositivo de computação e dispositivo de computação para funções de partição composta
BR112015022636A2 (pt) sistema de determinação de contexto de saúde
BR112014010634A8 (pt) Método implementado por computador, dispositivo de computação e meio de armazenamento legível por computador
BR102013031320A8 (pt) sistema e meio legível por computador não-transitório
GB2549242A8 (en) Storage system and control method for storage system

Legal Events

Date Code Title Description
B06U Preliminary requirement: requests with searches performed by other patent offices: procedure suspended [chapter 6.21 patent gazette]
B06A Patent application procedure suspended [chapter 6.1 patent gazette]
B09A Decision: intention to grant [chapter 9.1 patent gazette]
B16A Patent or certificate of addition of invention granted [chapter 16.1 patent gazette]

Free format text: PRAZO DE VALIDADE: 20 (VINTE) ANOS CONTADOS A PARTIR DE 18/12/2014, OBSERVADAS AS CONDICOES LEGAIS