CN102567481B - Data query filter method and device - Google Patents

Abstract

Embodiments of the present invention provide a data query filtering method and device, which relate to the field of data query, and can provide accurate number of business records, or display the context information of the line matching the input character while displaying the data information of the line, further meet user needs. The business-based query filtering method includes: receiving a request for querying business data, the query request includes a preset pipeline filtering keyword, and the preset pipeline filtering keyword indicates the number of business data records to be queried; The business data to be queried is formatted into a preset display template, wherein one piece of the business data is formatted once to the preset display template; the number of times the preset display template is formatted is counted, and the number is output. The embodiment of the present invention is applied to device data query.

Description

A data query filtering method and device

technical field

The invention relates to the communication field, in particular to a data query filtering method and device.

Background technique

When users query device data, they can filter and display specified data by pipeline. The keywords of pipeline filtering mainly include begin, exclude, include, count, pattern, etc. in:

begin: display all data starting from the matching condition, including matching rows;

exclude: Display all data except matching conditions, that is, matching row data is not displayed, and other data are displayed;

include: only display the data matching the conditions, other data will not be displayed;

count: display the number of rows of data;

pattern: filter by pattern.

At present, the existing technology supports filtering by row. If the business data containing 9 interfaces is filtered by the keyword count, the number of rows of data information contained in the business data will be output, and the information that the user actually wants to obtain is There are 9 interfaces.

Another example: the information about the interface GigabitEthernet0/0/0 is as follows:

GigabitEthernet0/0/0 current state: UP

Line protocol current state: UP

The Maximum Transmit Unit: 1500bytes

input packets: 25334, bytes: 7352989, multicasts: 0

output packets: 25933, bytes: 8726896, multicasts: 0

Directed-broadcast packets:

received packets: 1218, sent packets: 0

forwarded packets: 0, dropped packets: 0

Information about interface GigabitEthernet0/0/1 is as follows:

GigabitEthernet0/0/1current state: DOWN

Line protocol current state: UP

The Maximum Transmit Unit: 1500bytes

input packets: 25334, bytes: 7352989, multicasts: 0

output packets: 25933, bytes: 8726896, multicasts: 0

Directed-broadcast packets:

received packets: 1218, sent packets: 0

forwarded packets: 0, dropped packets: 0

The user wants to see the interface corresponding to the MTU (The Maximum Transmit Unit) bit rate of 1500 bits. If the user enters the command <Route>display ip interface|include Maximum Transmit Unit: 1500bytes, because the existing technology is based on line query, so The result will be output: The Maximum Transmit Unit: 1500bytes, The Maximum Transmit Unit: 1500bytes, only the MTU is displayed here, and the interface is not displayed. The user does not know which interface has an MTU of 1500 bytes. Therefore, the query result of the data query method based on row filtering in the prior art is not accurate enough, and the user may not obtain valuable information.

Contents of the invention

Embodiments of the present invention provide a business-based query and filtering method and device, which can provide accurate business record numbers, or display the context information of a line matching the input character while displaying the line's context information, further satisfying the user's needs. need.

In order to achieve the above object, embodiments of the present invention adopt the following technical solutions:

On the one hand, a service-based query filtering method is provided, including:

Receive a request for querying business data, the request for querying business data includes a preset pipeline filtering keyword, and the preset pipeline filtering keyword indicates the number of business data records to be queried;

Formatting a preset display template with the business data to be queried, wherein one piece of business data to be queried is formatted once in the preset display template;

Count the times of formatting the preset display template, and output the times.

On the other hand, a business-based query filtering method is provided, including:

Receive a request for querying business data, the request for querying business data includes pipeline filtering keywords and input characters;

Using the business data to be queried to format a preset display template, and configuring a display logo on each row of the display template, wherein one piece of the business data to be queried is formatted once in the preset display template, The display flag is used to indicate whether the information in the corresponding row needs to be displayed;

According to the rules indicated by the pipeline filter keyword, query and filter the formatted display template according to the input characters to obtain the data on the template to be displayed;

