WO2011143851A1 - Système, procédé et équipement de commande d'opération de serveur de base de données - Google Patents

Système, procédé et équipement de commande d'opération de serveur de base de données Download PDF

Info

Publication number
WO2011143851A1
WO2011143851A1 PCT/CN2010/075964 CN2010075964W WO2011143851A1 WO 2011143851 A1 WO2011143851 A1 WO 2011143851A1 CN 2010075964 W CN2010075964 W CN 2010075964W WO 2011143851 A1 WO2011143851 A1 WO 2011143851A1
Authority
WO
WIPO (PCT)
Prior art keywords
database server
type
server
memory
service
Prior art date
Application number
PCT/CN2010/075964
Other languages
English (en)
Chinese (zh)
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 中兴通讯股份有限公司
Publication of WO2011143851A1 publication Critical patent/WO2011143851A1/fr

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21—Design, administration or maintenance of databases

Definitions

  • the present invention relates to the field of communications technologies, and in particular, to a database server operation control system, method, and device.
  • a service control point SCP
  • the database server is required to perform certain operations. For example, in the process of processing a user-initiated virtual private mobile network (VPMN) call service, the SCP needs the database server to modify the stored fee data table of the user, then the SCP.
  • VPMN virtual private mobile network
  • a physical database server is usually used to perform related operations, and each SCP corresponds to at least one physical database server, and each physical database server stores data related to at least one intelligent network service. Since the physical database server is a database server based on disk storage, and the read/write rate of the external interface of the disk is low, the rate at which the physical database server performs related operations on the stored data is very low, and the physical database server performs The operation is accompanied by data interaction between the memory and the disk. For example, the physical database server needs to perform a write operation, then the physical database server writes the data to be written into the memory first, and then writes the data to the memory.
  • Embodiments of the present invention provide a database server operation control system, method, and device, which are used to solve the problem that an existing database server performs low-cost operations on stored data, and wastes more system resources. .
  • a database server operation control system comprising: a database server operation control device, a physical database server, and an in-memory database server, wherein: the database server operation control device is configured to obtain an operation type that requires an operation performed by the database server when processing the intelligent network service If the operation is determined by the in-memory database server according to the obtained operation type, the in-memory database server is instructed to perform the above operation, and if it is determined that the operation needs to be performed by the physical database server according to the obtained operation type, the physical database server is indicated.
  • a database server operation control method comprising the steps of: obtaining an operation type that requires an operation performed by a database server when processing an intelligent network service; and determining, according to the obtained operation type, that the operation needs to be performed by an in-memory database server And instructing the in-memory database server to perform the foregoing operations. If it is determined that the operation needs to be performed by the physical database server according to the obtained operation type, the physical database server is instructed to perform the foregoing operations.
  • a database server operation control device comprising: an obtaining unit, configured to: when processing an intelligent network service, obtain an operation type that requires an operation performed by a database server; and a determining unit, configured to determine, according to an operation type obtained by the obtaining unit, whether the operation is performed
  • the instructing unit is configured to: when the determining result of the determining unit is YES, instructing the in-memory database server to perform the foregoing operation, and when the determining result of the determining unit is negative, instructing the physical database server to perform the foregoing operation .
  • a service control point includes the above database server operation control device.
  • An in-memory database server comprising: a receiving unit, configured to receive an indication message sent by the database server operation control device for instructing the in-memory database server to perform a corresponding operation; and an operation execution unit, configured to receive the indication at the receiving unit After the message, the corresponding operation is performed.
  • the database server operation control system includes a database server operation control device, a physical database server, and an in-memory database server.
  • the in-memory database server is instructed to perform the above operation, otherwise the physical database server is instructed to perform the above operations, and the physical database server and the in-memory database server respectively
  • the instruction of the database server operation control device performs a corresponding operation, and thus, it can be seen that the technical party of the embodiment of the present invention The case is no longer only stored by the physical database server and performs related operations, but is performed by the in-memory database server and the physical database server.
  • Each type of database server handles the corresponding type of operation, the database server.
  • FIG. 1 is a structural block diagram of a database server operation control system according to an embodiment of the present invention
  • FIG. 2 is a flowchart of a database server operation control method according to an embodiment of the present invention
  • FIG. 3 is a schematic diagram of an SCP and a database server according to an embodiment of the present invention
  • FIG. 4 is a flowchart of a specific implementation of a database server operation control method according to an embodiment of the present invention
  • FIG. 5 is a block diagram of an SCP structure according to an embodiment of the present invention
  • FIG. 6 is a structural block diagram of an in-memory database server according to an embodiment of the present invention
  • DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The main implementation principles, specific implementation manners, and the corresponding beneficial effects that can be achieved by the embodiments of the present invention are described in detail below with reference to the accompanying drawings.
  • the embodiment of the present invention provides a database server operation control system, which is applied to an intelligent network system.
  • the structure thereof is as shown in FIG. 1 , and includes a database server operation control device 11 , a physical database server 12 , and an in-memory database server 13 .
  • the database server operation control device 11 is configured to: when processing the intelligent network service, obtain an operation type that requires an operation performed by the database server, and if it is determined that the operation needs to be performed by the in-memory database server 13 according to the obtained operation type, indicating the memory
  • the database server 13 performs the above operation, otherwise instructs the physical database server 12 to perform the above operations; the physical database server 12 and the in-memory database server 13 are configured to perform corresponding operations in accordance with the instructions of the database server operation control device 11, respectively.
  • the database server operation control device 11 can be, but is not limited to, an SCP in an intelligent network, where the intelligent network system includes multiple SCPs, and each SCP is responsible for processing at least one type of service, and each SCP performs a control database according to the above manner. Server operation.
  • the database server operation control system includes a database server operation control device, a physical database server, and an in-memory database server.
  • the database server operation control device processes the intelligent network service, the database server is first obtained. The operation type of the executed operation.
  • the in-memory database server is instructed to perform the above operation, otherwise the physical database server is instructed to perform the above operations, the physical database server and the in-memory database server.
  • the corresponding operations are performed according to the instructions of the database server operation control device. It can be seen that the technical solution of the embodiment of the present invention no longer only stores data and performs related operations by the physical database server, but by the in-memory database server and the physical server.
  • each type of database server handles the corresponding type of operation, and the database server operation control device according to the operation type Which database server is used, and the in-memory database server reads and writes data at a much higher rate than the physical database server reads and writes data, and the in-memory database is stored in the memory of the database server.
  • the embodiment of the present invention provides a database server operation control method, as shown in FIG.
  • Step 21 When processing an intelligent network service, obtain an operation type that requires an operation performed by the database server;
  • the database server operation control device is an SCP in the intelligent network. Since the intelligent network system includes multiple SCPs, each SCP is responsible for processing at least one type of intelligent network service, so the intelligent network system passes each type of service through a service processing request. Routed to the corresponding SCP processing. After receiving the service processing request, each SCP triggers the service logic corresponding to the service type of the service. Each type of service corresponds to different service logic. If the business logic contains the required database.
  • the operation performed by the server, the SCP obtains an operation type that requires an operation performed by the database server, where the operation type specifically refers to the data table for the operation and the operation mode to be performed on the data table, for example, the operation type may be "modify the user.
  • Expense data sheet, or "Modify user's configuration data table" Step 22 obtained according to the type of operation, it is determined whether the above-described operation performed by the database server memory, if yes, go to step 23, if no, go to step 24;
  • the embodiment of the invention provides that the in-memory database server is added to perform related operations in the intelligent network system, and the operation types respectively responsible for the in-memory database server and the physical database server are preset, for example, the in-memory database server is responsible for performing the operation type as "modifying the user fee data table".
  • the operation, and the physical database server is responsible for performing the operation type "modify the user's configuration data table" operation
  • the SCP stores the correspondence between the operation type and the server type, and the server type includes the monthly response of the in-memory database server The type of the server and the server type corresponding to the physical database server.
  • the SCP determines whether the above operation needs to be performed by the in-memory database server according to the obtained operation type, but is not limited to the following process: First, the SCP is based on the obtained operation.
  • the operation of the same data table may be performed by a database server or by two database servers. For example, for the "user fee data table, it may be set to be executed by the in-memory database server".
  • the operation of updating the user expense data table ", the physical database server performs the operation of adding or deleting the user fee data table,” can also be set to the in-memory database server to separately complete the "modification (including update, add, and delete) user fee data table, If the two database servers perform related operations together for a certain data table, in order to ensure the consistency of the data stored in the two database servers, it is necessary to synchronize the data stored in the two database servers to call For example, if the "User Expense Data Table" of the business is set to perform the "Update User Expense Data Table” operation, the physical database server performs the "Add or Delete User Expense Data Table,” operation, where "Update User Fees" data sheet,, The operation is performed during the user's call, and the operation of adding or deleting the user fee data table is performed when the user opens an account or cancels the account, so the "update user fee data table" is executed in the in-memory database server.
  • the in-memory database server synchronizes the data with the physical database server.
  • the full-scale synchronization method can be used, that is, the "user expense data table" stored in the in-memory database is synchronized to the physical database, but due to the in-memory database month There are more data transmitted between the server and the physical database server, so you can use the incremental synchronization method (also called “thing-level” synchronization mode) to tamper with the "user fee data table" during the call.
  • Data and 4 tampering methods are sent to the physical database server, physical database server for "user fee data" Table 4 is the same as the in-memory database server, which is equivalent to the physical database server and the in-memory database server perform the same operation; when the user accounts, the physical database server will target the "user expense data table"
  • the operation of adding or deleting, at this time, the physical database server should synchronize data with the in-memory database server, and the method of full-synchronization or incremental synchronization can be used. The specific synchronization process is not mentioned here. Data synchronization is performed between the database server and the in-memory database server by incremental synchronization.
  • the database server Since the traffic in the intelligent network system is very large, the database server operates more, in order to ensure the data stored in the physical database server and the in-memory database server. Consistency, it is also possible to perform a full amount of synchronization at a specified point in time, for example, synchronizing the "user expense data table" in the physical database server to the in-memory database at the beginning of each month. Step 23, instructing the in-memory database server to perform the above operations;
  • One or more in-memory database servers may be set. If multiple settings are provided, each in-memory database server is responsible for performing operations on at least one type of service, for example, an intelligent network service that can be processed by an SCP in an intelligent network system.
  • Service 1, Service 2, Service 3, and Service 4 in which 40 pairs of the same type of operation are executed by the in-memory database server, and the in-memory database server A is responsible for executing the service 1 With operation a of service 2, the in-memory database server B is responsible for performing operation a for service 3, and the in-memory database server C is responsible for performing operation a for service 4, which stores the service type of the intelligent network service and the in-memory database server.
  • the server identifier as shown in Table 1: Schematic diagram of the correspondence between the service type and the server identifier
  • the SCP After determining that the operation for the intelligent network has been performed by the in-memory database server, the SCP first obtains the service type of the intelligent network service, and then according to the obtained service type, the correspondence between the service type and the server identifier of each in-memory database server. In the relationship, the server identifier of the in-memory database server that processes the intelligent network service is searched, and the in-memory database server corresponding to the found server identifier performs operation a.
  • Step 24 Instruct the physical database server to perform the foregoing operations.
  • one or more physical database servers may be set. If multiple settings are provided, each physical database server is responsible for performing operations on at least one type of service, for example, one of the intelligent network systems.
  • the intelligent network service that the SCP can process includes Service 1, Service 2, Service 3, and Service 4.
  • the D is responsible for performing the operations b for the service 1 and the service 2
  • the physical database server E is responsible for performing the operation b for the service 3
  • the physical database server F is responsible for performing the operation b for the service 4, in which the intelligent network service is stored
  • Table 2 Schematic diagram of the correspondence between the service type and the server identifier
  • the SCP After determining that the operation b for the intelligent network has been performed by the physical database server, the SCP first obtains the service type of the intelligent network service, and then according to the obtained service type, the correspondence between the service type and the server identifier of each physical database server. In the relationship, the server identifier of the physical database server that processes the intelligent network service is searched, and the physical database server corresponding to the found server identifier is instructed to perform operation b. As shown in FIG.
  • FIG. 3 it is a schematic diagram of the relationship between the SCP and the database server in the embodiment of the present invention, which includes multiple SCPs, multiple in-memory database servers, and multiple physical database servers, each of which is respectively Connected to one or more in-memory database servers and physical database servers, each SCP-processed intelligent network service performs corresponding operations when the database server is required to operate.
  • Step 41 The SCPW receives the VPMN call service request sent by the user A.
  • Step 42 The SCPW determines that the VPMN service is being processed.
  • the database server is required to perform the operation of "updating the user fee data table”
  • Step 43 The SCPW searches and executes the "update user fee data table” according to the operation type of the "update user fee data table” in the correspondence between the operation type and the server type.
  • the server type of the operating database server Step 44, SCPW determines that the discovered server type is the server type corresponding to the in-memory database server; Step 45, SCPW indicates the service type according to the VPMN call service, the service type and the in-memory database.
  • the embodiment of the present invention provides a database server operation control apparatus, and the structure thereof is as shown in FIG.
  • the obtaining unit 51 is configured to process In the case of the intelligent network service, the operation type of the operation required by the database server is obtained; the determining unit 52 is configured to determine, according to the operation type obtained by the obtaining unit 51, whether the operation needs to be performed by the in-memory database server; and the indicating unit 53 is configured to determine When the determination result of the unit 52 is YES, the memory database server is instructed to perform the above operation, and when the determination result of the determination unit 52 is negative, the physical number is indicated. The above operation is performed according to the library server.
  • the determining unit 52 specifically includes a first lookup subunit, a judging subunit, and a determining subunit, where: the first lookup subunit is configured to correspond to the operation type and the server type according to the operation type obtained by the obtaining unit 51. In the relationship, the server type corresponding to the obtained operation type is searched; the determining subunit is configured to determine whether the server type found by the first search subunit is a server type corresponding to the in-memory database server; determining the subunit, for determining the subunit When the judgment result is YES, it is determined that the above operation needs to be performed by the in-memory database server, and when the judgment result is NO, it is determined that the above operation needs to be performed by the physical database server.
  • the indicating unit 53 specifically includes an obtaining subunit, a second searching subunit, and an indicating subunit, wherein: obtaining the subunit, a service type for obtaining the foregoing intelligent network service; a second search subunit, configured to obtain a correspondence between the service type and the server identifier of each memory database server according to the service type obtained by the obtained subunit
  • the server identifier of the in-memory database server that processes the foregoing intelligent network service is searched;
  • the indication sub-unit is configured to instruct the in-memory database server corresponding to the server identifier found by the second search sub-unit to perform the operation.
  • the database server determined by the determining unit 52 is an in-memory database server.
  • the embodiment of the invention further provides an SCP, which can be, but is not limited to, the above-mentioned database server operation control device.
  • the embodiment of the present invention further provides an in-memory database server, and the structure thereof is as shown in FIG. 6 , and includes a receiving unit 61 and an operation executing unit 62.
  • the receiving unit 61 is configured to receive, by the database server operation control device, the An indication message that the in-memory database server performs corresponding operations;
  • the operation execution unit 62 is configured to perform the foregoing corresponding operation after the receiving unit 61 receives the indication message.

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

