×

Hive table links

  • US 10,339,157 B2
  • Filed: 02/13/2013
  • Issued: 07/02/2019
  • Est. Priority Date: 02/13/2013
  • Status: Active Grant
First Claim
Patent Images

1. A method, comprising:

  • receiving a data query from a tenant assigned to a first virtual data warehouse included in a plurality of virtual data warehouses located within a multi-tenancy data warehouse, wherein the first virtual data warehouse is a database part of a first physical data center,wherein the tenant is associated with multiple namespaces, wherein the data query identifies a first namespace of the multiple namespaces, wherein the multiple namespaces are mapped to the multi-tenancy data warehouse, wherein the multi-tenancy data warehouse corresponds to a physical data warehouse, and wherein the first virtual data warehouse is included in a first physical data center;

    generating a set of information, based on the data query, indicating data the tenant is authorized to access within the multi-tenancy data warehouse;

    receiving a declaration from the tenant to utilize a subset of the data which the tenant can access as indicated by the set of information;

    determining whether the subset of the data is in a second physical data center that is different from the first physical data center;

    in response to determining the subset of the data is in a second physical data center different from the first physical data center, caching the subset of the data from the second physical data center in the first physical data center and generating a link identifying a set of parameters for retrieving the data, wherein the set of parameters comprises a time range of data to be retrieved;

    importing data that is outside of the first virtual data warehouse using the link;

    preventing access, by the first namespace using a two-part name syntax, to a second virtual warehouse by the first virtual data warehouse, wherein the second virtual data warehouse is included in the plurality of virtual data warehouses;

    monitoring utilization of the data outside of the first virtual data warehouse;

    determining the utilization of the data only includes data from a smaller time range; and

    updating the set of parameters so that the link only retrieves the data from the smaller time range.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×