CN1834957A - Multi-chart information initializing method of database - Google Patents

Multi-chart information initializing method of database Download PDF

Info

Publication number
CN1834957A
CN1834957A CN 200510055449 CN200510055449A CN1834957A CN 1834957 A CN1834957 A CN 1834957A CN 200510055449 CN200510055449 CN 200510055449 CN 200510055449 A CN200510055449 A CN 200510055449A CN 1834957 A CN1834957 A CN 1834957A
Authority
CN
China
Prior art keywords
information
master meter
unknown message
database
internal memory
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 200510055449
Other languages
Chinese (zh)
Other versions
CN100383787C (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.)
Huawei Technologies Co Ltd
Original Assignee
Huawei Technologies 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 Huawei Technologies Co Ltd filed Critical Huawei Technologies Co Ltd
Priority to CNB2005100554499A priority Critical patent/CN100383787C/en
Publication of CN1834957A publication Critical patent/CN1834957A/en
Application granted granted Critical
Publication of CN100383787C publication Critical patent/CN100383787C/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 invention discloses a database multilist information initializing method, where the database multilist comprises primary list and secondary lists. And the method comprises the steps of: A. reading information from each secondary list into a memory; B. reading information from the primary list and generating a primary list recording set in the memory; C. according to a relation between unknown information in the primary list recording set and secondary list information, using the unknown information as index, and searching the secondary list information in the memory related with the unknown information by the relation, and putting the known information in the primary list recording set and the related secondary list information together into a complete record of database multilist information.

Description

