CN107977344A - Date storage method, acquisition methods and server - Google Patents

Abstract

The present embodiments relate to field of data access technology, discloses a kind of date storage method, acquisition methods and server.Date storage method in the present invention, default programming language is supported applied to server and the server, the described method includes：At least two systematic parameters of selected operation system are obtained as combination parameter；The combination parameter is packaged into the default programming language form；By the combination parameter by the default programming language format conversion into JSON forms；The combination parameter of the JSON forms of the operation system is stored to database.Data capture method and server are additionally provided in the present invention.Technical scheme can make it that access of the server to systematic parameter is more flexible, and management is more convenient, while reduces redundant data.

Description

Data storage method, acquisition method and server

technical field

The embodiments of the present invention relate to the technical field of data access, and in particular, to a data storage method, an acquisition method, and a server.

Background technique

With the continuous development of Internet technology, terminal equipment can access various websites and obtain various resources through the server; the function of the service platform has a great impact on the use of terminal equipment. The server can access the database to access data; wherein, the data stored in the database is of various types, for example: various system parameters of the server, shared information, personal records, and so on.

Current servers usually run on the JAVA platform. When storing system parameters, this type of server will create a separate configuration table in the database corresponding to each business, and the configuration table includes multiple data records, corresponding to multiple system data. As shown in Table 1 below

Table 1:

id description key value 245 company information company Wangsu Technology 246 Copyright Information copyright Copyright2015-2020

In Table 1, the key column corresponds to the name of the system parameter, the value column corresponds to the actual value of the system parameter, the id column corresponds to the identification code of the system parameter, and the description column corresponds to the description of the system parameter. Each system parameter corresponds to a data record, and each data record includes a key and a value; in actual business scenarios, the system parameters are obtained through the key-value method, and the real effective value is the value corresponding to the value, and the key is in the actual The business scenario has no practical significance, and is only used as intermediate data for access.

The inventors have found that at least the following problems exist in the prior art: in actual business scenarios, multiple related system parameters are often used at the same time, such as the two system parameters (company information and copyright information) in Table 1 are often used at the same time to mark the server Copyright information; and using the above key-value method, only one value can be obtained through one key, and multiple system parameters must be obtained through multiple keys to obtain multiple times; and each time a system parameter is added, an additional one must be configured key, there will be one more redundant data.

Contents of the invention

The purpose of the embodiments of the present invention is to provide a data storage method, an acquisition method and a server, so that the server can more flexibly access system parameters, make management more convenient, and reduce redundant data at the same time.

In order to solve the above technical problems, the embodiment of the present invention provides a data storage method, which is applied to a server and the server supports a preset programming language, and the method includes: acquiring at least two system parameters of the selected business system as Combined parameters; packaging the combined parameters into the preset programming language format; converting the combined parameters from the preset programming language format into JSON format; storing the combined parameters in the JSON format of the business system to the database.

The embodiment of the present invention also provides a data acquisition method, which is applied to a server and the server supports a preset programming language. The method includes: when an acquisition command of the combined parameters of the business system is detected, acquire the data from the database. The combination parameter of the JSON format of the business system; wherein, the combination parameter includes at least two system parameters; the obtained combination parameter is converted from the JSON format into the preset programming language format; from the preset programming Each of the system parameters is extracted from the combined parameters in the language format.

The embodiment of the present invention also provides a server, the server includes: at least one processor; and a memory connected to the at least one processor in communication; wherein, the memory stores information that can be processed by the at least one processor. Instructions executed by a processor, the instructions are executed by the at least one processor, so that the at least one processor can execute the data storage method.

The embodiment of the present invention also provides a server, the server includes: at least one processor; and a memory connected to the at least one processor in communication; wherein, the memory stores information that can be processed by the at least one processor. Instructions executed by a processor, the instructions are executed by the at least one processor, so that the at least one processor can execute the data acquisition method.

Compared with the prior art, the embodiment of the present invention selects at least two system parameters of the business system as combined parameters, converts the combined parameters from the preset programming language format into JSON format and stores them in the database, and when needed The combined parameters in JSON format are obtained from the database during acquisition; the selected at least two system parameters are accessed as a whole, making the server more flexible in accessing the system parameters, more convenient in management, and reducing redundant data at the same time.

