CN110795449A - BS architecture-based environment-friendly public opinion system - Google Patents
BS architecture-based environment-friendly public opinion system Download PDFInfo
- Publication number
- CN110795449A CN110795449A CN201910853147.8A CN201910853147A CN110795449A CN 110795449 A CN110795449 A CN 110795449A CN 201910853147 A CN201910853147 A CN 201910853147A CN 110795449 A CN110795449 A CN 110795449A
- Authority
- CN
- China
- Prior art keywords
- public opinion
- environment
- friendly
- information
- module
- 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
- 238000010276 construction Methods 0.000 claims abstract description 17
- 238000012216 screening Methods 0.000 claims abstract description 5
- 230000007613 environmental effect Effects 0.000 claims description 82
- 238000012544 monitoring process Methods 0.000 claims description 15
- 238000000034 method Methods 0.000 claims description 9
- 230000008569 process Effects 0.000 claims description 7
- 230000001360 synchronised effect Effects 0.000 claims description 5
- 230000005540 biological transmission Effects 0.000 claims description 4
- 238000007621 cluster analysis Methods 0.000 claims description 4
- 238000005259 measurement Methods 0.000 claims description 4
- 230000007935 neutral effect Effects 0.000 claims description 4
- 239000003550 marker Substances 0.000 claims description 3
- 238000012546 transfer Methods 0.000 claims description 3
- 230000000007 visual effect Effects 0.000 claims description 3
- 230000000694 effects Effects 0.000 abstract description 15
- 238000011161 development Methods 0.000 abstract description 5
- 238000007726 management method Methods 0.000 description 27
- 238000010586 diagram Methods 0.000 description 22
- 238000013461 design Methods 0.000 description 19
- 238000003912 environmental pollution Methods 0.000 description 7
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 230000006872 improvement Effects 0.000 description 2
- 238000003780 insertion Methods 0.000 description 2
- 230000037431 insertion Effects 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 239000002689 soil Substances 0.000 description 2
- 238000013316 zoning Methods 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000003933 environmental pollution control Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000014759 maintenance of location Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000003340 mental effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000009877 rendering Methods 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000003911 water pollution Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/101—Collaborative creation, e.g. joint development of products or services
-
- 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
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/26—Government or public services
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Human Resources & Organizations (AREA)
- General Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- Tourism & Hospitality (AREA)
- Data Mining & Analysis (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Economics (AREA)
- Marketing (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Primary Health Care (AREA)
- Educational Administration (AREA)
- General Health & Medical Sciences (AREA)
- Development Economics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides an environment-friendly public opinion system based on BS architecture, which comprises a public opinion map submodule and a public opinion management submodule, wherein the public opinion map submodule is used for counting and screening environment-friendly public opinion data of different areas; the public opinion management submodule is used for providing full-text fuzzy retrieval and accurate retrieval functions for users of the environment-friendly public opinion system, and searching relevant environment-friendly public opinions of input key information from the public opinion information in the public opinion map submodule. The environment-friendly public opinion information management system realizes digital management of environment-friendly public opinion information, provides a technical platform for environment-friendly supervisors to carry out digitalization and informatization office, can crawl, analyze and excavate valuable information and potential rules from massive public opinion information under the support of an environment-friendly public opinion system, assists the development of environment-friendly supervision work, improves the effect and efficiency of environment-friendly supervision, and promotes the informatization construction of environment-friendly work.
Description
Technical Field
The invention relates to an environment-friendly public opinion system based on BS architecture.
Background
At present, the environmental public opinion information of China is complex and diversified, the latest environmental public opinion information is continuously issued and shared by common people by means of the Internet environment and information technology, the numerous and redundant environmental public opinion information brings great workload to environmental monitoring personnel, and the environmental monitoring personnel need to mine and screen out sensitive, popular and high-attention environmental topics from massive and real-time environmental public opinion information as soon as possible so as to guide the social environmental public opinion to move forward towards the correct direction and effectively solve the urgent environmental problem. In view of the above needs, there is a need to establish an environment-friendly public opinion-oriented information management system for performing overall management on environment-friendly public opinion-related information.
Since the nineties of the last century, the concept of ecological restoration and environmental protection gradually started to revive nationwide, and ecological restoration and environmental protection strategies were practiced and implemented at the national level, for example, in order to control northern sandstorm weather from the source, the national and local governments continuously invest in the construction of various protection forests such as northeast protection forest, and the improvement of vegetation coverage on the earth surface, so as to conserve water resources and reduce water and soil loss and soil desertification. In order to solve the problem of water environment pollution in the south, a large amount of manpower and material resources are invested by national and local governments every year to carry out research work on salvaging plankton in water and treating water pollution. From the effect of environmental pollution control, although the environmental pollution problem in China is a link to a certain extent under the heavy promotion of the nation and the society, the environmental pollution problem is not fundamentally restrained. On one hand, the contradiction between the environment and the economy is continuously increased and worsened due to the lack of the participation of the public in the public work of environmental management and protection, the continuously accumulated environmental pollution burden is gradually an important burden influencing the economic development, the contradiction which is difficult to reconcile exists between the increasing material and mental requirements of people and the current situation of the natural environment, the resource environmental utilization exceeding the environmental capacity makes people have strong appeal on environmental protection, but is limited by the limitation of environmental protection force and cannot systematically participate in the development of the environmental protection and management work; environmental pollution and treatment work are highly required to the time efficiency, once environmental pollution is discovered, its treatment should be reluctant, but the environmental protection law enforcement volume of china at present stage is relatively weak, environmental pollution supervision ability is also relatively lagged, point-to-point spot check and supervision mode are difficult to accomplish to environmental pollution's full coverage monitoring and overall management, environmental protection monitoring's time efficiency is relatively poor, this problem has been solved to a certain extent in the proposition of this patent.
Disclosure of Invention
In view of the above, the present invention is directed to an environment-friendly public opinion system based on BS architecture to solve the above-mentioned problems in the background art.
In order to achieve the purpose, the technical scheme of the invention is realized as follows:
the BS architecture-based environment-friendly public opinion system comprises a public opinion map submodule and a public opinion management submodule, wherein the public opinion map submodule is used for counting and screening environment-friendly public opinion data of different areas;
the public opinion management submodule is used for providing full-text fuzzy retrieval and accurate retrieval functions for users of the environment-friendly public opinion system, and searching relevant environment-friendly public opinions of input key information from public opinion information in the public opinion map submodule.
Furthermore, the public opinion map sub-module comprises a region list display module, a public opinion instrument panel, a public opinion head module and a map display module;
the region list display module takes a region as a statistical object, performs list statistics on public opinion information issued by the region, and visually displays the environment-friendly public opinion issuing conditions of different regions;
the public opinion instrument panel is used for counting the public opinion total number, the positive side total number supported by the environment-friendly public opinion, the negative side total number supported by the environment-friendly public opinion and the neutral side total number supported by the environment-friendly public opinion at a certain time according to time, and showing the attention and support state of the public opinion by a visual pie chart and numerical values;
the public opinion initial module is used for screening out environment-friendly public opinion focus information of Top10 by taking the attention of the environment-friendly public opinion event as a measurement index and displaying the environment-friendly public opinion focus information in a list;
the map display module is used for displaying the spatial distribution information of the environmental protection public sentiment on the map in the form of regional environmental protection public sentiment information spatial clustering and spatial data marking.
Further, the public opinion management submodule comprises an article storage module, an article synchronization module and a page retrieval module;
the article storage module is used for constructing an index before the environmental protection public opinion information and the articles are stored, and storing the index and the articles into a database after an index library is formed, so that full-text retrieval can be conveniently carried out on the environmental protection public opinion information according to keywords in the later period;
the article synchronization module is used for keeping the synchronization between the environment-friendly public opinion information database and the environment-friendly public opinion information search database and providing a synchronous public opinion information source for the overall management of the environment-friendly public opinion information and the full text search;
the page retrieval module is used for providing a full-text retrieval function of the environment-friendly public sentiment articles for the user.
Furthermore, the region list display module also comprises an inquiry operation on the environment-friendly public opinion information, after a user logs in a system, the region information is filled in a region list interface, the region information is submitted to a background server and an inquiry SQL sentence is constructed, the background database executes the inquiry sentence to match the region information and returns a result, the result comprises two types of inquiry environment-friendly public opinion information and non-inquiry environment-friendly public opinion information, the number of inquiry result lines is 1, the region list interface is used for performing list display, and the list displays environment-friendly public opinion information sources, related regions, related titles, public opinion information release time and access links of the public opinion information of the governed region; if 0, the user displays 'no environmental public opinion information in the area'.
Further, the map display module realizes the following processes:
(1) the front-end query condition is transmitted to the background through ajax
The front end constructs ajax transmission parameters by taking the current time as a condition, and transmits the query condition of the front end to the background through the matching of ajax and struts.xml;
(2) constructing query SQL statement, connecting database and querying
Combining the query conditions received by the background, constructing a query SQL statement, and counting the quantity of the environment-friendly public opinion information in the latest time period of different cities by using a group by statement;
and realizing the cluster analysis of the urban environment-friendly public opinion information by w BMaplib.
(3) And transmitting the query result to a front end, analyzing JSON format data by the front end, calling a Baidu map API (application programming interface), constructing a marker array, and calling new BMaplib.
Further, the article warehousing module is implemented as follows:
(1) the front-end query condition is transmitted to the background through ajax
Establishing ajax for transmitting user input parameters of a front end, including but not limited to article titles, article labels, article contents, publishers and publication time, and transmitting input conditions of the front end to a background through the cooperation of ajax and struts.xml;
(2) background receives parameters transmitted by front end to carry out text construction and index construction
And after receiving the parameters transmitted from the front end, the background corresponds the parameters to the solr index construction and text storage codes to finish the article warehousing operation.
Further, the article synchronization module implements the following process:
(1) writes a property file and copies the file into apache-tomcat-7.0.72\ webapps \ solr \ WEB-INF \ lib;
(2) and adding a monitoring configuration in a web.xml file under an apache-tomcat-7.0.72\ webapps \ solr \ WEB-INF directory.
Further, the page retrieval module implements the following process:
(1) the front-end query condition is transmitted to the background through ajax
The front end constructs ajax transmission parameters by taking the release time, the article keywords and the like as retrieval conditions, and transmits the retrieval conditions of the front end to the background by matching ajax and struts;
(2) the background receives the query parameters transmitted by the front end and carries out Solr query
After analyzing the parameters transmitted by the ajax, the background queries the Solr index file by using query conditions such as keywords, release time and the like;
(3) retrieval result list display
The background transmits the full-text retrieval result to the front end, and the front end displays the retrieval result in a table.
Compared with the prior art, the BS architecture-based environment-friendly public opinion system has the following advantages:
(1) the invention realizes the overall management of public opinion retention related information, breaks through the information gap between the common people and the development of environmental protection work, opens an environmental protection information sharing and publishing channel and platform to the public, enables the common people to participate in ecological restoration and environmental protection work by the identity of 'VGI', and creates a good atmosphere which is concerned about supporting the environmental protection work in the whole society
(2) According to the invention, a good public interaction mechanism can be constructed by virtue of an environment-friendly public opinion system, the short-board problems such as time lag and the like existing in the conventional environment-friendly public opinion information acquisition are changed, and the sudden problems are solved, so that the collection channel of the environment-friendly public opinions is greatly enriched, and the quantity and the coverage of the environment-friendly public opinions are improved in an all-round way;
(3) the invention realizes the digital management of the environmental protection public opinion information by the information technology, provides a technical platform for the environmental protection monitoring personnel to carry out digitalization and informatization office, can crawl, analyze and excavate valuable information and potential rules from massive public opinion information under the support of an environmental protection public opinion system, assists the development of environmental protection monitoring work, improves the effect and efficiency of environmental protection monitoring, and promotes the informatization construction of the environmental protection work.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate an embodiment of the invention and, together with the description, serve to explain the invention and not to limit the invention. In the drawings:
fig. 1 is a flow chart of public opinion display service according to an embodiment of the present invention;
fig. 2 is a flow chart of public opinion management service according to an embodiment of the present invention;
fig. 3 is a design diagram of an environment-friendly public opinion region list display module according to an embodiment of the present invention;
fig. 4 is a design diagram of an environment-friendly public opinion dashboard display module according to an embodiment of the present invention;
fig. 5 is a design diagram of an environment-friendly public opinion headline display module according to an embodiment of the invention;
fig. 6 is a design diagram of an environment-friendly public opinion map display module according to an embodiment of the present invention;
fig. 7 is a schematic diagram of a public opinion management sub-function module of an environmental public opinion system according to an embodiment of the invention;
FIG. 8 is a flowchart illustrating the design of an article warehousing module according to an embodiment of the present invention;
FIG. 9 is a flowchart of an article synchronization module according to an embodiment of the present invention;
fig. 10 is a design diagram of an environmental public opinion page retrieval module according to an embodiment of the present invention;
fig. 11 is a diagram illustrating a regional environment-friendly public opinion information query activity according to an embodiment of the present invention;
fig. 12 is a sequence diagram illustrating a query operation of regional environmental public opinion information according to an embodiment of the present invention;
fig. 13 is a diagram of public opinion zoning quantity statistics activity according to an embodiment of the present invention;
fig. 14 is a timing diagram illustrating a public opinion zoning quantity statistics operation according to an embodiment of the invention;
FIG. 15 is an insert activity diagram of an article according to an embodiment of the present invention;
FIG. 16 is a timing diagram illustrating an article information insertion operation according to an embodiment of the present invention;
FIG. 17 is a schematic diagram of an article synchronization configuration interface according to an embodiment of the present invention;
FIG. 18 is a diagram illustrating the activity of an article retrieval operation according to an embodiment of the present invention;
fig. 19 is a timing diagram illustrating an article query operation according to an embodiment of the present invention.
Detailed Description
It should be noted that the embodiments and features of the embodiments of the present invention may be combined with each other without conflict.
The present invention will be described in detail below with reference to the embodiments with reference to the attached drawings.
The environmental protection public opinion system needs to be based on comprehensively showing regional environmental protection public opinion information in regions, the showing forms are various, the system comprises a list, an instrument panel and the like, the service flow of public opinion showing activities is analyzed, public opinion showing comprises public opinion monitoring personnel, environmental protection public opinion information and a system triplex, the monitoring personnel log in the system, the environmental protection public opinion information existing in the system is checked, especially to the public opinion information with higher popularity, the monitoring personnel can pay high attention to the public opinion information, the hotspot public opinion and abnormal information are captured through different showing forms, and the service flow chart of the public opinion showing is shown as figure 1.
The environmental protection public opinion information is fast to update, the size is huge, environmental protection public opinion in the environmental protection public opinion system comes from different channels, and appears in the form of text mostly, the original public opinion management is mainly based on activities such as manually picking key words, splicing public opinion information and the like, and the management efficiency is low. The method comprises the steps of analyzing the business process of public opinion management activities, wherein the public opinion management comprises four parts, namely public opinion management personnel, Solr technology, a Solr index library and an environment-friendly public opinion database, and the business process chart of the public opinion management is shown in figure 2.
The invention thus provides an environment-friendly public opinion system based on BS architecture, the public opinion system comprises the following:
public opinion map submodule
(1) Region list
The region list is used for carrying out list statistics on the public sentiment information issued by the region by taking the region as a statistical object, and intuitively displaying the environment-friendly public sentiment issuing conditions of different regions. The main design flow of the region list display module is as follows: the user logs in the environmental protection public opinion system and enters the public opinion region list display function module of the public opinion map module, and can perform corresponding authority operation on the environmental protection public opinion information according to different user authorities, for example, a system manager and an environmental protection public opinion manager can add, delete, modify and query the environmental protection public opinion information, an environmental protection public opinion supervisor only has the authority to query the environmental protection public opinion information, and the design diagram of the environmental protection public opinion information region list display module is shown in fig. 3.
The region list module is realized by the following steps:
the users of the region list module comprise system managers, environment-friendly public opinion managers and environment-friendly public opinion supervisors, interfaces visited by users with different roles are different, the environment-friendly public opinion managers are taken as an example, after the users log in the environment-friendly public opinion system and enter the region list module, the environment-friendly public opinion information of the jurisdiction region and the prefecture county district under the jurisdiction region can be displayed according to the authority list of the logged-in users, in the region list module, the environment-friendly public opinion supervisors can inquire the environment-friendly public opinion information, and the activity flow is as follows: a user logs in the environmental protection public opinion system, enters a region list module, inputs a region name, clicks 'query', transmits the region name to a background server, the background server constructs a query SQL statement according to the query region name, queries in a database and returns a query result to a front-end interface, and fig. 11 shows a regional environmental protection public opinion information query activity diagram.
The operation of inquiring the regional environmental protection public opinion information mainly relates to three objects of a system user, a regional list interface and a background database, and the time sequence relation of inquiring the regional environmental protection public opinion information is shown in the figure. After a user logs in a system, filling region information (such as Beijing city) on a region list interface, submitting the region information to a background server and constructing an inquiry SQL statement, executing the inquiry statement by a background database to match the region information, returning a result, wherein the result comprises two types of inquiry to environment-friendly public opinion information and non-inquiry to environment-friendly public opinion information, and displaying the list on the region list interface when the number of inquiry result lines is 1, wherein the list shows environment-friendly public opinion information sources, related regions, titles, public opinion information release time and access links of the public opinion information of the governed region; if 0, the user displays 'no environmental public opinion information in the area'. Fig. 12 is a sequence diagram of operations for querying regional environmental public opinion information.
The realization of the region list function module mainly depends on the connection of background service and database and the query of database SQL statement.
(2) Public opinion instrument panel
The public opinion dashboard is used for counting the public opinion total number, the positive total number supported by the environment-friendly public opinion, the negative total number supported by the environment-friendly public opinion and the neutral total number supported by the environment-friendly public opinion at a certain time according to the time (year/month/day), and showing the attention and the support state of the public opinion by a visual pie chart and numerical values. The main design flow of the public opinion instrument panel module is as follows: the user logs in the environment-friendly public opinion system and enters a public opinion dashboard display function module of the public opinion map module, the public opinion dashboard function module inquires and calculates corresponding public opinion quantity information from the environment-friendly public opinion database and displays a pie chart at the front end, and a design chart of the environment-friendly public opinion information dashboard display module is shown in fig. 4.
(3) Public opinion headline
The public opinion event module takes the attention of the environment-friendly public opinion event as a measurement index to screen out environment-friendly public opinion focus information of Top10 and display the information in a list. The main design flow of the public opinion headline module is as follows: the method comprises the steps that a user logs in an environment-friendly public opinion system and enters a public opinion top display function module of a public opinion map module, the public opinion top function module takes the comment quantity (positive, negative and neutral) of an article as a measurement standard, the comment quantity of each article is counted from an environment-friendly public opinion database, ten groups of environment-friendly public opinion titles with the highest comment quantity and article hyperlink information are displayed in a parallel table mode to serve as public opinion top, and a design diagram of the environment-friendly public opinion top display module is shown in figure 5.
(4) Map display
The map display is to display the spatial distribution information of the environmental protection public sentiment on the map in the form of regional environmental protection public sentiment information spatial clustering and spatial data marking. The map display function is similar to the public opinion region list display function, and is only different forms adopted in the front-end expression and rendering, and the main design flow of the environment-friendly public opinion map display module is as follows: the user logs in the environment-friendly public opinion system and enters a map display function module of a public opinion map module, the map display function module is used for summarizing real-time environment-friendly public opinion article data of different regions from an environment-friendly public opinion database, assigning the data to region point data, and performing cluster analysis and cluster display on the environment-friendly public opinion article data of the space point positions by means of a spatial clustering algorithm, wherein a design diagram of the environment-friendly public opinion map display module is shown in fig. 6.
The map display module is realized by the following steps:
the map display module is used for superposing environment-friendly public opinion spatial distribution point location information by taking an environment-friendly public opinion publishing city as a coordinate on a map with a Baidu map as a base map, and then realizing cluster analysis on the environment-friendly public opinion point location data by utilizing a Markercuster function provided by an API (application program interface), and the map display module has the following realization process:
(1) the front-end query condition is transmitted to the background through ajax
The front end constructs ajax transfer parameters by taking the current time as a condition, and transmits the query condition of the front end to the background through matching of ajax and struts.
(2) Constructing query SQL statement, connecting database and querying
And combining the query conditions received by the background, constructing a query SQL statement, and counting the quantity of the environment-friendly public opinion information in the latest time period of different cities by using a group by statement, wherein specific codes are not repeated.
(3) And transmitting the query result (the quantity of the environment-friendly public opinion information corresponding to different city IDs stored in a JSON format) to the front end, analyzing the data in the JSON format by the front end, calling a Baidu map API (application program interface), constructing a marker array, and calling newBMapLib.
As can be seen from the above analysis, the core of the map display is to inquire the region and quantity of public sentiment information, and the activity diagram is shown in fig. 13.
The users of the map display module include system management personnel, environmental protection public opinion management personnel and environmental protection public opinion monitoring personnel, taking the environmental protection public opinion monitoring personnel as an example, after logging in the environmental protection public opinion system and entering the map display module, the users can inquire the quantity of the environmental protection public opinion information in different regions through time and perform spatial clustering display on a Baidu map, and the operation sequence chart of public opinion regional quantity statistics is shown in fig. 14.
Public opinion management submodule
The public opinion management submodule in the environment-friendly public opinion system is used for providing full-text fuzzy retrieval and accurate retrieval functions for users of the environment-friendly public opinion system and helping the users to search relevant environment-friendly public opinions of input key information from massive environment-friendly public opinion information, and mainly comprises three subfunction modules, namely article storage, article synchronization and page retrieval, and the subfunction modules are shown in fig. 7.
(1) Article warehousing
The article warehousing function module is biased to background management, and mainly conducts index construction before the environmental protection public sentiment information and the articles are stored, and the indexes and the articles are stored in the database after an index library is formed, so that full-text retrieval can be conducted on the environmental protection public sentiment information according to keywords at a later stage. The Solr search engine is introduced to carry out storage processing and index construction on the environmental protection public sentiment articles, when the environmental protection public sentiment articles are newly added, the request of the Solr server side is firstly obtained, then the articles are constructed, fields are added into the articles, and the fields are submitted to the Solr server to update an index base of the environmental protection public sentiment articles. The background design flow of the article warehousing module is shown in fig. 8.
The article warehousing module is implemented as follows:
the article warehousing function module is biased to background management, and mainly conducts index construction before the environmental protection public sentiment information and the articles are stored, and the indexes and the articles are stored in the database after an index library is formed, so that full-text retrieval can be conducted on the environmental protection public sentiment information according to keywords at a later stage. The module introduces a Solr search engine to carry out warehousing processing and index construction on the environment-friendly public sentiment articles, is realized on the basis of a search engine Solr, encapsulates the corresponding relation of the article entities in the index fields in the Solr, configures Chinese participles, sets the participle types of each field and encapsulates a Solr warehousing interface API. The implementation flow of article warehousing and index construction based on Solr is as follows:
(1) the front-end query condition is transmitted to the background through ajax
Establishing ajax for user input parameters (article titles, article labels, article contents, publishers, publication time and the like) at the front end for transmission, and transmitting the input conditions at the front end to the background through the cooperation of ajax and struts.
(2) Background receives parameters transmitted by front end to carry out text construction and index construction
After receiving the parameters transmitted from the front end, the background corresponds the parameters to the solr index construction and text storage codes, and then the article warehousing operation can be completed.
As can be seen from the above analysis, the core of article storage is to insert article information into the database, and the activity graph is shown in fig. 15.
The user of the article warehousing module comprises a system manager and an environment-friendly public sentiment manager, for example, after the system manager logs in an environment-friendly public sentiment system and enters the article warehousing module, the user can fill the relevant information of the environment-friendly public sentiment article into a corresponding text box, click the warehousing submission, and then input the environment-friendly public sentiment article into a database and construct an index of the article, the information to be filled in the article warehousing comprises article types, article labels, publishers, publishing units, publishing time, article titles, article contents and the like, and the article information insertion operation timing chart is shown in fig. 16.
(2) Article synchronization
The article synchronization function module is biased to background management and used for keeping the environment-friendly public opinion information database and the environment-friendly public opinion information search library synchronous and providing a synchronous public opinion information source for environment-friendly public opinion information overall management and full text search. The background design flow of the article synchronization module is shown in the figure, and the search service and the index storage service are used as a link between the text data and the index data of the public sentiment articles, so that the corresponding public sentiment articles can be searched by the index data, and the text change and the index data update can be synchronized. Fig. 9 is a flow chart of the article synchronization module design.
The article synchronization module is implemented as follows:
the article synchronization belongs to a background service module, and after the article information in the database is updated, the Solr index should be updated synchronously so as to ensure the consistency of the index file and the data file.
The background implementation steps of the regular synchronization of the articles are as follows:
1. properties file is written and copied into apache-tomcat-7.0.72\ webapps \ solr \ WEB-INF \ lib.
2. The monitoring configuration is added to the web.xml file under the apache-tomcat-7.0.72\ webapps \ solr \ WEB-INF directory, and the configuration interface is shown in FIG. 17.
(3) Page retrieval
The page retrieval aims at providing a full-text retrieval function of an environment-friendly public sentiment article for a user, and a main design flow of a page retrieval module is as follows: the user logs in the environment-friendly public opinion system and enters a page retrieval function module of the public opinion management module, the user inputs keywords, selects a designated area and a time range generated by the environment-friendly public opinion, the page retrieval function module retrieves articles from an environment-friendly public opinion database and an article index database according to retrieval conditions and displays titles and access links of the retrieved related articles in a list, and a design drawing of the page retrieval module is shown as fig. 10.
The page retrieval module is implemented as follows:
the page retrieval aims at providing a full text retrieval function of an environment-friendly public sentiment article for a user, and the implementation flow is as follows:
(1) the front-end query condition is transmitted to the background through ajax
The front end constructs ajax transfer parameters by taking the release time, the article keywords and the like as retrieval conditions, and transmits the retrieval conditions of the front end to the background through the matching of ajax and struts.
(2) The background receives the query parameters transmitted by the front end and carries out Solr query
And after analyzing the parameters transmitted by the ajax, the background queries the Solr index file by using query conditions such as keywords, release time and the like.
(3) Retrieval result list display
The background transmits the full-text retrieval result to the front end, and the front end displays the retrieval result in a table mode, which is not described in detail.
As can be seen from the above analysis, the core of the article search is to perform an article query operation on the Solr database, and the activity diagram is shown in fig. 18.
The users of the page retrieval module include system managers, environmental protection public opinion supervisors, and the environmental protection public opinion supervisors, for example, after logging in the environmental protection public opinion system and entering the page retrieval module, can input query parameters such as release time and keywords to retrieve the environmental protection public opinion articles in full text, and the operation sequence chart of article query is shown in fig. 19.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (8)
1. BS framework-based environment-friendly public opinion system is characterized in that: comprises a public opinion map submodule and a public opinion management submodule,
the public opinion map submodule is used for counting and screening environment-friendly public opinion data in different areas;
the public opinion management submodule is used for providing full-text fuzzy retrieval and accurate retrieval functions for users of the environment-friendly public opinion system, and searching relevant environment-friendly public opinions of input key information from the public opinion information in the public opinion map submodule.
2. The BS-architecture-based environmental public opinion system as claimed in claim 1, wherein: the public opinion map sub-module comprises a region list display module, a public opinion instrument panel, a public opinion head module and a map display module;
the region list display module takes a region as a statistical object, performs list statistics on public opinion information issued by the region, and visually displays the environment-friendly public opinion issuing conditions of different regions;
the public opinion instrument panel is used for counting the public opinion total number, the positive total number supported by the environment-friendly public opinion, the negative total number supported by the environment-friendly public opinion and the neutral total number supported by the environment-friendly public opinion at a certain time according to time, and showing the attention and support state of the public opinion by a visual pie chart and numerical values;
the public opinion initial module is used for screening out environment-friendly public opinion focus information of Top10 by taking the attention of the environment-friendly public opinion event as a measurement index and displaying the environment-friendly public opinion focus information in a list;
the map display module is used for displaying the spatial distribution information of the environmental protection public sentiment on the map in the form of regional environmental protection public sentiment information spatial clustering and spatial data marking.
3. The BS-architecture-based environmental public opinion system as claimed in claim 1, wherein: the public opinion management submodule comprises an article warehousing module, an article synchronization module and a page retrieval module;
the article storage module is used for constructing an index before the environmental protection public opinion information and the articles are stored, and storing the index and the articles into a database after an index library is formed, so that full-text retrieval can be conveniently carried out on the environmental protection public opinion information according to keywords in the later period;
the article synchronization module is used for keeping the synchronization between the environment-friendly public opinion information database and the environment-friendly public opinion information search database and providing a synchronous public opinion information source for the overall management of the environment-friendly public opinion information and the full text search;
the page retrieval module is used for providing a full-text retrieval function of the environment-friendly public sentiment articles for the user.
4. The BS-based environment-friendly public opinion system as claimed in claim 2, wherein: the region list display module also comprises query operation on the environment-friendly public opinion information, after a user logs in a system, the region information is filled in a region list interface, the region information is submitted to a background server and a query SQL sentence is constructed, the background database executes the query sentence to match the region information and returns a result, the result comprises two types of queried environment-friendly public opinion information and un-queried environment-friendly public opinion information, the number of query result lines is 1, then the region list interface is subjected to list display, and the environment-friendly public opinion information sources, related regions, titles, public opinion information release time and public opinion information access links of the region to be governed are displayed in the list; if 0, the user displays 'no environmental public opinion information in the area'.
5. The BS-based environment-friendly public opinion system as claimed in claim 2, wherein: the map display module realizes the following processes:
(1) the front-end query condition is transmitted to the background through ajax
The front end constructs ajax transmission parameters by taking the current time as a condition, and transmits the query condition of the front end to the background through the matching of ajax and struts.xml;
(2) constructing query SQL statement, connecting database and querying
Combining the query conditions received by the background, constructing a query SQL statement, and counting the quantity of the environment-friendly public opinion information in the latest time period of different cities by using a group by statement;
realizing the cluster analysis of urban environment-friendly public opinion information by w BMaplib and MarkerCluster;
(3) and transmitting the query result to a front end, analyzing JSON format data by the front end, calling a Baidu map API (application programming interface), constructing a marker array, and calling new BMaplib.
6. The BS-based environment-friendly public opinion system as claimed in claim 3, wherein: the article warehousing module is implemented as follows:
(1) the front-end query condition is transmitted to the background through ajax
Establishing ajax for transmitting user input parameters of a front end, including but not limited to article titles, article labels, article contents, publishers and publication time, and transmitting input conditions of the front end to a background through the cooperation of ajax and struts.xml;
(2) background receives parameters transmitted by front end to carry out text construction and index construction
And after receiving the parameters transmitted from the front end, the background corresponds the parameters to the solr index construction and text storage codes to finish the article warehousing operation.
7. The BS-based environment-friendly public opinion system as claimed in claim 3, wherein: the article synchronization module is implemented as follows:
(1) writes a property file and copies the file into apache-tomcat-7.0.72\ webapps \ solr \ WEB-INF \ lib;
(2) and adding a monitoring configuration in a web.xml file under an apache-tomcat-7.0.72\ webapps \ solr \ WEB-INF directory.
8. The BS-based environment-friendly public opinion system as claimed in claim 3, wherein: the page retrieval module is implemented as follows:
(1) the front-end query condition is transmitted to the background through ajax
The front end constructs ajax transfer parameters by taking the release time, the article keywords and the like as retrieval conditions, and transmits the retrieval conditions of the front end to the background through the matching of ajax and struts.xml;
(2) the background receives the query parameters transmitted by the front end and carries out Solr query
After analyzing the parameters transmitted by the ajax, the background queries the Solr index file by using query conditions such as keywords, release time and the like;
(3) retrieval result list display
The background transmits the full-text retrieval result to the front end, and the front end displays the retrieval result in a table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910853147.8A CN110795449A (en) | 2019-09-10 | 2019-09-10 | BS architecture-based environment-friendly public opinion system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910853147.8A CN110795449A (en) | 2019-09-10 | 2019-09-10 | BS architecture-based environment-friendly public opinion system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110795449A true CN110795449A (en) | 2020-02-14 |
Family
ID=69427339
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910853147.8A Pending CN110795449A (en) | 2019-09-10 | 2019-09-10 | BS architecture-based environment-friendly public opinion system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110795449A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113032656A (en) * | 2021-04-23 | 2021-06-25 | 中南大学 | Key phrase-based cloud platform combined database management method and system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102779174A (en) * | 2012-06-26 | 2012-11-14 | 北京奇虎科技有限公司 | Public opinion information display system and method |
| CN104516979A (en) * | 2014-12-31 | 2015-04-15 | 北京锐安科技有限公司 | Data query method and data query system based on quadratic search |
| CN108021651A (en) * | 2017-11-30 | 2018-05-11 | 中科金联（北京）科技有限公司 | Network public opinion risk assessment method and device |
| CN108304172A (en) * | 2017-01-13 | 2018-07-20 | 北京畅游天下网络技术有限公司 | A kind of web development approaches and web develop engine |
| CN108363731A (en) * | 2018-01-15 | 2018-08-03 | 阿里巴巴集团控股有限公司 | A kind of service publishing method, device and electronic equipment |
| CN109145216A (en) * | 2018-08-29 | 2019-01-04 | 中国平安保险(集团)股份有限公司 | Network public-opinion monitoring method, device and storage medium |
-
2019
- 2019-09-10 CN CN201910853147.8A patent/CN110795449A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102779174A (en) * | 2012-06-26 | 2012-11-14 | 北京奇虎科技有限公司 | Public opinion information display system and method |
| CN104516979A (en) * | 2014-12-31 | 2015-04-15 | 北京锐安科技有限公司 | Data query method and data query system based on quadratic search |
| CN108304172A (en) * | 2017-01-13 | 2018-07-20 | 北京畅游天下网络技术有限公司 | A kind of web development approaches and web develop engine |
| CN108021651A (en) * | 2017-11-30 | 2018-05-11 | 中科金联（北京）科技有限公司 | Network public opinion risk assessment method and device |
| CN108363731A (en) * | 2018-01-15 | 2018-08-03 | 阿里巴巴集团控股有限公司 | A kind of service publishing method, device and electronic equipment |
| CN109145216A (en) * | 2018-08-29 | 2019-01-04 | 中国平安保险(集团)股份有限公司 | Network public-opinion monitoring method, device and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| 刘德鹏: ""互联网舆情监控分析***的研究与实现"", 《CNKI》 * |
| 应伟军: ""实时网络舆情监测***的设计与实现"", 《CNKI》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113032656A (en) * | 2021-04-23 | 2021-06-25 | 中南大学 | Key phrase-based cloud platform combined database management method and system |
| CN113032656B (en) * | 2021-04-23 | 2023-09-26 | 中南大学 | Cloud platform combined database management method and system based on key word group |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110866123B (en) | Method for constructing data map based on data model and system for constructing data map | |
| CN110310051A (en) | A kind of wisdom garden management method being automatically imported and dynamically update business data | |
| CN110336886A (en) | A kind of multiagent, multi-user, multiple terminals collaboration wisdom garden cloud service system | |
| CN103390039A (en) | Urban disaster thematic map real-time generating method based on network information | |
| CN109542967A (en) | Smart city data-sharing systems and method based on XBRL standard | |
| CN111949724A (en) | Intellectual property big data platform | |
| US20200334314A1 (en) | Emergency disposal support system | |
| CN101957860B (en) | Method and device for releasing and searching information | |
| Teo et al. | A novel systematic approach of constructing protests repertoires from social media: comparing the roles of organizational and non-organizational actors in social movement | |
| CN116842255A (en) | Accident data management method, visualization system and display method based on metallurgical industry | |
| CN105069665A (en) | Sorting and display method and apparatus of multi-channel off-site advertisement report data | |
| CN114637740A (en) | Novel map platform construction method based on knowledge representation and knowledge extraction | |
| CN110795449A (en) | BS architecture-based environment-friendly public opinion system | |
| CN109189873A (en) | A kind of Meteorological Services big data monitoring analysis system platform | |
| CN111382165A (en) | Mobile homeland management system | |
| CN116578628A (en) | Yangtze river channel big data service analysis method and apparatus | |
| CN113177715B (en) | Municipal works planning management system in earlier stage based on BIM and GIS | |
| Silfianti et al. | Do Indonesian Province Website Rich and Popular | |
| CN114238531A (en) | Method and device for drawing mechanism resources | |
| Bao | The application of big data technology in the research of ancient Chinese silk road | |
| CN113590684A (en) | Non-tax payment big data analysis system | |
| CN111538732A (en) | Natural resource asset liability management system based on big data | |
| CN115269500B (en) | Ecological environment data storage method, ecological environment data retrieval method and electronic equipment | |
| Qu | Urban Governance Research in China (2012-2022): Progress and Reflections | |
| Lin et al. | Design and Implementation of Lujiazui Land Management Information System Based on WebGIS |
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 |