Research on Oracle spatial data encryption problem

oracle| Encryption | data | problems
Oracle 9i2 Features:
1, the return value is the custom object type function. For example, the Sdo_geometry data type.
2, can use Java or C language to write stored procedures. ÷
Oracle Spatial Advanced Features:
You can use the return value to obtain the spatial data as a geometric column for a custom function of the Sdo_geometry data type.

Encryption implementation:

1, simple data encryption.
1 Create a custom function with a return value of Sdo_geometry data type that decrypts the Sdo_geometry data from the BLOB (or any other data type) data and returns.
2 The decryption process needs to pass a key parameter to the function, which comes from your client program or Web application.
In this way, others will not be able to parse the data you have stored in spatial.

2, advanced data encryption.
1 Create a custom function with the C language return value of sdo_geometry data type, decrypt the sdo_geometry data from the BLOB (or any other data type) data and return it. This step requires a OCI interface-related programming technology, so it is slightly more difficult to achieve a bit higher.
2 C Language Program read the hardware code of the machine, after the operation of the server to obtain the key.
3 when reading the data, it also gives the function the key parameter of the client, and the combination of two keys is the final key that can decrypt the data. Of course, the data is stored in the corresponding key to encrypt.
In this way, your spatial data can only be acquired by specific clients and servers, and other programs cannot be retrieved.

The eight winds are not moving November 23, 2004 graffiti in Dalian