Displaying and outputting the data information of the line matching the input character on the template to be displayed, and displaying and outputting the data information of the line indicated by the display mark on the template to be displayed.

On the one hand, a service-based query filtering device is provided, including:

The first receiving module is configured to receive a request for querying business data, the request for querying business data includes a preset pipeline filtering keyword, and the preset pipeline filtering keyword indicates the number of business data records to be queried. ;

The first processing module is configured to use the business data to be queried to format a preset display template, where a piece of business data to be queried is formatted once to the preset display template;

The statistical output module is used for counting the times of formatting the preset display template and outputting the times.

On the one hand, a service-based query filtering device is provided, including:

The second receiving module is used to receive a request for querying business data, and the request for querying business data includes pipeline filtering keywords and input characters;

The second processing module is configured to use the business data to be queried to format a preset display template, and set a display mark on each line of the display template, wherein a piece of business data to be queried is formatted once The preset display template, the display flag is used to indicate whether the information of its corresponding row needs to be displayed;

A query filtering module, configured to query and filter the formatted display template according to the input characters according to the rules indicated by the pipeline filtering keywords, to obtain data information on the template to be displayed;

The display output module is used to display and output the data information of the line matching the input character on the template to be displayed, and display and output the data information of the line indicated by the display mark on the template to be displayed.

The business-based query filtering method and device provided by the embodiments of the present invention use the business data to be queried to format a preset display template, wherein a piece of business data to be queried is formatted once to a preset display template; statistical formatting Output after the preset times of displaying the template. Compared with the row-based query in the prior art, the number of business records obtained based on the business query can be provided, which meets the precise needs of users.

Use the business data to be queried to format a preset display template, and set a display mark on each row of the display template, where a piece of business data to be queried is formatted once in a preset display template, and the display mark is used to indicate its corresponding row Whether the information needs to be displayed; according to the indicated rules, query and filter the formatted display template according to the input characters, and obtain the template to be displayed; display and output the data information of the line matching the input characters on the template to be displayed, and display the output on the template to be displayed The display identifier indicates the data information for the displayed row. Compared with only displaying the matching result in the prior art, it is possible to display the context information of the data information of the line matching the input character while displaying the data information of the line, so as to further meet the needs of users.

Description of drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following will briefly introduce the accompanying drawings that need to be used in the description of the embodiments. Obviously, the accompanying drawings in the following description are only some embodiments of the present invention. For Those of ordinary skill in the art can also obtain other drawings based on these drawings without making creative efforts.

FIG. 1 is a schematic flow chart of a service-based query filtering method provided by an embodiment of the present invention;

FIG. 2 is a schematic flowchart of another service-based query filtering method provided by an embodiment of the present invention;

Fig. 3 is a schematic diagram of a display template provided by an embodiment of the present invention;

FIG. 4 is a schematic diagram of another display template provided by an embodiment of the present invention;

FIG. 5 is a schematic structural diagram of a service-based query filtering device provided by an embodiment of the present invention;

FIG. 6 is a schematic structural diagram of a first processing module provided by an embodiment of the present invention;

FIG. 7 is a schematic structural diagram of another service-based query filtering device provided by an embodiment of the present invention.

Detailed ways

The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

The service-based query filtering method provided by the embodiment of the present invention, as shown in Figure 1, includes the following steps:

S101, the query filtering device receives a request for querying service data, the request for querying service data includes a preset pipeline filtering keyword, and the preset pipeline filtering keyword indicates the number of service data records to be displayed to be queried.

S102. The query filtering device uses the service data to be queried to format a preset display template, wherein one piece of service data to be queried formats a preset display template.

S103. The query filtering device counts the number of times the preset display template is formatted, and outputs the number of times.

Compared with the row-based query in the prior art, the service-based query and filtering method provided by the embodiment of the present invention can provide the number of service records obtained based on the service query, which meets the precise needs of users.

