IP Library Granted Patent US 10,817,479
Granted Patent B2
US 10,817,479 · App. 15/631,306 · Granted Oct 27, 2020

Recommending data providers' datasets based on database value densities

Inventors: Arun Kumar Jagota (Sunnyvale, CA); Marc Joseph Delurgio (San Anselmo, CA); Venkata Murali Tejomurtula (Fremont, CA)
Assignee: salesforce.com, inc.
G06F16/185G06F16/214G06F16/2462G06F16/313G06F17/18
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,817,479
App. No.
15/631,306
Granted
Oct 27, 2020
Kind
B2
Abstract

Recommending data providers' datasets based on database value densities is described. A database system determines a provider dataset density for a value by identifying a frequency of the value in a dataset that is provided by a data provider. The database system determines a user database density for the value by identifying a frequency of the value in a database used by a data user. The database system determines a relative density based on a relationship between the provider dataset density and the user database density. The database system determines an evaluation metric for the value, based on a combination of the relative density and the user database density. The database system causes a recommendation to be outputted, based on a relationship of the evaluation metric relative to other evaluation metrics for other values, which recommends that the data user acquire at least a part of the dataset.

Claims (34)

1. A system comprising:

one or more processors; and

a non-transitory computer readable medium storing a plurality of instructions, which when executed, cause the one or more processors to:

determine, by a database system, a provider dataset density for a value by identifying a relationship of a total number of records in a dataset that store the value in record fields of an attribute compared to a total number of records in the dataset that store any value in record fields of the attribute, wherein the dataset is provided by a data provider;

determine, by the database system, a user database density for the value by identifying a relationship of a total number of records in a database that store the value in record fields of the attribute compared to a total number of records in the database that store any value in record fields of the attribute, wherein the database is used by a data user;

determine, by the database system, a relative density based on a relationship between the provider dataset density and the user database density;

determine, by the database system, an evaluation metric for the value, based on a combination of the relative density and the user database density; and

cause, by the database system, a recommendation to be outputted, based on a relationship of the evaluation metric relative to other evaluation metrics for other values, which recommends that the data user acquire at least a part of the dataset.

2. The system of claim 1 , wherein the total number of records in the database that store the value in record fields of the attribute is based on a plurality of weights that are associated with a plurality of instances of the value and that correspond to a plurality of entities stored by the database.

3. The system of claim 1 , wherein determining the relative density based on the relationship between the provider dataset density and the user database density comprises determining a ratio between the user database density and the provider dataset density.

4. The system of claim 1 , wherein the combination of the relative density and the user database density comprises one of a sum of the relative density and the user database density, and a product of the relative density and the user database density.

5. The system of claim 4 , wherein the sum of the relative density and the user database density comprises a sum of a first product and a second product, the first product being a product of the relative density and a relative density weight, the second product being a product of the user database density and a user database density weight, at least one of the relative density weight and the user database density weight being adjusted based on usage of the database by at least one data user.

6. The system of claim 1 , wherein at least the part of the dataset comprises a subset of a larger dataset provided by the data provider.

7. A computer program product comprising a non-transitory computer-readable medium which stores computer-readable program code to be executed by one or more processors when retrieved from a non-transitory computer-readable medium, the non-transitory computer-readable medium comprising program code including instructions to:

determine, by a database system, a provider dataset density for a value by identifying a relationship of a total number of records in a dataset that store the value in record fields of an attribute compared to a total number of records in the dataset that store any value in record fields of the attribute, wherein the dataset is provided by a data provider;

determine, by the database system, a user database density for the value by identifying a relationship of a total number of records in a database that store the value in record fields of the attribute compared to a total number of records in the database that store any value in record fields of the attribute, wherein the database is used by a data user;

determine, by the database system, a relative density based on a relationship between the provider dataset density and the user database density;

determine, by the database system, an evaluation metric for the value, based on a combination of the relative density and the user database density; and

cause, by the database system, a recommendation to be outputted, based on a relationship of the evaluation metric relative to other evaluation metrics for other values, which recommends that the data user acquire at least a part of the dataset.

8. The computer program product of claim 7 , wherein the total number of records in the database that store the value in record fields of the attribute is based on a plurality of weights that are associated with a plurality of instances of the value and that correspond to a plurality of entities stored by the database.

9. The computer program product of claim 7 , wherein determining the relative density based on the relationship between the provider dataset density and the user database density comprises determining a ratio between the user database density and the provider dataset density.

10. The computer program product of claim 7 , wherein the combination of the relative density and the user database density comprises one of a sum of the relative density and the user database density, and a product of the relative density and the user database density, and wherein the sum of the relative density and the user database density comprises a sum of a first product and a second product, the first product being a product of the relative density and a relative density weight, the second product being a product of the user database density and a user database density weight, at least one of the relative density weight and the user database density weight being adjusted based on usage of the database by at least one data user.

11. The computer program product of claim 7 , wherein at least the part of the dataset comprises a subset of a larger dataset provided by the data provider.

12. A method comprising:

determining, by a database system, a provider dataset density for a value by identifying a relationship of a total number of records in a dataset that store the value in record fields of an attribute compared to a total number of records in the dataset that store any value in record fields of the attribute, wherein the dataset is provided by a data provider;

determining, by the database system, a user database density for the value by identifying a relationship of a total number of records in a database that store the value in record fields of the attribute compared to a total number of records in the database that store any value in record fields of the attribute, wherein the database is used by a data user;

determining, by the database system, a relative density based on a relationship between the provider dataset density and the user database density;

determining, by the database system, an evaluation metric for the value, based on a combination of the relative density and the user database density; and

causing, by the database system, a recommendation to be outputted, based on a relationship of the evaluation metric relative to other evaluation metrics for other values, the recommendation being that the data user acquire at least a part of the dataset.

13. The method of claim 12 , wherein the total number of records in the database that store the value in record fields of the attribute is based on a plurality of weights that are associated with a plurality of instances of the value and that correspond to a plurality of entities stored by the database.

14. The method of claim 12 , wherein determining the relative density based on the relationship between the provider dataset density and the user database density comprises determining a ratio between the user database density and the provider dataset density.

15. The method of claim 12 , wherein the combination of the relative density and the user database density comprises one of a sum of the relative density and the user database density, and a product of the relative density and the user database density.

16. The method of claim 15 , wherein the sum of the relative density and the user database density comprises a sum of a first product and a second product, the first product being a product of the relative density and a relative density weight, the second product being a product of the user database density and a user database density weight, at least one of the relative density weight and the user database density weight being adjusted based on usage of the database by at least one data user.

17. The method of claim 12 , wherein at least the part of the dataset comprises a subset of a larger dataset provided by the data provider.

Assignments (2)
CHANGE OF NAME Recorded Oct 3, 2023
From: SALESFORCE.COM, INC.
To: SALESFORCE, INC.
Reel/Frame 065114/0983 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 23, 2017
From: JAGOTA, ARUN KUMAR; DELURGIO, MARC JOSEPH; TEJOMURTULA, VENKATA MURALI
To: SALESFORCE.COM, INC.
Reel/Frame 042796/0092 →
Continuity (1)
Related Publication 20180373732A1 · Dec 27, 2018