In addition, the preset programming language is JAVA, and the storing of the combined parameters in the JSON format of the business system to the database specifically includes: creating a JAVA object; the attributes of the JAVA object include at least keywords and actual value; obtain the identification mark that characterizes the combination parameter; assign the identification mark to the keyword, and assign the combination parameter in JSON format to the actual value; store the JAVA object after the assignment in the database. This embodiment provides a specific way of storing the combined parameters in JSON format.

In addition, before the packaging of the combination parameters into the preset programming language format, the method further includes: providing a configuration interface for the combination parameters, so as to configure the combination parameters through the configuration interface. This embodiment provides a method for configuring the combination parameters.

In addition, the at least two selected system parameters are constant parameters. Since constant parameters do not involve modification operations, multiple constant parameters are selected to form combined parameters for common access, which can avoid inconvenience in access when a certain system parameter in the combined parameters needs to be modified.

In addition, the acquiring the combination parameter of the business system in JSON format from the database specifically includes: acquiring the identification mark characterizing the combination parameter; acquiring the combination parameter in JSON format corresponding to the identification mark from the database parameter. This embodiment provides a specific storage manner of the combined parameters in JSON format. This embodiment provides a specific way to obtain the combined parameters in JSON format.

Description of drawings

One or more embodiments are exemplified by the pictures in the corresponding drawings, and these exemplifications do not constitute a limitation to the embodiments. Elements with the same reference numerals in the drawings represent similar elements. Unless otherwise stated, the drawings in the drawings are not limited to scale.

Fig. 1 is the flowchart of the data storage method according to the first embodiment of the present invention;

FIG. 2 is a specific flowchart of step 104 according to the first embodiment of the present invention;

Fig. 3 is a flowchart according to a second embodiment of the present invention;

Fig. 4 is the schematic diagram of an example of the configuration interface of the combination parameter of the second embodiment of the present invention;

Fig. 5 is a flowchart of a data storage method according to a third embodiment of the present invention;

Fig. 6 is a block diagram of a server according to a fourth embodiment of the present invention.

Detailed ways

In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the various implementation modes of the present invention will be described in detail below in conjunction with the accompanying drawings. However, those of ordinary skill in the art can understand that, in each implementation manner of the present invention, many technical details are provided for readers to better understand the present application. However, even without these technical details and various changes and modifications based on the following implementation modes, the technical solutions claimed in this application can also be realized.

The first embodiment of the present invention relates to a data storage method, which is applied to a server and the server supports a preset programming language. As shown in Figure 1, it is a flow chart of the method of this embodiment, including the following steps:

Step 101: Obtain at least two system parameters of the selected business system as combined parameters;

Step 102: Encapsulate the combined parameters into a preset programming language format;

Step 103: Convert the combined parameters from the preset programming language format into JSON format;

Step 104: Store the combined parameters of the business system in JSON format to the database.

Among them, JSON (JavaScript Object Notation, JS Object Notation), is a lightweight data exchange format, which uses a text format completely independent of programming language to store and represent data.

Compared with the prior art, the embodiment of the present invention selects at least two system parameters of the business system as combined parameters, converts the combined parameters from the preset programming language format into JSON format and stores them in the database, and obtains them when needed Obtaining the combined parameters in JSON format from the database; accessing at least two selected system parameters as a whole, making the server more flexible in accessing the system parameters, more convenient in management, and reducing redundant data at the same time.

The implementation details of the data storage method of this embodiment are described in detail below. The following content is only the implementation details provided for the convenience of understanding, and is not necessary for implementing this solution.

In this embodiment, the default programming language is JAVA, and the default programming language format is JAVA object; the following uses JAVA as an example for illustration, but this embodiment does not impose any limitation on the type of the default programming language.

In step 101, at least two system parameters of the selected service system are obtained as combined parameters.

Specifically, at least two system parameters may be selected as combined parameters according to the actual service system. Each business system usually includes multiple system parameters, and at least two system parameters can be pre-selected for common access as combined parameters. The selection of combined parameters can be based only on the business requirements related to system parameters. Generally speaking, in a business system, the business that only involves system parameters is relatively fixed, such as initial configuration, copyright information, etc., and the probability of system parameters being updated after the initial assignment is low, so it can be selected in advance according to actual business needs. Determine relevant system parameters to form a combination for executing the business. In this way, when performing such tasks, you can directly query and obtain the corresponding combination parameters to meet the execution requirements, which not only improves the parameter query rate, but also improves business processing efficiency.

