CN100371931C - Method for realizing quick-accessing database - Google Patents

Method for realizing quick-accessing database Download PDF

Info

Publication number
CN100371931C
CN100371931C CN 03153284 CN03153284A CN100371931C CN 100371931 C CN100371931 C CN 100371931C CN 03153284 CN03153284 CN 03153284 CN 03153284 A CN03153284 A CN 03153284A CN 100371931 C CN100371931 C CN 100371931C
Authority
CN
China
Prior art keywords
database
information
record
data
table
Prior art date
Application number
CN 03153284
Other languages
Chinese (zh)
Other versions
CN1581161A (en
Inventor
孟 李
暄 王
马家明
Original Assignee
华为技术有限公司
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 华为技术有限公司 filed Critical 华为技术有限公司
Priority to CN 03153284 priority Critical patent/CN100371931C/en
Publication of CN1581161A publication Critical patent/CN1581161A/en
Application granted granted Critical
Publication of CN100371931C publication Critical patent/CN100371931C/en

Links

Abstract

本发明公开了一种实现对数据库快速访问的方法,该方法为每条信息设置唯一的记录标识,建立一个以上用于保存信息的数据表,并为每个数据表设置唯一的标识信息,建立保存记录标识与数据表对应关系的内存索引表;数据库接收到查询信息后,从数据表中获取与该查询信息所对应的信息的记录标识,并将获取的记录标识组成至少一个的记录标识集;根据内存索引表查询每个记录标识集中的记录标识所在的数据表,从数据表中获取记录标识对应的信息,并将该记录标识集对应的所有信息发送给用户。 The present invention discloses a method for rapid access to the database, which is provided for each unique record identification information, to establish a data table for storing the above information, and set the identification information unique to each of the data table, the establishment of identifying data record stored table corresponding to the relationship between the index table memory; after receiving the query information database, obtaining identification information recorded information corresponding to the query from the data table, and records the acquired identifier into at least one set of the record identifier ; according to the memory table lookup index identifies each record in the data tables identifying where the set of records, acquiring recording information corresponding to the ID from the data table, and transmits all of the record identification information set corresponding to the user. 本发明解决了现有技术中数据库在数据量很大时访问速度很慢的问题,实现了对数据库的快速访问。 The invention solves the prior art when a large amount of data in the database access speed is very slow problem, achieve rapid access to the database.

Description

一种实现对数据库快速访问的方法技术领域本发明涉及数据库访问技术领域,更确切地说是涉及一种实现对数据库快速i方问的方法。 TECHNICAL FIELD one implementation of fast access to the database of the present invention relates to the field of database access technology, and more particularly, to a database to achieve fast Q i square method. 背景技术随着科学技术的飞速发展,数据库已经普遍应用于各种领域,对数据库访问速度的要求也越来越高。 BACKGROUND With the rapid development of science and technology, the database has been widely used in various fields of the database access speed requirements are also increasing. 以通信领域为例,现在人们越来越多地使用短消息进行日常通信,短消息通信已经成为主要的通讯手段之一。 To the field of communications, for example, it is now increasingly using short messages daily communication, short messaging has become one of the main means of communication. 根据实际维护需要,需要将最近一段历史时期的短消息保存在短消息数据库中,目前的短消息数据库只建立一张数据表,所有的短消息都保存在这张数据表中。 According to the actual maintenance needs, SMS recent historical period of the short message needs to be saved in the database, the current short message database only to establish a data table, all of the short messages are stored in this table. 一般来说,短消息数据库需要至少保存三个月的历史数据,而每天都有5000万条甚至更多的短消息需要记录在短消息数据库的数据表中,因此数据表中的数据量非常大,将这么大的数据表存入数据库非常困难。 In general, the short message database need to save at least three months of historical data, and every day 50 million or more short message needs to be recorded in the data table in the SMS database, so the amount of data is very large table It will be so much data stored in the database table is very difficult. 如果用户需要对指定用户的短消息发送情况进行跨天查询,则局方维护人员需要在短消息数据库的数据表中查询所有的数据,以找出用户需要的话单记录,显然,在如此庞大的数据表中查找数据非常困难。 If you need a short message to the specified user to send the case for cross-day inquiry, the Bureau maintenance personnel need to check all the data in the data table short message database to identify user needs, then a single record, obviously, in such a large data table lookup data is very difficult. 而用户在进行查询时对短消息数据库的响应速度要求较高,需要短消息数据库能在较短的时间内返回查询结果。 While the response speed of the user during a query of the database demanding short message, the short message needs to query the database to return the results in a short time. 因此,现有的短消息数据库组织方式很难满足用户快速获取查询信息的要求。 Therefore, the existing short message database organization difficult to meet the requirements of users quick access to information inquiries. 为实现对短消息数据库的调优,目前业界提出了对短消息数据库的参数进行调整、在数据表上建立索引、使用硬件来分担磁盘I/O等方法,但是由于短消息数据库非常庞大,通过上述方法对短消息数据库调优时,不能明显地提高短消息数据库的访问速度。 To achieve tuning of the short message database, the industry put forward the parameters of the short message database to adjust, indexing, using hardware in the data table to share the disk I / O and other methods, but due to the short message database is very large, by the method of the above short message database tuning, does not significantly increase the speed of the short message database. 并且,在将获取到的短消息详细信息发送给用户时,由于所要发送的短消息详细信息的数据量可能非常大,而用户所在的网络可能无法传输如此大的数据,则将出现丟包的现象,即使网络可以传输这个数据包,也会因所要传输的短消息详细信息的数据量非常大而影响整个网络中数据的传输。 Further, when the acquired short message sending detailed information to the user, since the amount of data a short message to be sent detailed information can be very large, and the network where the user may not transfer so much data loss will occur phenomenon, even if the network can transmit the packet, also due to the amount of data short messages for detailed information is to be transmitted very large to affect the transmission of data across the network. 因此现有的短消息数据库不能满足短消息业务的实际需要。 Therefore, the existing short message database does not meet the actual needs of the short message service. 综上所迷,现有的大数据量数据库的访问速度已经不能满足业务对数据库快速反馈信息的要求,而现有的调优方法不能大幅度提高数据库的访问速度。 Summing up the fans, the access speed of the existing database of large amounts of data can not meet the requirements of the business fast feedback information to the database, and the existing tuning method can not significantly improve access to the database. 发明内容有鉴于此,本发明的主要目的在于提供一种实现对数据库快速访问的方法,使用户能够快速地从数据量非常大的数据库中查找到详细信息,以满足实际需要。 SUMMARY OF THE INVENTION Accordingly, the main object of the present invention is to provide a method to achieve fast access to the database, enables the user to quickly find a very large amount of data from the database and the detailed information, in order to meet the actual needs. 为达到以上目的,本发明的技术方案是这样实现的: 一种实现对数据库快速访问的方法,该方法包括以下步骤:a. 根据查询条件建立一个以上的数据表,并为每个数据表设置唯一的对应于所述查询条件的数据表标识信息;b. 将所有的数据库信息按照所述查询条件分别保存在相应的数据表中,.并为每条数据库信息设置唯一的记录标识,将该记录标识保存在相应数据表中, 并建立保存数据库信息记录标识与数据表标识信息对应关系的内存索引表;c. 接收到包含所述查询条件的值的查询信息后,根据所述值从数据表中获取符合该查询信息的数据库信息所对应的记录标识,并将获取的记录标识组成大于等于一个的记录标识集,根据内存索引表查询每个记录标识集中记录标识所在的数据表,从数据表中获取记录标识对应的数据库信息,并将每个记录标识集 To achieve the above object, the technical solution of the present invention is implemented as follows: A method for rapid access to the database implementation, the method comprising the steps of:. A data table to establish one or more filter criteria, and the data table is provided for each the only condition corresponding to the query data table identification information; B all information in the database of the query conditions are stored in the corresponding data table and database information for each unique record identifier is provided, the. recording identification data stored in the corresponding table, and establishing the stored database information recording memory index table identifies the data table identification information corresponding relationship;. c after receiving the query message containing the value query condition according to the data values ​​from the obtaining table information matches the query information database corresponding to the record identifier, and records the acquired identifier consisting of not less than a set of identity record, each record in the query identified collectively recorded in accordance with the identification data table memory where the index table, the data from the Get the information recording table corresponding to the ID database, and each record set identifier 应的所有数据库信息分别发送给用户。 All database information should be sent to the user, respectively.

所述步骤C中,将记录标识集中所有记录标识对应的数据库信息保存在数据包中,并将该数据包发送给用户。 Said step C, the centralized database record identification information of all the records corresponding to the ID stored in the packet, and the packet is sent to the user.

该方法可以进一步包括,在数据库中设置与用户及数据库交互的数据库管 The method may further comprise, arranged to interact with the user and the database in the database Database

理模块(DBDaemon ),则步骤b中由DBDaemon建立保存数据库信息记录标识与数据表标识信息对应关系的内存索引表;所述步骤c中,由DBDaemon接收查询信息、获取记录标识并生成记录标识集、从内存索引表中查询记录标识所在的数据表、获取记录标识对应的数据库信息,并将数据库信息发送给用户。 Management Module (DBDaemon), then step b established and stored database information recording memory index table identifies the data table identification information corresponding relationship by DBDaemon; said step (c), the DBDaemon receiving query information, and generates the acquired record identification record set identifier query the index table from memory table identifies where the data is recorded, and obtaining information database record corresponding to the ID, and transmits the information to the user database.

根据每条数据库信息输入数据库的时间为每条数据库信息设置记录标识。 Each database record identification information is provided for each database based on the time information is entered into the database.

所述步骤b中,根据网络的数据传输量及保存在数据表中的信息的数据量设置记录标识集所包含的记录标识的个数。 Step b, the identification number of records contained in a record identification set amount set according to the amount of data transmission and data stored in the data table of the network information.

所述步骤a中,根据单位时间建立数据表,所述步骤b中,将所有的数据库信息按照单位时间分别保存在相应的数据表中。 In the step a, the establishment of a data table according to the unit time, said step (b), all the information in the database unit time are stored in the corresponding data table.

所述单位时间是一天。 The unit time is one day.

所述数据库是短消息数据库。 The database is a database message.

本发明方案具有以下有益效果: Embodiment of the present invention has the following advantages:

1) 通过为数据库设置多个数据表,将所有信息分别保存在这些数据表中,可以提高对大数据量的数据库的查询速度,且便于将数据表存入数据库; 1) By providing a plurality of data tables for the database, all the information are stored in the data table, can speed up the search of a large amount of data in the database, and to ease the data table stored in the database;

