Hi,
This use case show compresion ratios about 45% , with DEFLATE that seems a
normal ratio for small strings.
-- ----------------------------------------
create table bio (id int auto_increment primary key, cdata text, bdata
varbinary );
insert into bio (cdata) values (' sp|P08506|DACC_ECOLI PENICILLIN-BINDING
PROTEIN 6 PRECURSOR\n (D-ALANYL-D-ALANINE CARBOXYPEPTIDASE FRACTION
C) (EC\n3.4.16.4)\n (DD-PEPTIDASE) (DD-CARBOXYPEPTIDASE) (PBP-6).\n
Length =
400\n\n Score = 894 (409.5 bits), Expect = 5.0e-120, P = 5.0e-120\n Identities
= 169/342 (49%), Positives = 237/3 42 (69%)\n\nQuery:
1\nMDYTTGQILTAGNEHQQRNPASLTKLMTGYVVDRAIDSHRITPDDIVTVGRDAWAKDNPV 60\n
MDY +G++L GN ++ +PASLTK+MT YVV +A+
+ +I D+VTVG+DAWA\nNP\nSbjct:
45\nMDYASGKVLAEGNADEKLDPASLTKIMTSYVVGQALKADKIKLTDMVTVGKDAWATGNPA 104\n\nQuery:
61\nFVGSSLMFLKEGDRVSVRDLSRGLIVDSGNDACVALADYIAGGQRQFVEMMNNYAEKLHL 120\n
GSS+MFLK GD+VSV DL++G+I+ SGNDAC+ALADY+AG Q F+ +MN
YA\n+KL L\nSbjct:
105\nLRGSSVMFLKPGDQVSVADLNKGVIIQSGNDACIALADYVAGSQESFIGLMNGYAKKLGL 164\n\nQuery:
121\nKDTHFETVHGLDAPGQHSSAYDLAVLSRAIIHGEPEFYHMYSEKSLTWNGITQQNRNGLL 180\n
+T F+TVHGLDAPGQ S+A D+A+L +A+IH PE Y ++ EK T+N I Q
NRN\nLL\nSbjct:
165\nTNTTFQTVHGLDAPGQFSTARDMALLGKALIHDVPEEYAIHKEKEFTFNKIRQPNRNRLL 224\n\nQuery:
181\nWDKTMNVDGLKTGHTSGAGFNLIASAVDGQRRLIAVVMGADSAKGREEEARKLLRWGQQN 240\n
W +N DG+KTG T+GAG+NL+ASA G RLI+VV+GA + + R E+ KLL WG\n+\nSbjct:
225\nWSSNLNEDGMKTGTTAGAGYNLVASATQGDMRLISVVLGAKTDRIRFNESEKLLTWGFRF 284\n\nQuery:
241\nFTTVQILHRGKKVGTERIWYGDKENIDLGTEQEFWMVLPKAEIPHIKAKYTLDGKELTAP 300\n
F TV + T+R+W+GDK ++LG + + +P+ ++ ++KA YTL\n+LTAP\nSbjct:
285\nFETVTPIKPDATFVTQRVWFGDKSEVNLGAGEAGSVTIPRGQLKNLKASYTLTEPQLTAP 344\n\nQuery:
301 ISAHQRVGEIELYDRDKQVAHWPLVTLESVGEGSMFSRLSDY 342\n + Q VG I+
K + PL+ +E+V EG F R+ D+\nSbjct: 345
LKKGQVVGTIDFQLNGKSIEQRPLIVMENVEEGGFFGRVWDF 386');
update bio set bdata = COMPRESS(STRINGTOUTF8(cdata),'DEFLATE');
select id, length(cdata) as data_len, length(bdata) as comp_len,round(
(length(bdata)*1.0000/length(cdata)) ,4)*100 as comp_ratio from bio;
drop table bio;
-- ---------------------------------------------
Hope this help.
regards,
Dario
El 08/10/10 04:27, HJ escribió:
> I m using H2 for a project where one of the functions is to store text
>>> of a size 100-2000 characters. This text is highly compressible.
>>> Hence I have three questions:
>>> 1. Is there a way to compact a String within H2. COMPRESS does not
>>> seem to reach the desired size. Actually it is getting even larger.
>>
> Thank you much for your answer. The data I want to store is actually
> an output from a biological alignment algorithm called blast.
>
> A good example for a single field which should be stored in the
> database is:
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
