Patents by Inventor Alexander Gorelik
Alexander Gorelik has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Publication number: 20140012819Abstract: A method, computer program product, and system for analyzing data within one or more databases, comprising selecting one or more databases for analysis, each database comprising one or more database objects comprising one or more data values, applying a function to each data value in each database object within the one or more databases, where the function produces function values limited to a predetermined range, identifying for analysis the data values producing a certain function value within the predetermined range to form a sampled data set, and analyzing the sampled data set to determine relationships between the database objects within and across the one or more databases.Type: ApplicationFiled: September 6, 2013Publication date: January 9, 2014Applicant: International Business Machines CorporationInventor: Alexander Gorelik
-
Publication number: 20130262525Abstract: According to a present invention embodiment, a system determines a relationship between source and target database tables, and includes a computer system including at least one processor. Potential pivot keys of the target database table are determined, and maps are created for each potential pivot key between the database tables based on distinct values. Transformations for each map are generated that enable target data to be produced from source data. The transformations for each potential pivot key are analyzed and the potential pivot key with the transformations that generate the greatest amount of matching data is selected as the resulting pivot key. The database table columns corresponding to the resulting pivot key are determined to be associated by the relationship. Embodiments of the present invention further include a method and computer program product for determining a relationship between source and target database tables in substantially the same manner described above.Type: ApplicationFiled: March 30, 2012Publication date: October 3, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Leon Burda, Salil Datta, Alexander Gorelik, Dongmei Ren, Lev M. Tsentsiper
-
Publication number: 20130254183Abstract: An apparatus and method are described for the discovery of semantics, relationships and mappings between data in different software applications, databases, files, reports, messages, or systems. In one aspect, semantics and relationships and mappings are identified between a first and a second data source. A binding condition is discovered between portions of data in the first and the second data source. The binding condition is used to discover correlations between portions of data in the first and the second data source. The binding condition and the correlations are used to discover a transformation function between portions of data in the first and the second data source.Type: ApplicationFiled: May 9, 2013Publication date: September 26, 2013Applicant: International Business Machines CorporationInventors: Alexander Gorelik, Lingling Yan
-
Publication number: 20130226940Abstract: According to one embodiment of the present invention, a system determines key relationships between database tables and includes a computer system including at least one processor. The system determines a sampling range for one or more matching columns between first and second database tables. The matching columns satisfy one or more matching criteria and the sampling range is based on quantities of distinct values within the matching columns. Data is sampled from the first and second database tables in accordance with the sampling ranges to determine a sample set. Keys between the first and second database tables are determined based on matching between columns within the sample set. Embodiments of the present invention further include a method and computer program product for determining key relationships between database tables in substantially the same manner described above.Type: ApplicationFiled: February 28, 2012Publication date: August 29, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Alexander Gorelik, Sharad Santhanam, Lev M. Tsentsiper
-
Patent number: 8442999Abstract: An apparatus and method are described for the discovery of semantics, relationships and mappings between data in different software applications, databases, files, reports, messages, or systems. In one aspect, semantics and relationships and mappings are identified between a first and a second data source. A binding condition is discovered between portions of data in the first and the second data source. The binding condition is used to discover correlations between portions of data in the first and the second data source. The binding condition and the correlations are used to discover a transformation function between portions of data in the first and the second data source.Type: GrantFiled: October 6, 2011Date of Patent: May 14, 2013Assignee: International Business Machines CorporationInventors: Alexander Gorelik, Lingling Yan
-
Patent number: 8380750Abstract: A data source is accessed to provide information.Type: GrantFiled: February 17, 2011Date of Patent: February 19, 2013Assignee: International Business Machines CorporationInventor: Alexander Gorelik
-
Publication number: 20130024430Abstract: A method, computer program product, and system for analyzing data within one or more databases, comprising selecting one or more databases for analysis, each database comprising one or more database objects comprising one or more data values, applying a function to each data value in each database object within the one or more databases, where the function produces function values limited to a predetermined range, identifying for analysis the data values producing a certain function value within the predetermined range to form a sampled data set, and analyzing the sampled data set to determine relationships between the database objects within and across the one or more databases.Type: ApplicationFiled: July 19, 2011Publication date: January 24, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventor: Alexander Gorelik
-
Publication number: 20130013590Abstract: A data source is accessed to provide information.Type: ApplicationFiled: September 14, 2012Publication date: January 10, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventor: Alexander Gorelik
-
Publication number: 20120215766Abstract: A data source is accessed to provide information.Type: ApplicationFiled: February 17, 2011Publication date: August 23, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventor: Alexander Gorelik
-
Publication number: 20120158745Abstract: An apparatus and method are described for the discovery of semantics, relationships and mappings between data in different software applications, databases, files, reports, messages, or systems. In one aspect, semantics and relationships and mappings are identified between a first and a second data source. A binding condition is discovered between portions of data in the first and the second data source. The binding condition is used to discover correlations between portions of data in the first and the second data source. The binding condition and the correlations are used to discover a transformation function between portions of data in the first and the second data source.Type: ApplicationFiled: October 6, 2011Publication date: June 21, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Alexander Gorelik, Lingling Yan
-
Patent number: 8082243Abstract: In one aspect, semantics and relationships and mappings are identified between a first and a second data source. Data between the first and second data source is compared. A binding condition is discovered between portions of data in the first and the second data source based upon the comparison, wherein the binding condition identifies data within the first and second data sources that map to each other. The binding condition is used to discover correlations between portions of data in the first and the second data source, wherein the correlations identify data in the first data source that correspond to values in the second data source. The binding condition and the correlations are used to discover a transformation function between portions of data in the first and the second data source, wherein the transformation function generates data in the second data source data in the first data source.Type: GrantFiled: September 12, 2008Date of Patent: December 20, 2011Assignee: International Business Machines CorporationInventors: Alexander Gorelik, Lingling Yan
-
Patent number: 7680828Abstract: A method and a system for facilitating data retrieval from a plurality of data sources are provided. A plurality of ‘Local Data Objects’ (LDOs) corresponding to the plurality of data sources are generated. Further, the plurality of LDOs are mapped onto a ‘Global Data Object’ (GDO). The GDO consolidates the plurality of LDOs into a single integrated model. The mapping of the LDOs onto the GDO includes a plurality of ‘binding conditions’ that relate LDO attributes to GDO attributes. The mapping also includes a plurality of ‘transformation functions’ for transforming the LDO attributes to the GDO attributes.Type: GrantFiled: August 4, 2006Date of Patent: March 16, 2010Assignee: International Business Machines CorporationInventor: Alexander Gorelik
-
Publication number: 20090094274Abstract: An apparatus and method are described for the discovery of semantics, relationships and mappings between data in different software applications, databases, files, reports, messages, or systems. In one aspect, semantics and relationships and mappings are identified between a first and a second data source. A binding condition is discovered between portions of data in the first and the second data source. The binding condition is used to discover correlations between portions of data in the first and the second data source. The binding condition and the correlations are used to discover a transformation function between portions of data in the first and the second data source.Type: ApplicationFiled: September 12, 2008Publication date: April 9, 2009Applicant: Exeros, Inc.Inventors: Alexander Gorelik, Lingling Yan
-
Patent number: 7426520Abstract: An apparatus and method are described for the discovery of semantics, relationships and mappings between data in different software applications, databases, files, reports, messages, or systems. In one aspect, semantics and relationships and mappings are identified between a first and a second data source. A binding condition is discovered between portions of data in the first and the second data source. The binding condition is used to discover correlations between portions of data in the first and the second data source. The binding condition and the correlations are used to discover a transformation function between portions of data in the first and the second data source.Type: GrantFiled: September 9, 2004Date of Patent: September 16, 2008Assignee: Exeros, Inc.Inventors: Alexander Gorelik, Lingling Yan
-
Patent number: 7320122Abstract: A method of generating procedural language code for extracting data from a data warehouse comprising the steps of accepting a declarative specification and generating procedural language code to execute the declarative specification.Type: GrantFiled: May 25, 2004Date of Patent: January 15, 2008Assignee: Business Objects Data IntegrationInventors: Sachinder S. Chawla, Jason Chen, Alexander Gorelik, Hon C. Thio, Dave Wang
-
Publication number: 20060271528Abstract: A method and a system for facilitating data retrieval from a plurality of data sources are provided. A plurality of ‘Local Data Objects’ (LDOs) corresponding to the plurality of data sources are generated. Further, the plurality of LDOs are mapped onto a ‘Global Data Object’ (GDO). The GDO consolidates the plurality of LDOs into a single integrated model. The mapping of the LDOs onto the GDO includes a plurality of ‘binding conditions’ that relate LDO attributes to GDO attributes. The mapping also includes a plurality of ‘transformation functions’ for transforming the LDO attributes to the GDO attributes.Type: ApplicationFiled: August 4, 2006Publication date: November 30, 2006Applicant: Exeros, Inc.Inventor: Alexander Gorelik
-
Publication number: 20050055369Abstract: An apparatus and method are described for the discovery of semantics, relationships and mappings between data in different software applications, databases, files, reports, messages, or systems. In one aspect, semantics and relationships and mappings are identified between a first and a second data source. A binding condition is discovered between portions of data in the first and the second data source. The binding condition is used to discover correlations between portions of data in the first and the second data source. The binding condition and the correlations are used to discover a transformation function between portions of data in the first and the second data source.Type: ApplicationFiled: September 9, 2004Publication date: March 10, 2005Inventors: Alexander Gorelik, Lingling Yan
-
Publication number: 20050055669Abstract: A method of generating procedural language code for extracting data from a data warehouse comprising the steps of accepting a declarative specification and generating procedural language code to execute the declarative specification.Type: ApplicationFiled: May 25, 2004Publication date: March 10, 2005Applicant: ACTA TECHNOLOGY, INC.Inventors: Sachinder Chawla, Jason Chen, Alexander Gorelik, Hon Thio, Dave Wang
-
Publication number: 20020004799Abstract: In a computing system, wherein applications access databases to obtain data and the databases are updated from time to time and the applications require consistent data from the databases even while an update is occurring, a first database; a second database, wherein the first database and second database a substantive copies of each other outside of an update period; a database indicator that indicates one of the first and second databases as a live database and the other one of the first and second databases as a load database; a query router for routing queries from application to the live database; and a router switcher for switching the database indicator such that the live database becomes the load database and the load database becomes the live database.Type: ApplicationFiled: February 12, 2001Publication date: January 10, 2002Inventors: Alexander Gorelik, Leon Burda
-
Publication number: 20010047372Abstract: In a data processing system, hierarchical documents or hierarchical messages are mapped to a Nested Relational Data Model to allow for transformation and manipulation using declarative statements. The resulting nested data can be converted to a relational format and mapped to multiple relational tables, and/or converted from a nested relational format to an external hierarchical format, such as XML. The system can specify and execute declarative rules to extract, transform, integrate, load and update hierarchical and relational data. The system can also be used for extending documents with relational and non-relational data and applying updates based on these documents to relational database targets. The system can also be used for mapping Nested Relational Data to function calls that accept tables as parameters and return multiple scalar and table parameters as output.Type: ApplicationFiled: February 12, 2001Publication date: November 29, 2001Inventors: Alexander Gorelik, Sachinder S. Chawla, Awez I. Syed, Leon Burda, Mon F. Yee, Sridhar Grantimahapatruni