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

摘要

PURPOSE: An analytic processing method on a relational database server is provided to eliminate a step for loading to a data warehouse from a conventional method, and to realize an OLAP(On-Line Analytical Processing) function to the relational database. CONSTITUTION: The method comprises the steps of designing the database, and executing the database. The database designing step includes a drill information configuring step(430) configuring the drill information by calling the drill information from a drill information device, a drill information display step(440) displaying the drill information on a screen of a drill information display, and a drill information storing step(460) storing the selected drill information selecting the necessary information from the displayed information. The database executing step includes a fullset data generating step, a drill information configuring step, a mapping drill information configuring step, and a data displaying step.