Unlock instant, AI-driven research and patent intelligence for your innovation.

Navigation and visualization of relational database

A database, relational technology, applied in the field of database management

Inactive Publication Date: 2011-04-06
BUSINESS OBJECTS SOFTWARE
View PDF9 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

As a result, traditional BI tools do not provide an efficient, navigable representation of the data stored in the database

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
  • Navigation and visualization of relational database
  • Navigation and visualization of relational database
  • Navigation and visualization of relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] The following description is provided to enable any person skilled in the art to make and use the described embodiments, and to set forth the best mode contemplated for carrying out some embodiments. However, various modifications will still be apparent to those skilled in the art.

[0023] figure 1 The system 100 includes a framework for defining information space metadata 110 associated with relational data sources 120 . Relational data source 120 may include any query-responsive data source or source of known or becoming known relational data, including but not limited to a Structured Query Language (SQL) relational database management system.

[0024] Metadata designer 130 may include a software application for creating information space metadata 110 based on relational data sources 120 . Metadata Designer 130 may comprise a stand-alone, web-based or other application running on any computing device or device known or becoming known. figure 1 Dashed lines are use...

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

The invention provides a method and a system of navigation and visualization of a relational database, which include determination of metadata indicating a structure of the relational database, generation of one or more structured query language queries based on the metadata to retrieve, from the relational database, facet values of each of a plurality of facets of the relational database, determination of a display order of the plurality of facets based on the facet values, and generation of an interface to display of the facet values of the plurality of facets in the determined display order. Also included may be generation of one or more structured query language queries based on the metadata to retrieve aggregated values of a measure for each of the facet values of each of the plurality of facets from the relational database, and generation of the interface to display each of the aggregated values in association with a corresponding facet value in the determined display order.

Description

technical field [0001] This application deals with database management. Background technique [0002] Generally, business data is stored in physical tables in a database. Databases may include relational databases such as Oracle, Microsoft SQL Server, IBM DB2, Teradata, and the like. The structure and relationships of physical database tables are complex. To access stored data, users who understand the structure and relationships generate specific database language queries intended to extract the desired data from the database. [0003] Traditionally, business intelligence (BI) tools have typically relied on abstraction layers that shield end users from the complexity of physical tables. The abstraction layer allows end users to query the database using intuitive terms rather than references to specific physical entities of the database. However, generating these queries is beyond the technical capabilities of the average business user. [0004] Also, user-generated que...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F17/30392G06F16/2423
Inventor 扬·L·比亚尼克迪迪尔·博尔夫亚历克西斯·L·奈波
Owner BUSINESS OBJECTS SOFTWARE