Preferably, a plurality of system parameters with low change frequency and high coupling degree will be selected as the combined parameters; wherein, each system parameter includes a parameter name and a parameter value, and the low change frequency here refers to the change of the parameter value The frequency is very low and will not even change; the high degree of coupling here means that the probability of multiple system parameters being accessed together is high. Preferably, the selected system parameters are all constant parameters (that is, the parameter values will not change).

In step 102, the combined parameters are encapsulated into a JAVA object. Specifically, a JAVA object is created, which includes multiple attributes, and the specific attribute names correspond to the parameter names of each system parameter in the combined parameters, and the corresponding attribute values are the parameter values of each system parameter. It should be noted that, when the preset programming language is another programming language, the format processing can be performed according to the established method of the other programming language.

In step 103: converting the JAVA object into JSON format. Specifically, the related functions of JAVA to JSON can be used for format conversion. Specifically, after the attribute name and attribute value in the JAVA object are converted into JSON format, they are actually converted into a string, that is, the combined parameter name and corresponding parameter value are converted into a string in JSON format . In this way, converting the original combination of multiple parameter names and parameter value records into a string can make the recorded data lighter.

In step 104: storing the combined parameters of the business system in JSON format to the database. That is, the combined parameters in JSON format are stored in the database as a whole. Specifically, as shown in Figure 2, step 104 may include the following sub-steps:

Sub-step 1041: create a JAVA object; the attributes of the JAVA object include at least a key and an actual value.

Sub-step 1042: Obtain the identification mark representing the combination parameter. Specifically, the identification mark representing the combination parameter is generally preset by the developer and stored in the server, but it is not limited thereto, and the identification mark can also be randomly generated by the server.

Sub-step 1043: Assign the identification flag to the keyword, and assign the combination parameter in JSON format to the actual value. That is, the identification mark representing the combined parameter is used as the attribute value of the keyword attribute in this JAVA object, and the combined parameter in JSON format (actually a character string) is used as the attribute value of the actual value attribute.

Sub-step 1044: Store the assigned JAVA object in the database. Wherein, the database used in the present embodiment is a key-value database, and correspondingly, the storage mode of JAVA object is the key-value mode, and the identification sign (the value of key) of characterizing combination parameter and the combination parameter (value of value) of JSON format value) is stored in the database as a piece of data. Based on this, the corresponding relationship between the identification mark (key value) and the combination parameter (value value) in JSON format can be established, so that the corresponding value can be obtained by looking up the key value value.

Further, the attributes of the JAVA object may also include an identification code (id) and a description (description), that is, the data record may also include an identification code (id) and a description (description).

It can be seen that through the method provided in this embodiment, corresponding system parameters can be selected based on actual business needs to form a combined parameter, and corresponding JAVA objects can be created and stored in the key-value database in JSON format, which not only saves data storage space , which simplifies the operation of the database, thereby improving the processing efficiency of the computer. Furthermore, when executing this business, you only need to search the database through the key value to obtain the corresponding value value. Since the string content in JSON format corresponds to a JAVA object, then by converting the value into a JAVA object, you can obtain all the system parameters required for business processing, which not only reduces the number of times to read the database in the traditional way, but also obtains business through a key All system parameters required for processing are processed, thereby increasing the speed of business processing.

The following uses an application scenario of a specific business system as an example for illustration.

Example 1

The game management system (hereinafter referred to as gms), in the business of displaying game configuration, involves three system parameters: energy upper limit, backfill time and url blacklist. , the values of the three system parameters have been assigned and saved. Generally speaking, in the subsequent use process, the modification of the three system parameters is rarely involved.

The business of displaying game configurations means that when players or administrators need to know about game configurations, they submit query requests, and the system will display these system parameters according to the requests. In this example, all system parameters required in the selected game configuration business are combined parameters.

In the traditional processing method, the JAVA object 1 of the system parameter is as follows:

Each system parameter corresponds to a JAVA object, the parameter name is assigned to the key, and the parameter value is assigned to the value.

