Hi, I would like to propose a new solution which is quite the same as the one from Martin. The basic idea is that we manage a digest column for every TEXT column - fully transparent and automatic.
1. Data definition Every table column of type TEXT or LONGTEXT is supplement with a column of type TEXT_KEY which is used for an SHA2-512 of the original column. 2. Functions 2.1 create_table If a column is of type TEXT or LONGTEXT then automatically an additional column for the digest is created. 2.2 update and insert If a TEXT or LONGTEXT column is written then the digest column is written too. 2.3 select and update If a join or an EQUAL operator is used then this is automatically replaced by the same operation on the digest column. If a LIKE operator is used then nothing is changed. Can Oracle handle LIKE on columns of type CLOB? If Oracle does not support this then we should forbid LIKE on TEXT and LONGTEXT columns. 3. Index handling If an index is requested on a TEXT or LONGTEXT column then this index is automatically migrated to the digest column. Any comments please? The important thing is for me, that the whole thing is transparent for the database drivers and for the users of the database layer. Nobody has to take care. Conclusion: We need the data in the database but we don't want to use the data for operations in the database. Best regards Michael -- ___________________________________________________________________ Michael Bell Humboldt-Universitaet zu Berlin Tel.: +49 (0)30-2093 70143 ZE Computer- und Medienservice Fax: +49 (0)30-2093 70135 Unter den Linden 6 [email protected] D-10099 Berlin ___________________________________________________________________ PGP Fingerprint: 09E4 3D29 4156 2774 0F2C C643 D8BD 1918 2030 5AAB
smime.p7s
Description: S/MIME Kryptografische Unterschrift
------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________ OpenXPKI-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-devel
