CN111506553A - Database function setting method and device - Google Patents
Database function setting method and device Download PDFInfo
- Publication number
- CN111506553A CN111506553A CN201910098537.9A CN201910098537A CN111506553A CN 111506553 A CN111506553 A CN 111506553A CN 201910098537 A CN201910098537 A CN 201910098537A CN 111506553 A CN111506553 A CN 111506553A
- Authority
- CN
- China
- Prior art keywords
- database
- function
- database connection
- parameter
- parameters
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44505—Configuring for program initiating, e.g. using registry, configuration files
- G06F9/4451—User profiles; Roaming
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer And Data Communications (AREA)
Abstract
One or more embodiments of the present specification provide a method and an apparatus for setting a function of a database, where the method may include: acquiring a database connection parameter set sent by a client, wherein the database connection parameter set comprises special database connection parameters; extracting a first common database connection parameter and a function setting parameter contained in the special database connection parameter; establishing an access session between the client and a database according to the first common database connection parameter; and setting the related functions of the database according to the function setting parameters.
Description
Technical Field
One or more embodiments of the present disclosure relate to the field of database technologies, and in particular, to a method and an apparatus for setting a function of a database.
Background
A database refers to a collection of data stored in a manner that is shareable to multiple users, has as little redundancy as possible, and is independent of the application. When a user wants to access data in a database, the client needs to transmit related database connection parameters to the database, so that an access session is established after authentication is completed, and the database is accessed based on the access session.
Disclosure of Invention
In view of this, one or more embodiments of the present disclosure provide a method and an apparatus for setting a function of a database.
To achieve the above object, one or more embodiments of the present disclosure provide the following technical solutions:
according to a first aspect of one or more embodiments of the present specification, there is provided a function setting method of a database, including:
acquiring a database connection parameter set sent by a client, wherein the database connection parameter set comprises a user name field parameter;
extracting a user name and function setting parameters contained in the user name field parameters;
establishing an access session between the client and a database according to the user name;
and setting the related functions of the database according to the function setting parameters.
According to a second aspect of one or more embodiments of the present specification, there is provided a function setting method of a database, including:
acquiring a database connection parameter set sent by a client, wherein the database connection parameter set comprises special database connection parameters;
extracting a first common database connection parameter and a function setting parameter contained in the special database connection parameter;
establishing an access session between the client and a database according to the first common database connection parameter;
and setting the related functions of the database according to the function setting parameters.
According to a third aspect of one or more embodiments of the present specification, there is provided a function setting method of a database, including:
displaying a connection parameter input interface, wherein the connection parameter input interface comprises input options;
generating special database connection parameters according to user input contents formed aiming at the input options, wherein the special database connection parameters comprise common database connection parameters and function setting parameters;
and sending a database connection parameter set to a database, wherein the database connection parameter set comprises the special database connection parameters, so that the database establishes an access session according to the common database connection parameters and sets related functions of the database according to the function setting parameters.
According to a fourth aspect of one or more embodiments of the present specification, there is provided a function setting method of a database, including:
the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a database connection parameter set sent by a client, and the database connection parameter set comprises a user name field parameter;
the extraction unit is used for extracting a user name and function setting parameters contained in the user name field parameters;
the establishing unit is used for establishing an access session between the client and a database according to the user name;
and the setting unit is used for setting the related functions of the database according to the function setting parameters.
According to a fifth aspect of one or more embodiments of the present specification, there is provided a function setting apparatus of a database, including:
the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a database connection parameter set sent by a client, and the database connection parameter set comprises special database connection parameters;
the extracting unit is used for extracting a first common database connection parameter and a function setting parameter which are contained in the special database connection parameter;
the establishing unit is used for establishing an access session between the client and the database according to the first common database connection parameter;
and the setting unit is used for setting the related functions of the database according to the function setting parameters.
According to a sixth aspect of one or more embodiments of the present specification, there is provided a function setting apparatus for a database, including:
the display unit is used for displaying a connection parameter input interface, and the connection parameter input interface comprises input options;
the generating unit is used for generating special database connection parameters according to user input contents formed aiming at the input options, wherein the special database connection parameters comprise common database connection parameters and function setting parameters;
and the sending unit is used for sending a database connection parameter set to a database, wherein the database connection parameter set comprises the special database connection parameter, so that the database establishes an access session according to the common database connection parameter and sets the related functions of the database according to the function setting parameter.
According to a seventh aspect of one or more embodiments of the present specification, there is provided an electronic device, comprising:
a processor;
a memory for storing processor-executable instructions;
wherein the processor implements the method according to the first, second or third aspect by executing the executable instructions.
According to an eighth aspect of one or more embodiments of the present specification, a computer-readable storage medium is proposed, on which computer instructions are stored, characterized in that the instructions, when executed by a processor, implement the steps of the method according to the first, second or third aspect.
Drawings
Fig. 1 is a schematic architecture diagram of a function setting system of a database according to an exemplary embodiment.
Fig. 2 is a flowchart of a method for setting functions of a database according to an exemplary embodiment.
Fig. 3 is a flowchart of another method for setting functions of a database according to an exemplary embodiment.
FIG. 4 is a schematic diagram of a database login interface provided by an exemplary embodiment.
FIG. 5 is a diagram illustrating a completed database login interface, according to an exemplary embodiment.
FIG. 6 is a schematic diagram illustrating parsing of user input provided by an exemplary embodiment.
Fig. 7 is a diagram illustrating a process for handling a set of database connection parameters, according to an example embodiment.
FIG. 8 is a schematic diagram of another parsing of user input provided by an exemplary embodiment.
FIG. 9 is a schematic diagram of yet another parsing of user input provided by an exemplary embodiment.
Fig. 10 is a schematic diagram of an apparatus according to an exemplary embodiment.
Fig. 11 is a block diagram of a function setting apparatus of a database according to an exemplary embodiment.
Fig. 12 is a schematic structural diagram of another apparatus provided in an exemplary embodiment.
Fig. 13 is a block diagram of another function setting apparatus for a database according to an exemplary embodiment.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with one or more embodiments of the present specification. Rather, they are merely examples of apparatus and methods consistent with certain aspects of one or more embodiments of the specification, as detailed in the claims which follow.
It should be noted that: in other embodiments, the steps of the corresponding methods are not necessarily performed in the order shown and described herein. In some other embodiments, the method may include more or fewer steps than those described herein. Moreover, a single step described in this specification may be broken down into multiple steps for description in other embodiments; multiple steps described in this specification may be combined into a single step in other embodiments.
In an embodiment, the function setting scheme of the database in the present specification may be applied to an electronic device, for example, the electronic device may include any type of mobile phone, tablet device, notebook computer, pda (Personal digital assistants), wearable device (such as smart glasses, smart watch, etc.), and the present specification does not limit this. The electronic device may run a client corresponding to the database, for example, the client may be supported by a BI (business intelligence) tool or other types of applications, and a user may input a corresponding database connection parameter set through the client, and accordingly, access to the database and quick setting of related functions are achieved.
Fig. 1 is a schematic architecture diagram of a function setting system of a database according to an exemplary embodiment. As shown in fig. 1, the system may include a server 11, a network 12, a number of electronic devices such as a PC13, a PC14, and the like.
The server 11 may be a physical server comprising a separate host, or the server 11 may be a virtual server carried by a cluster of hosts. During operation, the server 11 may run a server-side program to be implemented as a server of the application. In one or more embodiments of the present disclosure, the server 11 may cooperate with the clients running on the PCs 13-14 to implement the function setting scheme of the database.
The PC13-14 is only one type of electronic device that a user may use. In fact, it is obvious that the user can also use electronic devices of the type such as: a mobile phone, a tablet device, a notebook computer, a pda (personal digital assistants), a wearable device (such as smart glasses, a smart watch, etc.), etc., which are not limited by one or more embodiments of the present disclosure. During operation, the electronic device may run a client-side program of an application (such as the above-mentioned BI tool or other application) to be implemented as a client of the application, and the electronic device may implement human-computer interaction with a user based on the client, such as acquiring a database connection parameter set input by the user, outputting an access result to the database to the user, and the like.
It is noted that the application of the client may be pre-installed on the electronic device so that the client may be started and run on the electronic device, and of course, when an online "client" such as HTM L5 technology is used, the client may be obtained and run without installing the corresponding application on the electronic device.
And the network 12 for interaction between the PCs 13-14 and the server 11 may include various types of wired or wireless networks. In one embodiment, the Network 12 may include the Public Switched Telephone Network (PSTN) and the Internet.
Fig. 2 is a flowchart of a method for setting functions of a database according to an exemplary embodiment. As shown in fig. 2, the method is applied to a server (e.g., the server 11 shown in fig. 1, etc.), and may include the following steps:
In an embodiment, the special database connection parameters include a first general database connection parameter and a function setting parameter, where the first general database connection parameter is equivalent to a database connection parameter in the related art, for example, the first general database connection parameter may be a user name, a password, a server address or a port number, and the function setting parameter and the first general database connection parameter may be combined and spliced into the special database connection parameter in this specification, so that the function setting parameter for the related function may be transferred to the database without changing a client, thereby conveniently implementing a setting operation for the related function.
In an embodiment, the client may be borne by a BI tool or other applications in the related art, and the database based on the present specification may be compatible with the clients of the applications, so that a user may transmit the function setting parameters through the clients without performing corresponding changes on the clients, and the database may achieve very strong compatibility.
In one embodiment, the database connection parameter set may include one or more specific database connection parameters, which is not limited in this specification. The present specification does not limit the number of function setting parameters included in each specific database connection parameter, and may include one or more function setting parameters, for example.
And 204, extracting the first common database connection parameter and the function setting parameter contained in the special database connection parameter.
In an embodiment, the special database connection parameter may include a predefined special identifier, where the special identifier is used to separate the first general database connection parameter from the function setting parameter; correspondingly, in the process of reading the special database connection parameters, the special identification can be used as identification information, so that the corresponding first common database connection parameters and the corresponding function setting parameters can be accurately extracted. For example, the specific identifier may be a separator, but the specification is not limited thereto.
In an embodiment, the first general database connection parameter and the function setting parameter may be formed by characters in a predetermined character set, and the predetermined character set should not include the above-mentioned special identifier, so as to avoid causing misjudgment.
In one embodiment, the same character may be applied to constitute the first general database connection parameter, the function setting parameter and the special identifier, but it should be ensured that the usage rule of the character in the first general database connection parameter, the function setting parameter is different from the usage rule in constituting the special identifier. Taking the character "%" as an example, assuming that the special identifier is "%" (that is, the usage rule when the special identifier is formed is to use two consecutive "%"), a plurality of consecutive "%" cannot appear in the first general database connection parameter and the function setting parameter, and the two consecutive "%" are prevented from being erroneously recognized as the special identifier.
In an embodiment, the first general database connection parameter is equivalent to a database connection parameter in the related art, and an access session between the client and the database may be established according to the first general database connection parameter, so that the user may access the database based on the access session.
In one embodiment, the database connection parameter set may further include: the second common database connection parameter and the first common database connection parameter both belong to database connection parameters in the related art, and the second common database connection parameter and the first common database connection parameter both belong to different parameter types, for example, the first common database connection parameter is a user name, and the second common database connection parameter is a password. The database connection parameter set may include one or more second general database connection parameters, which is not limited in this specification.
In one embodiment, when the database connection parameters include a server address, a port number, a user name, a password, etc., for example, the user name or some other database connection parameter may be selected as the first general database connection parameter, and the special database connection parameter may be concatenated with the function setting parameter, and the others may be selected as the second general database connection parameter.
When the user name is selected as the first common database connection parameter, the user name is in a plaintext content instead of a hidden form of the password, so that the user can directly see the filled content in the filling process, and the user does not need to worry about filling errors or can find the filling errors in time, and therefore the method has relatively higher convenience. Meanwhile, the content of the user name is usually simple, so that a large number of special characters allowed by the password cannot be contained, and the special characters for distinguishing the connection parameters of the first common database and the function setting parameters are convenient to select. In addition, since the "server address" and the "port number" are used for establishing the basic communication connection, random modification easily causes connection failure, and thus the risk of selecting the "user name" as the first general database connection parameter is relatively low. In addition, the number of characters that can be filled in the input box corresponding to the database connection parameter is usually limited, the content of the server address and the like is usually more, and the content of the user name is usually less, so that when the user name is selected as the first common database connection parameter, more function setting parameters can be relatively accommodated, and the setting efficiency is improved.
And step 208, setting the related functions of the database according to the function setting parameters.
In an embodiment, according to the function setting parameter, the related function may be switched on or off, or a parameter value of the related function may be set; when a plurality of function setting parameters are included at the same time, on-off control can be performed on one part of related functions and the parameter values of the other part of related functions can be set at the same time. For example, the related function may be a native function of the database or an additional function provided by a third party, and the function setting parameter may be used to quickly turn on or off the related function, or change a parameter value of the related function, or the like.
In an embodiment, after the access session is established according to the first general database connection parameter (and possibly related to the second general database connection parameter), the function setting parameter may be saved in the session attribute of the access session; accordingly, when the client calls the related function, the session attribute of the access session may be read, so as to set the related function according to the function setting parameter stored in the session attribute.
In one embodiment, the function setting parameter may be described based on a key-value structure. For example, the function AA may be turned on by "AA ═ on", the function BB may be turned off by "BB ═ off", the parameter CC in the function CC may be assigned to 128 by "CC ═ 128", and the like, which is not limited in the present specification.
In one embodiment, the function setting parameter may be described as a binary string containing sets of character bits corresponding to functions to be set in the database; correspondingly, by reading the values of each group of character bits included in the function setting parameter, the function to be set as the related function can be determined, so as to set the related function according to the read values. For example, assuming that the function setting parameter is a binary string with 3 bits, the first character bit corresponds to the function AA, the second character bit corresponds to the function BB, and the third character bit corresponds to the function CC, when the value of the binary string is "110", it indicates that the function AA is set to the state corresponding to the value "1", the function BB is set to the state corresponding to the value "1", and the function CC is set to the state corresponding to the value "0", or when the value of the binary string is "011", it indicates that the function AA is set to the state corresponding to the value "0", the function BB is set to the state corresponding to the value "1", and the function CC is set to the state corresponding to the value "1"; if the state corresponding to the value of 1 is an on state and the state corresponding to the value of 0 is an off state, the on-off control of the functions AA-CC is realized. For another example, assuming that the function setting parameter is a binary string with 6 bits, the 1 st to 2 nd bits are a group and correspond to the function AA, the 3 rd to 4 th bits are a group and correspond to the function BB, and the 5 th to 6 th bits are a group and correspond to the function CC, when the binary string takes the value "110100", it indicates that the function AA takes the value "11" and the function BB takes the value "01" and the function CC takes the value "00" and corresponds to the state, where each group of bits may represent 4 states, including "00", "01", "10" and "11"; the number of character bits in each group can also be expanded to realize the representation of more states, which is not limited in this specification. In addition, besides the realization of state switching, when a group of character bits corresponds to a parameter to be set of a related function, the values of the group of character bits can also be used for assigning values to the parameter to be set. Compared with the adoption of a key value structure, the length of the function setting parameter can be relatively reduced by adopting the binary character string, and the length limit of the special database connection parameter is avoided being exceeded.
In one embodiment, the function setting parameter is described as a string of n-ary, n > 2; accordingly, the function setting parameters may be converted into a binary string containing sets of character bits corresponding to functions to be set in the database; and then, determining the function to be set as the related function by reading the value of each group of character bits contained in the function setting parameter, and setting the related function according to the read value. Compared with the binary character string, the binary character string can be further converted into the n-ary character string; taking the decimal character string as an example, when the binary character string is "110", it may be converted into a decimal number "6".
Fig. 3 is a flowchart of another method for setting functions of a database according to an exemplary embodiment. As shown in fig. 3, the method applied to an electronic device (e.g., PC13-14 shown in fig. 1, etc.) may include the following steps:
In an embodiment, the input options may include an input box such that the user may enter and form corresponding user input content in the input box. The input option can also be implemented in other forms, for example, the input option can be implemented as a trigger key, so that the user can make a voice when the trigger key is pressed, and further form corresponding user input content through voice recognition. Alternatively, the user input content may be formed in other ways, and this specification does not limit this.
And 304, generating special database connection parameters according to the user input content formed aiming at the input options, wherein the special database connection parameters comprise common database connection parameters and function setting parameters.
In an embodiment, the special database connection parameters include common database connection parameters and function setting parameters, where the common database connection parameters are equivalent to database connection parameters in the related art, for example, the common database connection parameters may be a user name, a password, a server address or a port number, and the like, and in this specification, the function setting parameters and the common database connection parameters may be combined and spliced into the special database connection parameters, so that the function setting parameters for the related functions may be transferred to the database without changing a client, thereby conveniently implementing setting operations for the related functions.
When the user name is selected as the first common database connection parameter, the user name is in a plaintext content instead of a hidden form of the password, so that the user can directly see the filled content in the filling process, and the user does not need to worry about filling errors or can find the filling errors in time, and therefore the method has relatively higher convenience. Meanwhile, the content of the user name is usually simple, so that a large number of special characters allowed by the password cannot be contained, and the special characters for distinguishing the connection parameters of the first common database and the function setting parameters are convenient to select. In addition, since the "server address" and the "port number" are used for establishing the basic communication connection, random modification easily causes connection failure, and thus the risk of selecting the "user name" as the first general database connection parameter is relatively low. In addition, the number of characters that can be filled in the input box corresponding to the database connection parameter is usually limited, the content of the server address and the like is usually more, and the content of the user name is usually less, so that when the user name is selected as the first common database connection parameter, more function setting parameters can be relatively accommodated, and the setting efficiency is improved.
In an embodiment, the client may be borne by a BI tool or other applications in the related art, and the database based on the present specification may be compatible with the clients of the applications, so that a user may transmit the function setting parameters through the clients without performing corresponding changes on the clients, and the database may achieve very strong compatibility.
In an embodiment, the special database connection parameter may include a predefined special identifier, where the special identifier is used to separate the general database connection parameter from the function setting parameter; correspondingly, in the process of reading the special database connection parameters, the special identification can be used as identification information, so that the corresponding common database connection parameters and the corresponding function setting parameters can be accurately extracted. For example, the specific identifier may be a separator, but the specification is not limited thereto.
In an embodiment, the general database connection parameter and the function setting parameter may be formed by characters in a preset character set, and the preset character set should avoid including the above-mentioned special identifier to avoid causing misjudgment.
In one embodiment, the same character may be applied to the connection parameters of the general database, the function setting parameters and the special identifier, but it should be ensured that the usage rules of the character in the connection parameters of the general database and the function setting parameters are different from the usage rules in the formation of the special identifier. For example, if the specific identifier is "%" (that is, the usage rule for forming the specific identifier is to use two consecutive "%"), a plurality of consecutive "%", which cannot be found in the normal database connection parameter and the function setting parameter, is avoided, and two consecutive "%" are mistakenly identified as the specific identifier.
In one embodiment, the database connection parameter set may include one or more specific database connection parameters, which is not limited in this specification. The present specification does not limit the number of function setting parameters included in each specific database connection parameter, and may include one or more function setting parameters, for example.
In an embodiment, the general database connection parameter is equivalent to a database connection parameter in the related art, and an access session between the client and the database may be established according to the general database connection parameter, so that the user may access the database based on the access session.
In one embodiment, the database connection parameter set may further include: other common database connection parameters; for the sake of distinction, it may be assumed that the special database connection parameter includes a first general database connection parameter, and the other general database connection parameter is a second general database connection parameter. The second common database connection parameter and the first common database connection parameter both belong to database connection parameters in the related art, and the second common database connection parameter and the first common database connection parameter both belong to different parameter types, for example, the first common database connection parameter is a user name, and the second common database connection parameter is a password. The database connection parameter set may include one or more second general database connection parameters, which is not limited in this specification.
In one embodiment, when the database connection parameters include a server address, a port number, a user name, a password, etc., for example, the user name or some other database connection parameter may be selected as the first general database connection parameter, and the special database connection parameter may be concatenated with the function setting parameter, and the others may be selected as the second general database connection parameter.
In an embodiment, according to the function setting parameter, the related function may be switched on or off, or a parameter value of the related function may be set; when a plurality of function setting parameters are included at the same time, on-off control can be performed on one part of related functions and the parameter values of the other part of related functions can be set at the same time. For example, the related function may be a native function of the database or an additional function provided by a third party, and the function setting parameter may be used to quickly turn on or off the related function, or change a parameter value of the related function, or the like.
In an embodiment, after the access session is established according to the first general database connection parameter (and possibly related to the second general database connection parameter), the function setting parameter may be saved in the session attribute of the access session; accordingly, when the client calls the related function, the session attribute of the access session may be read, so as to set the related function according to the function setting parameter stored in the session attribute.
In one embodiment, the function setting parameter may be described based on a key-value structure. For example, the function AA may be turned on by "AA ═ on", the function BB may be turned off by "BB ═ off", the parameter CC in the function CC may be assigned to 128 by "CC ═ 128", and the like, which is not limited in the present specification.
In one embodiment, the function setting parameter may be described as a binary string containing sets of character bits corresponding to functions to be set in the database; correspondingly, by reading the values of each group of character bits included in the function setting parameter, the function to be set as the related function can be determined, so as to set the related function according to the read values. For example, assuming that the function setting parameter is a binary string with 3 bits, the first character bit corresponds to the function AA, the second character bit corresponds to the function BB, and the third character bit corresponds to the function CC, when the value of the binary string is "110", it indicates that the function AA is set to the state corresponding to the value "1", the function BB is set to the state corresponding to the value "1", and the function CC is set to the state corresponding to the value "0", or when the value of the binary string is "011", it indicates that the function AA is set to the state corresponding to the value "0", the function BB is set to the state corresponding to the value "1", and the function CC is set to the state corresponding to the value "1"; if the state corresponding to the value of 1 is an on state and the state corresponding to the value of 0 is an off state, the on-off control of the functions AA-CC is realized. For another example, assuming that the function setting parameter is a binary string with 6 bits, the 1 st to 2 nd bits are a group and correspond to the function AA, the 3 rd to 4 th bits are a group and correspond to the function BB, and the 5 th to 6 th bits are a group and correspond to the function CC, when the binary string takes the value "110100", it indicates that the function AA takes the value "11" and the function BB takes the value "01" and the function CC takes the value "00" and corresponds to the state, where each group of bits may represent 4 states, including "00", "01", "10" and "11"; the number of character bits in each group can also be expanded to realize the representation of more states, which is not limited in this specification. In addition, besides the realization of state switching, when a group of character bits corresponds to a parameter to be set of a related function, the values of the group of character bits can also be used for assigning values to the parameter to be set. Compared with the adoption of a key value structure, the length of the function setting parameter can be relatively reduced by adopting the binary character string, and the length limit of the special database connection parameter is avoided being exceeded.
In one embodiment, after obtaining the binary string, the binary string may be converted into an n-ary string as the function setting parameter, where n > 2; taking the decimal character string as an example, when the binary character string is "110", it may be converted into a decimal number "6". Correspondingly, after receiving the function setting parameters, the server can convert the function setting parameters into a binary character string, wherein the binary character string comprises a plurality of groups of character bits corresponding to the functions to be set in the database; and then, determining the function to be set as the related function by reading the value of each group of character bits contained in the function setting parameter, and setting the related function according to the read value.
For the convenience of understanding, the technical solutions of one or more embodiments of the present specification are described by taking the access database "Test" as an example. FIG. 4 is a schematic diagram of a database login interface provided by an exemplary embodiment. Assuming that the user accesses the database through the PC13, the PC13 may present the database login interface 400 shown in fig. 4 to the user, where the database login interface 400 includes input boxes corresponding to various database connection parameters, for example, the database connection parameters may include a database name, a server address, a port number, a user name, a password, and the like, and a corresponding input box exists on the right side of each database connection parameter for the user to fill in.
For example, FIG. 5 is a diagram illustrating a database login interface with completed fills in, according to an exemplary embodiment. Assuming that the user fills in the input box shown in fig. 4 and then presents the status as shown in fig. 5, the database connection parameters in the database login interface 400 include: the database name is "Test", the server address is "192.168.0.100", the port number is "1520", the user name is "hello% agent ═ bi", the password is in an invisible state and is shown "×", and so on.
It should be noted that: in the embodiment shown in fig. 5, the user fills not only the content as the database connection parameter but also the function setting parameter for the preset function in the input box corresponding to the "user name". For example, FIG. 6 is a schematic diagram illustrating parsing of user input provided by an exemplary embodiment. As shown in fig. 6, the content filled in the input box by the user is "hello% agent ═ bi", and can be divided into two main parts, namely, "hello" and "agent ═ bi", and the two main parts are separated by a separator "%"; here, "hello" on the left side of the separator is a database connection parameter corresponding to "user name", and "agent ═ bi" on the right side of the separator is a function switch parameter for function 1, indicating that function 1 is turned on.
The PC13 can generate all the user input contents as shown in fig. 5 as a database connection parameter set and transmit the database connection parameter set to the server 11 for processing. Fig. 7 is a diagram illustrating a process for handling a set of database connection parameters, according to an example embodiment. As shown in fig. 7, after receiving the database connection parameter set, the server 11 may read all database connection parameters included in the database connection parameter set. For example, when the server 11 reads the database name, the server address, the port number, and the password, it may be determined that none of the corresponding "Test", "192.168.0.100", "1520", "(the plaintext password that the server 11 actually reads should be the corresponding one)" contains the separator "%", and thus, the read contents may be taken as values of the corresponding database connection parameters; when the server 11 reads the user name, since the delimiter "%" is included in the "hello% agent ═ bi", the server 11 can determine: the content located on the left side of the delimiter "%" is the value of the database connection parameter "user name", the content located on the right side of the delimiter "%" is the function setting parameter, that is, the value of the "user name" is "hello", and the value of the function setting parameter is "agent ═ bi".
Based on the database name "Test", the server address "192.168.0.100", the port number "1520", the user name "hello", and the corresponding password, the server 11 may authenticate the user; after the authentication is passed, the server 11 may create a corresponding access session for the user, and store the function setting parameter "agent ═ bi" in the session attribute of the access session. Accordingly, in the process of accessing the database "Test" by the user, assuming that a call for the function 1 is involved, the server 11 may read a session attribute of an access session corresponding to the user, and if it is determined that the session attribute includes a function setting parameter "agent ═ bi", the server 11 may determine to open the corresponding function 1.
Similar to the above embodiment, the user may also fill in the input box corresponding to the database connection parameter with the setting parameter for the more functions, which is not limited in this specification. For example, FIG. 8 is a schematic illustration of another parsing of user input provided by an exemplary embodiment. As shown in fig. 8, when the user input content is "hello% agent ═ bi and foo ═ bar,", the content "hello" on the left side of the separator "%" is the value of the database connection parameter "user name", the separator "%" and the first comma "," the content "agent ═ bi between" is the function setting parameter 1, the first comma "," the second comma "," the content "foo ═ bar between" is the function setting parameter 2, and so on. In summary, based on the above form, the user can define parameters such as "agent" and "foo" in the input box of the database connection parameter, for example, define the parameter "agent" as "bi" and the parameter "foo" as "bar", and so on, so as to complete the related function setting, for example, setting the start function 1 by "agent-bi" and setting the start function 2 by "foo-bar".
In the embodiments shown in fig. 6 and 8, the function setting parameters, such as "agent bi", "foo bar", etc., are defined by a "key-value" structure, which may occupy more input space. In order to save input space, another form of function setting parameter may be employed. For example, FIG. 9 is a schematic diagram of yet another parsing of user input provided by an exemplary embodiment. As shown in fig. 9, assuming that there are 3 functions controllable by switches in the database "Test", the function setting parameters for these 3 functions can be represented by a binary character string with a length of 3 character bits, for example, when the user input content is "hello% 101", the content "101" on the right side of the separator "%" is the function setting parameter, where the leftmost character "1" represents an on function 1, the middle character "0" represents an off function 2, and the rightmost character "1" represents an on function 3, so that the switch control for the 3 functions can be represented by only 3 characters, thereby greatly reducing the length of the function setting parameter.
Besides the binary character string, a character string with a higher system can be adopted to simplify the function setting parameters. Taking decimal as an example, the user input may be "hello% 5", where the function setting parameter is "5", which is equivalent to the binary string "101". Accordingly, the server 11, upon receiving the database connection parameter set, may convert the identified function setting parameter "5" into the binary string "101", thereby determining: function 1 on, function 2 off, function 3 on.
FIG. 10 is a schematic block diagram of an apparatus provided in an exemplary embodiment. Referring to fig. 10, at the hardware level, the apparatus includes a processor 1002, an internal bus 1004, a network interface 1006, a memory 1008, and a non-volatile memory 1010, although it may also include hardware required for other services. The processor 1002 reads a corresponding computer program from the nonvolatile memory 1010 into the memory 1008 and then runs the computer program to form a function setting device of the database on a logical level. Of course, besides software implementation, the one or more embodiments in this specification do not exclude other implementations, such as logic devices or combinations of software and hardware, and so on, that is, the execution subject of the following processing flow is not limited to each logic unit, and may also be hardware or logic devices.
Referring to fig. 11, in a software implementation, the function setting device of the database may include:
an obtaining unit 1101, configured to obtain a database connection parameter set sent by a client, where the database connection parameter set includes a special database connection parameter;
an extracting unit 1102, configured to extract a first general database connection parameter and a function setting parameter included in the special database connection parameter;
an establishing unit 1103, configured to establish an access session between the client and the database according to the first general database connection parameter;
a setting unit 1104 for setting the function related to the database according to the function setting parameter.
Optionally, the special database connection parameter includes a predefined special identifier, and the special identifier is used to separate the first general database connection parameter from the function setting parameter.
Optionally, the setting unit 1104 is specifically configured to implement at least one of the following:
and performing on-off control on the related functions and setting the parameter values of the related functions.
Alternatively to this, the first and second parts may,
the device further comprises: a storing unit 1105 that stores the function setting parameter in a session attribute of the access session;
the setting unit 1104 is specifically configured to: and when the client calls the related function, reading the session attribute of the access session so as to set the related function according to the function setting parameters stored in the session attribute.
Optionally, the function setting parameter is described based on a key value structure.
Optionally, the function setting parameter is described as a binary string, the binary string includes a plurality of groups of character bits corresponding to the functions to be set in the database; the setting unit 1104 is specifically configured to:
and determining the function to be set as the related function by reading the values of each group of character bits contained in the function setting parameters, so as to set the related function according to the read values.
Optionally, the function setting parameter is described as a string of n-ary, n > 2; the setting unit 1104 is specifically configured to:
converting the function setting parameters into a binary string, wherein the binary string comprises a plurality of groups of character bits corresponding to functions to be set in the database;
and determining the function to be set as the related function by reading the values of each group of character bits contained in the function setting parameters, so as to set the related function according to the read values.
Optionally, the first common database connection parameter includes at least one of: user name, password, server address, port number.
Optionally, the database connection parameter set further includes: second generic database connection parameters.
FIG. 12 is a schematic block diagram of an apparatus provided in an exemplary embodiment. Referring to fig. 12, at the hardware level, the apparatus includes a processor 1202, an internal bus 1204, a network interface 1206, a memory 1208, and a non-volatile memory 1210, although other hardware required for services may be included. The processor 1202 reads a corresponding computer program from the non-volatile memory 1210 into the memory 1208 and then runs the computer program to form a function setting device of the database on a logic level. Of course, besides software implementation, the one or more embodiments in this specification do not exclude other implementations, such as logic devices or combinations of software and hardware, and so on, that is, the execution subject of the following processing flow is not limited to each logic unit, and may also be hardware or logic devices.
Referring to fig. 13, in a software implementation, the function setting device of the database may include:
the display unit 1301 displays a connection parameter input interface, where the connection parameter input interface includes input options;
a generating unit 1302, configured to generate a special database connection parameter according to user input content formed for the input option, where the special database connection parameter includes a general database connection parameter and a function setting parameter;
the sending unit 1303 is configured to send a database connection parameter set to a database, where the database connection parameter set includes the special database connection parameter, so that the database establishes an access session according to the general database connection parameter, and sets a related function of the database according to the function setting parameter.
The systems, devices, modules or units illustrated in the above embodiments may be implemented by a computer chip or an entity, or by a product with certain functions. A typical implementation device is a computer, which may take the form of a personal computer, laptop computer, cellular telephone, camera phone, smart phone, personal digital assistant, media player, navigation device, email messaging device, game console, tablet computer, wearable device, or a combination of any of these devices.
In a typical configuration, a computer includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic disk storage, quantum memory, graphene-based storage media or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The foregoing description has been directed to specific embodiments of this disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims may be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing may also be possible or may be advantageous.
The terminology used in the description of the one or more embodiments is for the purpose of describing the particular embodiments only and is not intended to be limiting of the description of the one or more embodiments. As used in one or more embodiments of the present specification and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It should also be understood that the term "and/or" as used herein refers to and encompasses any and all possible combinations of one or more of the associated listed items.
It should be understood that although the terms first, second, third, etc. may be used in one or more embodiments of the present description to describe various information, such information should not be limited to these terms. These terms are only used to distinguish one type of information from another. For example, first information may also be referred to as second information, and similarly, second information may also be referred to as first information, without departing from the scope of one or more embodiments herein. The word "if" as used herein may be interpreted as "at … …" or "when … …" or "in response to a determination", depending on the context.
The above description is only for the purpose of illustrating the preferred embodiments of the one or more embodiments of the present disclosure, and is not intended to limit the scope of the one or more embodiments of the present disclosure, and any modifications, equivalent substitutions, improvements, etc. made within the spirit and principle of the one or more embodiments of the present disclosure should be included in the scope of the one or more embodiments of the present disclosure.
Claims (24)
1. A method for setting functions of a database, comprising:
acquiring a database connection parameter set sent by a client, wherein the database connection parameter set comprises a user name field parameter;
extracting a user name and function setting parameters contained in the user name field parameters;
establishing an access session between the client and a database according to the user name;
and setting the related functions of the database according to the function setting parameters.
2. A method for setting functions of a database, comprising:
acquiring a database connection parameter set sent by a client, wherein the database connection parameter set comprises special database connection parameters;
extracting a first common database connection parameter and a function setting parameter contained in the special database connection parameter;
establishing an access session between the client and a database according to the first common database connection parameter;
and setting the related functions of the database according to the function setting parameters.
3. The method according to claim 2, wherein the special database connection parameter comprises a predefined special identifier, and the special identifier is used for separating the first general database connection parameter and the function setting parameter.
4. The method according to claim 2, wherein the setting the related function of the database according to the function setting parameter includes at least one of:
and performing on-off control on the related functions and setting the parameter values of the related functions.
5. The method of claim 2,
the method further comprises the following steps: storing the function setting parameters in session attributes of the access session;
the setting of the related functions of the database according to the function setting parameters comprises the following steps: and when the client calls the related function, reading the session attribute of the access session so as to set the related function according to the function setting parameters stored in the session attribute.
6. The method of claim 2, wherein the function setting parameters are described based on a key value structure.
7. The method of claim 2, wherein the function setting parameters are described as a binary string containing sets of character bits corresponding to functions to be set in the database; the setting of the related functions of the database according to the function setting parameters comprises the following steps:
and determining the function to be set as the related function by reading the values of each group of character bits contained in the function setting parameters, so as to set the related function according to the read values.
8. The method of claim 2, wherein the function setting parameter is described as a string of n-ary, n > 2; the setting of the related functions of the database according to the function setting parameters comprises the following steps:
converting the function setting parameters into a binary string, wherein the binary string comprises a plurality of groups of character bits corresponding to functions to be set in the database;
and determining the function to be set as the related function by reading the values of each group of character bits contained in the function setting parameters, so as to set the related function according to the read values.
9. The method of claim 2, wherein the first generic database connection parameter comprises at least one of: user name, password, server address, port number.
10. The method of claim 1, wherein the database connection parameter set further comprises: second generic database connection parameters.
11. A method for setting functions of a database, comprising:
displaying a connection parameter input interface, wherein the connection parameter input interface comprises input options;
generating special database connection parameters according to user input contents formed aiming at the input options, wherein the special database connection parameters comprise common database connection parameters and function setting parameters;
and sending a database connection parameter set to a database, wherein the database connection parameter set comprises the special database connection parameters, so that the database establishes an access session according to the common database connection parameters and sets related functions of the database according to the function setting parameters.
12. A function setting apparatus for a database, comprising:
the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a database connection parameter set sent by a client, and the database connection parameter set comprises a user name field parameter;
the extraction unit is used for extracting a user name and function setting parameters contained in the user name field parameters;
the establishing unit is used for establishing an access session between the client and a database according to the user name;
and the setting unit is used for setting the related functions of the database according to the function setting parameters.
13. A function setting apparatus for a database, comprising:
the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a database connection parameter set sent by a client, and the database connection parameter set comprises special database connection parameters;
the extracting unit is used for extracting a first common database connection parameter and a function setting parameter which are contained in the special database connection parameter;
the establishing unit is used for establishing an access session between the client and the database according to the first common database connection parameter;
and the setting unit is used for setting the related functions of the database according to the function setting parameters.
14. The apparatus according to claim 13, wherein the special database connection parameter comprises a predefined special identifier, and the special identifier is used to separate the first general database connection parameter and the function setting parameter.
15. The apparatus according to claim 13, wherein the setting unit is specifically configured to implement at least one of:
and performing on-off control on the related functions and setting the parameter values of the related functions.
16. The apparatus of claim 13,
the device further comprises: a storage unit that stores the function setting parameter in a session attribute of the access session;
the setting unit is specifically configured to: and when the client calls the related function, reading the session attribute of the access session so as to set the related function according to the function setting parameters stored in the session attribute.
17. The apparatus of claim 13, wherein the function setting parameters are described based on a key value structure.
18. The apparatus of claim 13, wherein the function setting parameter is described as a binary string containing a number of sets of character bits corresponding to functions to be set in the database; the setting unit is specifically configured to:
and determining the function to be set as the related function by reading the values of each group of character bits contained in the function setting parameters, so as to set the related function according to the read values.
19. The apparatus of claim 13, wherein the function setting parameter is described as a string of n-ary, n > 2; the setting unit is specifically configured to:
converting the function setting parameters into a binary string, wherein the binary string comprises a plurality of groups of character bits corresponding to functions to be set in the database;
and determining the function to be set as the related function by reading the values of each group of character bits contained in the function setting parameters, so as to set the related function according to the read values.
20. The apparatus of claim 13, wherein the first generic database connection parameter comprises at least one of: user name, password, server address, port number.
21. The apparatus of claim 13, wherein the database connection parameter set further comprises: second generic database connection parameters.
22. A function setting apparatus for a database, comprising:
the display unit is used for displaying a connection parameter input interface, and the connection parameter input interface comprises input options;
the generating unit is used for generating special database connection parameters according to user input contents formed aiming at the input options, wherein the special database connection parameters comprise common database connection parameters and function setting parameters;
and the sending unit is used for sending a database connection parameter set to a database, wherein the database connection parameter set comprises the special database connection parameter, so that the database establishes an access session according to the common database connection parameter and sets the related functions of the database according to the function setting parameter.
23. An electronic device, comprising:
a processor;
a memory for storing processor-executable instructions;
wherein the processor implements the method of any one of claims 1-11 by executing the executable instructions.
24. A computer-readable storage medium having stored thereon computer instructions, which, when executed by a processor, carry out the steps of the method according to any one of claims 1-11.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910098537.9A CN111506553B (en) | 2019-01-31 | 2019-01-31 | Function setting method and device for database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910098537.9A CN111506553B (en) | 2019-01-31 | 2019-01-31 | Function setting method and device for database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111506553A true CN111506553A (en) | 2020-08-07 |
| CN111506553B CN111506553B (en) | 2023-07-04 |
Family
ID=71877376
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910098537.9A Active CN111506553B (en) | 2019-01-31 | 2019-01-31 | Function setting method and device for database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111506553B (en) |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101030242A (en) * | 2007-02-12 | 2007-09-05 | 深圳市迈科龙电子有限公司 | Method for controlling database safety access |
| CN101147362A (en) * | 2005-03-22 | 2008-03-19 | 日本电气株式会社 | Connection parameter setting system, method thereof, access point, server, radio terminal, and parameter setting device |
| US20120330954A1 (en) * | 2011-06-27 | 2012-12-27 | Swaminathan Sivasubramanian | System And Method For Implementing A Scalable Data Storage Service |
| CN103002052A (en) * | 2012-12-24 | 2013-03-27 | 百度在线网络技术（北京）有限公司 | Resource positioning method and device in cloud database |
| CN103729471A (en) * | 2014-01-21 | 2014-04-16 | 华为软件技术有限公司 | Method and device for database query |
| CN105516163A (en) * | 2015-12-18 | 2016-04-20 | 网易（杭州）网络有限公司 | Login method, terminal device and communication system |
| CN106776638A (en) * | 2015-11-24 | 2017-05-31 | 大唐软件技术股份有限公司 | Database operation method and device |
| CN107451159A (en) * | 2016-05-31 | 2017-12-08 | 中国移动通信集团广东有限公司 | A kind of data bank access method and device |
| CN107766431A (en) * | 2017-09-18 | 2018-03-06 | 杭州安恒信息技术有限公司 | It is a kind of that Parameter Function Unit method and system are gone based on syntax parsing |
| CN108733720A (en) * | 2017-04-24 | 2018-11-02 | 北京京东尚科信息技术有限公司 | The on-line testing method and check system of the SQL query of multiple database type |
| CN108763536A (en) * | 2018-05-31 | 2018-11-06 | 阿里巴巴集团控股有限公司 | Data bank access method and device |
-
2019
- 2019-01-31 CN CN201910098537.9A patent/CN111506553B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101147362A (en) * | 2005-03-22 | 2008-03-19 | 日本电气株式会社 | Connection parameter setting system, method thereof, access point, server, radio terminal, and parameter setting device |
| CN101030242A (en) * | 2007-02-12 | 2007-09-05 | 深圳市迈科龙电子有限公司 | Method for controlling database safety access |
| US20120330954A1 (en) * | 2011-06-27 | 2012-12-27 | Swaminathan Sivasubramanian | System And Method For Implementing A Scalable Data Storage Service |
| CN103002052A (en) * | 2012-12-24 | 2013-03-27 | 百度在线网络技术（北京）有限公司 | Resource positioning method and device in cloud database |
| CN103729471A (en) * | 2014-01-21 | 2014-04-16 | 华为软件技术有限公司 | Method and device for database query |
| CN106776638A (en) * | 2015-11-24 | 2017-05-31 | 大唐软件技术股份有限公司 | Database operation method and device |
| CN105516163A (en) * | 2015-12-18 | 2016-04-20 | 网易（杭州）网络有限公司 | Login method, terminal device and communication system |
| CN107451159A (en) * | 2016-05-31 | 2017-12-08 | 中国移动通信集团广东有限公司 | A kind of data bank access method and device |
| CN108733720A (en) * | 2017-04-24 | 2018-11-02 | 北京京东尚科信息技术有限公司 | The on-line testing method and check system of the SQL query of multiple database type |
| CN107766431A (en) * | 2017-09-18 | 2018-03-06 | 杭州安恒信息技术有限公司 | It is a kind of that Parameter Function Unit method and system are gone based on syntax parsing |
| CN108763536A (en) * | 2018-05-31 | 2018-11-06 | 阿里巴巴集团控股有限公司 | Data bank access method and device |
Non-Patent Citations (1)
| Title |
|---|
| 张燕: "基于ASP.NET下数据库连接技术分析" * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111506553B (en) | 2023-07-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106802803B (en) | Application data processing method and device | |
| KR102376713B1 (en) | Composite partition functions | |
| CN109218301B (en) | Method and device for mapping frame header defined by software between multiple protocols | |
| CN108432200B (en) | Method for protecting and controlling access to private personal information | |
| CN114329298B (en) | Page presentation method and device, electronic equipment and storage medium | |
| CN110727417B (en) | Data processing method and device | |
| CN111966633A (en) | Method, device, electronic equipment and medium for inquiring child nodes under directory | |
| CN108776587B (en) | Data acquisition method and device, computer equipment and storage medium | |
| CN111427484A (en) | Unread session processing method and device | |
| CN109600458B (en) | Website access method and device | |
| WO2012102731A1 (en) | Utilizing content via personal clouds | |
| US20170289243A1 (en) | Domain name resolution method and electronic device | |
| RU2605041C2 (en) | Methods and systems for displaying microblog topics | |
| CN112380464A (en) | Short link generation method and related equipment | |
| CN105515935A (en) | Interaction information DOI processing method and device | |
| CN109145053B (en) | Data processing method and device, client and server | |
| WO2015000342A1 (en) | Method and client device for accessing webpage | |
| CN111722764A (en) | Message input and display method and device, electronic equipment and readable storage medium | |
| CN105991683A (en) | Data transmission method and device | |
| CN111506553B (en) | Function setting method and device for database | |
| CN111381745B (en) | Page switching method, device and equipment | |
| CN109871260B (en) | Multi-dimensional service current limiting method and system based on shared memory between containers | |
| CN109905486B (en) | Application program identification display method and device | |
| CN105144073A (en) | Removable storage device identity and configuration information | |
| CN107948228A (en) | The means of communication and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |