Various techniques are described for platform management of integrated access of public and privately-accessible datasets utilizing federated query generation and query schema rewriting optimization, including receiving at a dataset access platform a query formatted according to a first data schema, generating a copy of the query, saving the query and the copy to a datastore, parsing the copy of the query in the first schema using an inference engine, determining whether the query comprises data associated with an access control condition associated with accessing the dataset, the access control condition being configured to indicate whether the query is permitted to access the dataset, and rewriting, using a proxy server, the copy of the query in a second schema by converting the copy of the query into a triple associated with the query and another triple associated with the access control condition.

This disclosure relates generally to a method and system for extraction of SQL queries in an application. Various conventional approaches models SQL query extraction at a specific program point problem as an instance of string expression problem. Many string analysis based solutions are not scalable for large applications and those which are scalable do not account explicitly for the heap based flow. In an embodiment, the disclosed method and system utilizes a multi-criteria slicing based model which takes into account the data flowing through heap and contributing to SQL queries generation.

Methods and systems for generating a response to a query using an AI engine. One method includes translating a received query into a profile comprised of at least a query type and a priority. The method further includes collecting, based on the profile, a first set of data items from a first data file storing data categorized as general public data and a second set of data items from a second data file storing data categorized as personal private information and applying an AI correlation engine to the second set of data items to determine PPI-agnostic relevancy indicators for PPI included in the second set of data items. The method further includes masking, based on the query cluster profile, the second set of data items by replacing the PPI included in the second set of data items with the PPI-agnostic relevancy indicators.

Log messages are compressed, searched, and decompressed. A dictionary is used to store non-numeric expressions found in log messages. Both numeric and non-numeric expressions found in log messages are represented by placeholders in a string of log “type” information. Another dictionary is used to store the log type information. A compressed log message contains a key to the log-type dictionary and a sequence of values that are keys to the non-numeric dictionary and/or numeric values. Searching may be performed by parsing a search query into subqueries that target the dictionaries and/or content of the compressed log messages. A dictionary may reference segments that contain a number of log messages, so that all log message need not be considered for some searches.

A big data analytics system includes an event monitoring controller that detects a user targeted event from an initial digital query data flow. An event conversion controller determines at least one contextual element associated with the at least one user targeted event, and automatically converts the at least one contextual element into a search criteria. An external data query builder controller automatically executes an external search query based on the search criteria. A data fusing controller automatically fuses the at least one contextual element generated from the at least one user targeted event, together with external search results generated from the external search query and the initial query data flow to generate a fused data file.

A hardware database privacy device is communicatively coupled to a private database system. The hardware database privacy device receives a request from a client device to perform a query of the private database system and identifies a level of differential privacy corresponding to the request. The identified level of differential privacy includes privacy parameters (ε,δ) indicating the degree of information released about the private database system. The hardware database privacy device identifies a set of operations to be performed on the set of data that corresponds to the requested query. After the set of data is accessed, the set of operations is modified based on the identified level of differential privacy such that a performance of the modified set of operations produces a result set that is (ε,δ)-differentially private.

Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.

A method and system for performing federated identity management are described. The method and system include receiving a communication for a data source at a wrapper. The wrapper includes a dispatcher and a service. The dispatcher receives the communication and is data agnostic. The communication corresponds to end user credentials for an end user. The method and system include providing the communication from the dispatcher to the data source and to the service. The method and system also use the service to authenticate the end user based on the end user credentials and utilizing federated identity management.

A method and system according to embodiments enable generalized program to program interoperability. The method and system employ an automatic or substantially automatic transform adapter for using a given exchange standard for two-way communication with a program. In order for the adapter to employ the exchange standard, a discovery manager may learn the program's data communications structure and/or format, and may learn data meaning information from the program. An adapter creator may derive a transform which converts the program's data communications structure and data meaning into the exchange standard. The transform may be used by the adapter to enable two-way communication with any adapter and/or program similarly employing the given exchange standard to achieve interoperability.

Methods and systems for generating a response to a query using an AI engine. One method includes translating a received query into a profile comprised of at least a query type and a priority. The method further includes collecting, based on the profile, a first set of data items from a first data file storing data categorized as general public data and a second set of data items from a second data file storing data categorized as personal private information and applying an AI correlation engine to the second set of data items to determine PPI-agnostic relevancy indicators for PPI included in the second set of data items. The method further includes masking, based on the query cluster profile, the second set of data items by replacing the PPI included in the second set of data items with the PPI-agnostic relevancy indicators.