For example, the preset pipeline filtering keyword in S101 above may be "record". Of course, "record" is just an example. The pipeline filtering keyword here includes but is not limited to "record". As long as the pipeline filtering keyword set here can Just implement this function, and it is used to display the number of records of the business data to be queried. Of course, the pipeline filtering keywords here can also include: display all data starting from the matching condition, including the keyword "begin" of the matching row; or display all data except the matching condition, that is, the matching row data is not displayed, and other data are displayed The keyword "exclude"; or the keyword "include" that only displays the data that matches the condition, and other data is not displayed; or the keyword "count" that displays the number of rows of data; or the keyword "pattern" that filters by pattern, etc. .

Taking the embodiment of the present invention as an example, it is only necessary to display the number of service data records to be queried. For example, assuming that the query request here is the number of user query interfaces, you can enter the command line: <Route>display ip interface brief|record. It is assumed here that the service data in Table 1 below, that is, interface (Interface) data, needs to be queried and filtered.

interface IP Address/Mask Physical Protocol 1 Aux0/0/1 unassigned down down 2 Eth-Trunk2 unassigned down down 3 GigabitEthernet0/0/0 10.137.129.28/23 up up 4 LoopBack0 1.2.3.4/32 up ups) 5 NULL0 unassigned up ups) 6 Virtual-Template0 unassigned up ups) 7 Vlanif10 unassigned down down 8 Vlanif11 unassigned down down 9 Vlanif100 unassigned down down

Table 1

The above data is stored by row in the server, such as the name of the interface "Aux0/0/1" in the first row of Table 1 and the current uplink and downlink status: Aux0/0/1 current state, and the current status of the line protocol: Line protocol current state information can be expressed as:

Aux0/0/1 current state: DOWN

Line protocol current state: DOWN

Therefore, all 9 interface information in Table 1 can be displayed and recorded in 18 lines of data information.

For example, the content of the display template in the above S102 can be pre-set according to the query filtering requirements. In addition, it should be noted that a start tag needs to be set before the first display template formatted by the business data to be queried to identify Record the start of business data, so as to count the times of formatting the preset display template. Exemplarily, as shown in Figure 3, <interface information begin/> (interface information begins) is set before the display template of the business data to be queried to identify the start of counting the business data to be queried, wherein the content in the display template Including: interface name and current uplink and downlink status, current status of uplink protocol, last uplink time of uplink protocol, remark description information, maximum number of transmission unit bits and network address. Here, only the interface business data is used as an example to list some types of data information of the interface. Of course, the business data to be queried may also include other types of business data, and the data information of the interface may also include other types of data information. In the example shown here, the template is preferably implemented in a procedural language, and of course it can also be implemented in other languages such as C and scripting languages.

In the above S103, the query filtering device counts the number of times the preset display template is formatted, and outputs the number of times. For example, as long as the number of times the display template with the start tag mark is formatted is calculated, the business record to be queried can be obtained Number of bars. Finally, the total number of business records is output. For example, the above Table 1 is still used as an example. Of course, at this time, the content definition query data information type in the display template is: interface name, current uplink and downlink status, and maximum transmission unit bits. number, the displayed result is: Total interface: 9, which means that there are currently 9 interfaces, and based on the traditional line query technology, the result of 18 lines of information output will be obtained.

The business-based query filtering method provided by the embodiments of the present invention uses the business data to be queried to format a preset display template, wherein a piece of business data to be queried is formatted once to a preset display template; the statistical format is preset The number of times the template is displayed after the output. Compared with the row-based query in the prior art, the number of business records obtained based on the business query can be provided, which meets the precise needs of users.

The service-based query filtering method provided by the embodiments of the present invention, as shown in Figure 2, includes the following steps:

S301. The query filtering device receives a request for querying service data, and the request for querying service data includes a channel filtering keyword and input characters.

S302, the query filtering device formats a preset display template with the above-mentioned service data to be queried, and configures a display mark on each line of the display template, wherein, a piece of business data to be queried is formatted once with a preset display template, and displayed Indicates whether the information indicating its corresponding row needs to be displayed.

