CN100527126C - 使用维属性和每维多个分层进行联机分析处理的系统和方法 - Google Patents
使用维属性和每维多个分层进行联机分析处理的系统和方法 Download PDFInfo
- Publication number
- CN100527126C CN100527126C CNB2004100550385A CN200410055038A CN100527126C CN 100527126 C CN100527126 C CN 100527126C CN B2004100550385 A CNB2004100550385 A CN B2004100550385A CN 200410055038 A CN200410055038 A CN 200410055038A CN 100527126 C CN100527126 C CN 100527126C
- Authority
- CN
- China
- Prior art keywords
- database
- attribute
- dimension
- definition
- layering
- 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.)
- Expired - Fee Related
Links
Images
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/2264—Multidimensional index structures
-
- 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
-
- 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
-
- 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/99943—Generating database or data structure, e.g. via user interface
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (28)
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/603,037 | 2003-06-24 | ||
US10/603,037 US7590638B2 (en) | 2003-06-24 | 2003-06-24 | System and method for online analytical processing using dimension attributes and multiple hierarchies where first hierarchy has at least one attribute from the defined dimension not present in the second hierarchy |
Publications (2)
Publication Number | Publication Date |
---|---|
CN1573754A CN1573754A (zh) | 2005-02-02 |
CN100527126C true CN100527126C (zh) | 2009-08-12 |
Family
ID=33418648
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB2004100550385A Expired - Fee Related CN100527126C (zh) | 2003-06-24 | 2004-06-24 | 使用维属性和每维多个分层进行联机分析处理的系统和方法 |
Country Status (5)
Country | Link |
---|---|
US (1) | US7590638B2 (zh) |
EP (1) | EP1492030B1 (zh) |
JP (1) | JP2005018778A (zh) |
KR (1) | KR101085666B1 (zh) |
CN (1) | CN100527126C (zh) |
Families Citing this family (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
DE10334153A1 (de) * | 2003-07-26 | 2005-02-24 | Karl Hehl | Verfahren und Vorrichtung zur interaktiven Steuerung einer Maschine |
JP4998237B2 (ja) * | 2007-12-06 | 2012-08-15 | 富士通株式会社 | 論理構造モデル作成支援プログラム、論理構造モデル作成支援装置および論理構造モデル作成支援方法 |
US8380748B2 (en) * | 2008-03-05 | 2013-02-19 | Microsoft Corporation | Multidimensional data cubes with high-cardinality attributes |
US20090248715A1 (en) * | 2008-03-31 | 2009-10-01 | Microsoft Corporation | Optimizing hierarchical attributes for olap navigation |
CA2708911C (en) * | 2009-07-09 | 2016-06-28 | Accenture Global Services Gmbh | Marketing model determination system |
CN102567792B (zh) * | 2010-12-17 | 2014-07-09 | 金蝶软件(中国)有限公司 | 穿透方法及系统 |
CN102243658A (zh) * | 2011-07-08 | 2011-11-16 | 百度在线网络技术(北京)有限公司 | 一种用于对多层结构数据进行数据平铺操作的方法和设备 |
CN103186427B (zh) * | 2011-12-31 | 2016-09-07 | 中国银联股份有限公司 | 一种分析数据记录集合的系统和方法 |
US9886460B2 (en) * | 2012-09-12 | 2018-02-06 | International Business Machines Corporation | Tuple reduction for hierarchies of a dimension |
WO2014047681A1 (en) * | 2012-09-25 | 2014-04-03 | Vizdynamics Pty Ltd | System and method for processing digital traffic metrics |
CN102938097B (zh) * | 2012-09-28 | 2016-09-28 | 用友网络科技股份有限公司 | 用于联机分析处理系统的数据处理装置和数据处理方法 |
EP3979092A1 (en) * | 2017-05-12 | 2022-04-06 | QlikTech International AB | Method for querying indexed, partitioned dimension tables |
DE102018210091A1 (de) * | 2018-06-21 | 2019-12-24 | Aktiebolaget Skf | Wälzlageranordnung |
KR102271124B1 (ko) * | 2019-12-23 | 2021-06-30 | 주식회사 엘지씨엔에스 | 검색 결과 제공 방법 및 장치 |
Family Cites Families (15)
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 |
US5940818A (en) * | 1997-06-30 | 1999-08-17 | International Business Machines Corporation | Attribute-based access for multi-dimensional databases |
US6122628A (en) * | 1997-10-31 | 2000-09-19 | International Business Machines Corporation | Multidimensional data clustering and dimension reduction for indexing and searching |
US5918232A (en) * | 1997-11-26 | 1999-06-29 | Whitelight Systems, Inc. | Multidimensional domain modeling method and system |
US6298342B1 (en) * | 1998-03-16 | 2001-10-02 | Microsoft Corporation | Electronic database operations for perspective transformations on relational tables using pivot and unpivot columns |
US6542892B1 (en) * | 1999-04-07 | 2003-04-01 | Hewlett-Packard Development Company, L.P. | Configuring a client for a printer using electronic mail |
US6535872B1 (en) * | 1999-04-08 | 2003-03-18 | International Business Machines Corporation | Method and apparatus for dynamically representing aggregated and segmented data views using view element sets |
US6477536B1 (en) * | 1999-06-22 | 2002-11-05 | Microsoft Corporation | Virtual cubes |
US6658413B1 (en) * | 1999-09-01 | 2003-12-02 | I2 Technologies Us, Inc. | Multidimensional database system with intermediate lockable intersections |
US6473764B1 (en) * | 1999-10-15 | 2002-10-29 | Microsoft Corporation | Virtual dimensions in databases and method therefor |
US6954760B2 (en) * | 2001-02-01 | 2005-10-11 | Hitachi, Ltd. | Method and system for multidimensional database management |
US8185487B2 (en) * | 2001-02-12 | 2012-05-22 | Facebook, Inc. | System, process and software arrangement for providing multidimensional recommendations/suggestions |
US7146375B2 (en) * | 2002-01-25 | 2006-12-05 | Decode Genetics, Ehf | Inference control method in a data cube |
US7133856B2 (en) * | 2002-05-17 | 2006-11-07 | The Board Of Trustees Of The Leland Stanford Junior University | Binary tree for complex supervised learning |
US7181450B2 (en) * | 2002-12-18 | 2007-02-20 | International Business Machines Corporation | Method, system, and program for use of metadata to create multidimensional cubes in a relational database |
-
2003
- 2003-06-24 US US10/603,037 patent/US7590638B2/en not_active Expired - Fee Related
-
2004
- 2004-06-07 EP EP04102562.8A patent/EP1492030B1/en not_active Expired - Lifetime
- 2004-06-22 KR KR1020040046510A patent/KR101085666B1/ko active IP Right Grant
- 2004-06-23 JP JP2004185648A patent/JP2005018778A/ja active Pending
- 2004-06-24 CN CNB2004100550385A patent/CN100527126C/zh not_active Expired - Fee Related
Non-Patent Citations (2)
Title |
---|
Relational extensions for OLAP. N. Colossi ET AL.IBM SYSTEMS JOURNAL,Vol.41 No.4. 2002 |
Relational extensions for OLAP. N. Colossi ET AL.IBM SYSTEMS JOURNAL,Vol.41 No.4. 2002 * |
Also Published As
Publication number | Publication date |
---|---|
EP1492030B1 (en) | 2016-10-19 |
US7590638B2 (en) | 2009-09-15 |
KR101085666B1 (ko) | 2011-11-22 |
US20040267799A1 (en) | 2004-12-30 |
EP1492030A2 (en) | 2004-12-29 |
EP1492030A3 (en) | 2005-02-09 |
CN1573754A (zh) | 2005-02-02 |
KR20050001348A (ko) | 2005-01-06 |
JP2005018778A (ja) | 2005-01-20 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20230084389A1 (en) | System and method for providing bottom-up aggregation in a multidimensional database environment | |
CN101971165B (zh) | 数据关系的图形表示 | |
CN100527126C (zh) | 使用维属性和每维多个分层进行联机分析处理的系统和方法 | |
CN101460950B (zh) | 从数据库模式中自动生成web表单 | |
CN100535894C (zh) | 数据库对象脚本生成方法和系统 | |
CN1713179B (zh) | 在对象模型中的影响分析 | |
CN1841379B (zh) | 将文件系统模型映射到数据库对象 | |
CN1692354B (zh) | 信息管理系统、信息处理设备以及信息处理方法 | |
US20110282861A1 (en) | Extracting higher-order knowledge from structured data | |
CN109952569A (zh) | 用于基于字典的连接和聚合的技术 | |
CN101194257A (zh) | 处理搜索信息的方法和系统 | |
US10162855B2 (en) | Systems and methods for optimizing data analysis | |
Paranjape et al. | Improving website hyperlink structure using server logs | |
KR20100094021A (ko) | 이동통신 단말기와 아이피 기반 정보 단말기를 이용한 맞춤, 지능형 심볼, 아이콘 인터넷 정보 검색시스템 | |
KR20210099690A (ko) | 오픈마켓 빅데이터 기반 ai 셀러 관리 시스템 및 방법 | |
US20060224628A1 (en) | Modeling for data services | |
JP2004516553A (ja) | エンティテイにインデックス付けする方法 | |
CN102057377B (zh) | 虚拟化查询中的对象 | |
KR20210143554A (ko) | 오픈마켓 빅데이터를 활용한 ai 키워드 추천 시스템 및 방법 | |
Sakr | A data model and algorithms for a spatial data marketplace | |
CN102880716A (zh) | 被识别实体的相关任务的主动交付 | |
Kimball | The evolving role of the enterprise data warehouse in the era of big data analytics | |
da Silva et al. | Providing geographic-multidimensional decision support over the Web | |
Jung et al. | EE-Cat: Extended electronic catalog for dynamic and flexible electronic commerce | |
JPH10222357A (ja) | データ再利用によるソフトウェア構築方法及びシステム |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
ASS | Succession or assignment of patent right |
Owner name: MICROSOFT TECHNOLOGY LICENSING LLC Free format text: FORMER OWNER: MICROSOFT CORP. Effective date: 20150504 |
|
C41 | Transfer of patent application or patent right or utility model | ||
TR01 | Transfer of patent right |
Effective date of registration: 20150504 Address after: Washington State Patentee after: Micro soft technique license Co., Ltd Address before: Washington State Patentee before: Microsoft Corp. |
|
CF01 | Termination of patent right due to non-payment of annual fee | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20090812 Termination date: 20200624 |