CN101111838A - 多维企业软件系统中的自动关系模式生成 - Google Patents
多维企业软件系统中的自动关系模式生成 Download PDFInfo
- Publication number
- CN101111838A CN101111838A CNA200580047412XA CN200580047412A CN101111838A CN 101111838 A CN101111838 A CN 101111838A CN A200580047412X A CNA200580047412X A CN A200580047412XA CN 200580047412 A CN200580047412 A CN 200580047412A CN 101111838 A CN101111838 A CN 101111838A
- Authority
- CN
- China
- Prior art keywords
- data
- database schema
- dimension
- template
- report
- 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
Links
- 238000000034 method Methods 0.000 claims abstract description 61
- 230000000694 effects Effects 0.000 claims description 15
- 230000004048 modification Effects 0.000 claims description 10
- 238000012986 modification Methods 0.000 claims description 10
- 230000004044 response Effects 0.000 claims description 3
- 238000007667 floating Methods 0.000 claims description 2
- 238000012423 maintenance Methods 0.000 claims 1
- 230000008569 process Effects 0.000 abstract description 32
- 238000007726 management method Methods 0.000 description 13
- 238000005516 engineering process Methods 0.000 description 11
- 230000008859 change Effects 0.000 description 10
- 238000006116 polymerization reaction Methods 0.000 description 8
- 230000015572 biosynthetic process Effects 0.000 description 6
- 238000013500 data storage Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 5
- 230000008929 regeneration Effects 0.000 description 4
- 238000011069 regeneration method Methods 0.000 description 4
- 230000002708 enhancing effect Effects 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 238000007689 inspection Methods 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000005855 radiation Effects 0.000 description 1
- 230000001172 regenerating effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- UPPMZCXMQRVMME-UHFFFAOYSA-N valethamate Chemical compound CC[N+](C)(CC)CCOC(=O)C(C(C)CC)C1=CC=CC=C1 UPPMZCXMQRVMME-UHFFFAOYSA-N 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
-
- 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/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/213—Schema design and management with details for schema evolution support
-
- 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/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)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Tourism & Hospitality (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
列 | 描述 |
对象名称 | 包含用于存储模板对象(如立方体和维度)的表格的名称。 |
显示名称 | 包含用户12在企业应用程序中所看到的、模板对象(如立方体和维度)的显示名称。 |
对象id | 包含模板对象的全球唯一标识符(GUID)。 |
对象类型id | 包含对象类型标识符,其标识这一行所描述的是哪一类型的表格。 |
数据存储类型id | 包含数据存储对象类型标识符,其表示这一行所描 |
述的是什么类型的数据库对象,例如数据库TABLE或数据库VIEW。 | |
对象版本 | 指定用来创建对象的企业软件的版本。 |
最后保存的 | 包含对象最后被发布时的时戳。这列是可选的。 |
库id | 包含用来创建该对象的企业软件库的标识符。这列是可选的。 |
列 | 描述 |
对象名称 | 包含模板对象的表格的名称。对象名称是与在应用对象表格的对象名称列中发现的相同的名称。 |
列名称 | 包含用于发布对象的表格中所包含的列的名称。 |
显示名称 | 包含用户在企业应用程序中所看到的显示名称,以与包含在用于发布规划对象的表格中的列相关。这实质是列的可读名称,以代替在数据库系统中使用的名称,其中数据库系统可能具有对某些字符的限制。 |
列id | 这是与包含在用于发布规划对象的表格中的列相关的GUID。 |
对象类型id | 包含包含该列的表格的对象类型id。 |
列类型id | 包含用于该列的独立的数据类型标识符。该标识符例如可以是TEXT_VALUE或FLOAT_VALUE。 |
列顺序 | 包含在用于发布规划对象的表格中该列的顺序。这被用来对列的显示进行排序。 |
逻辑数据类型 | 包含用于该列的RDBMS独立类型标识符。 |
维度guid | 包含格式化的列的维度的GUID。 |
项目id | 具有数据类型和格式的列的GUID。 |
格式类型 | 列的数据类型。如数字,数据或百分比。 |
负标记符号 | 用于代表负值的符号。 |
小数位的数量 | 要显示的小数位(或精度)的数量。 |
缩放比例因数 | 数字值的缩放比例因数。 |
零值字符 | 用于表示等于0的值的字符。 |
Claims (44)
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US11/000,345 US7610300B2 (en) | 2004-11-30 | 2004-11-30 | Automated relational schema generation within a multidimensional enterprise software system |
US11/000,345 | 2004-11-30 | ||
PCT/IB2005/004139 WO2006064383A2 (en) | 2004-11-30 | 2005-11-16 | Automated relational schema generation within a multidimentional enterprise software system |
Publications (2)
Publication Number | Publication Date |
---|---|
CN101111838A true CN101111838A (zh) | 2008-01-23 |
CN101111838B CN101111838B (zh) | 2011-01-19 |
Family
ID=36568456
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN200580047412XA Expired - Fee Related CN101111838B (zh) | 2004-11-30 | 2005-11-16 | 多维企业软件系统中的自动关系模式生成 |
Country Status (6)
Country | Link |
---|---|
US (1) | US7610300B2 (zh) |
EP (1) | EP1836620A4 (zh) |
CN (1) | CN101111838B (zh) |
AU (1) | AU2005315255B2 (zh) |
CA (1) | CA2588341A1 (zh) |
WO (1) | WO2006064383A2 (zh) |
Cited By (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103119618A (zh) * | 2010-04-20 | 2013-05-22 | Ips株式会社 | 数据库、业务内容数据管理服务器和业务内容数据管理程序 |
CN104391927A (zh) * | 2014-11-21 | 2015-03-04 | 浪潮通用软件有限公司 | 一种多维数据模型的维度重构实现方法 |
CN106156130A (zh) * | 2015-04-09 | 2016-11-23 | 阿里巴巴集团控股有限公司 | 一种数据处理方法及装置 |
CN108345602A (zh) * | 2017-01-22 | 2018-07-31 | 株式会社日立制作所 | 数据多维建模系统及数据多维建模方法 |
CN108595552A (zh) * | 2018-04-10 | 2018-09-28 | 平安科技(深圳)有限公司 | 数据立方体发布方法、装置、电子设备和存储介质 |
CN109947861A (zh) * | 2017-11-09 | 2019-06-28 | 北京京东尚科信息技术有限公司 | 用于数据仓库生成目标表的方法、装置和计算机可读介质 |
CN111295651A (zh) * | 2017-09-29 | 2020-06-16 | 甲骨文国际公司 | 在多维数据库环境中使多个父母具有权重的系统和方法 |
CN112236761A (zh) * | 2018-06-27 | 2021-01-15 | 国际商业机器公司 | 数据立方体的动态增量更新 |
CN114741445A (zh) * | 2022-03-03 | 2022-07-12 | 北京元年科技股份有限公司 | 数据导出方法、装置、设备及计算机可读存储介质 |
Families Citing this family (79)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7505888B2 (en) * | 2004-11-30 | 2009-03-17 | International Business Machines Corporation | Reporting model generation within a multidimensional enterprise software system |
US7593955B2 (en) * | 2004-11-30 | 2009-09-22 | International Business Machines Corporation | Generation of aggregatable dimension information within a multidimensional enterprise software system |
FR2888018A1 (fr) * | 2005-07-01 | 2007-01-05 | Medience Sa | Procede et systeme de realisation d'une base de donnees virtuelle a partir de sources de donnees presentant des schemas heterogenes |
US20070073765A1 (en) * | 2005-09-23 | 2007-03-29 | Epiphany, Inc. | Metadata-based schema generator |
US7720803B2 (en) * | 2006-03-28 | 2010-05-18 | Sap Ag | Mapping of a transactional data model to a reporting data model |
US20080126395A1 (en) * | 2006-11-28 | 2008-05-29 | Ocyrhoe Technologies Ltd | Automatically creating a relational database from a spreadsheet |
US20080147704A1 (en) * | 2006-12-13 | 2008-06-19 | Godwin Debbie A | Systems and methods for propagation of database schema changes |
US20080222189A1 (en) * | 2007-03-06 | 2008-09-11 | Microsoft Corporation | Associating multidimensional data models |
US7685186B2 (en) * | 2007-06-25 | 2010-03-23 | Microsoft Corporation | Optimized and robust in-place data transformation |
US20080319780A1 (en) * | 2007-06-25 | 2008-12-25 | Microsoft Corporation | Defining reports for dimension based enterprise resource planning systems |
US20090287737A1 (en) * | 2007-10-31 | 2009-11-19 | Wayne Hammerly | Architecture for enabling rapid database and application development |
US8380748B2 (en) * | 2008-03-05 | 2013-02-19 | Microsoft Corporation | Multidimensional data cubes with high-cardinality attributes |
US8838652B2 (en) * | 2008-03-18 | 2014-09-16 | Novell, Inc. | Techniques for application data scrubbing, reporting, and analysis |
US7930322B2 (en) * | 2008-05-27 | 2011-04-19 | Microsoft Corporation | Text based schema discovery and information extraction |
US10102262B2 (en) | 2008-08-29 | 2018-10-16 | Red Hat, Inc. | Creating reports using dimension trees |
US8874502B2 (en) * | 2008-08-29 | 2014-10-28 | Red Hat, Inc. | Real time datamining |
US9098538B2 (en) * | 2008-10-06 | 2015-08-04 | Teradata Us, Inc. | Master data management versioning |
GB0818864D0 (en) | 2008-10-15 | 2008-11-19 | Dow Corning | Fabric and fibre conditioning additives |
US7970728B2 (en) * | 2008-10-23 | 2011-06-28 | International Business Machines Corporation | Dynamically building and populating data marts with data stored in repositories |
US20100131457A1 (en) * | 2008-11-26 | 2010-05-27 | Microsoft Corporation | Flattening multi-dimensional data sets into de-normalized form |
US20110029478A1 (en) * | 2009-05-20 | 2011-02-03 | Broeker Stephen A | Stream Star Schema and Nested Binary Tree for Data Stream Analysis |
US8478786B2 (en) | 2010-09-14 | 2013-07-02 | Microsoft Corporation | Automatic layout derivation and implementation |
US20120102453A1 (en) * | 2010-10-21 | 2012-04-26 | Microsoft Corporation | Multi-dimensional objects |
US9396283B2 (en) | 2010-10-22 | 2016-07-19 | Daniel Paul Miranker | System for accessing a relational database using semantic queries |
US9754230B2 (en) * | 2010-11-29 | 2017-09-05 | International Business Machines Corporation | Deployment of a business intelligence (BI) meta model and a BI report specification for use in presenting data mining and predictive insights using BI tools |
US20120222004A1 (en) * | 2011-02-24 | 2012-08-30 | Intuit Inc. | Publishing and updating of multidimensional models using orchestration tools for software offerings |
US8612405B1 (en) | 2011-09-30 | 2013-12-17 | Emc Corporation | System and method of dynamic data object upgrades |
US9164751B2 (en) * | 2011-09-30 | 2015-10-20 | Emc Corporation | System and method of rolling upgrades of data traits |
US8990675B2 (en) | 2011-10-04 | 2015-03-24 | Microsoft Technology Licensing, Llc | Automatic relationship detection for spreadsheet data items |
US9038014B2 (en) * | 2011-12-15 | 2015-05-19 | Microsoft Technology Licensing, Llc | Intelligently recommending schemas based on user input |
US20130339399A1 (en) * | 2012-06-18 | 2013-12-19 | Dexter A. Dorris | Dynamic Schema |
EP2690563A1 (en) * | 2012-07-23 | 2014-01-29 | BRANDAD Systems AG | Method and device for reporting on data of documents generated from templates |
US9430550B2 (en) | 2012-09-28 | 2016-08-30 | Oracle International Corporation | Clustering a table in a relational database management system |
US9507825B2 (en) | 2012-09-28 | 2016-11-29 | Oracle International Corporation | Techniques for partition pruning based on aggregated zone map information |
US8996544B2 (en) | 2012-09-28 | 2015-03-31 | Oracle International Corporation | Pruning disk blocks of a clustered table in a relational database management system |
WO2014092697A1 (en) * | 2012-12-11 | 2014-06-19 | Tmm Data, Llc | Methods and systems for collecting, managing, and sharing data |
US10642837B2 (en) | 2013-03-15 | 2020-05-05 | Oracle International Corporation | Relocating derived cache during data rebalance to maintain application performance |
US9626388B2 (en) | 2013-09-06 | 2017-04-18 | TransMed Systems, Inc. | Metadata automated system |
US11042516B2 (en) | 2013-12-06 | 2021-06-22 | Micro Focus Llc | Flexible schema table |
US9817851B2 (en) * | 2014-01-09 | 2017-11-14 | Business Objects Software Ltd. | Dyanmic data-driven generation and modification of input schemas for data analysis |
US11288290B2 (en) * | 2014-12-18 | 2022-03-29 | Ab Initio Technology Llc | Building reports |
US20160283523A1 (en) | 2015-03-24 | 2016-09-29 | International Business Machines Corporation | Schema generation using natural language processing |
EP3332335A1 (en) * | 2015-08-06 | 2018-06-13 | Convida Wireless, LLC | Mechanisms for multi-dimension data operations |
US10438013B2 (en) | 2016-06-19 | 2019-10-08 | Data.World, Inc. | Platform management of integrated access of public and privately-accessible datasets utilizing federated query generation and query schema rewriting optimization |
US10853376B2 (en) | 2016-06-19 | 2020-12-01 | Data.World, Inc. | Collaborative dataset consolidation via distributed computer networks |
US10824637B2 (en) | 2017-03-09 | 2020-11-03 | Data.World, Inc. | Matching subsets of tabular data arrangements to subsets of graphical data arrangements at ingestion into data driven collaborative datasets |
US11675808B2 (en) | 2016-06-19 | 2023-06-13 | Data.World, Inc. | Dataset analysis and dataset attribute inferencing to form collaborative datasets |
US10324925B2 (en) | 2016-06-19 | 2019-06-18 | Data.World, Inc. | Query generation for collaborative datasets |
US11941140B2 (en) | 2016-06-19 | 2024-03-26 | Data.World, Inc. | Platform management of integrated access of public and privately-accessible datasets utilizing federated query generation and query schema rewriting optimization |
US11947554B2 (en) | 2016-06-19 | 2024-04-02 | Data.World, Inc. | Loading collaborative datasets into data stores for queries via distributed computer networks |
US10353911B2 (en) | 2016-06-19 | 2019-07-16 | Data.World, Inc. | Computerized tools to discover, form, and analyze dataset interrelations among a system of networked collaborative datasets |
US11334625B2 (en) | 2016-06-19 | 2022-05-17 | Data.World, Inc. | Loading collaborative datasets into data stores for queries via distributed computer networks |
US10747774B2 (en) | 2016-06-19 | 2020-08-18 | Data.World, Inc. | Interactive interfaces to present data arrangement overviews and summarized dataset attributes for collaborative datasets |
US11755602B2 (en) | 2016-06-19 | 2023-09-12 | Data.World, Inc. | Correlating parallelized data from disparate data sources to aggregate graph data portions to predictively identify entity data |
US10515085B2 (en) | 2016-06-19 | 2019-12-24 | Data.World, Inc. | Consolidator platform to implement collaborative datasets via distributed computer networks |
US10452975B2 (en) | 2016-06-19 | 2019-10-22 | Data.World, Inc. | Platform management of integrated access of public and privately-accessible datasets utilizing federated query generation and query schema rewriting optimization |
US11468049B2 (en) | 2016-06-19 | 2022-10-11 | Data.World, Inc. | Data ingestion to generate layered dataset interrelations to form a system of networked collaborative datasets |
US11023104B2 (en) | 2016-06-19 | 2021-06-01 | data.world,Inc. | Interactive interfaces as computerized tools to present summarization data of dataset attributes for collaborative datasets |
US10645548B2 (en) | 2016-06-19 | 2020-05-05 | Data.World, Inc. | Computerized tool implementation of layered data files to discover, form, or analyze dataset interrelations of networked collaborative datasets |
US12008050B2 (en) | 2017-03-09 | 2024-06-11 | Data.World, Inc. | Computerized tools configured to determine subsets of graph data arrangements for linking relevant data to enrich datasets associated with a data-driven collaborative dataset platform |
US11238109B2 (en) | 2017-03-09 | 2022-02-01 | Data.World, Inc. | Computerized tools configured to determine subsets of graph data arrangements for linking relevant data to enrich datasets associated with a data-driven collaborative dataset platform |
US11086876B2 (en) | 2017-09-29 | 2021-08-10 | Oracle International Corporation | Storing derived summaries on persistent memory of a storage device |
US10922308B2 (en) | 2018-03-20 | 2021-02-16 | Data.World, Inc. | Predictive determination of constraint data for application with linked data in graph-based datasets associated with a data-driven collaborative dataset platform |
US11243960B2 (en) | 2018-03-20 | 2022-02-08 | Data.World, Inc. | Content addressable caching and federation in linked data projects in a data-driven collaborative dataset platform using disparate database architectures |
USD940732S1 (en) | 2018-05-22 | 2022-01-11 | Data.World, Inc. | Display screen or portion thereof with a graphical user interface |
US12117997B2 (en) | 2018-05-22 | 2024-10-15 | Data.World, Inc. | Auxiliary query commands to deploy predictive data models for queries in a networked computing platform |
US11947529B2 (en) | 2018-05-22 | 2024-04-02 | Data.World, Inc. | Generating and analyzing a data model to identify relevant data catalog data derived from graph-based data arrangements to perform an action |
USD940169S1 (en) | 2018-05-22 | 2022-01-04 | Data.World, Inc. | Display screen or portion thereof with a graphical user interface |
US11442988B2 (en) | 2018-06-07 | 2022-09-13 | Data.World, Inc. | Method and system for editing and maintaining a graph schema |
US10726052B2 (en) | 2018-07-03 | 2020-07-28 | Sap Se | Path generation and selection tool for database objects |
US10936557B2 (en) | 2018-07-26 | 2021-03-02 | International Business Machines Corporation | Relational database schema generation |
US10901987B2 (en) * | 2018-12-14 | 2021-01-26 | Sap Se | Dynamic automatic generation of database views |
US11144549B2 (en) | 2018-12-14 | 2021-10-12 | Sap Se | Dynamic generation of join statements for database operations |
US10895973B2 (en) | 2019-04-23 | 2021-01-19 | Google Llc | Browsing hierarchical datasets |
CN111310434B (zh) * | 2020-02-28 | 2024-01-19 | 北京金堤科技有限公司 | 文本生成方法和装置、电子设备和存储介质 |
US11853324B2 (en) | 2021-05-10 | 2023-12-26 | Argo AI, LLC | Systems and methods for atomic publication of distributed writes to a distributed data warehouse |
US11755621B2 (en) * | 2021-05-10 | 2023-09-12 | Argo AI, LLC | Systems and methods for atomic publication of distributed writes to a distributed data warehouse |
US11681698B2 (en) | 2021-05-10 | 2023-06-20 | Argo AI, LLC | Systems and methods for atomic publication of distributed writes to a distributed data warehouse |
US11947600B2 (en) | 2021-11-30 | 2024-04-02 | Data.World, Inc. | Content addressable caching and federation in linked data projects in a data-driven collaborative dataset platform using disparate database architectures |
Family Cites Families (55)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5379419A (en) * | 1990-12-07 | 1995-01-03 | Digital Equipment Corporation | Methods and apparatus for accesssing non-relational data files using relational queries |
US5734887A (en) * | 1995-09-29 | 1998-03-31 | International Business Machines Corporation | Method and apparatus for logical data access to a physical relational database |
US5692181A (en) * | 1995-10-12 | 1997-11-25 | Ncr Corporation | System and method for generating reports from a computer database |
US5870746A (en) * | 1995-10-12 | 1999-02-09 | Ncr Corporation | System and method for segmenting a database based upon data attributes |
JP3952518B2 (ja) * | 1996-03-29 | 2007-08-01 | 株式会社日立製作所 | 多次元データ処理方法 |
US5721910A (en) | 1996-06-04 | 1998-02-24 | Exxon Research And Engineering Company | Relational database system containing a multidimensional hierachical model of interrelated subject categories with recognition capabilities |
US5978788A (en) * | 1997-04-14 | 1999-11-02 | International Business Machines Corporation | System and method for generating multi-representations of a data cube |
US5978796A (en) * | 1997-06-30 | 1999-11-02 | International Business Machines Corporation | Accessing multi-dimensional data by mapping dense data blocks to rows in a relational database |
US6205447B1 (en) * | 1997-06-30 | 2001-03-20 | International Business Machines Corporation | Relational database management of multi-dimensional data |
US6134541A (en) * | 1997-10-31 | 2000-10-17 | International Business Machines Corporation | Searching multidimensional indexes using associated clustering and dimension reduction information |
US5918232A (en) * | 1997-11-26 | 1999-06-29 | Whitelight Systems, Inc. | Multidimensional domain modeling method and system |
JP2002526833A (ja) * | 1998-09-30 | 2002-08-20 | アイツー テクノロジーズ, インコーポレイテッド | 多次元データ管理システム |
US6154766A (en) * | 1999-03-23 | 2000-11-28 | Microstrategy, Inc. | System and method for automatic transmission of personalized OLAP report output |
US6282544B1 (en) * | 1999-05-24 | 2001-08-28 | Computer Associates Think, Inc. | Method and apparatus for populating multiple data marts in a single aggregation process |
US6477536B1 (en) * | 1999-06-22 | 2002-11-05 | Microsoft Corporation | Virtual cubes |
US6385604B1 (en) * | 1999-08-04 | 2002-05-07 | Hyperroll, Israel Limited | Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements |
CA2281331A1 (en) * | 1999-09-03 | 2001-03-03 | Cognos Incorporated | Database management system |
US6510420B1 (en) * | 1999-09-30 | 2003-01-21 | International Business Machines Corporation | Framework for dynamic hierarchical grouping and calculation based on multidimensional member characteristics |
US7328206B2 (en) * | 1999-10-15 | 2008-02-05 | Microsoft Corporation | Extensions for adding and removing calculated members in a multidimensional database |
GB9924523D0 (en) * | 1999-10-15 | 1999-12-15 | Univ Strathclyde | Database processor |
US6484179B1 (en) * | 1999-10-25 | 2002-11-19 | Oracle Corporation | Storing multidimensional data in a relational database management system |
US6418427B1 (en) * | 1999-12-30 | 2002-07-09 | Decode Genetics Ehf | Online modifications of dimension structures in multidimensional processing |
US20020029207A1 (en) * | 2000-02-28 | 2002-03-07 | Hyperroll, Inc. | Data aggregation server for managing a multi-dimensional database and database management system having data aggregation server integrated therein |
US6768986B2 (en) * | 2000-04-03 | 2004-07-27 | Business Objects, S.A. | Mapping of an RDBMS schema onto a multidimensional data model |
US6594672B1 (en) * | 2000-06-01 | 2003-07-15 | Hyperion Solutions Corporation | Generating multidimensional output using meta-models and meta-outlines |
CA2311884A1 (en) * | 2000-06-16 | 2001-12-16 | Cognos Incorporated | Method of managing slowly changing dimensions |
WO2002021378A1 (en) * | 2000-09-05 | 2002-03-14 | Big Think Llc | System and method for personalization implemented on multiple networks and multiple interfaces |
US6801921B2 (en) * | 2000-09-08 | 2004-10-05 | Hitachi, Ltd. | Method and system for managing multiple database storage units |
US6829621B2 (en) * | 2000-10-06 | 2004-12-07 | International Business Machines Corporation | Automatic determination of OLAP cube dimensions |
US7287218B1 (en) * | 2000-10-25 | 2007-10-23 | Bea Systems, Inc. | Dynamic publication of information from a database |
US7039871B2 (en) * | 2000-10-27 | 2006-05-02 | Swiftknowledge, Inc. | Secure data access in a multidimensional data environment |
US6714940B2 (en) * | 2001-11-15 | 2004-03-30 | International Business Machines Corporation | Systems, methods, and computer program products to rank and explain dimensions associated with exceptions in multidimensional data |
US7028046B2 (en) * | 2002-03-19 | 2006-04-11 | Hyperion Solutions Corporation | Method of splitting a multi-dimensional cube between a multi-dimensional and a relational database |
US6691102B2 (en) * | 2002-03-26 | 2004-02-10 | International Business Machines Corporation | Query processing method of name-value pairs in relational databases |
US7171427B2 (en) * | 2002-04-26 | 2007-01-30 | Oracle International Corporation | Methods of navigating a cube that is implemented as a relational object |
US7366730B2 (en) * | 2002-04-26 | 2008-04-29 | Oracle International Corporation | Registration of solved cubes within a relational database management system |
US8868544B2 (en) | 2002-04-26 | 2014-10-21 | Oracle International Corporation | Using relational structures to create and support a cube within a relational database system |
US6965903B1 (en) * | 2002-05-07 | 2005-11-15 | Oracle International Corporation | Techniques for managing hierarchical data with link attributes in a relational database |
US20040181519A1 (en) * | 2002-07-09 | 2004-09-16 | Mohammed Shahbaz Anwar | Method for generating multidimensional summary reports from multidimensional summary reports from multidimensional data |
JP2004094425A (ja) * | 2002-08-30 | 2004-03-25 | Hitachi Ltd | データベース構築処理変更方法 |
US6768995B2 (en) * | 2002-09-30 | 2004-07-27 | Adaytum, Inc. | Real-time aggregation of data within an enterprise planning environment |
US7072822B2 (en) * | 2002-09-30 | 2006-07-04 | Cognos Incorporated | Deploying multiple enterprise planning models across clusters of application servers |
US7467125B2 (en) * | 2002-12-12 | 2008-12-16 | International Business Machines Corporation | Methods to manage the display of data entities and relational database structures |
US7716167B2 (en) * | 2002-12-18 | 2010-05-11 | International Business Machines Corporation | System and method for automatically building an OLAP model in a relational database |
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 |
US7953694B2 (en) * | 2003-01-13 | 2011-05-31 | International Business Machines Corporation | Method, system, and program for specifying multidimensional calculations for a relational OLAP engine |
US20040193633A1 (en) * | 2003-03-28 | 2004-09-30 | Cristian Petculescu | Systems, methods, and apparatus for automated dimensional model definitions and builds utilizing simplified analysis heuristics |
US7089266B2 (en) * | 2003-06-02 | 2006-08-08 | The Board Of Trustees Of The Leland Stanford Jr. University | Computer systems and methods for the query and visualization of multidimensional databases |
US7756907B2 (en) * | 2003-09-16 | 2010-07-13 | The Board Of Trustees Of The Leland Stanford Jr. University | Computer systems and methods for visualizing data |
US7593969B2 (en) * | 2003-12-31 | 2009-09-22 | Microsoft Corporation | Linked dimension and measure groups |
US7844570B2 (en) * | 2004-07-09 | 2010-11-30 | Microsoft Corporation | Database generation systems and methods |
US7562086B2 (en) * | 2004-07-09 | 2009-07-14 | Microsoft Corporation | Custom grouping for dimension members |
US7418438B2 (en) * | 2004-11-30 | 2008-08-26 | International Business Machines Corporation | Automated default dimension selection within a multidimensional enterprise software system |
US7505888B2 (en) * | 2004-11-30 | 2009-03-17 | International Business Machines Corporation | Reporting model generation within a multidimensional enterprise software system |
US7593955B2 (en) * | 2004-11-30 | 2009-09-22 | International Business Machines Corporation | Generation of aggregatable dimension information within a multidimensional enterprise software system |
-
2004
- 2004-11-30 US US11/000,345 patent/US7610300B2/en not_active Expired - Fee Related
-
2005
- 2005-11-16 CN CN200580047412XA patent/CN101111838B/zh not_active Expired - Fee Related
- 2005-11-16 WO PCT/IB2005/004139 patent/WO2006064383A2/en active Application Filing
- 2005-11-16 CA CA002588341A patent/CA2588341A1/en not_active Abandoned
- 2005-11-16 AU AU2005315255A patent/AU2005315255B2/en not_active Ceased
- 2005-11-16 EP EP05850815A patent/EP1836620A4/en not_active Withdrawn
Cited By (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103119618A (zh) * | 2010-04-20 | 2013-05-22 | Ips株式会社 | 数据库、业务内容数据管理服务器和业务内容数据管理程序 |
CN104391927A (zh) * | 2014-11-21 | 2015-03-04 | 浪潮通用软件有限公司 | 一种多维数据模型的维度重构实现方法 |
CN106156130B (zh) * | 2015-04-09 | 2019-11-12 | 阿里巴巴集团控股有限公司 | 一种数据处理方法及装置 |
CN106156130A (zh) * | 2015-04-09 | 2016-11-23 | 阿里巴巴集团控股有限公司 | 一种数据处理方法及装置 |
CN108345602A (zh) * | 2017-01-22 | 2018-07-31 | 株式会社日立制作所 | 数据多维建模系统及数据多维建模方法 |
CN108345602B (zh) * | 2017-01-22 | 2021-06-25 | 株式会社日立制作所 | 数据多维建模系统及数据多维建模方法 |
CN111295651A (zh) * | 2017-09-29 | 2020-06-16 | 甲骨文国际公司 | 在多维数据库环境中使多个父母具有权重的系统和方法 |
CN111295651B (zh) * | 2017-09-29 | 2023-09-26 | 甲骨文国际公司 | 在多维数据库环境中使多个父母具有权重的系统和方法 |
CN109947861A (zh) * | 2017-11-09 | 2019-06-28 | 北京京东尚科信息技术有限公司 | 用于数据仓库生成目标表的方法、装置和计算机可读介质 |
CN108595552A (zh) * | 2018-04-10 | 2018-09-28 | 平安科技(深圳)有限公司 | 数据立方体发布方法、装置、电子设备和存储介质 |
CN112236761A (zh) * | 2018-06-27 | 2021-01-15 | 国际商业机器公司 | 数据立方体的动态增量更新 |
CN112236761B (zh) * | 2018-06-27 | 2023-12-22 | 勤达睿公司 | 数据立方体的动态增量更新 |
CN114741445A (zh) * | 2022-03-03 | 2022-07-12 | 北京元年科技股份有限公司 | 数据导出方法、装置、设备及计算机可读存储介质 |
Also Published As
Publication number | Publication date |
---|---|
AU2005315255B2 (en) | 2009-11-05 |
WO2006064383A3 (en) | 2006-10-05 |
EP1836620A2 (en) | 2007-09-26 |
CA2588341A1 (en) | 2006-06-22 |
US20060117057A1 (en) | 2006-06-01 |
EP1836620A4 (en) | 2010-08-04 |
CN101111838B (zh) | 2011-01-19 |
WO2006064383A2 (en) | 2006-06-22 |
US7610300B2 (en) | 2009-10-27 |
AU2005315255A1 (en) | 2006-06-22 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101111838B (zh) | 多维企业软件系统中的自动关系模式生成 | |
CN100568237C (zh) | 多维企业软件系统中的报表模板生成方法和系统 | |
CN101111835B (zh) | 多维企业软件系统中的自动默认维度选择方法 | |
CN101167048B (zh) | 多维企业软件系统内的可聚集维度信息的生成 | |
CN101084494B (zh) | 用于管理计算机环境中的工作流的方法和设备 | |
Rifaie et al. | Data modelling for effective data warehouse architecture and design | |
El Beggar et al. | Towards an MDA-oriented UML profiles for data warehouses design and development | |
Hoppe | Sales and inventory planning with SAP APO | |
Prakash et al. | Requirements Engineering for Data Warehousing | |
Li | Data warehouse design: an investigation of star schema | |
Radut et al. | Designing a Data Warehouse. Case Study: SC “AMBIENT” SA | |
Ismail | Framework and database for organizing external information for strategic management in the construction industry: application to the Egyptian market | |
Pletch et al. | The account data model | |
Janus et al. | Cubes, Dimensions, and Measures | |
Shirahatti | Business Planning and Forecasting Application for Synopsys, Inc. | |
Langer et al. | Data Warehousing | |
Copalu | Book store information system | |
Garanar | The service manufacturing system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C41 | Transfer of patent application or patent right or utility model | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20081219 Address after: American New York Applicant after: International Business Machines Corp. Address before: Amsterdam, The Netherlands Applicant before: IBM International Group Effective date of registration: 20081219 Address after: Amsterdam, The Netherlands Applicant after: IBM International Group Address before: Alberta Canada Applicant before: Coorg Los Unlimited Co. Effective date of registration: 20081219 Address after: Alberta Canada Applicant after: Coorg Los Unlimited Co. Address before: American Minnesota Applicant before: Cognos Inc. |
|
ASS | Succession or assignment of patent right |
Owner name: INTERNATIONAL BUSINESS MACHINE CORP. Free format text: FORMER OWNER: IBM INTERNATIONAL GROUP CO.,LTD. Effective date: 20081219 Owner name: IBM INTERNATIONAL GROUP CO.,LTD. Free format text: FORMER OWNER: CARL LOEWS CO.,LTD. Effective date: 20081219 |
|
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20110119 Termination date: 20151116 |
|
EXPY | Termination of patent right or utility model |