Luming Wang

US Patent:

8082239, Dec 20, 2011

Filed:

Feb 4, 2008

Appl. No.:

12/025696

Inventors:

Xiaohong Yang - Sammamish WA, US
Luming Wang - Bellevue WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30

US Classification:

707705, 707600, 707737

Abstract:

Technologies are described herein for defining the scope of a sub-cube based upon a database query. A request is received to perform a query of a multi-dimensional database, such as a cube, stored at a server computer. In response to the request, the scope for a sub-portion, called a sub-cube, of the multi-dimensional database is determined based upon the query. The scope of the sub-cube may be determined by identifying the minimum sub-portion of the cube necessary to perform the query. Once the scope has been determined, the sub-cube is generated at the server computer and transmitted to a client computer. The client computer stores the sub-cube locally and performs the requested database query on the sub-cube stored at the client computer. A user interface may be provided through which a user can modify the scope of the sub-cube determined based upon the query.

US Patent:

8103687, Jan 24, 2012

Filed:

Jun 3, 2008

Appl. No.:

12/132075

Inventors:

Patrick John Baumgartner - Pullman WA, US
Luming Wang - Bellevue WA, US
Jason Malcolm - Renton WA, US
Xiaohong Yang - Sammamish WA, US
Peter Eberhardy - Seattle WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707758, 707766, 707769

Abstract:

Tools and techniques are described for selecting member sets for generating asymmetric queries. User interfaces provided by this description may include representations of different dimensions that include respective members. These dimensions define hierarchical data structures against which queries are run to generate requested reports. The user interfaces may include representations of members associated with different dimensions, with members from different dimensions arranged in selected orders. The user interfaces may also provide selection tools that activate symmetrical or asymmetrical rendering modes for constructing the query. In the symmetrical rendering mode, the query cross-joins all of the members selected from one dimension with all of the members selected from the other dimension. In the asymmetrical rendering mode, the query cross-joins the first-ordered member from one dimension with the first-ordered member from another dimension, cross-joins the second member from one dimension with the second member from another dimension, and so on.

US Patent:

8204853, Jun 19, 2012

Filed:

Nov 17, 2008

Appl. No.:

12/272684

Inventors:

Jin Wang - Kirkland WA, US
Luming Wang - Bellevue WA, US
Malik Hussain - Woodinville WA, US
Zaiwei Du - Bellevue WA, US
Zhenyu Tang - Sammamish WA, US
Patrick J. Baumgartner - Kirkland WA, US
Mark Xiaohong Yang - Sammamish WA, US
Peter Eberhardy - Seattle WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30

US Classification:

707610, 707695

Abstract:

Data processing architecture where submitters can write data and/or metadata changes to a destination through an asynchronous interface. The architecture includes a ticketing system that issues a ticket (a unique identifier) to the submitter in response to receiving a changelist from the submitter. When the changes are successfully completed at the destination, the cached destination data can be re-downloaded to the submitter, and the changes cached in the submitter, discarded. Absent this capability, a user has to manually manage the cached changes and cached data. The architecture can be distributed in that multiple submitters can submit changelists. The destination provides data integrity by managing submissions to assist in ensuring data integrity across multiple submissions. Automatic changelist cleanup is provided on the submitter so that changelists do not impact performance, memory, and storage.

US Patent:

8239248, Aug 7, 2012

Filed:

Mar 7, 2007

Appl. No.:

11/714975

Inventors:

Patrick Baumgartner - Kirkland WA, US
Alisson Sol - Cambridge, GB
Peter Eberhardy - Seattle WA, US
Luming Wang - Bellevue WA, US
Mark Yang - Sammamish WA, US
Amer Shahnawaz - Redmond WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06Q 40/00

US Classification:

705 8, 705 7, 705 10, 705 35, 705 36, 705 37

Abstract:

