Computer method and system combining OLTP database and OLAP database environments

A computer system and database technology, applied in the direction of database management system, multiple digital computer combinations, database distribution/replication, etc., can solve the problems of different semantic levels of data

Active Publication Date: 2012-07-18
DASSAULT SYST ENOVIA
View PDF4 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The first is that the semantic level of data in OLAP and OLTP database servers may differ

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Computer method and system combining OLTP database and OLAP database environments
  • Computer method and system combining OLTP database and OLAP database environments
  • Computer method and system combining OLTP database and OLAP database environments

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] The following is a description of exemplary embodiments of the present invention.

[0026] The teachings of all patents, published applications and references cited herein are incorporated by reference in their entirety.

[0027] figure 1 Shown is a computer database system, apparatus and method 108 embodying the present invention.

[0028] System 100 includes OLTP database system 30 and OLAP database system 40 . The OLAP database system 40 is generally configured as in the prior art and can be accessed by an OLAP client 50b. In addition, the OLTP database system 30 and the application server 60 access and synchronize data with the OLAP database 40, as will be seen more clearly below.

[0029] Application server 60 supports OLTP client 50a. The application server 60 is formed by the database adapter extractor 13 , the OLTP adapter 15 and the OLAP adapter 17 . Using techniques common in the art, the database adapter 13 operates to extract information from the OLTP d...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

A computer system provides access to both an online transaction processing (OLTP) database server and an online analytics processing (OLAP) database server. The computer system includes a client application adapted to receive a query. According to (a) mode of operation (e.g., read or update) of the client application and (b) synchronization status of the OLAP database server, the client application redirects the query to the OLTP database server or to the OLAP database server. The client application redirects the query to the OLTP database server when the mode of operation is other than a read-only operation or the synchronization status is "unsynchronized". The client application redirects the query to the OLAP database server when the mode of operation is a read-only operation and the synchronization status is "synchronized". The computer system further includes an OLTP application server (e.g., Enovia V6) comprising an OLTP adapter and an OLAP adapter. The OLAP adapter is formed of a mapping component adapted to map data between OLTP semantics and OLAP semantics.

Description

Background technique [0001] Enterprise customers typically maintain two types of database environments. First, relational databases are used in an online transaction processing (OLTP) environment to support transaction-oriented applications, like those developed by Dassault Systemes under the CATIA, ENOVIA, DELMIA, etc. trademarks. Second, generate export copies of OLTP data for online analytical processing (OLAP) for value-added applications such as business intelligence, reporting, and decision support. Historically, OLAP environments have also used relational database technology, but this is changing as OLAP-tuned storage systems become widely available. Dassault Systemes brand is an example of a modern OLAP warehouse. [0002] Currently, OLTP and OLAP environments are completely disjointed, and various applications are designed to support one environment or the other. The separation of these multi-database environments enables sub-optimal use of computing resources, d...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F17/30575G06F17/30557G06F16/25G06F16/27G06F15/16
Inventor D·E·图克斯巴里
Owner DASSAULT SYST ENOVIA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap