News Column

Patent Application Titled "Distributed Data Warehouse" Published Online

April 29, 2014

By a News Reporter-Staff News Editor at Information Technology Newsweekly -- According to news reporting originating from Washington, D.C., by VerticalNews journalists, a patent application by the inventors Yan, An (Sammamish, WA); Zhao, Mingyang (Issaquah, WA); Wang, Robert C. (Redmond, WA); Chen, Yu (Sammamish, WA); Anderson, Blake (Kirkland, WA), filed on October 10, 2012, was made available online on April 17, 2014.

The assignee for this patent application is Microsoft Corporation.

Reporters obtained the following quote from the background information supplied by the inventors: "The continued increase in the numbers and types of computing platforms has contributed to a corresponding gain in the amount of data available for analysis. The change in the amount of available data is driven by both an increase in the number of events that can be effectively captured as well as increases in the types of data that can be easily stored for a given event. Keyword searching for information on a wide area network provides one example of how the amount of available data for analysis has changed. In recent years, the number of people performing searches has increased, the types of information being searched for has increased, and providers of search engines have become increasingly sophisticated in identifying information that is valuable for data mining. Many other types of on-line and/or business activities have seen similar growth in available information."

In addition to obtaining background information on this patent application, VerticalNews editors also obtained the inventors' summary information for this patent application: "In various embodiments, methods and data structures are provided for allowing data mining with improved efficiency. During processing of a usage log (or multiple logs) for an activity, such as a usage logfile of network search activity, a common fact table is generated. The common fact table allows a plurality of auxiliary data structures to be formed from the common fact table. These auxiliary data structures are designed to allow users to submit queries against the contents of the data structure in order to investigate the data. Use of a common fact table for forming auxiliary data structures allows multiple users to further investigate the underlying data from the usage log while maintaining consistency in the auxiliary data structures used by the multiple users. The efficiency of access of the common fact table is improved by allowing users to access auxiliary data structures other than the auxiliary data structures that are associated with a user. Optionally, the common fact table and/or the auxiliary data structures can include dimension values that correspond to both pre-identified dimension values as well as dimension values that are identified during processing of the activity logfiles.

"This Summary is provided to introduce a selection of concepts in a simplified form that are further described below in the Detailed Description. This Summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used as an aid, in isolation, in determining the scope of the claimed subject matter.


"The invention is described in detail below with reference to the attached drawing figures, wherein:

"FIG. 1 shows a limited example of an auxiliary data structure that includes only two dimensions.

"FIG. 2 schematically shows an example of a system for creating a common fact table and auxiliary data structures.

"FIG. 3 is a block diagram of an exemplary computing environment suitable for use in implementing embodiments of the present invention.

"FIG. 4 schematically shows a network environment suitable for performing embodiments of the invention.

"FIGS. 5-6 show examples of various methods enabled by using a common fact table and auxiliary data structures.

"FIG. 7 shows another limited example of an auxiliary data structure that includes only two dimensions."

For more information, see this patent application: Yan, An; Zhao, Mingyang; Wang, Robert C.; Chen, Yu; Anderson, Blake. Distributed Data Warehouse. Filed October 10, 2012 and posted April 17, 2014. Patent URL:

Keywords for this news article include: Microsoft Corporation, Information Technology, Information and Data Mining, Information and Data Architecture.

Our reports deliver fact-based news of research and discoveries from around the world. Copyright 2014, NewsRx LLC

For more stories covering the world of technology, please see HispanicBusiness' Tech Channel

Source: Information Technology Newsweekly