Patents Assigned to Informatica Corporation
-
Publication number: 20150113330Abstract: 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: ApplicationFiled: October 17, 2013Publication date: April 23, 2015Applicant: Informatica CorporationInventor: Richard Grondin
-
Patent number: 8886617Abstract: 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: GrantFiled: May 9, 2013Date of Patent: November 11, 2014Assignee: Informatica CorporationInventors: Richard Grondin, Vassili Zarouba
-
Publication number: 20140250119Abstract: 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: ApplicationFiled: May 9, 2014Publication date: September 4, 2014Applicant: Informatica CorporationInventors: Pradeep Bhattiprolu, Richard Grondin
-
Patent number: 8826370Abstract: 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: GrantFiled: March 22, 2012Date of Patent: September 2, 2014Assignee: Informatica CorporationInventor: Eric Boukobza
-
Patent number: 8799229Abstract: 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: GrantFiled: December 21, 2012Date of Patent: August 5, 2014Assignee: Informatica CorporationInventors: Richard Grondin, Evgueni Fadeitchev, Vassili Zarouba
-
Patent number: 8707336Abstract: 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: GrantFiled: May 14, 2010Date of Patent: April 22, 2014Assignee: Informatica CorporationInventors: Michael S. Appelbaum, Jeffrey H. Garvett
-
Patent number: 8583680Abstract: 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: GrantFiled: May 14, 2012Date of Patent: November 12, 2013Assignee: Informatica CorporationInventor: Khanh Hoang
-
Publication number: 20130254171Abstract: 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: ApplicationFiled: May 9, 2013Publication date: September 26, 2013Applicant: Informatica CorporationInventors: Richard Grondin, Vassili Zarouba
-
Publication number: 20130212071Abstract: 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: ApplicationFiled: December 21, 2012Publication date: August 15, 2013Applicant: Informatica CorporationInventors: Richard Grondin, Evgueni Fadeitchev, Vassili Zarouba
-
Patent number: 8458230Abstract: 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: GrantFiled: June 18, 2012Date of Patent: June 4, 2013Assignee: Informatica CorporationInventors: Dmitri Korablev, Gregory Danforth
-
Patent number: 8453159Abstract: 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: GrantFiled: May 30, 2008Date of Patent: May 28, 2013Assignee: Informatica CorporationInventors: Michael S. Appelbaum, Jeffrey H. Garvett, Christopher Bradley, Karl Ginter, Michael Bartman
-
Patent number: 8433717Abstract: 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: GrantFiled: March 13, 2012Date of Patent: April 30, 2013Assignee: Informatica CorporationInventors: Dmitri Korablev, Gregory Danforth
-
Patent number: 8392460Abstract: 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: GrantFiled: November 2, 2011Date of Patent: March 5, 2013Assignee: Informatica CorporationInventors: Khanh Hoang, Gregory Danforth
-
Patent number: 8386435Abstract: 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: GrantFiled: May 9, 2007Date of Patent: February 26, 2013Assignee: Informatica CorporationInventors: Richard Grondin, Evgueni Fadeitchev, Vassili Zarouba
-
Patent number: 8327419Abstract: 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: GrantFiled: August 19, 2008Date of Patent: December 4, 2012Assignee: Informatica CorporationInventors: Dmitri Korablev, Gregory Danforth
-
Patent number: 8271477Abstract: 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: GrantFiled: December 14, 2007Date of Patent: September 18, 2012Assignee: Informatica CorporationInventors: Manish Sood, Xiaofeng Qian
-
Patent number: 8224873Abstract: 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: GrantFiled: August 19, 2008Date of Patent: July 17, 2012Assignee: Informatica CorporationInventors: Dmitri Korablev, Gregory Danforth
-
Patent number: 8200622Abstract: 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: GrantFiled: May 29, 2003Date of Patent: June 12, 2012Assignee: Informatica CorporationInventor: Khanh Hoang
-
Patent number: 8166071Abstract: 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: GrantFiled: August 19, 2008Date of Patent: April 24, 2012Assignee: Informatica CorporationInventors: Dmitri Korablev, Gregory Danforth
-
Patent number: RE44478Abstract: 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: GrantFiled: May 3, 2005Date of Patent: September 3, 2013Assignee: Informatica CorporationInventors: Niels Godfredsen, Spencer Lord, Yusuf Bashir, Eric Ying, Oliver Tse