System, method, and computer program product for accessing and manipulating remote datasets

• Main Authors: HOWARD KENNETH, CHIRLIAN PETER, KAPLAN ERIC J, SHUKHAT ALEKSANDR, GU BEI
• Format: Patent
• Language: English
• Published: 07.08.2012
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

A method, system and computer program product for creating a report on the basis of a plurality of remote datasets. The system for achieving this includes an intelligence server, connected to one or more tree servers. The tree servers are in turn connected to one or more databases. A user specifies a report to be created by the system. A client, acting on behalf of the user, creates a report definition that is sent to the intelligence server and the tree servers. Each tree server creates one or more segments, or slices, of the report, using the information that resides on the tree server. These slices are then sent to the intelligence server, which aggregates the slices into a tree structure. The tree structure is then converted into a report for presentation to the client. Moreover, the intelligence server receives updates from the tree servers as necessary. To do so, the tree servers and the intelligence server remain in communication for the purposes of passing update messages. The update messages are received and processed at the intelligence server in a manner that facilitates synchronization with the contributing tree servers and provides live updates to the user.