Informatica Corporation

Chitresh Kakwani

Manish Gupta

Gregorio Convertino

Ranjeet Kumar Tayi

Swati Tomar

An apparatus, computer-readable medium, and computer-implemented method for data subsetting, including receiving a request comprising a criterion indicating a criterion table in a plurality of tables of a database, as schema of the database corresponding to an entity graph, the entity graph comprising a plurality of entities corresponding to the plurality of tables and a plurality of directed edges connecting the plurality of entities, determining directed edges in the plurality of directed edges that must be traversed in both directions in order to traverse all entities in the entity graph starting from a criterion entity corresponding to the criterion table, generating, an ordered list of edges for the entity graph based on the directed edges that must be traversed in both directions and topological ordering, and generating a subset of data from the plurality of tables based on the ordered list of edges for the entity graph and the request.

Method, apparatus, and computer-readable medium to extract a referentially intact subset from a database

A system, method and computer-readable medium for missing data identification, including identifying columns in tables of a database, generating categorical columns of categorical data by transforming data values in the columns into categorical data values, generating a co-occurrence matrix corresponding to a pair of categorical columns in the categorical columns, determining an expected frequency of co-occurrence corresponding to each unique pair of categorical data values based at least in part on a marginal totals corresponding to categorical data values in the co-occurrence matrix, and identifying one or more locations of missing data based at least in part on the count of co-occurrence of each unique pair of categorical data values and the expected frequency of co-occurrence corresponding to each unique pair of categorical data values.

Method, apparatus, and computer-readable medium for missing data identification

A system, method and computer-readable medium for generation of missing data including transmitting indicators corresponding to locations of missing data in columns in tables of a database, each location of missing data corresponding to categorical values of categorical columns and each location of missing data being identified based on an expected count of data values at the corresponding location, receiving a selection of at least one indicator corresponding to at least one location of missing data, the at least one location of missing data corresponding to two or more categorical values of two or more categorical columns in the categorical columns, and generating sets of data records in at least one table in the tables of the database, each set of data records having two or more column values in two or more columns that correspond to the two or more categorical values of the two or more categorical columns.

Growing community of inventors

Rajasthan, India

Chitresh Kakwani