CN111161086A - Method, system, computer equipment and storage medium for inquiring business data - Google Patents
Method, system, computer equipment and storage medium for inquiring business data Download PDFInfo
- Publication number
- CN111161086A CN111161086A CN201911290688.0A CN201911290688A CN111161086A CN 111161086 A CN111161086 A CN 111161086A CN 201911290688 A CN201911290688 A CN 201911290688A CN 111161086 A CN111161086 A CN 111161086A
- Authority
- CN
- China
- Prior art keywords
- address
- target
- attribute information
- coordinate point
- geographic coordinate
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
-
- 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/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9532—Query formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9537—Spatial or temporal dependent retrieval, e.g. spatiotemporal queries
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Mathematical Physics (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention provides a method for inquiring service data, which comprises the following steps: acquiring service data; mapping the service data into a preset geographic map according to the address of the service data to obtain a corresponding geographic coordinate point, and establishing an attribute information mapping table according to the geographic coordinate point and other attribute information of the service data; acquiring operation information of a user, and analyzing the operation information to obtain a corresponding target address query instruction; screening out a target geographic coordinate point corresponding to a target address query instruction according to the target address query instruction and an attribute information mapping table; and acquiring corresponding target attribute information according to the target geographic coordinate point and the attribute information mapping table, and displaying the target geographic coordinate point and the target attribute information. The embodiment of the invention also provides a system, computer equipment and a readable storage medium. The embodiment of the invention can inquire according to a plurality of dimensions of the service data or by selecting the geographical range in a frame, and can effectively improve the inquiry efficiency of the service data.
Description
Technical Field
The embodiment of the invention relates to the field of computer data processing, in particular to a method and a system for querying service data, computer equipment and a computer readable storage medium.
Background
At present, in the product planning or selling process, historical business data needs to be extracted first, then the historical business data needs to be inquired and analyzed, so that the selling and claim settlement information of various products is obtained, then the market scale is estimated according to the information, and the product planning is carried out. When the product has multiple dimensions and the historical service data volume is large, the complexity of the data increases sharply, for example, one service data has more than ten dimensions, one database has tens of millions of service data, the processing of a large amount of data increases the complexity of the operation, the query becomes complicated, and the query efficiency is low.
Therefore, under the condition of huge business data volume and large data dimension, how to simplify the complexity of operation and improve the query efficiency is an urgent technical problem to be solved.
Disclosure of Invention
In view of this, embodiments of the present invention provide a method, a system, a computer device, and a computer-readable storage medium for querying business data, which can query according to multiple dimensions of the business data or by selecting a geographical range in a frame, and can effectively improve the query efficiency of the business data.
In order to achieve the above object, an embodiment of the present invention provides a method for querying service data, including the following steps:
acquiring service data, wherein the service data at least comprises: address and other attribute information;
mapping the service data to a preset geographic map according to the address to obtain a geographic coordinate point corresponding to the address, and establishing an attribute information mapping table according to the geographic coordinate point and the other attribute information, wherein the attribute information mapping table is used for mapping a comparison relation between the geographic coordinate point and the attribute information;
acquiring operation information of a user, and analyzing the operation information to obtain a corresponding target address query instruction;
screening out a target geographic coordinate point corresponding to the target address query instruction from the geographic map according to the target address query instruction and the attribute information mapping table;
and acquiring target attribute information corresponding to the target geographic coordinate point according to the target geographic coordinate point and the attribute information mapping table, and displaying the target geographic coordinate point and the target attribute information.
Further, the step of mapping the service data to a preset geographical map according to the address further includes:
resolving the address into an address field;
matching the address field with a field of a preset address in the preset geographic map, wherein the preset address is preset with a corresponding geographic coordinate point;
and when the matching is successful, mapping the address to a geographic coordinate point corresponding to the preset address.
Further, the step of obtaining operation information of the user and analyzing the operation information to obtain a corresponding target address query instruction specifically includes:
receiving a keyword input by the user through a preset input box or click information of one dimension of a plurality of preset dimensions in a preset pull-down box;
acquiring target service data corresponding to the keyword or the click information according to the keyword or the click information;
and generating the target address query instruction according to the target address in the target service data.
Further, the step of obtaining the operation information of the user and analyzing the operation information to obtain the corresponding target address query instruction further includes:
receiving operation information of the user for selecting the geographical range;
determining a target address of the target service data in the geographic range according to the geographic range;
and generating the target address query instruction according to the target address of the target service data.
Further, the step of receiving the operation information of the user for selecting the geographical range includes:
and receiving operation information of drawing a closed graph by the user, wherein the closed graph forms the geographic range.
Further, before the step of receiving the keyword input by the user through the preset input box or the click information of one dimension of a plurality of preset dimensions in the preset drop-down box, the method further includes:
setting corresponding query dimensions according to other attribute information of the service data, wherein the query dimensions at least comprise: address dimension, number dimension, category dimension, quota dimension, value dimension, and date dimension.
In order to achieve the above object, an embodiment of the present invention further provides a system for querying service data, including:
an obtaining module, configured to obtain service data, where the service data at least includes: address and other attribute information;
the mapping module is used for mapping the service data into a preset geographic map according to the address to obtain a geographic coordinate point corresponding to the address, and establishing an attribute information mapping table according to the geographic coordinate point and the other attribute information, wherein the attribute information mapping table is used for mapping a comparison relation between the geographic coordinate point and the attribute information;
the analysis module is used for acquiring operation information of a user and analyzing the operation information to obtain a corresponding target address query instruction;
the screening module is used for screening a target geographic coordinate point corresponding to the target address query instruction from the geographic map according to the target address query instruction and the attribute information mapping table;
and the display module is used for acquiring target attribute information corresponding to the target geographic coordinate point according to the target geographic coordinate point and the attribute information mapping table and displaying the target geographic coordinate point and the target attribute information.
In order to achieve the above object, an embodiment of the present invention further provides a computer device, where the computer device includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor implements the steps of the method for querying business data as described above when executing the computer program.
In order to achieve the above object, an embodiment of the present invention further provides a computer-readable storage medium, in which a computer program is stored, where the computer program is executable by at least one processor, so as to cause the at least one processor to execute the steps of the service data query method described above.
The business data query method, the business data query system, the computer equipment and the computer readable storage medium provided by the embodiment of the invention can map the business data to the geographic coordinate points in the map according to the addresses of the business data, analyze the operation information of the user to obtain the address query command, screen the target geographic coordinate points and the target attribute information, display the target geographic coordinate points and the target attribute information, and effectively improve the query efficiency of the business data.
The invention is described in detail below with reference to the drawings and specific examples, but the invention is not limited thereto.
Drawings
Fig. 1 is a flowchart illustrating steps of a method for querying service data according to an embodiment of the present invention.
Fig. 2 is a schematic diagram of program modules of a service data query system according to an embodiment of the present invention.
Fig. 3 is a schematic diagram of a hardware structure of an embodiment of a computer device according to an embodiment of the present invention.
Fig. 4 is a schematic diagram of receiving a keyword input by a user through a preset input box or click information of one dimension of a plurality of preset dimensions in a preset drop-down box according to an embodiment of the present invention.
Fig. 5 is a schematic diagram of operation information of receiving a user frame for selecting a geographic area according to an embodiment of the present invention.
Fig. 6 is a schematic diagram for displaying the target geographic coordinate point and the target attribute information according to the embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Technical solutions between various embodiments may be combined with each other, but must be realized by those skilled in the art, and when the technical solutions are contradictory or cannot be realized, such a combination should not be considered to exist, and is not within the protection scope of the present invention.
Example one
Referring to fig. 1, a flowchart illustrating steps of a method for querying business data according to the present invention is shown. It is to be understood that the flow charts in the embodiments of the present method are not intended to limit the order in which the steps are performed. The following description is given by taking a computer device as an execution subject, specifically as follows:
step S100, obtaining service data, wherein the service data at least comprises: address and other attribute information, wherein the other attribute information at least comprises: number, category, amount, value, and date.
In a preferred embodiment, the data for the policy number, address, seed, premium, start date and expiration date are obtained by connecting to the base information database system.
In another preferred embodiment, the system can be further connected to a risk information database system so as to obtain risk assessment data of the insurance policy, wherein the risk assessment data comprises data such as disaster types and risk levels.
In another preferred embodiment, the system can also be connected to a database system of the claim information, so as to obtain data of the insurance policy, such as the payment amount, the paid amount, the unsettled amount, the proportion of the claim factors and the like.
Step S102, mapping the service data to a preset geographic map according to the address to obtain a geographic coordinate point corresponding to the address, and establishing an attribute information mapping table according to the geographic coordinate point and the other attribute information, wherein the attribute information mapping table is used for mapping a comparison relationship between the geographic coordinate point and the attribute information.
Specifically, the service data is mapped to a preset geographic map through a geographic coding module of the GIS to obtain geographic coordinate points corresponding to the addresses, and then an attribute information mapping table is established according to the obtained geographic coordinate points and other attribute information, wherein the attribute information mapping table maps attribute information such as numbers, types, limits, values and dates in the service data and the comparison relation of the geographic coordinate points corresponding to the addresses.
The GIS is an abbreviation of Geographic Information processing System (Geographic Information System), sometimes also referred to as a "geosciences Information System". The GIS is a specific very important spatial information system, and is a technical system for collecting, storing, managing, operating, analyzing, displaying and describing relevant geographic distribution data in the whole or partial earth surface (including the atmosphere) space under the support of a computer hardware and software system. The GIS also comprises a geocoding module, wherein the geocoding refers to the process of converting the position description such as the address or the place name into a geographic coordinate point on a map.
In an exemplary embodiment, the geographic coding module associates the business data with a corresponding geographic coordinate point on the geographic map according to an address in the business data. Specifically, the geocoding module acquires geographic element reference data preset in the GIS, such as cities, streets, roads, house numbers and the like, and then adds the reference data to a preset address locator pattern, wherein the address locator pattern is used for defining which reference data are used to create an address locator, and the geocoding module adds the reference data to the address locator pattern and then creates the address locator. Further, the address locator analyzes address fields such as provinces, cities, streets, postcodes and the like in the service data, then searches candidate addresses from reference data in the address locator, calculates matching degrees for the candidate addresses, arranges the calculated matching degrees from high to low, and establishes an attribute information mapping table according to other attribute information and the geographic coordinate points, wherein the address with the highest matching degree is the geographic coordinate point corresponding to the service data, and the geographic coordinate point is usually represented in a longitude and latitude form.
Illustratively, the address of the service data is "number 1 of south mountain region Yuehai street Yuehai road of Shenzhen, Guandong province", and the geocoding module resolves the policy address into an address field: guangdong province, Shenzhen city, Nanshan region, Guangdai street, Guangdai Luo and No. 1, then matching the address fields with the reference data respectively to obtain three matching addresses, which are respectively 'Guangdong province Shenzhen city Nanshan region Guangdai street Guangdai Lu No. 1', 'Guangdong province Shenzhen city Nanshan region Guangdai street Guangdai Lu No. 1-1' and 'Guangdong province Shenzhen city Nanshan region Guangdai street Guangdai Lu No. 11', the matching degrees of the three matching addresses are respectively 100, 98 and 98, so that the address with the matching degree of 100 is the target address corresponding to the business data, the geographic coordinate point corresponding to the target address is the geographic coordinate point corresponding to the business data, and then establishing the mapping relationship between the geographic coordinate point and other attribute information corresponding to the address in the attribute information mapping table.
And step S104, acquiring operation information of a user, and analyzing the operation information to obtain a corresponding target address query instruction.
In a preferred embodiment, a keyword input by a user in a preset input box is received, then a field value corresponding to the keyword in a database table is determined according to the keyword, so that target business data corresponding to the field value is obtained, and then a target address query instruction is generated according to an address in the target data.
Referring to fig. 4, if a user inputs a keyword "zhang san" through a preset "insured" input box, a field value containing "zhang san" in a database table is determined according to the keyword "zhang san", so as to obtain policy data corresponding to the field value "zhang san", and then a target address query instruction is generated according to an address in the policy data.
In another preferred embodiment, click information of the user on one of a plurality of preset dimensions in a preset drop-down box is received, target service data corresponding to the click information is obtained according to the click information, and a target address query instruction is generated according to an address in the target service data. The preset dimensions respectively correspond to a plurality of items of attribute information in the service data, and the preset dimensions at least comprise: a number dimension, an address dimension, a category dimension, a value dimension, a quota dimension, and a date dimension.
Referring to fig. 4, a user may click "please select province" in the dimension of "target address", and pull down "guangdong", so that the field value in the database table contains business data of "guangdong" according to the information of "guangdong", and a target address query instruction is generated according to the detailed address of the business data.
In another preferred embodiment, a geographic range formed by drawing a closed graph by a user is received, then a target address of target business data in the geographic range is determined according to the geographic range, and the target address query instruction is generated according to the target address of the target business data.
Specifically, a graph drawing tool is preset in the GIS, a user can draw any closed graph on the geographic map by using the graph drawing tool, a map area corresponding to the closed graph is a framed geographic range, and then a longitude and latitude set corresponding to the geographic range is obtained. And then screening the business data of which the longitude and latitude corresponding to the address are contained in the longitude and latitude set so as to obtain the address corresponding to the business data, and then generating a target address query instruction according to the address.
The user can use the straight line and arc line commands of the graph drawing tool to draw graphs on the map, and the drawn straight line and arc line are connected end to form a closed graph; for another example, the user may also directly draw a closed graph by using a triangle, rectangle, ellipse, or circle command, where an area of the closed graph corresponding to the map is a framed geographic range, the geographic range is represented by a longitude and latitude set of a series of coordinate points, then obtain service data with the longitude and latitude within the range, further obtain addresses of the service data, and finally generate a target address query instruction according to the addresses.
Referring to fig. 5, a user draws a circle on a map by a graphic drawing tool, and the circle is within the framed geographical range, then filters the service data within the range, further obtains addresses of the service data, and finally generates a target address query instruction according to the addresses.
In another preferred embodiment, when there is no field value corresponding to the keyword input by the user in the database table, that is, the analysis of the operation information of the user fails, the feedback information "no data meeting the requirement, please re-input the keyword" is sent to the user; and when the business data of which the longitude and latitude corresponding to the address are contained in the longitude and latitude set is not screened, namely the analysis of the operation information of the user fails, sending feedback information 'data which does not meet the requirement, and requesting to adjust the frame selection range' to the user.
And step S106, screening out a target geographic coordinate point corresponding to the target address query instruction from the geographic map according to the target address query instruction and the attribute information mapping table.
Specifically, the attribute information mapping table includes an address of the service data, other attribute information, and a corresponding geographic coordinate point, so that matching can be performed according to the address in the target address query instruction and the address in the attribute information mapping table, and then the target geographic coordinate point corresponding to the address is obtained.
Illustratively, in step S104, acquiring a corresponding policy data according to a key "property risk" input by the user, where an address corresponding to the policy data is "number 1 of yuehai road in the south mountain area of Guangdong Shenzhen city, Guangdong province, and then generating a corresponding target address query instruction according to the address; and then matching the address with the address in the attribute information mapping table, and acquiring a target geographic coordinate point corresponding to the matched address when the corresponding address is matched.
And step S108, acquiring target attribute information corresponding to the target geographic coordinate point according to the target geographic coordinate point and the attribute information mapping table, and displaying the target geographic coordinate point and the target attribute information.
And after the target geographic coordinate point corresponding to the address query instruction is screened out, further acquiring target attribute information corresponding to the target geographic coordinate point from the attribute information mapping table, and displaying the target geographic coordinate point and the target attribute information on a display interface.
Referring to fig. 6, a user selects a start date "2018-01-01" and an end date "2019-01-01" by "policy start" dimension pull-down, generates a corresponding target query command, queries to obtain a plurality of target coordinate points and corresponding attribute information nationwide, and displays the coordinate points and the attribute information as shown in fig. 6.
The invention can quickly inquire according to the data dimension or the limited geographical range, and can effectively improve the inquiry efficiency of the business data because the multi-dimensional inquiry can be carried out and the geographical area can be limited by drawing for inquiry.
Example two
Referring to fig. 2, a schematic diagram of program modules of a business data query system according to a second embodiment of the present invention is shown. In this embodiment, the query system 20 for business data based on computer equipment may include or be divided into one or more program modules, and the one or more program modules are stored in a storage medium and executed by one or more processors to implement the present invention and implement the query method for business data. The program module referred to in the embodiments of the present invention refers to a series of computer program instruction segments capable of performing specific functions, and is more suitable for describing the execution process of the query system 20 of the business data in the storage medium than the program itself. The following description will specifically describe the functions of the program modules of the present embodiment:
an obtaining module 200, configured to obtain service data, where the service data at least includes: address and other attribute information.
In a preferred embodiment, the obtaining module 200 is connected to the basic information database system to obtain the data of the policy number, address, risk, premium, start date and expiration date of the policy.
In another preferred embodiment, the acquiring module 200 may further be connected to a risk information database system to acquire risk assessment data of the insurance policy, wherein the risk assessment data includes disaster type and risk level data.
In another preferred embodiment, the acquiring module 200 can also be connected to the claim information database system to acquire data such as the amount of claim, the amount of paid out, the amount of outstanding money, the ratio of factors of claim, and the like of the policy.
A mapping module 202, configured to map the service data to a preset geographic map according to the address, obtain a geographic coordinate point corresponding to the address, and establish an attribute information mapping table according to the geographic coordinate point and the other attribute information, where the attribute information mapping table is used to map a comparison relationship between the geographic coordinate point and the attribute information.
Specifically, the mapping module 202 maps the service data to a preset geographic map through a geographic coding unit in the GIS sub-module to obtain a geographic coordinate point corresponding to the address, and then establishes an attribute information mapping table according to the obtained geographic coordinate point and other attribute information, so as to map a comparison relationship between attribute information such as a serial number, a type, a limit, a value, a date and the like in the service data and the geographic coordinate point corresponding to the address.
GIS is an abbreviation of Geographic Information processing System (Geographic Information System), sometimes also referred to as a "geosciences Information System". The GIS is a specific and very important spatial information system, which is a technical system for collecting, storing, managing, operating, analyzing, displaying and describing relevant geographic distribution data in the whole or part of the space of the earth surface layer (including the atmosphere) under the support of a computer hardware and software system. The GIS submodule also comprises a geocoding unit, and geocoding refers to a process of converting the position description such as an address or a place name into a geographic coordinate point on a map.
In an exemplary embodiment, the service data is associated with a corresponding geographic coordinate point on the geographic map according to an address in the service data by the geocoding unit. Specifically, the geocoding unit acquires geographic element reference data preset in the GIS, such as cities, streets, roads, house numbers and the like, and then adds the reference data to a preset address locator pattern, wherein the address locator pattern is used for defining which reference data are used to create an address locator, and the geocoding module adds the reference data to the address locator pattern and then creates the address locator. Further, the address locator analyzes an address field in the service data, such as province, city, street, postcode and the like, searches a candidate address from reference data in the address locator, calculates a matching degree for the candidate address, wherein the address with the highest matching degree is a geographic coordinate point corresponding to the service data, the geographic coordinate point is usually represented in a longitude and latitude mode, and then an attribute information mapping table is established according to other attribute information and the geographic coordinate point.
Illustratively, the address of the service data is "number 1 of south mountain region Yuehai street Yuehai road of Shenzhen, Guandong province", and the geocoding module resolves the policy address into an address field: guangdong province, Shenzhen city, Nanshan region, Guangdai street, Guangdai Luo and No. 1, then matching the address fields with the reference data respectively to obtain three matching addresses, namely 'Guangdong province Shenzhen city Nanshan region Guangdai street Guangdai Lu No. 1', 'Guangdong province Shenzhen city Nanshan region Guangdai street Guangdai Lu No. 1' and 'Guangdong province Shenzhen city Nanshan region Guangdai street Guangdai Lu No. 11', the matching degrees of the three matching addresses are 100, 98 and 98 respectively, 98, and 98, then the address with the matching degree of 100 is the target address corresponding to the business data, the geographic coordinate point corresponding to the target address is the geographic coordinate point of the business data, and then establishing the mapping relationship between the geographic coordinate point and other corresponding attribute information in the attribute information mapping table.
The analysis module 204 obtains operation information of the user, and analyzes the operation information to obtain a corresponding target address query instruction.
In a preferred embodiment, the parsing module 204 receives a keyword input by a user in a preset input box, determines a field value corresponding to the keyword in a database table according to the keyword, thereby obtaining target service data corresponding to the field value, and generates a target address query instruction according to an address in the target data.
Referring to fig. 4, a user inputs a keyword "zhang san" through a preset "insured" input box, the parsing module 204 determines a field value containing "zhang san" in a database table according to the keyword "zhang san", further obtains policy data corresponding to the field value "zhang san", and then generates a target address query instruction according to an address in the policy data.
In another preferred embodiment, the parsing module 204 receives click information of the user on one of a plurality of preset dimensions in a preset drop-down box, acquires target service data corresponding to the click information according to the click information, and generates a target address query instruction according to an address in the target service data. The preset dimensions respectively correspond to a plurality of items of attribute information in the service data, and the preset dimensions at least comprise: a number dimension, an address dimension, a category dimension, a value dimension, a quota dimension, and a date dimension.
Referring to fig. 4, a user may click "please select province" in the dimension of "target address", and pull down "guangdong", where the parsing module 204 includes business data of "guangdong" from the field value in the database table according to the information of "guangdong", and generates a target address query instruction according to the detailed address of the business data.
In another preferred embodiment, the parsing module 204 receives a geographic range formed by drawing a closed graph by a user, determines a target address of target service data within the geographic range according to the geographic range, and generates the target address query instruction according to the target address of the target service data.
Specifically, a graph drawing tool is preset in the GIS submodule, a user can draw any closed graph on the geographic map by using the graph drawing tool, a map area corresponding to the closed graph is a framed geographic range, and then a longitude and latitude set corresponding to the geographic range is obtained. And then screening the business data of which the longitude and latitude corresponding to the address are contained in the longitude and latitude set so as to obtain the address corresponding to the business data, and then generating a target address query instruction according to the address.
For example, a user may use the line and arc commands of the graphic drawing tool to draw a graphic on a map, the drawn lines and arcs forming a closed graphic by joining end to end; for another example, the user may also directly draw a closed graph by using a triangle, rectangle, ellipse, or circle command, where an area of the closed graph corresponding to the map is a framed geographic range, the geographic range is represented by a longitude and latitude set of a series of coordinate points, then obtain service data with the longitude and latitude within the range, further obtain addresses of the service data, and finally generate a target address query instruction according to the addresses.
Referring to fig. 5, if the user draws a circle on the map through the graphic drawing tool, the circle range is the framed geographical range, the parsing module 204 filters the service data in the range, further obtains the addresses of the service data, and finally generates the target address query instruction according to the addresses.
In another preferred embodiment, when there is no field value corresponding to the keyword input by the user in the database table, that is, the analysis of the operation information of the user fails, the feedback information "no data meeting the requirement, please re-input the keyword" is sent to the user; and when the business data of which the longitude and latitude corresponding to the address are contained in the longitude and latitude set is not screened, namely the analysis of the operation information of the user fails, sending feedback information 'data which does not meet the requirement, and requesting to adjust the frame selection range' to the user.
And the screening module 206 is configured to screen a target geographic coordinate point corresponding to the target address query instruction from the geographic map according to the target address query instruction and the attribute information mapping table.
Specifically, the attribute information mapping table includes an address of the service data, other attribute information, and a corresponding geographic coordinate point, so that matching can be performed according to the address in the target address query instruction and the address in the attribute information mapping table, and then the target geographic coordinate point corresponding to the address is obtained.
Illustratively, the parsing module 204 acquires a corresponding policy data according to a key "property risk" input by the user, where an address corresponding to the policy data is "number 1 of south mountain region, Guangdong province Shenzhen city, Guanghai street, Guanghai road", and then generates a corresponding target address query instruction according to the address; and then matching the address with the address in the attribute information mapping table, and acquiring a target geographic coordinate point corresponding to the matched address when the corresponding address is matched.
And the display module 208 acquires the target attribute information corresponding to the target geographic coordinate point according to the target geographic coordinate point and the attribute information mapping table, and displays the target geographic coordinate point and the target attribute information.
After the screening module 206 screens out the target geographic coordinate point corresponding to the address query instruction, further obtain target attribute information corresponding to the target geographic coordinate point from the attribute information mapping table, and display the target geographic coordinate point and the target attribute information on a display interface.
Referring to fig. 6, a user selects a start date "2018-01-01" and an end date "2019-01-01" through a dimension pull-down of "policy start period", the parsing module 204 generates a corresponding target query command, the screening module 206 queries and obtains a plurality of target coordinate points and corresponding attribute information nationwide, and the display of the coordinate points and the attribute information is shown in fig. 6.
The invention can inquire according to the data dimension or the limited geographic range, and can effectively improve the inquiry efficiency of the business data because the multi-dimensional inquiry can be carried out and the geographic area can be limited for inquiry.
EXAMPLE III
Fig. 3 is a schematic diagram of a hardware architecture of a computer device according to a third embodiment of the present invention. In the present embodiment, the computer device 2 is a device capable of automatically performing numerical calculation and/or information processing in accordance with a preset or stored instruction. The computer device 2 may be a personal computer, a tablet computer, a mobile phone, or the like, or may be a cloud device for providing a virtual client, such as a rack server, a blade server, a tower server, or a rack server (including an independent server or a server cluster composed of a plurality of servers). As shown, the computer device 2 includes, but is not limited to, at least a memory 21, a processor 22, a network interface 23, and a query system 20 based on business data of the computer device, which are communicatively connected to each other through a system bus. Wherein:
in this embodiment, the memory 21 includes at least one type of computer-readable storage medium including a flash memory, a hard disk, a multimedia card, a card-type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a Read Only Memory (ROM), an Electrically Erasable Programmable Read Only Memory (EEPROM), a Programmable Read Only Memory (PROM), a magnetic memory, a magnetic disk, an optical disk, and the like. In some embodiments, the storage 21 may be an internal storage unit of the computer device 2, such as a hard disk or a memory of the computer device 2. In other embodiments, the memory 21 may also be an external storage device of the computer device 2, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), etc. provided on the computer device 20. Of course, the memory 21 may also comprise both internal and external memory units of the computer device 2. In this embodiment, the memory 21 is generally used to store an operating system and various application software installed in the computer device 2, such as the program code of the query system 20 based on the business data of the computer device in the second embodiment. Further, the memory 21 may also be used to temporarily store various types of data that have been output or are to be output.
The network interface 23 may comprise a wireless network interface or a wired network interface, and the network interface 23 is generally used for establishing communication connection between the computer device 2 and other electronic apparatuses. For example, the network interface 23 is used to connect the computer device 2 to an external terminal through a network, establish a data transmission channel and a communication connection between the computer device 2 and the external terminal, and the like. The network may be a wireless or wired network such as an Intranet (Intranet), the Internet (Internet), a Global System of Mobile communication (GSM), Wideband Code Division Multiple Access (WCDMA), a 4G network, a 5G network, Bluetooth (Bluetooth), Wi-Fi, and the like.
It is noted that fig. 3 only shows the computer device 2 with components 20-23, but it is to be understood that not all shown components are required to be implemented, and that more or less components may be implemented instead.
In this embodiment, the query system 20 based on the service data of the computer device stored in the memory 21 can be further divided into one or more program modules, and the one or more program modules are stored in the memory 21 and executed by one or more processors (in this embodiment, the processor 22) to complete the present invention.
For example, fig. 2 shows a schematic diagram of program modules of a second embodiment of the query system 20 for implementing business data based on a computer device, in this embodiment, the query system 20 for business data may be divided into an obtaining module 200, a mapping module 202, a parsing module 204, a screening module 206, and a display module 208. The program module referred to in the present invention refers to a series of computer program instruction segments capable of performing specific functions, and is more suitable than a program for describing the execution process of the query system 20 of the business data in the computer device 2. The specific functions of the program modules 200 and 208 have been described in detail in the second embodiment, and are not described herein again.
Example four
The present embodiment also provides a computer-readable storage medium, such as a flash memory, a hard disk, a multimedia card, a card-type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a read-only memory (ROM), an electrically erasable programmable read-only memory (EEPROM), a programmable read-only memory (PROM), a magnetic memory, a magnetic disk, an optical disk, a server, an App application mall, etc., on which a computer program is stored, which when executed by a processor implements corresponding functions. The computer-readable storage medium of this embodiment is used for the query system 20 for storing the service data based on the computer device, and when executed by the processor, the query system implements the query method for the service data based on the computer device of the first embodiment.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. A method for querying service data, the method comprising:
acquiring service data, wherein the service data at least comprises: address and other attribute information;
mapping the service data to a preset geographic map according to the address to obtain a geographic coordinate point corresponding to the address, and establishing an attribute information mapping table according to the geographic coordinate point and the other attribute information, wherein the attribute information mapping table is used for mapping a comparison relation between the geographic coordinate point and the attribute information;
acquiring operation information of a user, and analyzing the operation information to obtain a corresponding target address query instruction;
screening out a target geographic coordinate point corresponding to the target address query instruction from the geographic map according to the target address query instruction and the attribute information mapping table;
and acquiring target attribute information corresponding to the target geographic coordinate point according to the target geographic coordinate point and the attribute information mapping table, and displaying the target geographic coordinate point and the target attribute information.
2. The method for querying business data according to claim 1, wherein the step of mapping the business data into a preset geographic map according to the address comprises:
resolving the address into an address field;
matching the address field with a field of a preset address in the preset geographic map, wherein the preset address is preset with a corresponding geographic coordinate point;
and when the matching is successful, mapping the address to a geographic coordinate point corresponding to the address.
3. The method for querying business data according to claim 1, wherein the step of obtaining operation information of a user and analyzing the operation information to obtain a corresponding target address query instruction specifically comprises:
receiving a keyword input by the user through a preset input box or click information of one dimension of a plurality of preset dimensions in a preset pull-down box;
acquiring target service data corresponding to the keyword or the click information according to the keyword or the click information;
and generating the target address query instruction according to the target address in the target service data.
4. The method for querying business data according to claim 1, wherein the step of obtaining operation information of a user and analyzing the operation information to obtain a corresponding target address query instruction further comprises:
receiving operation information of the user for selecting the geographical range;
determining a target address of the target service data in the geographic range according to the geographic range;
and generating the target address query instruction according to the target address of the target service data.
5. The method for querying business data according to claim 4, wherein the step of receiving the operation information of the user for framing the geographic area comprises:
and receiving operation information of drawing a closed graph by the user, wherein the closed graph forms the geographic range.
6. The method for querying business data according to claim 3, wherein before the step of receiving the keyword inputted by the user through the preset input box or the click information of one of the plurality of preset dimensions in the preset drop-down box, the method further comprises:
setting corresponding query dimensions according to other attribute information of the service data, wherein the query dimensions at least comprise: address dimension, number dimension, category dimension, quota dimension, value dimension, and date dimension.
7. A query system for business data, comprising:
an obtaining module, configured to obtain service data, where the service data at least includes: address and other attribute information;
the mapping module is used for mapping the service data into a preset geographic map according to the address to obtain a geographic coordinate point corresponding to the address, and establishing an attribute information mapping table according to the geographic coordinate point and the other attribute information, wherein the attribute information mapping table is used for mapping a comparison relation between the geographic coordinate point and the attribute information;
the analysis module is used for acquiring operation information of a user and analyzing the operation information to obtain a corresponding target address query instruction;
the screening module is used for screening a target geographic coordinate point corresponding to the target address query instruction from the geographic map according to the target address query instruction and the attribute information mapping table;
and the display module is used for acquiring target attribute information corresponding to the target geographic coordinate point according to the target geographic coordinate point and the attribute information mapping table and displaying the target geographic coordinate point and the target attribute information.
8. The query system for business data according to claim 7, wherein said mapping module is further configured to:
resolving the address into an address field;
matching the address field with a field of a preset address in the preset geographic map, wherein the preset address is preset with a corresponding geographic coordinate point;
and when the matching is successful, mapping the address to a geographic coordinate point corresponding to the address.
9. A computer device, characterized by a computer device memory, a processor and a computer program stored on the memory and executable on the processor, which computer program, when executed by the processor, carries out the steps of the query method of business data according to any one of claims 1-6.
10. A computer-readable storage medium, in which a computer program is stored which is executable by at least one processor to cause the at least one processor to perform the steps of the method of querying of traffic data according to any one of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911290688.0A CN111161086A (en) | 2019-12-16 | 2019-12-16 | Method, system, computer equipment and storage medium for inquiring business data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911290688.0A CN111161086A (en) | 2019-12-16 | 2019-12-16 | Method, system, computer equipment and storage medium for inquiring business data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111161086A true CN111161086A (en) | 2020-05-15 |
Family
ID=70557134
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911290688.0A Pending CN111161086A (en) | 2019-12-16 | 2019-12-16 | Method, system, computer equipment and storage medium for inquiring business data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111161086A (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111881385A (en) * | 2020-07-21 | 2020-11-03 | 百度在线网络技术（北京）有限公司 | Push content generation method, device, equipment and readable storage medium |
| CN111950974A (en) * | 2020-07-02 | 2020-11-17 | 广州仓实信息科技有限公司 | Progress information processing method and device, computer equipment and storage medium |
| CN112052409A (en) * | 2020-09-28 | 2020-12-08 | 中国平安人寿保险股份有限公司 | Address resolution method, device, equipment and medium |
| CN112364033A (en) * | 2021-01-13 | 2021-02-12 | 北京云真信科技有限公司 | Data retrieval system |
| CN112435311A (en) * | 2020-12-11 | 2021-03-02 | 上海中通吉网络技术有限公司 | Method and device for generating electronic geo-fence |
| CN112949268A (en) * | 2021-03-25 | 2021-06-11 | 苍穹数码技术股份有限公司 | Form management method, device, equipment and computer readable storage medium |
| CN114528367A (en) * | 2022-02-23 | 2022-05-24 | 重庆允丰科技有限公司 | Service data information statistical method based on digital twin and computer storage medium |
| CN116541421A (en) * | 2023-07-07 | 2023-08-04 | 中关村科学城城市大脑股份有限公司 | Address query information generation method and device, electronic equipment and computer medium |
| CN116743790A (en) * | 2022-09-30 | 2023-09-12 | 腾讯云计算（北京）有限责任公司 | Device data acquisition, device data analysis method and device and computer device |
| CN117131867A (en) * | 2022-05-17 | 2023-11-28 | 贝壳找房(北京)科技有限公司 | Method, apparatus, computer program product and storage medium for splitting house address |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1426876A1 (en) * | 2002-12-04 | 2004-06-09 | H.W.S.- Hardware Solution Limited | Geographical information system |
| CN102446187A (en) * | 2010-10-13 | 2012-05-09 | 上海众恒信息产业股份有限公司 | Service information correlation method and correlation device |
| CN104504045A (en) * | 2014-12-18 | 2015-04-08 | 国家电网公司 | GIS (geographic information system) positioning analysis system based on power customer address word segments |
| CN108198083A (en) * | 2018-01-12 | 2018-06-22 | 平安科技（深圳）有限公司 | Declaration form multi dimensional analysis implementation method, device, terminal device and storage medium |
-
2019
- 2019-12-16 CN CN201911290688.0A patent/CN111161086A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1426876A1 (en) * | 2002-12-04 | 2004-06-09 | H.W.S.- Hardware Solution Limited | Geographical information system |
| CN102446187A (en) * | 2010-10-13 | 2012-05-09 | 上海众恒信息产业股份有限公司 | Service information correlation method and correlation device |
| CN104504045A (en) * | 2014-12-18 | 2015-04-08 | 国家电网公司 | GIS (geographic information system) positioning analysis system based on power customer address word segments |
| CN108198083A (en) * | 2018-01-12 | 2018-06-22 | 平安科技（深圳）有限公司 | Declaration form multi dimensional analysis implementation method, device, terminal device and storage medium |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111950974A (en) * | 2020-07-02 | 2020-11-17 | 广州仓实信息科技有限公司 | Progress information processing method and device, computer equipment and storage medium |
| CN111950974B (en) * | 2020-07-02 | 2024-05-14 | 广州仓实信息科技有限公司 | Progress information processing method, device, computer equipment and storage medium |
| CN111881385A (en) * | 2020-07-21 | 2020-11-03 | 百度在线网络技术（北京）有限公司 | Push content generation method, device, equipment and readable storage medium |
| CN112052409B (en) * | 2020-09-28 | 2023-11-24 | 中国平安人寿保险股份有限公司 | Address resolution method, device, equipment and medium |
| CN112052409A (en) * | 2020-09-28 | 2020-12-08 | 中国平安人寿保险股份有限公司 | Address resolution method, device, equipment and medium |
| CN112435311A (en) * | 2020-12-11 | 2021-03-02 | 上海中通吉网络技术有限公司 | Method and device for generating electronic geo-fence |
| CN112364033A (en) * | 2021-01-13 | 2021-02-12 | 北京云真信科技有限公司 | Data retrieval system |
| CN112949268A (en) * | 2021-03-25 | 2021-06-11 | 苍穹数码技术股份有限公司 | Form management method, device, equipment and computer readable storage medium |
| CN114528367A (en) * | 2022-02-23 | 2022-05-24 | 重庆允丰科技有限公司 | Service data information statistical method based on digital twin and computer storage medium |
| CN117131867A (en) * | 2022-05-17 | 2023-11-28 | 贝壳找房(北京)科技有限公司 | Method, apparatus, computer program product and storage medium for splitting house address |
| CN117131867B (en) * | 2022-05-17 | 2024-05-14 | 贝壳找房(北京)科技有限公司 | Method, apparatus, computer program product and storage medium for splitting house address |
| CN116743790A (en) * | 2022-09-30 | 2023-09-12 | 腾讯云计算（北京）有限责任公司 | Device data acquisition, device data analysis method and device and computer device |
| CN116743790B (en) * | 2022-09-30 | 2024-05-10 | 腾讯云计算（北京）有限责任公司 | Device data acquisition, device data analysis method and device and computer device |
| CN116541421B (en) * | 2023-07-07 | 2023-09-12 | 中关村科学城城市大脑股份有限公司 | Address query information generation method and device, electronic equipment and computer medium |
| CN116541421A (en) * | 2023-07-07 | 2023-08-04 | 中关村科学城城市大脑股份有限公司 | Address query information generation method and device, electronic equipment and computer medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111161086A (en) | Method, system, computer equipment and storage medium for inquiring business data | |
| US11740102B2 (en) | Method, apparatus, device and storage medium for determining point of interest area | |
| US20220067117A1 (en) | System and method for linking data records for parcels | |
| US8306971B2 (en) | Methods and systems of automatically geocoding a dataset for visual analysis | |
| US20140280318A1 (en) | Method and System for Generating a Geocode Trie and Facilitating Reverse Geocode Lookups | |
| US20130041883A1 (en) | Search engine with geographical verification processing | |
| JP2018510410A (en) | Method and apparatus for processing address text | |
| CN105260466A (en) | Picture pushing method and apparatus | |
| US20190095536A1 (en) | Method and device for content recommendation and computer readable storage medium | |
| CN112861972A (en) | Site selection method and device for exhibition area, computer equipment and medium | |
| US9959268B2 (en) | Semantic modeling of geographic information in business intelligence | |
| KR20170073693A (en) | Extracting similar group elements | |
| CN111209487B (en) | User data analysis method, server, and computer-readable storage medium | |
| KR102184048B1 (en) | System and method for checking of information about estate development plan based on geographic information system | |
| US11334216B2 (en) | Systems and methods for visually presenting geospatial information | |
| CN109684425A (en) | Declaration form station address matching process and device | |
| CN112435311A (en) | Method and device for generating electronic geo-fence | |
| JP2003316808A (en) | Map information retrieving, counting and distributing system | |
| CN111339409A (en) | Map display method and system | |
| CN110799969B (en) | Semantic vector tablet | |
| CN111858613B (en) | Service data retrieval method | |
| CN111737330A (en) | Spatial data standardization method and device, computer equipment and storage medium | |
| CN112988933A (en) | Method and device for managing address information | |
| CN110598131B (en) | Method and device for determining user resident area, storage medium and electronic equipment | |
| JP5617027B1 (en) | Information management system and information management program |
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 |