WO2005027019A3 - A method and apparatus for semantic discovery and mapping between data sources - Google Patents

A method and apparatus for semantic discovery and mapping between data sources Download PDF

Info

Publication number
WO2005027019A3
WO2005027019A3 PCT/US2004/029631 US2004029631W WO2005027019A3 WO 2005027019 A3 WO2005027019 A3 WO 2005027019A3 US 2004029631 W US2004029631 W US 2004029631W WO 2005027019 A3 WO2005027019 A3 WO 2005027019A3
Authority
WO
WIPO (PCT)
Prior art keywords
data
mapping
data sources
data source
portions
Prior art date
Application number
PCT/US2004/029631
Other languages
French (fr)
Other versions
WO2005027019A2 (en
Inventor
Alexander Gorelik
Lingling Yan
Original Assignee
Exeros Inc
Alexander Gorelik
Lingling Yan
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Exeros Inc, Alexander Gorelik, Lingling Yan filed Critical Exeros Inc
Publication of WO2005027019A2 publication Critical patent/WO2005027019A2/en
Publication of WO2005027019A3 publication Critical patent/WO2005027019A3/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G06F16/221—Column-oriented storage; Management thereof
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21—Design, administration or maintenance of databases
    • G06F16/211—Schema design and management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2228—Indexing structures
    • G06F16/2237—Vectors, bitmaps or matrices
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24542—Plan optimisation
    • G06F16/24544—Join order optimisation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2468—Fuzzy queries
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99942—Manipulating data structure, e.g. compression, compaction, compilation
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99943—Generating database or data structure, e.g. via user interface
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99944—Object-oriented database structure
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99944—Object-oriented database structure
    • Y10S707/99945—Object-oriented database structure processing

Abstract

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 (300, fig. 3) between a first and a second data source. A binding condition is discovered (308, fig. 3) between portions of data in the first and the second data source. The binding condition is used to discover correlations (400, fig.4) 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 (310, fig. 3) between portions of data in the first and the second data source.
PCT/US2004/029631 2003-09-10 2004-09-10 A method and apparatus for semantic discovery and mapping between data sources WO2005027019A2 (en)

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
US50204303P 2003-09-10 2003-09-10
US60/502,043 2003-09-10
US10/938,205 2004-09-09
US10/938,205 US7426520B2 (en) 2003-09-10 2004-09-09 Method and apparatus for semantic discovery and mapping between data sources

Publications (2)

Publication Number Publication Date
WO2005027019A2 WO2005027019A2 (en) 2005-03-24
WO2005027019A3 true WO2005027019A3 (en) 2006-03-23

Family

ID=34228902

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2004/029631 WO2005027019A2 (en) 2003-09-10 2004-09-10 A method and apparatus for semantic discovery and mapping between data sources

Country Status (2)

Country Link
US (6) US7426520B2 (en)
WO (1) WO2005027019A2 (en)

Families Citing this family (297)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7409685B2 (en) 2002-04-12 2008-08-05 Hewlett-Packard Development Company, L.P. Initialization and update of software and/or firmware in electronic devices
CA2414281C (en) * 2000-11-17 2009-06-02 Bitfone Corporation System and method for updating and distributing information
US8479189B2 (en) 2000-11-17 2013-07-02 Hewlett-Packard Development Company, L.P. Pattern detection preprocessor in an electronic device update generation system
US7089266B2 (en) 2003-06-02 2006-08-08 The Board Of Trustees Of The Leland Stanford Jr. University Computer systems and methods for the query and visualization of multidimensional databases
US7426520B2 (en) 2003-09-10 2008-09-16 Exeros, Inc. Method and apparatus for semantic discovery and mapping between data sources
ATE515746T1 (en) 2003-09-15 2011-07-15 Ab Initio Technology Llc DATA PROFILING
US8555273B1 (en) 2003-09-17 2013-10-08 Palm. Inc. Network for updating electronic devices
US20050102303A1 (en) * 2003-11-12 2005-05-12 International Business Machines Corporation Computer-implemented method, system and program product for mapping a user data schema to a mining model schema
US7349919B2 (en) * 2003-11-21 2008-03-25 International Business Machines Corporation Computerized method, system and program product for generating a data mining model
US8037102B2 (en) 2004-02-09 2011-10-11 Robert T. and Virginia T. Jenkins Manipulating sets of hierarchical data
US7873529B2 (en) * 2004-02-20 2011-01-18 Symphonyiri Group, Inc. System and method for analyzing and correcting retail data
US7904895B1 (en) 2004-04-21 2011-03-08 Hewlett-Packard Develpment Company, L.P. Firmware update in electronic devices employing update agent in a flash memory card
US8606723B2 (en) * 2004-06-04 2013-12-10 Sap Ag Consistent set of interfaces derived from a business object model
US8694397B2 (en) * 2004-06-18 2014-04-08 Sap Ag Consistent set of interfaces derived from a business object model
US8904273B2 (en) * 2004-07-02 2014-12-02 International Business Machines Corporation System and method of format specification
US8526940B1 (en) 2004-08-17 2013-09-03 Palm, Inc. Centralized rules repository for smart phone customer care
US7809763B2 (en) * 2004-10-15 2010-10-05 Oracle International Corporation Method(s) for updating database object metadata
US7801923B2 (en) 2004-10-29 2010-09-21 Robert T. and Virginia T. Jenkins as Trustees of the Jenkins Family Trust Method and/or system for tagging trees
US7627591B2 (en) * 2004-10-29 2009-12-01 Skyler Technology, Inc. Method and/or system for manipulating tree expressions
US7630995B2 (en) 2004-11-30 2009-12-08 Skyler Technology, Inc. Method and/or system for transmitting and/or receiving data
US7636727B2 (en) 2004-12-06 2009-12-22 Skyler Technology, Inc. Enumeration of trees from finite number of nodes
US8195693B2 (en) * 2004-12-16 2012-06-05 International Business Machines Corporation Automatic composition of services through semantic attribute matching
US7899834B2 (en) * 2004-12-23 2011-03-01 Sap Ag Method and apparatus for storing and maintaining structured documents
US8316059B1 (en) 2004-12-30 2012-11-20 Robert T. and Virginia T. Jenkins Enumeration of rooted partial subtrees
US8615530B1 (en) 2005-01-31 2013-12-24 Robert T. and Virginia T. Jenkins as Trustees for the Jenkins Family Trust Method and/or system for tree transformation
US8744937B2 (en) * 2005-02-25 2014-06-03 Sap Ag Consistent set of interfaces derived from a business object model
US7681177B2 (en) 2005-02-28 2010-03-16 Skyler Technology, Inc. Method and/or system for transforming between trees and strings
CN101142559B (en) * 2005-03-16 2011-10-19 英国电讯有限公司 Monitoring computer-controlled processes and systems
EP1708099A1 (en) * 2005-03-29 2006-10-04 BRITISH TELECOMMUNICATIONS public limited company Schema matching
EP1864247A1 (en) * 2005-04-01 2007-12-12 British Telecommunications Public Limited Company Adaptive classifier, and method of creation of classification parameters therefor
US7725468B2 (en) 2005-04-08 2010-05-25 Oracle International Corporation Improving efficiency in processing queries directed to static data sets
US7899821B1 (en) 2005-04-29 2011-03-01 Karl Schiffmann Manipulation and/or analysis of hierarchical data
US20070005658A1 (en) * 2005-07-02 2007-01-04 International Business Machines Corporation System, service, and method for automatically discovering universal data objects
US7873607B1 (en) * 2005-07-07 2011-01-18 Knutson Stanley G Model driven consolidator of database information
US8099674B2 (en) 2005-09-09 2012-01-17 Tableau Software Llc Computer systems and methods for automatically viewing multidimensional databases
US20070067278A1 (en) * 2005-09-22 2007-03-22 Gtess Corporation Data file correlation system and method
US7836022B2 (en) * 2005-10-12 2010-11-16 International Business Machines Corporation Reduction of join operations when archiving related database tables
US8176081B2 (en) * 2005-11-18 2012-05-08 International Business Machines Corporation Forms integration of an external data model not implemented through a document object model (DOM) accessible application programming interface (API)
US20070156736A1 (en) * 2006-01-05 2007-07-05 International Business Machines Corporation Method and apparatus for automatically detecting a latent referential integrity relationship between different tables of a database
US7499943B2 (en) * 2006-01-09 2009-03-03 International Business Machines Corporation Mapping for mapping source and target objects
US20070185868A1 (en) * 2006-02-08 2007-08-09 Roth Mary A Method and apparatus for semantic search of schema repositories
WO2008005102A2 (en) * 2006-05-13 2008-01-10 Sap Ag Consistent set of interfaces derived from a business object model
US7917651B2 (en) * 2006-05-26 2011-03-29 International Business Machines Corporation Apparatus, system, and method for asynchronous complex inbound transactions from SAP applications using service oriented architecture
US20070282784A1 (en) * 2006-05-31 2007-12-06 Natwar Modani Comprehensive algebraic relationship discovery in databases
EP2025095A2 (en) 2006-06-08 2009-02-18 Hewlett-Packard Development Company, L.P. Device management in a network
US20080021912A1 (en) * 2006-07-24 2008-01-24 The Mitre Corporation Tools and methods for semi-automatic schema matching
US7580944B2 (en) * 2006-07-27 2009-08-25 Yahoo! Inc. Business intelligent architecture system and method
WO2008014454A2 (en) 2006-07-27 2008-01-31 Hewlett-Packard Development Company, L.P. User experience and dependency management in a mobile device
US8566193B2 (en) * 2006-08-11 2013-10-22 Sap Ag Consistent set of interfaces derived from a business object model
US8495586B2 (en) * 2006-08-24 2013-07-23 Software Analysis and Forensic Engineering Software for filtering the results of a software source code comparison
US7987159B2 (en) * 2006-09-15 2011-07-26 Microsoft Corporation Detecting and managing changes in business data integration solutions
US8402473B1 (en) 2006-09-28 2013-03-19 Sap Ag Managing consistent interfaces for demand business objects across heterogeneous systems
EP2092441A1 (en) * 2006-10-31 2009-08-26 Nielsen Media Research, Inc. et al Methods and systems to retrieve information from data sources
WO2008101022A2 (en) * 2007-02-13 2008-08-21 The Nielsen Company (Us), Llc Methods and apparatus to reach through to business logic services
US7668860B2 (en) * 2007-04-02 2010-02-23 Business Objects Software Ltd. Apparatus and method for constructing and using a semantic abstraction for querying hierarchical data
US8156509B2 (en) 2007-06-05 2012-04-10 International Business Machines Corporation Exchanging data using data transformation
US8166000B2 (en) * 2007-06-27 2012-04-24 International Business Machines Corporation Using a data mining algorithm to generate format rules used to validate data sets
US8171001B2 (en) * 2007-06-27 2012-05-01 International Business Machines Corporation Using a data mining algorithm to generate rules used to validate a selected region of a predicted column
US20090006315A1 (en) * 2007-06-29 2009-01-01 Sougata Mukherjea Structured method for schema matching using multiple levels of ontologies
US8401987B2 (en) * 2007-07-17 2013-03-19 International Business Machines Corporation Managing validation models and rules to apply to data sets
US7970943B2 (en) * 2007-08-14 2011-06-28 Oracle International Corporation Providing interoperability in software identifier standards
US9110967B2 (en) * 2007-08-29 2015-08-18 International Business Machines Corporation Data lineage in data warehousing environments
US8122040B2 (en) * 2007-08-29 2012-02-21 Richard Banister Method of integrating remote databases by automated client scoping of update requests over a communications network
US7801884B2 (en) * 2007-09-19 2010-09-21 Accenture Global Services Gmbh Data mapping document design system
US7801908B2 (en) * 2007-09-19 2010-09-21 Accenture Global Services Gmbh Data mapping design tool
US8903842B2 (en) 2007-10-26 2014-12-02 Microsoft Corporation Metadata driven reporting and editing of databases
US8856313B2 (en) * 2007-11-13 2014-10-07 International Business Machines Corporation Systems and methods for using provenance information for data retention in stream-processing
US8190596B2 (en) * 2007-11-28 2012-05-29 International Business Machines Corporation Method for assembly of personalized enterprise information integrators over conjunctive queries
US8145684B2 (en) * 2007-11-28 2012-03-27 International Business Machines Corporation System and computer program product for assembly of personalized enterprise information integrators over conjunctive queries
US9292567B2 (en) * 2007-12-12 2016-03-22 Oracle International Corporation Bulk matching with update
US8326873B2 (en) * 2008-01-09 2012-12-04 Credit Suisse Securities (Usa) Llc Enterprise architecture system and method
US8495594B2 (en) * 2008-01-10 2013-07-23 International Business Machines Corporation Method and system for providing a componentized resource adapter architecture
US7996093B2 (en) * 2008-01-24 2011-08-09 Rockwell Automation Technologies, Inc. Automatic controller relationship resolution
US8028000B2 (en) * 2008-02-28 2011-09-27 Microsoft Corporation Data storage structure
US8417593B2 (en) 2008-02-28 2013-04-09 Sap Ag System and computer-readable medium for managing consistent interfaces for business objects across heterogeneous systems
US8645434B2 (en) * 2008-03-18 2014-02-04 Apple Inc. Techniques for schema production and transformation
US20090249358A1 (en) * 2008-03-31 2009-10-01 Sap Ag Managing Consistent Interfaces for Kanban Business Objects Across Heterogeneous Systems
US20090248429A1 (en) * 2008-03-31 2009-10-01 Sap Ag Managing Consistent Interfaces for Sales Price Business Objects Across Heterogeneous Systems
US20090248463A1 (en) * 2008-03-31 2009-10-01 Emmanuel Piochon Managing Consistent Interfaces For Trading Business Objects Across Heterogeneous Systems
US8930248B2 (en) * 2008-03-31 2015-01-06 Sap Se Managing consistent interfaces for supply network business objects across heterogeneous systems
US8200614B2 (en) * 2008-04-30 2012-06-12 SAP France S.A. Apparatus and method to transform an extract transform and load (ETL) task into a delta load task
US8352458B2 (en) * 2008-05-07 2013-01-08 Oracle International Corporation Techniques for transforming and loading data into a fact table in a data warehouse
US20090300587A1 (en) * 2008-05-27 2009-12-03 Microsoft Corporation Determining domain data coverage in testing database applications
US20090326988A1 (en) 2008-06-26 2009-12-31 Robert Barth Managing consistent interfaces for business objects across heterogeneous systems
US8671064B2 (en) * 2008-06-26 2014-03-11 Sap Ag Managing consistent interfaces for supply chain management business objects across heterogeneous systems
US8984025B1 (en) * 2008-06-30 2015-03-17 Symantec Corporation Method and apparatus for processing a transform function, a reference file and parameter information that represent a data file
US9720971B2 (en) * 2008-06-30 2017-08-01 International Business Machines Corporation Discovering transformations applied to a source table to generate a target table
US20100070491A1 (en) * 2008-09-18 2010-03-18 International Business Machines Corporation Dynamic Contextual Table Headers
US20100088117A1 (en) * 2008-10-02 2010-04-08 Siemens Medical Solutions Usa, Inc. Multi-Mode Medical Data Reporting System
US7970728B2 (en) * 2008-10-23 2011-06-28 International Business Machines Corporation Dynamically building and populating data marts with data stored in repositories
US8117218B2 (en) * 2008-11-24 2012-02-14 The Boeing Company Methods and systems for automated data mapping and analysis
US8577760B2 (en) * 2008-11-25 2013-11-05 Sap Ag Managing consistent interfaces for tax authority business objects across heterogeneous systems
US20100161344A1 (en) * 2008-12-12 2010-06-24 Dyson David S Methods and apparatus to prepare report requests
US20100153297A1 (en) 2008-12-12 2010-06-17 Sap Ag Managing Consistent Interfaces for Credit Portfolio Business Objects Across Heterogeneous Systems
US9047338B2 (en) * 2008-12-17 2015-06-02 International Business Machines Corporation Managing drill-through targets
US20100153333A1 (en) * 2008-12-17 2010-06-17 Rasmussen Glenn D Method of and System for Managing Drill-Through Source Metadata
EP2416257A4 (en) * 2009-03-31 2015-04-22 Fujitsu Ltd Computer-assisted name identification equipment, name identification method, and name identification program
JP5375413B2 (en) * 2009-07-30 2013-12-25 富士通株式会社 Data conversion apparatus, data conversion method, and data conversion program
JP4522485B1 (en) * 2009-09-18 2010-08-11 株式会社インフォース Data conversion method, apparatus and program
US8868600B2 (en) * 2009-09-29 2014-10-21 Sap Ag Value help search system and method
US20110078569A1 (en) * 2009-09-29 2011-03-31 Sap Ag Value help user interface system and method
US8396751B2 (en) 2009-09-30 2013-03-12 Sap Ag Managing consistent interfaces for merchandising business objects across heterogeneous systems
US8386529B2 (en) * 2010-02-21 2013-02-26 Microsoft Corporation Foreign-key detection
US8543535B2 (en) * 2010-02-24 2013-09-24 Oracle International Corporation Generation of star schemas from snowflake schemas containing a large number of dimensions
US9195952B2 (en) * 2010-03-26 2015-11-24 Accenture Global Services Limited Systems and methods for contextual mapping utilized in business process controls
US9785987B2 (en) 2010-04-22 2017-10-10 Microsoft Technology Licensing, Llc User interface for information presentation system
US20110282861A1 (en) * 2010-05-11 2011-11-17 Microsoft Corporation Extracting higher-order knowledge from structured data
US8433673B2 (en) 2010-05-28 2013-04-30 Oracle International Corporation System and method for supporting data warehouse metadata extension using an extender
CA2783451C (en) * 2010-06-03 2018-01-16 International Business Machines Corporation Method and system of adapting a data model to a user interface component
US8732083B2 (en) 2010-06-15 2014-05-20 Sap Ag Managing consistent interfaces for number range, number range profile, payment card payment authorisation, and product template template business objects across heterogeneous systems
US8412603B2 (en) * 2010-06-15 2013-04-02 Sap Ag Managing consistent interfaces for currency conversion and date and time business objects across heterogeneous systems
US9135585B2 (en) 2010-06-15 2015-09-15 Sap Se Managing consistent interfaces for property library, property list template, quantity conversion virtual object, and supplier property specification business objects across heterogeneous systems
US8417588B2 (en) 2010-06-15 2013-04-09 Sap Ag Managing consistent interfaces for goods tag, production bill of material hierarchy, and release order template business objects across heterogeneous systems
US20110320433A1 (en) * 2010-06-25 2011-12-29 Microsoft Corporation Automated Joining of Disparate Data for Database Queries
CA2706741C (en) 2010-06-29 2011-12-13 Ibm Canada Limited - Ibm Canada Limitee Managing parameters in filter expressions
US8370316B2 (en) * 2010-07-12 2013-02-05 Sap Ag Hash-join in parallel computation environments
US9043296B2 (en) 2010-07-30 2015-05-26 Microsoft Technology Licensing, Llc System of providing suggestions based on accessible and contextual information
WO2012033662A2 (en) * 2010-09-10 2012-03-15 Rambus Inc. Memory controller and method for tuned address mapping
US9460189B2 (en) * 2010-09-23 2016-10-04 Microsoft Technology Licensing, Llc Data model dualization
US20120150764A1 (en) * 2010-12-10 2012-06-14 Payman Sadegh Method and system for automated business analytics modeling
JP6066927B2 (en) 2011-01-28 2017-01-25 アビニシオ テクノロジー エルエルシー Generation of data pattern information
US8380750B2 (en) 2011-02-17 2013-02-19 International Business Machines Corporation Searching and displaying data objects residing in data management systems
US8745053B2 (en) 2011-03-01 2014-06-03 Xbridge Systems, Inc. Method for managing mainframe overhead during detection of sensitive information, computer readable storage media and system utilizing same
US8769200B2 (en) 2011-03-01 2014-07-01 Xbridge Systems, Inc. Method for managing hierarchical storage during detection of sensitive information, computer readable storage media and system utilizing same
DE102011101154A1 (en) * 2011-05-11 2012-11-15 Abb Technology Ag Method and device for uniform naming of the same parameters of different field devices of an automation system
US8856085B2 (en) * 2011-07-19 2014-10-07 International Business Machines Corporation Automatic consistent sampling for data analysis
US8775280B2 (en) 2011-07-28 2014-07-08 Sap Ag Managing consistent interfaces for financial business objects across heterogeneous systems
US8725654B2 (en) 2011-07-28 2014-05-13 Sap Ag Managing consistent interfaces for employee data replication business objects across heterogeneous systems
US8521838B2 (en) 2011-07-28 2013-08-27 Sap Ag Managing consistent interfaces for communication system and object identifier mapping business objects across heterogeneous systems
US8601490B2 (en) 2011-07-28 2013-12-03 Sap Ag Managing consistent interfaces for business rule business object across heterogeneous systems
US8560392B2 (en) 2011-07-28 2013-10-15 Sap Ag Managing consistent interfaces for a point of sale transaction business object across heterogeneous systems
US8666845B2 (en) 2011-07-28 2014-03-04 Sap Ag Managing consistent interfaces for a customer requirement business object across heterogeneous systems
US8990675B2 (en) * 2011-10-04 2015-03-24 Microsoft Technology Licensing, Llc Automatic relationship detection for spreadsheet data items
US9747359B2 (en) * 2011-10-19 2017-08-29 Hewlett Packard Enterprise Development Lp Using a database to translate a natural key to a surrogate key
US9122985B2 (en) 2011-10-28 2015-09-01 Microsoft Technology Licensing, Llc Programmatic access to terminologies expressed in hierarchical form
US9098312B2 (en) 2011-11-16 2015-08-04 Ptc Inc. Methods for dynamically generating an application interface for a modeled entity and devices thereof
US9576046B2 (en) 2011-11-16 2017-02-21 Ptc Inc. Methods for integrating semantic search, query, and analysis across heterogeneous data types and devices thereof
US8909641B2 (en) 2011-11-16 2014-12-09 Ptc Inc. Method for analyzing time series activity streams and devices thereof
US8577833B2 (en) 2012-01-04 2013-11-05 International Business Machines Corporation Automated data analysis and transformation
US9111014B1 (en) 2012-01-06 2015-08-18 Amazon Technologies, Inc. Rule builder for data processing
US9232368B2 (en) 2012-02-16 2016-01-05 Sap Se Consistent interface for user feed administrator, user feed event link and user feed settings
US8762454B2 (en) 2012-02-16 2014-06-24 Sap Ag Consistent interface for flag and tag
US8984050B2 (en) 2012-02-16 2015-03-17 Sap Se Consistent interface for sales territory message type set 2
US8762453B2 (en) 2012-02-16 2014-06-24 Sap Ag Consistent interface for feed collaboration group and feed event subscription
US8756274B2 (en) 2012-02-16 2014-06-17 Sap Ag Consistent interface for sales territory message type set 1
US9237425B2 (en) 2012-02-16 2016-01-12 Sap Se Consistent interface for feed event, feed event document and feed event type
US9336246B2 (en) 2012-02-28 2016-05-10 International Business Machines Corporation Generating composite key relationships between database objects based on sampling
US20130238669A1 (en) * 2012-03-09 2013-09-12 Business Objects Software Ltd Using Target Columns in Data Transformation
US8930303B2 (en) 2012-03-30 2015-01-06 International Business Machines Corporation Discovering pivot type relationships between database objects
US8682885B2 (en) * 2012-05-15 2014-03-25 Sap Ag Method and system for combining data objects
US10229200B2 (en) 2012-06-08 2019-03-12 International Business Machines Corporation Linking data elements based on similarity data values and semantic annotations
WO2014000200A1 (en) 2012-06-28 2014-01-03 Sap Ag Consistent interface for document output request
US8521621B1 (en) 2012-06-28 2013-08-27 Sap Ag Consistent interface for inbound delivery request
US8756135B2 (en) 2012-06-28 2014-06-17 Sap Ag Consistent interface for product valuation data and product valuation level
US8949855B2 (en) 2012-06-28 2015-02-03 Sap Se Consistent interface for address snapshot and approval process definition
US9246869B2 (en) 2012-06-28 2016-01-26 Sap Se Consistent interface for opportunity
US9367826B2 (en) 2012-06-28 2016-06-14 Sap Se Consistent interface for entitlement product
US9400998B2 (en) 2012-06-28 2016-07-26 Sap Se Consistent interface for message-based communication arrangement, organisational centre replication request, and payment schedule
US8615451B1 (en) 2012-06-28 2013-12-24 Sap Ag Consistent interface for goods and activity confirmation
US9026561B2 (en) 2012-07-02 2015-05-05 International Business Machines Corporation Automated report of broken relationships between tables
US9043236B2 (en) 2012-08-22 2015-05-26 Sap Se Consistent interface for financial instrument impairment attribute values analytical result
US9547833B2 (en) 2012-08-22 2017-01-17 Sap Se Consistent interface for financial instrument impairment calculation
US9076112B2 (en) 2012-08-22 2015-07-07 Sap Se Consistent interface for financial instrument impairment expected cash flow analytical result
US9324033B2 (en) * 2012-09-13 2016-04-26 Nokia Technologies Oy Method and apparatus for providing standard data processing model through machine learning
EP2713288B1 (en) * 2012-09-26 2020-05-06 Tata Consultancy Services Limited Foreign key identification in database management systems
US9633076B1 (en) 2012-10-15 2017-04-25 Tableau Software Inc. Blending and visualizing data from multiple data sources
US9576020B1 (en) * 2012-10-18 2017-02-21 Proofpoint, Inc. Methods, systems, and computer program products for storing graph-oriented data on a column-oriented database
KR102129643B1 (en) 2012-10-22 2020-07-02 아브 이니티오 테크놀로지 엘엘시 Profiling data with source tracking
US10671926B2 (en) 2012-11-30 2020-06-02 Servicenow, Inc. Method and system for generating predictive models for scoring and prioritizing opportunities
US9280739B2 (en) 2012-11-30 2016-03-08 Dxcontinuum Inc. Computer implemented system for automating the generation of a business decision analytic model
US10706359B2 (en) 2012-11-30 2020-07-07 Servicenow, Inc. Method and system for generating predictive models for scoring and prioritizing leads
US9892026B2 (en) * 2013-02-01 2018-02-13 Ab Initio Technology Llc Data records selection
US9191357B2 (en) 2013-03-15 2015-11-17 Sap Se Consistent interface for email activity business object
US10268639B2 (en) * 2013-03-15 2019-04-23 Inpixon Joining large database tables
US9191343B2 (en) 2013-03-15 2015-11-17 Sap Se Consistent interface for appointment activity business object
EP2973047A4 (en) 2013-03-15 2016-11-02 Ptc Inc Methods for managing applications using semantic modeling and tagging and devices thereof
US9619538B2 (en) * 2013-03-15 2017-04-11 Teradata Us, Inc. Techniques for data integration
US9116940B1 (en) * 2013-04-15 2015-08-25 Google Inc. Searching for join candidates
US9514244B2 (en) * 2013-04-29 2016-12-06 International Business Machines Corporation Dynamic assignment of business logic based on schema mapping metadata
US9794877B2 (en) 2013-04-30 2017-10-17 International Business Machines Corporation Transmitting device, receiving device, communication device, programs, transmission method, and receiving method for wireless communication of continuous data in the form of packets
US9710534B2 (en) 2013-05-07 2017-07-18 International Business Machines Corporation Methods and systems for discovery of linkage points between data sources
US9256657B1 (en) * 2013-06-13 2016-02-09 Amazon Technologies, Inc. Tracking data communicated between services
KR20170142215A (en) * 2013-07-02 2017-12-27 콘비다 와이어리스, 엘엘씨 Mechanisms for semantics publishing and discovery
US9305067B2 (en) 2013-07-19 2016-04-05 International Business Machines Corporation Creation of change-based data integration jobs
US9449060B2 (en) * 2013-08-06 2016-09-20 International Business Machines Corporation Post-migration validation of ETL jobs and exception management
US9454557B2 (en) * 2013-08-29 2016-09-27 Oracle International Corporation Unit of work based incremental data processing
JP6017055B2 (en) * 2013-10-10 2016-10-26 三菱電機株式会社 Data linkage support apparatus and data linkage support method
CN104598374B (en) 2013-10-30 2017-12-01 国际商业机器公司 The method and apparatus of correction failure script
US10515231B2 (en) * 2013-11-08 2019-12-24 Symcor Inc. Method of obfuscating relationships between data in database tables
JP6173896B2 (en) * 2013-12-10 2017-08-02 株式会社日立製作所 Data processing method and data processing server
US9578120B1 (en) * 2013-12-20 2017-02-21 Amazon Technologies, Inc. Messaging with key-value persistence
US11487732B2 (en) 2014-01-16 2022-11-01 Ab Initio Technology Llc Database key identification
US20150242409A1 (en) * 2014-02-22 2015-08-27 SourceThought, Inc. Automated Data Shaping
US20150242407A1 (en) * 2014-02-22 2015-08-27 SourceThought, Inc. Discovery of Data Relationships Between Disparate Data Sets
EP3114578A1 (en) 2014-03-07 2017-01-11 AB Initio Technology LLC Managing data profiling operations related to data type
US9350812B2 (en) 2014-03-21 2016-05-24 Ptc Inc. System and method of message routing using name-based identifier in a distributed computing environment
US10313410B2 (en) 2014-03-21 2019-06-04 Ptc Inc. Systems and methods using binary dynamic rest messages
US10025942B2 (en) 2014-03-21 2018-07-17 Ptc Inc. System and method of establishing permission for multi-tenancy storage using organization matrices
US9560170B2 (en) 2014-03-21 2017-01-31 Ptc Inc. System and method of abstracting communication protocol using self-describing messages
WO2015143416A1 (en) 2014-03-21 2015-09-24 Ptc Inc. Systems and methods for developing and using real-time data applications
US9462085B2 (en) 2014-03-21 2016-10-04 Ptc Inc. Chunk-based communication of binary dynamic rest messages
US9961058B2 (en) 2014-03-21 2018-05-01 Ptc Inc. System and method of message routing via connection servers in a distributed computing environment
US9467533B2 (en) 2014-03-21 2016-10-11 Ptc Inc. System and method for developing real-time web-service objects
US9762637B2 (en) 2014-03-21 2017-09-12 Ptc Inc. System and method of using binary dynamic rest messages
US9350791B2 (en) 2014-03-21 2016-05-24 Ptc Inc. System and method of injecting states into message routing in a distributed computing environment
US9335938B2 (en) 2014-03-27 2016-05-10 International Business Machines Corporation Optimized transfer and storage of highly denormalized data in an in-memory data grid
US9916357B2 (en) 2014-06-27 2018-03-13 Microsoft Technology Licensing, Llc Rule-based joining of foreign to primary key
EP3163468B1 (en) * 2014-06-27 2020-09-02 Sony Corporation Information processing device, information processing method, and program
CN105447032A (en) * 2014-08-29 2016-03-30 国际商业机器公司 Method and system for processing message and subscription information
MY187722A (en) * 2014-10-14 2021-10-14 Mimos Berhad A system and method for managing a collection of data
US9740743B2 (en) * 2014-10-20 2017-08-22 Salesforce.Com, Inc. Matching objects using keys based on match rules
US11157473B2 (en) 2014-11-21 2021-10-26 Red Hat, Inc. Multisource semantic partitioning
US9679024B2 (en) * 2014-12-01 2017-06-13 Facebook, Inc. Social-based spelling correction for online social networks
US9684699B2 (en) * 2014-12-03 2017-06-20 Sas Institute Inc. System to convert semantic layer metadata to support database conversion
US9977812B2 (en) 2015-01-30 2018-05-22 Microsoft Technology Licensing, Llc Trie-structure formulation and navigation for joining
US9892143B2 (en) 2015-02-04 2018-02-13 Microsoft Technology Licensing, Llc Association index linking child and parent tables
US10339151B2 (en) 2015-02-23 2019-07-02 Red Hat, Inc. Creating federated data source connectors
US11068647B2 (en) 2015-05-28 2021-07-20 International Business Machines Corporation Measuring transitions between visualizations
US10417282B1 (en) 2015-07-22 2019-09-17 Wells Fargo Bank, N.A. Entity mapping
US10248701B2 (en) * 2015-09-18 2019-04-02 International Business Machines Corporation Efficient distributed query execution
US10607139B2 (en) 2015-09-23 2020-03-31 International Business Machines Corporation Candidate visualization techniques for use with genetic algorithms
US9558245B1 (en) 2015-12-07 2017-01-31 International Business Machines Corporation Automatic discovery of relevant data in massive datasets
CN106897657B (en) * 2015-12-18 2020-10-27 大唐电信科技股份有限公司 Face living body detection method and device
US10678608B2 (en) 2016-02-29 2020-06-09 Red Hat Israel, Ltd. Interacting with a source object via a virtual object
US11847040B2 (en) 2016-03-16 2023-12-19 Asg Technologies Group, Inc. Systems and methods for detecting data alteration from source to target
US11086751B2 (en) * 2016-03-16 2021-08-10 Asg Technologies Group, Inc. Intelligent metadata management and data lineage tracing
US10621048B1 (en) * 2016-04-27 2020-04-14 Jpmorgan Chase Bank, N.A. Method and system for implementing a backup validation engine
WO2017197402A2 (en) 2016-05-13 2017-11-16 Maana, Inc. Machine-assisted object matching
US10459979B2 (en) * 2016-06-30 2019-10-29 Facebook, Inc. Graphically managing data classification workflows in a social networking system with directed graphs
US10698954B2 (en) * 2016-06-30 2020-06-30 Facebook, Inc. Computation platform agnostic data classification workflows
US10685035B2 (en) 2016-06-30 2020-06-16 International Business Machines Corporation Determining a collection of data visualizations
US11042536B1 (en) * 2016-09-06 2021-06-22 Jpmorgan Chase Bank, N.A. Systems and methods for automated data visualization
US10650000B2 (en) * 2016-09-15 2020-05-12 Oracle International Corporation Techniques for relationship discovery between datasets
US10445062B2 (en) 2016-09-15 2019-10-15 Oracle International Corporation Techniques for dataset similarity discovery
US10565222B2 (en) 2016-09-15 2020-02-18 Oracle International Corporation Techniques for facilitating the joining of datasets
US10621195B2 (en) 2016-09-20 2020-04-14 Microsoft Technology Licensing, Llc Facilitating data transformations
US10706066B2 (en) 2016-10-17 2020-07-07 Microsoft Technology Licensing, Llc Extensible data transformations
US10546055B2 (en) * 2016-10-20 2020-01-28 Microsoft Technology Licensing, Llc Join with format modification by example
US10776380B2 (en) * 2016-10-21 2020-09-15 Microsoft Technology Licensing, Llc Efficient transformation program generation
US11163788B2 (en) 2016-11-04 2021-11-02 Microsoft Technology Licensing, Llc Generating and ranking transformation programs
US11170020B2 (en) 2016-11-04 2021-11-09 Microsoft Technology Licensing, Llc Collecting and annotating transformation tools for use in generating transformation programs
US11726753B2 (en) * 2016-12-03 2023-08-15 Thomas STACHURA Spreadsheet-based software application development
US10402368B2 (en) 2017-01-04 2019-09-03 Red Hat, Inc. Content aggregation for unstructured data
US10162881B2 (en) * 2017-01-17 2018-12-25 Maana, Inc. Machine-assisted key discovery and join generation
US11086895B2 (en) 2017-05-09 2021-08-10 Oracle International Corporation System and method for providing a hybrid set-based extract, load, and transformation of data
US11074235B2 (en) 2017-08-10 2021-07-27 Io-Tahoe Llc Inclusion dependency determination in a large database for establishing primary key-foreign key relationships
US11620315B2 (en) 2017-10-09 2023-04-04 Tableau Software, Inc. Using an object model of heterogeneous data to facilitate building data visualizations
US11057500B2 (en) 2017-11-20 2021-07-06 Asg Technologies Group, Inc. Publication of applications using server-side virtual screen change capture
US10896297B1 (en) 2017-12-13 2021-01-19 Tableau Software, Inc. Identifying intent in visual analytical conversations
US10783161B2 (en) 2017-12-15 2020-09-22 International Business Machines Corporation Generating a recommended shaping function to integrate data within a data repository
US10891274B2 (en) * 2017-12-21 2021-01-12 International Business Machines Corporation Data shuffling with hierarchical tuple spaces
US10956125B2 (en) 2017-12-21 2021-03-23 International Business Machines Corporation Data shuffling with hierarchical tuple spaces
CN108304469B (en) * 2017-12-27 2021-12-07 中国银联股份有限公司 Method and device for fuzzy matching of character strings
US10812611B2 (en) 2017-12-29 2020-10-20 Asg Technologies Group, Inc. Platform-independent application publishing to a personalized front-end interface by encapsulating published content into a container
US10877740B2 (en) 2017-12-29 2020-12-29 Asg Technologies Group, Inc. Dynamically deploying a component in an application
US11611633B2 (en) 2017-12-29 2023-03-21 Asg Technologies Group, Inc. Systems and methods for platform-independent application publishing to a front-end interface
US11068540B2 (en) 2018-01-25 2021-07-20 Ab Initio Technology Llc Techniques for integrating validation results in data profiling and related systems and methods
US10740075B2 (en) * 2018-02-06 2020-08-11 Smartshift Technologies, Inc. Systems and methods for code clustering analysis and transformation
US11030248B2 (en) 2018-04-18 2021-06-08 Palantir Technologies Inc. Resource dependency system and graphical user interface
CN108632270B (en) * 2018-05-03 2020-07-24 河海大学常州校区 Low-rate TCP DoS attack prevention method based on software defined network
US11442952B2 (en) 2018-09-24 2022-09-13 Salesforce, Inc. User interface for commerce architecture
US11226970B2 (en) * 2018-09-28 2022-01-18 Hitachi Vantara Llc System and method for tagging database properties
US11055489B2 (en) 2018-10-08 2021-07-06 Tableau Software, Inc. Determining levels of detail for data visualizations using natural language constructs
US11755754B2 (en) * 2018-10-19 2023-09-12 Oracle International Corporation Systems and methods for securing data based on discovered relationships
US11537276B2 (en) 2018-10-22 2022-12-27 Tableau Software, Inc. Generating data visualizations according to an object model of selected data sources
US10996835B1 (en) 2018-12-14 2021-05-04 Tableau Software, Inc. Data preparation user interface with coordinated pivots
US11106642B2 (en) * 2018-12-26 2021-08-31 Io-Tahoe LLC. Cataloging database metadata using a probabilistic signature matching process
US10942908B2 (en) * 2019-01-14 2021-03-09 Business Objects Software Ltd. Primary key determination
US11106719B2 (en) 2019-02-22 2021-08-31 International Business Machines Corporation Heuristic dimension reduction in metadata modeling
US11030255B1 (en) 2019-04-01 2021-06-08 Tableau Software, LLC Methods and systems for inferring intent and utilizing context for natural language expressions to generate data visualizations in a data visualization interface
US20200356559A1 (en) * 2019-05-08 2020-11-12 Datameer, Inc. Query Combination In A Hybrid Multi-Cloud Database Environment
US11704494B2 (en) * 2019-05-31 2023-07-18 Ab Initio Technology Llc Discovering a semantic meaning of data fields from profile data of the data fields
US11153400B1 (en) 2019-06-04 2021-10-19 Thomas Layne Bascom Federation broker system and method for coordinating discovery, interoperability, connections and correspondence among networked resources
US11762634B2 (en) 2019-06-28 2023-09-19 Asg Technologies Group, Inc. Systems and methods for seamlessly integrating multiple products by using a common visual modeler
US11042558B1 (en) 2019-09-06 2021-06-22 Tableau Software, Inc. Determining ranges for vague modifiers in natural language commands
US11003645B1 (en) * 2019-10-04 2021-05-11 Palantir Technologies Inc. Column lineage for resource dependency system and graphical user interface
US11055067B2 (en) 2019-10-18 2021-07-06 Asg Technologies Group, Inc. Unified digital automation platform
US11886397B2 (en) 2019-10-18 2024-01-30 Asg Technologies Group, Inc. Multi-faceted trust system
US11269660B2 (en) 2019-10-18 2022-03-08 Asg Technologies Group, Inc. Methods and systems for integrated development environment editor support with a single code base
US11941137B2 (en) 2019-10-18 2024-03-26 Asg Technologies Group, Inc. Use of multi-faceted trust scores for decision making, action triggering, and data analysis and interpretation
US11755760B2 (en) 2019-10-18 2023-09-12 Asg Technologies Group, Inc. Systems and methods for secure policies-based information governance
US11030256B2 (en) 2019-11-05 2021-06-08 Tableau Software, Inc. Methods and user interfaces for visually analyzing data visualizations with multi-row calculations
US11366858B2 (en) 2019-11-10 2022-06-21 Tableau Software, Inc. Data preparation using semantic roles
US10997217B1 (en) 2019-11-10 2021-05-04 Tableau Software, Inc. Systems and methods for visualizing object models of database tables
US11875393B2 (en) * 2020-01-28 2024-01-16 Salesforce, Inc. Generation of recommendations from dynamically-mapped data
US20210366195A1 (en) * 2020-05-22 2021-11-25 Ohio State Innovation Foundation Method and system for generating data-enriching augmented reality applications from a domain-specific language
US11281668B1 (en) 2020-06-18 2022-03-22 Tableau Software, LLC Optimizing complex database queries using query fusion
US11567920B2 (en) * 2020-09-15 2023-01-31 Sap Se Master data mapping scheme permitting querying
WO2022081476A1 (en) 2020-10-13 2022-04-21 ASG Technologies Group, Inc. dba ASG Technologies Geolocation-based policy rules
US11561522B2 (en) 2020-11-11 2023-01-24 Mapped Inc. Data mapping based on device profiles
US11816075B2 (en) 2021-07-27 2023-11-14 Bank Of America Corporation Configuration engine for dynamically generating user interfaces
US11755591B2 (en) * 2021-08-06 2023-09-12 Sap Se Metadata object identifier registry
US20230177032A1 (en) * 2021-12-08 2023-06-08 International Business Machines Corporation Performing automated semantic feature discovery
US11741102B1 (en) * 2022-03-10 2023-08-29 Express Scripts Strategic Development, Inc. Adaptive model transformation in multi-tenant environment
US11880365B2 (en) 2022-03-23 2024-01-23 Bank Of America Corporation Multimodal and distributed database system structured for dynamic latency reduction
US20230359174A1 (en) * 2022-05-06 2023-11-09 Mapped Inc. Automatic link prediction for devices in commercial and industrial environments
US11922125B2 (en) 2022-05-06 2024-03-05 Mapped Inc. Ensemble learning for extracting semantics of data in building systems

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6112198A (en) * 1997-06-30 2000-08-29 International Business Machines Corporation Optimization of data repartitioning during parallel query optimization

Family Cites Families (102)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
GB2273180A (en) 1992-12-02 1994-06-08 Ibm Database backup and recovery.
US5548749A (en) 1993-10-29 1996-08-20 Wall Data Incorporated Semantic orbject modeling system for creating relational database schemas
US5692107A (en) 1994-03-15 1997-11-25 Lockheed Missiles & Space Company, Inc. Method for generating predictive models in a computer system
US5675785A (en) 1994-10-04 1997-10-07 Hewlett-Packard Company Data warehouse which is accessed by a user using a schema of virtual tables
US5615341A (en) * 1995-05-08 1997-03-25 International Business Machines Corporation System and method for mining generalized association rules in databases
US5794209A (en) 1995-03-31 1998-08-11 International Business Machines Corporation System and method for quickly mining association rules in databases
US5802511A (en) 1996-01-02 1998-09-01 Timeline, Inc. Data retrieval method and apparatus with multiple source capability
US5806066A (en) 1996-03-26 1998-09-08 Bull Hn Information Systems Inc. Method of integrating schemas of distributed heterogeneous databases
US5813002A (en) 1996-07-31 1998-09-22 International Business Machines Corporation Method and system for linearly detecting data deviations in a large database
US5943667A (en) 1997-06-03 1999-08-24 International Business Machines Corporation Eliminating redundancy in generation of association rules for on-line mining
US6226649B1 (en) 1997-06-23 2001-05-01 Oracle Corporation Apparatus and method for transparent access of foreign databases in a heterogeneous database system
JPH1115842A (en) * 1997-06-24 1999-01-22 Mitsubishi Electric Corp Data mining device
US5978796A (en) * 1997-06-30 1999-11-02 International Business Machines Corporation Accessing multi-dimensional data by mapping dense data blocks to rows in a relational database
US6092064A (en) * 1997-11-04 2000-07-18 International Business Machines Corporation On-line mining of quantitative association rules
US6339775B1 (en) 1997-11-07 2002-01-15 Informatica Corporation Apparatus and method for performing data transformations in data warehousing
US6301575B1 (en) * 1997-11-13 2001-10-09 International Business Machines Corporation Using object relational extensions for mining association rules
IL122850A0 (en) 1998-01-05 1999-03-12 Wizsoft Pattern recognition using generalized association rules
US6298342B1 (en) 1998-03-16 2001-10-02 Microsoft Corporation Electronic database operations for perspective transformations on relational tables using pivot and unpivot columns
AU761900B2 (en) * 1998-03-27 2003-06-12 International Business Machines Corporation Processing precomputed views
US6078918A (en) 1998-04-02 2000-06-20 Trivada Corporation Online predictive memory
US6049797A (en) * 1998-04-07 2000-04-11 Lucent Technologies, Inc. Method, apparatus and programmed medium for clustering databases with categorical attributes
US6185549B1 (en) * 1998-04-29 2001-02-06 Lucent Technologies Inc. Method for mining association rules in data
JPH11345124A (en) * 1998-05-29 1999-12-14 Ibm Japan Ltd Method and device for determining rules in data base
US6182070B1 (en) * 1998-08-21 2001-01-30 International Business Machines Corporation System and method for discovering predictive association rules
US6311179B1 (en) * 1998-10-30 2001-10-30 International Business Machines Corporation System and method of generating associations
JP4406944B2 (en) 1998-11-11 2010-02-03 株式会社日立製作所 Computer system and distributed processing system for queries
US6278997B1 (en) 1999-02-05 2001-08-21 International Business Machines Corporation System and method for constraint-based rule mining in large, dense data-sets
GB2351572B (en) * 1999-06-26 2002-02-06 Univ York Data procesors
CA2281331A1 (en) 1999-09-03 2001-03-03 Cognos Incorporated Database management system
US6965888B1 (en) 1999-09-21 2005-11-15 International Business Machines Corporation Method, system, program, and data structure for cleaning a database table using a look-up table
US6604095B1 (en) 1999-09-21 2003-08-05 International Business Machines Corporation Method, system, program, and data structure for pivoting columns in a database table
US6393424B1 (en) 1999-12-29 2002-05-21 Networks Associates, Inc. Method and apparatus for using a static metadata object to reduce database accesses
US7007020B1 (en) * 2000-03-10 2006-02-28 Hewlett-Packard Development Company, L.P. Distributed OLAP-based association rule generation method and system
EP1277138B1 (en) 2000-04-04 2018-10-17 Red Hat, Inc. A system and method for accessing data in disparate information sources
US6542881B1 (en) 2000-08-03 2003-04-01 Wizsoft Inc. System and method for revealing necessary and sufficient conditions for database analysis
US6850947B1 (en) 2000-08-10 2005-02-01 Informatica Corporation Method and apparatus with data partitioning and parallel processing for transporting data for data warehousing applications
DE10134229A1 (en) 2000-08-17 2002-02-28 Ibm Computer supported method for automatic determination of differences in a data table comprising a large number of records and columns without having to have prior knowledge of the contents of the database table
US6941303B2 (en) 2000-09-20 2005-09-06 Ndsu Research Foundation System and method for organizing, compressing and structuring data for data mining readiness
JP5525673B2 (en) 2000-09-28 2014-06-18 オラクル・インターナショナル・コーポレイション Enterprise web mining system and method
US6829621B2 (en) 2000-10-06 2004-12-07 International Business Machines Corporation Automatic determination of OLAP cube dimensions
JP3815218B2 (en) 2000-12-20 2006-08-30 株式会社日立製作所 Data analysis method and apparatus
US20020128998A1 (en) 2001-03-07 2002-09-12 David Kil Automatic data explorer that determines relationships among original and derived fields
US7058637B2 (en) 2001-05-15 2006-06-06 Metatomix, Inc. Methods and apparatus for enterprise application integration
US20040093559A1 (en) 2001-05-25 2004-05-13 Ruth Amaru Web client for viewing and interrogating enterprise data semantically
US7877421B2 (en) 2001-05-25 2011-01-25 International Business Machines Corporation Method and system for mapping enterprise data assets to a semantic information model
GB2395041A (en) 2001-08-14 2004-05-12 Bloomberg Lp Distribution and mapping of financial records from data stream
US7149780B2 (en) 2001-12-14 2006-12-12 Pitney Bowes Inc. Method for determining e-mail address format rules
US7031969B2 (en) 2002-02-20 2006-04-18 Lawrence Technologies, Llc System and method for identifying relationships between database records
US20030191667A1 (en) 2002-04-09 2003-10-09 Fitzgerald David System and user interface supporting use of rules for processing healthcare and other claim data
US7149746B2 (en) 2002-05-10 2006-12-12 International Business Machines Corporation Method for schema mapping and data transformation
US6973459B1 (en) 2002-05-10 2005-12-06 Oracle International Corporation Adaptive Bayes Network data mining modeling
US7756804B2 (en) 2002-05-10 2010-07-13 Oracle International Corporation Automated model building and evaluation for data mining system
US7249118B2 (en) 2002-05-17 2007-07-24 Aleri, Inc. Database system and methods
US7028288B2 (en) 2002-06-03 2006-04-11 Sun Microsystems, Inc. Input field constraint mechanism
US7574652B2 (en) 2002-06-20 2009-08-11 Canon Kabushiki Kaisha Methods for interactively defining transforms and for generating queries by manipulating existing query data
AU2002951910A0 (en) 2002-10-04 2002-10-24 Tenix Industries Pty Limited Data quality and integrity engine
US7096217B2 (en) * 2002-10-31 2006-08-22 International Business Machines Corporation Global query correlation attributes
US7644361B2 (en) 2002-12-23 2010-01-05 Canon Kabushiki Kaisha Method of using recommendations to visually create new views of data across heterogeneous sources
CN1145901C (en) 2003-02-24 2004-04-14 杨炳儒 Intelligent decision supporting configuration method based on information excavation
US7296017B2 (en) 2003-03-28 2007-11-13 Microsoft Corporation Validation of XML data files
US7913159B2 (en) 2003-03-28 2011-03-22 Microsoft Corporation System and method for real-time validation of structured data files
US7426520B2 (en) 2003-09-10 2008-09-16 Exeros, Inc. Method and apparatus for semantic discovery and mapping between data sources
US7865507B2 (en) 2003-09-15 2011-01-04 Oracle International Corporation Data quality analyzer
US7328428B2 (en) 2003-09-23 2008-02-05 Trivergent Technologies, Inc. System and method for generating data validation rules
US20050108631A1 (en) 2003-09-29 2005-05-19 Amorin Antonio C. Method of conducting data quality analysis
US20050086250A1 (en) 2003-10-16 2005-04-21 Richardson Ellen K. Select/refresh method and apparatus
US7272776B2 (en) 2003-12-30 2007-09-18 Sap Aktiengesellschaft Master data quality
US7266537B2 (en) 2004-01-14 2007-09-04 Intelligent Results Predictive selection of content transformation in predictive modeling systems
US20050182739A1 (en) 2004-02-18 2005-08-18 Tamraparni Dasu Implementing data quality using rule based and knowledge engineering
US7761406B2 (en) 2004-03-16 2010-07-20 International Business Machines Corporation Regenerating data integration functions for transfer from a data integration platform
US7933762B2 (en) 2004-04-16 2011-04-26 Fortelligent, Inc. Predictive model generation
EP2487601A1 (en) 2004-05-04 2012-08-15 Boston Consulting Group, Inc. Method and apparatus for selecting, analyzing and visualizing related database records as a network
US20050278308A1 (en) 2004-06-01 2005-12-15 Barstow James F Methods and systems for data integration
US8055672B2 (en) 2004-06-10 2011-11-08 International Business Machines Corporation Dynamic graphical database query and data mining interface
US7251653B2 (en) 2004-06-30 2007-07-31 Microsoft Corporation Method and system for mapping between logical data and physical data
US7490106B2 (en) * 2004-07-09 2009-02-10 Microsoft Corporation Multidimensional database subcubes
US20060053382A1 (en) 2004-09-03 2006-03-09 Biowisdom Limited System and method for facilitating user interaction with multi-relational ontologies
US7627620B2 (en) 2004-12-16 2009-12-01 Oracle International Corporation Data-centric automatic data mining
US8626570B2 (en) 2004-12-22 2014-01-07 Bank Of America Corporation Method and system for data quality management
US7680791B2 (en) 2005-01-18 2010-03-16 Oracle International Corporation Method for sorting data using common prefix bytes
JP4207915B2 (en) 2005-01-24 2009-01-14 オムロン株式会社 Quality fluctuation display device, quality fluctuation display method, quality fluctuation display program, and recording medium recording the program
US20060274760A1 (en) 2005-06-07 2006-12-07 Level 3 Communications, Inc. Internet packet quality monitor
WO2007021254A2 (en) 2005-08-09 2007-02-22 Quark, Inc. Systems and methods for integrating from data sources to data target locations
US7797337B2 (en) 2005-09-29 2010-09-14 Scenera Technologies, Llc Methods, systems, and computer program products for automatically associating data with a resource as metadata based on a characteristic of the resource
US8504606B2 (en) 2005-11-09 2013-08-06 Tegic Communications Learner for resource constrained devices
US7487171B2 (en) 2005-12-30 2009-02-03 International Business Machines Corporation System and method for managing a hierarchy of databases
US20070179959A1 (en) 2006-01-30 2007-08-02 Microsoft Corporation Automatic discovery of data relationships
CA2542379A1 (en) 2006-04-07 2007-10-07 Cognos Incorporated Packaged warehouse solution system
US7634464B2 (en) 2006-06-14 2009-12-15 Microsoft Corporation Designing record matching queries utilizing examples
US8285677B2 (en) 2006-06-30 2012-10-09 International Business Machines Corporation Method and apparatus for propagating tables while preserving cyclic foreign key relationships
US20080085742A1 (en) 2006-10-10 2008-04-10 Minna Karukka Mobile communication terminal
US7836004B2 (en) 2006-12-11 2010-11-16 International Business Machines Corporation Using data mining algorithms including association rules and tree classifications to discover data rules
US20080243823A1 (en) 2007-03-28 2008-10-02 Elumindata, Inc. System and method for automatically generating information within an eletronic document
US8171001B2 (en) 2007-06-27 2012-05-01 International Business Machines Corporation Using a data mining algorithm to generate rules used to validate a selected region of a predicted column
US8166000B2 (en) 2007-06-27 2012-04-24 International Business Machines Corporation Using a data mining algorithm to generate format rules used to validate data sets
US8401987B2 (en) 2007-07-17 2013-03-19 International Business Machines Corporation Managing validation models and rules to apply to data sets
US7702694B1 (en) 2007-09-07 2010-04-20 Southern Company Services, Inc. System and method for organizing managing and accessing large quantities of data from non-homogenous data sources
US8055668B2 (en) 2008-02-13 2011-11-08 Camouflage Software, Inc. Method and system for masking data in a consistent manner across multiple data sources
US8306932B2 (en) 2008-04-08 2012-11-06 Infosys Technologies Limited System and method for adaptive data masking
US9720971B2 (en) 2008-06-30 2017-08-01 International Business Machines Corporation Discovering transformations applied to a source table to generate a target table
US8996563B2 (en) 2010-04-06 2015-03-31 Tokutek, Inc. High-performance streaming dictionary
US8386493B2 (en) 2010-09-23 2013-02-26 Infosys Technologies Limited System and method for schema matching

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6112198A (en) * 1997-06-30 2000-08-29 International Business Machines Corporation Optimization of data repartitioning during parallel query optimization

Also Published As

Publication number Publication date
US20060271528A1 (en) 2006-11-30
WO2005027019A2 (en) 2005-03-24
US7426520B2 (en) 2008-09-16
US7680828B2 (en) 2010-03-16
US8082243B2 (en) 2011-12-20
US8874613B2 (en) 2014-10-28
US20150074117A1 (en) 2015-03-12
US9336253B2 (en) 2016-05-10
US20050055369A1 (en) 2005-03-10
US20130254183A1 (en) 2013-09-26
US20090094274A1 (en) 2009-04-09
US8442999B2 (en) 2013-05-14
US20120158745A1 (en) 2012-06-21

Similar Documents

Publication Publication Date Title
WO2005027019A3 (en) A method and apparatus for semantic discovery and mapping between data sources
WO2004095428A3 (en) Index and query processor for data and information retrieval, integration and sharing from multiple disparate data sources
GB2399916B (en) Transforming multimedia data for delivery to multiple heterogeneous devices
WO2002001416A3 (en) Architecture for distributed database information access
WO2002097623A3 (en) Management and synchronization application for network file system
AU2003295145A1 (en) Communications system and method
WO2002057882A3 (en) System and method for conducting electronic commerce
WO2005008358A3 (en) Information access using ontologies
WO2002052382A3 (en) Method and system for sharing investor information over an electronic network
IL151091A0 (en) Method and system for updating an archive of a computer file
TWI256556B (en) Distributed concurrent version management system and method
EP1081611A3 (en) Query engine and method for Querying data using metadata model
EP2485165A3 (en) Method and system of unifying data
WO2002008888A3 (en) System, method, and article of manufacture for a reconfigurable hardware-based multimedia device
WO2004084002A3 (en) Systems and methods for providing access to data stored in different types of data repositories
WO2004010354A3 (en) Business solution management (bsm)
WO2002019096A3 (en) Reconfiguration and preservation of setup data
AU2003226089A1 (en) Customized media interface
WO2003054694A3 (en) Method and system for attribute management in a namespace
WO2005050386A3 (en) System and method for performing a snapshot and for restoring data
AU2002337779A1 (en) Computing system and method to implicity commit unsaved data for a world wide web application
WO2003091829A3 (en) A method, computer program and computer for accessing data in an environment of multiple data repositories
AU2003214934A1 (en) Method and system for multimedia tags
AU2003267042A1 (en) Methods and systems for archiving data
WO2007078774A3 (en) Conflict resolution in highly available network element

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BW BY BZ CA CH CN CO CR CU CZ DK DM DZ EC EE EG ES FI GB GD GE GM HR HU ID IL IN IS JP KE KG KP KZ LC LK LR LS LT LU LV MA MD MK MN MW MX MZ NA NI NO NZ PG PH PL PT RO RU SC SD SE SG SK SY TJ TM TN TR TT TZ UA UG US UZ VN YU ZA ZM

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): BW GH GM KE LS MW MZ NA SD SZ TZ UG ZM ZW AM AZ BY KG MD RU TJ TM AT BE BG CH CY DE DK EE ES FI FR GB GR HU IE IT MC NL PL PT RO SE SI SK TR BF CF CG CI CM GA GN GQ GW ML MR SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
122 Ep: pct application non-entry in european phase