WO2000057311A3 - Method and system for manipulating data from multiple sources - Google Patents

Method and system for manipulating data from multiple sources Download PDF

Info

Publication number
WO2000057311A3
WO2000057311A3 PCT/US2000/007782 US0007782W WO0057311A3 WO 2000057311 A3 WO2000057311 A3 WO 2000057311A3 US 0007782 W US0007782 W US 0007782W WO 0057311 A3 WO0057311 A3 WO 0057311A3
Authority
WO
WIPO (PCT)
Prior art keywords
data
information
databases
relational
fields
Prior art date
Application number
PCT/US2000/007782
Other languages
French (fr)
Other versions
WO2000057311A2 (en
Inventor
Asad Shamim
Sam Eubanks
Original Assignee
Quansoo Group Inc
Asad Shamim
Sam Eubanks
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 Quansoo Group Inc, Asad Shamim, Sam Eubanks filed Critical Quansoo Group Inc
Priority to AU39155/00A priority Critical patent/AU3915500A/en
Publication of WO2000057311A2 publication Critical patent/WO2000057311A2/en
Publication of WO2000057311A3 publication Critical patent/WO2000057311A3/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/25—Integrating or interfacing systems involving database management systems
    • G06F16/258—Data format conversion from or to a database

Abstract

The invention provides users a simplified view of information stored in, and across, all of their operational systems, which may include data warehouses/marts, relational and non-relational databases and text sources. This enables users to query quickly and easily any cross-enterprise data source for up-to-the-minute information. It allows them access to current information in real-time, regardless of where the data resides. Embodiments of the invention allow users make queries through their web browser and receive immediate, direct, simultaneous access to information from multiple ERP systems, proprietary databases, strategic extranets and the Internet. The invention transposes data formats from different databases into a common format, enabling users to access and use information from different, incompatible databases simultaneously. Scenarios can be saved in the server and integrated into any Internet/Intranet application. As such, the invention integrates business data from incompatible systems, without creating an additional data store. Embodiments of the invention include an object-oriented data retrieval system for retrieving data from a plurality of external data sources. The object-oriented data retrieval system includes a category object encoded in an object-oriented programming language. In embodiments of the invention, the category object may contain a plurality of meta fields and at least one function for ordering data in the plurality of meta fields. The system also contains a plurality of transposed objects encoded in the object-oriented programming language, which contain functions for mapping fields from the plurality of relational data sources to the plurality of meta fields.
PCT/US2000/007782 1999-03-23 2000-03-23 Method and system for manipulating data from multiple sources WO2000057311A2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU39155/00A AU3915500A (en) 1999-03-23 2000-03-23 Method and system for manipulating data from multiple sources

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US12592399P 1999-03-23 1999-03-23
US60/125,923 1999-03-23

Publications (2)

Publication Number Publication Date
WO2000057311A2 WO2000057311A2 (en) 2000-09-28
WO2000057311A3 true WO2000057311A3 (en) 2001-07-05

Family

ID=22422077

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2000/007782 WO2000057311A2 (en) 1999-03-23 2000-03-23 Method and system for manipulating data from multiple sources

Country Status (2)

Country Link
AU (1) AU3915500A (en)
WO (1) WO2000057311A2 (en)

Families Citing this family (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2000172550A (en) 1998-12-07 2000-06-23 Fujitsu Ltd Inter-information processing system cooperation device, integrated information processing system and recording medium recording inter-information processing system cooperation program
US6377934B1 (en) 1999-01-15 2002-04-23 Metaedge Corporation Method for providing a reverse star schema data model
US6363353B1 (en) * 1999-01-15 2002-03-26 Metaedge Corporation System for providing a reverse star schema data model
US6411961B1 (en) * 1999-01-15 2002-06-25 Metaedge Corporation Apparatus for providing a reverse star schema data model
US7111010B2 (en) 2000-09-25 2006-09-19 Hon Hai Precision Industry, Ltd. Method and system for managing event attributes
EP1326402A1 (en) * 2002-01-07 2003-07-09 RAI RADIOTELEVISIONE ITALIANA (S.p.A.) System and method for data transfer between media asset management systems
GB0228447D0 (en) 2002-12-06 2003-01-08 Nicholls Charles M System for detecting and interpreting transactions events or changes in computer systems
EP1703420A1 (en) * 2005-03-18 2006-09-20 Sap Ag A data processing system and method
US7529761B2 (en) 2005-12-14 2009-05-05 Microsoft Corporation Two-dimensional conditional random fields for web extraction
WO2007087134A2 (en) 2006-01-20 2007-08-02 Bookham Technology Plc Optical beam steering and sampling apparatus and method
US7921432B2 (en) 2006-03-17 2011-04-05 Microsoft Corporation Managed application execution application programming interface and schema
US7908611B2 (en) 2006-03-17 2011-03-15 Microsoft Corporation Unmanaged programming language interoperability with managed internet protocol context
US8001130B2 (en) 2006-07-25 2011-08-16 Microsoft Corporation Web object retrieval based on a language model
US7720830B2 (en) 2006-07-31 2010-05-18 Microsoft Corporation Hierarchical conditional random fields for web extraction
US7921106B2 (en) 2006-08-03 2011-04-05 Microsoft Corporation Group-by attribute value in search results
US8504513B2 (en) 2009-11-25 2013-08-06 Microsoft Corporation Auto-generation of code for performing a transform in an extract, transform, and load process
WO2014092697A1 (en) * 2012-12-11 2014-06-19 Tmm Data, Llc Methods and systems for collecting, managing, and sharing data
US20140172516A1 (en) * 2012-12-17 2014-06-19 John Tuck Davison Systems and methods for streamlining data compilation and report generation
US11442931B2 (en) * 2019-09-27 2022-09-13 Amazon Technologies, Inc. Enabling federated query access to Heterogeneous data sources

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5764973A (en) * 1994-02-08 1998-06-09 Enterworks.Com, Inc. System for generating structured query language statements and integrating legacy systems
US5806066A (en) * 1996-03-26 1998-09-08 Bull Hn Information Systems Inc. Method of integrating schemas of distributed heterogeneous databases

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5764973A (en) * 1994-02-08 1998-06-09 Enterworks.Com, Inc. System for generating structured query language statements and integrating legacy systems
US5806066A (en) * 1996-03-26 1998-09-08 Bull Hn Information Systems Inc. Method of integrating schemas of distributed heterogeneous databases

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
CHRISTINE PARENT, ET AL.: "Issues and Approaches of Database Integration", ASSOCIATION FOR COMPUTING MACHINERY, XP002157038 *
DAI H: "An object-oriented approach to schema integration and data mining in multiple databases", PROCEEDINGS. TECHNOLOGY OF OBJECT-ORIENTED LANGUAGES. TOOLS 24 (CAT. NO.97TB100240), PROCEEDINGS. TECHNOLOGY OF OBJECT-ORIENTED LANGUAGES. TOOLS 24, BEIJING, CHINA, SEPT. 1997, 1998, Los Alamitos, CA, USA, IEEE Comput. Soc, USA, pages 294 - 303, XP002157037, ISBN: 0-8186-8551-4 *

Also Published As

Publication number Publication date
WO2000057311A2 (en) 2000-09-28
AU3915500A (en) 2000-10-09

Similar Documents

Publication Publication Date Title
WO2000057311A3 (en) Method and system for manipulating data from multiple sources
US6925474B2 (en) Video information retrieval
US6134552A (en) Knowledge provider with logical hyperlinks
US5799310A (en) Relational database extenders for handling complex data types
Eder et al. Changes of dimension data in temporal data warehouses
US5678038A (en) Storing and retrieving heterogeneous classification systems utilizing globally unique identifiers
US6466940B1 (en) Building a database of CCG values of web pages from extracted attributes
US8145641B2 (en) Managing feature data based on spatial collections
US20030041304A1 (en) Structured document management system and structured document management method
US7953755B2 (en) Semantic relational database
US20070192351A1 (en) System and method for high performance template driven metadata schema mapping and data storage for surveillance and sensor devices
US20020103829A1 (en) Method, system, program, and data structures for managing structured documents in a database
Schöning et al. Tamino—an internet database system
CN101292242A (en) Managing relationships between resources stored within a repository
CA2180906A1 (en) Information Management Apparatus Providing Efficient Management of Multimedia Titles in a Client-Server Network
WO2003054694A3 (en) Method and system for attribute management in a namespace
US7496556B2 (en) UPIKM database system with integrated XML interface
WO2002021339A3 (en) Method and apparatus for xml data storage, query rewrites, visualization, mapping and references
Trujillo et al. Applying UML and XML for designing and interchanging information for data warehouses and OLAP applications
Michard et al. The Aquarelle resource discovery system
de Carvalho Moura et al. A survey on metadata for describing and retrieving Internet resources
US20070150458A1 (en) System for extending data query using ontology, and method therefor
Lang et al. XML, metadata and efficient knowledge discovery
US6910051B2 (en) Method and system for mechanism for dynamic extension of attributes in a content management system
Deßloch et al. Information Integration - Goals and Challenges

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 BR BY CA CH CN CR CU CZ DE DK DM DZ EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG US UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): GH GM KE LS MW SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
AK Designated states

Kind code of ref document: A3

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY CA CH CN CR CU CZ DE DK DM DZ EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG US UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: A3

Designated state(s): GH GM KE LS MW SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

REG Reference to national code

Ref country code: DE

Ref legal event code: 8642

122 Ep: pct application non-entry in european phase
NENP Non-entry into the national phase

Ref country code: JP