Benjamin Z Li

US Patent:

6658432, Dec 2, 2003

Filed:

Jun 20, 2001

Appl. No.:

09/884444

Inventors:

Ali Alavi - Arlington VA
Glenn J. Boysko - Herndon VA
Gunther L. Brenes - Oakland CA
L. Douglas Everhart - Arlington VA
Benjamin Z. Li - Great Falls VA
Arturo Oliver - Reston VA
Abhimanyu Warikoo - New York NY

Assignee:

Microstrategy, Inc. - McLean VA

International Classification:

G06F 1730

US Classification:

7071041, 707 1

Abstract:

A layered architecture for communication of reporting system reports to users connecting via a web server. Users communicate via HTTP with web servers without download of plugins or executable files to the user system. The web servers are clustered to balance requests and transmit the requests. The web servers pass report requests via XML to the business intelligence servers to perform the work with the databases. The business intelligence servers convert reports into XML and provide the XML-based version to the web server. The web server then transmits an HTML or DHTMNL report back to the client over the web.

US Patent:

6697808, Feb 24, 2004

Filed:

Jun 19, 2001

Appl. No.:

09/883172

Inventors:

William Hurwood - Washington DC
Benjamin Z. Li - Great Falls VA
Abhimanyu Warikoo - New York NY

Assignee:

MicroStrategy, Inc. - McLean VA

International Classification:

G06F 1730

US Classification:

707 10, 707103 R

Abstract:

Methods and systems are provided for use in searching a metadata repository used to store metadata objects relating to data stored in a storage device of a decision support system. In embodiments of the invention, a search object is submitted to an object server by a requestor. The object server may search itself for objects meeting the search criteria. If unsuccessful, the search object may be sent to a metadata server which uses a metadata search engine to search the metadata repository. Results of the search may be returned to the requestor by the object server.

US Patent:

6704723, Mar 9, 2004

Filed:

Jun 20, 2001

Appl. No.:

09/884471

Inventors:

Ali Alavi - Arlington VA
Yuan Ding - Fairfax VA
Benjamin Z. Li - Great Falls VA
Abhimanyu Warikoo - New York NY

Assignee:

Microstrategy, Incorporated - McLean VA

International Classification:

G06F 1730

US Classification:

707 3, 707 4

Abstract:

A method and system is provided for exchanging information over a computer network. A network server computer system receives a query request from at least one client computer system over a computer network. The query request is formatted into an extensible markup language query document according to an extensible markup language document application program interface. The extensible markup language query document is transmitted to at least one business intelligence server computer system. The at least one business intelligence server computer system retrieves the information requested in the extensible markup language query document from at least one data storage device.

US Patent:

6772137, Aug 3, 2004

Filed:

Jun 20, 2001

Appl. No.:

09/884446

Inventors:

William Hurwood - Washington DC
Benjamin Z. Li - Great Falls VA
Barry R. Lovalvo - Dallas TX
Abhimanyu Warikoo - New York NY

Assignee:

MicroStrategy, Inc. - McLean VA

International Classification:

G06F 1730

US Classification:

707 2, 707 1, 709201

Abstract:

An object management system in a reporting system. The system includes an object data repository and an object server in a reporting system. The object data repository may maintain a definition and other information for at least one object accessible by a plurality of user interfaces. The server may provide a single access point for enabling users at a plurality of user sites to access objects stored in the object data repository.

US Patent:

6801910, Oct 5, 2004

Filed:

Jun 19, 2001

Appl. No.:

09/883505

Inventors:

Jeffrey A. Bedell - Arlington VA
Scott Cappiello - Arlington VA
L. Douglas Everhart - Arlington VA
William Hurwood - Washington DC
Benjamin Z. Li - Great Falls VA
Fabrice Martin - Washington DC
David B. Sherwood - McLean VA
Steven S. Trundle - Falls Church VA

Assignee:

MicroStrategy, Incorporated - McLean VA

International Classification:

G06F 1730

US Classification:

707 6, 707 2, 707 5, 715514, 715902, 715907

Abstract:

A method and system for guiding drilling into a report are disclosed. Through the use of the invention, a user can drill within a first report dimension or from the first report dimension into a second report dimension. Additionally, a drill map providing a plurality of drilling paths is associated with each report. The system of the invention includes drill transformation tools and drill map management tools for assisting a user in navigating through report instances.

US Patent:

6820073, Nov 16, 2004

Filed:

Mar 20, 2002

Appl. No.:

10/101488

Inventors:

Jeffrey A. Bedell - Arlington VA
William Hurwood - Washington DC
Benjamin Z. Li - Great Falls VA
Sadanand Sahasrabudhe - McLean VA
Xinyi Wang - Herndon VA
Jun Yuan - Sterling VA

Assignee:

MicroStrategy Inc. - McLean VA

International Classification:

G06F 1730

US Classification:

707 2, 707 3, 707 4, 707 10, 709203

Abstract:

A system for collaborative processing, comprising a controlling module with access to at least one relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database. The controlling module is capable of iteratively processing a multi-step calculation including generating SQL statements to the relational database, passing preliminary results to an external analytical engine and saving data back into the relational database for further processing until the multi-step calculation is performed.

US Patent:

6859798, Feb 22, 2005

Filed:

Jun 20, 2001

Appl. No.:

09/884472

Inventors:

Jeffrey A. Bedell - Arlington VA, US
Benjamin Z. Li - Great Falls VA, US
Luis V. Orozco - Vienna VA, US
Ramkumar Ramachandran - Reston VA, US
Michael J. Saylor - Great Falls VA, US
Stephen S. Trundle - Falls Church VA, US

Assignee:

MicroStrategy, Inc. - McLean VA

International Classification:

G06F015/18

US Classification:

706 45, 707 10

Abstract:

An intelligence server for a reporting system is disclosed. The reporting system may include a report initiation module, such as a user engine or calling application, for generating a request for a report. The intelligence server includes a server layer for receiving the generated request and for coordinating a flow of a processing of the received request; an application logic layer which includes business intelligence rules used for generating the report; and an analytical layer, in communication with the user engine and the server layer, for receiving the request to be processed from the server layer, transmitting the processed request to one or more data storage devices, and for extracting data from the data storage devices responsive to the transmitted request. The extracted data is then processed by the applications in the application logic layer to generate the report and the processing is independent of a user interface.

US Patent:

6996568, Feb 7, 2006

Filed:

Apr 11, 2002

Appl. No.:

10/120144

Inventors:

Jeffrey A. Bedell - Arlington VA, US
William Hurwood - Washington DC, US
Benjamin Z. Li - Great Falls VA, US
Fabrice Martin - Washington DC, US
Sadanand Sahasrabudhe - McLean VA, US
Jun Yuan - Sterling VA, US

Assignee:

MicroStrategy Incorporated - McLean VA

International Classification:

G06F 17/30

US Classification:

707100, 707 3, 707102, 715500

Abstract:

A system and method for defining and using logical extensions to a set of data stored in a relational database. A metadata definition for various extensions is stored to explain how to extend data as it is stored into a logical representation suitable for reporting and calculating purposes. An analytical engine translates report requests into SQL queries to access the physically stored data using the metadata extension definitions if necessary to generate appropriate results. Here, data is stored in at least one table that is physically keyed by a set of attributes with the attribute determining the granularity or level of data contained within the tables. A report request causes the engine to calculate and/or display the data at a lower level of granularity than exists, thereby invoking the metadata definitions. The extension definitions may describe how to extend data from the physical to the logical including joins and allocation rules.