L'invention porte sur un système, un procédé et un équipement de commande d'opération de serveur de base de données. Le système de commande d'opération de serveur de base de données comprend un dispositif de commande d'opération de serveur de base de données (11), un serveur de base de données physique (12) et un serveur de base de données en mémoire (13). Le dispositif de commande d'opération de serveur de base de données (11) est utilisé pour acquérir le type d'opération de l'opération qui doit être réalisée par le serveur de base de données lorsqu'un service de réseau intelligent est traité. Selon le type d'opération acquis, le dispositif de commande d'opération de serveur de base de données (11) indique au serveur de base de données en mémoire (13) de réaliser l'opération si l'opération doit être réalisée par le serveur de base de données en mémoire (13), et indique au serveur de base de données physique (12) de réaliser l'opération si l'opération doit être réalisée par le serveur de base de données physique (12). Le serveur de base de données physique (12) est utilisé pour réaliser l'opération conformément à l'indication du dispositif de commande d'opération de serveur de base de données (11). Le serveur de base de données en mémoire (13) est utilisé pour réaliser l'opération conformément à l'indication du dispositif de commande d'opération de serveur de base de données (11). Le système de commande d'opération de serveur de base de données résout le problème de plus faible efficacité et le problème de gaspillage de davantage de ressources système lorsque le serveur de base de données existant réalise l'opération correspondante sur les données stockées.
PCT/CN2010/075964 2010-05-19 2010-08-13 Système, procédé et équipement de commande d'opération de serveur de base de données WO2011143851A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201010179159.6 2010-05-19
CN201010179159A CN101833585A (zh) 2010-05-19 2010-05-19 数据库服务器操作控制系统、方法及设备

