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
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
Thanks Stefan. That helps. Regards, Sreejith On 21-Nov-2017, at 11:49 PM, Stefan Manegold <Stefan.Manegold@cwi.nl<mailto: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.com<mailto: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<mailto:users-list@monetdb.org> https://clicktime.symantec.com/a/1/q6CTdcD4sHC4jIirKo_CgZTwdfqqQ229WSdJMq6RmtY=?d=48PhZxXq960oW1CW8PwWNgP3bdNKOoGVFdcUjBfb5P_AvkjHWWVaXgNIXAVFwYyhfseyLn95mw67dMnc9bjNPm96VI4QT7ON-G3dZpccBMAlUGQmYntY3OJpnbExdrWWSzsq4lFcltMrpAPmEfZjKIKZdjdrYd1WmFFNrY0urgEC3dtZo59O5BStQc5-KF9oqYYhjLE0EIKU9CiDdns6FYB6AqQLv1ftWXZdz-hgtFkgHXknVGTmf02iHCMH-ZjxGQS68Ym6Afuhv4DVVuQAjSMj3TLQtCju9ubjPm94Bb51mh9lyNCIMpOQB_wmOAgoMbx7Xt_QrtzCixJ4H3OF43ogUwaITdj-OPwwlgEHd5xCcbyue2tlj1XCU7LNM8S_ARy8TJmu153jB_y_ivgh9yNIiMGLVIQOSr0LA4bHkpK2pCUse-PLBnQCDFyMXZffZwer3u9s&u=https%3A%2F%2Fwww.monetdb.org%2Fmailman%2Flistinfo%2Fusers-list -- | Stefan.Manegold@CWI.nl<mailto: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.org<mailto:users-list@monetdb.org> https://clicktime.symantec.com/a/1/q6CTdcD4sHC4jIirKo_CgZTwdfqqQ229WSdJMq6RmtY=?d=48PhZxXq960oW1CW8PwWNgP3bdNKOoGVFdcUjBfb5P_AvkjHWWVaXgNIXAVFwYyhfseyLn95mw67dMnc9bjNPm96VI4QT7ON-G3dZpccBMAlUGQmYntY3OJpnbExdrWWSzsq4lFcltMrpAPmEfZjKIKZdjdrYd1WmFFNrY0urgEC3dtZo59O5BStQc5-KF9oqYYhjLE0EIKU9CiDdns6FYB6AqQLv1ftWXZdz-hgtFkgHXknVGTmf02iHCMH-ZjxGQS68Ym6Afuhv4DVVuQAjSMj3TLQtCju9ubjPm94Bb51mh9lyNCIMpOQB_wmOAgoMbx7Xt_QrtzCixJ4H3OF43ogUwaITdj-OPwwlgEHd5xCcbyue2tlj1XCU7LNM8S_ARy8TJmu153jB_y_ivgh9yNIiMGLVIQOSr0LA4bHkpK2pCUse-PLBnQCDFyMXZffZwer3u9s&u=https%3A%2F%2Fwww.monetdb.org%2Fmailman%2Flistinfo%2Fusers-list
participants (2)
-
Sharma, Sreejith -
Stefan Manegold