CN113190549B - Multidimensional table data calling method, multidimensional table data calling device, server and storage medium - Google Patents

Multidimensional table data calling method, multidimensional table data calling device, server and storage medium Download PDF

Info

Publication number
CN113190549B
CN113190549B CN202110336072.3A CN202110336072A CN113190549B CN 113190549 B CN113190549 B CN 113190549B CN 202110336072 A CN202110336072 A CN 202110336072A CN 113190549 B CN113190549 B CN 113190549B
Authority
CN
China
Prior art keywords
target
data
dimensional
position information
information
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.)
Active
Application number
CN202110336072.3A
Other languages
Chinese (zh)
Other versions
CN113190549A (en
Inventor
魏继超
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Wuxi Jishubao Big Data Technology Co ltd
Original Assignee
Wuxi Jishubao Big Data Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Wuxi Jishubao Big Data Technology Co ltd filed Critical Wuxi Jishubao Big Data Technology Co ltd
Priority to CN202110336072.3A priority Critical patent/CN113190549B/en
Publication of CN113190549A publication Critical patent/CN113190549A/en
Application granted granted Critical
Publication of CN113190549B publication Critical patent/CN113190549B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/26Visual data mining; Browsing structured data

Abstract

The invention discloses a multidimensional table data calling method, a multidimensional table data calling device, a server and a storage medium, and belongs to the field of big data processing. In the method, when data are called from the multi-dimensional table, target area data are firstly obtained from a two-dimensional database according to target position information, further, the target position information is subjected to forward conversion to obtain a visual multi-dimensional table, and finally, a calling result is obtained from the visual multi-dimensional table according to target positioning information. The method provided by the invention realizes the visual conversion of the database, is convenient for the data calling end to call the visual data according to the visual multi-dimensional table, and avoids the problem of slow retrieval caused by directly calling the data in the database; in addition, when the retrieval result is obtained according to the target positioning information, due to the visual data selection, the problem of data error or search fuzziness caused by directly retrieving the target data in the database is avoided, the precision of retrieving the target data is improved, and the method has wide applicability in the field of big data application.

Description

Multidimensional table data calling method, multidimensional table data calling device, server and storage medium
Technical Field
The invention relates to the field of big data processing, in particular to a method, a device, a server and a storage medium for calling multidimensional table data.
Background
In the big data age, various industries face the problem of processing large-scale data sets, wherein data tables for induction processing are also evolving from single-dimensional tables to the widespread use of multi-dimensional tables. The multidimensional table is a table with a complex structure, and different from a two-dimensional table, column names of the multidimensional table do not all appear in the first row, but appear in each row randomly, data is not always filled in the lower part of the names, and fields have randomness.
The data acquisition mode of the multidimensional table in the related technology is suitable for small-scale data tables, and when the multidimensional table has large dimensionality and large number of fields (such as hundreds of fields) in the table, the efficiency of selecting the fields in the multidimensional table is low, and the time consumption is long; in addition, the configuration selection process is not intuitive, and configuration errors are easy to occur.
In the fields where data application is more professional (such as the field of finance and tax), improvement on the multidimensional table data acquisition mode in the related technology is urgently needed to achieve the expected effect of implementation.
Disclosure of Invention
The invention provides a multidimensional table data calling method, a multidimensional table data calling device, a server and a storage medium, which are used for solving the problems of data errors and field fuzzy search in the multidimensional table data calling in the related technology. The technical scheme is as follows:
in one aspect, a multidimensional table data retrieval method is provided, and the method includes:
acquiring target area data from a two-dimensional database according to target position information, wherein the target area data comprise target data, and each data in the two-dimensional database corresponds to position information for correlated storage;
performing forward conversion on the target position information to obtain a visual multi-dimensional table, wherein the forward conversion is realized according to the mapping relation between the target position information and the visual multi-dimensional table format;
storing the target region data into the visual multi-dimensional table;
acquiring a calling result from the visual multi-dimensional table according to target positioning information, wherein the calling result comprises the target data and initial position information of the target data, the initial position information is position information of the target data in the two-dimensional database, and the target positioning information is used for indicating the position information of the target data in the visual multi-dimensional table.
In another aspect, a multidimensional table data retrieval apparatus is provided, the apparatus including:
the data acquisition module is used for acquiring target area data from a two-dimensional database according to target position information, wherein the target area data comprise target data, and each data in the two-dimensional database corresponds to position information correlation storage;
the forward conversion module is used for performing forward conversion on the target position information to obtain a visual multi-dimensional table, and the forward conversion is realized according to the mapping relation between the target position information and the visual multi-dimensional table format;
the data storage module is used for storing the target area data into the visual multi-dimensional table;
and the result calling module is used for obtaining a calling result from the visual multidimensional table according to target positioning information, wherein the calling result comprises the target data and initial position information of the target data, the initial position information is position information of the target data in the two-dimensional database, the target positioning information is used for indicating the position information of the target data in the visual multidimensional table, and each module is used in the multidimensional table data calling method.
In another aspect, a server is provided, the server comprising a processor and a memory; the memory stores at least one instruction for execution by the processor to implement the multidimensional table data retrieval method as described in the above aspect.
In another aspect, a computer-readable storage medium is provided, which stores at least one instruction for execution by a processor to implement the multidimensional table data retrieval method as described in the above aspect.
In another aspect, a computer program product is provided, where at least one instruction is stored, and the at least one instruction is loaded and executed by the processor to implement the multidimensional table data retrieval method according to the above aspect.
The invention has the following beneficial effects:
in the invention, when the data of the multi-dimensional table is called, firstly, the target area data is obtained from the two-dimensional database according to the target position information, further, the target position information is converted in the forward direction to obtain the visual multi-dimensional table, and finally, the calling result is obtained from the visual multi-dimensional table according to the target positioning information. The method provided by the invention realizes the visual conversion of the database, is convenient for the data calling end to call the visual data according to the visual multi-dimensional table, and avoids the problem of slow retrieval caused by directly calling the data in the database; in addition, when the retrieval result is obtained according to the target positioning information, due to the visual data selection, the problem of data error or search fuzziness caused by directly retrieving the target data in the database is avoided, the precision of retrieving the target data is improved, and the method has wide applicability in the field of big data application.
Drawings
FIG. 1 is a flowchart illustrating a multidimensional table data retrieval method provided by an exemplary embodiment of the present invention;
FIG. 2 is a flowchart illustrating a multidimensional table data retrieval method provided by another exemplary embodiment of the present invention;
FIG. 3 is a block diagram illustrating an exemplary embodiment of a multidimensional table data retrieval apparatus;
fig. 4 is a block diagram illustrating a structure of a server according to an exemplary embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, embodiments of the present invention will be described in detail with reference to the accompanying drawings.
Reference herein to "a plurality" means two or more. "and/or" describes the association relationship of the associated objects, meaning that there may be three relationships, e.g., a and/or B, which may mean: a exists alone, A and B exist simultaneously, and B exists alone. The character "/" generally indicates that the former and latter associated objects are in an "or" relationship.
The multi-dimensional table data retrieval method provided by the invention can be widely applied to data conversion and retrieval scenes between a complex multi-dimensional table and a huge two-dimensional table, such as fields of economy, government affairs, investment and financing, risk assessment and the like, the database is increasingly enlarged, and a multi-dimensional table data retrieval method is urgently needed to improve the operation efficiency.
Example 1
The multidimensional table data retrieval method provided by the invention can be applied to a computer system, the computer system comprises a terminal and a server, wherein the terminal and the server are in data communication through a communication network, optionally, the communication network can be a wired network or a wireless network, and the communication network can be at least one of a local area network, a metropolitan area network and a wide area network.
The terminal is used for acquiring and storing data, or the terminal is provided with a data processing system for acquiring and storing data, and sending the stored multidimensional table data or real-time data to the server, optionally, the terminal may be a mobile device such as a smart phone, a tablet computer, a laptop portable notebook computer, or the like, or may be a fixed device such as a desktop computer, a projection computer, or the like, which is not limited in the present invention.
The server may be implemented as one server, or may be implemented as a server cluster formed by a group of servers, which may be physical servers, or may be implemented as a cloud server. In one possible embodiment, the server is a backend server of a data processing system within the terminal.
In one example, the server stores data recorded and sent by the terminal, a two-dimensional database is formed (the storage form of the multidimensional table in the database is a two-dimensional mode), when a search task is received, the server acquires target area data from the two-dimensional database according to target position information and performs forward conversion on the target position information to obtain a visual multidimensional table, the target area data is correspondingly stored in the visual multidimensional table, further, the server acquires a retrieval result from the visual multidimensional table according to target positioning information, and finally the server can return the retrieval result to the terminal for display.
In other possible embodiments, the multidimensional table data retrieving method may be implemented as part or all of a terminal function without a server, which is not limited by the present invention.
For convenience of description, the following embodiments are described as examples in which the multidimensional table data retrieval method is executed by a server.
Example 2
Referring to fig. 1, a flowchart of a multidimensional table data retrieval method according to an exemplary embodiment of the present invention is shown. The method comprises the following steps:
step 101, acquiring target area data from a two-dimensional database according to the target position information, wherein the target area data comprises the target data.
And each data in the two-dimensional database corresponds to position information and is stored in an associated manner.
In one example, the value x is the target data, and the value x is stored in the 8 th row and the 5 th column in the two-dimensional table, then the corresponding position information is (8, 5).
And 102, performing forward conversion on the target position information to obtain a visual multi-dimensional table.
The forward conversion is realized according to the mapping relation between the target position information and the visual multi-dimensional table format. The difference between the visual multidimensional table and the two-dimensional database is that the visual multidimensional table is an effective data area obtained according to the target position information, so that the subsequent retrieval process in all databases is omitted, a user can efficiently select and operate the visual target area data in the process of selecting the target data, and a background server does not need to perform full database retrieval and calling.
In one example, the visual multi-dimensional table does not display data outside the target data area, and thus, if the position information of the numerical value x in the two-dimensional table is (8,5), one of the number of rows or the number of columns may be reserved in the visual multi-dimensional table for forward transformation, and if the number of rows is reserved, the position information of the numerical value x in the visual multi-dimensional table is the 8 th row and the 1 st column through forward transformation (i.e., the data of the column before the 5 th column of the numerical value x in the two-dimensional table is not reserved, and the number of columns of the numerical value x is advanced to the 1 st column).
And 103, storing the target area data into the visual multi-dimensional table.
Correspondingly, after the forward conversion of the target area data corresponding to the target area data is completed, the target area data correspondingly stored in the target area data is stored in the visual multi-dimensional table, namely, the target area data is stored after being positioned.
And 104, acquiring a calling result from the visual multi-dimensional table according to the target positioning information, wherein the calling result comprises target data and initial position information of the target data.
The initial position information is the position information of the target data in the two-dimensional database, and the target positioning information is used for indicating the position information of the target data in the visual multi-dimensional table. In the above example, the position information of the value x in the two-dimensional table is (8,5), and after the forward transform, the position information of the value x in the visual multi-dimensional table is the 8 th row and the 1 st column, that is, (8,1), then the initial position information of the target data is (8,5), and the position information of the target data in the visual multi-dimensional table is (8, 1).
In the above example, the forward transform is taken as an example to illustrate the two-dimensional data type, and in fact, the two-dimensional data can be transformed into more than two-dimensional data (related to the visual multidimensional table dimension) through the forward transform.
In summary, in the embodiment of the present invention, when data is retrieved from the multidimensional table, the target area data is first obtained from the two-dimensional database according to the target location information, further, the target location information is forward converted to obtain the visual multidimensional table, and finally, a retrieval result is obtained from the visual multidimensional table according to the target location information. The method provided by the invention realizes the visual conversion of the database, is convenient for the data calling end to call the visual data according to the visual multi-dimensional table, and avoids the problem of slow retrieval caused by directly calling the data in the database; in addition, when the retrieval result is obtained according to the target positioning information, due to the visual data selection, the problem of data error or search fuzziness caused by directly retrieving the target data in the database is avoided, the precision of retrieving the target data is improved, and the method has wide applicability in the field of big data application.
Example 2
Referring to fig. 2, a flowchart of a multidimensional table data retrieval method according to another exemplary embodiment of the present invention is shown. The method comprises the following steps:
step 201, obtaining an area search signal, where the area search signal is obtained according to a selection trigger operation on a target field in a multidimensional table and/or a target data table.
In one possible implementation, in the case of a multidimensional table with a large data size, a preliminary data screening is performed first according to the target field and/or the range in which the target data table is located. In an exemplary scenario, a user selects a field 5 in the data table 1 to call data, and the terminal obtains an area search signal according to a selection trigger operation of the user on a target field and/or a target data table in the multidimensional table, and sends the area search information to a server, and the server obtains the area search signal.
Step 202, generating target position information according to the area position indicated by the area search signal.
Further, the server determines a data range, namely an indicated area position, which needs to be acquired in the two-dimensional database according to the area search signal, and then summarizes the indicated area position to obtain target position information. For example, the location information of all data in the field 5 area in the data table 1 is summarized to obtain the target location information.
Step 203, determining the position of the target area according to the target field information indicated by the target position information and/or the target data table information.
In one possible implementation, the target location information includes at least one of target field location information and target data table location information, and the target field location information may be coordinates of the target field or a set of coordinates of all data within the target field, as well as the target data table location information.
And step 204, acquiring target area data corresponding to the position of the target area from the two-dimensional database.
Wherein the target area data comprises target data.
And step 205, performing forward conversion on the target position information to obtain a visual multidimensional table.
Please refer to step 102 in the above embodiments for the description of this step, which is not repeated herein.
Step 206, storing the target area data into the visual multi-dimensional table.
Please refer to step 103 in the above embodiments for the description of this step, which is not repeated herein.
And step 207, acquiring a data selection signal, wherein the data selection signal is obtained according to the selection trigger operation of the target data in the visual multi-dimensional table.
In step 208, target location information is generated according to the data location indicated by the data selection signal.
And 209, performing inverse transformation on the target positioning information to obtain the position information of the target data in the two-dimensional database, wherein the inverse transformation is realized according to the mapping relation between the visual multi-dimensional table format and the target position information.
And step 210, acquiring target data from the visual multi-dimensional table according to the target positioning information.
And step 211, displaying an acquisition result, wherein the acquisition result comprises the target data and the initial position information of the target data.
Referring to fig. 3, a block diagram of a multidimensional table data retrieving apparatus according to an exemplary embodiment of the present invention is shown, where the apparatus includes:
the data acquisition module 301 is configured to acquire target area data from a two-dimensional database according to target location information, where the target area data includes target data, and each data in the two-dimensional database corresponds to location information for associated storage;
a forward conversion module 302, configured to perform forward conversion on the target location information to obtain a visual multidimensional table, where the forward conversion is implemented according to a mapping relationship between the target location information and a visual multidimensional table format;
a data storage module 303, configured to store the target region data in the visual multidimensional table;
a result retrieving module 304, configured to obtain a retrieval result from the visual multidimensional table according to target location information, where the retrieval result includes the target data and initial location information of the target data, where the initial location information is location information of the target data in the two-dimensional database, and the target location information is used to indicate location information of the target data in the visual multidimensional table.
Optionally, the result retrieving module 304 includes:
the first calling unit is used for performing reverse transformation on the target positioning information to obtain the position information of the target data in the two-dimensional database, and the reverse transformation is realized according to the mapping relation between the visual multi-dimensional table format and the target position information;
the second calling unit is used for acquiring the target data from the visual multi-dimensional table according to the target positioning information;
and the third calling unit displays the acquisition result, wherein the acquisition result comprises the target data and the initial position information of the target data.
Optionally, before the result retrieving module 304, the apparatus further includes:
the first signal acquisition module is used for acquiring a data selection signal, and the data selection signal is obtained according to the selection trigger operation of the target data in the visual multi-dimensional table;
and the information generating module is used for generating the target positioning information according to the data position indicated by the data selection signal.
Optionally, the target location information includes at least one of target field location information and target data table location information;
the data obtaining module 301 includes:
the first obtaining unit is used for determining the position of a target area according to the target field information indicated by the target position information and/or the target data table information;
and the second acquisition unit is used for acquiring the target area data corresponding to the target area position from the two-dimensional database.
Optionally, before the first obtaining unit, the data obtaining module 301 further includes:
a third obtaining unit, configured to obtain a region search signal, where the region search signal is obtained according to a selection trigger operation on a target field in a multidimensional table and/or a target data table;
and generating the target position information according to the area position indicated by the area search signal.
Referring to fig. 4, a schematic structural diagram of a server 400 according to an embodiment of the present invention is shown. The server 400 may be used to implement the multidimensional table data retrieval method provided in the above embodiments. The server 400 may be the server described in embodiment 1. Specifically, the method comprises the following steps:
the server 400 includes a Central Processing Unit (CPU)401, a system memory 404 including a Random Access Memory (RAM)402 and a Read Only Memory (ROM)403, and a system bus 405 connecting the system memory 404 and the central processing unit 401. The server 400 also includes a basic input/output system (I/O system) 406, which facilitates the transfer of information between devices within the computer, and a mass storage device 407 for storing an operating system 413, application programs 414, and other program modules 415.
The basic input/output system 406 includes a display 408 for displaying information and an input device 409 such as a mouse, keyboard, etc. for user input of information. Wherein a display 408 and an input device 409 are connected to the central processing unit 401 through an input output controller 410 connected to the system bus 405. The basic input/output system 406 may also include an input/output controller 410 for receiving and processing input from a number of other devices, such as a keyboard, mouse, or electronic stylus. Similarly, input/output controller 410 may also provide output to a display screen, a printer, or other type of output device.
The mass storage device 407 is connected to the central processing unit 401 through a mass storage controller (not shown) connected to the system bus 405. The mass storage device 407 and its associated computer-readable media provide non-volatile storage for the server 400. That is, the mass storage device 407 may include a computer-readable medium (not shown) such as a hard disk or CD-ROM drive.
Without loss of generality, computer readable media may comprise computer storage media and communication media. Computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data. Computer storage media includes RAM, ROM, EPROM, EEPROM, flash memory or other solid state memory technology, CD-ROM, DVD, or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices. Of course, those skilled in the art will appreciate that computer storage media is not limited to the foregoing. The system memory 404 and mass storage device 407 described above may be collectively referred to as memory.
According to various embodiments of the invention, the server 400 may also operate as a remote computer connected to a network through a network, such as the Internet. That is, the server 400 may be connected to the network 412 through the network interface unit 411 connected to the system bus 405, or may be connected to other types of networks or remote computer systems (not shown) using the network interface unit 411.
The memory also includes one or more programs, stored in the memory, and configured to be executed by the one or more processors. The one or more programs include instructions for implementing the server-side multidimensional table data retrieval method.
The memory has stored therein at least one instruction, at least one program, set of codes, or set of instructions configured to be executed by one or more processors to implement the functions of the various steps of the above-described multidimensional table data fetching method.
The present invention also provides a computer-readable storage medium, in which at least one instruction, at least one program, a set of codes, or a set of instructions is stored, and the at least one instruction, the at least one program, the set of codes, or the set of instructions is loaded and executed by a processor to implement the multidimensional table data retrieval method provided in the above embodiments.
Optionally, the computer-readable storage medium may include: a Read Only Memory (ROM), a Random Access Memory (RAM), a Solid State Drive (SSD), or an optical disc. The Random Access Memory may include a resistive Random Access Memory (ReRAM) and a Dynamic Random Access Memory (DRAM).
The above-mentioned serial numbers of the present invention are for description only and do not represent the merits of the embodiments.
It will be understood by those skilled in the art that all or part of the steps for implementing the above embodiments may be implemented by hardware, or may be implemented by a program instructing relevant hardware, where the program may be stored in a computer-readable storage medium, and the above-mentioned storage medium may be a read-only memory, a magnetic disk or an optical disk, etc.
The invention is not to be considered as limited to the particular embodiments shown and described, but is to be understood that various modifications, equivalents, improvements and the like can be made without departing from the spirit and scope of the invention.

Claims (7)

1. A multidimensional table data retrieval method, the method comprising:
acquiring target area data from a two-dimensional database according to target position information, wherein the target area data comprise target data, and each data in the two-dimensional database corresponds to position information for correlated storage;
performing forward conversion on the target position information to obtain a visual multi-dimensional table, wherein the forward conversion is realized according to the mapping relation between the target position information and the visual multi-dimensional table format;
storing the target region data into the visual multi-dimensional table;
acquiring a calling result from the visual multi-dimensional table according to target positioning information, wherein the calling result comprises the target data and initial position information of the target data, the initial position information is position information of the target data in the two-dimensional database, and the target positioning information is used for indicating the position information of the target data in the visual multi-dimensional table;
before the target data is acquired from the visual multi-dimensional table according to the target positioning information, the method further comprises the following steps:
acquiring a data selection signal, wherein the data selection signal is obtained according to the selection trigger operation of the target data in the visual multi-dimensional table;
and generating the target positioning information according to the data position indicated by the data selection signal.
2. The method of claim 1, wherein obtaining the retrieval from the visual multi-dimensional table based on the target location information comprises:
performing reverse transformation on the target positioning information to obtain the position information of the target data in the two-dimensional database, wherein the reverse transformation is realized according to the mapping relation between the visual multi-dimensional table format and the target position information;
acquiring the target data from the visual multi-dimensional table according to the target positioning information;
and displaying an acquisition result, wherein the acquisition result comprises the target data and initial position information of the target data.
3. The method of any of claims 1 to 2, wherein the target location information comprises at least one of target field location information and target data table location information;
the acquiring of the target area data from the two-dimensional database according to the target location information includes:
determining the position of a target area according to target field information indicated by the target position information and/or the target data table information;
and acquiring the target area data corresponding to the target area position from the two-dimensional database.
4. The method according to claim 3, wherein before determining a target area location according to the target field information indicated by the target location information and/or the target data table information, further comprising:
acquiring a region search signal, wherein the region search signal is obtained according to selection trigger operation of a target field in a multi-dimensional table and/or a target data table;
and generating the target position information according to the area position indicated by the area search signal.
5. A multidimensional table data retrieval apparatus, the apparatus comprising:
the data acquisition module is used for acquiring target area data from a two-dimensional database according to target position information, wherein the target area data comprise target data, and each data in the two-dimensional database corresponds to position information correlation storage;
the forward conversion module is used for performing forward conversion on the target position information to obtain a visual multi-dimensional table, and the forward conversion is realized according to the mapping relation between the target position information and the visual multi-dimensional table format;
the data storage module is used for storing the target area data into the visual multi-dimensional table;
a result retrieving module, configured to obtain a retrieval result from the visual multidimensional table according to target location information, where the retrieval result includes the target data and initial location information of the target data, where the initial location information is location information of the target data in the two-dimensional database, and the target location information is used to indicate location information of the target data in the visual multidimensional table, and each module is used in the multidimensional table data retrieval method according to any one of claims 1 to 4.
6. A server, comprising a processor and a memory; the memory stores at least one instruction for execution by the processor to implement the multidimensional table data retrieval method of any of claims 1 to 4.
7. A computer-readable storage medium storing at least one instruction for execution by a processor to implement the multidimensional table data retrieval method as recited in any one of claims 1 to 4.
CN202110336072.3A 2021-03-29 2021-03-29 Multidimensional table data calling method, multidimensional table data calling device, server and storage medium Active CN113190549B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110336072.3A CN113190549B (en) 2021-03-29 2021-03-29 Multidimensional table data calling method, multidimensional table data calling device, server and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110336072.3A CN113190549B (en) 2021-03-29 2021-03-29 Multidimensional table data calling method, multidimensional table data calling device, server and storage medium

Publications (2)

Publication Number Publication Date
CN113190549A CN113190549A (en) 2021-07-30
CN113190549B true CN113190549B (en) 2022-04-05

Family

ID=76974381

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110336072.3A Active CN113190549B (en) 2021-03-29 2021-03-29 Multidimensional table data calling method, multidimensional table data calling device, server and storage medium

Country Status (1)

Country Link
CN (1) CN113190549B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113688134B (en) * 2021-08-24 2024-02-09 招商银行股份有限公司 Visual variable management method, system and equipment based on multidimensional data

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105843842A (en) * 2016-03-08 2016-08-10 东北大学 Multi-dimensional gathering querying and displaying system and method in big data environment
CN110134731A (en) * 2019-04-26 2019-08-16 深圳壹账通智能科技有限公司 Data presentation method, device, computer equipment and storage medium

Family Cites Families (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2014145965A1 (en) * 2013-03-15 2014-09-18 Locus Analytics, Llc Domain-specific syntax tagging in a functional information system
US10275501B2 (en) * 2014-08-01 2019-04-30 Tata Consultancy Services Limited System and method for multi-dimensional data representation of objects
US10289283B1 (en) * 2014-09-29 2019-05-14 EMC IP Holding Company LLC Visual analysis for multi-dimensional data
US10824607B2 (en) * 2016-07-21 2020-11-03 Ayasdi Ai Llc Topological data analysis of data from a fact table and related dimension tables
CN108197237B (en) * 2017-12-29 2020-03-24 北京恒泰实达科技股份有限公司 Visual data acquisition and display system
CN108460087A (en) * 2018-01-22 2018-08-28 北京邮电大学 Heuristic high dimensional data visualization device and method
CN109669992A (en) * 2018-12-20 2019-04-23 云南电网有限责任公司玉溪供电局 A kind of implementation method of data visualization conversion
CN110413708B (en) * 2019-07-23 2022-06-21 杭州城市大数据运营有限公司 Data analysis system oriented to business terms

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105843842A (en) * 2016-03-08 2016-08-10 东北大学 Multi-dimensional gathering querying and displaying system and method in big data environment
CN110134731A (en) * 2019-04-26 2019-08-16 深圳壹账通智能科技有限公司 Data presentation method, device, computer equipment and storage medium

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
"Cross-Filtered Views for Multidimensional Visual Analysis";Chris Weaver 等;《IEEE TRANSACTIONS ON VISUALIZATION AND COMPUTER GRAPHICS》;20090818;第16卷(第2期);第192-204页 *
"多维时空数据协同可视分析方法";周志光 等;《计算机辅助设计与图形学学报》;20171231;第29卷(第12期);第2245-2255页 *

Also Published As

Publication number Publication date
CN113190549A (en) 2021-07-30

Similar Documents

Publication Publication Date Title
WO2020186783A1 (en) Data importing method and apparatus, and computer device and storage medium
CN110413611B (en) Data storage and query method and device
EP3767483A1 (en) Method, device, system, and server for image retrieval, and storage medium
EP4174677A1 (en) Data reading and writing method and device
US20140052727A1 (en) Data processing for database aggregation operation
CN111125266A (en) Data processing method, device, equipment and storage medium
CN110968585B (en) Storage method, device, equipment and computer readable storage medium for alignment
CN113190549B (en) Multidimensional table data calling method, multidimensional table data calling device, server and storage medium
CN112613271A (en) Data paging method and device, computer equipment and storage medium
US11954086B2 (en) Index data structures and graphical user interface
CN110928900B (en) Multi-table data query method, device, terminal and computer storage medium
CN113010542B (en) Service data processing method, device, computer equipment and storage medium
CN110377721B (en) Automatic question answering method, device, storage medium and electronic equipment
CN112329409B (en) Cell color conversion method and device and electronic equipment
CN111198917A (en) Data processing method, device, equipment and storage medium
CN105991400B (en) Group searching method and device
CN111125425A (en) Method, system and device for reading and writing video data and readable storage medium
CN110888874A (en) Device and method for creating form through Excel and storage medium
CN110750569A (en) Data extraction method, device, equipment and storage medium
CN113296962B (en) Memory management method, device, equipment and storage medium
US20170300516A1 (en) System and method for building a dwarf data structure
CN111832304B (en) Weight checking method and device for building names, electronic equipment and storage medium
CN115794810A (en) Word information batch capturing method and device and server
CN113297333A (en) Data processing method, device, server and storage medium
CN116627968A (en) Concurrent request processing method, processing device, computer equipment and medium

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