Patents Assigned to Informatica Corporation
  • Publication number: 20150113330
    Abstract: A test data extraction and persistence technique that relies on a data domain based storage infrastructure is disclosed. In operation, a test data server receives a test data query that specifies selection parameters for selecting test data and any transformation operations to be performed on the test data. The test data server identifies domains associated with the selection parameters and traverses the tables in the database based on the identified domains to extract test data that satisfies the selection parameters. The test data server optionally performs transformation operations, such as masking operations, specified by the test data query on the extracted data. The identified domains are stored such that test data that satisfies the test data query may be extracted from the database repetitively without reevaluating the test data query each time.
    Type: Application
    Filed: October 17, 2013
    Publication date: April 23, 2015
    Applicant: Informatica Corporation
    Inventor: Richard Grondin
  • Patent number: 8886617
    Abstract: A method of searching all tables in a data model is disclosed, using a non-materializing virtual table interface that acts as a view into the underlying data model. The virtual table is virtually built on the fly at query execution time, and maps to all columns and rows within the data model. A query on the virtual table is translated into a set of data model queries for searching the data model, based on columns selected from the virtual table and other specified search parameters, as well as the virtual table definition. The search process works in conjunction with data domains, and uses compaction and tokenization of data.
    Type: Grant
    Filed: May 9, 2013
    Date of Patent: November 11, 2014
    Assignee: Informatica Corporation
    Inventors: Richard Grondin, Vassili Zarouba
  • Publication number: 20140250119
    Abstract: A database keyword search technique that relies on a domain based storage infrastructure is disclosed. In operation, a keyword search string is processed to generate a set of search string permutations. Each string permutation specifies a different ordering of one or more portions of the search string. A domain based search process is then executed asynchronously for each string permutation. Each execution generates a search result set that identifies rows in the database that include data relevant to the string permutation. The results in each result set are scored and ranked based in part on the similarity between the string permutation and the search string provided by the user. The rankings determine which of the results are to be presented to the user.
    Type: Application
    Filed: May 9, 2014
    Publication date: September 4, 2014
    Applicant: Informatica Corporation
    Inventors: Pradeep Bhattiprolu, Richard Grondin
  • Patent number: 8826370
    Abstract: A system and computer-implemented method for providing security rules to an existing enterprise database system. The disclosed system and computer-implemented method intercepts database connection requests provided by third-party applications and end-users and determines what, if any, security rules to be applied to the request, including masking, scrambling and unmasking the data, as well as whether the requesting user has a need to know the requested data. Accordingly, personally identifiable and other sensitive information is not provided to an unauthorized requesting application and/or end-user.
    Type: Grant
    Filed: March 22, 2012
    Date of Patent: September 2, 2014
    Assignee: Informatica Corporation
    Inventor: Eric Boukobza
  • Patent number: 8799229
    Abstract: An apparatus, computer-readable medium, and computer-implemented method for generating a searchable archive, the method including receiving a set of tabular data comprising a plurality of rows, storing data corresponding to a group of rows in the plurality of rows in a compacted file, the compacted file comprising one or more compressed segments. The compressed segments can store data corresponding to a portion of the rows in the group of rows and can store the data corresponding to the group of rows in column-major order. The compressed segments can store one or more token values corresponding to one or more data values in the set of tabular data and the token values can be generated by dividing the set of tabular data into columns and assigning a different token to each unique data value within each of the columns.
    Type: Grant
    Filed: December 21, 2012
    Date of Patent: August 5, 2014
    Assignee: Informatica Corporation
    Inventors: Richard Grondin, Evgueni Fadeitchev, Vassili Zarouba
  • Patent number: 8707336
    Abstract: A system, method and computer program product for providing data event processing and application integration is provided. The present invention provides a novel application integration and event processing server that creates unified and personalized applications on demand out of existing Web services, communications systems, legacy assets, and databases for several types of applications without invasive programming. The present invention also provides a novel XML-based open markup language that allows real-time composite applications (for execution on the server of the present invention) to be easily created and changed while minimizing low-level coding by using a set of pre-defined templates, thus saving the time and expense typically required to create similar solutions from scratch.
    Type: Grant
    Filed: May 14, 2010
    Date of Patent: April 22, 2014
    Assignee: Informatica Corporation
    Inventors: Michael S. Appelbaum, Jeffrey H. Garvett
  • Patent number: 8583680
    Abstract: A system, method and computer program product for integrating, managing and coordinating activities of customers in an enterprise, across a plurality of applications, resources and touch-points. Customer data is obtained during interactions between a customer and an application, a resource or a touch-point. This data is stored in the form of virtual composite objects in cache memory, on a cluster of servers. The virtual composite objects contain customer data, policies and behaviors of the enterprise. The applications query for the virtual composite objects through the server. The server hosting the queried virtual composite object delivers the queried virtual composite object in real time to the querying application. Any updates to the virtual composite object on account of events at the applications, resources or touch-points, is carried out in real time.
    Type: Grant
    Filed: May 14, 2012
    Date of Patent: November 12, 2013
    Assignee: Informatica Corporation
    Inventor: Khanh Hoang
  • Publication number: 20130254171
    Abstract: A method of searching all tables in a data model is disclosed, using a non-materializing virtual table interface that acts as a view into the underlying data model. The virtual table is virtually built on the fly at query execution time, and maps to all columns and rows within the data model. A query on the virtual table is translated into a set of data model queries for searching the data model, based on columns selected from the virtual table and other specified search parameters, as well as the virtual table definition. The search process works in conjunction with data domains, and uses compaction and tokenization of data.
    Type: Application
    Filed: May 9, 2013
    Publication date: September 26, 2013
    Applicant: Informatica Corporation
    Inventors: Richard Grondin, Vassili Zarouba
  • Publication number: 20130212071
    Abstract: An apparatus, computer-readable medium, and computer-implemented method for generating a searchable archive, the method including receiving a set of tabular data comprising a plurality of rows, storing data corresponding to a group of rows in the plurality of rows in a compacted file, the compacted file comprising one or more compressed segments. The compressed segments can store data corresponding to a portion of the rows in the group of rows and can store the data corresponding to the group of rows in column-major order. The compressed segments can store one or more token values corresponding to one or more data values in the set of tabular data and the token values can be generated by dividing the set of tabular data into columns and assigning a different token to each unique data value within each of the columns.
    Type: Application
    Filed: December 21, 2012
    Publication date: August 15, 2013
    Applicant: Informatica Corporation
    Inventors: Richard Grondin, Evgueni Fadeitchev, Vassili Zarouba
  • Patent number: 8458230
    Abstract: Some embodiments provide a method and system for flexibly managing access to enterprise resources. To flexibly manage security, some embodiments secure the enterprise resources and provide a security access manager (SAM) to control access to the secured resources. The SAM controls access to the enterprise and the secure resources through one or more configurable management modules of the SAM. Each management module of the SAM is configurable to facilitate control over different security services of an enterprise security hierarchy (e.g., authentication, authorization, role mapping, etc.). Specifically, each management module is configurable to leverage security services that are provided by different security systems. In some embodiments, the management module is configured to interface with one or more adapters in order to establish the interfaces, logic, and protocols necessary to leverage the security functionality of such security systems.
    Type: Grant
    Filed: June 18, 2012
    Date of Patent: June 4, 2013
    Assignee: Informatica Corporation
    Inventors: Dmitri Korablev, Gregory Danforth
  • Patent number: 8453159
    Abstract: A system and method for monitoring information events partitions sets of information and processing steps into one or more workspaces. The workspaces include sharable portable specifications for implementing event monitoring by a plurality of users or computer systems. Workspaces may be bindable computing resources to establish controls between the computing resources and the workspaces.
    Type: Grant
    Filed: May 30, 2008
    Date of Patent: May 28, 2013
    Assignee: Informatica Corporation
    Inventors: Michael S. Appelbaum, Jeffrey H. Garvett, Christopher Bradley, Karl Ginter, Michael Bartman
  • Patent number: 8433717
    Abstract: Some embodiments provide a system and method that secures access to data objects of an enterprise that includes multiple data objects and multiple user applications that access data attributes of the data objects. In some embodiments, secure access is provided via a secure resource that secures access to data attributes of at least two objects by defining access control permissions for the secure resource and applying the defined access control permissions to the data attributes of the secure resource.
    Type: Grant
    Filed: March 13, 2012
    Date of Patent: April 30, 2013
    Assignee: Informatica Corporation
    Inventors: Dmitri Korablev, Gregory Danforth
  • Patent number: 8392460
    Abstract: Some embodiments provide a system for processing relationship data that expresses relationship between various entities. In some embodiments, the entities are entities associated directly with an enterprise. The entities in some embodiments described below also include entities associated indirectly with the enterprise through other entities. In some embodiments, the system consolidates disparate relationship data sets that relate to the same set of entities. For instance, in some embodiments, the system includes several data storages that store relationship data. For at least two entities, at least two different data storages store two different relationship data sets that differently express the relationship between the two entities. The system includes a hierarchy manager that receives the two different relationship data sets and consolidates the two different relationship data sets into one relationship data set that best expresses the relationship between the two entities.
    Type: Grant
    Filed: November 2, 2011
    Date of Patent: March 5, 2013
    Assignee: Informatica Corporation
    Inventors: Khanh Hoang, Gregory Danforth
  • Patent number: 8386435
    Abstract: A searchable archiving system. A searchable archiving system includes one or more compacted files of archive data loosely coupled to a search process. To create a compacted file, an archiving process tokenizes the archive data, optimizes the tokenized archive data, and extracts archive metadata from the tokenized data. The tokenized data may then be compressed in a variety of ways into compressed segments that may be individually accessed and decompressed by the search agents. Before compression, segment metadata is extracted from the segments. The compressed segments and segment metadata are then combined to create a compacted file. The search process accesses the compacted files by consulting locally stored archive metadata extracted from the files during the compaction process. The search process then invokes one or more search agents that actively search the compacted files. The search agents do so by using the segment metadata to identify segments to decompress and search.
    Type: Grant
    Filed: May 9, 2007
    Date of Patent: February 26, 2013
    Assignee: Informatica Corporation
    Inventors: Richard Grondin, Evgueni Fadeitchev, Vassili Zarouba
  • Patent number: 8327419
    Abstract: Some embodiments provide a system and method that secures access to data objects of an enterprise that includes multiple data objects and multiple user applications that access data attributes of the data objects. In some embodiments, access is provided by secure resources that (1) filter a set of the data objects using a user attribute to identify a subset of data attributes of the data objects and (2) performing a query by identifying the secure resources accessible by the user based on the particular user attribute and retrieving data attributes from the secure resources according to the query.
    Type: Grant
    Filed: August 19, 2008
    Date of Patent: December 4, 2012
    Assignee: Informatica Corporation
    Inventors: Dmitri Korablev, Gregory Danforth
  • Patent number: 8271477
    Abstract: Some embodiments of the invention provide a user interface that allows a user to specify one or more attributes that should be included in a master reference data set, and identify which of these attributes should serve as enterprise specified identifiers that can be used to identify the particular master reference data set in an enterprise data storage. Some embodiments of the invention provide a method that allows the master reference data set to be accessed and updated in the data storage through the use of the enterprise specified identifiers.
    Type: Grant
    Filed: December 14, 2007
    Date of Patent: September 18, 2012
    Assignee: Informatica Corporation
    Inventors: Manish Sood, Xiaofeng Qian
  • Patent number: 8224873
    Abstract: Some embodiments provide a method and system for flexibly managing access to enterprise resources. To flexibly manage security, some embodiments secure the enterprise resources and provide a security access manager (SAM) to control access to the secured resources. The SAM controls access to the enterprise and the secure resources through one or more configurable management modules of the SAM. Each management module of the SAM is configurable to facilitate control over different security services of an enterprise security hierarchy (e.g., authentication, authorization, role mapping, etc.). Specifically, each management module is configurable to leverage security services that are provided by different security systems. In some embodiments, the management module is configured to interface with one or more adapters in order to establish the interfaces, logic, and protocols necessary to leverage the security functionality of such security systems.
    Type: Grant
    Filed: August 19, 2008
    Date of Patent: July 17, 2012
    Assignee: Informatica Corporation
    Inventors: Dmitri Korablev, Gregory Danforth
  • Patent number: 8200622
    Abstract: A system, method and computer program product for integrating, managing and coordinating activities of customers in an enterprise, across a plurality of applications, resources and touch-points. Customer data is obtained during interactions between a customer and an application, a resource or a touch-point. This data is stored in the form of virtual composite objects in cache memory, on a cluster of servers. The virtual composite objects contain customer data, policies and behaviors of the enterprise. The applications query for the virtual composite objects through the server. The server hosting the queried virtual composite object delivers the queried virtual composite object in real time to the querying application. Any updates to the virtual composite object on account of events at the applications, resources or touch-points, is carried out in real time.
    Type: Grant
    Filed: May 29, 2003
    Date of Patent: June 12, 2012
    Assignee: Informatica Corporation
    Inventor: Khanh Hoang
  • Patent number: 8166071
    Abstract: Some embodiments provide a system and method that secures access to data objects of an enterprise that includes multiple data objects and multiple user applications that access data attributes of the data objects. In some embodiments, secure access is provided via a secure resource that secures access to data attributes of at least two objects by defining access control permissions for the secure resource and applying the defined access control permissions to the data attributes of the secure resource.
    Type: Grant
    Filed: August 19, 2008
    Date of Patent: April 24, 2012
    Assignee: Informatica Corporation
    Inventors: Dmitri Korablev, Gregory Danforth
  • Patent number: RE44478
    Abstract: Methods for navigating a large amount of data are disclosed. In one embodiment, the present invention accesses a source of formatted warehoused data. The present invention then displays a grid on a display device. In one embodiment, the grid is an iconic representation of the formatted warehoused data. The grid is comprised of elements, each element corresponding to some portion of the formatted warehoused data. The present invention displays a portion of the formatted warehoused data on the display device in response to a selection of a corresponding element of the grid. In another embodiment, the formatted warehoused data is condensed so that it can be read in summary form to a user using a voice-based protocol. The user can issue voice commands to drill down deeper into the data, until the desired information is reached. The user thus doesn't need to hear all of the information in the formatted warehoused data, but instead can make inquiries to directly navigate to a particular item of interest.
    Type: Grant
    Filed: May 3, 2005
    Date of Patent: September 3, 2013
    Assignee: Informatica Corporation
    Inventors: Niels Godfredsen, Spencer Lord, Yusuf Bashir, Eric Ying, Oliver Tse