CN113742558A - Query method, system, equipment and medium compatible and concurrent with multiple databases - Google Patents
Query method, system, equipment and medium compatible and concurrent with multiple databases Download PDFInfo
- Publication number
- CN113742558A CN113742558A CN202111006990.6A CN202111006990A CN113742558A CN 113742558 A CN113742558 A CN 113742558A CN 202111006990 A CN202111006990 A CN 202111006990A CN 113742558 A CN113742558 A CN 113742558A
- Authority
- CN
- China
- Prior art keywords
- information
- query
- key field
- interface
- query key
- 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
- 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/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
-
- 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/9535—Search customisation based on user profiles and personalisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/253—Grammatical analysis; Style critique
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/279—Recognition of textual entities
- G06F40/289—Phrasal analysis, e.g. finite state techniques or chunking
Abstract
The invention provides a query method, a system, equipment and a medium compatible and coexisting with various databases, which are characterized in that interface information of various databases is obtained, the interface information comprises access grammars corresponding to the various databases one by one, the interface information is integrated and packaged to form packaging interfaces, the databases are connected, a public sentiment analysis platform and the packaging interfaces are connected through a preset system interface, information sentences to be queried are input into a query inlet of the public sentiment analysis platform by a user, key words are extracted to generate query key fields, database query sentences for querying the query key fields corresponding to the databases are generated according to the query key fields, information containing the query key fields is obtained and sequenced, a sorting table and an integrated general sorting table of the databases are generated, the sorting table and the general sorting table are subjected to visual processing and then pushed to the public sentiment analysis platform, the method and the device realize the inquiry of information of multiple databases at the same time, and improve the efficiency of inquiring public opinion information from multiple databases.
Description
Technical Field
The invention relates to the field of network public sentiment, in particular to a method, a system, equipment and a medium for inquiring compatibility and coexistence of various databases.
Background
Under the wave of internet information, the information transmission speed is very fast, the fermentation speed of negative public opinions is far beyond the imagination of people, the negative public opinions can arouse negative feelings of people and even influence the public acceptance of the people to the government, so that the whole-network public opinions need to be observed and analyzed in real time, the negative information can be recognized in advance, correct countermeasures can be taken, the loss which is difficult to estimate is avoided, and the whole-network observation and real-time analysis and storage of the public opinion system provide great challenges for a database of the public opinion analysis system. The traditional data integration technology cannot meet the requirement that network public opinion analysis can timely acquire more updated and more comprehensive data, and the multi-database technology provides an effective method for integrating a plurality of heterogeneous data sources and realizing information sharing.
At present, domestic main public opinion information source platforms are numerous and comprise micro blogs, micro mails and news media clients, the platforms are various, used databases are different, and the databases have different access environments and organizational structures aiming at different environments and different requirements, so that public opinion data associated with the platforms are difficult to integrate; meanwhile, the data access amount of each platform is increased continuously, the data amount is expanded continuously, and the difficulty of data acquisition is increased.
The user of each platform is different, and the field is different, so the development and propagation speed of the public sentiment on each platform is also different, and even if the data of each platform is obtained, the difference of the platforms also increases difficulty for public sentiment analysis.
It is to be noted that the information invented in the background section above is only for enhancement of understanding of the background of the present disclosure, and therefore, may include information that does not constitute prior art known to those of ordinary skill in the art.
Disclosure of Invention
In view of this, the invention provides a query method, a query system, a query device and a query medium which are compatible and coexisting with various databases, and is used for solving the problem that the efficiency is not high when public opinion data are obtained from various databases at present. Therefore, the invention provides a query method, a system, equipment and a medium with compatibility and coexistence of various databases, simultaneously accesses the various databases to acquire public opinion data in real time, and improves the acquisition efficiency of network public opinion data; meanwhile, the acquired public opinion data are subjected to preliminary processing, public opinion analysis can be conveniently carried out on the data by workers, and processing strategies for dealing with the development of the public opinions of different platforms are generated.
The technical scheme of the invention is realized as follows:
the invention discloses a query method for compatibility and coexistence of multiple databases in a first aspect, which comprises the following steps:
s1, presetting a query entry and a system interface in the public opinion analysis system, acquiring interface information of various databases, and integrally packaging the interface information to form a packaging interface;
s2, connecting the public opinion analysis system with a packaging interface through the system interface, and connecting various databases with the packaging interface;
s3, obtaining the information sentence to be inquired input by the user in the inquiry entrance, extracting the key field from the sentence as the inquiry key field, forming the access inquiry sentence which is one-to-one corresponding to various databases and is used for inquiring the inquiry key field through the packaging interface; accessing various databases through the access query statement to acquire information containing the query key fields in the various databases;
and S4, sequencing the acquired information, performing visualization processing, and pushing the visualized information to a display interface of the public opinion analysis system.
According to the public opinion analysis system and the public opinion analysis method, the public opinion analysis system is connected with various databases through the system interface and the packaging interface, data can be conveniently and simultaneously acquired from the various databases, and the data acquisition efficiency is improved.
Based on the above technical solution, preferably, in step S1, the interface information of the package interface includes:
and the access grammars correspond to the various databases one by one and are used for forming the query statement.
The invention manages the access grammars of a plurality of databases in a unified way through the packaging interfaces, thereby facilitating the subsequent formation of query sentences, improving the efficiency of accessing the databases, and carrying out management and maintenance by directly modifying the packaging interface information if the databases are increased or decreased in the future, thereby greatly reducing the system development and the labor cost.
On the basis of the above technical solution, preferably, step S3 includes the following sub-steps:
s3-1, recognizing the information sentence to be inquired input by the user in the inquiry entrance, performing word segmentation and part-of-speech tagging on the sentence, filtering out stop words, and only keeping nouns, verbs and adjectives as inquiry key fields, namely the inquiry key fields comprise: a noun query key field, an adjective query key field and a verb query key field;
s3-2, sequentially forming query sentences which are one-to-one corresponding to various databases and take the nouns, the adjectives and the verbs as query key fields through the packaging interfaces according to the sequence of noun priority, adjective second and verb final;
and S3-3, using the query sentences in the various databases according to the sequence of forming the query sentences to sequentially query and acquire the information containing the noun query key field, the adjective query key field and the verb query key field in the various databases.
The method carries out word segmentation and part-of-speech tagging on the sentences by inputting the information sentences to be queried in the query entry by the user, filters stop words, only retains nouns, verbs and adjectives as query key fields, furthest ensures the information breadth capable of being queried, prevents information omission and simultaneously improves the query efficiency; the information containing the noun query key field, the adjective query key field and the verb query key field is queried in the database according to the sequence of noun priority, adjective second and verb final, important information in the sentence is queried preferentially according to grammatical habits, and the query efficiency is improved.
On the basis of the above technical solution, preferably, step S4 includes the following sub-steps:
s4-1, in various databases, sorting the information containing the query key fields in each database respectively to form a sorting table;
s4-2, extracting the sorting table of each database, and sorting again to form a total sorting table;
and S4-3, carrying out visualization processing on the sorted list and the general sorted list, and pushing the sorted list and the general sorted list to a public opinion analysis system in a chart form, wherein the chart form comprises but is not limited to a line chart, a column chart and a pie chart.
The inquired information is sequenced, the sequencing table and the general sequence table are visually processed, and the information is pushed to a public opinion analysis system in a chart form, wherein the chart form comprises but is not limited to a line chart, a column chart and a pie chart, and the information is sequenced and visually processed, so that a user can conveniently know the distribution and development condition of the public opinion information.
On the basis of the above technical solution, preferably, step S4-1 includes the following sub-steps:
s4-1-1, setting a preset time period, and sorting in various databases according to the data heat change of the information containing the query key fields in each database and the sequence of the heat rising from fast to slow;
s4-1-2, when the heat rising speed is the same, arranging from high to low according to the following sequence: the information simultaneously containing a noun query key field, an adjective query key field and a verb query key field > the information simultaneously containing the noun query key field and the adjective query key field > the information simultaneously containing the noun query key field and the verb query key field > the information simultaneously containing the adjective query key field and the verb query key field > the information containing the noun query key field > the information containing the adjective query key field > the information containing the verb query key field;
and sequencing the information according to the rules to form a sequencing table, wherein the sequencing table comprises an information sequence number, information content, information release time, information heat and the heat rising speed of the information in a preset time period.
According to the invention, the information containing the query key fields in each database is sorted according to the rise speed of the heat in the preset time period, so that the change trend of the heat of the information in the platform to which each database belongs is reflected, a user can conveniently know different change conditions of the heat of the same information on each platform, and different response schemes can be timely made for different platforms according to the change conditions.
Based on the above technical solution, it is preferable that the heat in step S4-1-1:
and setting each comment, praise and forwarding heat degree to be one for the comment, praise and forwarding amount of the information containing the query key field, wherein the total heat degree of each piece of information containing the query key field is the sum of the comment, praise and forwarding heat degree of the information.
According to the invention, the total heat of each piece of information is conveniently calculated by setting the heat calculation method, and the information is sorted according to the heat.
On the basis of the above technical solution, preferably, step S4-2 includes:
extracting the sorting table of each database, performing weighted calculation on the information sequence numbers in the sorting table according to the platform to which each database belongs, and re-determining the information sorting; grading the platforms according to preset rules, wherein the first-level platform is the platform with the daily activity of more than 6 hundred million, the first-level platform is the platform with the daily activity of more than 4 hundred million and less than 6 hundred million, the first-level platform is the platform with the daily activity of more than 2 hundred million and less than 4 hundred million, and the first-level platform is the platform with the daily activity of less than 4 hundred million;
if the platform to which the database belongs is a first-level platform, setting the weight of the platform to be 1, if the platform to which the database belongs is a second-level platform, setting the weight of the platform to be 0.7, if the platform to which the database belongs is a third-level platform, setting the weight of the platform to be 0.5, and if the platform to which the database belongs is a fourth-level platform, setting the weight of the platform to be 0.2; the first-level platform can be set as microblog, buffalo and the like, the second-level platform can be set as WeChat, b station, bean, know-you and the like, the third-level platform can be set as QQ, Taobao, Paibao, Baidu and the like, and the fourth-level platform can be set as each news client and the like. Multiplying the sequence serial number of each piece of information in the sorting table by the corresponding weight to obtain a number, namely the information weight corresponding to the information, and arranging the corresponding information from high to low according to the information weight to form a total sorting table;
the total sequence table comprises information content, information release time, information heat and the heat rising speed of the information in a preset time period.
The invention reflects the heat condition of the whole network public sentiment of the related user query information by sequencing the information in the sequencing list again, thereby facilitating the user to master the main development direction of the public sentiment and timely carrying out public sentiment management; the weight calculation method is obtained by comprehensively considering information such as daily activity and the like of each platform field and users thereof according to different platform public opinion development conditions; the information in the general sequence table comprises information content, information release time, information popularity and popularity rising speed of the information in a preset time period, and therefore the user can conveniently and vertically compare public opinion development of different platforms.
In a second aspect of the present invention, a query system compatible and coexisting with multiple databases is disclosed, the system comprising:
the integrated packaging module is used for acquiring interface information of various databases, integrally packaging the interface information to form a packaging interface, and presetting a system interface, wherein the packaging interface comprises access grammars which are in one-to-one correspondence with the various databases and are used for forming access query statements;
the connection module is used for connecting the public opinion analysis system with a packaging interface through the system interface and connecting various databases with the packaging interface;
the identification module is used for identifying the information sentences to be inquired input by the user in the inquiry entrance, performing word segmentation and part-of-speech tagging on the sentences, filtering stop words, and only retaining nouns, verbs and adjectives as inquiry key fields, namely the inquiry key fields comprise: a noun query key field, an adjective query key field and a verb query key field;
the information query module is used for querying the access query statement of the query key field, accessing various databases and acquiring the information containing the query key field in the various databases, wherein the access query statement is formed by the packaging interface and corresponds to the various databases one by one;
the data processing module is used for sorting the information acquired in each database to generate a sorting table, re-sorting the information in all the sorting tables, re-determining the information sorting and generating a total sorting table; and carrying out visual processing on the sorted list and the general sorted list, and pushing the sorted list and the general sorted list to a display interface of the public opinion analysis system in a chart form, wherein the chart form comprises but is not limited to a line chart, a column chart and a pie chart.
In a third aspect of the present invention, an electronic device is disclosed, the device comprising: at least one processor, at least one memory, a communication interface, and a bus; the processor, the memory and the communication interface complete mutual communication through the bus; the memory stores a plurality of database-compatible and co-existing query method programs executable by the processor, the plurality of database-compatible and co-existing query method programs configured to implement a plurality of database-compatible and co-existing query method according to the first aspect of the present invention.
In a fourth aspect of the present invention, a computer-readable storage medium is disclosed, wherein the storage medium stores a query method program for database compatibility and coexistence, and when executed, the query method program for database compatibility and coexistence implements the query method for database compatibility and coexistence according to the first aspect of the present invention.
Compared with the prior art, the query method, the query system, the query equipment and the query medium which are compatible and coexisting with various databases have the following beneficial effects:
(1) by setting the system interface and the packaging interface, the public opinion analysis system is connected with various databases to conveniently acquire data from the various databases, so that the efficiency of acquiring public opinion information from the various databases is improved; the packaging interface uniformly manages the access grammars of the databases, so that query sentences can be conveniently formed subsequently, the efficiency of accessing the databases is improved, and if the databases are increased or decreased in the future, management and maintenance can be performed by directly modifying the information of the packaging interface, so that the system development and the labor cost are greatly reduced;
(2) the invention obtains the related public opinion data from the database of each platform, sorts the data of each platform, facilitates the user to transversely compare the public opinion conditions of the same information on different platforms, makes different corresponding schemes aiming at different platforms, and integrates the different platforms in a sorting mode, so that the user can conveniently know the development condition of the public opinion on the whole network and the current main public opinion development condition in a vertical comparison mode, and timely performs public opinion management aiming at the public opinion development major direction;
(3) the method carries out word segmentation and part-of-speech tagging on the sentence by inputting the information sentence to be queried in the query entry by the user, filters out stop words, only retains nouns, verbs and adjectives as query key fields, furthest ensures the information breadth capable of being queried, prevents information omission, queries the information containing the noun query key fields, the adjective query key fields and the verb query key fields in the database according to the sequence of noun priority, adjective second and verb last, queries the important information in the sentence according to grammatical habit priority, and improves the query efficiency;
(4) the inquired information is sequenced, the sequencing table and the general sequence table are visually processed, and the information is pushed to a public opinion analysis system in a chart form, wherein the chart form comprises but is not limited to a line chart, a column chart and a pie chart, and the information is sequenced and visually processed, so that a user can conveniently know the distribution and development condition of the public opinion information.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flowchart illustrating a query method for compatibility and coexistence of multiple databases according to the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, are within the scope of the present invention.
Examples
The processing flow of the query method for compatibility and coexistence of multiple databases is shown in figure 1, and the processing steps are described as follows:
the method comprises the steps that firstly, an integrated packaging module obtains interface information of various databases and integrally packages the interface information to form a packaging interface, the packaging interface comprises access grammars which are in one-to-one correspondence with the various databases, a connecting module is connected with the various databases through the packaging interface, and a public opinion analysis system and the packaging interface are connected through a preset system interface to realize the connection of the public opinion analysis system and the various databases; and turning to the second step.
Secondly, a user inputs a sentence of information to be queried at a query entrance of the public opinion analysis system, an identification module identifies the sentence, performs word segmentation and part-of-speech tagging on the sentence, filters stop words, and only retains nouns, verbs and adjectives as query key fields, namely the query key fields comprise: a noun query key field, an adjective query key field and a verb query key field; and (6) turning to the third step.
Thirdly, the packaging interface acquires the user input sentences and the query key fields, and forms access query sentences containing the query key fields in all the query databases through access grammars corresponding to the various databases one by one; and turning to the fourth step.
Fourthly, the information query module queries all databases through all query sentences to obtain the information containing the query key fields in all databases; and turning to the fifth step.
Fifthly, the data processing module sorts the information acquired in each database, calculates the respective heat rising speed of all the information in the database in a preset time period, sets that each comment, praise and forwarding heat of one piece of information is one, and the total heat of each piece of information containing the query key field is the sum of the comment, praise and forwarding heat of the piece of information; arranging according to the heat rising speed of each piece of information from high to low, and when the heat rising speeds are the same, arranging according to the following sequence from high to low:
the information simultaneously containing a noun query key field, an adjective query key field and a verb query key field > the information simultaneously containing the noun query key field and the adjective query key field > the information simultaneously containing the noun query key field and the verb query key field > the information simultaneously containing the adjective query key field and the verb query key field > the information containing the noun query key field > the information containing the adjective query key field > the information containing the verb query key field;
sorting the information according to the rules to form a sorting table; the sorting table comprises an information sequence number, information content, information release time, information heat and the heat rising speed of the information in a preset time period; and turning to the sixth step.
Sixthly, the data processing module extracts the sorting table of each database, performs weighted calculation on information sequence numbers in the sorting table according to a platform to which each database belongs, and grades the platform according to a preset rule, wherein the platform with daily activity larger than 6 hundred million is a first-level platform, the platform with daily activity larger than 4 hundred million and smaller than 6 hundred million is the first-level platform, the platform with daily activity larger than 2 hundred million and smaller than 4 hundred million is the first-level platform, and the platform with daily activity smaller than 4 hundred million is the first-level platform;
if the platform to which the database belongs is a first-level platform, setting the weight of the platform to be 1, if the platform to which the database belongs is a second-level platform, setting the weight of the platform to be 0.7, if the platform to which the database belongs is a third-level platform, setting the weight of the platform to be 0.5, and if the platform to which the database belongs is a fourth-level platform, setting the weight of the platform to be 0.2; the first-level platform can be set as microblog, buffalo and the like, the second-level platform can be set as WeChat, b station, bean, know-you and the like, the third-level platform can be set as QQ, Taobao, Paibao, Baidu and the like, and the fourth-level platform can be set as each news client and the like. Multiplying the sequence serial number of each piece of information in the sorting table by the corresponding weight to obtain a number, namely the information weight corresponding to the information, and arranging the corresponding information from high to low according to the information weight to form a total sorting table; the master sequence table comprises information content, information release time, information heat and the heat rising speed of the information in a preset time period; and turning to the seventh step.
And seventhly, performing visual processing on the sequence table and the total sequence table by the data processing module to generate a chart form of the sequence table and the total sequence table, and pushing the chart to a display interface of the public opinion analysis system, wherein the chart form comprises but is not limited to a broken line chart, a column chart and a pie chart.
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 (10)
1. A query method for compatibility and coexistence of multiple databases is characterized by comprising the following steps:
s1, presetting a query entry and a system interface in the public opinion analysis system, acquiring interface information of various databases, and integrally packaging the interface information to form a packaging interface;
s2, connecting the public opinion analysis system with a packaging interface through the system interface, and connecting various databases with the packaging interface;
s3, obtaining the information sentence to be inquired input by the user in the inquiry entrance, extracting the key field from the sentence as the inquiry key field, forming the access inquiry sentence which is corresponding to the various databases one by one through the packaging interface and is used for inquiring the inquiry key field; accessing various databases through the access query statement to acquire information containing the query key fields in the various databases;
and S4, sequencing the acquired information, performing visualization processing, and pushing the visualized information to a display interface of the public opinion analysis system.
2. The method for querying multiple database compatibilities and coexistence as claimed in claim 1, wherein in said step S1, the interface information of the encapsulation interface includes:
and the access grammars correspond to the various databases one by one and are used for forming the query statement.
3. The method for querying the compatibility and coexistence of various databases according to claim 1, wherein said step S3 comprises the sub-steps of:
s3-1, recognizing the information sentence to be inquired input by the user in the inquiry entrance, performing word segmentation and part-of-speech tagging on the sentence, filtering out stop words, and only keeping nouns, verbs and adjectives as inquiry key fields, namely the inquiry key fields comprise: a noun query key field, an adjective query key field and a verb query key field;
s3-2, sequentially forming query sentences which are one-to-one corresponding to various databases and take the nouns, the adjectives and the verbs as query key fields through the packaging interfaces according to the sequence of noun priority, adjective second and verb final;
and S3-3, using the query sentences in the various databases according to the sequence of forming the query sentences to sequentially query and acquire the information containing the noun query key field, the adjective query key field and the verb query key field in the various databases.
4. The method for querying the compatibility and coexistence of multiple databases according to claim 3, wherein said step S4 comprises the sub-steps of:
s4-1, in various databases, sorting the information containing the query key fields in each database respectively to form a sorting table;
s4-2, extracting the sorting table of each database, and sorting again to form a total sorting table;
and S4-3, carrying out visualization processing on the sorted list and the general sorted list, and pushing the sorted list and the general sorted list to a public opinion analysis system in a chart form, wherein the chart form comprises but is not limited to a line chart, a column chart and a pie chart.
5. The method for querying multiple database compatibilities and coexistence as claimed in claim 4, wherein said step S4-1 comprises the sub-steps of:
s4-1-1, setting a preset time period, and sorting in various databases according to the data heat change of the information containing the query key fields in each database and the sequence of the heat rising from fast to slow;
s4-1-2, when the heat rising speed is the same, arranging from high to low according to the following sequence: the information simultaneously containing a noun query key field, an adjective query key field and a verb query key field > the information simultaneously containing the noun query key field and the adjective query key field > the information simultaneously containing the noun query key field and the verb query key field > the information simultaneously containing the adjective query key field and the verb query key field > the information containing the noun query key field > the information containing the adjective query key field > the information containing the verb query key field;
and sequencing the information according to the rules to form a sequencing table, wherein the sequencing table comprises an information sequence number, information content, information release time, information heat and the heat rising speed of the information in a preset time period.
6. The method for querying across multiple database compatibilities and co-existence according to claim 5, wherein the hot-degree in step S4-1-1 includes:
and setting each comment, praise and forwarding heat degree to be one for the comment, praise and forwarding amount of the information containing the query key field, wherein the total heat degree of each piece of information containing the query key field is the sum of the comment, praise and forwarding heat degree of the information.
7. The method for querying across multiple database compatibilities and concurrency according to claim 5, wherein said step S4-2 comprises:
extracting the sorting table of each database, performing weighted calculation on the information sequence numbers in the sorting table according to the platform to which each database belongs, and re-determining the information sorting; grading the platform according to a preset rule;
if the platform to which the database belongs is a first-level platform, setting the weight of the platform to be 1, if the platform to which the database belongs is a second-level platform, setting the weight of the platform to be 0.7, if the platform to which the database belongs is a third-level platform, setting the weight of the platform to be 0.5, and if the platform to which the database belongs is a fourth-level platform, setting the weight of the platform to be 0.2; multiplying the sequence serial number of each piece of information in the sorting table by the corresponding weight to obtain a number, namely the information weight corresponding to the information, and arranging the corresponding information from high to low according to the information weight to form a total sorting table;
the total sequence table comprises information content, information release time, information heat and the heat rising speed of the information in a preset time period.
8. A query system compatible and compatible with multiple databases, comprising:
the integrated packaging module is used for acquiring interface information of various databases, integrally packaging the interface information to form a packaging interface, and presetting a system interface, wherein the packaging interface comprises access grammars which are in one-to-one correspondence with the various databases and are used for forming access query statements;
the connection module is used for connecting the public opinion analysis system with a packaging interface through the system interface and connecting various databases with the packaging interface;
the identification module is used for identifying the information sentences to be inquired input by the user in the inquiry entrance, performing word segmentation and part-of-speech tagging on the sentences, filtering stop words, and only retaining nouns, verbs and adjectives as inquiry key fields, namely the inquiry key fields comprise: a noun query key field, an adjective query key field and a verb query key field;
the information query module is used for querying the access query statement of the query key field, accessing various databases and acquiring the information containing the query key field in the various databases, wherein the access query statement is formed by the packaging interface and corresponds to the various databases one by one;
the data processing module is used for sorting the information acquired in each database to generate a sorting table, re-sorting the information in all the sorting tables, re-determining the information sorting and generating a total sorting table; and carrying out visual processing on the sorted list and the general sorted list, and pushing the sorted list and the general sorted list to a display interface of the public opinion analysis system in a chart form, wherein the chart form comprises but is not limited to a line chart, a column chart and a pie chart.
9. An electronic device comprising at least one processor, at least one memory, a communication interface, and a bus; the processor, the memory and the communication interface complete mutual communication through the bus; the memory stores a multi-database compatible and concurrent query method program executable by the processor, the multi-database compatible and concurrent query method program configured to implement a multi-database compatible and concurrent query method according to any one of claims 1 to 7.
10. A computer-readable storage medium, wherein a multi-database compatible and concurrent query method program is stored on the storage medium, and when executed, implements the multi-database compatible and concurrent query method of any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111006990.6A CN113742558A (en) | 2021-08-30 | 2021-08-30 | Query method, system, equipment and medium compatible and concurrent with multiple databases |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111006990.6A CN113742558A (en) | 2021-08-30 | 2021-08-30 | Query method, system, equipment and medium compatible and concurrent with multiple databases |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113742558A true CN113742558A (en) | 2021-12-03 |
Family
ID=78734059
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111006990.6A Pending CN113742558A (en) | 2021-08-30 | 2021-08-30 | Query method, system, equipment and medium compatible and concurrent with multiple databases |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113742558A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114706918A (en) * | 2022-06-01 | 2022-07-05 | 杭州安恒信息技术股份有限公司 | Multi-type database compatibility method, device, equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103744955A (en) * | 2014-01-04 | 2014-04-23 | 北京理工大学 | Semantic query method based on ontology matching |
| CN105677709A (en) * | 2015-12-28 | 2016-06-15 | 北京搜狗科技发展有限公司 | Information processing method and apparatus, and device for processing information |
| CN105677864A (en) * | 2016-01-08 | 2016-06-15 | 国网冀北电力有限公司 | Retrieval method and device for power grid dispatching structural data |
| CN105912624A (en) * | 2016-04-07 | 2016-08-31 | 北京中安智达科技有限公司 | Query method for distributed deployed heterogeneous database |
| CN109614427A (en) * | 2018-10-23 | 2019-04-12 | 平安科技（深圳）有限公司 | The access method and device of Various database, storage medium and electronic equipment |
| CN111859090A (en) * | 2020-03-18 | 2020-10-30 | 齐浩亮 | Method for obtaining plagiarism source document based on local matching convolutional neural network model facing source retrieval |
-
2021
- 2021-08-30 CN CN202111006990.6A patent/CN113742558A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103744955A (en) * | 2014-01-04 | 2014-04-23 | 北京理工大学 | Semantic query method based on ontology matching |
| CN105677709A (en) * | 2015-12-28 | 2016-06-15 | 北京搜狗科技发展有限公司 | Information processing method and apparatus, and device for processing information |
| CN105677864A (en) * | 2016-01-08 | 2016-06-15 | 国网冀北电力有限公司 | Retrieval method and device for power grid dispatching structural data |
| CN105912624A (en) * | 2016-04-07 | 2016-08-31 | 北京中安智达科技有限公司 | Query method for distributed deployed heterogeneous database |
| CN109614427A (en) * | 2018-10-23 | 2019-04-12 | 平安科技（深圳）有限公司 | The access method and device of Various database, storage medium and electronic equipment |
| CN111859090A (en) * | 2020-03-18 | 2020-10-30 | 齐浩亮 | Method for obtaining plagiarism source document based on local matching convolutional neural network model facing source retrieval |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114706918A (en) * | 2022-06-01 | 2022-07-05 | 杭州安恒信息技术股份有限公司 | Multi-type database compatibility method, device, equipment and storage medium |
| CN114706918B (en) * | 2022-06-01 | 2022-09-16 | 杭州安恒信息技术股份有限公司 | Multi-type database compatibility method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105740228B (en) | A kind of internet public feelings analysis method and system | |
| CN106202476B (en) | A kind of interactive method and device of knowledge based collection of illustrative plates | |
| US9282162B2 (en) | Processing user profiles of users in an electronic community | |
| CN111597308A (en) | Knowledge graph-based voice question-answering system and application method thereof | |
| WO2023029420A1 (en) | Power user appeal screening method and system, electronic device, and storage medium | |
| CN107480133B (en) | Subjective question self-adaptive scoring method based on answer implication and dependency relationship | |
| CN106649742A (en) | Database maintenance method and device | |
| CN106776797A (en) | A kind of knowledge Q-A system and its method of work based on ontology inference | |
| CN105787134B (en) | Intelligent answer method, apparatus and system | |
| CN110852095B (en) | Statement hot spot extraction method and system | |
| CN112749266B (en) | Industrial question and answer method, device, system, equipment and storage medium | |
| KR20200042767A (en) | System and Method for Extracting Keyword and Generating Abstract | |
| CN112100396A (en) | Data processing method and device | |
| CN114528312A (en) | Method and device for generating structured query language statement | |
| Liang et al. | Patent analysis with text mining for TRIZ | |
| CN113742558A (en) | Query method, system, equipment and medium compatible and concurrent with multiple databases | |
| CN108959366B (en) | Open question-answering method | |
| KR20030069640A (en) | System and method for geting information on hierarchical and conceptual clustering | |
| CN110019763B (en) | Text filtering method, system, equipment and computer readable storage medium | |
| KR20100073793A (en) | Apparatus and method for knowledge structuralization using collective intelligence, and method for providing knowledge service using it | |
| CN111460114A (en) | Retrieval method, device, equipment and computer readable storage medium | |
| CN111933141A (en) | Artificial intelligence voice interaction system based on big data | |
| CN115082010A (en) | Intelligent management method, storage medium and system for metadata in power field | |
| CN102521239B (en) | Question-answering information matching system and method based on OWL (web ontology language) for Internet | |
| Kannan et al. | Text document clustering using statistical integrated graph based sentence sensitivity ranking algorithm |
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 |