S303, the query filtering device queries and filters the formatted display template according to the input characters according to the rules indicated by the pipeline filtering keywords, and obtains data information on the template to be displayed.

S304, the query filtering device displays and outputs the data information of the line matching the input character on the template to be displayed, and displays and outputs the data information of the line indicated by the display mark on the template to be displayed.

The business-based query filtering method provided by the embodiment of the present invention uses the business data to be queried to format a preset display template, and sets a display mark on each line of the display template, wherein a piece of business data to be queried is formatted once Pre-set display template, the display flag is used to indicate whether the information of the corresponding row needs to be displayed; according to the indicated rules, query and filter the formatted display template according to the input characters, and obtain the data information on the template to be displayed; display output to be displayed The data information of the line matching the input characters on the template, and displaying and outputting the data information of the line indicated by the display mark on the template to be displayed. Compared with only displaying the matching result in the prior art, it is possible to display the context information of the data information of the line matching the input character while displaying the data information of the line, so as to further meet the needs of users.

For example, the pipeline filtering keyword in S301 above may include: displaying all data starting from the matching condition, including the keyword "begin" of the matching row; or displaying all data except the matching condition, that is, the matching row data is not displayed , the keyword "exclude" for displaying other data; or the keyword "include" for only displaying data that matches the condition, but not for other data; or the keyword "count" for displaying the number of rows of data; or the keyword for filtering by pattern "count" etc.

Exemplary selection input pipeline filter keyword "include" in the present embodiment, if the user wants to inquire MTU (Maximum Transmit Unit, maximum transmission unit) is the interface corresponding to 1500bytes (bit), then can input order <Route>display ip interface |includeMaximum Transmit Unit: 1500bytes.

For example, the content of the display template in the above S302 can be pre-set according to the query and filtering requirements. In addition, a display identifier needs to be configured on each row of the display template. Exemplarily, the display identifier here is set on each row , including the must-display logo "must see: true" and the non-must-display logo "must see: false" (here, the method of displaying the logo using the tags "must see: true" and "must see: false" is just an example Of course, other tags can also be used; in addition, the display logo here is realized by setting a tag on each row of the display template, of course, it can also be configured by configuring a form for each row of the corresponding display template that allows users to select the display row, that is, as long as The same function can be achieved), where the must-display flag is used to indicate that the row of data information will be displayed when displayed, and will not be filtered out. As shown in Figure 4, add "" after each row of data information must see: true" or "must see: false" to identify the display status of the data information in the query results. Wherein, the content setting in the display template is as shown in the previous embodiment. Here, the display mark is realized by setting a mark in each row of the display template, of course, it may also be a method such as configuring a form corresponding to each row of the display template for the user to select the display row. In the example shown here, the template is preferably implemented in a procedural language, and of course it can also be implemented in other languages such as C language and scripting language.

In the above S303, the query filtering device queries and filters the formatted display template according to the input characters according to the rules indicated by the pipeline filtering keywords, and obtains the data information on the template to be displayed, for example, according to the input pipeline filtering The keyword "include", that is: only the data matching the conditions will be displayed, and other data will not be displayed. If the user wants to query the interface whose MTU (Maximum Transmit Unit, maximum transmission unit) is 1500bytes (bit), then enter the command <Route>display ip interface|include Maximum Transmit Unit: 1500bytes and the rule indicated by the filtering keyword "include" filters the formatted display template, and obtains the MTU (Maximum Transmit Unit, maximum transmission unit) that the user wants to query is corresponding to 1500bytes (bits) The data information on the display template where the interface information is located is used as the data information on the template to be displayed, that is, the data information on the display template that includes "include Maximum Transmit Unit: 1500bytes", where include Maximum Transmit Unit: 1500bytes is the input character.

In the above S304, the query filtering device displays and outputs the data information of the row matching the input character on the template to be displayed, and displays and outputs the data information of the row indicated by the display mark on the template to be displayed, for example, displays the data information of the matching input character and Must-display data information of business data containing matching information, the exemplary display results are:

