CN101840430A - Intelligent card database multi-list operation method and device - Google Patents

Intelligent card database multi-list operation method and device Download PDF

Info

Publication number
CN101840430A
CN101840430A CN 201010163363 CN201010163363A CN101840430A CN 101840430 A CN101840430 A CN 101840430A CN 201010163363 CN201010163363 CN 201010163363 CN 201010163363 A CN201010163363 A CN 201010163363A CN 101840430 A CN101840430 A CN 101840430A
Authority
CN
China
Prior art keywords
record
buffer memory
size
querying condition
database table
Prior art date
Legal status (The legal status 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 status listed.)
Granted
Application number
CN 201010163363
Other languages
Chinese (zh)
Other versions
CN101840430B (en
Inventor
刘庆海
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing WatchData System Co Ltd
Original Assignee
Beijing WatchData System Co Ltd
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
Application filed by Beijing WatchData System Co Ltd filed Critical Beijing WatchData System Co Ltd
Priority to CN2010101633639A priority Critical patent/CN101840430B/en
Publication of CN101840430A publication Critical patent/CN101840430A/en
Application granted granted Critical
Publication of CN101840430B publication Critical patent/CN101840430B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

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 operation as 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

Intelligent card database multi-list operation method and device
Technical field
The present invention relates to the intelligent card database field, relate in particular to a kind of intelligent card database multi-list operation method and device.
Background technology
Because intelligent card database only provides single table handling, therefore when using, the design intelligent card database can only design by individual data storehouse table.In the time need connecting application to a plurality of tables of data in the database, operation to intelligent card database at present has two kinds of methods: first kind, at first will need to connect synthetic table of a plurality of tables of data of application, promptly all information in a plurality of tables of data are placed in the table, then this synthetic table that comprises all information are operated; Second kind, by being used for finishing the operation of Relational database table, promptly the data that needs are connected in the table of using are all got in the application, finish the relevant connection operation in application.
State in realization in the process of intelligent card database multi-list operation, the inventor finds that there are the following problems at least in the prior art: because the spatial cache of smart card is limited, if adopt first method, can increase many redundant datas in the database table after synthetic, the intelligent card database performance is sharply descended, influenced the operating efficiency of database.If adopt second method, can in communication, increase many redundant datas, increased the smart card communication processing time, and a large amount of redundant datas need be stored in the limited internal memory of smart card, the database performance of smart card is sharply descended, influenced the operating efficiency of intelligent card database.All there is a large amount of redundancies in the data that above-mentioned two kinds of methods are obtained, cause mass of redundancy data to be stored in the limited smart card memory, make that limited memory space is more congested originally, cause the database performance of smart card sharply to descend, influenced the operating efficiency of intelligent card database.
Summary of the invention
Embodiments of the invention provide a kind of intelligent card database multi-list operation method and device, have improved the performance of intelligent card database and the operating efficiency of intelligent card database.
For achieving the above object, embodiments of the invention adopt following technical scheme:
A kind of intelligent card database multi-list operation method comprises:
Carry out at least two database tables of attended operation from needs, choose a database table as first database table;
Obtain first record that satisfies first querying condition, and according to described first recording storage of the big young pathbreaker of first buffer memory in described first buffer memory, described first querying condition is and the corresponding querying condition of described first database table that the size of described first buffer memory is at least the storage size of a record in described first database table;
From described first record, obtain the corresponding data thresholding of data domain name in the connection querying condition of described first database table and other database tables, replace the data domain name of correspondence in the described connection querying condition to form second querying condition with described data thresholding;
Obtain second record that satisfies described second querying condition, and according to described second recording storage of the big young pathbreaker of second buffer memory in described second buffer memory, the size of described second buffer memory is at least the storage size of a record in described second database table;
Described first record is connected combination with described second record obtains connecting the combination record, and with described connection combination recording storage in preallocated connection output buffers, the size of described connection output buffers is at least described first database table and is connected a back storage size that connects combination record record with second database table.
A kind of intelligent card database multi-list operating means comprises:
Choose the unit, be used for carrying out at least two database tables of attended operation, choose a database table as first database table from needs;
First acquiring unit is used to obtain first record that satisfies first querying condition, and described first querying condition is and the corresponding querying condition of described first database table;
First storage unit, described first recording storage that is used for obtaining according to described first acquiring unit of the big young pathbreaker of first buffer memory is at described first buffer memory, and the size of described first buffer memory is at least the storage size of a record in described first database table;
Component units, be used for obtaining the corresponding data thresholding of data domain name the connection querying condition of described first database table and other database tables, replace the data domain name of correspondence in the described connection querying condition to form second querying condition with described data thresholding from described first record;
Second acquisition unit is used to obtain second record that satisfies described second querying condition;
Second storage unit is used for described second recording storage that the described second acquisition unit of big young pathbreaker according to second buffer memory obtains at described second buffer memory, and the size of described second buffer memory is at least the storage size of a record in described second database table;
Connect assembled unit, be used for that described first record is connected combination with described second record and obtain connecting the combination record;
The 3rd storage unit, the connection combination recording storage that is used for described connection assembled unit is generated is at preallocated connection output buffers, and the size of described connection output buffers is at least described first database table and is connected a back storage size that connects combination record record with second database table.
After adopting technical solution of the present invention, in the time need carrying out the correlation inquiry operation to a plurality of database tables in the intelligent card database, in smart card, can store first buffer memory and second buffer memory of next bar record at least for the database table setting that need carry out correlation inquiry, and according to the connection output buffers of the recording setting correspondence after connecting; When carrying out the multi-table query operation, the size storage according to buffer memory of the record that satisfies querying condition is stored in first buffer memory and second buffer memory of setting in batches, and after the record that satisfies condition is carried out attended operation, with the recording storage after connecting in connecting output buffers, to realize the multilist correlation inquiry of intelligent card data table, that is, use the multiplexing mode of buffer memory to make full use of limited smart card memory space, thereby improved the performance and the quality of intelligent card database.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art, to do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art below, apparently, accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is an intelligent card database multi-list method of operating process flow diagram in the embodiment of the invention 1;
Fig. 2 is an intelligent card database multi-list method of operating process flow diagram in the embodiment of the invention 2;
Fig. 3 is the composition frame chart of a kind of intelligent card database multi-list operating means in the embodiment of the invention 3;
Fig. 4 is the composition frame chart of another kind of intelligent card database multi-list operating means in the embodiment of the invention 3;
Fig. 5 is the composition frame chart of another kind of intelligent card database multi-list operating means in the embodiment of the invention 3;
Fig. 6 is the composition frame chart of another kind of intelligent card database multi-list operating means in the embodiment of the invention 3.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the invention, the technical scheme in the embodiment of the invention is clearly and completely described, obviously, described embodiment only is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills belong to the scope of protection of the invention not making the every other embodiment that is obtained under the creative work prerequisite.
Embodiment 1
The embodiment of the invention provides a kind of querying method of intelligent card database, and as shown in Figure 1, this method comprises:
101, carry out at least two database tables of attended operation from needs, choose a database table as first database table.
Wherein, the attended operation mode between the intelligent card database table generally comprises following three kinds, left attended operation, right attended operation and interior attended operation; Wherein, carry out at least two database tables of attended operation, choose a database table and can comprise: the attended operation mode of at first judging described intelligent card database table according to the connection type value in the interface function as first database table from needs; Secondly according to the attended operation mode of described intelligent card database table, from carrying out at least two database tables of attended operation, needs choose a database table as first database table, and the embodiment of the invention does not limit this.For example, when the attended operation mode of described intelligent card database table was left attended operation, the database table of choosing the logical relation symbol left side in the condition of contact expression formula according to the condition of contact expression formula was first database table; When the attended operation mode of described intelligent card database table was right attended operation, the database table of choosing logical relation symbol the right in the condition of contact expression formula according to the condition of contact expression formula was first database table; When the attended operation mode of described intelligent card database table was interior attended operation, arbitrary database table of choosing in described at least two database tables that need to connect was first database table.Wherein, when three tables in needing database or multilist attended operation, earlier first is connected according to above-mentioned two table connected modes with second table, the result after connecting with two tables then is connected with the 3rd table, by that analogy, till all tables have all connected.
102, obtain first record that satisfies first querying condition, and according to described first recording storage of the big young pathbreaker of first buffer memory in described first buffer memory, described first querying condition is and the corresponding querying condition of described first database table that the size of described first buffer memory is at least the storage size of a record in described first database table.
Wherein, described first querying condition corresponding with first database table can comprise the querying condition of specifying a plurality of fields of output at described first database table, for convenience, will can comprise at described first database table and specify the querying condition of a plurality of fields of exporting to be referred to as first querying condition in the embodiment of the invention.
103, from described first record, obtain the corresponding data thresholding of data domain name in the connection querying condition of described first database table and other database tables, replace the data domain name of correspondence in the described connection querying condition to form second querying condition with described data thresholding.
104, obtain second record that satisfies described second querying condition, and according to described second recording storage of the big young pathbreaker of second buffer memory in described second buffer memory, the size of described second buffer memory is at least the storage size of a record in described second database table.
105, described first record is connected combination with described second record and obtains connecting the combination record, and with described connection combination recording storage in preallocated connection output buffers, the size of described connection output buffers is at least described first database table and is connected a back storage size that connects combination record record with second database table.
In the embodiment of the invention, in the time need carrying out the correlation inquiry operation to a plurality of database tables in the intelligent card database, in smart card, can store first buffer memory and second buffer memory of next bar record at least for the database table setting that need carry out correlation inquiry, and according to the connection output buffers of the recording setting correspondence after connecting; When carrying out the multi-table query operation, the size storage according to buffer memory of the record that satisfies querying condition is stored in first buffer memory and second buffer memory of setting in batches, and after the record that satisfies condition is carried out attended operation, with the recording storage after connecting in connecting output buffers, to realize the multilist correlation inquiry of intelligent card data table, that is, use the multiplexing mode of buffer memory to make full use of limited smart card memory space, thereby improved the performance and the quality of intelligent card database.
Embodiment 2
The embodiment of the invention provides a kind of intelligent card database multi-list operation method, attended operation between the intelligent card database table generally comprises following three kinds, left side attended operation, right attended operation and interior attended operation, the embodiment of the invention specifically is specifically addressed described intelligent card database two table handling methods in left attended operation mode, as shown in Figure 2, this method comprises:
Be the convenience of describing in the present embodiment, two database tables that the embodiment of the invention need connect intelligent card database are called left-handed watch and right table, and described left-handed watch of correspondence and the preallocated buffer memory of right table are called left-handed watch buffer memory and right table cache.
201, carry out choosing a database table as first database table two database tables of attended operation from needs, i.e. the left-handed watch of database and right table; The embodiment of the invention with left-handed watch as first database table.
Further, the embodiment of the invention has also pre-seted storage and has satisfied described left-handed watch and right left-handed watch buffer memory (first buffer memory), the right table cache (second buffer memory) of showing the querying condition record, and the connection output buffers of storage linkage record.When distributing above-mentioned three buffer memorys, generally connect output buffers according to distributing earlier, the order of reallocation left-handed watch buffer memory and right table cache specifically comprises:
Connect the size that size that the back gained connects the size of combination record and smart card free memory is determined described connection output buffers according to the described database table that obtains; The size of described smart card free memory is deducted the size of the size of connection output buffers as new smart card free memory; According to the size of the size of described first database table that obtains and a record of second database table and described new smart card free memory, determine first buffer memory corresponding and the size of second buffer memory respectively with described first tables of data and second database table.Wherein, the size of described buffer memory can be determined with the record strip number, but the embodiment of the invention does not limit this.
202, obtain first record that satisfies first querying condition, in preallocated left-handed watch buffer memory, described first querying condition is and the corresponding querying condition of left-handed watch according to described first recording storage of the big young pathbreaker of left-handed watch buffer memory.
Wherein, described first querying condition corresponding with first database table can comprise the querying condition of specifying a plurality of fields of output at described first database table, for convenience, will can comprise at described first database table and specify the querying condition of a plurality of fields of exporting to be referred to as first querying condition in the embodiment of the invention.
Wherein, because the memory headroom of smart card is limited, therefore the left-handed watch spatial cache size that is described left-handed watch distribution is also limited, may exist described preallocated left-handed watch buffer memory can not hold all records that satisfy first querying condition, therefore, obtaining first record that satisfies first querying condition according to described first querying condition, and with described first recording storage in the process of described left-handed watch buffer memory, the described recording storage that will satisfy described first querying condition is in preallocated left-handed watch buffer memory the time, need to judge whether the described record size that satisfies described first querying condition surpasses the size of described preallocated left-handed watch buffer memory, if surpass the size of described left-handed watch buffer memory, then need to be stored in the described left-handed watch buffer memory in batches, specifically comprise according to the described record that satisfies first querying condition of the big young pathbreaker of described left-handed watch buffer memory:
Whether the size of judging described record is greater than the size of described left-handed watch buffer memory; If described first record size is less than or equal to the size of described left-handed watch buffer memory, then described first record once all is stored in the described left-handed watch buffer memory; If the size of described first record is greater than the size of described left-handed watch buffer memory, then according to the size of described left-handed watch buffer memory in batches with described first recording storage in described left-handed watch buffer memory.Wherein, described size according to described left-handed watch buffer memory in batches with described first recording storage in described left-handed watch buffer memory, can comprise: from described first record, choose be less than or equal to described left-handed watch spatial cache size recording storage in described left-handed watch buffer memory, and also have first record satisfy described first querying condition in described first database table of mark; After the record in the described left-handed watch buffer memory and the record that satisfies second querying condition are connected combination finish,, obtain remaining first record of satisfied first querying condition according to described mark Query Database; According to the size of left-handed watch buffer memory in batches with described remaining first recording storage in described left-handed watch buffer memory.
203, judge whether there is the record that does not have processing in the described left-handed watch buffer memory, if there is not the record that does not have processing in the described left-handed watch buffer memory, then execution in step 204; If there is the record that does not have processing in the described left-handed watch buffer memory, then execution in step 205.
204, judge whether also there is the record that satisfies first querying condition in the described left-handed watch; If also there is the record that satisfies first querying condition in the described left-handed watch, then execution in step 202; If do not have the record that satisfies first querying condition in the described left-handed watch, then finish this connection query manipulation.
205, from described left-handed watch buffer memory, take out a record, and from described record, obtain with connect querying condition in the corresponding data thresholding of data domain name, replace the data domain name of correspondence in the described connection querying condition to form second querying condition with described data thresholding.
206, according to described second querying condition right side table that needs are connected with described left-handed watch is inquired about, will be satisfied the recording storage of described second querying condition in preallocated right table cache.
Wherein, because the memory headroom of smart card is limited, therefore the right table cache space size that is described right table distribution is also limited, may exist described preallocated right table cache can not hold all records that satisfy second querying condition, therefore obtaining second record that satisfies described second querying condition according to described second querying condition, and described second recording storage that will satisfy described second querying condition is in preallocated right table cache the time, need to judge that described second size that writes down is whether greater than the size of described preallocated right table cache, if size greater than described right table cache, then need to be stored in the described right table cache in batches, specifically comprise according to the described record that satisfies second querying condition of the big young pathbreaker of described right table cache:
Whether the size of judging described second record is greater than the size of described right table cache; If described second record size is less than or equal to the size of described right table cache, then described second record all once is stored in the described right table cache; If described second record size is greater than the size of described right table cache, then according to the size of described right table cache in batches with described second recording storage in described right table cache.Wherein, described size according to described right table cache comprises described second recording storage in batches in described right table cache: from described second record, choose be less than or equal to described right table cache space size recording storage in described right table cache, and also have the record satisfy described second querying condition in described second database table of mark; After the first record connection that the record in the described right table cache is corresponding with described connection querying condition has been made up,, obtain remaining second record that satisfies second querying condition according to described mark Query Database; According to the size of right table cache in batches with described remaining second recording storage in described right table cache.
207, judge whether there is the record that does not have processing in the described right table cache, if there is not the record that does not have processing in the described right table cache, then execution in step 208; If there is the record that does not have processing in the described right table cache, then execution in step 209.
208, judge whether also there is the record that satisfies second querying condition in the described right table; If also have the record that satisfies second querying condition in the described right table, then execution in step 206; If do not have the record that satisfies second querying condition in the described right table, then execution in step 205.
209, from described right table cache, take out a record, and the record that will take out from described right table cache is connected with a record that takes out from described left-handed watch, recording storage after connecting in described connection output buffers, and is added 1 with the record number in the described connection output buffers.
Wherein, for keeping connecting the consistance of back record length, if do not have the record that satisfies described second querying condition in the described right table cache, can fill up a record that satisfies described second querying condition with null value, and with described fill up after the null value record with from the left-handed watch buffer memory, take out the record that satisfies described first querying condition successively and be connected combination, and be stored in the preallocated connection output buffers, and the record number in the described connection output buffers is added 1.
210, judge whether the record number in the described output buffers equals the record number that described output buffers can be stored, if the record number that the record number in the described output buffers can be stored less than described output buffers, then execution in step 209; If the record number in the described output buffers equals the record number that described output buffers can be stored, then execution in step 211.
211, write down the linkage record number that finds in the described output buffers, and the linkage record in the described output buffers is exported.
Further, in the process of execution in step 206, also comprise: according to showing the 3rd corresponding inquiry condition with the described right side, described second database table is inquired about, to satisfy the recording storage of described second querying condition and the 3rd inquiry condition in preallocated right table cache, so that make the record that satisfies described connection querying condition that finds more accurate.Wherein, the described three inquiry condition corresponding with second database table can comprise the querying condition of specifying a plurality of fields of output at described second database table, in the embodiment of the invention for convenience, to can comprise at described second database table and specify the querying condition of a plurality of fields of exporting to be referred to as the 3rd inquiry condition, but be not restricted to this.
Further, after finishing described connection query manipulation according to described connection querying condition, the embodiment of the invention also comprises: with preallocated left-handed watch buffer memory and right table cache, and connect output buffers release, so that described smart card uses described releasing memory to carry out other operation.
The left attended operation that is primarily aimed at two tables in the embodiment of the invention is that example has been carried out concrete elaboration, when implementing the embodiment of the invention according to the right attended operation of two tables, comprise with the difference that adopts the left attended operation of two tables: with described right showing as first database table, and at first according to the querying condition corresponding with described right table described right table is inquired about, the execution of other steps is with reference to the concrete operations of using two table left sides to connect; When the mode of operation that connects in showing according to two is implemented the embodiment of the invention, be different from that two table left sides connect and the right operation that is connected of two tables comprises: any database table during described left-handed watch or the right side are shown is as first database table, and in the process that the described database table that needs attended operation is inquired about, in the process of described first database table being inquired about according to first querying condition corresponding with described first database table, if do not have the record that satisfies described first querying condition in described first database table, then the connection query manipulation of end data table; If there is the record that satisfies described first querying condition in described first database table, but there is not the record that satisfies second querying condition in second database table, then no longer carry out the connection and the output of query note, connect query manipulation and directly stop database table.
In the embodiment of the invention, in the time need carrying out the correlation inquiry operation to a plurality of database tables in the intelligent card database, in smart card, can store first buffer memory and second buffer memory of next bar record at least for the database table setting that need carry out correlation inquiry, and according to the connection output buffers of the recording setting correspondence after connecting; When carrying out the multi-table query operation, the size storage according to buffer memory of the record that satisfies querying condition is stored in first buffer memory and second buffer memory of setting in batches, and after the record that satisfies condition is carried out attended operation, with the recording storage after connecting in connecting output buffers, to realize the multilist correlation inquiry of intelligent card data table, that is, use the multiplexing mode of buffer memory to make full use of limited smart card memory space, thereby improved the performance and the quality of intelligent card database.
And by finish attended operation in smart card, the result after only output connects has improved database manipulation efficient in the embodiment of the invention.By the multilist attended operation, can expand to the multilist design to single table, improved the design flexibility of intelligent card database table.
In addition, after executing described connection query manipulation, preallocated buffer memory is discharged,, thereby improved the utilization factor of smart card memory so that described smart card uses described releasing memory to carry out other operation according to described connection querying condition.
Embodiment 3
The embodiment of the invention provides a kind of inquiry unit of intelligent card database, as shown in Figure 3, this device comprises: choose unit 301, first acquiring unit 302, first storage unit 303, component units 304, second acquisition unit 305, second storage unit 306, connect assembled unit 307 and the 3rd storage unit 308.
Choose unit 301, be used for carrying out at least two database tables of attended operation, choose a database table as first database table from needs; Wherein, the attended operation mode between the intelligent card database table generally comprises following three kinds, comprising: left attended operation, right attended operation and interior attended operation; Wherein, carry out at least two database tables of attended operation, choose a database table and can comprise: the attended operation mode of at first judging described intelligent card database table according to the connection type value in the interface function as first database table from needs; Secondly according to the attended operation mode of described intelligent card database table, from carrying out at least two database tables of attended operation, needs choose a database table as first database table, and the embodiment of the invention does not limit this.For example, when the attended operation mode of described intelligent card database table was left attended operation, the database table of choosing the logical relation symbol left side in the condition of contact expression formula according to the condition of contact expression formula was first database table; When the attended operation mode of described intelligent card database table was right attended operation, the database table of choosing logical relation symbol the right in the condition of contact expression formula according to the condition of contact expression formula was first database table; When the attended operation mode of described intelligent card database table was interior attended operation, arbitrary database table of choosing in described at least two database tables that need to connect was first database table.Wherein, when three tables in needing database or multilist attended operation, earlier first is connected according to above-mentioned two table connected modes with second table, the result after connecting with two tables then is connected with the 3rd table, by that analogy, till all tables have all connected.
First acquiring unit 302, be used to obtain first record that satisfies first querying condition, and according to described first recording storage of the big young pathbreaker of first buffer memory in described first buffer memory, described first querying condition is and the corresponding querying condition of described first database table that the size of described first buffer memory is at least the storage size of a record in described first database table.Wherein, described first querying condition corresponding with first database table can comprise the querying condition of specifying a plurality of fields of output at described first database table, for convenience, will can comprise at described first database table and specify the querying condition of a plurality of fields of exporting to be referred to as first querying condition in the embodiment of the invention.
First storage unit 303, described first recording storage that is used for obtaining according to described first acquiring unit 303 of the big young pathbreaker of first buffer memory is at described first buffer memory, and the size of described first buffer memory is at least the storage size of a record in described first database table.
Component units 304, be used for obtaining the corresponding data thresholding of data domain name the connection querying condition of described first database table and other database tables, replace the data domain name of correspondence in the described connection querying condition to form second querying condition with described data thresholding from described first record.
Second acquisition unit 305 is used to obtain second record that satisfies described second querying condition; Second storage unit 306, described second recording storage that is used for obtaining according to the described second acquisition unit 305 of the big young pathbreaker of second buffer memory is at described second buffer memory, and the size of described second buffer memory is at least the storage size of a record in described second database table.
Connect assembled unit 307, be used for that described first record is connected combination with described second record and obtain connecting the combination record; The 3rd storage unit 308, the connection combination recording storage that is used for described connection assembled unit 307 is generated is at preallocated connection output buffers, and the size of described connection output buffers is at least described first database table and is connected a back storage size that connects combination record record with second database table.
Further, as shown in Figure 4, this device also comprises buffer memory allocation units 309 and computing unit 310, and buffer memory allocation units 309 are used for described first database table and are connected the size that size that the back connects the size of combination record and smart card free memory is determined described connection output buffers with second database table; Computing unit 310 is used for the size of described smart card free memory is deducted the size of the size of connection output buffers as new smart card free memory; Described buffer memory allocation units 309 also are used for, according to the size of the size of described first database table that obtains and a record of second database table and described new smart card free memory, determine first buffer memory corresponding and the size of second buffer memory respectively with described first tables of data and second database table.
Further, as shown in Figure 5, this device also comprises releasing unit 311.Described releasing unit 311 is used for after executing described connection query manipulation according to described connection querying condition, and preallocated first buffer memory of buffer memory allocation units, second buffer memory and connection output buffers are discharged.
Further, because the memory headroom of smart card is limited, therefore for described first database table distribute first to deposit the space size limited, may exist the described preallocated first database table buffer memory can not hold all records that satisfy first querying condition, therefore obtaining first record that satisfies described first querying condition according to described first querying condition, and with described first recording storage in preallocated first buffer memory time, need to judge that described first size that writes down is whether greater than the size of described preallocated first buffer memory, if size greater than described first buffer memory, then need to be stored in described first buffer memory according to described first record of the big young pathbreaker of described first buffer memory in batches, as shown in Figure 6, this described first storage unit 303 comprises: first judge module 3031, first memory module 3032 and first is memory module 3033 in batches.
Whether first judge module 3031, the size that is used to judge first record that satisfies described first querying condition be greater than the size of described first buffer memory; First memory module 3032 is used for when described first judge module 3031 judges that the size of described first record is less than or equal to described first buffer memory big or small, will described first writes down all once to be stored in described first buffer memory; Described first judge module 3031 judge described first record size greater than described first buffer memory big or small the time, described first in batches memory module 3033 be used for, according to the size of described first buffer memory in batches with described first recording storage in described first buffer memory.
Wherein, described first in batches memory module 3033 specifically be used for, described first in batches memory module be used for, from described first the record choose be less than or equal to the described first spatial cache size recording storage in described first buffer memory; Choose submodule described first and from described first record, choose in described first database table of mark when also having first record that satisfies described first querying condition, also have first record that satisfies described first querying condition in described first database table of mark; And the record in described first buffer memory and the record that satisfies second querying condition are connected make up finish after, according to described mark Query Database, obtain remaining first record that satisfies first querying condition, and according to the size of first buffer memory in batches with described remaining first recording storage in described first buffer memory.
Further, because the memory headroom of smart card is limited, therefore for described second database table distribute second to deposit the space size also limited, may exist described preallocated second table cache can not hold all records that satisfy second querying condition, therefore inquiring about described second database table according to described second querying condition, obtain second record that satisfies described second querying condition, and with described second recording storage in preallocated second buffer memory time, need to judge that described second record size that satisfies described second querying condition is whether greater than the size of described preallocated second buffer memory, if the size greater than described second buffer memory then needs to be stored in described second buffer memory according to the described record that satisfies second querying condition of the big young pathbreaker of described second buffer memory in batches, as shown in Figure 6, this described second storage unit 306 comprises: second judge module 3061, second memory module 3062 and second is memory module 3063 in batches.
Second judge module 3061 is used to judge that whether the size of described second record is greater than described second cache size; Second memory module 3062 is used for when described second judge module 3061 judges that the size of described second record is less than or equal to described second buffer memory big or small, will described second writes down once all to be stored in described second buffer memory; Second in batches memory module 3062 also be used for, the size of judging described second record at described second judge module 3061 is during greater than described second buffer memory big or small, according to the size of described second buffer memory in batches with described second recording storage in described second buffer memory.
Wherein, described second in batches memory module 3062 specifically be used for, from described second the record choose be less than or equal to the described second spatial cache size recording storage in described second buffer memory; Choose submodule described second and from described second record, when choosing the record that is less than or equal to the described second spatial cache size, also have the record that satisfies described second querying condition in described second database table of mark; And after the first record connection that the record in described second buffer memory is corresponding with described connection querying condition has been made up, according to described mark Query Database, obtain remaining second record that satisfies second querying condition, and according to the size of second buffer memory in batches with described remaining second recording storage in described second buffer memory.
Further, described second acquisition unit 306 also is used for, according to the 3rd inquiry condition described second database table is being inquired about, obtained second record that satisfies described second querying condition and the 3rd inquiry condition, described the 3rd inquiry condition is and the corresponding querying condition of described second database table.Wherein, the described three inquiry condition corresponding with second database table can comprise the querying condition of specifying a plurality of fields of output at described second database table, for convenience, will can comprise at described second database table and specify the querying condition of a plurality of fields of exporting to be referred to as the 3rd inquiry condition in the embodiment of the invention.
In the embodiment of the invention, in the time need carrying out the correlation inquiry operation to a plurality of database tables in the intelligent card database, in smart card, can store first buffer memory and second buffer memory of next bar record at least for the database table setting that need carry out correlation inquiry, and according to the connection output buffers of the recording setting correspondence after connecting; When carrying out the multi-table query operation, the size storage according to buffer memory of the record that satisfies querying condition is stored in first buffer memory and second buffer memory of setting in batches, and after the record that satisfies condition is carried out attended operation, with the recording storage after connecting in connecting output buffers, to realize the multilist correlation inquiry of intelligent card data table, that is, use the multiplexing mode of buffer memory to make full use of limited smart card memory space, thereby improved the performance and the quality of intelligent card database.
And by finish attended operation in smart card, the result after only output connects has improved database manipulation efficient in the embodiment of the invention.By the multilist attended operation, can expand to the multilist design to single table, improved the design flexibility of intelligent card database table.
In addition, after executing described connection query manipulation, preallocated buffer memory is discharged,, thereby improved the utilization factor of smart card memory so that described smart card uses described releasing memory to carry out other operation according to described connection querying condition.
By the present invention, realized the attended operation of intelligent card database two tables, further can realize the attended operation of multilist by similar design principle and operation steps, data redundancy and in application, realize the shortcoming and defect of the communication data redundancy that associative operation brought when having overcome single table handling, have laid a good foundation for realization intelligent card database multi-list Application Design, give full play to the superiority of relational database concatenation operation.
Through the above description of the embodiments, the those skilled in the art can be well understood to the present invention and can realize by the mode that software adds essential common hardware, can certainly pass through hardware, but the former is better embodiment under a lot of situation.Based on such understanding, the part that technical scheme of the present invention contributes to prior art in essence in other words can embody with the form of software product, this computer software product is stored in the storage medium that can read, floppy disk as computing machine, hard disk or CD etc., comprise some instructions with so that computer equipment (can be personal computer, server, the perhaps network equipment etc.) carry out the described method of each embodiment of the present invention.
Those skilled in the art should understand that the application's embodiment can be provided as method, system or computer program.Therefore, the application can adopt complete hardware embodiment, complete software implementation example or in conjunction with the form of the embodiment of software and hardware aspect.And the application can adopt the form that goes up the computer program of implementing in one or more computer-usable storage medium (including but not limited to magnetic disk memory, CD-ROM, optical memory etc.) that wherein include computer usable program code.
The application is that reference is described according to the process flow diagram and/or the block scheme of method, equipment (system) and the computer program of the embodiment of the present application.Should understand can be by the flow process in each flow process in computer program instructions realization flow figure and/or the block scheme and/or square frame and process flow diagram and/or the block scheme and/or the combination of square frame.Can provide these computer program instructions to the processor of multi-purpose computer, special purpose computer, Embedded Processor or other programmable data processing device to produce a machine, make the instruction of carrying out by the processor of computing machine or other programmable data processing device produce to be used for the device of the function that is implemented in flow process of process flow diagram or a plurality of flow process and/or square frame of block scheme or a plurality of square frame appointments.
These computer program instructions also can be stored in energy vectoring computer or the computer-readable memory of other programmable data processing device with ad hoc fashion work, make the instruction that is stored in this computer-readable memory produce the manufacture that comprises command device, this command device is implemented in the function of appointment in flow process of process flow diagram or a plurality of flow process and/or square frame of block scheme or a plurality of square frame.
These computer program instructions also can be loaded on computing machine or other programmable data processing device, make on computing machine or other programmable devices and to carry out the sequence of operations step producing computer implemented processing, thereby the instruction of carrying out on computing machine or other programmable devices is provided for being implemented in the step of the function of appointment in flow process of process flow diagram or a plurality of flow process and/or square frame of block scheme or a plurality of square frame.
Although described the application's preferred embodiment, in a single day those skilled in the art get the basic creative notion of cicada, then can make other change and modification to these embodiment.So claims are intended to all changes and the modification that are interpreted as comprising preferred embodiment and fall into the application's scope.
The above; only be the specific embodiment of the present invention, but protection scope of the present invention is not limited thereto, anyly is familiar with those skilled in the art in the technical scope that the present invention discloses; can expect easily changing or replacing, all should be encompassed within protection scope of the present invention.Therefore, protection scope of the present invention should be as the criterion with the protection domain of described claim.

Claims (15)

1. an intelligent card database multi-list operation method is characterized in that, comprising:
Carry out at least two database tables of attended operation from needs, choose a database table as first database table;
Obtain first record that satisfies first querying condition, and according to described first recording storage of the big young pathbreaker of first buffer memory in described first buffer memory, described first querying condition is and the corresponding querying condition of described first database table that the size of described first buffer memory is at least the storage size of a record in described first database table;
From described first record, obtain the corresponding data thresholding of data domain name in the connection querying condition of described first database table and other database tables, replace the data domain name of correspondence in the described connection querying condition to form second querying condition with described data thresholding;
Obtain second record that satisfies described second querying condition, and according to described second recording storage of the big young pathbreaker of second buffer memory in described second buffer memory, the size of described second buffer memory is at least the storage size of a record in described second database table;
Described first record is connected combination with described second record obtains connecting the combination record, and with described connection combination recording storage in preallocated connection output buffers, the size of described connection output buffers is at least described first database table and is connected a back storage size that connects combination record record with second database table.
2. method according to claim 1 is characterized in that, described first recording storage of described big young pathbreaker according to first buffer memory comprises in described first buffer memory:
Whether the size of judging described first record is greater than the size of described first buffer memory;
If the size of described first record is less than or equal to the size of described first buffer memory, then described first record once all is stored in described first buffer memory;
If the size of described first record is greater than the size of described first buffer memory, then according to the size of described first buffer memory in batches with described first recording storage in described first buffer memory.
3. method according to claim 2 is characterized in that, described size according to described first buffer memory comprises described first recording storage in batches in described first buffer memory:
From described first record, choose be less than or equal to the described first spatial cache size recording storage in described first buffer memory, and also have first record satisfy described first querying condition in described first database table of mark;
After the record in described first buffer memory and the record that satisfies second querying condition are connected combination finish,, obtain remaining first record of satisfied first querying condition according to described mark Query Database;
According to the size of first buffer memory in batches with described remaining first recording storage in described first buffer memory.
4. method according to claim 1 is characterized in that, described second recording storage of described big young pathbreaker according to second buffer memory comprises in described second buffer memory:
Whether the size of judging described second record is greater than the size of described second buffer memory;
If the size of described second record is less than or equal to the size of described second buffer memory, then described second record once all is stored in described second buffer memory;
If the size of described second record is greater than the size of described second buffer memory, then according to the size of described second buffer memory in batches with described second recording storage in described second buffer memory.
5. method according to claim 4 is characterized in that, described size according to described second buffer memory comprises described second recording storage in batches in described second buffer memory:
From described second record, choose be less than or equal to the described second spatial cache size recording storage in described second buffer memory, and also have the record satisfy described second querying condition in described second database table of mark;
After the first record connection that the record in described second buffer memory is corresponding with described connection querying condition has been made up,, obtain remaining second record that satisfies second querying condition according to described mark Query Database;
According to the size of second buffer memory in batches with described remaining second recording storage in described second buffer memory.
6. method according to claim 1 is characterized in that, describedly described first record is connected combination with described second record obtains connecting the combination record, and recording storage is made up in described connection comprise in preallocated connection output buffers:
If do not have described second record in described second buffer memory, then fill up second record that satisfies described second querying condition with null value, and the described record of second after the null value of filling up is connected combination with described first record in first buffer memory and obtains connecting the combination record, and described connection is made up recording storage in preallocated connection output buffers; Perhaps only with described first recording storage in preallocated connection output buffers;
If have described second record in described second buffer memory, first record that then will be corresponding with the data thresholding of described second querying condition and second record are connected combination and obtain connecting the combination record, and described connection is made up recording storage in preallocated connection output buffers.
7. method according to claim 1 is characterized in that, this method also comprises:
Be connected the size that size that the back connects the size of combination record and smart card free memory is determined described connection output buffers with second database table according to described first database table;
The size of described smart card free memory is deducted the size of the size of connection output buffers as new smart card free memory;
According to the size of the size of described first database table that obtains and a record of second database table and described new smart card free memory, determine first buffer memory corresponding and the size of second buffer memory respectively with described first tables of data and second database table.
8. method according to claim 1 is characterized in that, this method also comprises:
After executing described connection query manipulation, preallocated first buffer memory, second buffer memory and connection output buffers are discharged according to described connection querying condition.
9. an intelligent card database multi-list operating means is characterized in that, comprising:
Choose the unit, be used for carrying out at least two database tables of attended operation, choose a database table as first database table from needs;
First acquiring unit is used to obtain first record that satisfies first querying condition, and described first querying condition is and the corresponding querying condition of described first database table;
First storage unit, described first recording storage that is used for obtaining according to described first acquiring unit of the big young pathbreaker of first buffer memory is at described first buffer memory, and the size of described first buffer memory is at least the storage size of a record in described first database table;
Component units, be used for obtaining the corresponding data thresholding of data domain name the connection querying condition of described first database table and other database tables, replace the data domain name of correspondence in the described connection querying condition to form second querying condition with described data thresholding from described first record;
Second acquisition unit is used to obtain second record that satisfies described second querying condition;
Second storage unit is used for described second recording storage that the described second acquisition unit of big young pathbreaker according to second buffer memory obtains at described second buffer memory, and the size of described second buffer memory is at least the storage size of a record in described second database table;
Connect assembled unit, be used for that described first record is connected combination with described second record and obtain connecting the combination record;
The 3rd storage unit, the connection combination recording storage that is used for described connection assembled unit is generated is at preallocated connection output buffers, and the size of described connection output buffers is at least described first database table and is connected a back storage size that connects combination record record with second database table.
10. device according to claim 9 is characterized in that, described first storage unit comprises:
Whether first judge module, the size that is used to judge described first record be greater than the size of described first buffer memory;
First memory module is used for when described first judge module judges that the size of described first record is less than or equal to described first buffer memory big or small, will described first writes down once all to be stored in described first buffer memory;
First memory module in batches, the size that is used for judging described first record at described first judge module be during greater than described first buffer memory big or small, according to the size of described first buffer memory in batches with described first recording storage in described first buffer memory.
11. device according to claim 10 is characterized in that, described first in batches memory module be used for, from described first the record choose be less than or equal to the described first spatial cache size recording storage in described first buffer memory; Choose submodule described first and from described first record, choose in described first database table of mark when also having first record that satisfies described first querying condition, also have first record that satisfies described first querying condition in described first database table of mark; And the record in described first buffer memory and the record that satisfies second querying condition are connected make up finish after, according to described mark Query Database, obtain remaining first record that satisfies first querying condition, and according to the size of first buffer memory in batches with described remaining first recording storage in described first buffer memory.
12. device according to claim 9 is characterized in that, described second storage unit comprises:
Whether second judge module, the size that is used to judge described second record be greater than the size of described second buffer memory;
Second memory module is used for when described second judge module judges that the size of described second record is less than or equal to described second buffer memory big or small, will described second writes down once all to be stored in described second buffer memory;
Second memory module in batches, the size that is used for judging described second record at described second judge module be during greater than described second buffer memory big or small, according to the size of described second buffer memory in batches with described second recording storage in described second buffer memory.
13. device according to claim 12 is characterized in that, described second in batches memory module be used for, from described second the record choose be less than or equal to the described second spatial cache size recording storage in described second buffer memory; Choose submodule described second and from described second record, when choosing the record that is less than or equal to the described second spatial cache size, also have the record that satisfies described second querying condition in described second database table of mark; And after the first record connection that the record in described second buffer memory is corresponding with described connection querying condition has been made up, according to described mark Query Database, obtain remaining second record that satisfies second querying condition, and according to the size of second buffer memory in batches with described remaining second recording storage in described second buffer memory.
14. device according to claim 9 is characterized in that, this device also comprises:
The buffer memory allocation units are used for being connected the size that size that the back connects the size of combination record and smart card free memory is determined described connection output buffers with second database table according to described first database table;
Computing unit is used for the size of described smart card free memory is deducted the size of the size of connection output buffers as new smart card free memory;
Described buffer memory allocation units also are used for, according to the size of the size of described first database table that obtains and a record of second database table and described new smart card free memory, determine first buffer memory corresponding and the size of second buffer memory respectively with described first tables of data and second database table.
15. device according to claim 9 is characterized in that, described device also comprises:
Releasing unit is used for after executing described connection query manipulation according to described connection querying condition, and preallocated first buffer memory of buffer memory allocation units, second buffer memory and connection output buffers are discharged.
CN2010101633639A 2010-04-28 2010-04-28 Intelligent card database multi-list operation method and device Expired - Fee Related CN101840430B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2010101633639A CN101840430B (en) 2010-04-28 2010-04-28 Intelligent card database multi-list operation method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2010101633639A CN101840430B (en) 2010-04-28 2010-04-28 Intelligent card database multi-list operation method and device

Publications (2)

Publication Number Publication Date
CN101840430A true CN101840430A (en) 2010-09-22
CN101840430B CN101840430B (en) 2012-02-29

Family

ID=42743803

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2010101633639A Expired - Fee Related CN101840430B (en) 2010-04-28 2010-04-28 Intelligent card database multi-list operation method and device

Country Status (1)

Country Link
CN (1) CN101840430B (en)

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102262675A (en) * 2011-08-12 2011-11-30 北京握奇数据系统有限公司 Method for querying database and smart card
CN102306086A (en) * 2011-08-12 2012-01-04 北京握奇数据系统有限公司 Data output method of intelligent card and intelligent card
WO2015184782A1 (en) * 2014-10-22 2015-12-10 中兴通讯股份有限公司 Data query method and device
WO2016101659A1 (en) * 2014-12-22 2016-06-30 华为技术有限公司 Service data query method and apparatus and database system
CN105745642A (en) * 2014-03-31 2016-07-06 华为技术有限公司 Device and method for inquiring data
CN106570022A (en) * 2015-10-10 2017-04-19 阿里巴巴集团控股有限公司 Cross-data-source query method, apparatus and system
CN106933927A (en) * 2015-12-31 2017-07-07 北京国双科技有限公司 The connection method of tables of data and device
CN107016400A (en) * 2015-12-31 2017-08-04 达索系统公司 The assessment of training set
WO2018058671A1 (en) * 2016-09-30 2018-04-05 华为技术有限公司 Control method for executing multi-table connection operation and corresponding device
CN111221912A (en) * 2020-01-06 2020-06-02 中科驭数(北京)科技有限公司 Data synchronization method and device between database and hardware

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6012057A (en) * 1997-07-30 2000-01-04 Quarterdeck Corporation High speed data searching for information in a computer system
CN101000635A (en) * 2007-01-10 2007-07-18 凤凰微电子(中国)有限公司 Mass storing and managing method of smart card
CN101067814A (en) * 2007-05-10 2007-11-07 浪潮集团山东通用软件有限公司 Mapping conversion method between data access level Xml format data and relational data
CN101110074A (en) * 2007-01-30 2008-01-23 浪潮乐金信息系统有限公司 Data speedup query method based on file system caching
CN101350030A (en) * 2007-07-20 2009-01-21 株式会社东芝 Method and apparatus for caching data
CN101635001A (en) * 2008-07-18 2010-01-27 QlikTech国际公司 Method and apparatus for extracting information from a database

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6012057A (en) * 1997-07-30 2000-01-04 Quarterdeck Corporation High speed data searching for information in a computer system
CN101000635A (en) * 2007-01-10 2007-07-18 凤凰微电子(中国)有限公司 Mass storing and managing method of smart card
CN101110074A (en) * 2007-01-30 2008-01-23 浪潮乐金信息系统有限公司 Data speedup query method based on file system caching
CN101067814A (en) * 2007-05-10 2007-11-07 浪潮集团山东通用软件有限公司 Mapping conversion method between data access level Xml format data and relational data
CN101350030A (en) * 2007-07-20 2009-01-21 株式会社东芝 Method and apparatus for caching data
CN101635001A (en) * 2008-07-18 2010-01-27 QlikTech国际公司 Method and apparatus for extracting information from a database

Cited By (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102306086A (en) * 2011-08-12 2012-01-04 北京握奇数据系统有限公司 Data output method of intelligent card and intelligent card
CN102306086B (en) * 2011-08-12 2013-08-21 北京握奇数据系统有限公司 Data output method of intelligent card and intelligent card
CN102262675A (en) * 2011-08-12 2011-11-30 北京握奇数据系统有限公司 Method for querying database and smart card
CN105745642B (en) * 2014-03-31 2019-08-16 华为技术有限公司 Inquire the treating method and apparatus of data
CN105745642A (en) * 2014-03-31 2016-07-06 华为技术有限公司 Device and method for inquiring data
WO2015184782A1 (en) * 2014-10-22 2015-12-10 中兴通讯股份有限公司 Data query method and device
WO2016101659A1 (en) * 2014-12-22 2016-06-30 华为技术有限公司 Service data query method and apparatus and database system
CN106570022A (en) * 2015-10-10 2017-04-19 阿里巴巴集团控股有限公司 Cross-data-source query method, apparatus and system
CN106570022B (en) * 2015-10-10 2020-06-23 菜鸟智能物流控股有限公司 Cross-data-source query method, device and system
CN107016400A (en) * 2015-12-31 2017-08-04 达索系统公司 The assessment of training set
CN106933927B (en) * 2015-12-31 2019-12-10 北京国双科技有限公司 Data table connection method and device
CN106933927A (en) * 2015-12-31 2017-07-07 北京国双科技有限公司 The connection method of tables of data and device
CN107016400B (en) * 2015-12-31 2023-01-24 达索系统公司 Evaluation of training set
CN109791543A (en) * 2016-09-30 2019-05-21 华为技术有限公司 Execute the control method and corresponding intrument of multi-table join operation
WO2018058671A1 (en) * 2016-09-30 2018-04-05 华为技术有限公司 Control method for executing multi-table connection operation and corresponding device
CN109791543B (en) * 2016-09-30 2021-02-12 华为技术有限公司 Control method for executing multi-table connection operation and corresponding device
US11301470B2 (en) 2016-09-30 2022-04-12 Huawei Technologies Co., Ltd. Control method for performing multi-table join operation and corresponding apparatus
CN111221912A (en) * 2020-01-06 2020-06-02 中科驭数(北京)科技有限公司 Data synchronization method and device between database and hardware

Also Published As

Publication number Publication date
CN101840430B (en) 2012-02-29

Similar Documents

Publication Publication Date Title
CN101840430B (en) Intelligent card database multi-list operation method and device
CN107688999B (en) Block chain-based parallel transaction execution method
CN101751406B (en) Method and device for realizing column storage based relational database
JP6025149B2 (en) System and method for managing data
CN101031907B (en) Index processing
CN102521406B (en) Distributed query method and system for complex task of querying massive structured data
CN105320775B (en) The access method and device of data
CN103229173B (en) Metadata management method and system
CN106201355A (en) Data processing method and device and storage system
CN101315628A (en) Internal memory database system and method and device for implementing internal memory data base
CN102779138B (en) The hard disk access method of real time data
CN104112008A (en) Multi-table data association inquiry optimizing method and device
CN103577440A (en) Data processing method and device in non-relational database
CN103765381B (en) Parallel work-flow to B+ tree
CN102682108B (en) Row and line mixed database storage method
CN102890675B (en) Method and device for storing and finding data
EP2316074A1 (en) Copying entire subgraphs of objects without traversing individual objects
CN108021702A (en) Classification storage method, device, OLAP database system and medium based on LSM-tree
CN102622434A (en) Data storage method, data searching method and device
CN104536908B (en) A kind of magnanimity small records efficient storage management method towards unit
CN105786918A (en) Data loading storage space-based data query method and device
CN102521304A (en) Hash based clustered table storage method
US7984072B2 (en) Three-dimensional data structure for storing data of multiple domains and the management thereof
CN103092916B (en) The method and apparatus of amendment data structure
CN102262675B (en) Method for querying database and smart card

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
CF01 Termination of patent right due to non-payment of annual fee
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20120229