2) 通过将获取的记录标识划分为多个记录标识集,使数据库可以充分利用网络的最大传输量来传输详细信息; 2) identified by the acquired record is divided into a plurality of sets identification record, so that the database can take advantage of the maximum transmission capacity of the network to transmit details;

3) 通过建立用于保存数据表与记录标识的对应关系的内存索引表,建立对整个数据库的索引拷贝,使数据库可以通过该内存索引表获取所查询的信息所在的数据表,并实现对数据库中所有数据表的扫描,以便快速地从数 3) by creating a memory index table for the stored corresponding relationship between data tables and records identified, copying of the entire index database so that the database can be queried to obtain data where the table information through the index table memory, and to realize the database All scanning data table to quickly from several

据表中获取数据库信息,进一步提高了对大数据量的数据库的查询速度。 According to the table to get database information to further improve query speed for a large amount of data in the database. 附图说明 BRIEF DESCRIPTION

图1为本发明实施例的实现流程图。 1 implemented flowchart of an embodiment of the present invention. 具体实施方式 Detailed ways

下面结合附图及具体实施例对本发明方案作进一步详细的说明,, 以对短消息数据库的处理为例,参见图1,本发明方案通过以下步骤实 The following accompanying drawings and specific embodiments of the present invention will be further described in detail ,, the database to process the short message as an example, see FIG. 1, the steps of the present invention by solid