Publications (1)

Publication Number Publication Date
WO2011143851A1 true WO2011143851A1 (fr) 2011-11-24

Family

ID=42717654

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2010/075964 WO2011143851A1 (fr) 2010-05-19 2010-08-13 Système, procédé et équipement de commande d'opération de serveur de base de données

Country Status (2)

Country Link
CN (1) CN101833585A (fr)
WO (1) WO2011143851A1 (fr)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103425684A (zh) * 2012-05-18 2013-12-04 中兴通讯股份有限公司 数据库的操作方法及装置
CN102769667B (zh) * 2012-06-29 2015-01-28 北京奇虎科技有限公司 一种id生成方法、装置和系统
CN103024077B (zh) * 2012-12-28 2017-03-15 北京百度网讯科技有限公司 日程关联信息的推送方法、系统和服务器
CN104408054B (zh) * 2014-10-29 2017-10-31 深圳市金证科技股份有限公司 一种数据库管理系统
CN107657458A (zh) * 2016-08-23 2018-02-02 平安科技（深圳）有限公司 名单获取方法及装置

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1453958A (zh) * 2002-04-26 2003-11-05 华为技术有限公司 智能网用户统一帐号的方法
CN1992953A (zh) * 2005-12-30 2007-07-04 中兴通讯股份有限公司 一种分布式hlr内存数据库的实现方法
CN101493826A (zh) * 2008-12-23 2009-07-29 中兴通讯股份有限公司 基于web应用的数据库系统及其数据管理方法

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040158550A1 (en) * 2003-01-16 2004-08-12 Jardin Cary Anthony System and method for cooperate database acceleration
CN101119414A (zh) * 2007-09-19 2008-02-06 华为技术有限公司 访问数据库的方法及系统

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1453958A (zh) * 2002-04-26 2003-11-05 华为技术有限公司 智能网用户统一帐号的方法
CN1992953A (zh) * 2005-12-30 2007-07-04 中兴通讯股份有限公司 一种分布式hlr内存数据库的实现方法
CN101493826A (zh) * 2008-12-23 2009-07-29 中兴通讯股份有限公司 基于web应用的数据库系统及其数据管理方法

