Method and apparatus for automatically classifying data
One embodiment of the present invention provides a system for automatically classifying data in a database. During operation, the system receives and executes a database operation. Next, the system automatically determines if any data was modified as a result of executing the database operation. If so, for each data item that was modified, the system automatically determines if the data item is associated with a classification-rule. If so, the system automatically reclassifies the data item according to the classification-rule. If not, the system leaves a classification of the data item unchanged.
1. A method for automatically classifying data in a database, the method comprising:
executing a received database operation;
determining, by a computer, that a data item in the database is modified as a result of executing the database operation;
determining, by the computer, that the data item is associated with a classification rule, which corresponds to a privilege level required for accessing the data item,
reclassifying, by the computer, the data item according to the classification rule, and
executing an additional operation specified by the classification rule, wherein the additional operation comprises modifying the privilege level.
2. The method of claim 1 , wherein determining that the data item is modified as a result of executing the database operation involves examining a transaction log for the database.
3. The method of claim 1 , wherein the classification for the data item is associated with a privilege level required to access the data item.
4. The method of claim 1 , wherein determining that the data item is associated with the classification rule involves using a hash function to facilitate identifying the classification-rule associated with the data item.
5. The method of claim 1 , wherein determining that the data item is associated with the classification rule involves matching the data item to a pattern which is associated with the classification-rule.
6. The method of claim 1 , further comprising executing additional operations specified by the classification rule.
7. The method of claim 6 , wherein the additional operations can involve one or more of the following operations:
encrypting the data item;
encrypting a row in the database associated with the data item;
encrypting a column in the database associated with the data item;
encrypting metadata in the database associated with the data item;
decrypting the row in the database associated with the data item;
decrypting the column in the database associated with the data item;
decrypting the metadata in the database associated with the data item;
sending an alert to a user who is associated with the classification-rule;
rejecting the database operation;
recording operations involving the data item in a log; and
auditing the database.
8. The method of claim 1 , further comprising presenting the data item to a user after reclassifying the data item.
9. The method of claim 1 , wherein determining that the data item is associated with the classification rule further involves determining if the data item satisfies an arbitrary rule.
10. A non-transitory computer-readable storage medium storing instructions that when executed by a computer cause the computer to perform a method for automatically classifying data in a database, the method comprising:
executing a received database operation;
determining, by a computer, that a data item in the database is modified as a result of executing the database operation;
determining, by the computer, that the data item is associated with a classification rule, which corresponds to a privilege level required for accessing the data item,
reclassifying, by the computer, the data item according to the classification rule, and
executing an additional operation specified by the classification rule, wherein the additional operation comprises modifying the privilege level.
11. The non-transitory computer-readable storage medium of claim 10 , wherein determining that the data item is modified as a result of executing the database operation involves examining a transaction log for the database.
12. The non-transitory computer-readable storage medium of claim 10 , wherein the classification for the data item is associated with a privilege level required to access the data item.
13. The non-transitory computer-readable storage medium of claim 10 , wherein determining that the data item is associated with the classification rule involves using a hash function to facilitate identifying the classification-rule associated with the data item.
14. The non-transitory computer-readable storage medium of claim 10 , wherein determining that the data item is associated with the classification-rule involves matching the data item to a pattern which is associated with the classification rule.
15. The non-transitory computer-readable storage medium of claim 10 , wherein the method further comprises executing additional operations specified by the classification rule.
16. The non-transitory computer-readable storage medium of claim 15 , wherein the additional operations can involve one or more of the following operations:
encrypting the data item;
encrypting a row in the database associated with the data item;
encrypting a column in the database associated with the data item;
encrypting metadata in the database associated with the data item;
decrypting the row in the database associated with the data item;
decrypting the column in the database associated with the data item;
decrypting the metadata in the database associated with the data item;
sending an alert to a user who is associated with the classification-rule;
rejecting the database operation;
recording operations involving the data item in a log; and
auditing the database.
17. The non-transitory computer-readable storage medium of claim 10 , wherein the method further comprises presenting the data item to a user after reclassifying the data item.
18. The non-transitory computer-readable storage medium of claim 10 , wherein determining that the data item is associated with the classification rule further involves determining if the data item satisfies an arbitrary rule.
19. An apparatus that automatically classifies data in a database, comprising:
an execution mechanism configured to execute a received database operation;
a determination mechanism configured to automatically determine that a data item in the database is modified as a result of executing the database operation;
wherein the determination mechanism is further configured to automatically determine that the data item is associated with a classification rule, which corresponds to a privilege level required for accessing the data item;
a reclassification mechanism configured to reclassify the data item according to the classification rule; and
a execution mechanism configured to execute an additional operation specified by the classification rule, wherein the additional operation comprises modifying the privilege level.
20. The apparatus of claim 19 , wherein the determination mechanism is configured to examine a transaction log for the database.
21. The apparatus of claim 19 , wherein a classification for the data item is associated with a privilege level required to access the data item.
22. The apparatus of claim 19 , wherein the determination mechanism is configured to use a hash function to facilitate identifying the classification rule associated with the data item.
23. The apparatus of claim 19 , wherein the determination mechanism is configured to match the data item to a pattern which is associated with the classification rule.
24. The apparatus of claim 19 , wherein the execution mechanism is configured to execute additional operations specified by the classification rule.
25. The apparatus of claim 24 , wherein the additional operations can involve one or more of the following operations:
encrypting the data item;
encrypting a row in the database associated with the data item;
encrypting a column in the database associated with the data item;
encrypting metadata in the database associated with the data item;
decrypting the row in the database associated with the data item;
decrypting the column in the database associated with the data item;
decrypting the metadata in the database associated with the data item;
sending an alert to a user who is associated with the classification-rule;
rejecting the database operation;
recording operations involving the data item in a log; and
auditing the database.