Each system parameter is stored separately as a data record in the database. That is, to build a configuration table in the database, three custom keys are required to store the three system parameters into the data in the form of key-value, as shown in Table 2, where the first line in Table 2 is the four attributes, the second, third, and fourth lines are each a data record, representing a system parameter. It should be noted that the data in the tables in this application are all illustrative descriptions and are not limited thereto.

Table 2

id description key value 260 energy cap maxEnergy 100 261 backfill time recoverTime 30 262 url blacklist urlBlackList http://h.7k7k.com/

Among them, the energy upper limit and backfill time are of numeric type, and the url blacklist is of string type. Due to the different types of energy upper limit, backfill time, and url blacklist, type conversion operations are required when reading and writing the database. Before storing in the database, the energy upper limit and backfill time need to be converted into a string type; after reading the database, the energy upper limit and backfill time need to be converted into a number type.

In this traditional processing method, when the business of displaying game configuration is executed, the three records need to be read from the database respectively. In this way, the energy upper limit, backfill time and url blacklist need to be known during the business execution process. The key value corresponding to the value value can read the corresponding value value from the database, and convert and display it.

In adopting the technical scheme of the present embodiment, after the combined parameter is encapsulated into a JAVA object, its JAVA object 2 is as follows:

Convert the combination parameters from JAVA objects into JSON format, and store the combination parameters of the game management system in JSON format to the database; that is, use the JSON format to combine the three system parameters of the game management system into one data record, and only need one custom key, as shown in Table 3.

table 3

Among them, the value corresponding to value {"maxEnergy":100,"recoverTime":30,"urlBlackList": "http://h.7k7k.com"} in Table 3 is the combination parameter in JSON format.

In the technical solution of this embodiment, according to the business requirements for displaying game configurations, the system parameters involved are first selected to form a parameter combination, the parameter combination is encapsulated into a JAVA object, and the JAVA object is converted into JSON format, and a The record is stored in the database, so that when performing the business of displaying the game configuration, all the required system parameters can be obtained only according to the corresponding key value of the record.

As can be seen from the above, the comparison of the technical solution adopted in this embodiment shows that the technical solution adopted in this embodiment effectively reduces the number of keys and data redundancy; at the same time, no type conversion is required, and the read and write operations are flexible.

As shown in Figure 3, it is a flow chart of the second embodiment of the present invention, wherein, step 201 to step 204 are correspondingly similar to steps 101 to 104 in the first embodiment, and a new step 200 is newly added, specifically:

Step 200: Provide a configuration interface for combination parameters, so as to configure the combination parameters through the configuration interface.

Specifically, the configuration interface includes each system parameter in the combined parameters, and each system parameter includes a parameter name and a parameter value with input; designers can input parameter values in the configuration interface to realize the configuration of system parameters. Among them, the configuration interface can be provided when the system parameters are initialized and set, and can also be provided when the parameter values need to be modified. As shown in Figure 4, it corresponds to the configuration interface of Example 1 in the first embodiment; wherein, the interface setting method in Figure 4 is only an exemplary description, and is not limited thereto.

The step division of the above various methods is only for the sake of clarity of description. During implementation, it can be combined into one step or some steps can be split and decomposed into multiple steps. As long as they include the same logical relationship, they are all within the scope of protection of this patent. ; Adding insignificant modifications or introducing insignificant designs to the algorithm or process, but not changing the core design of the algorithm and process are all within the scope of protection of this patent.

The third embodiment of the present invention relates to a data acquisition method, which is applied to a server and the server supports a preset programming language. In this embodiment, the default programming language is JAVA, and the default programming language format is JAVA format; the following are all described using JAVA as an example, but this embodiment does not make any restrictions on the type of preset programming language.

As shown in Figure 5, it is a flowchart of the method of this embodiment, including the following steps:

Step 301: Judging whether the acquisition command of the combined parameters of the business system is detected; if yes, then enter step 302, if not, then end.

Wherein, the acquisition command of the combined parameters of the business system may be generated by the request received by the server from the client, or may be generated by the execution of the business system inside the server. For example, when the server receives the request for obtaining the game configuration system parameters of the game management system sent by the client, the server will generate a request for obtaining the game configuration system parameters; or, when the server’s video management system needs to configure a game point , the server will generate a request for obtaining the site configuration system parameters of the video management system.

