System, method and computer program product for calculating a size of an entity
View Patent ↗In accordance with embodiments, there are provided mechanisms and methods for calculating a size of an entity. These mechanisms and methods for calculating a size of an entity can enable optimized data analysis, improved system resource knowledge, increased efficiency, etc.
1. A computer program product embodied on a non-transitory computer readable medium, comprising:
computer code for identifying an entity implemented within a multi-tenant on-demand database system, where the entity includes a tenant of the system;
computer code for determining one or more indexes associated with the entity; and
computer code for calculating a size of the entity including an amount of storage consumed by the entity by:
selecting a sample clause representing a portion of the one or more indexes associated with the entity;
dynamically generating structured query language (SQL) instructions for all columns of each index within the sample clause to determine a sample size of data in bytes within the columns of the sample clause, where the SQL instructions utilize a vsize function for all columns of each index within the sample clause to determine a size of data in bytes within the columns of the sample clause; and
estimating, using the sample size, a total size of data within all of the indexes associated with the entity.
2. The computer program product of claim 1 , wherein the entity is identified by receiving input from a user.
3. The computer program product of claim 1 , wherein the entity is identified utilizing an entity identifier (ID).
4. The computer program product of claim 1 , wherein the entity is identified in response to a request for data associated with the entity.
5. The computer program product of claim 1 , wherein determining the one or more indexes includes retrieving a list of all indexes associated with the entity.
6. The computer program product of claim 1 , wherein determining the one or more indexes may include requesting index details from the system using structured query language (SQL) code.
7. The computer program product of claim 1 , wherein the one or more indexes associated with the entity are described in a list of a data dictionary.
8. The computer program product of claim 1 , wherein the one or more indexes include one or more tables.
9. The computer program product of claim 1 , wherein the size of the entity includes an amount of data used by the entity within a system.
10. The computer program product of claim 1 , further comprising computer code for reporting the size of the entity to a user.
11. The computer program product of claim 10 , wherein a report is created that includes the size of the entity, and such report is distributed to the user.
12. The computer program product of claim 11 , wherein the report sent to the user includes a size of each index associated with the entity.
13. The computer program product of claim 1 , wherein the one or more indexes include one or more custom indexes.
14. The computer program product of claim 4 , wherein the entity is identified in response to a request for details regarding the amount of storage consumed by the entity.
15. The computer program product of claim 1 , wherein generating SQL instructions for all columns of each index within the sample clause includes looping through a list of the one or more indexes within the sample clause and dynamically generating the SQL instructions for all columns of each index.
16. A method, comprising:
identifying an entity implemented within a multi-tenant on-demand database system, where the entity includes a tenant of the system;
determining one or more indexes associated with the entity, utilizing a processor; and
calculating a size of the entity including an amount of storage consumed by the entity by:
selecting a sample clause representing a portion of the one or more indexes associated with the entity;
dynamically generating structured query language (SQL) instructions for all columns of each index within the sample clause to determine a sample size of data in bytes within the columns of the sample clause, where the SQL instructions utilize a vsize function for all columns of each index within the sample clause to determine a size of data in bytes within the columns of the sample clause; and
estimating, using the sample size, a total size of data within all of the indexes associated with the entity.
17. An apparatus, comprising:
a processor for:
identifying an entity implemented within a multi-tenant on-demand database system, where the entity includes a tenant of the system;
determining one or more indexes associated with the entity; and
calculating a size of the entity including an amount of storage consumed by the entity by:
selecting a sample clause representing a portion of the one or more indexes associated with the entity;
dynamically generating structured query language (SQL) instructions for all columns of each index within the sample clause to determine a sample size of data in bytes within the columns of the sample clause, where the SQL instructions utilize a vsize function for all columns of each index within the sample clause to determine a size of data in bytes within the columns of the sample clause; and
estimating, using the sample size, a total size of data within all of the indexes associated with the entity.