MonetDB - Data Compression, is it possible?
All,
Is there any data compression methods available in MonetDB? What I understand from I read is, by default MonetDB doesn't have a compression methods to avoid the overhead of uncompression while loading the files into memory mapped files. Is that true? If there is a compression mechanism (alike QUERY HIGH Compression in Oracle) what is it in here?
Regards, Sreejith
Sreejith,
the answer is simple: No, there is currently no support for data compression in MonetDB.
Having said that, purely to reduce the DB footprint on disk as well as I/O volume, people have successfully used MonetDB on top of a compressing file system, as far as I know.
Best, Stefan
----- On Nov 21, 2017, at 1:00 PM, Sharma, Sreejith Sreejith.Sharma@harman.com wrote:
All,
Is there any data compression methods available in MonetDB? What I understand from I read is, by default MonetDB doesn’t have a compression methods to avoid the overhead of uncompression while loading the files into memory mapped files. Is that true? If there is a compression mechanism (alike QUERY HIGH Compression in Oracle) what is it in here?
Regards,
Sreejith
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Thanks Stefan. That helps.
Regards, Sreejith
On 21-Nov-2017, at 11:49 PM, Stefan Manegold <Stefan.Manegold@cwi.nlmailto:Stefan.Manegold@cwi.nl> wrote:
Sreejith,
the answer is simple: No, there is currently no support for data compression in MonetDB.
Having said that, purely to reduce the DB footprint on disk as well as I/O volume, people have successfully used MonetDB on top of a compressing file system, as far as I know.
Best, Stefan
----- On Nov 21, 2017, at 1:00 PM, Sharma, Sreejith Sreejith.Sharma@harman.commailto:Sreejith.Sharma@harman.com wrote:
All,
Is there any data compression methods available in MonetDB? What I understand from I read is, by default MonetDB doesn’t have a compression methods to avoid the overhead of uncompression while loading the files into memory mapped files. Is that true? If there is a compression mechanism (alike QUERY HIGH Compression in Oracle) what is it in here?
Regards,
Sreejith
_______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://clicktime.symantec.com/a/1/q6CTdcD4sHC4jIirKo_CgZTwdfqqQ229WSdJMq6Rm...
-- | Stefan.Manegold@CWI.nlmailto:Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/http://www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | _______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://clicktime.symantec.com/a/1/q6CTdcD4sHC4jIirKo_CgZTwdfqqQ229WSdJMq6Rm...
participants (2)
-
Sharma, Sreejith
-
Stefan Manegold