Method and device for dynamically selecting database

A database and dynamic technology, applied in the field of database selection, can solve problems such as inaccuracy, and achieve the effect of reducing pressure, reducing impact, and improving efficiency

Inactive Publication Date: 2010-04-21
YONYOU NETWORK TECH
View PDF0 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, based on this assumption, the

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
  • Method and device for dynamically selecting database
  • Method and device for dynamically selecting database
  • Method and device for dynamically selecting database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] The method and device for dynamically selecting a database according to the present invention will be described in detail below with reference to the accompanying drawings.

[0027] like figure 1 As shown, the method for dynamically selecting a database according to the present invention includes:

[0028] Step 102, configuring judgment conditions for each document;

[0029] Step 104, according to the query condition input by the user for the receipt, judge whether the query condition satisfies the judgment condition corresponding to the receipt; and

[0030] Step 106, select the database to be queried according to the judgment result.

[0031] Wherein, the step of configuring judgment conditions includes: selecting one or more indicators from the query conditions provided by each document; setting default values ​​for the one or more indicators; and configuring the one or more indicators as A logical expression is used as the judgment condition.

[0032] Wherein, t...

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

The invention discloses a method for dynamically selecting a database, which comprises the following steps: configuring a judgment condition for each document; judging whether a query condition satisfies the judgment condition corresponding to the document according to the query condition input by a user aiming at the document; and selecting a queried database according to a judgment result. The invention also provides a device for dynamically selecting the database. By analyzing the query condition, and determining the database to be queried according to the analysis result and the judgment condition, the method and the device not only improves the query efficiency, but also reduces the influence on a service system caused by the query operation, thereby greatly lightening the pressure of a service database.

Description

technical field [0001] The present invention relates to a method and a device for selecting a database, and more particularly to a method and a device for dynamically selecting a database that can be configured according to a user's query. Background technique [0002] The current information system no longer has only one database, but can have multiple databases. One of them is a business database, serving OLTP (On-LineTransaction Processing), which is mainly used for daily business operations of the system, such as: making vouchers, making orders, etc.; other part of the database is a query backed up by the business database The database is an OLAP (On-Line Analytical Processing) service and is mainly used for querying data. When a user makes a query, he can decide which database to go to for the query operation according to the user's query conditions. In this way, the impact of the query operation on the business system can be greatly reduced, and the load of each data...

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
IPC IPC(8): G06F17/30
Inventor 刘晨伟
Owner YONYOU NETWORK TECH
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