Abstract: A method of establishing a link in a first web page includes establishing a first component in the first web page capable of querying a first data source, establishing a variable named according to a predetermined naming convention, generating an argument to the variable having a field queried in the first data source, establishing a second component in a second web page capable of receiving the variable from the first component, appending the argument to a query statement, and querying a second data source linked to the first data source, and embedding a link to the second web page in the code of the first web page having the variable and the argument.

Abstract: A pivot analysis with an XML/XSL mechanism is disclosed. The pivot analysis is utilized to acquire the raw data from a relational database and then the raw data is converted into a XML data by a pivot transformation mechanism. Furthermore, the XSL/XSLT mechanism is configured to modify the XML data and thus the post processing of the pivot tables, for instance, a row calculation and a column calculation can be performed.

Abstract: A method of establishing a link in a first web page includes establishing a first component in the first web page capable of querying a first data source, establishing a variable named according to a predetermined naming convention, generating an argument to the variable having a field queried in the first data source, establishing a second component in a second web page capable of receiving the variable from the first component, appending the argument to a query statement, and querying a second data source linked to the first data source, and embedding a link to the second web page in the code of the first web page having the variable and the argument.

Abstract: A pivot analysis with an XML/XSL mechanism is disclosed. The pivot analysis is utilized to acquire the raw data from a relational database and then the raw data is converted into a XML data by a pivot transformation mechanism. Furthermore, the XSL/XSLT mechanism is configured to modify the XML data and thus the post processing of the pivot tables, for instance, a row calculation and a column calculation can be performed.

Abstract: The invention provides a method and a system of interface editing and online real-time accessing for a mobile personal device. The system comprises a database, personal mobile device, a database connected to the server, and an interface editing/command setting module. The user can create a new project setting file by the interface-editing/command-setting module then transmit the file to the server. The personal mobile device downloads the needed data for the user and displays the user's personalized layout setting through the connection between the personal mobile device and the server, wherein data transmission can also be wireless data accessing. Therefore, the user can in real-time inquire and update data on-line by using personal mobile device.