Techniques to manage information for dynamic reports are described. An apparatus may comprise a business planning application module to update a current period reference to a time member of a time dimension, generate a rolling data entry form with actual data members and forecast data members based on the current period reference, and set a data locking mode for the actual data members and a data access mode for the forecast data members. Other embodiments are described and claimed.

US Patent:

8341512, Dec 25, 2012

Filed:

Oct 31, 2007

Appl. No.:

11/931857

Inventors:

Alisson A. S. Sol - Cambridge, GB
Luming Wang - Bellevue WA, US
Xiaohong Mark Yang - Sammamish WA, US
Patrick J. Baumgartner - Pullman WA, US
Peter Eberhardy - Seattle WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/00
G06F 17/20
G06F 17/21

US Classification:

715212, 715215, 715222

Abstract:

An interface for designing a report is provided, with elements of the report being disposed at intersections of report positions and configured to present information derived from data in a database. A formula is associated with one or more selected elements in the report to generate a result for the one or more selected elements. A tuple identifying the report positions of the one or more selected elements is associated and stored with the formula in a formula list associated with the report. The report is configured so that, when the report is generated, it is determined whether identifying report positions corresponding to an identified element in the report correspond with the tuple in the formula list. Upon determining the tuple corresponds with the identifying report positions for the identified element, the formula associated with the tuple is applied to generate the result.

US Patent:

8473473, Jun 25, 2013

Filed:

Mar 16, 2010

Appl. No.:

12/724764

Inventors:

Luming Wang - Bellevue WA, US
Xiaohong Yang - Sammamish WA, US
Hailei Zhang - Sammamish WA, US
Sonal Jain - Bothell WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707705, 707709, 707710

Abstract:

An object oriented search mechanism extracts structural metadata and data based on type of document contents and data sources connected to the documents. Relationships between textual and non-textual elements within documents as well as metadata associated with the elements and data sources are utilized to generate a unified object model with the addition of semantic information derived from metadata and taxonomy, which are used to enhance search indexing, ranking of search results, and dynamic adjustment of result rendering user interface with fine tuned relevancy. Additional data from data sources connected to the documents may also be used to unlock hidden data such as data that has been filtered out in an original document.

US Patent:

8515906, Aug 20, 2013

Filed:

Jun 12, 2012

Appl. No.:

13/494650

Inventors:

Jin Wang - Kirkland WA, US
Luming Wang - Bellevue WA, US
Malik Hussain - Woodinville WA, US
Zaiwei Du - Bellevue WA, US
Zhenyu Tang - Sammamish WA, US
Patrick J. Baumgartner - Kirkland WA, US
Mark Xiaohong Yang - Sammamish WA, US
Peter Eberhardy - Seattle WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30

US Classification:

707610, 707695

Abstract:

Data processing architecture where submitters can write data and/or metadata changes to a destination through an asynchronous interface. The architecture includes a ticketing system that issues a ticket (a unique identifier) to the submitter in response to receiving a changelist from the submitter. When the changes are successfully completed at the destination, the cached destination data can be re-downloaded to the submitter, and the changes cached in the submitter, discarded. Absent this capability, a user has to manually manage the cached changes and cached data. The architecture can be distributed in that multiple submitters can submit changelists. The destination provides data integrity by managing submissions to assist in ensuring data integrity across multiple submissions. Automatic changelist cleanup is provided on the submitter so that changelists do not impact performance, memory, and storage.

US Patent:

8560519, Oct 15, 2013

Filed:

Mar 19, 2010

Appl. No.:

12/727739

Inventors:

Luming Wang - Bellevue WA, US
Xiaohong Yang - Sammamish WA, US
Anton Amirov - Redmond WA, US
Pablo Barvo - Bothell WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30

US Classification:

707709

Abstract:

Relationships between linked and/or embedded documents as well as documents sharing data source(s) are captured and rendered through virtual documents. Virtual documents are created representing linked/embedded documents and data sources associated with a relevant document. Relationships between real and virtual documents are preserved and rendered along with search results providing a user a comprehensive picture of search results.