GigabitEthernet0/0/0 current state: UP

The Maximum Transmit Unit: 1500bytes

GigabitEthernet0/0/1 current state: UP

The Maximum Transmit Unit: 1500bytes

That is to say, the interface corresponding to the maximum transmission unit of 1500bytes (bits): GigabitEthernet0/0/0, the current state is uplink; the other interface corresponding to the maximum transmission unit of 1500bytes (bits): GigabitEthernet0/0/1, the current state is uplink . Among them, "GigabitEthernet0/0/0 current state: UP" and "GigabitEthernet0/0/1 current state: UP" are the context part of the display indication indication, and the two "The MaximumTransmit Unit: 1500bytes" are the display part of matching input characters.

The business-based query filtering method provided by the embodiment of the present invention, compared with the prior art that only displays the matching results, can display the data information of the line matching the input character and at the same time display the context information of the data information of the line, further satisfying User needs.

Corresponding to the above method embodiment, the service-based query filtering device 50 provided for the embodiment of the present invention can be applied to the above method embodiment shown in FIG. 1 , as shown in FIG. 5 , including: a first receiving module 51, a first Processing module 52 and statistical output module 53, wherein:

The first receiving module 51 is configured to receive a request for querying business data, the query request includes a preset pipeline filtering keyword, and the preset pipeline filtering keyword indicates the number of business data records to be displayed to be queried.

The first processing module 52 is configured to use the above-mentioned service data to be queried to format a preset display template, wherein a piece of the above-mentioned service data to be queried is formatted once to a preset display template.

The statistical output module 53 is configured to count the number of times of formatting the preset display template, and output the number of times.

The business-based query filtering device provided by the embodiments of the present invention uses the business data to be queried to format a preset display template, wherein a piece of business data to be queried is formatted once to a preset display template; the statistical format is preset The number of times the template is displayed after the output. Compared with the row-based query in the prior art, the number of business records obtained based on the business query can be provided, which meets the precise needs of users.

Further, as shown in FIG. 6, the first processing module 52 also includes a start tag setting unit 521, which is used to set the start tag before the first display template of the business data format to be queried, so as to facilitate statistical formatting in advance. Set the number of times to display the template.

Corresponding to the above method embodiment, the service-based query filtering device 60 provided by another embodiment of the present invention can be applied to the above method embodiment corresponding to FIG. 2 , as shown in FIG. 7 , including: a second receiving module 61, a second Processing module 62, query filter module 63 and display output module 64, wherein:

The second receiving module 61 is configured to receive a request for querying service data, and the query request includes pipeline filtering keywords and input characters.

The second processing module 62 is used to format a preset display template with the above-mentioned business data to be queried, and set a display mark on each line of the display template, wherein a piece of business data to be queried is formatted once with a preset display template , the display flag is used to indicate whether the information of its corresponding row needs to be displayed.

For example, the display identification set by the second processing module 62 on each row of the display template includes: required display information and non-required display information; wherein, the required display information is used to indicate that the information of its corresponding row needs to be displayed; Information is used to indicate that the information of its corresponding row does not need to be displayed.

The query filtering module 63 is configured to query and filter the formatted display template according to the input characters according to the rules indicated by the pipeline filtering keywords, so as to obtain data information on the template to be displayed.

The display output module 64 is configured to display and output the data information of the line matching the input character on the template to be displayed, and display and output the data information of the line indicated by the display mark on the template to be displayed.

The service-based query filtering device provided by the embodiment of the present invention uses the service data to be queried to format a preset display template, and sets a display mark on each line of the display template, wherein a piece of service data to be queried is formatted once Pre-set display template, the display flag is used to indicate whether the information of the corresponding row needs to be displayed; according to the indicated rules, query and filter the formatted display template according to the input characters, and obtain the data information on the template to be displayed; display output to be displayed The data information of the line matching the input characters on the template, and displaying and outputting the data information of the line indicated by the display mark on the template to be displayed. Compared with only displaying the matching result in the prior art, it is possible to display the context information of the data information of the line matching the input character while displaying the data information of the line, so as to further meet the needs of users.

