CN111090669A - Data query method and device based on space-time collision - Google Patents
Data query method and device based on space-time collision Download PDFInfo
- Publication number
- CN111090669A CN111090669A CN201911299900.XA CN201911299900A CN111090669A CN 111090669 A CN111090669 A CN 111090669A CN 201911299900 A CN201911299900 A CN 201911299900A CN 111090669 A CN111090669 A CN 111090669A
- Authority
- CN
- China
- Prior art keywords
- query
- result
- collision
- space
- time
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 75
- 238000012545 processing Methods 0.000 claims abstract description 46
- 238000012216 screening Methods 0.000 claims description 22
- 238000004590 computer program Methods 0.000 claims description 14
- 230000008569 process Effects 0.000 description 24
- 238000010586 diagram Methods 0.000 description 10
- 230000006870 function Effects 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 230000010354 integration Effects 0.000 description 3
- 238000000354 decomposition reaction Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 239000008186 active pharmaceutical agent Substances 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000002123 temporal effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2425—Iterative querying; Query formulation based on the results of a preceding query
Abstract
The embodiment of the application provides a data query method and a device based on space-time collision, which relate to the technical field of data processing, and the method comprises the following steps: receiving a spatio-temporal query request; splicing the time-space query request to obtain a structured query statement; performing space-time collision processing according to the structured query statement and a pre-constructed database to obtain a space-time collision result; and generating a data query result according to the space-time collision result. Therefore, by the implementation of the implementation mode, the data query result can be accurately obtained, and the query efficiency is further improved.
Description
Technical Field
The application relates to the technical field of data processing, in particular to a data query method and device based on space-time collision.
Background
The space-time big data is big data which describes a physical world and a virtual world by taking space-time as a reference, and has a time dimension and a space dimension, most of data in the real world are related to geographical positions, and with the rapid development of the internet technology, the required information is screened from a large amount of space-time data more and more important. The existing data query method generally performs simple time and space matching according to query conditions, and then obtains a query result. However, in practice, the existing data query method has low accuracy and low query efficiency.
Disclosure of Invention
The embodiment of the application aims to provide a data query method and device based on space-time collision, which can accurately obtain data query results and further improve query efficiency.
The embodiment of the application provides a data query method based on spatiotemporal collision in a first aspect, which comprises the following steps:
receiving a spatio-temporal query request;
splicing the space-time query request to obtain a structured query statement;
performing space-time collision processing according to the structured query statement and a pre-constructed database to obtain a space-time collision result;
and generating a data query result according to the space-time collision result.
In the implementation process, the method can preferentially receive the time-space query request, and then splice the received time-space query request to obtain a structured query statement; after the structured query data are obtained, performing space-time collision processing in a pre-constructed database according to the structured query statement to obtain a space-time collision result; and finally, generating a data query result according to the space-time collision result so as to complete the query of the data. Therefore, by implementing the implementation mode, the structured processing can be carried out according to the time-space query request, so that the data query can be more standardized, and the accuracy of the data query is improved; and accurate space-time collision results can be obtained through space-time collision processing, so that data query results can be accurately obtained according to the space-time collision results, and the overall efficiency of data query is improved.
Further, the performing spatiotemporal collision processing according to the structured query statement and a pre-constructed database to obtain a spatiotemporal collision result includes:
acquiring a time query condition, a space query condition and other query condition sets from the structured query statement according to a preset query condition classification rule;
performing data query in a pre-constructed database according to the time query condition to obtain a first result set; performing data query in the database according to the space query condition to obtain a second result set;
when the other query condition sets are not empty sets, performing data query in the database according to the other query condition sets to obtain other result sets;
and performing space-time collision processing on the first result set, the second result set and the other result sets to obtain space-time collision results.
In the implementation process, in the process of performing space-time collision, the method can firstly acquire time query conditions, space query conditions and other query condition sets included in the structured query statement according to preset query condition classification rules; then, performing data query in a pre-constructed database according to the time query condition to obtain a first result set corresponding to the time element, and performing data query in the database according to the space query condition to obtain a second result set corresponding to the space element; after the first result set and the second result set are obtained, whether other query conditions are empty sets or not is confirmed, and when the other query condition sets are not empty sets, data query is carried out in the database according to the other query condition sets to obtain other result sets; and finally, performing space-time collision processing according to the first result set, the second result set and other result sets to obtain a space-time collision result. Therefore, by implementing the implementation mode, the structured query statement can be further subjected to information decomposition, and the information decomposition of the structured query statement can be more stable and effective by using the preset query condition classification rule, so that the precision of data query is improved; in addition, by implementing the implementation mode, multi-aspect query can be carried out according to time, space and other three dimensions, and space-time collision results of the three dimensions are obtained, so that the accuracy of data query can be effectively improved, and the speed of data query is ensured.
Further, the performing spatiotemporal collision processing on the first result set, the second result set and the other result sets to obtain spatiotemporal collision results includes:
obtaining a result set screening rule;
selecting at least one result set from the other result sets according to the result set screening rule to serve as a third result set;
performing intersection solving processing on the first result set, the second result set and the third result set to obtain at least one intersection solving result;
and summarizing the at least one intersection result to obtain a space-time collision result.
In the implementation process, the method can preferentially acquire the result set screening rule in the process of performing space-time collision processing according to the first result set, the second result set and other result sets to obtain space-time collision results; then selecting at least one result set from other result sets according to the result set screening rule to serve as a third result set; the method is prompted to carry out intersection solving processing on the first result set, the second result set and the third result set to obtain at least one intersection solving result; wherein the at least one intersection result is a result set obtained by intersecting at least one result included in the first result set, at least one result included in the second result set, and at least one result included in the third result set, and is referred to as at least one intersection result; and finally, summarizing the at least one intersection result to obtain a space-time collision result. Therefore, by implementing the implementation mode, re-screening can be performed according to the result sets in other result sets, and the intersection result which is more in line with the query scene is obtained, so that the acquisition precision of the space-time collision result can be effectively improved.
Further, before the receiving a data query request, the method further comprises:
acquiring original query data for constructing the database;
generating a data table comprising preset fields according to the original query data;
creating index information according to the data table;
and constructing a database according to the index information and the data table.
In the implementation process, before receiving a data query request, the method can preferentially acquire original query data for constructing the database, and then generate a data table comprising preset fields according to the original query data; so that the method can create index information from the data table; and further, the index information and the data table can be promoted to establish a database so as to facilitate data query. Therefore, by implementing the implementation mode, the database for query can be established before data query is carried out, so that the real-time performance of the database is improved, and the precision of the data query is improved.
Further, the preset field comprises one or more of an identity identification field, a name identification field, a point position identification field, a time field, a license plate identification field and a license plate type field.
The index information comprises one or more of a time field index, an identity identification field index and a point location identification field index.
In the implementation process, the preset field comprises one or more of an identity identification field, a name identification field, a point position identification field, a time field, a license plate identification field and a license plate type field, and therefore the preset field can define an application environment of data query, and query precision of the data query is guaranteed. In addition, one or more of time field index, identity identification field index and point location identification field index included in the index information can ensure the effectiveness of the index information, thereby improving the precision and efficiency in the data query process.
A second aspect of the embodiments of the present application provides a spatiotemporal collision-based data query apparatus, where the spatiotemporal collision-based data query apparatus includes:
a receiving unit for receiving a spatio-temporal query request;
the splicing unit is used for splicing the space-time query request to obtain a structured query statement;
the collision unit is used for performing space-time collision processing according to the structured query statement and a pre-constructed database to obtain a space-time collision result;
and the generating unit is used for generating a data query result according to the space-time collision result.
In the implementation process, the data query device can realize the operations of receiving a space-time query request, constructing a structured statement, processing a space-time collision result, generating a data query result and the like through the mutual cooperation and the joint work of a plurality of units, so that the integration of data query is completed. By implementing the implementation mode, the data query device can autonomously complete a series of data query processes, thereby greatly simplifying the data query process and improving the convenience for data query; in addition, the data query device can also greatly improve the accuracy and efficiency of data query through the cooperative work of a plurality of units.
Further, the collision cell includes:
the determining subunit is used for acquiring a time query condition, a space query condition and other query condition sets from the structured query statement according to a preset query condition classification rule;
the query subunit is used for performing data query in a pre-constructed database according to the time query condition to obtain a first result set; performing data query in the database according to the space query condition to obtain a second result set; when the other query condition sets are not empty sets, performing data query in the database according to the other query condition sets to obtain other result sets;
and the collision subunit is used for performing space-time collision processing on the first result set, the second result set and the other result sets to obtain space-time collision results.
In the implementation process, the determining subunit can determine a time query condition, a space query condition and other query condition sets, and prompt the querying subunit to perform data query in the database according to the time query condition, the space query condition and other query condition sets to obtain a first result set, a second result set and other result sets, so that the collision subunit performs collision processing on the first result set, the second result set and other result sets to obtain space-time collision results. By implementing the implementation mode, the data query device can further complete the process of time-space collision through the subunits, so that the acquisition precision of the time-space collision result is improved, and the data query precision can be improved.
Further, the collision sub-unit includes:
the acquisition module is used for acquiring a result set screening rule;
the screening module is used for selecting at least one result set from the other result sets according to the result set screening rule to serve as a third result set;
the intersection solving module is used for solving intersection of the first result set, the second result set and the third result set to obtain at least one intersection solving result;
and the summarizing module is used for summarizing the at least one intersection result to obtain a space-time collision result.
In the implementation process, the collision subunit may obtain the intersection result through a plurality of modules, and then summarize according to the intersection result to obtain the collision result of the space-time collision. It can be seen that, by implementing this embodiment, the collision result is obtained based on a large number of possible combinations (i.e., intersection results), so that objectivity of the collision result can be ensured, and the accuracy of obtaining the spatio-temporal collision result can be improved.
A third aspect of the embodiments of the present application provides an electronic device, including a memory and a processor, where the memory is used to store a computer program, and the processor runs the computer program to make the electronic device execute the spatiotemporal collision-based data query method according to any one of the first aspect of the embodiments of the present application.
A fourth aspect of the embodiments of the present application provides a computer-readable storage medium, which stores computer program instructions, and when the computer program instructions are read and executed by a processor, the method for querying data based on spatiotemporal collision according to any one of the first aspect of the embodiments of the present application is performed.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are required to be used in the embodiments of the present application will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and that those skilled in the art can also obtain other related drawings based on the drawings without inventive efforts.
FIG. 1 is a schematic flow chart illustrating a spatiotemporal collision-based data query method according to an embodiment of the present disclosure;
FIG. 2 is a schematic flow chart illustrating another spatio-temporal collision-based data query method according to an embodiment of the present application;
FIG. 3 is a schematic structural diagram of a spatiotemporal collision-based data query apparatus according to an embodiment of the present application;
FIG. 4 is a schematic structural diagram of another spatiotemporal collision-based data query device according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be described below with reference to the drawings in the embodiments of the present application.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures. Meanwhile, in the description of the present application, the terms "first", "second", and the like are used only for distinguishing the description, and are not to be construed as indicating or implying relative importance.
Example 1
Referring to fig. 1, fig. 1 is a schematic flowchart illustrating a data query method based on spatiotemporal collision according to an embodiment of the present application. The method can be applied to a data query scene based on multiple dimensions such as time, space and the like, and particularly can be used when high-precision spatio-temporal data is queried. The data query method based on the spatiotemporal collision comprises the following steps:
s101, receiving a space-time query request.
In this embodiment, the spatiotemporal query request is a multidimensional query request based on time and space.
And S102, splicing the time-space query requests to obtain a structured query statement.
In this embodiment, the structured query statement has a specific statement order, which facilitates data query.
And S103, performing space-time collision processing according to the structured query statement and a pre-constructed database to obtain a space-time collision result.
In this embodiment, the spatiotemporal collision processing may be understood as a processing procedure of performing multi-dimensional multiple queries in a pre-constructed database according to a structured query statement, and summarizing query results to obtain spatiotemporal collision results.
And S104, generating a data query result according to the space-time collision result.
In this embodiment, the data query result is obtained by further processing the spatiotemporal collision result.
In this embodiment, the execution subject of the method may be a computing device such as a computer and a server, and is not limited in this embodiment.
In this embodiment, an execution subject of the method may also be a smart device such as a smart phone and a tablet, which is not limited in this embodiment.
It can be seen that, by implementing the data query method based on spatiotemporal collision described in fig. 1, a spatiotemporal query request can be preferentially received, and then the received spatiotemporal query requests are subjected to splicing processing to obtain a structured query statement; after the structured query data are obtained, performing space-time collision processing in a pre-constructed database according to the structured query statement to obtain a space-time collision result; and finally, generating a data query result according to the space-time collision result so as to complete the query of the data. Therefore, by implementing the implementation mode, the structured processing can be carried out according to the time-space query request, so that the data query can be more standardized, and the accuracy of the data query is improved; and accurate space-time collision results can be obtained through space-time collision processing, so that data query results can be accurately obtained according to the space-time collision results, and the overall efficiency of data query is improved.
Example 2
Referring to fig. 2, fig. 2 is a schematic flowchart of another spatiotemporal collision-based data query method according to an embodiment of the present application. The flow chart of the spatio-temporal collision-based data query method described in fig. 2 is improved according to the flow chart of the spatio-temporal collision-based data query method described in fig. 1. The data query method based on the spatiotemporal collision comprises the following steps:
s201, obtaining original query data for constructing a database.
In this embodiment, the original query data is a preset large amount of data, and the data is used as basic data of the query.
S202, generating a data table comprising preset fields according to the original query data.
In this embodiment, the preset field includes one or more of an identity field, a name field, a location field, a time field, a license plate field, and a license plate type field.
In this embodiment, the index information includes one or more of a time field index, an identity field index, and a point identification field index.
And S203, creating index information according to the data table.
In this embodiment, the index information is index information of a data table.
And S204, constructing a database according to the index information and the data table.
In this embodiment, the method may construct the database according to the index information and the data table and other contents.
S205, receiving a space-time query request.
In this embodiment, the spatiotemporal query request is a multidimensional query request based on time and space.
And S206, splicing the time-space query requests to obtain a structured query statement.
In this embodiment, the structured query statement has a specific statement order, which facilitates data query.
And S207, acquiring a time query condition, a space query condition and other query condition sets from the structured query statement according to a preset query condition classification rule.
In the embodiment, the basis of the space-time collision is a time condition and a space condition; as can be seen, temporal query terms, spatial query terms, and other sets of query terms explain the underlying requirements of the query.
S208, performing data query in a pre-constructed database according to the time query condition to obtain a first result set; and performing data query in the database according to the spatial query condition to obtain a second result set.
In this embodiment, the query process is a one-by-one query process.
In this embodiment, the first result set corresponds to a plurality of time query results; the second result set corresponds to a plurality of spatial query results.
And S209, when the other query condition sets are not empty sets, performing data query in the database according to the other query condition sets to obtain other result sets.
In this embodiment, the other result set includes a plurality of other results.
S210, performing space-time collision processing on the first result set, the second result set and the other result sets to obtain space-time collision results.
As an alternative, the spatiotemporal collision processing on the first result set, the second result set and the other result sets, and the step of obtaining the spatiotemporal collision result may include:
obtaining a result set screening rule;
selecting at least one result set from other result sets according to a result set screening rule to serve as a third result set;
performing intersection solving processing on the first result set, the second result set and the third result set to obtain at least one intersection solving result;
and summarizing at least one intersection result to obtain a space-time collision result.
By implementing the implementation mode, the result set screening rule can be preferentially obtained; then selecting at least one result set from other result sets according to the result set screening rule to serve as a third result set; the method is prompted to carry out intersection solving processing on the first result set, the second result set and the third result set to obtain at least one intersection solving result; wherein the at least one intersection result is a result set obtained by intersecting at least one result included in the first result set, at least one result included in the second result set, and at least one result included in the third result set, and is referred to as at least one intersection result; and finally, summarizing the at least one intersection result to obtain a space-time collision result. Therefore, by implementing the implementation mode, re-screening can be performed according to the result sets in other result sets, and the intersection result which is more in line with the query scene is obtained, so that the acquisition precision of the space-time collision result can be effectively improved.
And S211, generating a data query result according to the space-time collision result.
In this embodiment, the data query result is obtained by further processing the spatiotemporal collision result.
In the embodiment, in a pre-constructed database, the spatiotemporal trajectory data stored in Hive can be sorted and stored into a Carbondata table by means of SparkSQL, wherein the Carbondata table contains fields such as an identity card, a name, a point location ID, a trajectory occurrence time, a license plate number, a license plate type and the like; when the Carbondata creates the table, indexes are established for the time field, the identity card and the point location ID, so that the query efficiency is improved. In the sorting process, if the track data lacks the identity card or the license plate number, the sorted people and vehicle list associated data can be supplemented and perfected.
For example, in order to efficiently utilize optimized data organization of CarbonData, CarbonData provides a targeted optimization strategy, and at present, a CarbonData community is first deeply integrated with Spark, wherein features such as filtering and pushing down, delaying materialization, incremental warehousing and the like are enhanced based on Spark SQL framework, and all DataFrame APIs are supported. So the CarbonData data is computed here using SparkSQL. Meanwhile, time and space (namely point location ID) input into a Web page are taken as query conditions and submitted to a server, the server splices the query conditions into SQL and pushes the SQL to a Redis channel subscribed by a Spark program in advance, the Spark program receives the SQL information of the subscribed channel, calculation is carried out by utilizing Spark SQL, and a result is pushed to the Redis. Spark and the Web can realize real-time interaction by means of a Redis channel.
Specific examples are as follows, for example,
firstly, setting query conditions to complete the query of a first result set.
1) The query conditions are classified into 3 types, time interval, region position, target object (optional)
2) Time interval: start time and end time, time of generation of screening trace
3) Area position: resource points on a specific map. .
And secondly, modifying the query conditions to complete the query of a second result set. If more result sets are needed, the second step is repeated.
And thirdly, selecting a result set to be subjected to collision intersection solving, clicking the 'collision intersection solving', and performing SQL JOIN operation intersection solving.
And fourthly, generating a collision result summary.
It can be seen that, by implementing the data query method based on spatiotemporal collision described in fig. 2, a spatiotemporal query request can be preferentially received, and then the received spatiotemporal query requests are subjected to splicing processing to obtain a structured query statement; after the structured query data are obtained, performing space-time collision processing in a pre-constructed database according to the structured query statement to obtain a space-time collision result; and finally, generating a data query result according to the space-time collision result so as to complete the query of the data. Therefore, by implementing the implementation mode, the structured processing can be carried out according to the time-space query request, so that the data query can be more standardized, and the accuracy of the data query is improved; and accurate space-time collision results can be obtained through space-time collision processing, so that data query results can be accurately obtained according to the space-time collision results, and the overall efficiency of data query is improved.
Example 3
Referring to fig. 3, fig. 3 is a schematic structural diagram of a data query apparatus based on spatiotemporal collision according to an embodiment of the present application. Wherein, the data inquiry device based on the space-time collision comprises:
a receiving unit 310 for receiving a spatiotemporal query request;
the splicing unit 320 is configured to splice the time-space query request to obtain a structured query statement;
the collision unit 330 is configured to perform spatio-temporal collision processing according to the structured query statement and a pre-constructed database to obtain a spatio-temporal collision result;
and the generating unit 340 is configured to generate a data query result according to the spatiotemporal collision result.
In this embodiment, for the explanation of the data query device based on spatiotemporal collision, reference may be made to the description in embodiment 1 or embodiment 2, and details are not repeated in this embodiment.
It can be seen that, by implementing the spatio-temporal collision-based data query apparatus described in fig. 3, the operations of receiving a spatio-temporal query request, constructing a structured statement, processing spatio-temporal collision results, and generating data query results can be achieved through the cooperation and the cooperative work of a plurality of units, so as to complete the integration of data query. By implementing the implementation mode, the data query device can autonomously complete a series of data query processes, thereby greatly simplifying the data query process and improving the convenience for data query; in addition, the data query device can also greatly improve the accuracy and efficiency of data query through the cooperative work of a plurality of units.
Example 4
Referring to fig. 4, fig. 4 is a schematic structural diagram of another spatiotemporal collision-based data query apparatus according to an embodiment of the present application. The structural diagram of the spatiotemporal collision-based data query device described in fig. 4 is improved according to the structural diagram of the spatiotemporal collision-based data query device described in fig. 3. Wherein the collision cell 330 includes:
the determining subunit 331 is configured to obtain a time query condition, a space query condition, and other query condition sets from the structured query statement according to a preset query condition classification rule;
a query subunit 332, configured to perform data query in a pre-constructed database according to a time query condition to obtain a first result set; performing data query in the database according to the spatial query condition to obtain a second result set; when the other query condition sets are not empty sets, performing data query in the database according to the other query condition sets to obtain other result sets;
and the collision subunit 333 is configured to perform spatio-temporal collision processing on the first result set, the second result set, and the other result sets to obtain spatio-temporal collision results.
As an alternative embodiment, the collision subunit 333 includes:
the acquisition module is used for acquiring a result set screening rule;
the screening module is used for selecting at least one result set from other result sets according to the result set screening rule to serve as a third result set;
the intersection solving module is used for solving intersection of the first result set, the second result set and the third result set to obtain at least one intersection solving result;
and the summarizing module is used for summarizing at least one intersection result to obtain a space-time collision result.
As an optional implementation, the data query apparatus based on spatiotemporal collision further includes:
an obtaining unit 350, configured to obtain original query data used for building a database;
the generating unit 340 is further configured to generate a data table including preset fields according to the original query data;
a creating unit 360 for creating index information according to the data table;
the creating unit 360 is further used for creating a database according to the index information and the data table
As an optional implementation manner, the preset field includes one or more of an identity identification field, a name identification field, a location identification field, a time field, a license plate identification field, and a license plate type field.
The index information comprises one or more of a time field index, an identity identification field index and a point identification field index.
In this embodiment, for the explanation of the data query device based on spatiotemporal collision, reference may be made to the description in embodiment 1 or embodiment 2, and details are not repeated in this embodiment.
It can be seen that, when the spatio-temporal collision-based data query apparatus described in fig. 4 is implemented, the multiple units cooperate with each other and work together to implement operations such as receiving a spatio-temporal query request, constructing a structured statement, processing spatio-temporal collision results, and generating data query results, so as to complete integration of data query. By implementing the implementation mode, the data query device can autonomously complete a series of data query processes, thereby greatly simplifying the data query process and improving the convenience for data query; in addition, the data query device can also greatly improve the accuracy and efficiency of data query through the cooperative work of a plurality of units.
The embodiment of the present application provides an electronic device, which includes a memory and a processor, where the memory is used to store a computer program, and the processor runs the computer program to make the electronic device execute the spatiotemporal collision-based data query method according to any one of embodiment 1 or embodiment 2 of the present application.
The embodiment of the present application provides a computer-readable storage medium, which stores computer program instructions, and when the computer program instructions are read and executed by a processor, the computer program instructions execute the spatiotemporal collision-based data query method according to any one of embodiment 1 or embodiment 2 of the present application.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus and method can be implemented in other ways. The apparatus embodiments described above are merely illustrative, and for example, the flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
In addition, functional modules in the embodiments of the present application may be integrated together to form an independent part, or each module may exist separately, or two or more modules may be integrated to form an independent part.
The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application or portions thereof that substantially contribute to the prior art may be embodied in the form of a software product stored in a storage medium and including instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
The above description is only an example of the present application and is not intended to limit the scope of the present application, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application shall be included in the protection scope of the present application. It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures.
The above description is only for the specific embodiments of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present application, and shall be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
Claims (10)
1. A data query method based on spatiotemporal collision is characterized by comprising the following steps:
receiving a spatio-temporal query request;
splicing the space-time query request to obtain a structured query statement;
performing space-time collision processing according to the structured query statement and a pre-constructed database to obtain a space-time collision result;
and generating a data query result according to the space-time collision result.
2. The spatio-temporal collision-based data query method according to claim 1, wherein the spatio-temporal collision processing is performed according to the structured query statement and a pre-constructed database to obtain spatio-temporal collision results, and the method comprises:
acquiring a time query condition, a space query condition and other query condition sets from the structured query statement according to a preset query condition classification rule;
performing data query in a pre-constructed database according to the time query condition to obtain a first result set; performing data query in the database according to the space query condition to obtain a second result set;
when the other query condition sets are not empty sets, performing data query in the database according to the other query condition sets to obtain other result sets;
and performing space-time collision processing on the first result set, the second result set and the other result sets to obtain space-time collision results.
3. The spatio-temporal collision-based data query method according to claim 2, wherein the spatio-temporal collision processing on the first result set, the second result set and the other result sets to obtain spatio-temporal collision results comprises:
obtaining a result set screening rule;
selecting at least one result set from the other result sets according to the result set screening rule to serve as a third result set;
performing intersection solving processing on the first result set, the second result set and the third result set to obtain at least one intersection solving result;
and summarizing the at least one intersection result to obtain a space-time collision result.
4. The spatio-temporal collision-based data query method according to claim 1, wherein prior to the receiving a data query request, the method further comprises:
acquiring original query data for constructing the database;
generating a data table comprising preset fields according to the original query data;
creating index information according to the data table;
and constructing a database according to the index information and the data table.
5. The spatio-temporal collision-based data query method according to claim 4, wherein the preset fields comprise one or more of an identity identification field, a name identification field, a point identification field, a time field, a license plate identification field, and a license plate type field.
The index information comprises one or more of a time field index, an identity identification field index and a point location identification field index.
6. A spatiotemporal collision-based data query device, comprising:
a receiving unit for receiving a spatio-temporal query request;
the splicing unit is used for splicing the space-time query request to obtain a structured query statement;
the collision unit is used for performing space-time collision processing according to the structured query statement and a pre-constructed database to obtain a space-time collision result;
and the generating unit is used for generating a data query result according to the space-time collision result.
7. The spatiotemporal collision-based data query device according to claim 6, wherein the collision unit comprises:
the determining subunit is used for acquiring a time query condition, a space query condition and other query condition sets from the structured query statement according to a preset query condition classification rule;
the query subunit is used for performing data query in a pre-constructed database according to the time query condition to obtain a first result set; performing data query in the database according to the space query condition to obtain a second result set; when the other query condition sets are not empty sets, performing data query in the database according to the other query condition sets to obtain other result sets;
and the collision subunit is used for performing space-time collision processing on the first result set, the second result set and the other result sets to obtain space-time collision results.
8. The spatiotemporal collision-based data query device according to claim 6, wherein the collision subunit comprises:
the acquisition module is used for acquiring a result set screening rule;
the screening module is used for selecting at least one result set from the other result sets according to the result set screening rule to serve as a third result set;
the intersection solving module is used for solving intersection of the first result set, the second result set and the third result set to obtain at least one intersection solving result;
and the summarizing module is used for summarizing the at least one intersection result to obtain a space-time collision result.
9. An electronic device, comprising a memory for storing a computer program and a processor for executing the computer program to cause the electronic device to perform the spatiotemporal collision-based data query method according to any one of claims 1 to 5.
10. A readable storage medium, wherein computer program instructions are stored in the readable storage medium, and when the computer program instructions are read and executed by a processor, the method for querying data based on spatiotemporal collision according to any one of claims 1 to 5 is executed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911299900.XA CN111090669A (en) | 2019-12-16 | 2019-12-16 | Data query method and device based on space-time collision |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911299900.XA CN111090669A (en) | 2019-12-16 | 2019-12-16 | Data query method and device based on space-time collision |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111090669A true CN111090669A (en) | 2020-05-01 |
Family
ID=70396469
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911299900.XA Pending CN111090669A (en) | 2019-12-16 | 2019-12-16 | Data query method and device based on space-time collision |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111090669A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112732761A (en) * | 2021-01-13 | 2021-04-30 | 青岛海信网络科技股份有限公司 | Data collision method and device |
| CN112861022A (en) * | 2021-02-01 | 2021-05-28 | 杭州全拓科技有限公司 | Artificial intelligence-based personnel activity big data record query method |
| CN112989228A (en) * | 2021-04-25 | 2021-06-18 | 湖南视觉伟业智能科技有限公司 | Distributed space-time query method and system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103425789A (en) * | 2013-08-28 | 2013-12-04 | 深圳信息职业技术学院 | Spatio-temporal data query method and device |
| CN105788264A (en) * | 2016-04-28 | 2016-07-20 | 泰华智慧产业集团股份有限公司 | Hbase-based barrier data area collision analysis method and Hbase-based barrier data area collision analysis system |
| CN107798026A (en) * | 2016-09-05 | 2018-03-13 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| CN110019402A (en) * | 2017-12-26 | 2019-07-16 | 浙江宇视科技有限公司 | Data analysing method, device and readable storage medium storing program for executing |
| US20190266138A1 (en) * | 2016-10-24 | 2019-08-29 | Beijing Wellintech Co., Ltd. | Method for retrieving data object based on spatial-temporal database |
-
2019
- 2019-12-16 CN CN201911299900.XA patent/CN111090669A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103425789A (en) * | 2013-08-28 | 2013-12-04 | 深圳信息职业技术学院 | Spatio-temporal data query method and device |
| CN105788264A (en) * | 2016-04-28 | 2016-07-20 | 泰华智慧产业集团股份有限公司 | Hbase-based barrier data area collision analysis method and Hbase-based barrier data area collision analysis system |
| CN107798026A (en) * | 2016-09-05 | 2018-03-13 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| US20190266138A1 (en) * | 2016-10-24 | 2019-08-29 | Beijing Wellintech Co., Ltd. | Method for retrieving data object based on spatial-temporal database |
| CN110019402A (en) * | 2017-12-26 | 2019-07-16 | 浙江宇视科技有限公司 | Data analysing method, device and readable storage medium storing program for executing |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112732761A (en) * | 2021-01-13 | 2021-04-30 | 青岛海信网络科技股份有限公司 | Data collision method and device |
| CN112732761B (en) * | 2021-01-13 | 2022-08-23 | 青岛海信网络科技股份有限公司 | Data collision method and device |
| CN112861022A (en) * | 2021-02-01 | 2021-05-28 | 杭州全拓科技有限公司 | Artificial intelligence-based personnel activity big data record query method |
| CN112989228A (en) * | 2021-04-25 | 2021-06-18 | 湖南视觉伟业智能科技有限公司 | Distributed space-time query method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106528787B (en) | query method and device based on multidimensional analysis of mass data | |
| CN111090669A (en) | Data query method and device based on space-time collision | |
| CN108304444B (en) | Information query method and device | |
| US8862566B2 (en) | Systems and methods for intelligent parallel searching | |
| US20150278268A1 (en) | Data encoding and corresponding data structure | |
| EP3311305A1 (en) | Automated database schema annotation | |
| CN106649503A (en) | Query method and system based on sql | |
| CN112883030A (en) | Data collection method and device, computer equipment and storage medium | |
| CN110969517B (en) | Bidding life cycle association method, system, storage medium and computer equipment | |
| US9659021B1 (en) | Client based backups and backup indexing | |
| CN108170752B (en) | Template-based metadata management method and system | |
| CN107330024B (en) | Storage method and device of tag system data | |
| CN115145871A (en) | File query method and device and electronic equipment | |
| CN102508884A (en) | Method and device for acquiring hotpot events and real-time comments | |
| CN105302827A (en) | Event search method and device | |
| CN105068879B (en) | A kind of method and device searched target and subscribed to | |
| CN110955712A (en) | Development API processing method and device based on multiple data sources | |
| CN106446080B (en) | Data query method, query service equipment, client equipment and data system | |
| CN106933909B (en) | Multi-dimensional data query method and device | |
| CN111143356B (en) | Report retrieval method and device | |
| CN109725982B (en) | Data object construction method and device | |
| CN111061814A (en) | Modeling analysis method and device, electronic equipment and storage medium | |
| CN110879810A (en) | Data processing method and device | |
| CN110928868A (en) | Vehicle data retrieval method, device and computer-readable storage medium | |
| CN115934759B (en) | Acceleration calculation method for massive multi-source heterogeneous satellite data query |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200501 |
|
| WD01 | Invention patent application deemed withdrawn after publication |