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

Method and system for manipulating data from multiple sources

Info

Publication number
WO2000057311A3
WO2000057311A3 PCT/US2000/007782 US0007782W WO2000057311A3 WO 2000057311 A3 WO2000057311 A3 WO 2000057311A3 US 0007782 W US0007782 W US 0007782W WO 2000057311 A3 WO2000057311 A3 WO 2000057311A3
Authority
WO
Grant status
Application
Patent type
Prior art keywords
data
plurality
invention
object
information
Prior art date
Application number
PCT/US2000/007782
Other languages
French (fr)
Other versions
WO2000057311A2 (en )
Inventor
Sam Eubanks
Asad Shamim
Original Assignee
Sam Eubanks
Quansoo Group Inc
Asad Shamim
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

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/30Information retrieval; Database structures therefor ; File system structures therefor
    • G06F17/30286Information retrieval; Database structures therefor ; File system structures therefor in structured data stores
    • G06F17/30557Details of integrating or interfacing systems involving at least one database management system
    • G06F17/30569Details of 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 WO2000057311A3 (en)

Priority Applications (2)

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

Publications (2)

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

Family

ID=22422077

Family Applications (1)

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

Country Status (1)

Country Link
WO (1) WO2000057311A3 (en)

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 Inter-information processing system cooperation device, integrated information processing system and recording medium recording inter-information processing system cooperation program
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
US6363353B1 (en) * 1999-01-15 2002-03-26 Metaedge Corporation System 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
WO2007087134A3 (en) 2006-01-20 2008-06-05 Bookham Technology Plc Optical beam steering and sampling apparatus and method
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

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 Type
WO2000057311A2 (en) 2000-09-28 application

Similar Documents

Publication Publication Date Title
Lee et al. XClust: clustering XML schemas for effective integration
Weibel The Dublin Core: a simple content description model for electronic resources
Seligman et al. XML's impact an databases and data sharing
Banerjee et al. Oracle8i-the XML enabled data management system
US7185049B1 (en) Multimedia integration description scheme, method and system for MPEG-7
Jones et al. Managing scientific metadata
US7000183B1 (en) Method and apparatus for viewer-specific presentation of information
US6513039B1 (en) Profile inferencing through automated access control list analysis heuristics
Heery Review of metadata formats
US6910040B2 (en) System and method for XML based content management
US6189012B1 (en) Apparatus and method for storing, navigating among and adding links between data items
US20040187111A1 (en) Content management portal and method for communicating media content
Staab et al. An annotation framework for the semantic web
US20060136435A1 (en) System and method for context-sensitive decomposition of XML documents based on schemas with reusable element/attribute declarations
US6983282B2 (en) Computer method and apparatus for collecting people and organization information from Web sites
US7213017B2 (en) Systems and methods for transforming query results into hierarchical information
US20080126397A1 (en) RDF Object Type and Reification in the Database
US20100057777A1 (en) Systems and methods for generating multi-population statistical measures using middleware
US20020143742A1 (en) Apparatus, method, and program for retrieving structured documents
US20070271290A1 (en) Method and apparatus for accessing data within an electronic system by an extrernal system
US6185573B1 (en) Method and system for the integrated storage and dynamic selective retrieval of text, audio and video data
EP1087306A2 (en) Meta-documents and method of managing them
US6754648B1 (en) Method for storing and managing data
US20040267693A1 (en) Method and system for evaluating the suitability of metadata
US7885918B2 (en) Creating a taxonomy from business-oriented metadata content

Legal Events

Date Code Title Description
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

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

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)
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

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

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 in:

Ref country code: JP