CN109783495A - A kind of multi-dimensional data processing method, device and computer equipment - Google Patents
A kind of multi-dimensional data processing method, device and computer equipment Download PDFInfo
- Publication number
- CN109783495A CN109783495A CN201910026965.0A CN201910026965A CN109783495A CN 109783495 A CN109783495 A CN 109783495A CN 201910026965 A CN201910026965 A CN 201910026965A CN 109783495 A CN109783495 A CN 109783495A
- Authority
- CN
- China
- Prior art keywords
- data
- dimension
- dimensional
- valid data
- valid
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
This application provides a kind of multi-dimensional data processing method, device and computer equipments, this method comprises: obtaining the multiple data of pending data source within a preset period of time；The first valid data are chosen from corresponding first data of the first dimensional informations multiple under the first dimension；From the remaining dimension for removing the first dimension, any dimension is chosen as the second dimension；The second valid data are chosen from corresponding the second data for forming the first valid data of the second dimensional informations multiple under the second dimension；The first valid data corresponding to first object dimensional information and corresponding second valid data of the second target dimension information visualize.The embodiment of the present application simplifies while showing the visual noise that multidimensional data generates by the way that using a dimension as granularity of query, stagewise carries out the selection of valid data, reduces the data volume inquired every time；The mode of above-mentioned stagewise extracted valid data characterizes the relevance between data, and improves recognition speed.
Description
Technical field
This application involves technical field of data processing, in particular to a kind of multi-dimensional data processing method, device and
Computer equipment.
Background technique
With the fast development of Internet technology, the data that business generates are more and more, and data dimension is also more and more, number
According to magnitude, exponentially type increases.In the big data era that data volume explodes, big data is analyzed, the hidden of data can be obtained
Hiding value.
Currently, in the prior art to the analysis of multi-dimensional data generally using tiling link method, i.e., by the number of various dimensions
Become multidimensional data tiling into excel table according to expansion, so that user's effective data from excel table.
But the mode of above-mentioned tiling link, the data volume of the multidimensional data after expansion is huge, can generate vision to user
Noise is not easy to user and searches valid data.Also, when data dimension is higher, data magnitude can be in exponential increase, and dimension is got over
Majority is bigger according to tiling amount, and visual noise is more.Meanwhile this method allows data correlation to die down, it is most of in data set
Data have extremely strong correlation, can not be isolated and be analyzed and shown as independent object, multidimensional data is tiled
Also the relevance between data can be allowed to die down at into excel table, user is allowed to identify that useful data becomes extremely difficult.
Summary of the invention
In view of this, the embodiment of the present application is designed to provide a kind of multi-dimensional data processing method, device and calculating
Machine equipment, using a dimension as granularity of query, stagewise carries out the selection of valid data, realizes the mass data from various dimensions
In quickly identify useful data, improve recognition speed.
In a first aspect, the embodiment of the present application provides a kind of multi-dimensional data processing method, which comprises
Obtain the multiple data of pending data source within a preset period of time；
Corresponding first data of multiple first dimensional informations are chosen from multiple data based on the first dimension, are obtained more
A first data；
It is chosen from multiple first data and meets the first valid data of the first preset condition, and record this first to have
Imitate the corresponding first object dimensional information of data；
From the remaining dimension for removing first dimension, any dimension is chosen as the second dimension；
It is corresponding for forming that multiple second dimensional informations are chosen from multiple data based on second dimension
Second data of corresponding first valid data of one mark dimensional information, obtain multiple second corresponding to each first valid data
Data；
It is chosen from multiple second data and meets the second valid data of the second preset condition, and record this second to have
Imitate the corresponding second target dimension information of data；
It is corresponding to corresponding first valid data of the first object dimensional information and the second target dimension information
The second valid data visualized.
With reference to first aspect, the embodiment of the present application provides the first possible embodiment of first aspect, wherein institute
The second valid data chosen from multiple second data and meet the second preset condition are stated, and record second valid data
After corresponding second target dimension information, the method also includes:
The remaining dimension for removing first dimension and second dimension if it exists then returns and chooses any dimension conduct
The step of second dimension, until there is no the remaining dimensions for removing first dimension and second dimension, alternatively, until returning
Round trip number reaches preset threshold.
With reference to first aspect, the embodiment of the present application provides second of possible embodiment of first aspect, wherein institute
Stating data includes the corresponding data of at least one index；Described choose from multiple first data meets the first preset condition
The first valid data, comprising:
For every one first data in multiple first data, judge whether first data meet first data right
Answer the first preset threshold range under index；
If first data are unsatisfactory for first preset threshold range, it is determined that first data are the first significant figure
According to；Wherein, for each first dimensional information, first preset threshold model of first data under corresponding index under the dimensional information
Enclose is according to the first data determination under the index in historical time section.
The possible embodiment of second with reference to first aspect, the embodiment of the present application provide the third of first aspect
Possible embodiment, wherein described that the second significant figure for meeting the second preset condition is chosen from multiple second data
According to, comprising:
For every one second data in multiple second data, judge whether first data meet second data right
Answer the second preset threshold range under index；
If second data are unsatisfactory for second preset threshold range, it is determined that second data are the second significant figure
According to, wherein it is directed to each second dimensional information, second preset threshold model of second data under corresponding index under the dimensional information
Enclose is according to the second data determination under the index in historical time section.
The possible embodiment of with reference to first aspect the first, the embodiment of the present application provide the 4th kind of first aspect
Possible embodiment, wherein described to corresponding first valid data of the first object dimensional information and described second
After corresponding second valid data of target dimension information are visualized, the method also includes:
Obtain the second valid data that last time is chosen；
Abnormality processing is carried out to the corresponding second target dimension information of second valid data of selection.
The possible embodiment of with reference to first aspect the first, the embodiment of the present application provide the 5th kind of first aspect
Possible embodiment, wherein described to corresponding first valid data of the first object dimensional information and described second
Corresponding second valid data of target dimension information are visualized, comprising:
Obtain preset template graph；
Corresponding first valid data of the first object dimensional information and described are shown based on preset template graph
Corresponding second valid data of second target dimension information.
Second aspect, the embodiment of the present application also provides a kind of multi-dimensional data processing units, comprising:
Module is obtained, for obtaining the multiple data of pending data source within a preset period of time；
Module is chosen, for choosing multiple first dimensional informations corresponding the from multiple data based on the first dimension
One data obtain multiple first data；The first significant figure for meeting the first preset condition is chosen from multiple first data
According to, and record the corresponding first object dimensional information of first valid data；From the remaining dimension for removing first dimension,
Any dimension is chosen as the second dimension；Multiple second dimensional information difference are chosen from multiple data based on second dimension
Corresponding the second data for being used to form corresponding first valid data of the first mark dimensional information, obtain having corresponding to each first
Imitate multiple second data of data；The second valid data for meeting the second preset condition are chosen from multiple second data,
And record the corresponding second target dimension information of second valid data；
Display module, for corresponding first valid data of the first object dimensional information and second target
Corresponding second valid data of dimensional information are visualized.
In conjunction with second aspect, the embodiment of the present application provides the first possible embodiment of second aspect, wherein institute
Selection module being stated, being also used to when there is the remaining dimension for removing first dimension and second dimension, returns to choose and appoint
The step of dimension is as the second dimension removes the remaining dimension of first dimension and second dimension until being not present,
Alternatively, until recycle time reaches preset threshold.
In conjunction with second aspect, the embodiment of the present application provides second of possible embodiment of second aspect, wherein institute
Stating data includes the corresponding data of at least one index；The selection module, is specifically used for:
For every one first data in multiple first data, judge whether first data meet first data right
Answer the first preset threshold range under index；
If first data are unsatisfactory for first preset threshold range, it is determined that first data are the first significant figure
According to；Wherein, for each first dimensional information, first preset threshold model of first data under corresponding index under the dimensional information
Enclose is according to the first data determination under the index in historical time section.
The third aspect, the embodiment of the present application also provides a kind of computer equipments, comprising: processor, memory and bus,
The memory is stored with the executable machine readable instructions of the processor, when computer equipment operation, the processor
First aspect is executed by bus communication between the memory, when the machine readable instructions are executed by the processor to appoint
The step of multi-dimensional data processing method described in one.
A kind of multi-dimensional data processing method, device and computer equipment provided by the embodiments of the present application, first from first
It is chosen in multiple first data under dimension and meets the first valid data of the first preset condition, then, from removing the first dimension
Remaining dimension in, choose any dimension as the second dimension, the of above-mentioned first valid data formed under second dimension
It is further chosen in two data and meets the second valid data of the second preset condition, finally by valid data of selection and corresponding
Target dimension information is visualized.In the embodiment of the present application, using a dimension as granularity of query, stagewise carries out effective
The selection of data reduces the data volume inquired every time, reduces while showing the visual noise that multidimensional data generates, also,
The mode of stagewise extracted valid data characterizes the relevance between data, can be from the sea of various dimensions by the above method
Useful data is quickly identified in amount data, improves recognition speed.
To enable the above objects, features, and advantages of the application to be clearer and more comprehensible, preferred embodiment is cited below particularly, and cooperate
Appended attached drawing, is described in detail below.
Detailed description of the invention
Technical solution in ord to more clearly illustrate embodiments of the present application, below will be to needed in the embodiment attached
Figure is briefly described, it should be understood that the following drawings illustrates only some embodiments of the application, therefore is not construed as pair
The restriction of range for those of ordinary skill in the art without creative efforts, can also be according to this
A little attached drawings obtain other relevant attached drawings.
Fig. 1 shows a kind of flow chart of multi-dimensional data processing method provided by the embodiment of the present application.
Fig. 2 shows a kind of schematic diagrames of the multi-dimensional data of displaying provided by the embodiment of the present application.
Fig. 3 shows the schematic diagram of the multi-dimensional data of the displaying of another kind provided by the embodiment of the present application.
Fig. 4 shows the schematic diagram of the multi-dimensional data of the displaying of another kind provided by the embodiment of the present application.
Fig. 5 shows the flow chart of another kind multi-dimensional data processing method provided by the embodiment of the present application.
Fig. 6 shows the flow chart of another kind multi-dimensional data processing method provided by the embodiment of the present application.
Fig. 7 shows the flow chart of another kind multi-dimensional data processing method provided by the embodiment of the present application.
Fig. 8 shows the flow chart of another kind multi-dimensional data processing method provided by the embodiment of the present application.
Fig. 9 shows a kind of structural schematic diagram of multi-dimensional data processing unit provided by the embodiment of the present application.
Figure 10 shows a kind of structural schematic diagram of computer equipment provided by the embodiment of the present application.
Specific embodiment
To keep the purposes, technical schemes and advantages of the embodiment of the present application clearer, below in conjunction with the embodiment of the present application
Middle attached drawing, the technical scheme in the embodiment of the application is clearly and completely described, it is clear that described embodiment is only
It is some embodiments of the present application, instead of all the embodiments.The application being usually described and illustrated herein in the accompanying drawings is real
The component for applying example can be arranged and be designed with a variety of different configurations.Therefore, below to the application's provided in the accompanying drawings
The detailed description of embodiment is not intended to limit claimed scope of the present application, but is merely representative of the selected reality of the application
Apply example.Based on embodiments herein, those skilled in the art institute obtained without making creative work
There are other embodiments, shall fall in the protection scope of this application.
It as shown in Figure 1, Figure 2, Figure 3 and Figure 4, is a kind of multi-dimensional data processing method provided by the embodiments of the present application, institute
The method of stating can be applied to terminal device or server, in the above way be applied to be illustrated for server, the side
Method includes:
S101, the multiple data of pending data source within a preset period of time are obtained.
In the embodiment of the present application, user pre-selects pending data source, and selects the range of time dimension.Server
Multiple data out of the corresponding preset time period of range that select above-mentioned time dimension in pending data source.
Here, the data of acquisition include the data under multiple indexs.These parameters include trading volume, transaction success rate etc..
Wherein, trading volume can be with transaction amount, transaction stroke count etc..Data in above-mentioned pending data source have multiple dimensions, here
Multiple dimensions may is that region dimension, channel dimension, type dimension and data addressing dimension etc..
S102, corresponding first data of multiple first dimensional informations are chosen from multiple data based on the first dimension,
Obtain multiple first data.
In the embodiment of the present application, the first dimension can be what user currently selected, and it is pre-configured to be also possible to user.
It include multiple first dimensional informations in the first dimension of server, server is based on the first dimension, shows multiple first dimensional informations
Corresponding first data.
Using the first dimension as region dimension, which can be Beijing, Shanghai, Shenzhen, Hangzhou etc.；With trade gold
Volume, transaction stroke count and the data instance traded under these three indexs of success rate:
Beijing, transaction amount 400,000 are traded stroke count 200, success rate 40% of trading；
Shanghai, transaction amount 500,000 are traded stroke count 60, success rate 85% of trading；
Shenzhen, transaction amount 600,000 are traded stroke count 70, success rate 90% of trading；
Hangzhou, transaction amount 500,000 are traded stroke count 60, success rate 95% of trading.
S103, the first valid data for meeting the first preset condition are chosen from multiple first data, and recording should
The corresponding first object dimensional information of first valid data.
In the embodiment of the present application, the first preset condition can refer to for the first data under each first dimensional information in correspondence
The first preset threshold range under mark；Wherein, corresponding first preset threshold range of different first dimensional informations can be identical,
It can be different.
For example, Beijing area, corresponding first preset threshold range of transaction amount is 40~800,000, and transaction stroke count is 40
~100；
In Hangzhou Region of Zhe Jiang Province, corresponding first preset threshold range of transaction amount are 20-60 ten thousand, and transaction stroke count is 40~100
Pen.
And above-mentioned first valid data chosen can be the abnormal data for being unsatisfactory for above-mentioned first preset threshold range.Than
Such as, Pekinese trades stroke count 200, does not meet the first preset threshold range 40~100 under the index, chooses the transaction
Stroke count 200 are abnormal data, meanwhile, recording the corresponding region dimension of transaction stroke count 200 is Beijing.
S104, from the remaining dimension for removing first dimension, choose any dimension as the second dimension.
In the embodiment of the present application, region dimension is removed, further includes channel dimension, type dimension and data in remaining dimension
Location dimension etc., chooses that channel dimension, any dimension for example chooses canal as the second dimension in type dimension and data addressing dimension
Road dimension is as the second dimension.
S105, to choose multiple second dimensional informations from multiple data based on second dimension corresponding for group
At the second data of corresponding first valid data of the first mark dimensional information, obtain corresponding to the multiple of each first valid data
Second data.
It include multiple second dimensional informations in the second dimension in the embodiment of the present application, server is based on the second dimension, shows
Corresponding second data of multiple second dimensional informations, and to can make up the first mark dimensional information corresponding for these second data
First valid data.
For example, the second dimension is channel dimension, multiple second dimensional informations can be with are as follows: Internetbank, ATM
(Automatic Teller Machine, ATM), sales counter etc..
Corresponding, the transaction amount 400,000 of Beijing Area can be divided into: the network bank business amount of money of Beijing Area is 200,000,
ATM transaction amount 100,000, the over-the-counter trading amount of money 10；The transaction amount of each channel of Beijing Area Beijing Area corresponding with value
Transaction amount 400,000.
Transaction stroke count 200 of Beijing Area can be divided into: transaction stroke count 200 of Beijing Area can be divided into: Beijing
The network bank business stroke count in region is 150, and ATM trades stroke count 30, over-the-counter trading stroke count 20；Each channel of Beijing Area
Transaction stroke count 200 of transaction stroke count Beijing Area corresponding with value.
S106, the second valid data for meeting the second preset condition are chosen from multiple second data, and recording should
The corresponding second target dimension information of second valid data.
In the embodiment of the present application, the second preset condition can refer to for the second data under each second dimensional information in correspondence
The second preset threshold range under mark；Wherein, corresponding second preset threshold range of different second dimensional informations can be identical,
It can be different.For example, Beijing area, corresponding second preset threshold range of network bank business stroke count is 10~100.
And above-mentioned second valid data chosen can be the abnormal data for being unsatisfactory for above-mentioned second preset threshold range.Than
Such as, network bank business stroke count in Beijing Area's does not meet corresponding i.e. the second preset threshold range 10~100 for 150, at this point,
Choosing transaction stroke count 150 is the second valid data, and records corresponding network bank business channel.
S107, to corresponding first valid data of the first object dimensional information and the second target dimension information
Corresponding second valid data are visualized.
In the embodiment of the present application, server can show above-mentioned first object dimensional information, first in Visual Chart
Valid data, the second target dimension information and the second valid data.
In specific embodiment, server can show Beijing Area, transaction stroke count 200, net in Visual Chart
Silver-colored channel, transaction stroke count 150, in order to which user checks abnormal data and relevant dimension information.
A kind of multi-dimensional data processing method provided by the embodiments of the present application, first from multiple first numbers under the first dimension
Meet the first valid data of the first preset condition according to middle selection, then, from the remaining dimension for removing the first dimension, chooses and appoint
Dimension further chooses symbol as the second dimension from the second data for forming above-mentioned first valid data under second dimension
The second valid data of the second preset condition are closed, are finally carried out the valid data of selection and corresponding target dimension information visual
Change and shows.In this way, stagewise carries out the selection of valid data using a dimension as granularity of query, reduce the number inquired every time
According to amount, the visual noise that multidimensional data generates is reduced while shown, also, the mode of stagewise extracted valid data characterizes
Relevance between data, useful data can quickly be identified from the mass data of various dimensions by the above method, improved
Recognition speed.
Further, in multi-dimensional data processing method provided by the embodiments of the present application, from multiple second data
The second valid data for meeting the second preset condition are chosen, and record the corresponding second target dimension information of second valid data
Later, the method also includes:
The remaining dimension for removing first dimension and second dimension if it exists then returns and chooses any dimension conduct
The step of second dimension, until there is no the remaining dimensions for removing first dimension and second dimension, alternatively, until returning
Round trip number reaches preset threshold.
In the embodiment of the present application, region dimension and channel dimension are removed, further includes type dimension and data in remaining dimension
Addressing dimension etc., server chooses in type dimension and data addressing dimension any dimension as the second dimension, for example chooses class
Type dimension continues the abnormal data choosing that network bank business stroke count is 150 corresponding multiple third data as the second dimension
It takes.
For example it include: money transfer transactions stroke count is 130 that network bank business stroke count, which is 150, payment transaction stroke count 20.Service
Device determines that money transfer transactions stroke count 130 do not meet corresponding preset condition, then chooses the money transfer transactions stroke count 130 as significant figure
According to.
In the embodiment of the present application, region dimension, channel dimension and type dimension are removed, further includes data in remaining dimension
Location dimension, server continue to choose data address dimension as the second dimension, and money transfer transactions stroke count is 130 and includes:
Source IP address IP1 transfer accounts stroke count be 120；
Source IP address IP2 transfer accounts stroke count be 2；
Source IP address IP3 transfer accounts stroke count be 2；
Source IP address IP4 transfer accounts stroke count be 6.
Server determines that source IP address IP1 transfers accounts stroke count 120 and do not meet corresponding preset condition, then with choosing the source IP
Location IP1 transfers accounts stroke count 120 as valid data.
In the embodiment of the present application, user can perform corresponding processing for above-mentioned abnormal data.For example, when determining source IP
Address is that transferring accounts stroke count 120 for IP1 is valid data, and user can carry out title processing to the source IP address of IP1.
Further, as shown in figure 5, in multi-dimensional data processing method provided by the embodiments of the present application, the data packet
Include the corresponding data of at least one index；The selection from multiple first data, which meets the first of the first preset condition, to be had
Imitate data, comprising:
S501, for every one first data in multiple first data, judge whether first data meet first number
According to the first preset threshold range under corresponding index.
In the embodiment of the present application, the first preset condition can be the first data under each first dimensional information in corresponding index
Under the first preset threshold range；Wherein, corresponding first preset threshold range of different first dimensional informations can be identical, can also
With difference.
For example, Beijing area, corresponding first preset threshold range of transaction amount is 40~800,000, and transaction stroke count is 40
~100；
In Hangzhou Region of Zhe Jiang Province, corresponding first preset threshold range of transaction amount are 20-60 ten thousand, and transaction stroke count is 40~100
Pen.
Correspondingly, the first preset threshold range of Beijing area corresponding 40~800,000 be according to Beijing area in history
Between section transaction amount determine.First preset threshold range of In Hangzhou Region of Zhe Jiang Province corresponding 20~600,000 is existed according to Beijing area
What the transaction amount of historical time section determined.
If S502, first data are unsatisfactory for first preset threshold range, it is determined that first data have for first
Imitate data；Wherein, for each first dimensional information, first default threshold of first data under corresponding index under the dimensional information
Value range is determined according to the first data under the index in historical time section.
In the embodiment of the present application, if server detect the first data not in corresponding first preset threshold range,
Determine that the first data are the first valid data.Here, the first valid data can be abnormal data.
For example, Pekinese trades stroke count 200, the first preset threshold range 40~100 under the index are not met,
The transaction stroke count 200 are chosen as abnormal data, meanwhile, recording the corresponding region dimension of transaction stroke count 200 is Beijing.
Further, as shown in fig. 6, in multi-dimensional data processing method provided by the embodiments of the present application, from multiple described
The second valid data for meeting the second preset condition are chosen in second data, comprising:
S601, for every one second data in multiple second data, judge whether first data meet second number
According to the second preset threshold range under corresponding index.
In the embodiment of the present application, the second preset condition can be the second data under each second dimensional information in corresponding index
Under the second preset threshold range；Wherein, corresponding first preset threshold range of different second dimensional informations can be identical, can also
With difference.
For example, corresponding second preset threshold range of Beijing area network bank business stroke count 10~100.Correspondingly, northern
Corresponding second preset threshold range of the corresponding network bank business stroke count in capital area is the net according to Beijing area in historical time section
Silver transaction stroke count determines.
If S602, second data are unsatisfactory for second preset threshold range, it is determined that second data have for second
Imitate data, wherein be directed to each second dimensional information, second default threshold of second data under corresponding index under the dimensional information
Value range is determined according to the second data under the index in historical time section.
In the embodiment of the present application, if server detect the second data not in corresponding second preset threshold range,
Determine that the second data are the second abnormal data.Here, the second valid data can be abnormal data.
For example, Beijing Area's network bank business stroke count 150 does not meet corresponding second preset threshold range 10~100
Pen at this point, choosing transaction stroke count 150 is the second valid data, and records corresponding network bank business channel.
Further, as shown in fig. 7, in multi-dimensional data processing method provided by the embodiments of the present application, to described first
Corresponding first valid data of target dimension information and corresponding second valid data of the second target dimension information carry out
After visual presentation, the method also includes:
S701, the second valid data that last time is chosen are obtained.
In the embodiment of the present application, server determine source IP address be IP1 transfer accounts stroke count 120 be abnormal data.
S702, abnormality processing is carried out to the corresponding second target dimension information of second valid data of selection.
As a kind of optional embodiment, server can carry out title processing by the source IP address to IP1 automatically.
Further, as shown in figure 8, in multi-dimensional data processing method provided by the embodiments of the present application, to described first
Corresponding first valid data of target dimension information and corresponding second valid data of the second target dimension information carry out
It visualizes, comprising:
S801, preset template graph is obtained.
In the embodiment of the present application, in preset template graph, multidimensional analysis part can partially pack up, be unfolded, is full frame
Expansion etc., so as to user flexibility use.
S802, shown based on preset template graph corresponding first valid data of the first object dimensional information and
Corresponding second valid data of the second target dimension information.
It is pre-configured in the embodiment of the present application, in server there are many preset template graph, server, which passes through, to be chosen
Preset template graph shows corresponding content.Wherein, the configuration mode of different type template graph is different.In addition, configuring
During Visual Chart, reference time data, dimension and chart sample can be adjusted according to the bandwagon effect of Visual Chart
Formula.In the embodiment of the present application, server can be instructed based on the modification of user, modify different preset template graphs, with
Just the more clear observation analysis data of user.
In the embodiment of the present application, corresponding content is shown by template graph, user can be obtained with stagewise and be checked not
Same dimension data solves the data of no the superior and the subordinate's dimensional relationships in such a way that user selects the precedence relationship filtering of dimension
Obtain and check problem.
In the embodiment of the present application, big data Visualized Analysis System is applied to by above-mentioned multi-dimensional data processing method
In, it is significantly improved to efficiency, specific manifestation are as follows:
1, the visual noise generated in data analysis is simplified, makes interface cleaner and tidier.
2, it allows the relevance between data clear, can easily find out the correlation of data.
3, it has wide range of applications, can be used in any complicated dimension data, including being associated in weaker data.
4, the data of various dimensions are got over, the data drilled through are more valuable, and precision is higher.
5, easy to operate.
As shown in figure 9, described device is for executing the embodiment of the present application also provides a kind of multi-dimensional data processing unit
Above-mentioned multi-dimensional data processing method, described device include:
Module 901 is obtained, for obtaining the multiple data of pending data source within a preset period of time；
Module 902 is chosen, is respectively corresponded for choosing multiple first dimensional informations from multiple data based on the first dimension
The first data, obtain multiple first data；Selection, which meets the first of the first preset condition, from multiple first data has
Data are imitated, and record the corresponding first object dimensional information of first valid data；From the remaining dimension for removing first dimension
In degree, any dimension is chosen as the second dimension；Multiple second dimension letters are chosen from multiple data based on second dimension
Corresponding the second data for being used to form corresponding first valid data of the first mark dimensional information are ceased, obtain corresponding to each
Multiple second data of first valid data；From multiple second data choose meet the second preset condition second effectively
Data, and record the corresponding second target dimension information of second valid data；
Display module 903, for corresponding first valid data of the first object dimensional information and described second
Corresponding second valid data of target dimension information are visualized.
Further, as shown in figure 9, in multi-dimensional data processing unit provided by the embodiments of the present application,
Module 902 being chosen, being also used to return when there is the remaining dimension for removing first dimension and second dimension
It returns and chooses the step of any dimension is as the second dimension, until there is no remove the surplus of first dimension and second dimension
Codimension degree, alternatively, until recycle time reaches preset threshold.
Further, as shown in figure 9, in multi-dimensional data processing unit provided by the embodiments of the present application, the data packet
Include the corresponding data of at least one index；Module 902 is chosen, is specifically used for:
For every one first data in multiple first data, judge whether first data meet first data right
Answer the first preset threshold range under index；
If first data are unsatisfactory for first preset threshold range, it is determined that first data are the first significant figure
According to；Wherein, for each first dimensional information, first preset threshold model of first data under corresponding index under the dimensional information
Enclose is according to the first data determination under the index in historical time section.
Further, as shown in figure 9, in multi-dimensional data processing unit provided by the embodiments of the present application, module is chosen
902, it is specifically used for:
For every one second data in multiple second data, judge whether first data meet second data right
Answer the second preset threshold range under index；
If second data are unsatisfactory for second preset threshold range, it is determined that second data are the second significant figure
According to, wherein it is directed to each second dimensional information, second preset threshold model of second data under corresponding index under the dimensional information
Enclose is according to the second data determination under the index in historical time section.
Further, multi-dimensional data processing unit provided by the embodiments of the present application, further includes:
Module is obtained, the second valid data chosen for obtaining last time；
Exception processing module, it is different for being carried out to the corresponding second target dimension information of second valid data of selection
Often processing.
Further, in multi-dimensional data processing unit provided by the embodiments of the present application, display module 903 is specifically used for:
Obtain preset template graph；
Corresponding first valid data of the first object dimensional information and described are shown based on preset template graph
Corresponding second valid data of second target dimension information.
A kind of multi-dimensional data processing unit provided by the embodiments of the present application, first from multiple first numbers under the first dimension
Meet the first valid data of the first preset condition according to middle selection, then, from the remaining dimension for removing the first dimension, chooses and appoint
Dimension further chooses symbol as the second dimension from the second data for forming above-mentioned first valid data under second dimension
The second valid data of the second preset condition are closed, are finally carried out the valid data of selection and corresponding target dimension information visual
Change and shows.In this way, stagewise carries out the selection of valid data using a dimension as granularity of query, reduce the number inquired every time
According to amount, the visual noise that multidimensional data generates is reduced while shown, also, the mode of stagewise extracted valid data characterizes
Relevance between data, useful data can quickly be identified from the mass data of various dimensions by the above method, improved
Recognition speed.
As shown in Figure 10, the embodiment of the present application also provides a kind of computer equipments 100, comprising: processor 1002, storage
Device 1001 and bus, the memory 1001 are stored with the executable machine readable instructions of the processor 1002, work as computer
When equipment 100 is run, pass through bus communication, the machine readable instructions between the processor 1002 and the memory 1001
The step of executing above-mentioned multi-dimensional data processing method when being executed by the processor 1002.
Specifically, above-mentioned memory 1001 and processor 1002 can be general memory and processor, not do here
It is specific to limit, when the computer program of 1002 run memory 1001 of processor storage, it is able to carry out above-mentioned multi-dimensional data
Processing method.
Corresponding to above-mentioned multi-dimensional data processing method, a kind of computer storage medium provided by the embodiments of the present application, institute
It states computer storage medium and is stored with computer executable instructions, which can be performed above-mentioned multi-dimensional data
Processing method.
Multi-dimensional data processing unit provided by the embodiment of the present application can be the specific hardware or installation in equipment
In software or firmware etc. in equipment.The technical effect of device provided by the embodiment of the present application, realization principle and generation and
Preceding method embodiment is identical, and to briefly describe, Installation practice part does not refer to place, can refer in preceding method embodiment
Corresponding contents.It is apparent to those skilled in the art that for convenience and simplicity of description, foregoing description is
The specific work process of system, device and unit, the corresponding process during reference can be made to the above method embodiment, it is no longer superfluous herein
It states.
In embodiment provided herein, it should be understood that disclosed device and method, it can be by others side
Formula is realized.The apparatus embodiments described above are merely exemplary, for example, the division of the unit, only one kind are patrolled
Function division is collected, there may be another division manner in actual implementation, in another example, multiple units or components can combine or can
To be integrated into another system, or some features can be ignored or not executed.Another point, shown or discussed is mutual
Coupling, direct-coupling or communication connection can be INDIRECT COUPLING or communication link by some communication interfaces, device or unit
It connects, can be electrical property, mechanical or other forms.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.Some or all of unit therein can be chosen according to the actual needs to realize the mesh of this embodiment scheme
's.
In addition, each functional unit in embodiment provided by the present application can integrate in one processing unit, it can also
To be that each unit physically exists alone, can also be integrated in one unit with two or more units.
It, can be with if the function is realized in the form of SFU software functional unit and when sold or used as an independent product
It is stored in a computer readable storage medium.Based on this understanding, the technical solution of the application is substantially in other words
The part of the part that contributes to existing technology or the technical solution can be embodied in the form of software products, the meter
Calculation machine software product is stored in a storage medium, including some instructions are used so that a computer equipment (can be a
People's computer, server or network equipment etc.) execute each embodiment the method for the application all or part of the steps.
And storage medium above-mentioned includes: that USB flash disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), arbitrary access are deposited
The various media that can store program code such as reservoir (RAM, Random Access Memory), magnetic or disk.
It should also be noted that similar label and letter indicate similar terms in following attached drawing, therefore, once a certain Xiang Yi
It is defined in a attached drawing, does not then need that it is further defined and explained in subsequent attached drawing, in addition, term " the
One ", " second ", " third " etc. are only used for distinguishing description, are not understood to indicate or imply relative importance.
Finally, it should be noted that embodiment described above, the only specific embodiment of the application, to illustrate the application
Technical solution, rather than its limitations, the protection scope of the application is not limited thereto, although with reference to the foregoing embodiments to this Shen
It please be described in detail, those skilled in the art should understand that: anyone skilled in the art
Within the technical scope of the present application, it can still modify to technical solution documented by previous embodiment or can be light
It is readily conceivable that variation or equivalent replacement of some of the technical features；And these modifications, variation or replacement, do not make
The essence of corresponding technical solution is detached from the spirit and scope of the embodiment of the present application technical solution.The protection in the application should all be covered
Within the scope of.Therefore, the protection scope of the application should be based on the protection scope of the described claims.
Claims (10)
1. a kind of multi-dimensional data processing method, which is characterized in that the described method includes:
Obtain the multiple data of pending data source within a preset period of time；
Corresponding first data of multiple first dimensional informations are chosen from multiple data based on the first dimension, obtain multiple
One data；
The first valid data for meeting the first preset condition are chosen from multiple first data, and record first significant figure
According to corresponding first object dimensional information；
From the remaining dimension for removing first dimension, any dimension is chosen as the second dimension；
It is corresponding for forming the first mark that multiple second dimensional informations are chosen from multiple data based on second dimension
Second data of corresponding first valid data of dimensional information obtain multiple second numbers corresponding to each first valid data
According to；
The second valid data for meeting the second preset condition are chosen from multiple second data, and record second significant figure
According to corresponding second target dimension information；
Corresponding to corresponding first valid data of the first object dimensional information and the second target dimension information
Two valid data are visualized.
2. multi-dimensional data processing method according to claim 1, which is characterized in that described from multiple second data
It is middle to choose the second valid data for meeting the second preset condition, and record the corresponding second target dimension letter of second valid data
After breath, the method also includes:
The remaining dimension for removing first dimension and second dimension if it exists then returns and chooses any dimension as second
The step of dimension, until there is no the remaining dimensions for removing first dimension and second dimension, alternatively, until returning secondary
Number reaches preset threshold.
3. multi-dimensional data processing method according to claim 1, which is characterized in that the data include that at least one refers to
Mark corresponding data；It is described that the first valid data for meeting the first preset condition are chosen from multiple first data, comprising:
For every one first data in multiple first data, judge whether first data meet first data and refer in correspondence
The first preset threshold range under mark；
If first data are unsatisfactory for first preset threshold range, it is determined that first data are the first valid data；Its
In, for each first dimensional information, first preset threshold range of first data under corresponding index is under the dimensional information
It is determined according to the first data under the index in historical time section.
4. multi-dimensional data processing method according to claim 3, which is characterized in that described from multiple second data
It is middle to choose the second valid data for meeting the second preset condition, comprising:
For every one second data in multiple second data, judge whether first data meet second data and refer in correspondence
The second preset threshold range under mark；
If second data are unsatisfactory for second preset threshold range, it is determined that second data are the second valid data,
In, for each second dimensional information, second preset threshold range of second data under corresponding index is under the dimensional information
It is determined according to the second data under the index in historical time section.
5. multi-dimensional data processing method according to claim 2, which is characterized in that described to the first object dimension
Corresponding first valid data of information and corresponding second valid data of the second target dimension information carry out visualization exhibition
After showing, the method also includes:
Obtain the second valid data that last time is chosen；
Abnormality processing is carried out to the corresponding second target dimension information of second valid data of selection.
6. multi-dimensional data processing method according to claim 2, which is characterized in that described to the first object dimension
Corresponding first valid data of information and corresponding second valid data of the second target dimension information carry out visualization exhibition
Show, comprising:
Obtain preset template graph；
Corresponding first valid data of the first object dimensional information and described second are shown based on preset template graph
Corresponding second valid data of target dimension information.
7. a kind of multi-dimensional data processing unit characterized by comprising
Module is obtained, for obtaining the multiple data of pending data source within a preset period of time；
Module is chosen, for choosing corresponding first number of multiple first dimensional informations from multiple data based on the first dimension
According to obtaining multiple first data；The first valid data for meeting the first preset condition are chosen from multiple first data, and
Record the corresponding first object dimensional information of first valid data；From the remaining dimension for removing first dimension, choose
Any dimension is as the second dimension；Multiple second dimensional informations are chosen from multiple data based on second dimension to respectively correspond
For form the second data of the first corresponding first valid data of mark dimensional information, obtain corresponding to each first significant figure
According to multiple second data；The second valid data for meeting the second preset condition are chosen from multiple second data, and are remembered
Record the corresponding second target dimension information of second valid data；
Display module, for corresponding first valid data of the first object dimensional information and second target dimension
Corresponding second valid data of information are visualized.
8. multi-dimensional data processing unit according to claim 7, which is characterized in that choose module, be also used to exist
When removing the remaining dimension of first dimension and second dimension, the step for choosing any dimension as the second dimension is returned
Suddenly, until there is no the remaining dimensions for removing first dimension and second dimension, alternatively, until recycle time reaches pre-
If threshold value.
9. multi-dimensional data processing unit according to claim 7, which is characterized in that the data include that at least one refers to
Mark corresponding data；The selection module, is specifically used for:
For every one first data in multiple first data, judge whether first data meet first data and refer in correspondence
The first preset threshold range under mark；
If first data are unsatisfactory for first preset threshold range, it is determined that first data are the first valid data；Its
In, for each first dimensional information, first preset threshold range of first data under corresponding index is under the dimensional information
It is determined according to the first data under the index in historical time section.
10. a kind of computer equipment characterized by comprising processor, memory and bus, the memory storage is
The executable machine readable instructions of processor are stated, when computer equipment operation, are led between the processor and the memory
Bus communication is crossed, the machine readable instructions execute as described in any one of claims 1 to 6 more when being executed by the processor
The step of dimension data processing method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910026965.0A CN109783495B (en) | 2019-01-11 | 2019-01-11 | Multi-dimensional data processing method and device and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910026965.0A CN109783495B (en) | 2019-01-11 | 2019-01-11 | Multi-dimensional data processing method and device and computer equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109783495A true CN109783495A (en) | 2019-05-21 |
| CN109783495B CN109783495B (en) | 2021-02-23 |
Family
ID=66500125
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910026965.0A Active CN109783495B (en) | 2019-01-11 | 2019-01-11 | Multi-dimensional data processing method and device and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109783495B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110750580A (en) * | 2019-10-23 | 2020-02-04 | 北京博睿宏远数据科技股份有限公司 | Data analysis method and device, computer equipment and storage medium |
| CN112749201A (en) * | 2019-10-30 | 2021-05-04 | 北京国双科技有限公司 | Structured data processing method and system |
| CN113254542A (en) * | 2021-04-21 | 2021-08-13 | 泰康保险集团股份有限公司 | Data visualization processing method and device and electronic equipment |
| CN113379551A (en) * | 2021-07-02 | 2021-09-10 | 华青融天(北京)软件股份有限公司 | Transaction data analysis method and device and electronic equipment |
| CN114297227A (en) * | 2021-12-24 | 2022-04-08 | 成都索贝数码科技股份有限公司 | Time sequence database architecture method, query method and time sequence database |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6904427B1 (en) * | 1999-04-30 | 2005-06-07 | Fujitsu Limited | Search system and method based on search condition combinations |
| CN104408169A (en) * | 2014-12-09 | 2015-03-11 | 北京国双科技有限公司 | Multi-dimensional expression language based dimension query method and device |
| CN105740333A (en) * | 2016-01-23 | 2016-07-06 | 北京掌阔移动传媒科技有限公司 | Visual advertisement management platform, and implementation method thereof |
| CN105447098B (en) * | 2015-11-10 | 2018-12-14 | 中国建设银行股份有限公司 | A kind of information query method and device |
| CN109101506A (en) * | 2017-06-20 | 2018-12-28 | 聚法科技（长春）有限公司 | Based on visual searching method and system |
-
2019
- 2019-01-11 CN CN201910026965.0A patent/CN109783495B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6904427B1 (en) * | 1999-04-30 | 2005-06-07 | Fujitsu Limited | Search system and method based on search condition combinations |
| CN104408169A (en) * | 2014-12-09 | 2015-03-11 | 北京国双科技有限公司 | Multi-dimensional expression language based dimension query method and device |
| CN105447098B (en) * | 2015-11-10 | 2018-12-14 | 中国建设银行股份有限公司 | A kind of information query method and device |
| CN105740333A (en) * | 2016-01-23 | 2016-07-06 | 北京掌阔移动传媒科技有限公司 | Visual advertisement management platform, and implementation method thereof |
| CN109101506A (en) * | 2017-06-20 | 2018-12-28 | 聚法科技（长春）有限公司 | Based on visual searching method and system |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110750580A (en) * | 2019-10-23 | 2020-02-04 | 北京博睿宏远数据科技股份有限公司 | Data analysis method and device, computer equipment and storage medium |
| CN112749201A (en) * | 2019-10-30 | 2021-05-04 | 北京国双科技有限公司 | Structured data processing method and system |
| CN113254542A (en) * | 2021-04-21 | 2021-08-13 | 泰康保险集团股份有限公司 | Data visualization processing method and device and electronic equipment |
| CN113254542B (en) * | 2021-04-21 | 2023-10-27 | 泰康保险集团股份有限公司 | Data visualization processing method and device and electronic equipment |
| CN113379551A (en) * | 2021-07-02 | 2021-09-10 | 华青融天(北京)软件股份有限公司 | Transaction data analysis method and device and electronic equipment |
| CN114297227A (en) * | 2021-12-24 | 2022-04-08 | 成都索贝数码科技股份有限公司 | Time sequence database architecture method, query method and time sequence database |
| CN114297227B (en) * | 2021-12-24 | 2023-06-20 | 成都索贝数码科技股份有限公司 | Time sequence database construction method, query method and time sequence database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109783495B (en) | 2021-02-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109783495A (en) | A kind of multi-dimensional data processing method, device and computer equipment | |
| CN107690657B (en) | Trade company is found according to image | |
| US20020070953A1 (en) | Systems and methods for visualizing and analyzing conditioned data | |
| CN109697434A (en) | A kind of Activity recognition method, apparatus and storage medium | |
| CN107851275A (en) | Time series explorer | |
| CN110045953A (en) | Generate the method and computing device of business rule expression formula | |
| CN110515830A (en) | Operation trace method for visualizing, device, equipment and storage medium | |
| Blake et al. | The impact of shape on the perception of Euler diagrams | |
| CN110490181A (en) | A kind of list based on OCR identification technology fills in checking method, device, equipment and computer storage medium | |
| CN109346168A (en) | A kind of method and device of determining data dependence | |
| CN109165377A (en) | Generate the method and tabulating equipment of form data | |
| CN107908733A (en) | A kind of querying method of global trade data, apparatus and system | |
| CN110222285A (en) | The methods of exhibiting of reading page calculates equipment and computer storage medium | |
| Webga et al. | Discovery of rating fraud with real-time streaming visual analytics | |
| CN108234659A (en) | Data processing method, apparatus and system | |
| CN109814958A (en) | Management state display methods, device, computer installation and storage medium | |
| Laramee et al. | Challenges and unsolved problems | |
| CN110210521A (en) | Image-recognizing method, device, server, terminal and storage medium | |
| Tatzgern et al. | Multi-perspective compact explosion diagrams | |
| Beaini et al. | Deep green function convolution for improving saliency in convolutional neural networks | |
| AU2017101931A4 (en) | Method and system for collecting, visualising and analysing risk data | |
| Kammer et al. | Exploring big data landscapes with elastic displays | |
| CN108093013A (en) | A kind of web data computational methods and server | |
| Vollmer et al. | 5 D dust & magnet visualization for large multivariate data | |
| CN104636458B (en) | The update method and device in address information storehouse |
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 |