CN108415964A - Tables of data querying method, device, terminal device and storage medium - Google Patents
Tables of data querying method, device, terminal device and storage medium Download PDFInfo
- Publication number
- CN108415964A CN108415964A CN201810121968.8A CN201810121968A CN108415964A CN 108415964 A CN108415964 A CN 108415964A CN 201810121968 A CN201810121968 A CN 201810121968A CN 108415964 A CN108415964 A CN 108415964A
- Authority
- CN
- China
- Prior art keywords
- data
- middle table
- tables
- index dimension
- target
- 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
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/248—Presentation of query results
-
- 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/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
- G06F16/9017—Indexing; Data structures therefor; Storage structures using directory or table look-up
- G06F16/902—Indexing; Data structures therefor; Storage structures using directory or table look-up using more than one table in sequence, i.e. systems with three or more layers
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of tables of data querying method, device, terminal device and storage mediums.The tables of data querying method includes：Data query instruction is obtained, data query instruction includes middle table ID and inquiry index dimension；Based on middle table ID, obtain target middle table corresponding with middle table ID, target middle table includes at least two original index dimensions and index dimension numerical value corresponding with original index dimension, the target middle table is inquired based on inquiry index dimension, the index dimension numerical value for obtaining original index dimension corresponding with inquiry index dimension, as target dimension numerical value.The tables of data querying method can also improve its response time while improving tables of data search efficiency.
Description
Technical field
The present invention relates to data processing field more particularly to a kind of tables of data querying method, device, terminal device and storages
Medium.
Background technology
System database is the warehouse for organizing, storing and managing data, with data sheet form in system database
The huge data of storage quantity.In inquiry system database when different dimensions (such as time, region and source dimension), use
Query sentence of database directly inquires all data in system database, since the data volume of system database is huge,
Data congestion situation is susceptible in query process, it is low so as to cause tables of data search efficiency so that the sound of tables of data inquiry
It is longer between seasonable.
Invention content
A kind of tables of data querying method of offer of the embodiment of the present invention, device, terminal device and storage medium, to solve data
Table search efficiency is relatively low, leads to the longer problem of query responding time.
In a first aspect, the embodiment of the present invention provides a kind of tables of data querying method, including：
Data query instruction is obtained, the data query instruction includes middle table ID and inquiry index dimension；
Based on the middle table ID, target middle table corresponding with the middle table ID, the target middle table are obtained
Including at least two original index dimensions and index dimension numerical value corresponding with the original index dimension；
The target middle table is inquired based on the inquiry index dimension, is obtained corresponding with the inquiry index dimension
The index dimension numerical value of original index dimension, as target dimension numerical value.
Second aspect, the embodiment of the present invention provide a kind of tables of data inquiry unit, including：
Data query instruction acquisition module, for obtaining data query instruction, the data query instruction includes middle table
ID and inquiry index dimension；
Target middle table acquisition module is based on the middle table ID for obtaining, obtains corresponding with the middle table ID
Target middle table, the target middle table includes at least two original index dimensions and corresponding with the original index dimension
Index dimension numerical value；
Index dimension numerical value acquisition module is obtained for inquiring the target middle table based on the inquiry index dimension
The index dimension numerical value of original index dimension corresponding with the inquiry index dimension, as target dimension numerical value.
The third aspect, the embodiment of the present invention provide a kind of terminal device, including memory, processor and are stored in described
In memory and the computer program that can run on the processor, the processor are realized when executing the computer program
The step of tables of data querying method.
Fourth aspect, the embodiment of the present invention provide a kind of computer-readable medium, and the computer-readable medium storage has
The step of computer program, the computer program realizes tables of data querying method when being executed by processor.
In tables of data querying method provided in an embodiment of the present invention, device, terminal device and storage medium, looked by data
The middle table ID ask in instruction obtains the target middle table inquired, and target middle table includes at least two original fingers
Mark dimension, the inquiry index dimension to reduce the query context of tables of data, then in being instructed by data query, in the target between table
In inquired, by acquisition and the corresponding index dimension numerical value of inquiry index dimension, as target dimension numerical value, i.e. data
The query result of table.Tables of data querying method, device, terminal device and the storage medium, by reduce data query range come
Target middle table is inquired, the efficiency of tables of data inquiry is improved.
Description of the drawings
In order to illustrate the technical solution of the embodiments of the present invention more clearly, below by institute in the description to the embodiment of the present invention
Attached drawing to be used is needed to be briefly described, it should be apparent that, the accompanying drawings in the following description is only some implementations of the present invention
Example, for those of ordinary skill in the art, without having to pay creative labor, can also be according to these attached drawings
Obtain other attached drawings.
Fig. 1 is a flow chart of the tables of data querying method that the embodiment of the present invention 1 provides.
Fig. 2 is a flow chart of the establishment middle table step that the embodiment of the present invention 1 provides.
Fig. 3 is a flow chart of the newer middle table step of acquisition that the embodiment of the present invention 1 provides.
Fig. 4 is a flow chart of the newer target middle table step of acquisition that the embodiment of the present invention 1 provides.
Fig. 5 is a functional block diagram of the tables of data inquiry unit that the embodiment of the present invention 2 provides.
Fig. 6 is a schematic diagram of the terminal device that the embodiment of the present invention 4 provides.
Specific implementation mode
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation describes, it is clear that described embodiments are some of the embodiments of the present invention, instead of all the embodiments.Based on this hair
Embodiment in bright, the every other implementation that those of ordinary skill in the art are obtained without creative efforts
Example, shall fall within the protection scope of the present invention.
Embodiment 1
Fig. 1 shows the flow chart of tables of data querying method in the present embodiment.The tables of data querying method is applied in data pipe
In reason system, for carrying out quick search and analysis to the data stored in data management system.It specifically can be applicable to financial collection
In the mechanism Budget Management System of group, quick search and statistics are carried out for the data to group's different institutions project budget report
Analysis is, it can be achieved that the purpose rapidly and efficiently inquired the data of mechanism project budget report.
As shown in Figure 1, the tables of data querying method includes the following steps：
S10：Data query instruction is obtained, data query instruction includes middle table ID and inquiry index dimension.
Wherein, data query instruction is the instruction for being inquired data.Data query instruction is specifically user
The instruction for inquiring data inputted to data management system by client is connected with data management system for inquiring
System database in data instruction.
Middle table ID is the mark for unique identification middle table, and middle table ID can send out data query instruction
The title or number for the tables of data that user is defined by certain rule, depending on concrete application environment.Wherein, middle table is to being
At least two raw data tables stored in system database are associated the tables of data formed after storage.The raw data table is to deposit
Storage untreated tables of data in system database.
Inquiry index dimension is used to inquire the index dimension with the data in the matched middle tables of middle table ID, index dimension
Degree can be the index dimension in the middle table, can also be the index dimension in raw data table associated with the middle table
Degree, depending on concrete application environment.Index dimension refers to the dimension of the classification indicators for the data being stored in system database.It should
Classification indicators are determined according to the details of data of system data library storage, including but not limited to the time, region,
Location, mechanism and source etc. are used to carry out the data in system database the classification indicators of analyzing processing.Each classification indicators pair
Answer a kind of index dimension, then its index dimension include but not limited to time dimension, region dimension, addressing dimension, mechanism dimension and
Source dimension etc..
In the present embodiment, during the middle table ID with unique mark in being instructed by data query can determine uniquely
Between table；And the inquiry index dimension in being instructed by data query, it may be determined that it will inquire which specific number in middle table
According in order to later use, the data carry out data processing, analysis or other operations.
S20：Based on middle table ID, target middle table corresponding with middle table ID is obtained, target middle table includes at least
Two original index dimensions and index dimension numerical value corresponding with original index dimension.
Target middle table is actually the middle table that the middle table ID in being instructed by data query is uniquely determined.Due to
At least one middle table is stored in system database, each middle table corresponds to a middle table ID, in being instructed according to data query
Middle table ID target middle table is determined from least one middle table.
Wherein, each original index dimension in target middle table is associated with a raw data table.For example, pre- in mechanism
It calculates and stores multiple middle tables in the corresponding system database of management system, each middle table corresponds to annual mechanism budget and summarizes
Table, such as 2015 year mechanism budget summaries and 2016 year mechanism budget summaries, if middle table ID and year in 2015
It is corresponding to spend mechanism budget summary, then it is target middle table.Each middle table is associated with at least one raw data table, such as
A project budget forms, B project budget forms and C project budget forms are associated in 2015 year mechanism budget summaries, and these three are former
Beginning tables of data.
Original index dimension is the index dimension of target middle table, index dimension numerical value corresponding with original index dimension
It is the index dimension numerical value of target middle table.It is to be appreciated that original index dimension and the corresponding index of original index dimension
Dimension numerical value constitutes target middle table.
In the present embodiment, any original index in table between the index dimension numerical value in target middle table refers in the target
The concrete numerical value of dimension.If a target middle table is the project funds summary sheet of A mechanisms, be associated in the project funds summary sheet to
The project funds table (i.e. raw data table) of a few project includes time dimension, region dimension in the project funds summary sheet
Original index dimension, each original index dimension such as degree and project dimension correspond to different index dimension numerical value, at this point, project passes through
Expense summary sheet is associated with at least one project funds table by project dimension, in order to pass through project funds summary sheet correlation inquiry
Relevant data at least one project funds table, it can be achieved that quick search purpose.
S30：Target middle table is inquired based on inquiry index dimension, obtains original index corresponding with inquiry index dimension
The index dimension numerical value of dimension, as target dimension numerical value.
Specifically, based on data query instruct in inquiry index dimension can obtain in target middle table with the inquiry index
The corresponding index dimension numerical value of dimension, to determine target dimension numerical value.That is target dimension numerical value is in response to given data and looks into
Ask the query result that instruction obtains.
It is inquired according to inquiry index dimension in table between in the target, target dimension numerical value can be obtained, that is, use
The query result at family.For example, some target middle table is the budget for storing and calculating each project in different months, if
The yearly budget that index dimension is each project is inquired, then needing the different month budgets of each project in target middle table
Index dimension numerical value carry out summation operation, the numerical value of the yearly budget of each project, that is, target dimension number just can be obtained
Value.In the tables of data querying method that the present embodiment is provided, corresponding target middle table is found according to middle table ID, then in mesh
It is inquired according to index inquiry dimension in mark middle table, obtains target dimension numerical value, that is, query result.The tables of data is looked into
Inquiry method can obtain target dimension numerical value by inquiring middle table, without inquiring all raw data tables, to avoid original
Quantity is excessive in tables of data, to improve efficiency of tabling look-up, accelerates its response time.
In one embodiment, as shown in Fig. 2, before step S10, i.e., obtain data query instruction step it
Before, tables of data querying method further includes the steps that creating middle table, and data query effect is improved will pass through the middle table created
Rate accelerates the response time of data query.Wherein, middle table is created to specifically comprise the following steps：
S11：At least two raw data tables are obtained, each raw data table includes at least one original index dimension.
Wherein, raw data table is tables of data that is unprocessed in system database or simplifying, all raw data tables one
The whole statistical informations for constituting user are acted, raw data table is basic foundation and the source for carrying out data query statistics.
S12：It obtains tables of data and creates instruction, it includes at least one coupling index dimension that tables of data, which creates instruction,.
Wherein, it is the instruction for creating middle table in system database that tables of data, which creates instruction,.Coupling index dimension is
Refer to the existing original index dimension of at least two raw data tables.If initial data Table A includes time dimension and region dimension
Degree, and raw data table B includes existence time in time dimension and project dimension, then initial data Table A and raw data table B
This coupling index dimension of dimension.
S13：At least two raw data tables are associated with based at least one coupling index dimension, obtain middle table, it is each
Middle table is associated with middle table ID.
Wherein, at least one coupling index dimension being all had by least two raw data tables is original by least two
Tables of data is associated, by the Data Integration at least two raw data tables to a new tables of data, that is, in
Between table, the middle table correspond to a middle table ID.For example, raw data table C is used for storing the project budget under all mechanisms, it is original
Tables of data D is used for storing the yearly budget of each mechanism, there is project name and budget amount in the two raw data tables
The two coupling index dimensions can then be based on project name and the two coupling index dimensions of budget amount by raw data table
C is associated with raw data table D, and to obtain middle table, which can be used in storing the year of disparity items under each mechanism
Budget, so that user can be by calling middle table inquiry to obtain corresponding target dimension numerical value, without by least two
A raw data table is inquired, and to accelerate search efficiency, improves query responding time.Each middle table includes a middle table
ID obtains corresponding target middle table in order to subsequently be based on middle table ID inquiries.In the present embodiment, it is based at least one pass
Join index dimension to create and the relevant middle table of at least two raw data tables, to inquire in the middle table, raising data
The efficiency of inquiry accelerates response speed.
In one embodiment, after creating middle table in system database, timing is used to the middle table of acquisition
Update mode updates the data in middle table, so that being latest data to the data obtained when the inquiry of middle table.
Specifically, as shown in figure 3, the tables of data querying method further includes：
S21：Timing more new command is obtained, timing more new command is associated with middle table ID, and timing more new command includes
Triggered time and configuration file.
Wherein, timing more new command is that data in target middle table are executed with the instruction of update operation.Timing update refers to
Order includes triggered time and configuration file.
Triggered time updates the Fixed Time Interval of instruction execution to be pre-set according to actual needs, such as：When triggering
Between be set as 12 hours, system database will obtain primary more new command every 12 hours, be used for the number in target middle table
It is updated according to being timed.
Configuration file is configuration file in system database, which is used for trigger data more new procedures, such as：It can
Configuration file is generated to use the bean components of java project frames.Specifically, configuration file has and date update program
Corresponding configuration file, the date update program can be timed triggering according to periodically more new command, to realize to data certainly
Dynamic update.
S22：If system time is consistent with the triggered time, date update program corresponding with configuration file is triggered, it is right
Data in the corresponding middle tables of middle table ID are updated, and are obtained first and are updated the data.
The included letter of system database can may be used with the auto acquisition system time in system database in present embodiment
Number obtains system time, such as：In a specific embodiment, getdate () function of SQL Server databases can be used
To obtain the current time in system.
If detecting, the current time in system is consistent with the triggered time, triggers data update journey corresponding with configuration file
Sequence inquires data in raw data table by the date update program, if the data in raw data table and last time
Query result is different, then changed data in the raw data table and middle table corresponding part is carried out comparison check, if
Inspection result is the presence of difference, then passes through the corresponding date update program of configuration file and compare raw data table and intermediate table search
Go out inconsistent part, obtains first and update the data.
For example, a certain middle table includes first project funds table and second project funds table, the triggered time is 12 hours, in system
When current time is the January in 2018 of 12 noon on the 15th, the current time in system is consistent with the triggered time, at this point, data are more
New procedures are triggered, and carry out inquiry discovery to first project funds table and second project funds table, first project funds table is looked into the last time
It askes result and there is difference, difference is that plus item mesh funds table has increased one 20000 yuan of fee of material expenditure newly, and then to centre
First project material expense expenditure part in table is compared with fee of material expenditure part in this first project funds table, finds to differ
It causes, the first project material expense expenditure part of middle table is updated by date update program, first is obtained and updates the data, the
One updates the data 20000 yuan of fee of materials expenditure to be increased newly in first project funds table.
S23：It is updated the data based on first, obtains newer middle table.
System database updates the data update middle table based on first, obtains updated middle table, to realize to update
Data portion is fast extracted, and the speed of data update is optimized, and improves the efficiency of database maintenance.
In the present embodiment, after system database creates middle table, to system database transmission timing more new command, with
Make system database at the triggered time during the current time in system is timing more new command, in triggering and timing more new command
The corresponding date update program of configuration file, a pair middle table corresponding with middle table ID carry out data update, fixed to realize
When middle table is updated, and improve the accuracy of result when inquiring middle table.
In a specific embodiment, as shown in figure 4, the step of obtaining target middle table corresponding with middle table ID
Later, which further includes following steps：
S31：Data update instruction is obtained, data update instruction is associated with middle table ID, and data update instruction includes
Configuration file.
Data update instruction and the timing more new command in step S21 of the step contribute to the data of middle table into
Row update operational order.It is to be appreciated that timing more new command is according to the time interval (i.e. triggered time) being arranged in instruction
More new command is executed, is that system database is automatically brought into operation newer process.And the limitation without time interval in data update instruction,
It is that data of the user according to actual needs in pair middle table corresponding with middle table ID carry out real-time update, user can be met
The demand for inquiring latest data, to improve the accuracy of the data inquired.
S32：Triggering date update program corresponding with configuration file, obtains among target corresponding with middle table ID
Second updating the data between current time in system and renewal time last time in table.
Wherein, triggering date update program corresponding with configuration file is to carry out triggering number in real time according to actual needs
According to more new procedures.It is updated the data by trigger data, to obtain the second update between current time and last renewal time
Data, specific method is with step S22, no longer burdensome herein to avoid repeating.
S33：It is updated the data based on second, obtains newer target middle table.
List acquirement method is identical as the method in step S23 among the newer target, but among the target got
The newer data of table have bigger difference, and it is the data obtained at set time intervals that first in S23, which updates the data, also
The data of recent renewal, and second in this step update the data be current time real-time update data, from data update
It is seen in degree, the data of this step are more more real-time than the data of step S23, more can guarantee the target dimension numerical value that inquiry is got
Accuracy.
In the present embodiment, after system database obtains target middle table, refer to the update of system database transmission data
It enables, a pair middle table corresponding with middle table ID carries out data update, to realize the data in real-time update middle table, and ensures
The accuracy and timeliness of result when inquiring target middle table.
In one embodiment, after step S40, which further includes following steps：If target is tieed up
Number of degrees value then generates abnormal prompt information not within the scope of criterion.
Wherein, criterion range is the threshold range that target dimension numerical value is arranged, which can be
Mathematical logic relationship can also be that user is independently arranged according to data monitoring demand.For example, project appropriation budget is generally big
In project fee settlement, there are a criterion ranges therebetween.Abnormal prompt information is for prompting user to exception
The prompting message that information is optimized.For example, when project fee settlement is more than the project budget through time-consuming, the page can pop up abnormal carry
Show information.For another example some project current year is when monthly estimate and upper monthly estimate difference be 500,000, and project management department is pre- to any two moon
It is that the bimestrial project budget gap of arbitrary current year is less than 400,000 to calculate gap and set critical field, it is clear that the target dimension number
Value can generate abnormal prompt information not within the scope of criterion.
In the present embodiment, it after getting target dimension numerical value, is based on judging the target dimension numerical value whether in index
In critical field, if not within the scope of criterion, abnormal prompt information is generated, to facilitate user to check simultaneously data
Modification carries out real-time effective monitoring to data, ensures the accuracy of data information.
The tables of data querying method that the present embodiment is provided, the middle table ID acquisitions in being instructed by data query are looked into
The target middle table of inquiry, and target middle table includes at least two original index dimensions, to reduce the inquiry model of tables of data
Enclose, then the inquiry index dimension in being instructed by data query, in the target between inquired in table, will get and inquiry
The corresponding index dimension numerical value of index dimension, as target dimension numerical value, the i.e. query result of tables of data.The tables of data is inquired
Method inquires target middle table by reducing data query range, improves the efficiency of tables of data inquiry.
It should be understood that the size of the serial number of each step is not meant that the order of the execution order in above-described embodiment, each process
Execution sequence should be determined by its function and internal logic, the implementation process without coping with the embodiment of the present invention constitutes any limit
It is fixed.
Embodiment 2
Fig. 5 shows the functional block diagram with the one-to-one tables of data inquiry unit of tables of data querying method in embodiment 1.Such as
Shown in Fig. 5, which includes data query instruction acquisition module 51, target middle table acquisition module 52 and index
Dimension numerical value acquisition module 53.Wherein, data query instruction acquisition module 51, target middle table acquisition module 52 and index dimension
The realization function of numerical value acquisition module 53 step corresponding with tables of data querying method in embodiment 1 corresponds, to avoid going to live in the household of one's in-laws on getting married
It states, the present embodiment is not described in detail one by one.
Data query instruction acquisition module 51, for obtaining data query instruction, data query instruction includes middle table ID
With inquiry index dimension.
Target middle table acquisition module 52 is obtained for being based on middle table ID among target corresponding with middle table ID
Table, target middle table include at least two original index dimensions and index dimension numerical value corresponding with original index dimension.
Index dimension numerical value acquisition module 53, for inquiring target middle table, acquisition and inquiry based on inquiry index dimension
The index dimension numerical value of the corresponding original index dimension of index dimension, as target dimension numerical value.
Preferably, tables of data inquiry unit further includes middle table creation module 54, for creating middle table.
Middle table creation module 54 includes raw data table acquiring unit 541,542 and of tables of data establishment instruction acquisition unit
Middle table acquiring unit 543.
Raw data table acquiring unit 541, for obtaining at least two raw data tables, each raw data table includes extremely
A few original index dimension.
Tables of data creates instruction acquisition unit 542, includes at least one coupling index for obtaining tables of data to create instruction
Dimension.
Middle table acquiring unit 543, for being closed at least two raw data tables based at least one coupling index dimension
Connection, obtains middle table, and each middle table is associated with middle table ID.
Preferably, tables of data inquiry unit further includes middle table timing update module 55, middle table timing update module 55
Acquiring unit 552 and newer middle table acquiring unit 553 are updated the data including timing update instruction acquisition unit 551, first.
Timing update instruction acquisition unit 551, for obtaining timing more new command, timing more new command and middle table ID phases
Association, and timing more new command includes triggered time and configuration file.
First updates the data acquiring unit 552, if when current for system when the triggered time, triggering is opposite with configuration file
The date update program answered is updated the data in the corresponding middle table of intermediate table id, obtains first and updates the data.
Newer middle table acquiring unit 553 updates the data for being based on first, obtains newer middle table.
Preferably, tables of data inquiry unit further includes data update module 56, and data update module 56 includes data update
Instruction acquisition unit 561, second update the data acquiring unit 562 and more fresh target middle table acquiring unit 563.
Data update instruction acquisition unit 561, for obtaining data update instruction, data update instruction and middle table ID phases
Association, and data update instruction includes configuration file.
Second updates the data acquiring unit 562, for triggering date update program corresponding with configuration file, obtains mesh
Second updating the data between current time in system and renewal time last time in mark middle table.
More fresh target middle table acquiring unit 563 is updated the data for being based on second, obtains newer target middle table.
Preferably, data query instruction further includes criterion range corresponding with inquiry index dimension.
Tables of data inquiry unit further includes abnormal prompt information generating module 57, is used in target dimension numerical value not in index
When in critical field, abnormal prompt information is generated.
Embodiment 3
The present embodiment provides a computer readable storage medium, computer journey is stored on the computer readable storage medium
Sequence realizes tables of data querying method in embodiment 1, to avoid repeating, here no longer when the computer program is executed by processor
It repeats.Alternatively, realizing in embodiment 2 each module/unit in tables of data inquiry unit when the computer program is executed by processor
Function, to avoid repeating, which is not described herein again.
Embodiment 4
Fig. 6 is the schematic diagram for the terminal device that one embodiment of the invention provides.As shown in fig. 6, the terminal of the embodiment is set
Standby 60 include processor 61, memory 62 and are stored in the computer program that can be run in memory 62 and on processor 61
63.The step of processor 61 realizes tables of data querying method in embodiment 1 when executing computer program 63, for example, it is shown in FIG. 1
Step S10 to S30.Alternatively, processor 61 realizes each mould of tables of data inquiry unit in embodiment 2 when executing computer program 63
The function of block/unit, such as module 51 shown in Fig. 5 is to the function of module 53.
Illustratively, computer program 63 can be divided into one or more module/units, one or more mould
Block/unit is stored in memory 62, and is executed by processor 61, to complete the present invention.One or more module/units can
To be the series of computation machine program instruction section that can complete specific function, the instruction segment is for describing computer program 63 at end
Implementation procedure in end equipment 60.It is obtained for example, computer program 63 can be divided into data query instruction as shown in Figure 5
Module 51, target middle table acquisition module 52 and index dimension numerical value acquisition module 53, to avoid stating, do not repeat one by one herein
Each module realizes function.
Terminal device 60 can be the computing devices such as desktop PC, notebook, palm PC and cloud server.Eventually
End equipment may include, but be not limited only to, processor 61, memory 62.It will be understood by those skilled in the art that Fig. 6 is only eventually
The example of end equipment 60 does not constitute the restriction to terminal device 60, may include components more more or fewer than diagram, or
Combine certain components or different components, for example, terminal device can also include input-output equipment, network access equipment,
Bus etc..
Alleged processor 61 can be central processing unit (Central Processing Unit, CPU), can also be
Other general processors, digital signal processor (Digital Signal Processor, DSP), application-specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor can also be any conventional processor
Deng.
Memory 62 can be the internal storage unit of terminal device 60, such as the hard disk or memory of terminal device 60.It deposits
Reservoir 62 can also be the plug-in type hard disk being equipped on the External memory equipment of terminal device 60, such as terminal device 60, intelligence
Storage card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card, flash card (Flash Card)
Deng.Further, memory 62 can also both include terminal device 60 internal storage unit and also including External memory equipment.It deposits
Reservoir 62 is used to store other programs and data needed for the computer program and terminal device 60.Memory 62 can be with
For temporarily storing the data that has exported or will export.It is apparent to those skilled in the art that
It for convenience of description and succinctly, can only with the division progress of above-mentioned each functional unit, module for example, in practical application
As needed to complete above-mentioned function distribution by different functional units, module, i.e., the internal structure of described device is drawn
It is divided into different functional units or module, to complete all or part of the functions described above.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, it can also
It is that each unit physically exists alone, it can also be during two or more units be integrated in one unit.Above-mentioned integrated list
The form that hardware had both may be used in member is realized, can also be realized in the form of SFU software functional unit.
If the integrated module/unit be realized in the form of SFU software functional unit and as independent product sale or
In use, can be stored in a computer read/write memory medium.Based on this understanding, the present invention realizes above-mentioned implementation
All or part of flow in example method, can also instruct relevant hardware to complete, the meter by computer program
Calculation machine program can be stored in a computer readable storage medium, the computer program when being executed by processor, it can be achieved that on
The step of stating each embodiment of the method.Wherein, the computer program includes computer program code, the computer program generation
Code can be source code form, object identification code form, executable file or certain intermediate forms etc..The computer-readable medium
May include：Any entity or device, recording medium, USB flash disk, mobile hard disk, magnetic of the computer program code can be carried
Dish, CD, computer storage, read-only memory (Read-Only Memory, ROM), random access memory (Random
Access Memory, RAM), electric carrier signal, telecommunication signal and software distribution medium etc..It should be noted that the meter
The content that calculation machine readable medium includes can carry out increase and decrease appropriate according to legislation in jurisdiction and the requirement of patent practice,
Such as in certain jurisdictions, according to legislation and patent practice, computer-readable medium is including being not electric carrier signal and electricity
Believe signal.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations；Although with reference to aforementioned reality
Applying example, invention is explained in detail, it will be understood by those of ordinary skill in the art that：It still can be to aforementioned each
Technical solution recorded in embodiment is modified or equivalent replacement of some of the technical features；And these are changed
Or replace, the spirit and scope for various embodiments of the present invention technical solution that it does not separate the essence of the corresponding technical solution should all
It is included within protection scope of the present invention.
Claims (10)
1. a kind of tables of data querying method, which is characterized in that including：
Data query instruction is obtained, the data query instruction includes middle table ID and inquiry index dimension；
Based on the middle table ID, target middle table corresponding with the middle table ID is obtained, the target middle table includes
At least two original index dimensions and index dimension numerical value corresponding with the original index dimension；
The target middle table is inquired based on the inquiry index dimension, is obtained corresponding original with the inquiry index dimension
The index dimension numerical value of index dimension, as target dimension numerical value.
2. tables of data querying method as described in claim 1, which is characterized in that in the step of acquisition data query instructs
Before, the tables of data querying method further includes：Create middle table；
The establishment middle table, including：
At least two raw data tables are obtained, each raw data table includes at least one original index dimension；
It obtains tables of data and creates instruction, it includes at least one coupling index dimension that tables of data, which creates instruction,；
At least two raw data tables are associated with based at least one coupling index dimension, obtain middle table, each centre
Table is associated with middle table ID.
3. tables of data querying method as claimed in claim 2, which is characterized in that after the establishment middle table the step of,
The tables of data querying method further includes：
Timing more new command is obtained, the timing more new command is associated with the middle table ID, and the timing more new command
Including triggered time and configuration file；
If the current time in system is the triggered time, date update program corresponding with the configuration file is triggered, it is right
Data in the corresponding middle table of the middle table ID are updated, and are obtained first and are updated the data；
It is updated the data based on described first, obtains newer middle table.
4. tables of data querying method as described in claim 1, which is characterized in that opposite with the middle table ID in the acquisition
After the step of target middle table answered, the tables of data querying method further includes：
Data update instruction is obtained, the data update instruction is associated with the middle table ID, and the data update instructs
Including configuration file；
Triggering date update program corresponding with the configuration file, obtains the target corresponding with the middle table ID
Second updating the data between current time in system and renewal time last time in middle table；
It is updated the data based on described second, obtains newer target middle table.
5. tables of data querying method as described in claim 1, which is characterized in that data query instruction further include with it is described
Inquire the corresponding criterion range of index dimension；
In the index dimension numerical value of acquisition original index dimension corresponding with the inquiry index dimension, tieed up as target
After the step of number of degrees value, the tables of data querying method further includes：
If the target dimension numerical value generates abnormal prompt information not within the scope of the criterion.
6. a kind of tables of data inquiry unit, which is characterized in that including：
Data query instruction acquisition module, for obtaining data query instruction, data query instruction include middle table ID with
Inquire index dimension；
Target middle table acquisition module is obtained for being based on the middle table ID in target corresponding with the middle table ID
Between table, the target middle table includes that at least two original index dimensions and index corresponding with the original index dimension are tieed up
Number of degrees value；
Index dimension numerical value acquisition module, for inquiring the target middle table, acquisition and institute based on the inquiry index dimension
The index dimension numerical value for stating the inquiry corresponding original index dimension of index dimension, as target dimension numerical value.
7. tables of data inquiry unit as claimed in claim 6, which is characterized in that the tables of data inquiry unit further includes centre
Table creation module, for creating middle table；
The middle table creation module, including：
Raw data table acquiring unit, for obtaining at least two raw data tables, each raw data table includes at least one
Original index dimension；
Tables of data creates instruction acquisition unit, includes at least one coupling index dimension for obtaining tables of data to create instruction；
Middle table acquiring unit, at least two raw data tables to be associated with based at least one coupling index dimension,
Middle table is obtained, each middle table is associated with middle table ID.
8. tables of data inquiry unit as claimed in claim 7, which is characterized in that the tables of data inquiry unit further includes centre
Table timing update module, the middle table timing update module include：
Timing update instruction acquisition unit, for obtaining timing more new command, the timing more new command and the middle table ID
It is associated, and the timing more new command includes triggered time and configuration file；
First updates the data acquiring unit, if be the triggered time for the current time in system, triggering and configuration text
The corresponding date update program of part is updated the data in the corresponding middle tables of the middle table ID, obtains first more
New data；
Newer middle table acquiring unit updates the data for being based on described first, obtains newer middle table.
9. a kind of terminal device, including memory, processor and it is stored in the memory and can be on the processor
The computer program of operation, which is characterized in that the processor realizes such as claim 1 to 5 when executing the computer program
The step of any one tables of data querying method.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, feature to exist
In the step of realization tables of data querying method as described in any one of claim 1 to 5 when the computer program is executed by processor
Suddenly.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810121968.8A CN108415964A (en) | 2018-02-07 | 2018-02-07 | Tables of data querying method, device, terminal device and storage medium |
| PCT/CN2018/081503 WO2019153471A1 (en) | 2018-02-07 | 2018-04-02 | Data table query method and apparatus, terminal device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810121968.8A CN108415964A (en) | 2018-02-07 | 2018-02-07 | Tables of data querying method, device, terminal device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108415964A true CN108415964A (en) | 2018-08-17 |
Family
ID=63127967
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810121968.8A Pending CN108415964A (en) | 2018-02-07 | 2018-02-07 | Tables of data querying method, device, terminal device and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN108415964A (en) |
| WO (1) | WO2019153471A1 (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109241140A (en) * | 2018-09-03 | 2019-01-18 | 北京旷视科技有限公司 | Data statistical approach, device and electronic equipment |
| CN109254966A (en) * | 2018-08-23 | 2019-01-22 | 平安科技（深圳）有限公司 | Tables of data querying method, device, computer equipment and storage medium |
| CN109271402A (en) * | 2018-09-04 | 2019-01-25 | 拉扎斯网络科技（上海）有限公司 | Data managing method, device, equipment and computer storage medium |
| CN110083597A (en) * | 2019-03-16 | 2019-08-02 | 平安普惠企业管理有限公司 | Order querying method, device, computer equipment and storage medium |
| CN110362554A (en) * | 2019-06-24 | 2019-10-22 | 平安科技（深圳）有限公司 | Setting method, device, equipment and the computer readable storage medium of timer |
| CN110413634A (en) * | 2019-06-27 | 2019-11-05 | 北京奇艺世纪科技有限公司 | Data query method, system, device and computer readable storage medium |
| CN110928903A (en) * | 2018-08-31 | 2020-03-27 | 阿里巴巴集团控股有限公司 | Data extraction method and device, equipment and storage medium |
| CN111723075A (en) * | 2020-06-11 | 2020-09-29 | 合肥阳光新能源科技有限公司 | Method, system and medium for constructing, retrieving and storing real-time database |
| WO2024021581A1 (en) * | 2022-07-28 | 2024-02-01 | 中兴通讯股份有限公司 | Metric query method and system, and electronic device and storage medium |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111125266B (en) * | 2019-12-24 | 2024-01-12 | 建信金融科技有限责任公司 | Data processing method, device, equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4483034B2 (en) * | 2000-06-06 | 2010-06-16 | 株式会社日立製作所 | Heterogeneous data source integrated access method |
| CN102937980A (en) * | 2012-10-18 | 2013-02-20 | 亿赞普(北京)科技有限公司 | Method for inquiring data of cluster database |
| CN106919566A (en) * | 2015-12-24 | 2017-07-04 | 航天信息股份有限公司 | A kind of query statistic method and system based on mass data |
| CN107341235A (en) * | 2017-07-04 | 2017-11-10 | 北京京东尚科信息技术有限公司 | Report form inquiring method, device, medium and electronic equipment |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104965886B (en) * | 2015-06-16 | 2019-01-29 | 广州市勤思网络科技有限公司 | Data dimension processing method |
| CN105354669A (en) * | 2015-10-30 | 2016-02-24 | 歌尔声学股份有限公司 | Multi-sector project configuration based field information generating method and system |
| CN106528885A (en) * | 2016-12-16 | 2017-03-22 | 苏州市环亚数据技术有限公司 | Processing method and device of medical business data |
| CN106844320B (en) * | 2016-12-27 | 2020-09-15 | 税友软件集团股份有限公司 | Financial statement integration method and equipment |
| CN106897386B (en) * | 2017-01-23 | 2019-10-29 | 武汉奇米网络科技有限公司 | A kind of big data multidimensional analysis method and system |
-
2018
- 2018-02-07 CN CN201810121968.8A patent/CN108415964A/en active Pending
- 2018-04-02 WO PCT/CN2018/081503 patent/WO2019153471A1/en active Application Filing
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4483034B2 (en) * | 2000-06-06 | 2010-06-16 | 株式会社日立製作所 | Heterogeneous data source integrated access method |
| CN102937980A (en) * | 2012-10-18 | 2013-02-20 | 亿赞普(北京)科技有限公司 | Method for inquiring data of cluster database |
| CN106919566A (en) * | 2015-12-24 | 2017-07-04 | 航天信息股份有限公司 | A kind of query statistic method and system based on mass data |
| CN107341235A (en) * | 2017-07-04 | 2017-11-10 | 北京京东尚科信息技术有限公司 | Report form inquiring method, device, medium and electronic equipment |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109254966A (en) * | 2018-08-23 | 2019-01-22 | 平安科技（深圳）有限公司 | Tables of data querying method, device, computer equipment and storage medium |
| CN110928903A (en) * | 2018-08-31 | 2020-03-27 | 阿里巴巴集团控股有限公司 | Data extraction method and device, equipment and storage medium |
| CN110928903B (en) * | 2018-08-31 | 2024-03-15 | 阿里巴巴集团控股有限公司 | Data extraction method and device, equipment and storage medium |
| CN109241140A (en) * | 2018-09-03 | 2019-01-18 | 北京旷视科技有限公司 | Data statistical approach, device and electronic equipment |
| CN109271402A (en) * | 2018-09-04 | 2019-01-25 | 拉扎斯网络科技（上海）有限公司 | Data managing method, device, equipment and computer storage medium |
| CN110083597A (en) * | 2019-03-16 | 2019-08-02 | 平安普惠企业管理有限公司 | Order querying method, device, computer equipment and storage medium |
| CN110362554A (en) * | 2019-06-24 | 2019-10-22 | 平安科技（深圳）有限公司 | Setting method, device, equipment and the computer readable storage medium of timer |
| CN110362554B (en) * | 2019-06-24 | 2024-05-03 | 平安科技（深圳）有限公司 | Method, device, equipment and computer readable storage medium for setting timer |
| CN110413634A (en) * | 2019-06-27 | 2019-11-05 | 北京奇艺世纪科技有限公司 | Data query method, system, device and computer readable storage medium |
| CN110413634B (en) * | 2019-06-27 | 2022-03-29 | 北京奇艺世纪科技有限公司 | Data query method, system, device and computer readable storage medium |
| CN111723075A (en) * | 2020-06-11 | 2020-09-29 | 合肥阳光新能源科技有限公司 | Method, system and medium for constructing, retrieving and storing real-time database |
| CN111723075B (en) * | 2020-06-11 | 2023-05-30 | 阳光新能源开发股份有限公司 | Method, system and medium for constructing, searching and storing data of real-time database |
| WO2024021581A1 (en) * | 2022-07-28 | 2024-02-01 | 中兴通讯股份有限公司 | Metric query method and system, and electronic device and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2019153471A1 (en) | 2019-08-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108415964A (en) | Tables of data querying method, device, terminal device and storage medium | |
| CN108536761B (en) | Report data query method and server | |
| US10948526B2 (en) | Non-parametric statistical behavioral identification ecosystem for electricity fraud detection | |
| US10754877B2 (en) | System and method for providing big data analytics on dynamically-changing data models | |
| US10956422B2 (en) | Integrating event processing with map-reduce | |
| US10528970B2 (en) | Systems, methods, and devices for pipelined processing of online advertising performance data | |
| CN104268428B (en) | A kind of visual configuration method calculated for index | |
| Bordin et al. | Dspbench: A suite of benchmark applications for distributed data stream processing systems | |
| CN111046237B (en) | User behavior data processing method and device, electronic equipment and readable medium | |
| CN109144997A (en) | Data correlation method, device and storage medium | |
| CN109961198B (en) | Associated information generation method and device | |
| US20200074509A1 (en) | Business data promotion method, device, terminal and computer-readable storage medium | |
| US20170279970A1 (en) | Dynamically generating an aggregation routine | |
| US20170083566A1 (en) | Partitioning advisor for online transaction processing workloads | |
| Gupta et al. | Big data energy management, analytics and visualization for residential areas | |
| US10963963B2 (en) | Rule based hierarchical configuration | |
| CN108573348B (en) | Financial index distributed computing method and system | |
| CN112749863A (en) | Keyword price adjusting method and device and electronic equipment | |
| CN104899278A (en) | Method and apparatus for generating data operation logs of Hbase database | |
| CN114416891B (en) | Method, system, apparatus and medium for data processing in a knowledge graph | |
| CN106156040A (en) | multi-dimensional data management method and device | |
| CN108182204A (en) | The processing method and processing device of data query based on house prosperity transaction multi-dimensional data | |
| CN109299089A (en) | The calculating and storage method and calculating of a kind of label data of drawing a portrait and storage system | |
| CN108537577B (en) | Data validity query method and device, storage medium and server | |
| CN110851758A (en) | Webpage visitor number statistical method and device |
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: 20180817 |