[go: up one dir, main page]

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

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

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)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7528364B2 (en) 2006-01-20 2009-05-05 Bookham Technology Plc Optical beam steering and sampling apparatus and method

Families Citing this family (18)

* 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 Information processing system cooperation apparatus, integrated information processing system, and recording medium storing information processing system cooperation program
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
US6377934B1 (en) * 1999-01-15 2002-04-23 Metaedge Corporation Method 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
US7908611B2 (en) 2006-03-17 2011-03-15 Microsoft Corporation Unmanaged programming language interoperability with managed internet protocol context
US7921432B2 (en) 2006-03-17 2011-04-05 Microsoft Corporation Managed application execution application programming interface and schema
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 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7528364B2 (en) 2006-01-20 2009-05-05 Bookham Technology Plc Optical beam steering and sampling apparatus and method

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
US7599957B2 (en) System and method for high performance template driven metadata schema mapping and data storage for surveillance and sensor devices
Vrdoljak et al. Designing web warehouses from XML schemas
Snow et al. The need for maps of transmission intensity to guide malaria control in Africa.
US7069502B2 (en) Structured document management system and structured document management method
US7444321B2 (en) Transforming query results into hierarchical information
US6466940B1 (en) Building a database of CCG values of web pages from extracted attributes
US7953755B2 (en) Semantic relational database
Schöning et al. Tamino—an internet database system
US20090187587A1 (en) Managing feature data based on spatial collections
WO2002005116A3 (en) Automatic database replication server and methods
CN101292242A (en) Managing relationships between resources stored within a repository
WO2003054694A3 (en) Method and system for attribute management in a namespace
WO2002021339A3 (en) Method and apparatus for xml data storage, query rewrites, visualization, mapping and references
US7496556B2 (en) UPIKM database system with integrated XML interface
Michard et al. The Aquarelle resource discovery system
US20070150458A1 (en) System for extending data query using ontology, and method therefor
KR100456621B1 (en) Apparatus and method for processing association-filter query language by using database registry reference
EP1965313A1 (en) Data processing
EP1016990A2 (en) Complex digital content managing method and complex digital content system
KR19990046910A (en) Spatial Database Management Apparatus and Method Using Spatial Index of Al * -TIAL on Internet
Döller et al. Towards an mpeg-7 query language

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