现: Now:

步骤IOI、为短消息数据库建立多个数据表。 Step IOI, multiple data tables a short message database.

为减少在获取短消息详细信息时对短消息数据库扫描所需的时间,需要设置多个数据表,并为每个数据表对应设置唯一的标识信息,将短消息的详细信息保存在这些表中,短消息详细信息可以包括主被叫地址信息、提交和下发时间、移动交换中心(MSC)地址、编码方案和类型等,在将短消息详细信息保存到数据表时,还需要针对每条短消息设置一个唯一的记录标识, 并将该记录标识与短消息详细信息一起保存在短消息数据库中,该记录标识可以设置为根据短消息入库时间顺序增加。 In order to reduce the short message to obtain detailed information on the time required for the short message database scan is necessary to provide a plurality of data tables, and sets the unique identification information for each data table corresponding to the details of the short message stored in these tables , the short message may include details of calling and called address information, and issued submission time, the mobile switching center (MSC) address, type of coding scheme and the like, when the short message is saved to a data table for more information, needed for each message identification is provided a unique record, and the record identifier and message details information stored in the database together with the short message, the record identifier may be provided to increase the storage time of the short message sequence. 在设置数据表时,可以为每天设置一个数据表,该数据表记录当天的所有短消息详细信息,短消息详细信息可以根据其提交到数据库的时间依次存入数据表中。 When setting the data table, a data table may be provided per day, all of the data table records details of day message, the short message details may be sequentially stored in the data table according to the time of its submission to the database.

