Patent ID: 7447704

Claim:
A method of data processing in a relational database for performing a pivot analysis through a network, comprising: acquiring raw data from said relational database via a series of designated SQL (Structured Query Language) commands, wherein said raw data is multi-level hierarchical dimension data, and a number of SQL commands used to acquire the raw data is calculated according to an equation NSQL =(NR÷1)×(Nc÷1), wherein NSQL represents a number of SQL commands used to acquire data, NR represents a number of rows of the raw data, and Nc represents a number of columns of the raw data; converting said raw data into first markup language data via designated hierarchial sorting; converting said first markup language data into second markup language data by using a stylesheet transformation method, wherein said first markup language data is different with said second markup language data, and said first and second markup language data can be transferred through said network; and outputting said second markup language data through said network.