CN100371931C - Method for realizing quick-accessing database - Google Patents
Method for realizing quick-accessing database Download PDFInfo
- Publication number
- CN100371931C CN100371931C CNB031532845A CN03153284A CN100371931C CN 100371931 C CN100371931 C CN 100371931C CN B031532845 A CNB031532845 A CN B031532845A CN 03153284 A CN03153284 A CN 03153284A CN 100371931 C CN100371931 C CN 100371931C
- Authority
- CN
- China
- Prior art keywords
- data
- database
- tables
- record identification
- information
- 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.)
- Expired - Fee Related
Links
Images
Abstract
The present invention discloses a method for realizing the quick access of a database. The method comprises: a unique record tag is set for each message; more than one data list for storing the message is established, and a unique tag message is set for each data list; a memory index list for storing the corresponding relation of the record tag and the data list is established; after the database receives query information, information record tags corresponding the query information can be obtained from the data lists, and form at least one record tag set; all the record tags are recorded and tagged on the data list according to the enquiry of a memory index list; messages corresponding to the record tags are obtained from the data list, and all the messages corresponding to the record tag set are sent to the users. The present invention solves the problem that accessing speed is low when the data quantity of the database is large in the prior art. Thus, the quick access of the database is achieved.
Description
Technical field
The present invention relates to the database access technology field, relate to a kind of method that realizes the database fast access or rather.
Background technology
Along with the develop rapidly of science and technology, database has been widely used in various fields, and is also more and more higher to the requirement of database access speed.
With the communications field is example, and people use short message to carry out periodic traffic more and more now, and short message communication has become one of main means of communication.Safeguard needs according to reality, the short message in nearest phase of history period need be kept in the short message data storehouse that a tables of data is only set up in present short message data storehouse, all short messages all are kept in this tables of data.In general, the short message data storehouse need be preserved trimestral historical data at least, and all have every day 5,000 ten thousand even more short message need be recorded in the tables of data in short message data storehouse, therefore the data volume in the tables of data is very big, deposits so big tables of data in database very difficulty.
If the user need stride a day inquiry to the short message transmission situation of designated user, then office side maintainer need inquire about all data in the tables of data in short message data storehouse, to find out the ticket writing that the user needs, obviously, in so huge tables of data, search very difficulty of data.And the user has relatively high expectations to the response speed in short message data storehouse when inquiring about, and needs the short message data storehouse can return Query Result in the short period of time.Therefore, existing short message data storehouse organizational form is difficult to satisfy the requirement that the user obtains Query Information fast.
For realizing tuning to the short message data storehouse, industry has proposed the parameter in short message data storehouse is adjusted, set up index, uses hardware to share methods such as magnetic disc i/o on tables of data at present, but because the short message data storehouse is very huge, during to short message data storehouse tuning, can not improve the access speed in short message data storehouse by said method significantly.And, when the short message details that will get access to send to the user, because the data volume of the short message details that will send may be very big, and the network at user place possibly can't transmit so big data, the phenomenon that packet loss then will occur, even network can transmit this packet, also can influence the transmission of data in the whole network very greatly because of the data volume of the short message details that will transmit.Therefore the actual needs of short message service can not be satisfied in existing short message data storehouse.
In sum, existing big data quantity access of database speed can not satisfy professional requirement to the database quick feedback information, and existing tuning method can not increase substantially access of database speed.
Summary of the invention
In view of this, fundamental purpose of the present invention is to provide a kind of method that realizes the database fast access, makes the user find details apace from the very large database of data volume, to satisfy actual needs.
For reaching above purpose, technical scheme of the present invention is achieved in that a kind of method that realizes the database fast access, and this method may further comprise the steps:
A. set up more than one tables of data according to querying condition, and unique tables of data identification information corresponding to described querying condition is set for each tables of data;
B. all database informations are kept at respectively in the corresponding tables of data according to described querying condition, and unique record identification is set for every database information, this record identification is kept in the corresponding data table, and sets up the internal memory concordance list of preserving database information record identification and tables of data identification information corresponding relation;
C. after receiving the Query Information of the value that comprises described querying condition, from tables of data, obtain the pairing record identification of the database information that meets this Query Information according to described value, and the record identification obtained formed record identification collection more than or equal to one, inquire about the tables of data at each record identification centralized recording sign place according to the internal memory concordance list, from tables of data, obtain the database information of record identification correspondence, and all database informations that each record identification set pair is answered send to the user respectively.
Among the described step c, concentrate the database information of all record identification correspondences to be kept in the packet record identification, and this packet is sent to the user.
This method may further include, the mutual database management module (DBDaemon) of setting and user and database in database is then set up the internal memory concordance list of preserving database information record identification and tables of data identification information corresponding relation by DBDaemon among the step b; Among the described step c, by DBDaemon receive Query Information, obtain record identification and generate the record identification collection, from the internal memory concordance list query note sign place tables of data, obtain the database information of record identification correspondence, and database information is sent to the user.
Time according to every database information input database is that every database information is provided with record identification.
Among the described step b, the number of the record identification that the record identification collection comprised is set according to the volume of transmitted data of network and the data volume that is kept at the information in the tables of data.
Among the described step a, set up tables of data according to the unit interval, among the described step b, all database informations were kept at respectively in the corresponding tables of data according to the unit interval.
The described unit interval is one day.
Described database is the short message data storehouse.
The present invention program has following beneficial effect:
1) by a plurality of tables of data are set for database, all information is kept at respectively in these tables of data, can improves inquiry velocity, and be convenient to deposit tables of data in database the database of big data quantity;
2) be divided into a plurality of record identification collection by the record identification that will obtain, the maximum transmitted amount that makes database can make full use of network is transmitted details;
3) be used to preserve the internal memory concordance list of the corresponding relation of tables of data and record identification by foundation, foundation is to the index copy of entire database, make database obtain the tables of data at institute information inquiring place by this internal memory concordance list, and realization is to the scanning of all tables of data in the database, so that from tables of data, obtain database information apace, further improved inquiry velocity to the database of big data quantity.
Description of drawings
Fig. 1 is the realization flow figure of the embodiment of the invention.
Embodiment
Below in conjunction with drawings and the specific embodiments the present invention program is described in further detail.
With the example that is treated to the short message data storehouse, referring to Fig. 1, the present invention program realizes by following steps:
For reducing when obtaining the short message details to the required time of short message data storehouse scanning, a plurality of tables of data need be set, and unique identification information is set for each tables of data correspondence, the details of short message are kept in these tables, the short message details can comprise the calling and called address information, submit to and issue the time, mobile switching centre (MSC) address, encoding scheme and type etc., when the short message details are saved in tables of data, also need a unique record identification be set at every short message, and this record identification is kept in the short message data storehouse with the short message details, this record identification can be set to increase in proper order according to the short message entry time.When tables of data is set, can be for a tables of data be set every day, this tables of data writes down all short message details on the same day, and the short message details can deposit in the tables of data successively according to its time that is submitted to database.
This DBDaemon interface need be set up an internal memory concordance list, and this internal memory concordance list is kept in the internal memory.The corresponding relation of keeping records sign and tables of data in this internal memory concordance list.Such as, comprise in the tables of data that record identification is 1 to 10 short message, this tables of data be designated a, then preserve the corresponding relation of this tables of data a and record identification 1 to 10 in the internal memory concordance list.
The querying condition of user's input can comprise information such as caller phone number and fixed time section, if comprise the fixed time section in the querying condition, then the DBDaemon interface inquires the pairing record identification of the short message that meets this querying condition from the pairing tables of data of this fixed time section, such as, it is that 12345 cellphone subscriber is in July 1 that the user needs the inquiring calling number, 2, the details of three days on the 3rd the short message that is sent, then the user sends to the DBDaemon interface with cell-phone number and date, after the DBDaemon interface is received Query Information, from the short message data storehouse with July 1,2, obtained the record identification of the short message correspondence of 12345 users transmission in the corresponding tables of data on the 3rd; If there is not the fixed time section in the querying condition, then the DBDaemon interface need inquire the pairing record identification of the short message that meets this querying condition from all tables of data, such as, it is the details of 12345 the short message that the cellphone subscriber sent that the user needs the inquiring calling number, then the user sends to the DBDaemon interface with cell-phone number, and the DBDaemon interface obtains the record identification of the short message correspondence of 12345 users transmission from all tables of data in short message data storehouse.
In general, the data volume of the information that the user need obtain is bigger, and present agreement has been stipulated data quantity transmitted in the network, therefore DBDaemon possibly can't directly send to the user with all data that inquire, and, user place network allows often also little than the agreement regulation of the data volume that once sends, and at this situation, the present invention program adopts DBDaemon that the pairing short message information of record identification is transferred to the user several times.All record identifications of the user inquiring condition that meets that DBDaemon at first will obtain in step 103 are divided into several record identification collection, and respectively each record identification collection are handled.Specifically, because the size of data of each short message information is similar, therefore can be according to the size of every short message information and the maximum transmission data amount of network, all record identifications are divided into a plurality of record identification collection, and pairing all the short message details of each record identification collection can once transfer out by network.When the record identification collection is handled, at first judge the tables of data at concentrated each the record identification place of this record identification according to the internal memory concordance list, from this tables of data, obtain the short message details, and the short message details of obtaining are kept in the packet.After the short message details of obtaining concentrated all the record identification correspondences of this record identification, the packet of preserving these short message details is sent to the user.
Below only be preferred embodiment of the present invention, not in order to restriction protection scope of the present invention.
Claims (8)
1. a realization is characterized in that to the method for database fast access this method may further comprise the steps:
A. set up more than one tables of data according to querying condition, and unique tables of data identification information corresponding to described querying condition is set for each tables of data;
B. all database informations are kept at respectively in the corresponding tables of data according to described querying condition, and unique record identification is set for every database information, this record identification is kept in the corresponding data table, and sets up the internal memory concordance list of preserving database information record identification and tables of data identification information corresponding relation;
C. after receiving the Query Information of the value that comprises described querying condition, from tables of data, obtain the pairing record identification of the database information that meets this Query Information according to described value, and the record identification obtained formed record identification collection more than or equal to one, inquire about the tables of data at each record identification centralized recording sign place according to the internal memory concordance list, from tables of data, obtain the database information of record identification correspondence, and all database informations that each record identification set pair is answered send to the user respectively.
2. method according to claim 1 is characterized in that among the described step c, concentrates the database information of all record identification correspondences to be kept in the packet record identification, and this packet is sent to the user.
3. method according to claim 1, it is characterized in that this method further comprises, the mutual database management module DBDaemon of setting and user and database in database then sets up the internal memory concordance list of preserving database information record identification and tables of data identification information corresponding relation by DBDaemon among the step b; Among the described step c, by DBDaemon receive Query Information, obtain record identification and generate the record identification collection, from the internal memory concordance list query note sign place tables of data, obtain the database information of record identification correspondence, and database information is sent to the user.
4. method according to claim 1 is characterized in that, according to time of every database information input database be that every database information is provided with record identification.
5. method according to claim 1 is characterized in that among the described step b, and the number of the record identification that the record identification collection comprised is set according to the volume of transmitted data of network and the data volume that is kept at the information in the tables of data.
6. method according to claim 1 is characterized in that among the described step a, sets up tables of data according to the unit interval, among the described step b, all database informations is kept at respectively in the corresponding tables of data according to the unit interval.
7. method according to claim 6 is characterized in that, the described unit interval is one day.
8. method according to claim 1 is characterized in that, described database is the short message data storehouse.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB031532845A CN100371931C (en) | 2003-08-13 | 2003-08-13 | Method for realizing quick-accessing database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB031532845A CN100371931C (en) | 2003-08-13 | 2003-08-13 | Method for realizing quick-accessing database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1581161A CN1581161A (en) | 2005-02-16 |
| CN100371931C true CN100371931C (en) | 2008-02-27 |
Family
ID=34580001
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB031532845A Expired - Fee Related CN100371931C (en) | 2003-08-13 | 2003-08-13 | Method for realizing quick-accessing database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100371931C (en) |
Families Citing this family (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100383787C (en) * | 2005-03-17 | 2008-04-23 | 华为技术有限公司 | Multi-chart information initializing method of database |
| CN100428232C (en) * | 2006-01-26 | 2008-10-22 | 北京和利时系统工程有限公司 | Quick and safe real-time database access method |
| CN1984354B (en) * | 2006-04-13 | 2010-07-07 | 华为技术有限公司 | Method and device for managing user account resource |
| CN100403314C (en) * | 2006-04-19 | 2008-07-16 | 华为技术有限公司 | Data inquiry method |
| CN100416568C (en) * | 2006-09-14 | 2008-09-03 | 南京中兴软创软件有限公司 | Method for accelerating database searching speed |
| CN101459529B (en) * | 2007-12-11 | 2010-10-20 | 中国移动通信集团公司 | Method and device for obtaining user data from home location register |
| CN101739523B (en) * | 2009-11-25 | 2013-02-27 | 金蝶软件（中国）有限公司 | Data permission control method and device |
| CN101957853B (en) * | 2010-09-20 | 2013-08-07 | 中兴通讯股份有限公司 | Minimum index identifier ID searching method and device |
| CN102323923B (en) * | 2011-05-18 | 2013-07-24 | 北京百纳威尔科技有限公司 | Method for processing historical record and equipment |
| CN102855254A (en) * | 2011-06-30 | 2013-01-02 | 北京新媒传信科技有限公司 | Method and system for user data storage |
| CN109976968A (en) * | 2017-12-27 | 2019-07-05 | 航天信息股份有限公司 | A kind of method, apparatus, medium and equipment obtaining database variation table data |
| CN110321344B (en) * | 2019-05-20 | 2024-03-15 | 深圳市晶测科技有限公司 | Information query method and device for associated data, computer equipment and storage medium |
| CN113568916A (en) * | 2021-07-30 | 2021-10-29 | 中国银行股份有限公司 | Data table segmentation method and device, electronic equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0749081A1 (en) * | 1995-06-12 | 1996-12-18 | Pointcast Inc. | Information and advertising distribution system and method |
| JPH1091644A (en) * | 1996-09-10 | 1998-04-10 | Oki Electric Ind Co Ltd | Method and device for processing data base query |
| US5893110A (en) * | 1996-08-16 | 1999-04-06 | Silicon Graphics, Inc. | Browser driven user interface to a media asset database |
| JP2001028001A (en) * | 1999-07-15 | 2001-01-30 | Nec Corp | Method for keyword retrieval over multiple tables |
| US20020049740A1 (en) * | 2000-08-17 | 2002-04-25 | International Business Machines Corporation | Method and system for detecting deviations in data tables |
| US20030078915A1 (en) * | 2001-10-19 | 2003-04-24 | Microsoft Corporation | Generalized keyword matching for keyword based searching over relational databases |
-
2003
- 2003-08-13 CN CNB031532845A patent/CN100371931C/en not_active Expired - Fee Related
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0749081A1 (en) * | 1995-06-12 | 1996-12-18 | Pointcast Inc. | Information and advertising distribution system and method |
| US5893110A (en) * | 1996-08-16 | 1999-04-06 | Silicon Graphics, Inc. | Browser driven user interface to a media asset database |
| JPH1091644A (en) * | 1996-09-10 | 1998-04-10 | Oki Electric Ind Co Ltd | Method and device for processing data base query |
| JP2001028001A (en) * | 1999-07-15 | 2001-01-30 | Nec Corp | Method for keyword retrieval over multiple tables |
| US20020049740A1 (en) * | 2000-08-17 | 2002-04-25 | International Business Machines Corporation | Method and system for detecting deviations in data tables |
| US20030078915A1 (en) * | 2001-10-19 | 2003-04-24 | Microsoft Corporation | Generalized keyword matching for keyword based searching over relational databases |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1581161A (en) | 2005-02-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100371931C (en) | Method for realizing quick-accessing database | |
| CN104113466A (en) | Harassing phone call identification method, client, server and system | |
| CN1126323C (en) | Managing group IP addresses in mobile end stations | |
| US20020083044A1 (en) | Method and system for wireless database management | |
| CN101594601B (en) | Charging method and device and system thereof | |
| CN101141484A (en) | Method, device and system of processing network directional data | |
| CN109118360B (en) | Block chain account checking method, device, equipment and storage medium | |
| CN101754189A (en) | Method for realizing multiple-card-one-number service, device and system thereof | |
| CN103024008A (en) | Data transmission method, device and system in internet of things | |
| CN1630418B (en) | Method and system for subscriber service management | |
| CN102340767A (en) | Realization method for opening call state capability and system | |
| CN102694933B (en) | Call transfer system and call transfer method | |
| CN101621748A (en) | Realization method for mobile virtual private network group business of cross-business control point and device | |
| CN101729929B (en) | System for accessing mass data with intelligent network business libraries, device and method | |
| CN101567944A (en) | Interaction voice response system and realization method thereof | |
| CN104580421A (en) | Server and user group information pushing method adopting same | |
| CN106982126A (en) | A kind of resource-sharing charging method and message accounting, memory bank | |
| CN101094449A (en) | Method for addressing user home gateway of short message, and service system of short message | |
| CN101170734B (en) | Method and device for service intercommunication between different networks | |
| CN106504021A (en) | A kind of network marketing flat based on advertisement pushing | |
| Ma et al. | Mobile RFID with IPv6 for phone services | |
| CN103186553B (en) | The querying method of service product and system in a kind of value-added service | |
| CN101841606A (en) | CRBT (Color Ring Back Tone) system and music box management method and equipment | |
| CN101754158B (en) | Method for transmitting user data by trans-regional virtual net and system thereof | |
| CN1829262B (en) | Apparatus and method for realizing to display switchboard number when virtual switchboard mobile extension calling |
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 | ||
| C17 | Cessation of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20080227 Termination date: 20130813 |