CN103425684A - Method and device for database operation - Google Patents
Method and device for database operation Download PDFInfo
- Publication number
- CN103425684A CN103425684A CN201210157777XA CN201210157777A CN103425684A CN 103425684 A CN103425684 A CN 103425684A CN 201210157777X A CN201210157777X A CN 201210157777XA CN 201210157777 A CN201210157777 A CN 201210157777A CN 103425684 A CN103425684 A CN 103425684A
- Authority
- CN
- China
- Prior art keywords
- database
- intelligent network
- network platform
- user
- facility
- 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.)
- Pending
Links
Images
Landscapes
- Telephonic Communication Services (AREA)
Abstract
The invention discloses a method and device for database operation. The method includes the steps that a first intelligent network platform receives service requests, wherein the service requests carry user identifications of users requesting the operation; the first intelligent network platform inquires first corresponding relations of the user identification scope and databases and determines the databases corresponding to the scope where the user identifications belong; the first intelligent network platform carries out the operation requested by the service requests on data corresponding to the user identifications in the databases. According to the method and device, through the utilization of the corresponding relations of the user identification scope and the databases, the databases to be visited by the intelligent network services can be determined, and the flexible visit to the databases is achieved.
Description
Technical field
The present invention relates to the communications field, in particular to a kind of method of operating and device of database.
Background technology
Intelligent network adopts modular design philosophy, the basic functional units that realizes business is divided into to the building block (Service Independence Block, referred to as SIB) of the business of being independent of, for example, and algorithm, charging, timer etc.SIB is independent of business, can reuse, and the various various combinations of SIB can form different business.The realization of business has been simplified in the introducing of SIB, and while needing to generate new business, service creation environment (SCE), according to new service logic, forms new business by existing SIB link, can develop easily new business.
After having realized the separating of service interaction function and service control function, business is able to centralized control and management.Business datum is kept in large-scale centralized formula database, and business datum is safeguarded and stored.Growth along with mobile subscriber group's quantity, the database scale is increasing, in correlation technique, data is carried out to subregion, and data are put into respectively to different databases, database is dispersed in disparate databases, so just need in intelligent network business, differentiate which database of connected reference.
Summary of the invention
For in correlation technique, intelligent network service data being stored in different databases, can't determine the problem of the database that intelligent network business will be accessed while being operated, the invention provides a kind of method of operating and device of database, at least to address the above problem.
According to an aspect of the present invention, provide a kind of method of operating of database, having comprised: the first intelligent network platform receives service request, wherein, carries the user's of solicit operation to some extent user ID in described service request; The first corresponding relation of described the first intelligent network platform inquiring user sign scope and database, determine the database corresponding with the affiliated scope of described user ID; Described the first intelligent network platform carries out to data corresponding with described user ID in described database the operation that described service request is asked.
Preferably, described the first intelligent network platform carries out to described database the operation that described service request is asked, and comprising: described the first intelligent network platform is determined the database facility at described database place; Described the first intelligent network platform is carried out described operation to data corresponding with described user ID in described database on described database facility.
Preferably, described database facility be not described the first intelligent network platform can directly access database facility the time, described the first intelligent network platform is carried out described operation to data corresponding with described user ID in described database on described database facility, comprise: the second corresponding relation of described the first intelligent network platform data query library facilities and intelligent network platform, definite the second intelligent network platform that can directly access the database facility at described database place; Described the first intelligent network platform is carried out described operation by described the second intelligent network platform to data corresponding with described user ID in described database.
Preferably, while having intelligent network platform corresponding to the database facility at a plurality of and described database place in described the second corresponding relation, determine the second intelligent network platform of the database facility that can directly access described database place, comprise: according to the current load of described a plurality of intelligent network platforms, according to the principle of load balancing, from described a plurality of intelligent network platforms, choose described the second intelligent network platform.
Preferably, described the first corresponding relation comprises: user ID scope, service identification and database three's corresponding relation; Also carry the service identification of the business that described service request asks in described service request; Determine the database corresponding with the affiliated scope of described user ID, comprising: described the first intelligent network platform is inquired about described the first corresponding relation, determines the database corresponding with the affiliated scope of described user ID and described service identification while.
Preferably, described user ID comprises: initiate the user's of described business calling number, and/or, the called number of described business; The number segment that described user ID scope is described calling number and/or described called number.
According to a further aspect in the invention, provide a kind of operating means of database, having comprised: receiver module, for receiving service request, wherein, carry the user's of solicit operation to some extent user ID in described service request; Determination module, for the first corresponding relation of inquiring user sign scope and database, determine the database corresponding with the affiliated scope of described user ID; Execution module, carry out for the data corresponding with described user ID to described database the operation that described service request is asked.
Preferably, described execution module comprises: determining unit, for determining the database facility at described database place; Performance element, on described database facility to described database the data corresponding with described user ID carry out described operation.
Preferably, described performance element, also at described database facility, be not the first intelligent network platform can directly access database facility the time, the second corresponding relation of data query library facilities and intelligent network platform, definite the second intelligent network platform that can directly access the database facility at described database place; By described the second intelligent network platform described database facility to described database in the data corresponding with described user ID carry out described operation.
Preferably, described performance element, also for the database facility that has a plurality of and described database place at described the second corresponding relation during corresponding intelligent network platform, determine in such a way the second intelligent network platform of the database facility that can directly access described database place: according to the current load of described a plurality of intelligent network platforms, according to the principle of load balancing, from described a plurality of intelligent network platforms, choose described the second intelligent network platform.
Preferably, described determination module, also, for when described the first corresponding relation comprises user ID scope, service identification and database three's corresponding relation, inquire about described the first corresponding relation, determine the database corresponding with the affiliated scope of described user ID and described service identification while.
Preferably, described user ID comprises: initiate the user's of described business calling number, and/or, the called number of described business; The number segment that described user ID scope is described calling number and/or described called number.
By the present invention, the first intelligent network platform receives service request, carry the user's of solicit operation to some extent user ID in this service request, and the first corresponding relation of inquiring user sign scope and database, determine the database corresponding with the affiliated scope of above-mentioned user ID, data corresponding with above-mentioned user ID in this database are carried out to the operation that service request is asked.Utilize the corresponding relation of user ID scope and database, determine the database that intelligent network business will be accessed, thereby realized the flexible access to database.
The accompanying drawing explanation
Accompanying drawing described herein is used to provide a further understanding of the present invention, forms the application's a part, and schematic description and description of the present invention the present invention does not form inappropriate limitation of the present invention for explaining.In the accompanying drawings:
Fig. 1 is the process flow diagram according to the method for operating of the database of the embodiment of the present invention;
Fig. 2 is the schematic diagram according to the operating means of the database of the embodiment of the present invention;
Fig. 3 is the schematic diagram according to the operating means of the preferred database of the embodiment of the present invention;
Fig. 4 is the schematic diagram according to the locations of structures of the intelligent network platform of the specific embodiment of the invention;
Fig. 5 is the process flow diagram according to the method for operating of the database of the specific embodiment of the invention.
Embodiment
Hereinafter with reference to accompanying drawing, also describe the present invention in detail in conjunction with the embodiments.It should be noted that, in the situation that do not conflict, embodiment and the feature in embodiment in the application can combine mutually.
A kind of method of operating of database is provided according to the embodiment of the present invention, has utilized the corresponding relation of user ID scope and database, determined the database that intelligent network business will be accessed, realized the flexible access of intelligent network business to database.
Fig. 1 is the process flow diagram according to the method for operating of the database of the embodiment of the present invention, and as shown in Figure 1, the method mainly comprises following step (step S102-step S106).
Step S102, the first intelligent network platform receives service request, wherein, carries the user's of solicit operation to some extent user ID in this service request.
Intelligent network business, according to default choosing method, is chosen an intelligent network platform (the first intelligent network platform) from a plurality of intelligent network platforms, and establishes the link with the first intelligent network platform, for example, sets up socket (socket) link.The first intelligent network platform receives service request, obtain the user's that service request asks user ID from service request, for example, according to the signaling of transmitting on intelligent network call, parse user ID from signaling, by the first intelligent network platform, complete corresponding database access operation.
Step S104, the first corresponding relation of the first intelligent network platform inquiring user sign scope and database, determine the database corresponding with the affiliated scope of above-mentioned user ID.
The database of intelligent network can be divided by the user ID scope, can mark off a plurality of databases, the data that will belong to the user of same user ID scope are stored in same database, and the length of user ID scope can be configured according to actual needs.The database marked off can be stored in intelligent network platform, also can be stored in database facility.Can be configured each database, configure database corresponding to each user ID scope, set up the corresponding relation (the first corresponding relation) of user ID scope and database, after intelligent network platform receives service request, can inquire about the first corresponding relation, determine affiliated database corresponding to scope of user ID.
In actual applications, user ID can be the user's of institute's solicit operation number, for example, and the calling number of current calling and/or called number, or the area code of current calling etc.In the situation that user ID is calling number or called number, can carry out partition database by number segment, for example, the intelligent network service data that is the user of " 134 " by the former positions of number is stored in a database.In the situation that user ID is area code, the data that ownership place can be belonged to the user of same area code are stored in a database, can realize carrying out partition database according to area.It should be noted that, the embodiment of the present invention is not limited to above-mentioned several user ID and database partition method, also can adopt according to actual needs other sign to carry out partition database.
The first intelligent network platform can read above-mentioned the first corresponding relation in the internal storage data district in start-up course, at inquiry direct reading out data from internal memory during corresponding relation, thereby improves processing speed.Further, for easy-to-look-up, for each record in the first corresponding relation, can build a cryptographic hash according to corresponding user ID scope and database, to improve search efficiency.
Step S106, the first intelligent network platform carries out to data corresponding with above-mentioned user ID in above-mentioned database the operation that above-mentioned service request is asked.
In actual applications, the database of intelligent network business access can be stored in intelligent network platform, also can be stored in database facility.In the situation that during the database of intelligent network business access is stored in intelligent network platform, the first intelligent network platform is directly accessed the database of local storage, data corresponding with the user ID of solicit operation in database are carried out to the operation that service request is asked, for example, for Ring Back Tone service, the first intelligent network platform can read called subscriber's multimedia bell information in database, and the multimedia bell information read is returned to the intelligent network value-added service.
In the situation that during the database of intelligent network business access is stored in database facility, the first intelligent network platform can be set up many according to library facilities with every number of units and be connected, every connects a corresponding thread/process, and this thread/process is only carried out database manipulation in this connection.The first intelligent network platform can be managed all database manipulation thread/processes, increases or delete database equipment, and the loading and unloading business, the available situation of quantitative check database, keep connection status.
For the database on the data library facilities conducts interviews, after the database of determining access, the database facility at place, all right specified data storehouse.Therefore, in a preferred implementation of the embodiment of the present invention, when the first intelligent network platform carries out to above-mentioned database operation that service request asks, the first intelligent network platform can be determined the database facility at above-mentioned database place, the first intelligent network platform on this database facility in to database the data corresponding with above-mentioned user ID carry out the operation that service request is asked.For example, the first intelligent network platform can, according to the corresponding relation of database and database facility, carry out the database facility at place, specified data storehouse.By this preferred implementation, realized the location of intelligent network business to the data library facilities, make intelligent network business can access the database be stored in database facility.
Intelligent network platform can directly be accessed a data library facilities, between each intelligent network platform, can establish the link.Intelligent network platform keeps keeping and being connected of the database facility of configuration, and connection status can be detected in real time and whether Test database equipment is available, in actual applications, also can be whether available by other functional entity Test database equipment, and testing result is reported to corresponding intelligent network platform, for example, whether available by SMAP Test database equipment, and report testing result by heartbeat message.
In a preferred implementation of the embodiment of the present invention, the established data library facilities be not the first intelligent network platform can directly access database facility the time, the database that need to access in order to access intelligent network business, the first intelligent network platform is on database facility during to data executable operations corresponding with above-mentioned user ID in database, can the data query library facilities and the second corresponding relation of intelligent network platform, determine directly the second intelligent network platform of the database facility at accessing database place, and pass through the second intelligent network platform to data executable operations corresponding with above-mentioned user ID in database.
For example, the first intelligent network platform is according to the corresponding relation of user ID scope and database, the database of determining access is database A, database A is arranged in database facility 1, and the database facility that the first intelligent network platform can directly be accessed is database facility 2, now, the second corresponding relation of the first intelligent network platform data query library facilities and intelligent network platform, determine that directly the database facility of accessing database A is the second intelligent network platform, the first intelligent network platform and the second intelligent network platform establish the link, by the second intelligent network platform accessing database A.
Further, while having intelligent network platform corresponding to the database facility at a plurality of and above-mentioned database place in the second corresponding relation, while determining the second intelligent network platform of the database facility that can directly access above-mentioned database place, can be according to the current load of a plurality of intelligent network platforms of determining, according to the principle of load balancing, from above-mentioned a plurality of intelligent network platforms, choose the second intelligent network platform.
For example, the first intelligent network platform is according to the corresponding relation of user ID scope and database, the database of determining access is database A, database A is arranged in database facility 1, and the database facility that the first intelligent network platform can directly be accessed is database facility 2, now, the second corresponding relation of the first intelligent network platform data query library facilities and intelligent network platform, determine that directly the database facility of accessing database A is intelligent network platform 2 and 3, the first intelligent network platform can be according to the load of intelligent network platform 2 and 3, choose the less intelligent network platform of load according to the load balancing principle, for example, the load of intelligent network platform 2 is less, and the load of intelligent network platform 3 is larger, the first intelligent network platform is using intelligent network platform 2 as the second intelligent network platform, and establish the link with intelligent network platform 2, by intelligent network platform 2 accessing database A.
In actual applications, the database of intelligent network can also be divided by user ID scope and service identification, the same business that will belong to a user ID scope is stored in a database, therefore, in a preferred implementation of the embodiment of the present invention, the first corresponding relation can comprise user ID scope, service identification and database three's corresponding relation.Can also carry the service identification of the business that service request asks in the service request that intelligent network platform receives.The first intelligent network platform determine with above-mentioned user ID under during database corresponding to scope, can inquire about the first corresponding relation, determine the database corresponding with the affiliated scope of user ID and service identification while.
Pass through the embodiment of the present invention, the first intelligent network platform receives service request, carry the user's of solicit operation to some extent user ID in this service request, and the first corresponding relation of inquiring user sign scope and database, determine the database corresponding with the affiliated scope of above-mentioned user ID, data corresponding with above-mentioned user ID in this database are carried out to the operation that service request is asked.Utilize the corresponding relation of user ID scope and database, determine the database that intelligent network business will be accessed, thereby realized the flexible access of intelligent network business to database.
According to the embodiment of the present invention, a kind of operating means of database also is provided, this device can be arranged in intelligent network platform equipment, and also can be arranged in other is entity, in order to realize the method for operating of the database that the above embodiment of the present invention provides.
Fig. 2 is the schematic diagram according to the operating means of the database of the embodiment of the present invention, and as shown in Figure 2, this device mainly comprises: receiver module 10, determination module 20 and execution module 30.Wherein, receiver module 10, for receiving service request, wherein, carry the user's of solicit operation to some extent user ID in this service request; Determination module 20, be coupled with receiver module 10, for the first corresponding relation of inquiring user sign scope and database, determines the database corresponding with the affiliated scope of above-mentioned user ID; Execution module 30, be coupled with determination module 20, for the data corresponding with above-mentioned user ID to above-mentioned database, carries out the operation that service request is asked.
Pass through the embodiment of the present invention, receiver module 10 receives service request, carry the user's of solicit operation to some extent user ID in this service request, and by the first corresponding relation of determination module 20 inquiring users signs scopes and database, determine the database corresponding with the affiliated scope of above-mentioned user ID, data corresponding with above-mentioned user ID in 30 pairs of these databases of execution module are carried out the operation that service request is asked.Utilize the corresponding relation of user ID scope and database, determine the database that intelligent network business will be accessed, thereby realized the flexible access of intelligent network business to database.
In actual applications, the database of intelligent network business access can be stored in intelligent network platform, also can be stored in database facility.In the situation that, during the database of intelligent network business access is stored in intelligent network platform, the first intelligent network platform is directly accessed the database of local storage, and data corresponding with the user ID of solicit operation in database are carried out to the operation that service request is asked.Therefore, in a preferred implementation of the embodiment of the present invention, as shown in Figure 3, execution module 30 can comprise: determining unit 302, for determining the database facility at above-mentioned database place; Performance element 304, on this database facility to above-mentioned database the data executable operations corresponding with above-mentioned user ID.
In the situation that during the database of intelligent network business access is stored in database facility, for the database on the data library facilities conducts interviews, after the database of determining access, database facility that can also place, specified data storehouse.Therefore, in a preferred implementation of the embodiment of the present invention, performance element 304, can also at above-mentioned database facility, be not the first intelligent network platform can directly access database facility the time, the second corresponding relation of data query library facilities and intelligent network platform, determine the second intelligent network platform of the database facility can directly access above-mentioned database place, by the second intelligent network platform above-mentioned database facility to above-mentioned database in the data executable operations corresponding with above-mentioned user ID.
Further, while having intelligent network platform corresponding to the database facility at a plurality of and above-mentioned database place in the second corresponding relation, while determining the second intelligent network platform of the database facility that can directly access above-mentioned database place, can be according to the current load of a plurality of intelligent network platforms of determining, according to the principle of load balancing, from above-mentioned a plurality of intelligent network platforms, choose the second intelligent network platform.Therefore, in a preferred implementation of the embodiment of the present invention, performance element 304, during intelligent network platform that can also be corresponding for the database facility that has a plurality of and above-mentioned database place at above-mentioned the second corresponding relation, according to the current load of above-mentioned a plurality of intelligent network platforms, according to the principle of load balancing, from above-mentioned a plurality of intelligent network platforms, choose the second intelligent network platform.
The database of intelligent network can also be divided by user ID scope and service identification, the same business that will belong to a user ID scope is stored in a database, and the first corresponding relation can comprise user ID scope, service identification and database three's corresponding relation.Can also carry the service identification of the business that service request asks in the service request that intelligent network platform receives.Therefore, in a preferred implementation of the embodiment of the present invention, determination module 20, also for when above-mentioned the first corresponding relation comprises user ID scope, service identification and database three's corresponding relation, inquire about the first corresponding relation determine with above-mentioned user ID under database corresponding to service identification while of scope and the business of asking.
Said method and device below by specific embodiment to the embodiment of the present invention are described.
According to the specific embodiment of the invention, the intelligent network value-added service is according to the intelligent network platform equipment numbering of link, setting up socket with this intelligent network platform links, calling party's calling number or called number are obtained to the database facility information that needs connection, then by the corresponding database facility of intelligent network business platform access, complete corresponding database access operation by this intelligent network platform, and operating result message is transmitted to value-added service by state machine, complete the access of database.
In the specific embodiment of the invention, the database of intelligent network is divided by number segment, can mark off a plurality of database facilities, by SMAP (Service Management Agent Point, referred to as SMAP) each database facility is configured, configure the database facility of each card number section correspondence, and corresponding relation is added in the management database of SMAP, corresponding relation is write in a card number segment file simultaneously, this document records minimum length and the maximum length that the first row is described total total how many records and card number section, below respectively record record successively: service key, the card number section, the information such as database facility numbering.Every number of units is according to the corresponding data library facilities numbering of library facilities (dbid), i.e. the IP node number of this equipment.
Intelligent network platform comprises service data function (Service Data Function, referred to as SDF) module, the operating means that is equivalent to the database of the above embodiment of the present invention, be responsible for access and the encapsulation operation to database, and the message of distribution operating database.An intelligent network platform only is installed on an equipment, is established link between different intelligent network platforms and just can intercom mutually afterwards.Intelligent network platform and database (Data Base, referred to as DB) can be on same equipment, also can be on different equipment.A SDF module can only establish the link with a database, and the SDF module can be set up many according to library facilities with every number of units and be connected, and every connects a corresponding thread/process, and this thread/process is only carried out database manipulation in this connection.The SDF module is in charge of all database manipulation thread/processes, increases or delete database equipment, and the loading and unloading business, the available situation of quantitative check database, keep connection status.
A database can be by a plurality of intelligent network platform equipment links and accesses, can safeguard the relation table of a database and intelligent network platform equipment, database and intelligent network platform equipment can be the relations of one-to-many simultaneously, and intelligent network platform equipment adopts stacking mode.A data library facilities is recorded all intelligent network platform equipments simultaneously.Intelligent network platform is to be responsible for processing and carrying out intelligent network business, and can access a plurality of databases.SMAP is when the management intelligent equipment, relation table is synchronized in the facility information file, this document records the first row and describes total total how many records, below respectively record record successively: the information such as database facility numbering, service key, intelligent network platform equipment chained list, an intelligent network platform equipment can only link a database.
The intelligent network value-added service provides replacement linked database device numbering dbid(intelligent network platform equipment numbering) algorithm SIB, as input parameter, inquire the database facility numbering dbid of this number according to called number (or calling number) and service key (being service identification).The intelligent network business platform, when just starting, can read in the card number segment file in the internal storage data district, and each record is according to corresponding service key and a card number Duan Jianyi Hash (hash) value, easy-to-look-up, to improve search efficiency., the facility information file is also read in the internal storage data district, each record is built a hash value according to corresponding service key and database facility numbering dbid simultaneously.
Intelligent network business is in needs replacement linked database device numbering dbid(intelligent network platform equipment numbering) time, intelligent network platform is according to call number (calling number or called number) and service key, go to inquire about card number section internal storage data district, inquire corresponding database facility numbering dbid, then according to service key and the database facility numbering dbid inquired, inquiry apparatus information internal storage data district, inquire the linked database device numbering.For a plurality of intelligent network platform equipments, by the mode of load balancing, select the linked database device numbering (intelligent network platform equipment numbering) of an intelligent network platform equipment.The dbid of the database link of intelligent network value-added service is reset to the intelligent network platform equipment numbering inquired, with the intelligent network platform equipment visit data library facilities by finding.IN DataBase is by the intelligent network platform schedule access, and whether SMAP SMAP can regularly make up one's mind to jump onto to each intelligent network platform equipment and report all database facility linking status normal.
Below in conjunction with Fig. 4, the browsing process of the database of the embodiment of the present invention is described, in Fig. 4, if that the new call number of value-added service number on intelligent network platform equipment 101 need to be accessed is database D B1, what directly find out is the device numbering of oneself, directly accessing database DB1.If the intelligent network value-added service on intelligent network platform equipment 101 needs accessing database DB2, can find according to call number section and service key the database facility numbering of database D B2, then according to database facility numbering and service key, find the numbering of intelligent network platform equipment 102, and the device numbering of intelligent network platform equipment 102 (linked database DB2) is reset to the database facility linked numbering, the value-added service on intelligent network platform equipment 101 just can be passed through intelligent network platform equipment 102 accessing database DB2.At database D B2, corresponding intelligent network platform equipment is more than one, for example, while comprising intelligent network platform equipment 102 and intelligent network platform equipment 103, can be according to load-balancing algorithm, difference on intelligent network platform equipment 101 is called out, selection intelligent network platform equipment 102 or intelligent network platform equipment 103 accessing database DB2 that can rotation.
Below in conjunction with Fig. 5, the embodiment of the present invention is described.
Fig. 5 is the process flow diagram according to the method for operating of the database of the specific embodiment of the invention, and as shown in Figure 5, the method can comprise following step (step S502-step S514):
Step S502., the corresponding relation of configuration card number section and database;
Step S504, the corresponding relation of configuration intelligent network platform and database;
In above-mentioned steps S502 and step S504, can pass through SMAP SMAP interface configurations card number section table corresponding to database relation, then configure the corresponding table of intelligent network platform link data base relation, SMAP SMAP is synchronized to the corresponding table of two relations in file, is issued in each intelligent network platform.
Step S506, value-added service inquiry called number multimedia bell information;
Step S508, intelligent network platform is according to called number and service key inquiry card number segment file;
Step S510, intelligent network platform inquires connection data library facilities numbering;
Step S512, intelligent network platform replacement linked database device numbering;
Step S514, the intelligent network platform accessing database.
In the specific embodiment of the invention, the multimedia bell information of inquiry called number in value-added service of take is example, in above-mentioned steps S506-step S514, the intelligent network platform of value-added service is according to called number and service key inquiry card number segment file, inquire corresponding database numbering, then in the intelligent network platform equipment numbering according to database numbering and service key query link database.Value-added service is just removed accessing database by the intelligent network platform equipment numbering inquired, and this called number relevant information just exists in this database.
By the embodiment of the present invention, in intelligent network business, for the big data quantity user, database distributed store, accessing database that can be flexible, efficient, correct.In same value-added service, the database of change that can be random access, access a plurality of different databases, makes the intelligent network business development more and more flexible, and the flexible accessing database of intelligent network business has greatly reduced frequency and the workload of business development.
From above description, can find out, the present invention has realized following technique effect: the first intelligent network platform receives service request, carry the user's of solicit operation to some extent user ID in this service request, and the first corresponding relation of inquiring user sign scope and database, determine the database corresponding with the affiliated scope of above-mentioned user ID, data corresponding with above-mentioned user ID in this database are carried out to the operation that service request is asked.Utilize the corresponding relation of user ID scope and database, determine the database that intelligent network business will be accessed, thereby realized the flexible access of intelligent network business to database.For the database on the data library facilities conducts interviews, after the database of determining access, the database facility at place, all right specified data storehouse, realized the location of intelligent network business to the data library facilities, makes intelligent network business can access the database be stored in database facility.
Obviously, those skilled in the art should be understood that, above-mentioned each module of the present invention or each step can realize with general calculation element, they can concentrate on single calculation element, perhaps be distributed on the network that a plurality of calculation elements form, alternatively, they can be realized with the executable program code of calculation element, thereby, they can be stored in memory storage and be carried out by calculation element, and in some cases, can carry out step shown or that describe with the order be different from herein, perhaps they are made into respectively to each integrated circuit modules, perhaps a plurality of modules in them or step being made into to the single integrated circuit module realizes.Like this, the present invention is not restricted to any specific hardware and software combination.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (12)
1. the method for operating of a database, is characterized in that, comprising:
The first intelligent network platform receives service request, wherein, carries the user's of solicit operation to some extent user ID in described service request;
The first corresponding relation of described the first intelligent network platform inquiring user sign scope and database, determine the database corresponding with the affiliated scope of described user ID;
Described the first intelligent network platform carries out to data corresponding with described user ID in described database the operation that described service request is asked.
2. method according to claim 1, is characterized in that, described the first intelligent network platform carries out to described database the operation that described service request is asked, and comprising:
Described the first intelligent network platform is determined the database facility at described database place;
Described the first intelligent network platform is carried out described operation to data corresponding with described user ID in described database on described database facility.
3. method according to claim 2, it is characterized in that, described database facility be not described the first intelligent network platform can directly access database facility the time, described the first intelligent network platform is carried out described operation to data corresponding with described user ID in described database on described database facility, comprising:
The second corresponding relation of described the first intelligent network platform data query library facilities and intelligent network platform, definite the second intelligent network platform that can directly access the database facility at described database place;
Described the first intelligent network platform is carried out described operation by described the second intelligent network platform to data corresponding with described user ID in described database.
4. method according to claim 3, it is characterized in that, while having intelligent network platform corresponding to the database facility at a plurality of and described database place in described the second corresponding relation, determine the second intelligent network platform of the database facility that can directly access described database place, comprising:
According to the current load of described a plurality of intelligent network platforms, according to the principle of load balancing, from described a plurality of intelligent network platforms, choose described the second intelligent network platform.
5. according to the described method of any one in claim 1 to 4, it is characterized in that,
Described the first corresponding relation comprises: user ID scope, service identification and database three's corresponding relation; Also carry the service identification of the business that described service request asks in described service request;
Determine the database corresponding with the affiliated scope of described user ID, comprising: described the first intelligent network platform is inquired about described the first corresponding relation, determines the database corresponding with the affiliated scope of described user ID and described service identification while.
6. method according to claim 5, is characterized in that, described user ID comprises: initiate the user's of described business calling number, and/or, the called number of described business; The number segment that described user ID scope is described calling number and/or described called number.
7. the operating means of a database, is characterized in that, comprising:
Receiver module, for receiving service request, wherein, carry the user's of solicit operation to some extent user ID in described service request;
Determination module, for the first corresponding relation of inquiring user sign scope and database, determine the database corresponding with the affiliated scope of described user ID;
Execution module, carry out for the data corresponding with described user ID to described database the operation that described service request is asked.
8. device according to claim 7, is characterized in that, described execution module comprises:
Determining unit, for determining the database facility at described database place;
Performance element, on described database facility to described database the data corresponding with described user ID carry out described operation.
9. device according to claim 8, is characterized in that, described performance element, also at described database facility, be not the first intelligent network platform can directly access database facility the time,
The second corresponding relation of data query library facilities and intelligent network platform, definite the second intelligent network platform that can directly access the database facility at described database place;
By described the second intelligent network platform described database facility to described database in the data corresponding with described user ID carry out described operation.
10. device according to claim 9, it is characterized in that, described performance element, also for the database facility that has a plurality of and described database place at described the second corresponding relation, during corresponding intelligent network platform, determine in such a way the second intelligent network platform of the database facility that can directly access described database place:
According to the current load of described a plurality of intelligent network platforms, according to the principle of load balancing, from described a plurality of intelligent network platforms, choose described the second intelligent network platform.
11. according to the described device of any one in claim 7 to 10, it is characterized in that, described determination module, also for when described the first corresponding relation comprises user ID scope, service identification and database three's corresponding relation,
Inquire about described the first corresponding relation, determine the database corresponding with the affiliated scope of described user ID and described service identification while.
12. device according to claim 11, is characterized in that, described user ID comprises: initiate the user's of described business calling number, and/or, the called number of described business; The number segment that described user ID scope is described calling number and/or described called number.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210157777XA CN103425684A (en) | 2012-05-18 | 2012-05-18 | Method and device for database operation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210157777XA CN103425684A (en) | 2012-05-18 | 2012-05-18 | Method and device for database operation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103425684A true CN103425684A (en) | 2013-12-04 |
Family
ID=49650442
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210157777XA Pending CN103425684A (en) | 2012-05-18 | 2012-05-18 | Method and device for database operation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103425684A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104794249A (en) * | 2015-05-15 | 2015-07-22 | 乐得科技有限公司 | Realization method and realization device of database |
| CN106933922A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The method and apparatus for storing ID |
| CN107040612A (en) * | 2014-09-25 | 2017-08-11 | 海信集团有限公司 | A kind of information recommendation method and device |
| CN108055312A (en) * | 2017-12-07 | 2018-05-18 | 畅捷通信息技术股份有限公司 | Method for routing and its device and computer installation and its readable storage medium storing program for executing |
| CN112699133A (en) * | 2021-03-23 | 2021-04-23 | 浙江太美医疗科技股份有限公司 | Database operation method and device and computer readable medium |
| CN112784299A (en) * | 2021-01-22 | 2021-05-11 | 中信银行股份有限公司 | Service processing method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1568025A (en) * | 2003-06-19 | 2005-01-19 | 中兴通讯股份有限公司 | Method for processing visiting user data in mobile communication system |
| CN101378540A (en) * | 2007-08-27 | 2009-03-04 | 华为技术有限公司 | Method and system for implementing number portability business, and number portability data-base |
| CN101833585A (en) * | 2010-05-19 | 2010-09-15 | 中兴通讯股份有限公司 | Database server operation control system, method and device |
-
2012
- 2012-05-18 CN CN201210157777XA patent/CN103425684A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1568025A (en) * | 2003-06-19 | 2005-01-19 | 中兴通讯股份有限公司 | Method for processing visiting user data in mobile communication system |
| CN101378540A (en) * | 2007-08-27 | 2009-03-04 | 华为技术有限公司 | Method and system for implementing number portability business, and number portability data-base |
| CN101833585A (en) * | 2010-05-19 | 2010-09-15 | 中兴通讯股份有限公司 | Database server operation control system, method and device |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107040612A (en) * | 2014-09-25 | 2017-08-11 | 海信集团有限公司 | A kind of information recommendation method and device |
| CN107172177A (en) * | 2014-09-25 | 2017-09-15 | 海信集团有限公司 | A kind of information recommendation method and device |
| CN104794249A (en) * | 2015-05-15 | 2015-07-22 | 乐得科技有限公司 | Realization method and realization device of database |
| CN104794249B (en) * | 2015-05-15 | 2018-08-28 | 网易乐得科技有限公司 | A kind of implementation method and equipment of database |
| CN106933922A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The method and apparatus for storing ID |
| CN108055312A (en) * | 2017-12-07 | 2018-05-18 | 畅捷通信息技术股份有限公司 | Method for routing and its device and computer installation and its readable storage medium storing program for executing |
| CN112784299A (en) * | 2021-01-22 | 2021-05-11 | 中信银行股份有限公司 | Service processing method and device |
| CN112699133A (en) * | 2021-03-23 | 2021-04-23 | 浙江太美医疗科技股份有限公司 | Database operation method and device and computer readable medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7644061B1 (en) | Managing resource indexes in a networking environment | |
| CN107545338B (en) | Service data processing method and service data processing system | |
| CN103425684A (en) | Method and device for database operation | |
| CN106844397B (en) | Task transmission method, device and system based on sub-base and sub-table | |
| CN102655503A (en) | Resource allocation using shared resource pools | |
| CN110247906A (en) | A kind of method for monitoring network and device, equipment, storage medium | |
| CN105468619A (en) | Resource distribution method and device used for database connection pool | |
| CN106547870A (en) | Point table method and device of data base | |
| CN100442711C (en) | File managing system and method in digital household network | |
| CN101820673A (en) | Method, equipment and system of permanent identification of interactive user equipment | |
| CN105630419A (en) | Partition view sending method of resource pools and management node | |
| CN107066522A (en) | Database access method and device | |
| EP2348676B1 (en) | Method for accessing magnanimity data of intelligent network service database and system and device thereof | |
| CN102316128A (en) | A kind ofly be used to generate network service method and device | |
| CN105978744A (en) | Resource allocation method, device and system | |
| CN108259605B (en) | Data calling system and method based on multiple data centers | |
| CN104349372A (en) | Method and system for calling positioning capability and position service gateway | |
| CN110837499A (en) | Data access processing method and device, electronic equipment and storage medium | |
| CN103905512A (en) | Data processing method and equipment | |
| CN101378540B (en) | Method and system for implementing number portability business, and number portability data-base | |
| CN112616143B (en) | Method and device for distributing communication numbers, electronic equipment and storage medium | |
| CN111600749B (en) | Method and system for managing multiple servers and computer storage medium | |
| CN111722783B (en) | Data storage method and device | |
| CN110442456B (en) | Multi-channel load balancing method based on Hyperridge-fabric | |
| CN111212138A (en) | Cross-site storage system and data information access method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20131204 |
|
| RJ01 | Rejection of invention patent application after publication |