CN113779160A - Method and device for acquiring data of multidimensional database - Google Patents
Method and device for acquiring data of multidimensional database Download PDFInfo
- Publication number
- CN113779160A CN113779160A CN202110973370.3A CN202110973370A CN113779160A CN 113779160 A CN113779160 A CN 113779160A CN 202110973370 A CN202110973370 A CN 202110973370A CN 113779160 A CN113779160 A CN 113779160A
- Authority
- CN
- China
- Prior art keywords
- area
- formula
- query
- data
- dependent
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 50
- 230000001419 dependent effect Effects 0.000 claims abstract description 93
- 238000013507 mapping Methods 0.000 claims abstract description 31
- 238000004590 computer program Methods 0.000 claims description 9
- 238000004364 calculation method Methods 0.000 abstract description 22
- 238000006243 chemical reaction Methods 0.000 description 11
- 238000007726 management method Methods 0.000 description 9
- 238000004458 analytical method Methods 0.000 description 4
- 238000012545 processing Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000013479 data entry Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and a device for acquiring data of a multidimensional database, wherein the method comprises the following steps: acquiring a query area of a user; under the condition that a formula application area of the query area is identified, determining a formula dependent area associated with the formula application area according to a first mapping relation; and acquiring effective data from the query area according to the formula dependent area. The method solves the technical problems that in the prior art, each cell of a query area needs to be traversed, so that a lot of invalid calculations are caused, and time and performance are wasted.
Description
Technical Field
The invention relates to the technical field of databases, in particular to a method and a device for acquiring data of a multidimensional database.
Background
In the multidimensional database, the cells in the multidimensional cube can be divided into input cells and formula calculation cells, the data can be quickly inquired about the input cell data, and each cell in a slice with formula application needs to be calculated according to a formula and then a result can be displayed.
It should be noted that, when a user needs to query a certain region, it is often necessary to perform traversal and then perform value calculation on each cell of the query region, because the sparsity of the multidimensional database causes many invalid calculations, which wastes time and performance.
Disclosure of Invention
The invention provides a method and a device for acquiring data of a multidimensional database, which are used for solving the technical problems that in the prior art, a lot of invalid calculations are caused by traversing each cell of a query area, and the time and the performance are wasted.
According to a first aspect of the present invention, there is provided a method for acquiring data of a multidimensional database, the method comprising: acquiring a query area of a user; under the condition that a formula application area of the query area is identified, determining a formula dependent area associated with the formula application area according to a first mapping relation; and acquiring effective data from the query area according to the formula dependent area.
Further, obtaining valid data from the query region according to the formula dependent region comprises: and under the condition that the formula dependent area is a first entry area, acquiring valid data from the first entry area in the query area.
Further, obtaining valid data from the query region according to the formula dependent region comprises: under the condition that the formula dependent area is a non-recording area, determining a sub-formula dependent area associated with the formula dependent area according to a second mapping relation; and under the condition that the sub-formula dependent area is a second entry area, acquiring effective data from the second entry area in the query area.
Further, before the query area of the user is obtained, the method comprises the following steps: acquiring a plurality of formulas input aiming at the query area; and generating the first mapping relation and the second mapping relation according to the plurality of formulas.
Further, after obtaining valid data from the query region according to the formula dependent region, the method includes: and calculating the effective data through the formula of the formula dependent area to generate a value of the formula application area of the query area.
According to a second aspect of the present invention, there is provided an apparatus for acquiring data of a multidimensional database, the apparatus comprising: the first acquisition unit is used for acquiring a query area of a user; the determining unit is used for determining a formula dependent area associated with the formula application area according to a first mapping relation under the condition that the formula application area of the query area is identified; and the second acquisition unit is used for acquiring effective data from the query area according to the formula dependent area.
Further, the second acquisition unit includes: the first obtaining module is configured to obtain valid data from the first entry area in the query area when the formula dependent area is the first entry area.
Further, the second acquisition unit includes: the determining module is used for determining a sub-formula dependent area associated with the formula dependent area according to a second mapping relation under the condition that the formula dependent area is a non-recording area;
and the second obtaining module is used for obtaining effective data from the second entry area in the query area under the condition that the sub-formula dependent area is the second entry area.
According to a third aspect of the present invention, there is provided a computer device comprising a memory and a processor, the memory having stored thereon computer instructions which, when executed by the processor, cause the method of data acquisition of a multidimensional database as defined in any one of the preceding to be performed.
According to a fourth aspect of the present invention, there is provided a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, causes a method of acquisition of data of a multidimensional database as described in any one of the above to be performed.
The invention provides a method and a device for acquiring data of a multidimensional database, wherein the method comprises the following steps: acquiring a query area of a user; under the condition that a formula application area of the query area is identified, determining a formula dependent area associated with the formula application area according to a first mapping relation; and acquiring effective data from the query area according to the formula dependent area. The method solves the technical problems that in the prior art, each cell of a query area needs to be traversed, so that a lot of invalid calculations are caused, and time and performance are wasted.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.
FIG. 1 is a flowchart illustrating a method for acquiring data from a multidimensional database according to a first embodiment of the present invention;
FIG. 2 is a flowchart illustrating an alternative method for acquiring data from a multidimensional database according to a first embodiment of the present invention; and
fig. 3 is a schematic diagram of an apparatus for acquiring data of a multidimensional database according to a second embodiment of the present invention.
Detailed Description
In order to make the above and other features and advantages of the present invention more apparent, the present invention is further described below with reference to the accompanying drawings. It is understood that the specific embodiments described herein are for purposes of illustration only and are not intended to be limiting.
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention. It will be apparent, however, to one skilled in the art that the specific details need not be employed to practice the present invention. In other instances, well-known steps or operations are not described in detail to avoid obscuring the invention.
Example one
The invention provides a method for acquiring data of a multidimensional database, which can comprise the following steps as shown in figure 1:
in step S11, the query area of the user is acquired.
Specifically, in the scheme, a query area transmitted by a user can be acquired by using hardware devices such as a server and the like as an execution main body, and then analysis and calculation are performed, the query area of the user can be a plurality of cells in a certain range in a multidimensional database, some cells in the plurality of cells are entry cells, some cells are cells covered by a formula, the entry cells can be directly acquired in the multidimensional database, and the cells covered by the formula need to acquire an effective value and then can acquire the value of the cell through formula calculation.
In step S13, if the application area of the query area is identified, the formula dependent area associated with the application area is determined according to the first mapping relationship.
Specifically, in the scheme, after the query area of the user is obtained, the multiple cells in the query area can be split into the input data area and the formula application area, and the input data area can be a cell without a formula area, that is, the input cell can directly obtain values from the multidimensional database. The formula application area may be a cell covered by a formula, for example, revenue, for the revenue, the revenue is calculated according to a formula, that is, the revenue is [ ' revenue ' is [ ' revenue of main business ' ] + [ ' revenue of other business ' ], in the formula, the revenue ' on the left side of the equal sign is a formula application area, the formula application area is not directly recorded and cannot be directly obtained from a table of a multidimensional database, in the step S13, a formula dependent area of the formula application area [ ' revenue ' ] may be determined according to a first mapping relationship established in advance, the first mapping may convert the formula application area into the formula dependent area, and in case that a user inquires the revenue, the query area may be converted into the revenue of main business and other business through the first mapping relationship, for example, [ 'business income' ] - > [ business income for main operation ], [ business income ] - > [ other business income ], that is, the formula-dependent area of the formula application area [ 'business income' ] includes [ 'business income for main operation' ] and [ 'business income for other' ].
Step S15, obtaining valid data from the query area according to the formula dependent area.
Specifically, in the present solution, valid data can be obtained from the query area through the formula dependent area, and taking revenue as an example, the formula dependent area of the application area [ 'revenue' ] includes [ 'major business revenue' ] and [ 'other business revenue' ], and the present solution obtains valid data from the query area according to the two areas [ 'major business revenue' ] and [ 'other business revenue' ].
Therefore, when the query area of the user is processed, each cell in the query area is not directly traversed, the query area is classified first, the formula dependent area corresponding to the query area is obtained through further conversion, then the effective value is obtained from the query area, and value calculation is performed, so that the technical problems that in the prior art, a lot of invalid calculations are needed to be traversed aiming at each cell in the query area, and time and performance are wasted are solved.
Optionally, the step S15 of obtaining valid data from the query area according to the formula dependent area may include:
and step S151, under the condition that the formula dependent area is the first entry area, acquiring effective data from the first entry area in the query area.
Specifically, in the present scheme, if it is determined that the formula dependent area is the first entry area, the present scheme obtains valid data directly from the first entry area of the query area and then performs calculation, and taking business income as an example, the formula dependent area of the application area [ 'business income' ] includes [ 'major business income' ] and [ 'other business income' ], and that [ 'major business income' ] and [ 'other business income' ] belong to the entry area in the query area, and the present scheme obtains valid data from the query area according to two areas [ 'major business income' ] and [ 'other business income' ].
Optionally, in step S15, the step of obtaining valid data from the query area according to the formula dependent area may include:
and S152, under the condition that the formula dependent area is a non-recording area, determining a sub formula dependent area related to the formula dependent area according to the second mapping relation.
And step S153, under the condition that the sub-formula dependent area is the second entry area, acquiring effective data from the second entry area in the query area.
Specifically, in the present scheme, if the formula dependent area is a non-entry area (still a formula application area), the value cannot be directly taken from the multidimensional database, but the second mapping relationship is continuously used to convert the formula dependent area into a sub-formula dependent area, such as a formula dependent area where [ business profit '] [' business income '] - [' business cost '] - [' management cost '], [' business profit '] is an application area, and [ business income' ], [ 'business cost' ] and [ management cost '] on the right side of the equal sign are [ business profit' ], and among three formula dependent areas of [ business income '], [' business cost '] and [ management cost' ] is an entry area, the value can be directly taken from the multidimensional database, and the business income 'and the business cost' are non-recording areas, the scheme acquires the business income 'in a sub-formula dependent area and other business income' according to a second mapping relation, and acquires effective data from the query area under the condition that the business income 'and other business income' are recording areas. It should be noted that, if the sub-formula dependent region in the step S153 is still a non-entry region, the present solution continues to iteratively convert the formula dependent region of the sub-formula dependent region until the formula dependent region is an entry region.
It should be noted that, the scheme provided by the present application may be regarded as a method for automatic evacuation calculation of a sparse multidimensional database, for an input multidimensional cube query, an application area of a formula is first analyzed, a formula dependent area is generated according to the application area of the formula, the formula dependent area is processed in a rule until the dependent area has no formula application, at this time, the dependent area is all obtained from entered data, the entered data obtained from storage is fast and non-empty, thereby the range of the formula dependent area is reduced, the calculation formula application area in the recursive direction is also obviously reduced, and finally, all cells of the query area are effectively calculated values.
Optionally, before the query area of the user is obtained in step S11, the method provided by the present application may further include:
in step S09, a plurality of formulas input for the query area are obtained.
In step S10, a first mapping relationship and a second mapping relationship are generated according to a plurality of formulas.
Specifically, in this scheme, a formula may be set for the multidimensional cube, a user may input a plurality of formulas for the multidimensional cube, and then a mapping relationship that converts the application area into a formula-dependent area, that is, the first mapping relationship and the second mapping relationship, is generated in advance according to the plurality of formulas. It should be noted that the formula of the multidimensional cube may be an equal sign expression, the slice specified on the left of the equal sign is referred to as a formula application area, the right of the equal sign is an expression to be calculated, and the slice appearing on the right of the equal sign is referred to as a formula dependent area. It should be noted that, in the present solution, the application area corresponding to each formula may be traversed in a loop, and the application area and the formula dependent area of the formula are converted.
Optionally, after the step S15 obtains valid data from the query region according to the formula dependent region, the method provided by the present application may further include:
in step S17, the valid data is calculated by the formula of the formula dependent region, and a value of the application region of the query region is generated.
Specifically, in the present solution, after the valid data is obtained, the valid value may be calculated according to a determined formula, so as to generate a value of the application area of the query area.
An alternative embodiment of the present solution is described below with reference to fig. 2:
in step S201, a formula is set for the multidimensional cube.
Step S202, recording the conversion relation between each formula application area and each formula dependent area.
Specifically, in the present solution, a conversion relationship between the formula application area and the formula dependent area, that is, a mapping relationship in the embodiment, may be generated in advance according to a formula input by a user. It should be noted that one formula application area may correspond to a plurality of formula dependent areas, and for each formula dependent area, conversion processing and storage of conversion relationships are required.
In step S203, the query slice is input and the process is started.
Specifically, the query slice may be a data slice in a data cube that a user needs to query, and the data slice stores multidimensional data and may be a set of multiple cells.
Step S204, a query area is obtained, and the slice is divided into a list of a data recording area and a formula application area according to a formula.
In step S205, the area in the list is acquired.
Specifically, after the query region of the user is obtained, the region may be split (which may be understood as being classified) according to a formula, and split into an entry data region (region without a formula) and a formula application region (application region with different rules), it should be noted that the split region needs to process different rules in a differentiated manner, and each separate region can only be applied by one man-hour.
Step S206, determining whether there is a rule in the area, if yes, executing step S210, and if no, executing step S207.
Step S207, the entry data is taken out from the storage.
Specifically, for all areas without formula application, batch value taking is performed directly, and only recorded data is stored in the multidimensional cube, so that effective recorded data of the areas can be obtained quickly through batch value taking, and the purpose of emptying from a formula source is achieved.
In step S208, the value of the formula application area is calculated from the formula dependent area according to the formula.
Specifically, the final value taking effect is that data needing to be calculated in a value taking range can be quickly calculated, and extra calculation is not carried out.
In step S209, a list of dependent areas is calculated according to the mapping relationship in the formula.
Specifically, the mapping relationship needs to be obtained by analyzing rules in advance, and a mutual conversion relationship between the formula application area and each formula dependent area needs to be obtained.
Step S210, traversing the dependency region list as a query region, and then executing step S204, it should be noted that the present solution may split application regions of different rules, and after knowing that all split regions have no formula, values are directly taken from storage and calculated recursively upwards. And calling the region of the same layer for the formula, and using different formula calculation or directly taking the value of the formula-free application region as the initial data recursive calculation of the next layer until the value of the query region is obtained.
The following describes a specific embodiment of the present invention with reference to table 1, and the technical effects of the present invention can also be illustrated.
Table 1:
| 2019 | 1 month | Revenue of main business | 100 |
| 2019 | 1 month | Cost of main business | 10 |
| 2019 | 2 month | Managing fees | 20 |
| 2020 | 3 month | Cost of other services | 30 |
| 2020 | 3 month | Cost of main business | 40 |
| 2020 | 3 month | Revenue of main business | 240 |
In connection with table 1, the multidimensional cube is composed of a plurality of dimensions, and it is assumed that the multidimensional cube is composed of three dimensions, which are year, period, subject, respectively. The annual dimension comprises 2019 elements and 2020 elements, the period dimension comprises six elements from 1 month to June, and the subjects comprise business income, business income of major operation, business income of other businesses, business cost of major operation, business cost of other businesses, business profit and 8 management expenses. The multidimensional cube has three formulas, namely [ 'business income' ] [ 'major business income' ] + [ 'other business income' ]; business cost [ 'major business cost' ] + [ 'other business cost' ]; "business profit" [ "business income" ] - [ "business cost" ] - [ "management expense" ]; the three formulas respectively explain the calculation modes of the business profit, the business cost and the business income, and the values of the three subjects cannot be recorded into data and need to be calculated by the three formulas.
According to the traditional data query scheme, if a user wants to query the [2019, business profit ] slice area, the user needs to traverse all 6 cells of [2019, business profit ], for each cell of [2019, business profit ], such as [2019, 1 month, business profit ], the user needs to obtain [2019, 1 month, business income ], [2019, 1 month, business cost ], [2019, 1 month, management cost ], [2019, 1 month, business income ], the user needs to obtain [2019, 1 month, main business income ] and [2019, 1 month, other business income ], [2019, 1 month, business cost ] needs to obtain [2019, 1 month, main business cost ], [2019, 1 month, other business cost ], the user respectively carries out addition and subtraction operation after the obtaining is finished, and the user carries out 30 times of value taking and 24 times of addition and subtraction operation in total to obtain 2012 non-empty [2019, business profit ].
The steps of data query according to the scheme provided by the application are as follows: through formula analysis, application areas which are all the third formula are found, and conversion is carried out according to the conversion relation in the formula to obtain [2019, business income ], [2019, business cost ] and [2019, management cost ]. And (2019, business income) finds application areas which are all the first formula through formula analysis, and the application areas are converted according to the conversion relation in the formula to obtain (2019, business income for main business) and (2019, other business income). The two areas of [2019, main business income ] and [2019, other business income ] are data recording areas, no formula is applied, and the value is directly taken from the storage in batches for 2 times to obtain 1 piece of data of [2019, 1 month and main business income ]. And calculating [2019, income of business ] from the data, and calculating an addition to obtain [2019, month 1, income of business ] data. And (2019, business cost) finding application areas which are all the second formula through formula analysis, and converting according to the conversion relation in the formula to obtain (2019, main business cost) and (2019, other business cost). The two areas of [2019, main business cost ] and [2019, other business cost ] are data recording areas, no formula is applied, and the value is directly taken from the storage in batches for 2 times to obtain 1 piece of data of [2019, 1 month and main business cost ]. And calculating [2019, business cost ] from the data, and calculating one addition to obtain [2019, month 1, business cost ] data. The area [2019, management cost ] is a data entry area, no formula is applied, and the value is taken from the storage for 1 time directly in batches to obtain 1 data [2019, 2 months, management cost ]. Therefore, the effective data in [2019, operating profit ] is obtained by carrying out subtraction operation for 4 times finally.
Therefore, compared with the traditional data query scheme in the prior art, the calculation times of the scheme are far smaller than those of the traditional mode. The performance is greatly improved, when the query area of a user is processed, the method does not directly search each cell in the area for traversal, but classifies the query area, further converts the query area to obtain a formula dependent area corresponding to the query area, acquires an effective value from the query area and then performs value calculation, and therefore the technical problems that in the prior art, a lot of invalid calculations are caused by the fact that traversal is performed on each cell in the query area, and time and performance are wasted are solved.
Example two
The present application further provides an apparatus for acquiring data of a multidimensional database, which may be implemented in a server or other devices, and may also be used to implement the method in the first embodiment, as shown in fig. 3, the apparatus includes: a first obtaining unit 30, configured to obtain a query area of a user; a determining unit 32, configured to determine, in a case where an application area of the query area is identified, a formula dependent area associated with the application area according to the first mapping relationship; and the second obtaining unit 34 is used for obtaining the valid data from the query area according to the formula dependent area.
By the device, when the query area of the user is processed, each cell in the query area is not directly traversed, the query area is classified first, the formula dependent area corresponding to the query area is obtained through further conversion, then the effective value is obtained from the query area, and value calculation is performed, so that the technical problems that in the prior art, a lot of invalid calculations are caused due to the fact that traversal is performed on each cell in the query area, and time and performance are wasted are solved.
Optionally, the second obtaining unit includes: the first obtaining module is used for obtaining effective data from the first entry area in the query area under the condition that the formula dependent area is the first entry area.
Optionally, the second obtaining unit includes: the determining module is used for determining a sub-formula dependent area related to the formula dependent area according to the second mapping relation under the condition that the formula dependent area is the application area; and the second acquisition module is used for acquiring effective data from the second entry area in the query area under the condition that the sub-formula dependent area is the second entry area.
The present application further provides a computer device comprising a memory and a processor, the memory having stored thereon computer instructions that, when executed by the processor, cause the method of obtaining data of a multidimensional database of the first embodiment to be performed.
The present application further provides a non-transitory computer-readable storage medium having stored thereon a computer program which, when executed by a processor, causes a method of data acquisition of a multidimensional database in a first embodiment to be performed.
It will be understood that the specific features, operations and details described herein above with respect to the method of the present invention may be similarly applied to the apparatus and system of the present invention, or vice versa. In addition, each step of the method of the present invention described above may be performed by a respective component or unit of the device or system of the present invention.
It should be understood that the various modules/units of the apparatus of the present invention may be implemented in whole or in part by software, hardware, firmware, or a combination thereof. The modules/units may be embedded in the processor of the computer device in the form of hardware or firmware or independent from the processor, or may be stored in the memory of the computer device in the form of software for being called by the processor to execute the operations of the modules/units. Each of the modules/units may be implemented as a separate component or module, or two or more modules/units may be implemented as a single component or module.
In one embodiment, a computer device is provided that includes a memory and a processor, the memory having stored thereon computer instructions executable by the processor, the computer instructions, when executed by the processor, instruct the processor to perform the steps of the method of embodiment one of the present invention. The computer device may broadly be a server, a terminal, or any other electronic device having the necessary computing and/or processing capabilities. In one embodiment, the computer device may include a processor, memory, a network interface, a communication interface, etc., connected by a system bus. The processor of the computer device may be used to provide the necessary computing, processing and/or control capabilities. The memory of the computer device may include non-volatile storage media and internal memory. An operating system, a computer program, and the like may be stored in or on the non-volatile storage medium. The internal memory may provide an environment for the operating system and the computer programs in the non-volatile storage medium to run. The network interface and the communication interface of the computer device may be used to connect and communicate with an external device through a network. Which when executed by a processor performs the steps of the method of the invention.
The invention may be implemented as a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, causes the steps of a method of a first embodiment of the invention to be performed. In one embodiment, the computer program is distributed across a plurality of computer devices or processors coupled by a network such that the computer program is stored, accessed, and executed by one or more computer devices or processors in a distributed fashion. A single method step/operation, or two or more method steps/operations, may be performed by a single computer device or processor or by two or more computer devices or processors. One or more method steps/operations may be performed by one or more computer devices or processors, and one or more other method steps/operations may be performed by one or more other computer devices or processors. One or more computer devices or processors may perform a single method step/operation, or perform two or more method steps/operations.
It will be appreciated by those of ordinary skill in the art that the method steps of the present invention may be directed to associated hardware, such as a computer device or processor, for performing the steps of the present invention by a computer program, which may be stored in a non-transitory computer readable storage medium, which when executed causes the steps of the present invention to be performed. Any reference herein to memory, storage, databases, or other media may include non-volatile and/or volatile memory, as appropriate. Examples of non-volatile memory include read-only memory (ROM), programmable ROM (prom), electrically programmable ROM (eprom), electrically erasable programmable ROM (eeprom), flash memory, magnetic tape, floppy disk, magneto-optical data storage device, hard disk, solid state disk, and the like. Examples of volatile memory include Random Access Memory (RAM), external cache memory, and the like.
The respective technical features described above may be arbitrarily combined. Although not all possible combinations of features are described, any combination of features should be considered to be covered by the present specification as long as there is no contradiction between such combinations.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. A method for obtaining data from a multidimensional database, the method comprising:
acquiring a query area of a user;
under the condition that a formula application area of the query area is identified, determining a formula dependent area associated with the formula application area according to a first mapping relation;
and acquiring effective data from the query area according to the formula dependent area.
2. The method of claim 1, wherein obtaining valid data from the query region according to the formula dependent region comprises:
and under the condition that the formula dependent area is a first entry area, acquiring valid data from the first entry area in the query area.
3. The method of claim 1, wherein obtaining valid data from the query region according to the formula dependent region comprises:
under the condition that the formula dependent area is a non-recording area, determining a sub-formula dependent area associated with the formula dependent area according to a second mapping relation;
and under the condition that the sub-formula dependent area is a second entry area, acquiring effective data from the second entry area in the query area.
4. The method of claim 3, wherein before the query region of the user is obtained, the method comprises:
acquiring a plurality of formulas input aiming at the query area;
and generating the first mapping relation and the second mapping relation according to the plurality of formulas.
5. The method of claim 1, wherein after obtaining valid data from the query region according to the formula dependent region, the method comprises:
and calculating the effective data through the formula of the formula dependent area to generate a value of the formula application area of the query area.
6. An apparatus for obtaining data of a multidimensional database, the apparatus comprising:
the first acquisition unit is used for acquiring a query area of a user;
the determining unit is used for determining a formula dependent area associated with the formula application area according to a first mapping relation under the condition that the formula application area of the query area is identified;
and the second acquisition unit is used for acquiring effective data from the query area according to the formula dependent area.
7. The apparatus of claim 6, wherein the second obtaining unit comprises:
the first obtaining module is configured to obtain valid data from the first entry area in the query area when the formula dependent area is the first entry area.
8. The apparatus of claim 6, wherein the second obtaining unit comprises:
the determining module is used for determining a sub-formula dependent area associated with the formula dependent area according to a second mapping relation under the condition that the formula dependent area is a non-recording area;
and the second obtaining module is used for obtaining effective data from the second entry area in the query area under the condition that the sub-formula dependent area is the second entry area.
9. A computer device comprising a memory and a processor, the memory having stored thereon computer instructions which, when executed by the processor, cause a method of acquisition of data of a multidimensional database as claimed in any one of claims 1 to 5 to be performed.
10. A non-transitory computer-readable storage medium having stored thereon a computer program which, when executed by a processor, causes a method of acquisition of data of a multidimensional database as claimed in any one of claims 1 to 5 to be performed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110973370.3A CN113779160A (en) | 2021-08-24 | 2021-08-24 | Method and device for acquiring data of multidimensional database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110973370.3A CN113779160A (en) | 2021-08-24 | 2021-08-24 | Method and device for acquiring data of multidimensional database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113779160A true CN113779160A (en) | 2021-12-10 |
Family
ID=78838857
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110973370.3A Pending CN113779160A (en) | 2021-08-24 | 2021-08-24 | Method and device for acquiring data of multidimensional database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113779160A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116991901A (en) * | 2023-09-25 | 2023-11-03 | 深圳市秦丝科技有限公司 | Data control system and method based on multidimensional database query |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101866363A (en) * | 2010-06-22 | 2010-10-20 | 用友软件股份有限公司 | Report form formula tree tracking method and device |
| CN103678590A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Report collecting device and report collecting method based on OLAP |
| CN109684616A (en) * | 2018-12-13 | 2019-04-26 | 山东浪潮通软信息科技有限公司 | Dynamic statement formula assembles the method and system made a report on |
| CN112115153A (en) * | 2020-09-21 | 2020-12-22 | 北京字跳网络技术有限公司 | Data processing method, device, equipment and storage medium |
-
2021
- 2021-08-24 CN CN202110973370.3A patent/CN113779160A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101866363A (en) * | 2010-06-22 | 2010-10-20 | 用友软件股份有限公司 | Report form formula tree tracking method and device |
| CN103678590A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Report collecting device and report collecting method based on OLAP |
| CN109684616A (en) * | 2018-12-13 | 2019-04-26 | 山东浪潮通软信息科技有限公司 | Dynamic statement formula assembles the method and system made a report on |
| CN112115153A (en) * | 2020-09-21 | 2020-12-22 | 北京字跳网络技术有限公司 | Data processing method, device, equipment and storage medium |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116991901A (en) * | 2023-09-25 | 2023-11-03 | 深圳市秦丝科技有限公司 | Data control system and method based on multidimensional database query |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11977541B2 (en) | Systems and methods for rapid data analysis | |
| EP3825861A2 (en) | Method and apparatus of user clustering, computer device | |
| CN110688393B (en) | Query statement optimization method and device, computer equipment and storage medium | |
| CN110990390B (en) | Data cooperative processing method, device, computer equipment and storage medium | |
| CN108062418B (en) | Data searching method and device and server | |
| WO2020259325A1 (en) | Feature processing method applicable to machine learning, and device | |
| CN107885875B (en) | Synonymy transformation method and device for search words and server | |
| CN113779160A (en) | Method and device for acquiring data of multidimensional database | |
| CN111414528B (en) | Method and device for determining equipment identification, storage medium and electronic equipment | |
| CN112836124A (en) | Image data acquisition method and device, electronic equipment and storage medium | |
| CN108961071B (en) | Method for automatically predicting combined service income and terminal equipment | |
| CN111914101A (en) | Abnormal identification method and device for file association relationship and computer equipment | |
| CN109697234B (en) | Multi-attribute information query method, device, server and medium for entity | |
| CN111159229B (en) | Data query method and device | |
| CN114925919A (en) | Service resource processing method and device, computer equipment and storage medium | |
| CN115098503A (en) | Null value data processing method and device, computer equipment and storage medium | |
| CN114860759A (en) | Data processing method, device and equipment and readable storage medium | |
| CN113779161B (en) | Method and device for generating calculation script, computer equipment and storage medium | |
| CN112232862A (en) | Method, device, equipment and storage medium for predicting advertisement business channel ROI | |
| CN115458103B (en) | Medical data processing method, medical data processing device, electronic equipment and readable storage medium | |
| CN115496129B (en) | Software matching method and device | |
| CN117271641A (en) | Data processing method, device and storage medium | |
| CN117609303A (en) | Multi-table joint query method, device, equipment and storage medium | |
| CN116820326A (en) | Data processing method, device, electronic equipment and storage medium | |
| CN118051536A (en) | Multi-source cross-source data query method, device, equipment and storage 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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20211210 |