A kind of multi-chart information initializing method of database
Technical field
The present invention relates to the database design field, relate in particular to a kind of multi-chart information initializing method of database.
Background technology
In the database application field, under the bigger situation of quantity of information, employing is put into the method that different database tables is preserved respectively after a complete information is divided into a plurality of parts usually, and above-mentioned different database table is commonly called database multi-list.For the ease of inquiry, when beginning to start in system usually, the database multi-list related to this system carries out initialization, promptly by reading database multi-list, the each several part information that is distributed in the database multi-list is extracted, thereby obtain a complete information record.
In existing multi-chart information initializing method of database, usually the data volume of being preserved with each table is a foundation, and the database table of data volume maximum is defined as master meter, and other database table except that master meter is defined as inferior showing.The database multi-list of being formed with table 1 and table 2 is an example, because the data volume that comprises is bigger than the data volume in the table 2 in the table 1, therefore table 1 is defined as master meter, table 2 is time table.
Device name Version Use agreement
Dev1 V100 SNMP
Dev2 V200 MML
Dev3 V100 SNMP
Dev4 V200 MML
Dev5 V100 SNMP
Dev6 V200 MML
Dev7 V100 SNMP
Dev8 V200 MML
Table 1
Protocol name Protocol description
SNMP Simple Network Management Protocol
MML The man-machine language interaction protocol
Table 2
Referring to Fig. 1, determined that the existing database multi-chart information initializing method behind master meter and time table may further comprise the steps:
Step 101. reads master meter information, forms the master meter record set.
In this step, use the system of database multi-list at first master meter to be read, each row in the master meter as a record, is formed the master meter record set in self EMS memory.For the master meter shown in the table 1, the formed master meter record set of this step comprises and putting in order and identical 8 records of table 1, all contains information such as device name, version and use agreement in every record.
Step 102. reads first record in the master meter record set.
In this step, use the system of database multi-list from the master meter record set that is kept at internal memory, to obtain article one record.For the master meter record set that is formed by table 1, first that reads this moment is recorded as: device name Dev1, a version V100, use agreement SNMP.Wherein, for the system that uses database multi-list, Dev1 and V100 are Given informations, and SNMP then is a unknown message.
Step 103. reads the information in each time table according to the current record in the master meter record set.
Owing to include unknown message in the current master meter record, and the incidence relation between each table of setting when setting up database multi-list as can be known, above-mentioned unknown message is present in each time table, therefore in this step with the unknown message in the current master meter record as querying condition, utilize query sentence of database to inquire about each time table successively.When system found the concrete implication of above-mentioned unknown message by database query operations from table 2 after, database multi-list as Query Result, returned to internal memory with the concrete implication of the unknown message that found.
For example, in the formed master meter record set of table 1, when current record is in this master meter record set first record, SNMP is a unknown message, then with SNMP as the querying condition that is included in the query statement, his-and-hers watches 2 read, then after the implication that gets access to SNMP is Simple Network Management Protocol, to internal memory return data storehouse multi-table query result.
The information that comprises in time table that step 104. writes down current master meter and read is assembled into a complete record.
Having finished this to after the reading of inferior table, use the system of database multi-list that the Given information in the current master meter record is combined with the implication of the unknown message that gets access to from inferior table, form a complete record.Be example still with first of table 1 record and table 2, the Simple Network Management Protocol that in this step database multi-list is returned to internal memory is updated among the SNMP in first record of table 1, and form the complete documentation that thes contents are as follows: device name Dev1, version V100, use agreement are Simple Network Management Protocol.
Step 105~106. judge that whether current master meter record is the tail record in the master meter record set, if, then finish notebook data storehouse multi-chart information initializing flow process, otherwise, turn to next the bar record in the master meter record set, and return execution in step 103.
If current master meter record is not the tail record in the master meter record set, then represent also to have the record that is not read in the master meter record set, and the unknown message in the above-mentioned record that is not read awaits obtaining from each time table; If current master meter record is the tail record in the master meter record set, then reading of master meter record set and each time table finished in expression, and formed all required complete documentations, promptly finished the database multi-list information initializing.
Above-mentioned steps 101 to 106 has been formed existing database multi-list information initializing process.Tentation data storehouse multilist is made up of master meter and n table, and wherein the line number of master meter is m.By above steps as seen, when forming the master meter record set, each row in the master meter forms a master meter record, promptly forms the master meter record set that comprises m bar record; And whenever read a master meter record, and all to from database, all time tables be read once, promptly read time database manipulation of table and carry out (m * n) inferior altogether; Consider again when forming the master meter record set the reading of master meter, then need the number of times of reading database to be: (1+mn) inferior for finishing the database multi-list information initializing.In addition, suppose to read the time that master meter consumes from database is k at every turn 1Second, read the inferior time of showing to be consumed from database is k at every turn 2Second, the time of then finishing the database multi-list information initializing is: (k 1+ mnk 2) second.
For table 1 and table 2, have 8 row, i.e. m=8 in the master meter; Inferior table has only one, i.e. n=1 then finishes the database multi-list information initializing and needs the number of times of reading database to be:
(1+8 * 1)=9 times.
The time that suppose to read table 1 again needs at every turn is 0.05 second, and the time of at every turn reading table 2 is 0.02 second, and then the time of database multi-list information initializing is: (0.05 * 1+8 * 1 * 0.02)=0.21 second.
From above-mentioned analysis as can be known, the shortcoming of existing multi-chart information initializing method of database is: the number of, inferior table more when the line number that master meter comprises more for a long time, make reading database the time number of times long and reading database of consumption more, the time of therefore finishing the database multi-list information initializing is long, speed is slow, efficient is lower.
Summary of the invention
In view of this, the object of the present invention is to provide a kind of high efficiency multi-chart information initializing method of database.
For achieving the above object, the invention provides a kind of multi-chart information initializing method of database, described database multi-list comprises master meter and time table, it is characterized in that this method may further comprise the steps:
A. the information in each time table is read in the internal memory;
B. read the information in the master meter, and in internal memory, generate the master meter record set;
C. according to the incidence relation between unknown message in the master meter record set of setting up in advance and time table information, with the unknown message in the described master meter record set is index, by described incidence relation, inferior table information that retrieval is associated with this unknown message in the internal memory, and the Given information in the described master meter record set and the relevant inferior table information that retrieves are assembled into the complete documentation of database multi-list information.
Steps A is described read the information in each time table in the internal memory after, this method further comprises:
In internal memory, set up corresponding mapping table, the delegation in time table that reads is saved as an element units of described mapping table for each described table;
The method for building up of the incidence relation between unknown message in the described master meter record set of step C and time table information is: set up described unknown message and comprise corresponding relation between the mapping table of this unknown message, and set up the corresponding relation between the described unknown message position of element units in mapping table corresponding with this unknown message;
Step C is described to the method for retrieving with corresponding table information of this unknown message in the internal memory to be: according to the incidence relation of setting up, determine corresponding mapping table and the corresponding position of element units in described mapping table by the unknown message in the master meter record set, according to the position of described mapping table, from the element units of correspondence, extract required inferior table information again.
Steps A is described read the information in each time table in the internal memory after, this method further comprises:
In internal memory, set up corresponding mapping table, the delegation in time table that reads is saved as an element units of described mapping table for each described table;
The method for building up of the incidence relation between unknown message in the described master meter record set of step C and time table information is: when reading described inferior table, read in positional information and time incidence relation of table in the master meter from database multi-list;
Step C is described to the method for retrieving with corresponding table information of this unknown message in the internal memory to be: according to the incidence relation of setting up, determine corresponding mapping table and the corresponding position of element units in described mapping table by the unknown message in the master meter record set, according to the position of described mapping table, from the element units of correspondence, extract required inferior table information again.
The method that delegation in the described inferior table information that will read saves as an element units of described mapping table is:
With in the described element units with the corresponding to project of master meter unknown message as key word, with the information of this unknown message correspondence in this row as element value;
The described method of extracting required inferior table information from the element units of correspondence is:
Corresponding relation according to described unknown message and mapping table, determine the pairing mapping table of key word, corresponding relation according to unknown message and element units position, this key word is converted to the position of element units, find corresponding element units according to described position again, obtain the element value in this element units.
If described unknown message is one or more, then after described step C, further comprise:
Judge whether current record is the tail record of master meter record set, if, then finish the flow process of this assembly unit complete documentation, otherwise, turn to next the bar record in the master meter record set, and return execution in step C.
After the described step C, this method further comprises: described table information is deleted from internal memory.
The described method that forms the master meter record set in internal memory of steps A is:
Each capable record that saves as in the described master meter record set with described master meter.
Use the present invention, can effectively improve the efficient of database multi-list information initializing.Particularly, the present invention has following beneficial effect:
1. the present invention is by carrying out read operation respectively one time to each database table in the database multi-list, and content wherein is saved in the internal memory, and then the master meter preserved in the internal memory and information that time table is corresponding retrieved, and be assembled into complete record, then the number of the database table in the number of times of the reading database that carries out in order to finish the database multi-list information initializing and the database multi-list is identical, comparatively significantly reduce the number of times of reading database operation, improved the efficient of database multi-list information initializing.
2. the present invention further adopts the form of mapping table (Map), and the information in each time table is kept in the internal memory.Because Map has and searches performance fast, then the time that the database multi-list information initializing is consumed among the present invention shorter, initialization efficient is higher.
Description of drawings
Fig. 1 is the process flow diagram of existing database multi-list initial method.
Fig. 2 is the process flow diagram of database multi-list initial method of the present invention.
Embodiment
For making purpose of the present invention, technical scheme clearer, below with reference to the accompanying drawing embodiment that develops simultaneously, the present invention is described in further detail.
The present invention is a kind of multi-chart information initializing method of database, and its basic thought is: at first, the information in each time table is read in the internal memory; Then, read the information in the master meter, and in internal memory, form the master meter record set; Then, according to the incidence relation between unknown message in the master meter record set of setting up in advance and time table information, with the unknown message in the described master meter record set is index, by described incidence relation, inferior table information that retrieval is associated with this unknown message in the internal memory, and the Given information in the described master meter record set and the relevant inferior table information that retrieves are assembled into the complete documentation of database multi-list information
The database multi-list that still constitutes with table 1 and table 2 is an example below, and multi-chart information initializing method of database of the present invention is described.
The present invention was a foundation with the data volume of being preserved in each table before the database multi-chart information is carried out initialization, pre-determined master meter and time table.For table 1 and table 2,, determine that therefore table 1 is that master meter, table 2 are time table because the data volume that comprises in the table 1 is bigger than table 2.
Referring to Fig. 2, multi-chart information initializing method of database of the present invention may further comprise the steps:
Step 201. reads the information in each time table in the internal memory, and sets up the corresponding Map of each time table.
Map is a kind of list formula set, and it comprises a plurality of element units of being made up of key word (Key) and corresponding element value (Value) thereof (Element).Map uses Hash (Hash) algorithm to carry out self memory and retrieval, be that Map sets up corresponding relation between the position of element units under key word and this key word, when carrying out retrieval, Map is converted to corresponding stored position information by hash algorithm with key word, directly find the elements corresponding unit by this positional information again, and from the element units that is found, extract element value.Therefore, Map is the data capsule with quick locating function.
Search performance fast for what utilize Map, use the system of database multi-list in this step predetermined each time table to be read, and in internal memory, be respectively each time table and set up corresponding Map, the inferior table information of reading in preservation.In the Map that is set up, an element units is corresponding with the list item in time table, the delegation that is about in time table saves as element units among the Map, and each element units is all to be key word, to be element value with the sundry item in this row with the corresponding project of master meter unknown message in this row.With table 2 is example, uses the system of database multi-list at first to obtain SNMP corresponding to Simple Network Management Protocol and the MML information corresponding to the man-machine language interaction protocol from table 2; Then, in internal memory, set up the Map that comprises two element units, the key word of one of them element units is that SNMP, corresponding element value are Simple Network Management Protocol, and the key word of another element units is that MML, corresponding element value are the man-machine language interaction protocol.
In addition, this step also can be read in unknown message and time incidence relation of table in the master meter, so that determine the pairing Map of unknown message when reading time table information.Also can adopt additive method to set up unknown message and time incidence relation of table in this step, for example: set up unknown message and comprise corresponding relation between the Map of this unknown message, and set up the corresponding relation between the unknown message position of element units in Map corresponding with this unknown message.
Step 202. reads the information in the master meter, and forms the master meter record set in internal memory.
In this step, the system that uses database is by carrying out a database read extract operation to master meter, obtains all information of preserving in the master meter, and with each row in the master meter as a record, in internal memory, form the master meter record set.
Step 203. is assembled into complete database multi-list information record with the inferior table information among master meter information in the master meter record set and the Map.
Use the system of database multi-list to be index with the unknown message in the master meter record set in this step, corresponding Map retrieves to inferior table, and after finding the implication of unknown message, Given information in the master meter is combined with the implication of the unknown message that obtains from Map, form complete record.Particularly, the method for this step assembly unit complete documentation comprises:
A. obtain first record in the master meter record set;
B. with the unknown message in the current record as key word, according to unknown message of setting up in advance and the corresponding relation between Map, all Map in the internal memory are retrieved, determine to comprise the Map of this key word, again according to the positional information that obtains by this key conversion, in determined Map, obtain corresponding element value, thereby obtain the information of this unknown message correspondence;
C. the information of the unknown message correspondence that gets access to is combined with Given information in the current record, form a complete record;
D. judge whether current record is the tail record of master meter record set, if, then finish the flow process of this assembly unit complete documentation, and enter step 204, otherwise, turn to next the bar record in the master meter record set, and return execution in step b.
The database multi-list of forming with table 1 and table 2 is an example, in this step at first the SNMP with first record in the formed master meter record set of table 1 be key word, determine the pairing Map of table 2, then in this Map, find the Simple Network Management Protocol of SNMP correspondence, and Simple Network Management Protocol is updated to first record of master meter record set, form the complete documentation that thes contents are as follows: device name Dev1, version V100, use agreement are Simple Network Management Protocol; Turn to the 2nd record of master meter record set then, carry out the assembly unit of complete documentation; The rest may be inferred, till the unknown message MML of the 8th record is replaced, forms complete record by the man-machine language interaction protocol among the Map of table 2 correspondence in the master meter record set.
Because required master meter information and time table information of database multi-list information initializing this moment all is present among the internal memory, so all operations of this step is all finished in internal memory.
Step 204. discharges the Map that has set up.
In this step, the system of use database multi-list sets up step 201 in internal memory all Map deletions are so that the releasing memory space.
So far, database multi-list information initializing of the present invention is finished.
In the process of database multi-list information initializing of the present invention, comprise table in the multilist of tentation data storehouse n time, and the line number of master meter is m.By above-mentioned step 201 to step 204 as seen, the present invention only needs master meter and each time table are carried out a database read extract operation respectively, be and finish the database multi-list information initializing and need the number of times of reading database to be: (1+n) inferior, (1+mn) that obviously is less than existing database multilist initial method is inferior.
In addition, suppose to read the time that master meter consumes from database is k at every turn 1Second, read the inferior time of showing to be consumed from database is k at every turn 2Second, read the time that Map consumes from internal memory is k at every turn 3Second, owing to whenever read a master meter record, all Map to be read once again, the time of then finishing the database multi-list information initializing is: (k 1+ nk 2+ mk 3) second.Facts have proved, from the Map that is stored in internal memory, obtain a time k that data are required 3Less than ten thousand/second, therefore the database multi-list information initializing time of the present invention is much smaller than (the k of prior art 1+ mnk 2) second.
For the database multi-list of table 1 and table 2 formation, have 8 row, i.e. m=8 in the master meter; Inferior table has only one, i.e. n=1 then finishes the database multi-list information initializing and needs the number of times of reading database to be:
(1+n)=(1+1)=2 time.
The time that suppose to read table 1 again needs at every turn is 0.05 second, and the time of at every turn reading table 2 is 0.02 second, and the time of at every turn reading Map is 0.0001 second, and then the time of database multi-list information initializing is:
(k 1+ nk 2+ mk 3Second)=(0.05 * 1+1 * 0.02+8 * 0.0001)=0.0708.
As seen, when table 1 and table 2 used method of the present invention to carry out initialization, the required time was 1/3rd of prior art.
Under normal conditions, master meter comprises about 100,000 row.Suppose master meter line number m=10 5OK, inferior table number n=3, master meter time for reading k 1=0.2 second, inferior table time for reading k 2=0.05 second, Map time for reading k 3=0.0001 second, when then using the method for prior art to carry out the database multi-list initialization, the time that is consumed was:
k 1+ mnk 2=0.2+10 5* 3 * 0.05=15000.2 second;
And when using method of the present invention to carry out the database multi-list initialization, the time that is consumed is:
k 1+ nk 2+ mk 3=0.2+3 * 0.05+10 5* 0.0001=10.35 second.
As seen, the initialization efficient of initialization efficiency ratio prior art of the present invention has improved more than 1,000 times at this moment.
No matter is the number of times of reading database this moment when using method of the present invention that database multi-list is carried out initialization, or the time that initialization consumed, and all can significantly reduce, thereby make the initialization efficient of database multi-list improve significantly
In a word, use the present invention, can effectively reduce reading database in the database multi-list information initializing number of times, shorten initialization time, improve initialization efficient.
The above only is preferred embodiment of the present invention, and is in order to restriction the present invention, within the spirit and principles in the present invention not all, any modification of being made, is equal to replacement, improvement etc., all should be included within protection scope of the present invention.