Those of ordinary skill in the art can understand that all or part of the steps for realizing the above-mentioned method embodiments can be completed by hardware related to program instructions, and the aforementioned program can be stored in a computer-readable storage medium. When the program is executed, the It includes the steps of the above method embodiments; and the aforementioned storage medium includes: ROM, RAM, magnetic disk or optical disk and other various media that can store program codes.

The above is only a specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Anyone skilled in the art can easily think of changes or substitutions within the technical scope disclosed in the present invention. Should be covered within the protection scope of the present invention. Therefore, the protection scope of the present invention should be determined by the protection scope of the claims.

Claims (8)

1. A data query filtering method, characterized in that, comprising: Receive a request for querying business data, the request for querying business data includes a preset pipeline filtering keyword, and the preset pipeline filtering keyword indicates the number of business data records to be displayed to be queried; Formatting a preset display template with the business data to be queried, wherein one piece of business data to be queried is formatted once in the preset display template; Counting the times of formatting the preset display template, outputting the times, and using the times as the number of business data records to be queried. 2. The method according to claim 1, wherein said formatting a preset display template with said business data to be queried comprises: A start tag is set before the first display template formatted by the service data to be queried, so as to count the number of preset display templates formatted. 3. A data query filtering method, characterized in that, comprising: Receive a request for querying business data, the request for querying business data includes pipeline filtering keywords and input characters; format a preset display template with the business data to be queried, and configure a display logo on each row of the display template, where a piece of the business data to be queried is formatted once in the preset display template, and the The display flag is used to indicate whether the information of its corresponding row needs to be displayed; According to the rules indicated by the pipeline filtering keywords, query and filter the formatted display template according to the input characters, and obtain the data information on the template to be displayed; Displaying and outputting the data information of the line matching the input character on the template to be displayed, and displaying and outputting the data information of the line indicated by the display mark on the template to be displayed. 4. The method according to claim 3, wherein the display mark includes a must-display mark and a non-must-display mark; wherein, the must-display mark is used to indicate that the information of its corresponding row needs to be displayed; the non-must-display mark The mandatory flag is used to indicate that the information in the corresponding row does not need to be displayed. 5. A data query filtering device, characterized in that, comprising: The first receiving module is configured to receive a request for querying business data, the request for querying business data includes a preset pipeline filtering keyword, and the preset pipeline filtering keyword indicates the number of business data records to be displayed to be queried; The first processing module is configured to use the business data to be queried to format a preset display template, wherein a piece of business data to be queried is formatted once to the preset display template; The statistical output module is used to count the number of times of the formatted preset display template, and output the number of times, and the number of times is used as the number of business data records to be queried. 6. The device according to claim 5, wherein the first processing module comprises: The start tag setting unit is configured to set a start tag before the first display template formatted by the business data to be queried, so as to count the times of formatting the preset display templates. 7. A data query filtering device, characterized in that, comprising: The second receiving module is used to receive a request for querying business data, and the request for querying business data includes pipeline filtering keywords and input characters; The second processing module is used to format a preset display template with the business data to be queried, and configure a display mark on each row of the display template, wherein a piece of the business data to be queried is formatted once in the preset A set display template, the display identifier is used to indicate whether the information of its corresponding row needs to be displayed; A query filtering module, configured to query and filter the formatted display template according to the input characters according to the rules indicated by the pipeline filtering keywords, to obtain data information on the template to be displayed; The display output module is used to display and output the data information of the line matching the input character on the template to be displayed, and display and output the data information of the line indicated by the display mark on the template to be displayed. 8. The device according to claim 7, wherein the display identifier configured by the second processing module on each row of the display template includes: a must-display identifier and a non-must-display identifier; wherein, the mandatory The displayed flag is used to indicate that the information in the corresponding row needs to be displayed; the non-obvious flag is used to indicate that the information in the corresponding row does not need to be displayed.

Images