Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

System and method for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment

A technology of tabular data and cube, applied in the field of database and data warehouse

Active Publication Date: 2018-01-02
ORACLE INT CORP
View PDF4 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, with tabular data that includes hundreds of columns, identifying the patterns used to build the cube can be a daunting task

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • System and method for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment
  • System and method for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment
  • System and method for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] The above, together with other features, will become apparent with reference to the accompanying specification, claims and drawings. Specific details are set forth in order to provide an understanding of various embodiments. It will be apparent, however, that various embodiments may be practiced without these specific details. The accompanying description and drawings are not limiting.

[0016] Multidimensional database environments, examples of which include Oracle Essbase, can be used to integrate large amounts of data (in some cases from multiple data sources) in a manner that addresses the specific requirements of end users, and distribute filtered information to these users.

[0017] figure 1 An example of a multidimensional database environment 100 is illustrated in accordance with an embodiment.

[0018] like figure 1 As shown, according to an embodiment, a multidimensional database environment operating as a database tier may include one or more multidimensi...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

In accordance with an embodiment, described herein is a system and method for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment. A cube schemainference component can successively perform column-wise splits to calculate information gain ratios between each pair of a plurality of columns in the tabular data. A cross correlation matrix can beconstructed from the information gain ratios between each pair of columns. The system can determine relationships among the plurality of columns based on the cross correlation matrix; create a hierarchy directed graph to represent the relationships; and further transform the hierarchy directed graph into a cube schema that can be used to create a cube for loading the tabular data, or to map the tabular data into an existing cube in the multidimensional database environment.

Description

[0001] Copyright Notice [0002] Portions of the disclosure of this patent document contain material that is subject to copyright protection. The copyright owner has no objection to the facsimile reproduction by anyone of the patent document or the patent disclosure as it appears in the Patent and Trademark Office's patent files or records, but otherwise reserves all copyrights in all instances. [0003] priority claim [0004] This application claims the benefit of priority to U.S. Provisional Application No. 62 / 245,885, filed October 23, 2015, entitled "SYSTEM AND METHOD FOR CABESAUTOMATIC INFERENCE OF CUBES FROM TABULAR DATA FOR USE IN A MULTIDIMENSIONALDATABASE," which provisional The application is hereby incorporated by reference. technical field [0005] Embodiments of the invention relate generally to databases and data warehouses, and in particular to systems and methods for automatically inferring cube schemas from tabular data for use in multidimensional database ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
CPCG06F16/211G06F16/212G06F16/283G06F16/9024G06F16/258G06F16/83
Inventor D·阿尔伯格V·贝尔耶夫G·谢克德G·鲁宾
Owner ORACLE INT CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com