Also Published As

Publication number Publication date
CN101833585A (zh) 2010-09-15

Similar Documents

Publication Publication Date Title
CN102594849B (zh) 数据备份、恢复方法、虚拟机快照删除、回滚方法及装置
EP2821925B1 (fr) Procédé et appareil de traitement de données distribuées
WO2017162032A1 (fr) Procédé et dispositif d'exécution d'une opération de récupération de données
JP6362761B2 (ja) ローミングネットワークアクセス方法および装置
WO2013178082A1 (fr) Procédé pour le téléchargement d'une image vers l'amont, système, terminal client, serveur de réseau et support de stockage informatique
CN109254825A (zh) 一种纳管虚拟机硬盘的方法及装置
WO2013163864A1 (fr) Procédé et dispositif de traitement de persistance de données et système de base de données
WO2013177968A1 (fr) Système et dispositif de stockage de fichiers, et procédé d'accès à des fichiers
WO2021109750A1 (fr) Appareil, dispositif et procédé de gestion de nœud, support de stockage et système
WO2017066931A1 (fr) Procédé et dispositif de gestion de certificat dans une architecture de virtualisation de fonction de réseau
WO2011143851A1 (fr) Système, procédé et équipement de commande d'opération de serveur de base de données
WO2009006841A1 (fr) Procédé et appareil destinés à commander des données provenant de sources multiples distribuées et synchrones
EP3297250A1 (fr) Procédé et dispositif de copie de données
WO2017113694A1 (fr) Système, dispositif et procédé de synchronisation de fichier
JP2018512001A (ja) 仮想化ネットワーク機能を管理するための方法及び装置
WO2020224236A1 (fr) Appareil, procédé et système de traitement de donnés de chaîne de blocs, et support de stockage
CN106611001A (zh) 虚拟机数据库表数据一致性的校验方法、装置及系统
CN104793981B (zh) 一种虚拟机集群的在线快照管理方法及装置
CN111722909A (zh) 一种虚拟机迁移方法、系统、设备及存储介质
CN115904520A (zh) 基于pcie拓扑状态变更的配置保存方法及相关设备
CN114201458B (zh) 一种信息更新方法、微服务系统及计算机可读存储介质
CN103327112B (zh) 基于云存储的桌面同步方法以及实现桌面同步的装置
CN112788585B (zh) 一种5g核心网中nf切换方法、装置及存储介质
CN112181049B (zh) 集群时间同步方法、装置、系统、设备及可读存储介质
CN102594874A (zh) 一种同步处理方法和装置

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 10851609

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 10851609

Country of ref document: EP

Kind code of ref document: A1