News Column

"Hive Table Links" in Patent Application Approval Process

September 2, 2014

By a News Reporter-Staff News Editor at Information Technology Newsweekly -- A patent application by the inventors Jain, Namit (Hyderbad, IN); Murthy, Raghotham Sathyanarayana (San Francisco, CA); Muthukrishnan, Sambavi (Palo Alto, CA); Mandhani, Bhushan (Union City, CA), filed on February 13, 2013, was made available online on August 21, 2014, according to news reporting originating from Washington, D.C., by VerticalNews correspondents.

This patent application has not been assigned to a company or institution.

The following quote was obtained by the news editors from the background information supplied by the inventors: "A data warehouse, in the broadest sense, is a database that contains large stores of current and historical data. In some cases, the data may be integrated from multiple data sources (e.g., marketing databases, sales databases, user databases, and other transactional databases used to maintain the most recent data). Typically, the data is organized and stored within the data warehouse. For example, in some cases, the data may be stored as a series of snapshots. In other cases, the data may be aggregated at a specific time interval (e.g., three months, six months, or older) and/or into specific subject areas.

"When data is integrated from multiple data sources, the data warehouse can provide consistent codes, descriptions, fields, and flagging. For example, suppose that the multiple data sources have different identification mechanisms for a product, the data warehouse may provide a uniform identification mechanism for the product. The data stored in the data warehouse can also be analyzed with tools such as online analytical processing (OLAP) and data mining tools. The results from these analyzes can be used for a variety of business purposes such as generating various analytics and creating reports.

"Over time, data warehouses can start running out of space. One solution is to split the data warehouse into smaller warehouses. These smaller warehouses could be geographically distributed. In some cases, each of the smaller data warehouse may be designed for a specific group of users (e.g., a team) or may host information regarding a particular subject. However, some groups of users or particular subjects may need access to the same data. Simply copying the same data to each of the smaller warehouses is inefficient. Another solution to the capacity problem is to delete data from the data warehouse. However, this data might be valuable in future data mining or analysis activities. As a result, more efficient techniques are needed for managing data within these data warehouses."

In addition to the background information obtained for this patent application, VerticalNews journalists also obtained the inventors' summary information for this patent application: "Systems and methods are described for providing table links within a data warehouse to reduce the amount of data replication. In accordance with various embodiments, a data query can be received from a tenant assigned to a first virtual data warehouse (e.g., a database) within a multi-tenancy data warehouse. Based on the data query a set of information can be generated indicating data the tenant is authorized to access within the multi-tenancy data warehouse. Then, the tenant can declare a subset of the data which the tenant can access and desires to utilize. Any data associated with the declaration that is located outside of the first virtual data warehouse can be imported using a link identifying a set of parameters (e.g., data location, time range, etc.) for retrieving the data. In addition, in some embodiments, the link may only provide read-only access to data outside of the first virtual data warehouse.

"In one or more embodiments, there may be multiple physical data centers and the first virtual data warehouse may be part of a first physical data center. A determination can be made as to whether a subset of the data declared by the tenant is in a second physical data center (e.g., in a virtual data warehouse). If the data is located at the second physical data center, the data from the second physical data center can be cached in the first physical data center. Some embodiments monitor the utilization or access of the data outside of the first virtual data warehouse. A determination can be made as to whether the utilization of the data only includes data from a smaller time range than a time range to which the link provides access. When this is detected, the set of parameter in the link can be updated so that the link only retrieves the data from the smaller time range.

"Embodiments of the present invention also include computer-readable storage media containing sets of instructions to cause one or more processors to perform the methods, variations of the methods, and other operations described herein.

"While multiple embodiments are disclosed, still other embodiments of the present invention will become apparent to those skilled in the art from the following detailed description, which shows and describes illustrative embodiments of the invention. As will be realized, the invention is capable of modifications in various aspects, all without departing from the scope of the present invention. Accordingly, the drawings and detailed description are to be regarded as illustrative in nature and not restrictive.


"Embodiments of the present invention will be described and explained through the use of the accompanying drawings in which:

"FIG. 1 illustrates an example of a multi-tenancy data warehouse environment in which some embodiments of the present invention may be utilized;

"FIG. 2 shows a block diagram with components which can be used in accordance with one or more embodiments of the present invention;

"FIG. 3 is a flowchart with a set of operations for generating a table link in accordance with various embodiments of the present invention;

"FIG. 4 is a flowchart with a set of operations for retrieving data within a data warehouse environment in accordance with some embodiments of the present invention;

"FIG. 5 is a flowchart with a set of operations for propagating updates to table links within a multi-tenancy data warehouse in accordance with various embodiments of the present invention;

"FIG. 6 is a block diagram of a system architecture of the social networking system with which some embodiments of the present invention may be utilized; and

"FIG. 7 illustrates an example of a computer system with which some embodiments of the present invention may be utilized.

"The drawings have not necessarily been drawn to scale. For example, the dimensions of some of the elements in the figures may be expanded or reduced to help improve the understanding of the embodiments of the present invention. Similarly, some components and/or operations may be separated into different blocks or combined into a single block for the purposes of discussion of some of the embodiments of the present invention. Moreover, while the invention is amenable to various modifications and alternative forms, specific embodiments have been shown by way of example in the drawings and are described in detail below. The intention, however, is not to limit the invention to the particular embodiments described. On the contrary, the invention is intended to cover all modifications, equivalents, and alternatives falling within the scope of the invention as defined by the appended claims."

URL and more information on this patent application, see: Jain, Namit; Murthy, Raghotham Sathyanarayana; Muthukrishnan, Sambavi; Mandhani, Bhushan. Hive Table Links. Filed February 13, 2013 and posted August 21, 2014. Patent URL:

Keywords for this news article include: Patents, Information Technology, Information and Data Mining, Information and Data Aggregation.

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

Story Tools Facebook Linkedin Twitter RSS Feed Email Alerts & Newsletters