Patent · US Active

Facilitating identification of star schemas in database environments

US9158818B2 · kind B2 · utility

0Cited by

12References

16Claims

0Family size

Assignee

Oracle International Corporation · US

Inventors

Geemon Kadambalil Baby · Bengaluru, IN
Mahesh Jayashankar · Bengaluru, IN
Paolo Fragapane · Bristol, GB
Suresh Mali · Bengaluru, IN
Mike Durran · Nailsea, GB
Ashish Mittal · Bengaluru, IN
James Steadman · Ledbury, GB

Key dates

Filing date	Apr 5, 2007
Grant date	Oct 13, 2015
Priority date	—
Expiry date	Jul 18, 2031

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/2456
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

Facilitating identification of star schemas in database environments. In an embodiment, queries directed to relational database tables (organized according to normalized schema) are examined to determine the relationships specified in the queries. A star schema is then generated by including the specified relationships. A data warehouse may be organized according to the generated star schema and the data previously stored in the database tables may be copied to the data warehouse.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.