REGULATION-COMPLIANT PROCESSING OF QUERIES AND STORING OF DATA IN AN ON-DEMAND ENVIRONMENT

摘要

In accordance with embodiments, there are provided mechanisms and methods for facilitating regulation-compliant processing of queries in an on-demand services environment according to one embodiment. In one embodiment and by way of example, a method includes receiving a query having first information not permitted to be stored per a regulation and second information permitted to be stored, and parameterizing the query into a parameterized query to replace the first information with parameters, where the first information includes data types. The method further includes annotating the parameters with decisions based on data properties correspondingly associated with the data types being represented by the parameters, and generating a final query based on the annotated parameters such that the final query is capable of being executed based on the annotated parameters and without storing the first information.