步骤102、建立短消息的数据库管理接口(DBDaemon)。 Step 102, establishing a short-message database management interface (DBDaemon).

此DBDaemon接口需要建立一个内存索引表,并将该内存索引表保存在内存中。 This DBDaemon interfaces need to create a memory index table, and save the memory index table in memory. 该内存索引表中保存记录标识与数据表的对应关系。 The index table stored in memory records correspondence between the identifier and the data table. 比如, 一个数据表中包括记录标识为1到IO的短消息,该数据表的标识为a,则内存索引表中保存该数据表a与记录标识1到IO的对应关系。 For example, a data table including a record identification of a short message to the IO, the identification of a data table, the index table stored in the memory corresponding to a relationship between the Table 1 identifies the recording to the IO.

步骤103、用户通过DBDaemon接口输入查询条件,DBDaemon接口根据该查询条件获取符合条件的所有记录标识。 Step 103, the user query, the interface DBDaemon All recordings were acquired according to the identified qualified by DBDaemon query interface input.

用户输入的查询条件可以包括主叫手机号码和指定时间段等信息,如果 Query entered by the user may include information about the caller's phone number and the specified time range, if

查询条件中包括指定时间段,则DBDaemon接口从该指定时间段所对应的数据表中查询到符合该查询条件的短消息所对应的记录标识,比如,用户需要查询主叫号码为12345的手机用户在7月1、 2、 3日三天的所发送的短信息的详细信息,则用户将手机号和日期发送给DBDaemon接口, DBDaemon 接口收到查询信息后,从短消息数据库中与7月1、 2、 3日对应的数据表中获取12345用户发送的短信息对应的记录标识;如果查询条件中没有指定时间段,则DBDaemon接口需要从所有数据表中查询到符合该查询条件的短消息所对应的记录标识,比如,用户需要查询主叫号码为12345的手机用户所发送的短信息的详细信息,则用户将手机号发送给DBDaemon接口, DBDaemon接口从短消息数据库所有的数据表中获取12345用户发送的短信息对应的记录标识。 Query condition includes a specified time period, the Interface Query DBDaemon from the designated time period corresponding to the data table matches the query message corresponding to the record identification, for example, the user needs to query the calling phone number is the user's 12345 after July 1, 2, details of text messages sent on the 3rd day, the user will be sent to the mobile phone number and date of DBDaemon interfaces, DBDaemon interface receives query information from the SMS database and July 1 , 2, 3 corresponding to the data table Gets a short message corresponding to the record identification transmitted by the user 12345; If the query criteria is not specified time period, DBDaemon interfaces need, from all of this data to the short message matches the query criteria being corresponding to the record identification, for example, the user need, calling number 12345 details the short message sent by the user's mobile phone, the user interfaces will be sent to phone number DBDaemon, 12345 DBDaemon interface to obtain a short message from a database of all the data in the table short message sent by the user corresponding to the record identifier.

步骤104 、 DBDaemon根据查询到的记录标识从数据库中获取详细信息, 并发送给用户。 Step 104, DBDaemon obtain more information from the database according to the found record identifier, sent to the user.

