Unlock instant, AI-driven research and patent intelligence for your innovation.

Intelligent card database multi-list operation method and device

An operation method and database technology, applied in the field of smart card database, can solve the problems of memory space congestion, performance degradation of smart card database, increase processing time of smart card, etc., to achieve the effect of improving performance and quality

Inactive Publication Date: 2012-02-29
BEIJING WATCH DATA SYST
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the process of realizing the multi-table operation of the above-mentioned smart card database, the inventor found that there are at least the following problems in the prior art: due to the limited cache space of the smart card, if the first method is adopted, a lot of redundant data will be added to the synthesized database table , so that the performance of the smart card database drops sharply, affecting the operational efficiency of the database
If the second method is used, a lot of redundant data will be added in the communication, which increases the communication processing time of the smart card, and a large amount of redundant data needs to be stored in the limited memory of the smart card, which will make the database performance of the smart card drop sharply and affect the smart card. Database Operational Efficiency
There is a lot of redundancy in the data obtained by the above two methods, resulting in a large amount of redundant data stored in the limited smart card memory, making the original limited memory space more congested, resulting in a sharp decline in the performance of the smart card database, affecting the operation of the smart card database efficiency

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
  • Intelligent card database multi-list operation method and device
  • Intelligent card database multi-list operation method and device
  • Intelligent card database multi-list operation method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0031] Embodiments of the present invention provide a query method for a smart card database, such as figure 1 As shown, the method includes:

[0032] 101. Select a database table as a first database table from at least two database tables that need to be connected.

[0033] Among them, the connection operation mode between smart card database tables generally includes the following three types, left join operation, right join operation and inner join operation; wherein, from at least two database tables that need to be connected, select a database table as the first A database table may include: firstly judge the connection operation mode of the smart card database table according to the connection type value in the interface function; secondly, according to the connection operation mode of the smart card database table, from at least two database tables that need to be connected A database table is selected as the first database table, which is not limited in this embodimen...

Embodiment 2

[0041] The embodiment of the present invention provides a smart card database multi-table operation method. The connection operation between the smart card database tables generally includes the following three types: left join operation, right join operation and inner join operation. The embodiment of the present invention specifically uses the left join operation mode Describe the operation method of the two tables of the smart card database in detail, as figure 2 As shown, the method includes:

[0042] For the convenience of description in this embodiment, in the embodiment of the present invention, the two database tables that need to be connected to the smart card database are called the left table and the right table, and the pre-allocated buffers corresponding to the left table and the right table are respectively called the left table Cache and right table cache.

[0043] 201. From the two database tables that need to be connected, select one database table as the fi...

Embodiment 3

[0069] An embodiment of the present invention provides a query device for a smart card database, such as image 3 As shown, the device includes: a selection unit 301 , a first acquisition unit 302 , a first storage unit 303 , a composition unit 304 , a second acquisition unit 305 , a second storage unit 306 , a connection combination unit 307 and a third storage unit 308 .

[0070] The selection unit 301 is used to select a database table as the first database table from at least two database tables that need to be connected; wherein, the connection operation modes between the smart card database tables generally include the following three types, including: left connection operation, right join operation, and inner join operation; wherein, selecting a database table as the first database table from at least two database tables that need to perform join operations may include: first judging the described The connection operation mode of the smart card database table; secondly,...

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 embodiment of the invention discloses an intelligent card database multi-list operation method and an intelligent card database multi-list operation device, which relate to the field of intelligent card databases and improves the performance and operation efficiency of an intelligent card database. The method comprises: selecting one of at least two database lists needing connection operationas a first database list; storing a first record meeting a first query condition corresponding to the first database list in a pre-assigned first buffer; acquiring a data domain value corresponding to the data domain name of the connection query condition from the record, replacing the corresponding data domain name in the connection query condition with the data domain value to form a second query condition, and storing a second record meeting the second query condition in a pre-assigned second buffer; and connecting and combining the first record and the second record, and storing the combined first and second records in a pre-assigned connection output buffer. The method and the device are mainly used the multi-list connection query of the intelligent card database.

Description

technical field [0001] The invention relates to the field of smart card databases, in particular to a multi-table operation method and device for smart card databases. Background technique [0002] Because the smart card database only provides single-table operation, it can only be designed according to a single database table when designing the smart card database application. When it is necessary to connect and apply multiple data tables in the database, there are currently two methods for operating the smart card database: the first method is to first combine multiple data tables that need to be connected to the application into one table, that is, combine multiple data tables Put all the information in one table, and then operate on the composite table that contains all the information; the second is to complete the operation of the relevant database table through the application, that is, to fetch all the data in the table that needs to be connected to the application i...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 刘庆海
Owner BEIJING WATCH DATA SYST