Claims (7)

1, a kind of multi-chart information initializing method of database, described database multi-list comprise master meter and time table, it is characterized in that this method may further comprise the steps:
A. the information in each time table is read in the internal memory;
B. read the information in the master meter, and in internal memory, generate the master meter record set;
C. according to the incidence relation between unknown message in the master meter record set of setting up in advance and time table information, with the unknown message in the described master meter record set is index, by described incidence relation, inferior table information that retrieval is associated with this unknown message in the internal memory, and the Given information in the described master meter record set and the relevant inferior table information that retrieves are assembled into the complete documentation of database multi-list information.
2, the method for claim 1 is characterized in that, steps A is described read the information in each time table in the internal memory after, this method further comprises:
In internal memory, set up corresponding mapping table, the delegation in time table that reads is saved as an element units of described mapping table for each described table;
The method for building up of the incidence relation between unknown message in the described master meter record set of step C and time table information is: set up described unknown message and comprise corresponding relation between the mapping table of this unknown message, and set up the corresponding relation between the described unknown message position of element units in mapping table corresponding with this unknown message;
Step C is described to the method for retrieving with corresponding table information of this unknown message in the internal memory to be: according to the incidence relation of setting up, determine corresponding mapping table and the corresponding position of element units in described mapping table by the unknown message in the master meter record set, according to the position of described mapping table, from the element units of correspondence, extract required inferior table information again.
3, the method for claim 1 is characterized in that, steps A is described read the information in each time table in the internal memory after, this method further comprises:
In internal memory, set up corresponding mapping table, the delegation in time table that reads is saved as an element units of described mapping table for each described table;
The method for building up of the incidence relation between unknown message in the described master meter record set of step C and time table information is: when reading described inferior table, read in positional information and time incidence relation of table in the master meter from database multi-list;
Step C is described to the method for retrieving with corresponding table information of this unknown message in the internal memory to be: according to the incidence relation of setting up, determine corresponding mapping table and the corresponding position of element units in described mapping table by the unknown message in the master meter record set, according to the position of described mapping table, from the element units of correspondence, extract required inferior table information again.
As claim 2 or 3 described methods, it is characterized in that 4, the method that the delegation in the described inferior table information that will read saves as an element units of described mapping table is:
With in the described element units with the corresponding to project of master meter unknown message as key word, with the information of this unknown message correspondence in this row as element value;
The described method of extracting required inferior table information from the element units of correspondence is:
Corresponding relation according to described unknown message and mapping table, determine the pairing mapping table of key word, corresponding relation according to unknown message and element units position, this key word is converted to the position of element units, find corresponding element units according to described position again, obtain the element value in this element units.
5, to adopt 1 described method as right, it is characterized in that,, then after described step C, further comprise if described unknown message is one or more:
Judge whether current record is the tail record of master meter record set, if, then finish the flow process of this assembly unit complete documentation, otherwise, turn to next the bar record in the master meter record set, and return execution in step C.
As claim 1 or 5 described methods, it is characterized in that 6, after the described step C, this method further comprises: described table information is deleted from internal memory.
7, the method for claim 1 is characterized in that, the described method that forms the master meter record set in internal memory of steps A is:
Each capable record that saves as in the described master meter record set with described master meter.
CNB2005100554499A 2005-03-17 2005-03-17 Multi-chart information initializing method of database Expired - Fee Related CN100383787C (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CNB2005100554499A CN100383787C (en) 2005-03-17 2005-03-17 Multi-chart information initializing method of database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CNB2005100554499A CN100383787C (en) 2005-03-17 2005-03-17 Multi-chart information initializing method of database

Publications (2)

Publication Number Publication Date
CN1834957A true CN1834957A (en) 2006-09-20
CN100383787C CN100383787C (en) 2008-04-23

Family

ID=37002704

Family Applications (1)

Application Number Title Priority Date Filing Date
CNB2005100554499A Expired - Fee Related CN100383787C (en) 2005-03-17 2005-03-17 Multi-chart information initializing method of database

Country Status (1)

Country Link
CN (1) CN100383787C (en)

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2010097019A1 (en) * 2009-02-25 2010-09-02 成都市华为赛门铁克科技有限公司 Method and apparatus for monitoring locking mechanism
WO2011095029A1 (en) * 2010-02-03 2011-08-11 中兴通讯股份有限公司 Efficient data processing method and device
CN102262675A (en) * 2011-08-12 2011-11-30 北京握奇数据系统有限公司 Method for querying database and smart card
CN102999525A (en) * 2011-09-16 2013-03-27 深圳市金蝶中间件有限公司 Data-table processing method and system
CN105447122A (en) * 2015-11-16 2016-03-30 中国人民解放军理工大学 Implementation method for autonomously creating file system based on multi-table association
CN109299098A (en) * 2018-09-29 2019-02-01 北京理工大学 The storage and its access method of a kind of table of multiple multilayer gauge outfits in the database
CN109408588A (en) * 2018-09-07 2019-03-01 武汉达梦数据库有限公司 A kind of method of breakpoint transmission when database synchronization initialization loading

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0489861B1 (en) * 1989-09-01 1997-07-09 Amdahl Corporation Operating system and data base
JPH0433164A (en) * 1990-05-30 1992-02-04 Nec Corp Temporary table connection system in relational type data base
US6295526B1 (en) * 1997-10-14 2001-09-25 Bellsouth Intellectual Property Corporation Method and system for processing a memory map to provide listing information representing data within a database
US6122628A (en) * 1997-10-31 2000-09-19 International Business Machines Corporation Multidimensional data clustering and dimension reduction for indexing and searching
CN100371931C (en) * 2003-08-13 2008-02-27 华为技术有限公司 Method for realizing quick-accessing database
CN1307585C (en) * 2003-12-31 2007-03-28 中兴通讯股份有限公司 Data processing method for realizing data base multitable inguiry

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2010097019A1 (en) * 2009-02-25 2010-09-02 成都市华为赛门铁克科技有限公司 Method and apparatus for monitoring locking mechanism
WO2011095029A1 (en) * 2010-02-03 2011-08-11 中兴通讯股份有限公司 Efficient data processing method and device
CN102262675A (en) * 2011-08-12 2011-11-30 北京握奇数据系统有限公司 Method for querying database and smart card
CN102999525A (en) * 2011-09-16 2013-03-27 深圳市金蝶中间件有限公司 Data-table processing method and system
CN102999525B (en) * 2011-09-16 2016-08-03 深圳市金蝶中间件有限公司 Tables of data processing method and system
CN105447122A (en) * 2015-11-16 2016-03-30 中国人民解放军理工大学 Implementation method for autonomously creating file system based on multi-table association
CN105447122B (en) * 2015-11-16 2018-09-21 中国人民解放军理工大学 A kind of implementation method that archives economy can be independently created based on multilist association
CN109408588A (en) * 2018-09-07 2019-03-01 武汉达梦数据库有限公司 A kind of method of breakpoint transmission when database synchronization initialization loading
CN109299098A (en) * 2018-09-29 2019-02-01 北京理工大学 The storage and its access method of a kind of table of multiple multilayer gauge outfits in the database
CN109299098B (en) * 2018-09-29 2022-04-12 北京理工大学 Method for storing and accessing multiple tables with multilayer headers in database

Also Published As

Publication number Publication date
CN100383787C (en) 2008-04-23

Similar Documents

Publication Publication Date Title
US11620397B2 (en) Methods and apparatus to provide group-based row-level security for big data platforms
US11468027B2 (en) Method and apparatus for providing efficient indexing and computer program included in computer readable medium therefor
CN1277213C (en) A flash memory file system management method
CN1834957A (en) Multi-chart information initializing method of database
EP3767483B1 (en) Method, device, system, and server for image retrieval, and storage medium
TW201913416A (en) Index key value tree database
US20150261466A1 (en) Device and method for storing data in distributed storage system
CN105279213A (en) Retrieval device and retrieval method for log database
CN1955958A (en) Sort data storage and split catalog inquiry method based on catalog tree
CN1975725A (en) Method and system for managing journal
CN101043695A (en) Method for storing and maintaining user equipment information in mobile communication system
CN103020054B (en) Fuzzy query method and system
US9262511B2 (en) System and method for indexing streams containing unstructured text data
CN102760165B (en) Full text retrieval method using bitmap index and device
KR20110021125A (en) Method and apparatus for recovering partition
CN1492362A (en) Data back up and recovering method of embedded data bank
US20090144279A1 (en) Method for improving search efficiency in enterprise search system
US9104726B2 (en) Columnar databases
CN112262379A (en) Storing data items and identifying stored data items
CN1845093A (en) Attribute extensible object file system
US20130159315A1 (en) Methods for prefix indexing
CN1776688A (en) Word data searching method
CN1889080A (en) Method for searching character string
CN114238334A (en) Heterogeneous data encoding method and device, heterogeneous data decoding method and device, computer equipment and storage medium
CN102768672A (en) Disk space management method and device

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: 20080423

Termination date: 20160317