一般来说,用户需要获取的信息的数据量比较大,而目前的协议规定了网络中传输的数据量,因此DBDaemon可能无法直接将查询到的所有数掂发送给用户,并且,用户所在网络允许一次发送的数据量往往比协议规定的还要小,针对这种情况,本发明方案采用DBDaemon将记录标识所对应的短消息信息分多次传输给用户。 In general, the data users need to obtain than the larger, and the current agreement specifies the amount of data transmitted over the network, so the number may not be directly DBDaemon all queries to weigh sent to the user, and the user's network allows the amount of data transmitted is often smaller than the predetermined protocol, for this situation, the present invention employs a short message DBDaemon recording identifying information corresponding to the multiple sub-transmission user. DBDaemon首先将在步骤103中获取的符合用户查询条件的所有记录标识分为若干个记录标识集,并分别对每一个记录标识集进行处理。 DBDaemon first acquired in step 103 all records the user ID that meets the query criteria identifying records into several sets, and each set of identification for each record processed. 具体来说,由于每个短消息信息的数据大小相似,因此可以根据每条短消息信息的大小及网络的最大传输数据量,将所有的记录标识划分为多个记录标识集,每个记录标识集所对应的所有短消息详细信息可以通过网络一次传输出去。 Specifically, due to the similarity data size information of each short message, it can be based on the maximum amount of data transmission and network information for each short message, identifies all the records into a plurality of sets identification record, each record identifier All short message details may be set corresponding to the first transmission across the network. 在对记录标识集进行处理时,首先根据内存索引表判断该记录标识集中每个记录标识所在的数据表,从该数据表中获取短消息详细信息,并将获取的短消息详细信息保存在一个数据包中。 When processing of the recording set identification, the index table is first determined according to the memory of the centralized data table for each record identifies where the record identification, message acquiring more information from the data table, and acquires the short message information in a detailed packet. 在获取这个记录标识集中所有记录标识对应的短消息详细信息后,将保存这些短消息详细 After acquiring this short message record identifier identifying the detailed information of all records corresponding to the concentration, these short messages saved Detail

信息的数据包发送给用户。 Packet information to the user.

以上仅为本发明的较佳实施例,并不用以限制本发明的保护范围。 Above is merely the preferred embodiment of the present invention is not intended to limit the scope of the present invention.

Claims (8)