Step 302: Obtain the combined parameters of the business system in JSON format from the database; wherein, the combined parameters include at least two system parameters.

Specifically, step 302 includes the following sub-steps:

Sub-step 3021: Obtain the identification mark representing the combination parameter.

The server internally stores the corresponding relationship between the combination parameter (value) and the identification mark (key), for example, a combination parameter-identification mark comparison table is stored. When an acquisition command of the combination parameter of the business system is detected, the corresponding relationship is queried to obtain the identification mark of the combination parameter.

Sub-step 3022: Obtain the combination parameter in JSON format corresponding to the identification mark from the database.

Wherein, the database stores the corresponding relationship between the identification mark and the combined parameters in JSON format. Each pair of combination parameters of the identification mark and JSON format is included in a data record, wherein the combination parameters include at least two system parameters. Preferably, each data record also includes the identification code and description of the combined parameters, as shown in Table 3 in the first embodiment.

Step 303: Convert the obtained combined parameters from the JSON format into a preset programming language format.

In this embodiment, to convert the combined parameters from the JSON format to the JAVA format, a JSON-to-JAVA related function may be used for format conversion. The combination parameter in JSON format is actually a JAVA object after being converted into JAVA format, and the JAVA object includes the parameter name and corresponding parameter value of each system parameter in the combination parameter; please refer to the first implementation for the form of the JAVA object JAVA object 2 in the example (JAVA object 2 only includes the parameter name of each system parameter).

Step 304: Extract each system parameter from the combined parameters in the preset programming language format.

In this embodiment, each system parameter is extracted from the JAVA object; that is, the parameter name and the corresponding parameter value of each system parameter are extracted from the JAVA object, and the business system is configured using the parameter value.

In some business systems, it is also necessary to display the obtained system parameters, that is, to display the parameter names and corresponding parameter values of each system parameter. For example, in a certain webpage system displayed on the server, the "version information" of the server needs to be displayed on the webpage ("version information" can be understood as a description of a combination parameter, which belongs to the data record corresponding to the combination parameter), Then, after the server obtains the combination parameter, it will be displayed on the web page.

Among them, when the acquisition command of the combined parameters is generated by the server receiving the request from the client, it usually means that the client needs the combined parameters. Therefore, after the server extracts each system parameter from the combined parameter, it will send each system parameter to the client. terminal, for the client to at least configure the business system according to various system parameters.

It is not difficult to find that this embodiment is an embodiment corresponding to the first or second embodiment, that is, the combined parameters in the JSON format of the business system in the database in this embodiment are actually in accordance with the first or second The data storage method described in the embodiment is stored, so the process of fetching the combination parameter from the database is the reverse process of storing the combination parameter. The relevant technical details mentioned in the first or second embodiment are still valid in this embodiment, and will not be repeated here to reduce repetition. Correspondingly, the relevant technical details mentioned in this implementation manner can also be applied in the first implementation manner.

The fourth embodiment of the present invention relates to a server. As shown in FIG. 6, the server 1 includes at least one processor 10; and a memory 11 communicatively connected to at least one processor; Instructions executed by a processor, the instructions are executed by at least one processor, so that at least one processor can execute the data storage method described in the first or second embodiment. In Fig. 6, only one server 10 and one storage 11 are taken as an example for illustration, but it is not limited thereto.

Further, the server 1 also includes a communication connector 12 for communicating with the database 2 . Wherein, the communication connector can be a wired connector or a wireless connector.

The fifth embodiment of the present invention relates to a server, as shown in FIG. 6 , the server includes at least one processor; and a memory connected to the at least one processor in communication; wherein, the memory stores information executable by the at least one processor. instructions, the instructions are executed by at least one processor, so that at least one processor can execute the data acquisition method described in the third embodiment.

Preferably, the server described in the fifth embodiment of the present invention can also execute the data storage method described in the first or second embodiment.

