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

Method for querying database and smart card

A query method and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., to achieve the effect of improving operation efficiency and multi-connection success rate, optimizing multi-connection query, and reducing memory requirements

Active Publication Date: 2013-01-16
BEIJING WATCH DATA SYST
View PDF12 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

It can be seen that the higher the number of records, the more obvious the I / O consumption of this technology

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 for querying database and smart card
  • Method for querying database and smart card
  • Method for querying database and smart card

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] serial number Name department gender 0001 Zhang San to develop male 0021 Li Si administrative female 0136 Wang Wu personnel male ...... ...... ...... ...... 0301 nine market male

[0028] Table 2 Employee salary table

[0029] serial number salary Entry year 0001 6000 2010 0021 5000 2009 0136 4500 2011 ...... ...... ...... 0301 9000 2006

[0030] The existing smart card realizes the query through the connection operation of each table as follows: read in a single record of each table according to the order of the incoming tables; delete the redundant field of the record every time a record is read. Table 3 is given below, and the method of querying the three tables through the connection operation is explained in the case of a connection condition.

[0031] Form 3 Employee Information Form

[0032] serial number age an...

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 querying a database and a smart card. The method comprises the following steps of: determining a length value of a redundant field of each table in N tables to be connected, wherein N is more than or equal to 2; determining a connecting sequence of the N tables to be connected according to the length value of the redundant field of each table, wherein the table of which the length value of the redundant field is greater is subjected to connecting operation earlier; and performing connecting operation on the N tables to be connected according to the connecting sequence, and outputting a query result. By the invention, requirements of multi-table connecting operation on internal memory are greatly reduced, so that the operating efficiency and multi-connection success rate of the smart card are improved.

Description

technical field [0001] The invention relates to the technical field of smart card databases, in particular to a database query method and a smart card. Background technique [0002] With the increasing development of informatization, it has become a trend to store important information in portable hardware. Among them, the large-capacity memory card applies database technology to the smart card operating system, providing a brand-new realization platform for better and richer mobile data services. [0003] Joining is the main feature of the relational database model, and the query of multiple tables in the database can be realized through the join operation. This is a sign that this type of database management system is different from other types of database management systems. In the relational database management system, the relationship between the data does not need to be determined when the table is created, and all the information of an entity is often stored in a t...

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