Multi-dimensional display carrier display method and device, terminal equipment and computer medium
By generating a set of configuration information and using SQL statements for configuration rendering, the problems of low display efficiency and insufficient scalability in existing technologies are solved, and efficient multi-dimensional data display is achieved.
Patent Information
- Application Number
- CN202110867573.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-07-28
- Publication Date
- 2025-11-11
- Estimated Expiration
- 2041-07-28
AI Technical Summary
Existing technologies have low display efficiency in scenarios with large amounts of data, and cannot extend the query logic of database tables beyond the processing capacity of pre-configured content, thus affecting the display effect.
By generating a set of configuration information, including a source configuration information set, an indicator dimension configuration information set, and a filter condition configuration information set, a multi-dimensional display carrier is generated based on the user's query request. SQL statements are used for configuration and rendering, avoiding redundant development.
It improved the efficiency and quality of the display platform, shortened the generation time, met business needs, and enhanced the display effect.
Smart Images

Figure CN115687738B_ABST
Abstract
Description
Technical Field
[0001] The embodiments disclosed herein relate to the field of computer technology, and specifically to page display carrier display methods, apparatus, terminal devices, and computer media. Background Technology
[0002] With the continuous advancement of information technology construction, most medium and large-sized enterprises and institutions have established relatively complete basic information systems such as office systems and customer management systems. These systems share a common characteristic: business personnel or users perform numerous operations on the database, including adding, modifying, and deleting data—that is, online transaction processing. After the systems have been running for a period of time, they inevitably help enterprises and institutions collect a large amount of historical data. Analyzing and processing this large amount of data, which exists independently and separately in the database, and presenting it to business personnel and managers in various display formats to provide them with useful information and support decision-making is a crucial aspect of business intelligence.
[0003] However, the following technical problems often arise when using display media to present multi-dimensional data and information:
[0004] Current technologies can only filter and display data from a pre-existing database. If the filtering criteria include an enumeration dropdown, all rows are scanned to retrieve the enumerated dropdown values, which is extremely slow in scenarios with large datasets, impacting the display efficiency of the platform. Furthermore, current technologies can only filter data from an existing database using a pre-configured approach. When the query logic of the database table exceeds the processing capacity of the pre-configured content, further expansion is impossible, failing to meet business needs and affecting the display effect of the platform. Summary of the Invention
[0005] The summary portion of this disclosure is intended to provide a brief overview of the concepts, which will be described in detail in the detailed description portion. This summary portion is not intended to identify key or essential features of the claimed technical solutions, nor is it intended to limit the scope of the claimed technical solutions.
[0006] Some embodiments of this disclosure propose multi-dimensional display carrier display methods, apparatuses, terminal devices, and computer media to solve one or more of the technical problems mentioned in the background section above.
[0007] In a first aspect, some embodiments of this disclosure provide a multi-dimensional display carrier display method, the method comprising: obtaining a query request sent by a user, wherein the query request represents a target configuration information set code, the target configuration information set code represents the storage address of the target configuration information set, the target configuration information set includes a target source configuration information set, a target indicator dimension configuration information set, and a target filtering condition configuration information set; generating a display carrier according to the query request; and sending the display carrier to a target terminal device, wherein the target terminal device displays the display carrier.
[0008] Secondly, some embodiments of this disclosure provide a multi-dimensional display carrier display device, which includes: an acquisition unit configured to acquire a query request sent by a user, wherein the query request represents a target configuration information set code, the target configuration information set code represents the storage address of the target configuration information set, and the target configuration information set includes a target source configuration information set, a target indicator dimension configuration information set, and a target filtering condition configuration information set; a generation unit configured to generate a display carrier according to the query request; and a sending unit configured to send the display carrier to a target terminal device, wherein the target terminal device displays the display carrier.
[0009] Thirdly, some embodiments of this disclosure provide a terminal device, including: one or more processors; and a storage device having one or more programs stored thereon, wherein when the one or more programs are executed by the one or more processors, the one or more processors implement any of the methods in the first aspect.
[0010] Fourthly, some embodiments of this disclosure provide a computer-readable medium having a computer program stored thereon, wherein the program, when executed by a processor, implements any of the methods in the first aspect.
[0011] The above embodiments of this disclosure have the following beneficial effects: the multi-dimensional display carrier display method of some embodiments of this disclosure can directly call the target configuration information set according to the query request sent by the user to generate a multi-dimensional display carrier through configuration, thereby improving the display efficiency of the display carrier and shortening the generation time of the display carrier. Specifically, the inventors have found that the reason for the poor generation efficiency and level of the current display carrier is that the existing technology can only filter and display through a pre-created database. If the filtering condition is an enumeration dropdown, it will scan all rows to obtain the enumeration dropdown value, which is very slow in the case of large data volume, affecting the display efficiency of the display carrier. In addition, the existing technology can only filter the existing database through a preset method. When the query logic of the database table exceeds the processing capacity of the preset configuration content, it cannot be further expanded, thereby failing to meet business needs and affecting the display effect of the display carrier. Based on this, firstly, some embodiments of this disclosure generate a configuration information set according to the historical source database, wherein the configuration information set includes a source configuration information set, an indicator dimension configuration information set, and a filtering condition configuration information set. After storing the configuration information set in the first terminal, the configuration item set code containing the stored configuration information set is obtained. Then, a query request from the user is received, where the query request represents the target configuration information set code. The target configuration information set code represents the storage address of the target configuration information set, which includes the target source configuration information set, the target indicator dimension configuration information set, and the target filtering condition configuration information set. Next, a display carrier is generated based on the query request. Specifically, the user's query requirements are obtained from the query request, and a multi-dimensional display carrier is generated based on these requirements. Finally, the display carrier is sent to the target terminal device, where it is displayed. This method changes the traditional approach of determining the display content by writing code to a visual determination method using a pre-set configuration information set. It considers multi-dimensional target indicator filtering, making it easier for users to determine the display content based on their query requests, thereby improving the display level and efficiency of the display carrier. Attached Figure Description
[0012] The above and other features, advantages, and aspects of the embodiments of this disclosure will become more apparent from the accompanying drawings and the following detailed description. Throughout the drawings, the same or similar reference numerals denote the same or similar elements. It should be understood that the drawings are schematic, and the originals and elements are not necessarily drawn to scale.
[0013] Figure 1 This is an architecture diagram of an exemplary system to which some embodiments of this disclosure can be applied;
[0014] Figure 2This is a flowchart of some embodiments of the multi-dimensional display carrier display method according to this disclosure;
[0015] Figure 3 This is a flowchart of some embodiments of the multi-dimensional display carrier display device according to the present disclosure;
[0016] Figure 4 This is a schematic diagram of the structure of a terminal device suitable for implementing some embodiments of the present disclosure. Detailed Implementation
[0017] Embodiments of this disclosure will now be described in more detail with reference to the accompanying drawings. While some embodiments of this disclosure are shown in the drawings, it should be understood that this disclosure can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided to provide a more thorough and complete understanding of this disclosure. It should be understood that the accompanying drawings and embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of protection of this disclosure.
[0018] It should also be noted that, for ease of description, only the parts relevant to the invention are shown in the accompanying drawings. Unless otherwise specified, the embodiments and features described in this disclosure can be combined with each other.
[0019] It should be noted that the concepts of "first" and "second" mentioned in this disclosure are used only to distinguish different devices, modules or units, and are not used to limit the order of functions performed by these devices, modules or units or their interdependencies.
[0020] It should be noted that the terms "a" and "a plurality of" used in this disclosure are illustrative rather than restrictive, and those skilled in the art should understand that, unless otherwise expressly indicated in the context, they should be understood as "one or more".
[0021] This disclosure will now be described in detail with reference to the accompanying drawings and embodiments.
[0022] Figure 1 An exemplary system architecture 100 is shown, in which embodiments of the multi-dimensional display carrier display method of this disclosure can be applied.
[0023] like Figure 1 As shown, system architecture 100 may include terminal devices 101, 102, and 103, a network 104, and a server 105. Network 104 serves as the medium for providing communication links between terminal devices 101, 102, and 103 and server 105. Network 104 may include various connection types, such as wired or wireless communication links, or fiber optic cables, etc.
[0024] Users can use terminal devices 101, 102, and 103 to interact with server 105 via network 104 to receive or send messages, etc. Various communication client applications can be installed on terminal devices 101, 102, and 103, such as information processing applications, display applications, and data analysis applications.
[0025] Terminal devices 101, 102, and 103 can be either hardware or software. When terminal devices 101, 102, and 103 are hardware, they can be various terminal devices with displays, including but not limited to smartphones, tablets, laptops, and desktop computers. When terminal devices 101, 102, and 103 are software, they can be installed on the terminal devices listed above. They can be implemented as multiple software programs or software modules (e.g., used to provide query request input), or as a single software program or software module. No specific limitations are imposed here.
[0026] Server 105 can be a server that provides various services, such as a server that stores query requests input by terminal devices 101, 102, and 103. The server can process the received query requests and feed back the processing results (such as display media) to the terminal devices.
[0027] It should be noted that the multi-dimensional display carrier display method provided in this embodiment can be executed by the server 105 or by the terminal device.
[0028] It should be noted that the query request can also be stored locally on the server 105. The server 105 can directly extract the query request from the local machine, process it, and obtain the display carrier. In this case, the exemplary system architecture 100 may not include the terminal devices 101, 102, 103 and the network 104.
[0029] It should also be noted that multi-dimensional display carrier applications can also be installed on terminal devices 101, 102, and 103. In this case, the processing method can also be executed by terminal devices 101, 102, and 103. In this case, the exemplary system architecture 100 may not include server 105 and network 104.
[0030] It should be noted that server 105 can be either hardware or software. When server 105 is hardware, it can be implemented as a distributed server cluster consisting of multiple servers, or as a single server. When server 105 is software, it can be implemented as multiple software programs or software modules (for example, used to provide multi-dimensional display services), or as a single software program or software module. No specific limitations are made here.
[0031] It should be understood that Figure 1The number of terminal devices, networks, and servers shown is merely illustrative. Depending on implementation needs, any number of terminal devices, networks, and servers can be included.
[0032] Continue to refer to Figure 2 The flowchart 200 illustrates some embodiments of the multi-dimensional display carrier display method according to the present disclosure. The multi-dimensional display carrier display method includes the following steps:
[0033] Step 201: Obtain the query request sent by the user.
[0034] In some embodiments, the executing entity of the multi-dimensional display carrier method (e.g.) Figure 1 The server shown receives a query request from the user. The query request represents the target configuration information set code, which represents the storage address of the target configuration information set. The target configuration information set includes the target source configuration information set, the target indicator dimension configuration information set, and the target filtering condition configuration information set.
[0035] Optionally, prior to the above method, the executing entity obtains the source database and the configuration instructions input by the user. Specifically, the source database can be a historical database generated by the information system. The configuration instructions input by the user can be instructions for querying and displaying the source database. Based on the source database, a set of configuration information is generated. This set includes a source configuration information set, an indicator dimension configuration information set, and a filter condition configuration information set. Optionally, the source configuration information set is determined from the source database according to the configuration instructions. This source configuration information set includes a first number of source configuration information entries, each representing a data table name. Specifically, the source configuration information set may contain only one source configuration information entry. Alternatively, it may contain more than one source configuration information entry; the data tables corresponding to more than one source configuration information entry can be concatenated to obtain the source configuration information set. According to the configuration instructions, an indicator dimension configuration information set is generated, including a second number of indicator dimension configuration information entries. Optionally, the indicator dimension configuration information set includes multi-dimensional indicator dimension configuration information, which may include, but is not limited to, one of the following: date, subject, region, or category. Specifically, the indicator dimension configuration information can be the data columns used for display. Indicator dimension configuration information can also include, but is not limited to, one of the following: column identifier, header display name, text alignment indicator, sorting support indicator, header filtering support indicator, display style, thousandths place handling indicator, and decimal place handling indicator. Specifically, the display name can be the name of the display medium. The column identifier can be used to represent the field values of the data column. The sorting support indicator can be displayed as a sort button, indicating whether the user has sorted the displayed data. The header filtering indicator can be displayed as a filter button, indicating whether the user has filtered the displayed data. The thousandths place handling indicator and the decimal place handling indicator can represent uniform formatting of the data field values obtained from the query. The display style can represent support for controlling the background color and text color of each cell in the display medium. Based on the configuration instructions, a filter condition configuration information set is generated. Specifically, the values of each filter condition configuration information in the filter condition configuration information set can be determined directly according to the configuration instructions. The filter configuration information set includes a third filter configuration information set, which includes, but is not limited to, one of the following: condition name, query field, field type, dropdown data source, and matching rule. Specifically, the condition name can be used to explain to the user what this filter item filters. The query field can be used to indicate which field in the data table is being filtered after the user enters the condition. The field type can include, but is not limited to, one of the following: input box, dropdown box, multi-select dropdown box, date, date range, numeric range, and checkbox. The dropdown data source can include, but is not limited to, one of the following: static data, data obtained from an API, and data queried using a SQL statement.Matching rules may include, but are not limited to, one of the following: supporting fuzzy matching queries, and matching queries of multiple values split by rules. The set of source configuration information, indicator dimension configuration information, and filter condition configuration information is defined as the configuration information set set.
[0036] Optionally, the configuration information set is sent to the first terminal. The first terminal stores the configuration information set. Specifically, the first terminal can store the configuration information set as a JavaScript Object Notation (JSON) format. The system receives the configuration information set code sent back by the first terminal, where the first terminal generates the configuration information set code, and the configuration item set code represents the storage address of the configuration information set. Specifically, the storage address of the configuration information set can be a unique address representing the storage location of the configuration information set. This storage address can be embedded in various business systems for analysis and use, or it can be accessed independently to view the configuration content.
[0037] Step 202: Generate a display carrier based on the query request.
[0038] In some embodiments, the executing entity generates a display carrier based on the query request. The display carrier may include, but is not limited to, one of the following: an image, a table, a line chart, a bar chart, and a pie chart.
[0039] Optionally, the target configuration information set is determined based on the target configuration information set code. Specifically, the target configuration information set can be accessed and retrieved based on the storage address contained in the target configuration information set code. An initial display carrier is generated, which is a blank page. The initial display carrier is updated based on the target configuration information set. Optionally, a set of indicator dimension configuration statements is generated based on the target configuration information set. Specifically, the set of indicator dimension configuration statements used for display can be determined based on the indicator dimension configuration information set in the target configuration information set. Specifically, the columns displayed in the report can be controlled based on the indicator dimension configuration information set, including column order dragging and column fixing. Sorting and filtering of configurations can also be performed. The display style can also be controlled based on the indicator dimension configuration information set to meet users' personalized display needs. A set of filter condition configuration statements is generated based on the target configuration information set. Specifically, the set of filter condition configuration statements can be determined based on the filter condition configuration information set in the target configuration information set. Specifically, filter condition configuration statements can be generated based on the various filter conditions provided by the filter condition configuration information set, thereby avoiding the problem that preset filter conditions cannot be changed and improving the level of support for users. Specifically, the FROM sub-statement required for the query can be constructed using the source configuration information set within the target configuration information set. SELECT, WHERE, GROUP BY, ORDER BY, HAVING, and LIMIT sub-statements can be constructed using the indicator dimension configuration information set within the target configuration information set. Specifically, the FROM, SELECT, WHERE, GROUP BY, ORDER BY, HAVING, and LIMIT sub-statements are all in Structured Query Language (SQL).
[0040] The target data set is retrieved from the source database based on the set of statements configured for indicator dimensions and filter conditions. Specifically, a unified interface can be determined for data querying based on these sets. The set of statements configured for indicator dimensions and filter conditions can be assembled based on the user's query request and submitted to the database for execution to obtain the retrieved target data set. Formatting operations can also be performed on the target data in the target data set. The initial display medium is updated based on the target data set. Specifically, areas in the blank page can be updated based on the target data in the target data set. A condition display area can be provided to show filter conditions, or a data display area can be provided to specifically display the retrieved target data set. A data pagination area can also be provided to display the total number of target data entries and the page number, allowing users to directly jump to a specified page and modify the number of target data entries displayed per page. Optionally, the initial display medium can be determined as the display medium.
[0041] Step 203: Send the display carrier to the target terminal device.
[0042] In some embodiments, the aforementioned executing entity sends a display medium to a target terminal device. The target terminal device displays the display medium. The target terminal device can be a device communicatively connected to the aforementioned executing entity. The target terminal device can be a "mobile phone" or a "computer." Specifically, the display medium can include, but is not limited to, one of the following: images, tables, line charts, bar charts, and pie charts. Specifically, the target terminal device can display the generated images to meet the user's data analysis and query needs.
[0043] Figure 2 One embodiment provides the following advantages: It obtains a query request from a user, where the query request represents the code of a target configuration information set, the target configuration information set code represents the storage address of the target configuration information set, and the target configuration information set includes a target source configuration information set, a target indicator dimension configuration information set, and a target filtering condition configuration information set; based on the query request, it generates a display carrier; and sends the display carrier to the target terminal device, whereby the target terminal device displays the display carrier. This implementation directly calls the target configuration information set based on the user's query request to generate a multi-dimensional display carrier through configuration, improving the display efficiency and shortening the generation time. This method utilizes SQL statements for configuration and calls the source database for page rendering, satisfying the needs of multi-dimensional data querying and display carrier display, and avoiding the problems of repeated development and display carrier generation.
[0044] Further reference Figure 3As an implementation of the above figures and methods, this disclosure provides some embodiments of a multi-dimensional display carrier display device, which are similar to... Figure 2 Corresponding to the above-described method embodiments, the device can be specifically applied to various terminal devices.
[0045] like Figure 3 As shown in some embodiments, a multi-dimensional display carrier display device 300 includes: an acquisition unit 301, a generation unit 302, and a sending unit 303. The acquisition unit 301 is configured to acquire a query request sent by a user, wherein the query request represents a target configuration information set code, the target configuration information set code represents the storage address of the target configuration information set, and the target configuration information set includes a target source configuration information set, a target indicator dimension configuration information set, and a target filtering condition configuration information set. The generation unit 302 is configured to generate a display carrier based on the query request. The sending unit 303 is configured to send the display carrier to a target terminal device, wherein the target terminal device displays the display carrier.
[0046] It is understandable that the units described in the device 300 are related to the reference. Figure 2 The steps in the described method correspond accordingly. Therefore, the operations, features, and beneficial effects described above for the method also apply to the device 300 and the units contained therein, and will not be repeated here.
[0047] The following is for reference. Figure 4 It shows a schematic diagram of the structure of a computer system 400 suitable for implementing a terminal device according to embodiments of the present disclosure. Figure 4 The terminal device shown is merely an example and should not be construed as limiting the functionality and scope of use of the embodiments disclosed herein.
[0048] like Figure 4 As shown, the computer system 400 includes a Central Processing Unit (CPU) 401, which can perform various appropriate actions and processes based on programs stored in Read Only Memory (ROM) 402 or programs loaded from storage section 406 into Random Access Memory (RAM) 403. The RAM 403 also stores various programs and data required for the operation of the system 400. The CPU 401, ROM 402, and RAM 403 are interconnected via a bus 404. An Input / Output (I / O) interface 405 is also connected to the bus 404.
[0049] The following components are connected to I / O interface 405: storage section 406, including hard disks, etc.; and communication section 407, including network interface cards such as LAN (Local Area Network) cards, modems, etc. Communication section 407 performs communication processing via a network such as the Internet. Drive 408 is also connected to I / O interface 405 as needed. Removable media 409, such as disks, optical disks, magneto-optical disks, semiconductor memories, etc., are installed on drive 408 as needed so that computer programs read from them can be installed into storage section 406 as needed.
[0050] In particular, according to embodiments of this disclosure, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments of this disclosure include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via communication section 407, and / or installed from removable medium 409. When the computer program is executed by central processing unit (CPU) 401, it performs the functions defined in the methods of this disclosure. It should be noted that the computer-readable medium described in this disclosure can be a computer-readable signal medium or a computer-readable storage medium, or any combination of the two. A computer-readable storage medium can be, for example—but not limited to—an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of computer-readable storage media may include, but are not limited to: electrical connections having one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof. In this disclosure, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in connection with an instruction execution system, apparatus, or device. In this disclosure, a computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium, which can transmit, propagate, or transfer a program for use by or in connection with an instruction execution system, apparatus, or device. Program code contained on a computer-readable medium can be transmitted using any suitable medium, including but not limited to: wireless, wire, optical fiber, RF, etc., or any suitable combination thereof.
[0051] Computer program code for performing the operations of this disclosure can be written in one or more programming languages or a combination thereof, including object-oriented programming languages such as Java, Smalltalk, and C++, and conventional procedural programming languages such as C or similar languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network—including a local area network (LAN) or a wide area network (WAN)—or can be connected to an external computer (e.g., via the Internet using an Internet service provider).
[0052] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this disclosure. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.
[0053] The above description is merely a preferred embodiment of this disclosure and an explanation of the technical principles employed. Those skilled in the art should understand that the scope of the invention involved in this disclosure is not limited to technical solutions formed by specific combinations of the above-described technical features, but should also cover other technical solutions formed by arbitrary combinations of the above-described technical features or their equivalents without departing from the above-described inventive concept. For example, technical solutions formed by substituting the above-described features with (but not limited to) technical features disclosed in this disclosure that have similar functions.
Claims
1. A method for displaying a multi-dimensional display medium, comprising: The process involves obtaining a query request from a user, where the query request represents a target configuration information set code, the target configuration information set code represents the storage address of the target configuration information set, the target configuration information set includes a target source configuration information set, a target indicator dimension configuration information set, and a target filtering condition configuration information set, and the storage address of the configuration information set is a unique address representing the storage location of the configuration information set. Prior to obtaining the user's query request, the process also includes... Obtain the source database and obtain the configuration instructions input by the user, wherein the source database is a historical database generated by the operation of the information system; Based on the source database, a set of configuration information is generated, wherein the set of configuration information includes a source configuration information set, an indicator dimension configuration information set, and a filtering condition configuration information set; The configuration information set is sent to the first terminal, wherein the first terminal stores the configuration information set. The configuration item set code sent back by the first terminal is received, wherein the first terminal generates the configuration information set code, and the configuration item set code represents the storage address of the configuration information set; Based on the query request, a display format is generated, wherein the display format includes one of the following: an image, a table, a line chart, a bar chart, and a pie chart. The generation of the display format based on the query request includes: The target configuration information set is determined based on the target configuration information set code; Generate an initial display medium, wherein the initial display medium is a blank page; The initial display carrier is updated according to the target configuration information set; The initial display carrier is determined as the display carrier; The display carrier is sent to the target terminal device, wherein the target terminal device displays the display carrier.
2. The method according to claim 1, wherein, The step of generating a set of configuration information based on the source database includes: According to the configuration instruction, a source configuration information set is determined from the source database, wherein the source configuration information set includes a first number of source configuration information items, and the source configuration information items represent data table names; According to the configuration instructions, a set of indicator dimension configuration information is generated, wherein the set of indicator dimension configuration information includes a second number of indicator dimension configuration information. According to the configuration instructions, a set of filter condition configuration information is generated, wherein the set of filter condition configuration information includes a third set of filter condition configuration information, and the filter condition configuration information includes one of the following: condition name, query field, field type, drop-down data source, and matching rule; The set of source configuration information, the set of indicator dimension configuration information, and the set of filtering condition configuration information are defined as the configuration information set set.
3. The method according to claim 2, wherein, The step of updating the initial display carrier according to the target configuration information set includes: Based on the target configuration information set, generate a set of indicator dimension configuration statements; Based on the target configuration information set, generate a set of filtering condition configuration statements; Based on the set of configuration statements for the specified indicator dimensions and the set of configuration statements for the specified filtering conditions, the target data set is found in the source database. The initial display carrier is updated based on the target data set.
4. The method according to claim 3, wherein, The indicator dimension configuration information set includes multi-dimensional indicator dimension configuration information, which includes one of the following: date, subject, region, and category.
5. A multi-dimensional display carrier display device, comprising: The acquisition unit is configured to acquire a query request sent by a user, wherein the query request represents a target configuration information set code, the target configuration information set code represents the storage address of the target configuration information set, the target configuration information set includes a target source configuration information set, a target indicator dimension configuration information set, and a target filtering condition configuration information set, and the storage address of the configuration information set is a unique address representing the storage location of the configuration information set. Before acquiring the query request sent by the user, the unit further includes... Obtain the source database and obtain the configuration instructions input by the user, wherein the source database is a historical database generated by the operation of the information system; Based on the source database, a set of configuration information is generated, wherein the set of configuration information includes a source configuration information set, an indicator dimension configuration information set, and a filtering condition configuration information set; The configuration information set is sent to the first terminal, wherein the first terminal stores the configuration information set. The configuration item set code sent back by the first terminal is received, wherein the first terminal generates the configuration information set code, and the configuration item set code represents the storage address of the configuration information set; The generation unit is configured to generate a display carrier based on the query request, wherein the display carrier includes one of the following: an image, a table, a line chart, a bar chart, and a pie chart; and generating the display carrier based on the query request includes: The target configuration information set is determined based on the target configuration information set code; Generate an initial display medium, wherein the initial display medium is a blank page; The initial display carrier is updated according to the target configuration information set; The initial display carrier is determined as the display carrier; The sending unit is configured to send the display carrier to a target terminal device, wherein the target terminal device displays the display carrier.
6. A terminal device, comprising: One or more processors; A storage device on which one or more programs are stored; When the one or more programs are executed by the one or more processors, the one or more processors implement the method as described in any one of claims 1-4.
7. A computer-readable medium having a computer program stored thereon, wherein, When the program is executed by the processor, it implements the method as described in any one of claims 1-4.
Citation Information
Patent Citations
Data query method and device based on configuration information
CN110019350A
Data display method and device, equipment and computer readable storage medium
CN110807045A