1、一种实现对数据库快速访问的方法,其特征在于该方法包括以下步骤: a.根据查询条件建立一个以上的数据表,并为每个数据表设置唯一的对应于所述查询条件的数据表标识信息; b.将所有的数据库信息按照所述查询条件分别保存在相应的数据表中,并为每条数据库信息设置唯一的记录标识,将该记录标识保存在相应数据表中,并建立保存数据库信息记录标识与数据表标识信息对应关系的内存索引表; c.接收到包含所述查询条件的值的查询信息后,根据所述值从数据表中获取符合该查询信息的数据库信息所对应的记录标识,并将获取的记录标识组成大于等于一个的记录标识集,根据内存索引表查询每个记录标识集中记录标识所在的数据表,从数据表中获取记录标识对应的数据库信息,并将每个记录标识集对应的所有数据库信息分别发送给用户。 1. A method for fast access to the database to achieve, characterized in that the method comprises the steps of:. A data table to establish one or more conditions of the query, and a unique set of data corresponding to the query condition for each data table table identification information;. b all information in the database of the query conditions are stored in the corresponding data table, and set a unique identifier for each database record information, the record identification data stored in the corresponding table, and the establishment of save the database record identification information index table and memory data table identifying the correspondence relationship information; C after receiving the query message comprising said value query condition, acquiring information database matches the query information from the data table based on the value. corresponding to the record identification, and records the acquired identifier consisting of not less than a set of identity record, each record in the query identified collectively recorded in accordance with the identification data table memory where the index table, obtaining the corresponding database record identification information from the data table, and All database information identifying each record set corresponding to the user are transmitted.
2、 根据权利要求1所述的方法,其特征在于所述步骤c中,将记录标识集中所有记录标识对应的数据库信息保存在数据包中,并将该数据包发送给用户。 2. The method according to claim 1, wherein said step (c), the database record identification centralize all information records corresponding to the ID stored in the packet, and the packet is sent to the user.
3、 根据权利要求1所述的方法,其特征在于该方法进一步包括,在数据库中设置与用户及数据库交互的数据库管理模块DBDaemon,则步骤b中由DBDaemon建立保存数据库信息记录标识与数据表标识信息对应关系的内存索引表;所述步骤c中,由DBDaemon接收查询信息、获取记录标识并生成记录标识集、从内存索引表中查询记录标识所在的数据表、获取记录标识对应的数据库信息,并将数据库信息发送给用户。 3. The method according to claim 1, characterized in that the method further comprises, disposed to interact with the user and the database management module DBDaemon database in the database, the database stored in step b establishing a record identification information with the data table identified by DBDaemon correspondence relationship memory index table; said step (c), the DBDaemon receiving query information, and generating a record identifier acquiring identification record set, query the data tables identifying where the record from memory index table, acquires information database record corresponding to the identifier, and sends the information to the user database.
4、 根据权利要求1所述的方法,其特征在于,根据每条数据库信息输入数据库的时间为每条数据库信息设置记录标识。 4. The method of claim 1, wherein the identifying information is provided for each database record for each database in accordance with the time information entered into the database.
5、 根据权利要求1所述的方法,其特征在于所述步骤b中,根据网络的数据传输量及保存在数据表中的信息的数据量设置记录标识集所包含的记录标识的个数。 5. The method according to claim 1, wherein said step (b), provided the number of set recording identifier included in the identified transfer amount and the amount of data stored in the data table information data network.
6、 根据权利要求1所述的方法,其特征在于所述步骤a中,根据单位时间建立数据表,所述步骤b中,将所有的数据库信息按照单位时间分别保存在相应的数据表中。 6. The method of claim 1, wherein said step a, the establishment of a data table according to the unit time, said step (b), all the information in the database unit time are stored in the corresponding data table.
7、 根据权利要求6所述的方法,其特征在于,所述单位时间是一天。 7. The method of claim 6, wherein said unit time is one day.
8、 根据权利要求1所述的方法,其特征在于,所述数据库是短消息数据库。 8. The method of claim 1, wherein said database is a database message.
CN 03153284 2003-08-13 2003-08-13 Method for realizing quick-accessing database CN100371931C (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 03153284 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
CN 03153284 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
CN 03153284 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 (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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

Citations (6)

* Cited by examiner, † Cited by third party
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

Patent Citations (6)

* Cited by examiner, † Cited by third party
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
US5619648A (en) Message filtering techniques
US5802510A (en) Universal directory service
US5742763A (en) Universal message delivery system for handles identifying network presences
US5826039A (en) Universal connection point for resources and communication unrelated to a physical endpoint
US20050131712A1 (en) Method and system to distribute policies
US8495163B2 (en) Method and apparatus for a publish-subscribe system with templates for role-based view of subscriptions
CN101257670B (en) Method, equipment and system for searching and downloading phone file
US6446114B1 (en) Messaging agent and method for retrieving and consolidating messages
CN101216821B (en) Data acquisition system storage management method
EP0258867A2 (en) Multitask subscription data retrieval method
CN1330207C (en) Parameter allocating system and method for mobile station
CN1316325C (en) server
JP4088549B2 (en) Methods in telecommunications networks
RU2357380C1 (en) Method and system for intelligent routing
US8019366B2 (en) Method for processing short message and communication terminal
JP2004172917A (en) Packet retrieving device, packet process retrieving method, and program
US20030018688A1 (en) Method and apparatus to facilitate accessing data in network management protocol tables
US20080189543A1 (en) Method and system for reducing a size of a security-related data object stored on a token
US20140229561A1 (en) Delivering messages from message sources to subscribing recipients
US20140006597A1 (en) Method, system, and device for managing server hardware resources in a cloud scheduling environment
JP4253639B2 (en) System and method for accessing contact information on a communication device
JPH11503000A (en) How to support a non-geographic telephone number and equipment
CN1392704A (en) Selecting synchronous data
US20050209990A1 (en) Method and apparatus for a publish-subscribe system with access controls
US20100015975A1 (en) Profile service for sharing rights-enabled mobile profiles

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