Hello All,
I was trying to figure it out about the License Size.
I know its calculated on Raw data size.
What exactly is the definition of Raw Data here ?
1. Total data loaded through COPY statement, this data might come through FILES / other sources(Databases)
2. Data loaded internally, from one table to another using the insert / UPDATE/ MERGE statement.
Which one holds true for Calculating Raw data size.
Thanks
NC
Calculating License Size
+2
For the purpose of license size audit and enforcement, HP Vertica evaluates the raw data size as if the data had been exported from the database in text format
http://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/AdministratorsGuide/Licensing/CalculatingTheDatabaseSize.htm?Highlight=raw%20data
http://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/AdministratorsGuide/Licensing/CalculatingTheDatabaseSize.htm?Highlight=raw%20data
Hi,
How raw data is calculated is already documented. Here is the some part of explanation for you:
HP Vertica uses statistical sampling to calculate an accurate estimate of the raw data size of the database. In this context, raw data means the uncompressed, unfederated data stored in a single HP Vertica database. For the purpose of license size audit and enforcement, HP Vertica evaluates the raw data size as if the data had been exported from the database in text format, rather than as compressed data.
HP Vertica conducts your database size audit using statistical sampling. This method allows HP Vertica to estimate the size of the database without significantly impacting database performance. The trade-off between accuracy and impact on performance is a small margin of error, inherent in statistical sampling.
Not all data in the HP Vertica database is evaluated as part of the raw data size. Specifically, HP Vertica excludes the following data:
*Multiple projections (underlying physical copies) of data from a logical database entity (table). *ata appearing in multiple projections of the same table is counted only once.
*Data stored in temporary tables.
*Data accessible through external table definitions.
*Data that has been deleted, but which remains in the database. To understand more about deleting and purging data, see Purging Deleted Data.
*Data stored in the WOS.
*Data stored in system and work tables such as monitoring tables, Data Collector tables, and Database Designer tables.
Regards'
Abhishek
How raw data is calculated is already documented. Here is the some part of explanation for you:
HP Vertica uses statistical sampling to calculate an accurate estimate of the raw data size of the database. In this context, raw data means the uncompressed, unfederated data stored in a single HP Vertica database. For the purpose of license size audit and enforcement, HP Vertica evaluates the raw data size as if the data had been exported from the database in text format, rather than as compressed data.
HP Vertica conducts your database size audit using statistical sampling. This method allows HP Vertica to estimate the size of the database without significantly impacting database performance. The trade-off between accuracy and impact on performance is a small margin of error, inherent in statistical sampling.
Not all data in the HP Vertica database is evaluated as part of the raw data size. Specifically, HP Vertica excludes the following data:
*Multiple projections (underlying physical copies) of data from a logical database entity (table). *ata appearing in multiple projections of the same table is counted only once.
*Data stored in temporary tables.
*Data accessible through external table definitions.
*Data that has been deleted, but which remains in the database. To understand more about deleting and purging data, see Purging Deleted Data.
*Data stored in the WOS.
*Data stored in system and work tables such as monitoring tables, Data Collector tables, and Database Designer tables.
Regards'
Abhishek
+2Could I request that responses with excerpts from the documentation are actually quoted as such? When a Vertica employee responds to a post, I have an expectation it's their own words. It adds no value to the discussion, in my opinion.
+2Could I request that links to documentation are for the latest version unless the OP explicitly mentions otherwise?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