Wherein, the memory and the processor are connected by a bus, and the bus may include any number of interconnected buses and bridges, and the bus connects one or more processors and various circuits of the memory together. The bus may also connect together various other circuits such as peripherals, voltage regulators, and power management circuits, all of which are well known in the art and therefore will not be further described herein. The bus interface provides an interface between the bus and the transceivers. A transceiver may be one element or multiple elements, such as multiple receivers and transmitters, providing a means for communicating with various other devices over a transmission medium. The data processed by the processor is transmitted on the wireless medium through the antenna, and further, the antenna receives the data and transmits the data to the processor.

The processor manages the bus and general processing, and can also provide various functions including timing, peripheral interfacing, voltage regulation, power management, and other control functions. Instead, memory can be used to store data that the processor uses when performing operations.

The sixth embodiment of the present invention relates to a computer-readable storage medium storing a computer program. The above method embodiments are implemented when the computer program is executed by the processor.

That is, those skilled in the art can understand that all or part of the steps in the method of the above-mentioned embodiments can be completed by instructing related hardware through a program, the program is stored in a storage medium, and includes several instructions to make a device ( It may be a single-chip microcomputer, a chip, etc.) or a processor (processor) to execute all or part of the steps of the methods described in the various embodiments of the present application. The aforementioned storage media include: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), magnetic disk or optical disk and other media that can store program codes. .

Those of ordinary skill in the art can understand that the above-mentioned embodiments are specific examples for realizing the present invention, and in practical applications, various changes can be made to it in form and details without departing from the spirit and spirit of the present invention. scope.

Claims (12)

1. A data storage method, characterized in that it is applied to a server and the server supports a preset programming language, the method comprising: Obtaining at least two system parameters of the selected business system as combined parameters; Encapsulating the combined parameters into the preset programming language format; Converting the combined parameters from the preset programming language format into JSON format; storing the combined parameters in the JSON format of the business system in a database. 2. The data storage method according to claim 1, characterized in that, the preset programming language is JAVA; and storing the combined parameters of the JSON format of the business system into a database specifically includes: Create a JAVA object; the attributes of the JAVA object at least include keywords and actual values; Obtaining an identification mark characterizing the combined parameters; Assigning the identification mark to the keyword, and assigning the combination parameter in JSON format to the actual value; storing the assigned JAVA object in the database. 3. The data storage method according to claim 1, characterized in that, before the said combined parameters are encapsulated into said preset programming language format, said method further comprises: A configuration interface for the combination parameter is provided, so that the combination parameter can be configured through the configuration interface. 4. The data storage method according to claim 1, wherein the at least two selected system parameters are constant parameters. 5. A data acquisition method, characterized in that it is applied to a server and the server supports a preset programming language, the method comprising: When an acquisition command of the combination parameter of the business system is detected, the combination parameter of the JSON format of the business system is obtained from the database; wherein the combination parameter includes at least two system parameters; Converting the obtained combined parameters from JSON format to the preset programming language format; Each of the system parameters is extracted from the combined parameters in the preset programming language format. 6. The data acquisition method according to claim 5, wherein said acquisition of the combined parameters in the JSON format of the business system from the database specifically comprises: Obtaining an identification mark characterizing the combined parameters; Obtain the combination parameter in JSON format corresponding to the identification mark from the database. 7. The data acquisition method according to claim 5, wherein the parameter acquisition command of the business system is an acquisition command of the combined parameters of the business system received from the client; After extracting each of the system parameters from the combined parameters in the preset programming language format, it further includes: sending each of the system parameters to the client, so that the client configures the service system at least according to each of the system parameters. 8. The data acquisition method according to claim 6, wherein the preset programming language is JAVA. 9. A server, characterized in that, comprising: at least one processor; and, a memory communicatively coupled to the at least one processor; wherein, The memory is stored with instructions executable by the at least one processor, the instructions are executed by the at least one processor, so that the at least one processor can perform any one of claims 1 to 4 data storage method. 10. A server, characterized in that, comprising: at least one processor; and, a memory communicatively coupled to the at least one processor; wherein, The memory is stored with instructions executable by the at least one processor, and the instructions are executed by the at least one processor, so that the at least one processor can perform any one of claims 5 to 8. data acquisition method. 11. A computer-readable storage medium storing a computer program, wherein the computer program implements the data storage method according to any one of claims 1 to 4 when executed by a processor. 12. A computer-readable storage medium storing a computer program, wherein the computer program implements the data storage method according to any one of claims 5 to 8 when executed by a processor.