Patents by Inventor Dan J. Mandelstein
Dan J. Mandelstein 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).
-
Patent number: 9411836Abstract: Techniques are disclosed to facilitate consistency between a glossary and a repository, where the glossary includes one or more terms and the repository includes information sets. Each information set includes a definition for a respective term and a range of valid values for the respective term. A request is received to approve a first information set in the repository, where the first information set pertains to a first term in the glossary. The first information set is designated as an active information set for the first term. A subsequent request is received to assign the first term in the glossary to a second information set in the repository, where the second information set is different from the first information set. An information set to designate as the active information set for the first term is programmatically determined based on a predefined consistency criterion.Type: GrantFiled: December 13, 2013Date of Patent: August 9, 2016Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Dan J Mandelstein, Sushain Pandit, Fenglian Xu
-
Patent number: 9342570Abstract: A method, system and computer program product for identifying reference data tables in an Extract-Transform-Load (ETL) process, by identifying, by operation of one or more computer processors, at least a first reference data operator in the process, wherein the first reference data operator references one or more tables and evaluating at least a first table referenced by the reference data operator to determine whether the first table is a reference data table by assigning a score to the first table, wherein the score is indicative of the likelihood that the first table is a reference data table and wherein a reference data table contains a set of values that describes other data.Type: GrantFiled: August 28, 2013Date of Patent: May 17, 2016Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Dan J. Mandelstein, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit
-
Patent number: 9286586Abstract: A method, computer program product, and system for information governance crowd sourcing by, responsive to receiving a data quality exception identifying one or more data quality errors in a data store, identifying a performance level required to correct the data quality errors, selecting, from a crowd hierarchy, a first one or more crowds meeting the defined performance level, wherein the crowd hierarchy ranks the performance of one or more crowds, and routing, by operation of one or more computer processors, the one or more data quality errors to the selected crowds for correction.Type: GrantFiled: May 3, 2013Date of Patent: March 15, 2016Assignee: International Business Machines CorporationInventors: Robert Kern, Dan J. Mandelstein, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit
-
Patent number: 9251183Abstract: A method, computer program product and system for managing tenant-specific data sets in a multi-tenant system, by receiving a request to convert a data set in a physical data store from a first type of multi-tenant deployment to a second type of multi-tenant deployment, retrieving tenant identification metadata identifying a tenant making the request, modifying the data set in the physical data store based on the second type of multi-tenant deployment, and modifying metadata associated with an abstraction layer to allow the modified data set to be accessed.Type: GrantFiled: March 14, 2013Date of Patent: February 2, 2016Assignee: International Business Machines CorporationInventors: Dan J. Mandelstein, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit, Charles D. Wolfson
-
Patent number: 9244951Abstract: A method, computer program product and system for managing tenant-specific data sets in a multi-tenant system, by receiving a request to convert a data set in a physical data store from a first type of multi-tenant deployment to a second type of multi-tenant deployment, retrieving tenant identification metadata identifying a tenant making the request, modifying the data set in the physical data store based on the second type of multi-tenant deployment, and modifying metadata associated with an abstraction layer to allow the modified data set to be accessed.Type: GrantFiled: March 8, 2012Date of Patent: January 26, 2016Assignee: International Business Machines CorporationInventors: Dan J. Mandelstein, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit, Daniel C. Wolfson
-
Patent number: 9092749Abstract: A method, computer program product, and system for information governance crowd sourcing by, responsive to receiving a data quality exception identifying one or more data quality errors in a data store, identifying a performance level required to correct the data quality errors, selecting, from a crowd hierarchy, a first one or more crowds meeting the defined performance level, wherein the crowd hierarchy ranks the performance of one or more crowds, and routing, by operation of one or more computer processors, the one or more data quality errors to the selected crowds for correction.Type: GrantFiled: April 13, 2012Date of Patent: July 28, 2015Assignee: International Business Machines CorporationInventors: Robert Kern, Dan J. Mandelstein, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit
-
Patent number: 9081785Abstract: Method, system, and computer program product to improve a coverage of a plurality of classifications between a plurality of terms in a glossary and a set of values in a reference data management system, by identifying a first classification, of the plurality of classifications in the glossary, between a first term in the glossary and a first set of values in the reference data management system, detecting a relationship between the first set of values and a second set of values in the reference data management system, and upon determining that a relevance score for a relevant value from the second set of values exceeds a predefined threshold, identifying the relevant value to be classified with the term in the glossary, wherein the glossary is configured to create a second classification between the first term and the relevant value.Type: GrantFiled: December 7, 2012Date of Patent: July 14, 2015Assignee: International Business Machines CorporationInventors: Dan J. Mandelstein, Ivan M. Milman, Sushain Pandit
-
Publication number: 20150193519Abstract: Flexibly modeling and visualizing a level-based hierarchy. A first level set and a second level set are identified from a first data set and a second data set in a first domain and a second domain, respectively. A first relationship type to be used between the first level set and the second level set is received. A first hierarchy is formalized, including at least the first level set and the second level set joined in a hierarchical relationship according to the first relationship type.Type: ApplicationFiled: January 9, 2014Publication date: July 9, 2015Applicant: International Business Machines CorporationInventors: Dan J. Mandelstein, Sushain Pandit, Subramanian Palaniappan, Olena Woolf, Fenglian Xu
-
Publication number: 20150193531Abstract: Flexibly modeling and visualizing a level-based hierarchy. A first level set and a second level set are identified from a first data set and a second data set in a first domain and a second domain, respectively. A first relationship type to be used between the first level set and the second level set is received. A first hierarchy is formalized, including at least the first level set and the second level set joined in a hierarchical relationship according to the first relationship type.Type: ApplicationFiled: September 24, 2014Publication date: July 9, 2015Inventors: Dan J. Mandelstein, Sushain Pandit, Subramanian Palaniappan, Olena Woolf, Fenglian Xu
-
Publication number: 20150169666Abstract: Techniques are disclosed to facilitate consistency between a glossary and a repository, where the glossary includes one or more terms and the repository includes information sets. Each information set includes a definition for a respective term and a range of valid values for the respective term. A request is received to approve a first information set in the repository, where the first information set pertains to a first term in the glossary. The first information set is designated as an active information set for the first term. A subsequent request is received to assign the first term in the glossary to a second information set in the repository, where the second information set is different from the first information set. An information set to designate as the active information set for the first term is programmatically determined based on a predefined consistency criterion.Type: ApplicationFiled: December 13, 2013Publication date: June 18, 2015Applicant: International Business Machines CorporationInventors: Dan J. Mandelstein, Sushain Pandit, Fenglian Xu
-
Patent number: 8954376Abstract: Techniques are disclosed for identifying transcoding tables in an Extract-Transform-Load (ETL) process, by identifying, by operation of one or more computer processors, records passing through an operator configured to replace values in the records with values from at least one table linked to the operator before being sent to an output table, wherein the operator specifies an operation for extracting, transforming, or loading data stored in one or more source systems into storage by a target system, and evaluating at least a first table linked to the operator to determine whether the first table is a transcoding table by assigning a score to the first table, wherein the score is indicative of the likelihood that the first table is a transcoding table, wherein a transcoding table is used to harmonize values from a plurality of tables in the one or more source systems to a table in the target.Type: GrantFiled: March 8, 2012Date of Patent: February 10, 2015Assignee: International Business Machines CorporationInventors: Dan J. Mandelstein, Ivan M. Milman, Martin Oberhofer, Sushain Pandit
-
Patent number: 8898104Abstract: A system maps data within a data source to a target data model, and comprises a computer system including at least one processor. The system determines an identifier for each data object of the data source based on the data within that data object, wherein the identifier indicates for that data object a corresponding concept within a domain ontological representation of a data model of the data source. The determined identifiers for the data objects of the data source are compared to the target data model to determine mappings between the data objects of the data source and the target data model. Data objects from the data source are extracted for the target data model in accordance with the mappings. Present invention embodiments further include a method and computer program product for mapping data within a data source to a target data model.Type: GrantFiled: July 26, 2011Date of Patent: November 25, 2014Assignee: International Business Machines CorporationInventors: Dan J. Mandelstein, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit
-
Publication number: 20140164399Abstract: Method, system, and computer program product to improve a coverage of a plurality of classifications between a plurality of terms in a glossary and a set of values in a reference data management system, by identifying a first classification, of the plurality of classifications in the glossary, between a first term in the glossary and a first set of values in the reference data management system, detecting a relationship between the first set of values and a second set of values in the reference data management system, and upon determining that a relevance score for a relevant value from the second set of values exceeds a predefined threshold, identifying the relevant value to be classified with the term in the glossary, wherein the glossary is configured to create a second classification between the first term and the relevant value.Type: ApplicationFiled: December 7, 2012Publication date: June 12, 2014Applicant: International Business Machines CorporationInventors: Dan J. Mandelstein, Ivan M. Milman, Sushain Pandit
-
Patent number: 8694918Abstract: Techniques are disclosed for generating a view of a data flow model. One or more groupings of data flow objects in the data flow model is determined, based on an ontology. At least a first one of the groupings is collapsed in the view. The view is output for display in a user interface configured to selectively expand and collapse the first group based on user input.Type: GrantFiled: February 6, 2012Date of Patent: April 8, 2014Assignee: International Business Machines CorporationInventors: Dan J. Mandelstein, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit
-
Publication number: 20140006339Abstract: A method, system and computer program product for identifying reference data tables in an Extract-Transform-Load (ETL) process, by identifying, by operation of one or more computer processors, at least a first reference data operator in the process, wherein the first reference data operator references one or more tables and evaluating at least a first table referenced by the reference data operator to determine whether the first table is a reference data table by assigning a score to the first table, wherein the score is indicative of the likelihood that the first table is a reference data table and wherein a reference data table contains a set of values that describes other data.Type: ApplicationFiled: August 28, 2013Publication date: January 2, 2014Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Dan J. MANDELSTEIN, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit
-
Patent number: 8583626Abstract: A method, system and computer program product for identifying reference data tables in an Extract-Transform-Load (ETL) process, by identifying, by operation of one or more computer processors, at least a first reference data operator in the process, wherein the first reference data operator references one or more tables and evaluating at least a first table referenced by the reference data operator to determine whether the first table is a reference data table by assigning a score to the first table, wherein the score is indicative of the likelihood that the first table is a reference data table and wherein a reference data table contains a set of values that describes other data.Type: GrantFiled: March 8, 2012Date of Patent: November 12, 2013Assignee: International Business Machines CorporationInventors: Dan J. Mandelstein, Ivan M. Milman, Martin Oberhofer, Sushain Pandit
-
Publication number: 20130275803Abstract: A method, computer program product, and system for information governance crowd sourcing by, responsive to receiving a data quality exception identifying one or more data quality errors in a data store, identifying a performance level required to correct the data quality errors, selecting, from a crowd hierarchy, a first one or more crowds meeting the defined performance level, wherein the crowd hierarchy ranks the performance of one or more crowds, and routing, by operation of one or more computer processors, the one or more data quality errors to the selected crowds for correction.Type: ApplicationFiled: April 13, 2012Publication date: October 17, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Robert Kern, Dan J. Mandelstein, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit
-
Publication number: 20130275170Abstract: A method, computer program product, and system for information governance crowd sourcing by, responsive to receiving a data quality exception identifying one or more data quality errors in a data store, identifying a performance level required to correct the data quality errors, selecting, from a crowd hierarchy, a first one or more crowds meeting the defined performance level, wherein the crowd hierarchy ranks the performance of one or more crowds, and routing, by operation of one or more computer processors, the one or more data quality errors to the selected crowds for correction.Type: ApplicationFiled: May 3, 2013Publication date: October 17, 2013Applicant: International Business Machines CorporationInventors: Robert Kern, Dan J. Mandelstein, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit
-
Publication number: 20130238641Abstract: A method, computer program product and system for managing tenant-specific data sets in a multi-tenant system, by receiving a request to convert a data set in a physical data store from a first type of multi-tenant deployment to a second type of multi-tenant deployment, retrieving tenant identification metadata identifying a tenant making the request, modifying the data set in the physical data store based on the second type of multi-tenant deployment, and modifying metadata associated with an abstraction layer to allow the modified data set to be accessed.Type: ApplicationFiled: March 8, 2012Publication date: September 12, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Dan J. Mandelstein, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit, Daniel C. Wolfson
-
Publication number: 20130238596Abstract: A method, system and computer program product for identifying reference data tables in an Extract-Transform-Load (ETL) process, by identifying, by operation of one or more computer processors, at least a first reference data operator in the process, wherein the first reference data operator references one or more tables and evaluating at least a first table referenced by the reference data operator to determine whether the first table is a reference data table by assigning a score to the first table, wherein the score is indicative of the likelihood that the first table is a reference data table and wherein a reference data table contains a set of values that describes other data.Type: ApplicationFiled: March 8, 2012Publication date: September 12, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Dan J. Mandelstein, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit