BRPI0502063A - Combinação de expressões multidimensionais e extensões de exploração de dados para explorar cubos olap - Google Patents

Combinação de expressões multidimensionais e extensões de exploração de dados para explorar cubos olap

Info

Publication number
BRPI0502063A
BRPI0502063A BR0502063-8A BRPI0502063A BRPI0502063A BR PI0502063 A BRPI0502063 A BR PI0502063A BR PI0502063 A BRPI0502063 A BR PI0502063A BR PI0502063 A BRPI0502063 A BR PI0502063A
Authority
BR
Brazil
Prior art keywords
data mining
extensions
olap cubes
data
explore
Prior art date
Application number
BR0502063-8A
Other languages
English (en)
Inventor
C James Maclennan
Pyungchul Kim
Zhaohui Tang
Original Assignee
Microsoft Corp
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 Corp filed Critical Microsoft Corp
Publication of BRPI0502063A publication Critical patent/BRPI0502063A/pt

Links

Classifications

    • E—FIXED CONSTRUCTIONS
    • E06—DOORS, WINDOWS, SHUTTERS, OR ROLLER BLINDS IN GENERAL; LADDERS
    • E06C—LADDERS
    • E06C1/00—Ladders in general
    • E06C1/02—Ladders in general with rigid longitudinal member or members
    • E06C1/14—Ladders capable of standing by themselves
    • E06C1/16—Ladders capable of standing by themselves with hinged struts which rest on the ground
    • E06C1/18—Ladders capable of standing by themselves with hinged struts which rest on the ground with supporting struts formed as ladders
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/2433—Query languages
    • G06F16/244—Grouping and aggregation
    • E—FIXED CONSTRUCTIONS
    • E06—DOORS, WINDOWS, SHUTTERS, OR ROLLER BLINDS IN GENERAL; LADDERS
    • E06C—LADDERS
    • E06C7/00—Component parts, supporting parts, or accessories
    • E06C7/02—Extending means
    • E06C7/04—Hand-operated extending means carried by the ladder
    • E—FIXED CONSTRUCTIONS
    • E06—DOORS, WINDOWS, SHUTTERS, OR ROLLER BLINDS IN GENERAL; LADDERS
    • E06C—LADDERS
    • E06C7/00—Component parts, supporting parts, or accessories
    • E06C7/06—Securing devices or hooks for parts of extensible ladders
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2465—Query processing support for facilitating data mining operations in structured databases
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99933—Query processing, i.e. searching
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99944—Object-oriented database structure
    • Y10S707/99945—Object-oriented database structure processing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Mechanical Engineering (AREA)
  • Fuzzy Systems (AREA)
  • Probability & Statistics with Applications (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

"COMBINAçãO DE EXPRESSõES MULTIDIMENSIONAIS E EXTENSõES DE EXPLORAçãO DE DADOS PARA EXPLORAR CUBOS OLAP". Trata-se de um esquema de linguagem que integra extensões multidimensionais (por exemplo, MDX) e extensões de exploração de dado (por exemplo, DMX) para realizar operações de exploração de dado sobre dados que residem em cubos OLAP. O esquema indica que <fonte-dado-consulta> não pode ser somente uma consulta relacional, de preferência uma consulta multidimensional formada utilizando MDX, por exemplo. As operações de criação de modelo, treinamento e predição são descritas.
BR0502063-8A 2004-06-22 2005-05-17 Combinação de expressões multidimensionais e extensões de exploração de dados para explorar cubos olap BRPI0502063A (pt)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US10/873,676 US7627555B2 (en) 2004-06-22 2004-06-22 Combining multidimensional expressions and data mining extensions to mine OLAP cubes

Publications (1)

Publication Number Publication Date
BRPI0502063A true BRPI0502063A (pt) 2006-01-10

Family

ID=34981588

Family Applications (1)

Application Number Title Priority Date Filing Date
BR0502063-8A BRPI0502063A (pt) 2004-06-22 2005-05-17 Combinação de expressões multidimensionais e extensões de exploração de dados para explorar cubos olap

Country Status (10)

Country Link
US (1) US7627555B2 (pt)
EP (1) EP1610237A3 (pt)
JP (1) JP4716796B2 (pt)
KR (1) KR101034428B1 (pt)
CN (1) CN1713180B (pt)
AU (1) AU2005201996B2 (pt)
BR (1) BRPI0502063A (pt)
CA (1) CA2506135A1 (pt)
MX (1) MXPA05005536A (pt)
RU (1) RU2398273C2 (pt)

Families Citing this family (27)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7937401B2 (en) * 2004-07-09 2011-05-03 Microsoft Corporation Multidimensional database query extension systems and methods
US20060036939A1 (en) * 2004-08-13 2006-02-16 Microsoft Corporation Support for user-specified spreadsheet functions
US8095499B2 (en) * 2004-10-19 2012-01-10 Microsoft Corporation Query consolidation for structured reports
US7899776B2 (en) * 2007-07-02 2011-03-01 Microsoft Corporation Explaining changes in measures thru data mining
EP2148310B1 (en) * 2008-07-21 2016-07-06 IDT Electronic Products Limited Data retrieval apparatus
US8229923B2 (en) * 2008-09-26 2012-07-24 Microsoft Corporation Multidimensional data space queries with expression evaluation
CA2708911C (en) 2009-07-09 2016-06-28 Accenture Global Services Gmbh Marketing model determination system
AU2010276051B2 (en) * 2009-07-22 2016-05-26 University Of Ontario Institute Of Technology System, method and computer program for multi-dimensional temporal data mining
CA2712569C (en) * 2009-08-31 2016-04-26 Accenture Global Services Gmbh Adaptive analytics multidimensional processing system
KR101117649B1 (ko) * 2010-10-13 2012-03-20 세종대학교산학협력단 Ｏｌａｐ 기반의 ３차원 공간에서 데이터 분석 객체의 선택 방법 및 시스템
CN102306176B (zh) * 2011-08-25 2013-09-25 浙江鸿程计算机系统有限公司 一种基于数据仓库内在特征的olap关键词查询方法
CN102789488B (zh) * 2012-06-29 2016-05-04 用友网络科技股份有限公司 数据查询处理系统和数据查询处理方法
CN103164222A (zh) * 2013-02-25 2013-06-19 用友软件股份有限公司 多维建模系统和多维建模方法
CN103235793A (zh) * 2013-04-01 2013-08-07 华为技术有限公司 联机处理数据的方法、设备及系统
US10275484B2 (en) * 2013-07-22 2019-04-30 International Business Machines Corporation Managing sparsity in a multidimensional data structure
US9442977B2 (en) 2013-09-06 2016-09-13 Sap Se Database language extended to accommodate entity-relationship models
US9639572B2 (en) 2013-09-06 2017-05-02 Sap Se SQL enhancements simplifying database querying
US9176801B2 (en) 2013-09-06 2015-11-03 Sap Se Advanced data models containing declarative and programmatic constraints
US9619552B2 (en) 2013-09-06 2017-04-11 Sap Se Core data services extensibility for entity-relationship models
US9430523B2 (en) 2013-09-06 2016-08-30 Sap Se Entity-relationship model extensions using annotations
US9361407B2 (en) 2013-09-06 2016-06-07 Sap Se SQL extended with transient fields for calculation expressions in enhanced data models
US9575819B2 (en) 2013-09-06 2017-02-21 Sap Se Local buffers for event handlers
US9354948B2 (en) 2013-09-06 2016-05-31 Sap Se Data models containing host language embedded constraints
CN106528795B (zh) * 2016-11-10 2023-10-13 中国农业银行股份有限公司 一种数据挖掘方法及装置
KR102058124B1 (ko) * 2019-01-25 2019-12-23 (주)비아이매트릭스 피벗 테이블 구조의 olap 결과를 이용한 딥러닝 예측 데이터 반영 시스템
CN114610757B (zh) * 2022-03-14 2025-04-01 浪潮通用软件有限公司 对基础查询对象进行扩展查询的方法、系统、设备及介质
US11868329B2 (en) 2022-05-20 2024-01-09 International Business Machines Corporation Multidimensional cube multivariate regression

Family Cites Families (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6205447B1 (en) * 1997-06-30 2001-03-20 International Business Machines Corporation Relational database management of multi-dimensional data
RU2167450C2 (ru) * 1999-02-17 2001-05-20 Общество с ограниченной ответственностью "Информбюро" Способ идентификации объектов по их описаниям
US6473764B1 (en) * 1999-10-15 2002-10-29 Microsoft Corporation Virtual dimensions in databases and method therefor
US7822629B2 (en) * 1999-12-15 2010-10-26 Hewlett-Packard Development Company, L.P. Customer profiling apparatus for conducting customer behavior pattern analysis, and method for comparing customer behavior patterns
US7007020B1 (en) * 2000-03-10 2006-02-28 Hewlett-Packard Development Company, L.P. Distributed OLAP-based association rule generation method and system
US6917940B1 (en) * 2000-03-10 2005-07-12 Hewlett-Packard Development Company, L.P. Olap-based customer behavior profiling method and system
US6687693B2 (en) * 2000-12-18 2004-02-03 Ncr Corporation Architecture for distributed relational data mining systems
US7099880B2 (en) * 2002-01-31 2006-08-29 International Business Machines Corporation System and method of using data mining prediction methodology
US6931391B2 (en) * 2002-06-21 2005-08-16 Microsoft Corporation Systems and methods for generating prediction queries
US7472127B2 (en) * 2002-12-18 2008-12-30 International Business Machines Corporation Methods to identify related data in a multidimensional database
CN100359495C (zh) * 2003-09-04 2008-01-02 上海格尔软件股份有限公司 基于数据仓库的信息安全审计方法
WO2005038613A2 (en) * 2003-10-17 2005-04-28 Hydralift Amclyde, Inc. Equipment component monitoring and replacement management system

Also Published As

Publication number Publication date
CN1713180A (zh) 2005-12-28
JP2006012143A (ja) 2006-01-12
AU2005201996B2 (en) 2010-07-08
CN1713180B (zh) 2013-05-08
US20050283459A1 (en) 2005-12-22
KR20060047700A (ko) 2006-05-18
AU2005201996A1 (en) 2006-01-12
EP1610237A2 (en) 2005-12-28
US7627555B2 (en) 2009-12-01
CA2506135A1 (en) 2005-12-22
JP4716796B2 (ja) 2011-07-06
KR101034428B1 (ko) 2011-05-12
RU2005119376A (ru) 2006-12-27
RU2398273C2 (ru) 2010-08-27
MXPA05005536A (es) 2006-01-11
EP1610237A3 (en) 2006-12-13

Similar Documents

Publication Publication Date Title
MXPA05005536A (es) Combinacion de expresiones multidimensionales y extensiones de extraccion de datos para extraer cubos de procesamiento analitico en linea (olap).
WO2011127158A8 (en) Data storage and/or retrieval based on a database model-agnostic, schema-agnostic and workload-agnostic data storage and access models
EP2008206A4 (en) ILLUSTRATION ARCHITECTURE WITH INCREASING VISION
WO2005029280A3 (en) Performing sequence analysis as a multipart plan storing intermediate results as a relation
BRPI0505606A (pt) armazenamento de dados para documentos de aplicativo de software
BRPI0414332A (pt) métodos e sistemas para aperfeiçoar uma ordenação de busca, usando perguntas relacionadas
BRPI0503650A (pt) armazenamento durável de tipos e instáncias de dados.net
BR112013009046A2 (pt) sistema e método para computações utilizando representações otimizadas do modelo de terra
BRPI0600183A (pt) api de construção de consulta que pode ser composta em linguagem de consulta
BRPI0504995A (pt) acesso de dados complexos
TW200701015A (en) Patent document content construction method
CN103778118A (zh) 一种基于sql的xml到关系数据库的转换方法
Colomé et al. Fertilidad en mujeres mayores de 40 años
Tso Representations of the Queer:: The Screening of Cross-dressing in Chinese
WO2006110373A3 (en) Apparatus and method for utilizing sentence component metadata to create database queries
Pedersen et al. Simple and realistic data generation
WO2009029924A3 (en) Indexing role hierarchies for words in a search index
Skilton et al. The ancient Theravada meditation system, boran kammatthana: Anapanasati or'mindfulness of the breath'in kammatthan majjima baeb lamdub
Bae et al. Word Sense Disambiguation of Polysemy Predicates using UWordMap
Watson The New Traditional School in Scotland: Innovation, Beyond-tune Composition and a Traditional Musician's Creative Practice
CN104572696A (zh) 一种基于脚本语言的xml到关系数据库的转换方法
TW200608241A (en) Pivot analysis with the XML/XSL mechanism
He et al. X-SQL: A function-complete XML query language
Gopalacharyulu et al. Investigating the structure of integrated biological networks
Moon et al. Pyoderma-pyostomatitis vegetans without inflammatory bowel disease

Legal Events

Date Code Title Description
B03A Publication of a patent application or of a certificate of addition of invention [chapter 3.1 patent gazette]
B03H Publication of an application: rectification [chapter 3.8 patent gazette]

Free format text: REFERENTE A RPI 1827 DE 10/01/2006, QUANTO AO ITEM (30)

B08F Application dismissed because of non-payment of annual fees [chapter 8.6 patent gazette]

Free format text: REFERENTE 8A. ANUIDADE.

B08K Patent lapsed as no evidence of payment of the annual fee has been furnished to inpi [chapter 8.11 patent gazette]

Free format text: REFERENTE AO DESPACHO 8.6 PUBLICADO NA RPI 2205 DE 09/04/2013.