Analytical Operation as Drill Up and Down of OLAP Tools From RDBMS

摘要

The method of the present invention is to visit the region of interest in the OLAP tools, data warehouse in order to improve the interest in difficulty themselves easy to find an area in which when expressed statistics (CrossTab) type queries in the (End User Computing) in a relational DB EUC It relates to an analytical method in which a relational DB applied to a relational DB.; Analytical method according to the invention is shown drilling information to be displayed on the screen in the drilling information configuration step, a drilling information indicator to give information configured in the drilling information configuration step of configuring a drill information drill call information from the drilling information organizer ; and drilling information storage group DB design phase comprising the selected drill-information storage step of storing selection information to select only the necessary information from the drill drills the information displayed and; Results generator is interlocked with a relational DB full set data generating step of generating a full set of data and any drill Configuring group any drilling information configuration step, information mapping groups the DB design phase constituting any drilling information, based on the full set of data a selecting mapping drilling information configuration step and a selection data display step of displaying the selected data based on the selection data indicator is in the mapping drilling information to the screen constituting the drilling information mapped by mapping to the drilling information, the arbitrary drilling information that is stored in the It includes the step of running DB.