CN116561158A - Internet-based data query background management system - Google Patents

Internet-based data query background management system Download PDF

Info

Publication number
CN116561158A
CN116561158A CN202310486770.0A CN202310486770A CN116561158A CN 116561158 A CN116561158 A CN 116561158A CN 202310486770 A CN202310486770 A CN 202310486770A CN 116561158 A CN116561158 A CN 116561158A
Authority
CN
China
Prior art keywords
data
characteristic data
database
characteristic
retrieval
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
Application number
CN202310486770.0A
Other languages
Chinese (zh)
Inventor
马晓飞
王阿倩
贾俊龙
马泽钧
饶文宸
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Jieshou City Science And Technology Small And Medium Enterprise Productivity Promotion Center Co ltd
Original Assignee
Jieshou City Science And Technology Small And Medium Enterprise Productivity Promotion Center Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Jieshou City Science And Technology Small And Medium Enterprise Productivity Promotion Center Co ltd filed Critical Jieshou City Science And Technology Small And Medium Enterprise Productivity Promotion Center Co ltd
Priority to CN202310486770.0A priority Critical patent/CN116561158A/en
Publication of CN116561158A publication Critical patent/CN116561158A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2425Iterative querying; Query formulation based on the results of a preceding query
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a data query background management system based on the Internet, which comprises a data acquisition module, a data processing center and a data output module, wherein the data processing center comprises a characteristic data identification unit, a characteristic data reading unit, a characteristic data retrieval unit, a first database and a second database, relates to the technical field of data query management, solves the technical problems of slow response speed of a large number of data queries and reduced experience of user query information, and further reduces the information range of user query by utilizing the characteristic data through identification and extraction of the acquired user information, and accelerates the retrieval of the user information by combining the retrieval of the characteristic data, thereby improving the experience of the user retrieval, and secondly, the characteristic data is retrieved and stored to generate a corresponding matching template and a retrieval result, thereby facilitating the rapid response of a system when different subsequent users search and generating the information data result which the user wants to acquire.

Description

Internet-based data query background management system
Technical Field
The invention belongs to the technical field of data query management, and particularly relates to a data query background management system based on the Internet.
Background
In the related art, when querying data stored in a database, generally, all data stored in the database is queried according to a user's requirement, and then the queried data is returned to the querying user.
According to the patent display with the application number of CN201010591758.9, the patent comprises a background database, a management platform and a client, wherein a data management module, a configuration information module, a query condition management module and a query statement editing module are arranged in the management platform; the client is provided with a query interface, and the management platform can log in any query interface; the database management module is connected with the background database and is used for setting one or more database applications in the background database; the configuration information module sets configuration data for each background database, and outputs a condition variable set to the query condition management module and a main query statement set and database connection parameters to the query statement editing module. Because the condition variables in the condition variable set are in one-to-one correspondence with the query conditions displayed on the query interface, the query conditions are converted into parameter sequences to replace variable names of the condition variables in the main query statement, and the query conditions are dynamically combined with the main query statement through the condition variables after being selected by a user, so that the dynamic management of the query system can be realized, and the query function of the original system is expanded.
In the existing data query management process, after a user inputs information, the background management of the database has slower response speed when querying information required by the user due to huge information storage in the database, so that the experience of the user in using the query is reduced.
Disclosure of Invention
The present invention aims to solve at least one of the technical problems existing in the prior art; therefore, the invention provides a data query background management system based on the Internet, which is used for solving the technical problems that the response speed of a large number of data queries is low and the experience of the user for querying information is reduced.
To achieve the above object, an embodiment according to a first aspect of the present invention proposes an internet-based data query background management system, including: the data input module is used for collecting the internet data and transmitting the collected internet data to the data processing center;
the data processing center acquires the transmitted internet data, performs analysis and calculation, transmits the internet data to the characteristic data identification unit and the characteristic data reading unit, respectively identifies and reads the characteristic data in the source data, generates first characteristic data and second characteristic data, stores the first characteristic data and the second characteristic data in the characteristic data storage core, then transmits the characteristic data to the characteristic data retrieval unit, retrieves the first database according to the first characteristic data and generates a second database, retrieves the second characteristic data after the retrieval is completed, directly performs matching and generates corresponding result information to be transmitted to the information output end if the second characteristic data exists in the second database, and transmits the second characteristic data to the first database to be retrieved and generates corresponding retrieval results by combining the retrieval records of the first characteristic data to be transmitted to the information output end if the second characteristic data does not exist in the second database;
if the first characteristic data and the second characteristic data are not in the first database and the second database, the system directly transmits the result information to the information output end.
As a further aspect of the invention: the feature data retrieving unit retrieves the first feature data and the second feature data as follows:
s1: marking the acquired source data, and marking the first characteristic data in the source data as TZ 1 After marking is completed, the first characteristic data TZ 1 Performing storage and memorization;
s2: first characteristic data TZ to be stored 1 Transmitting to a first database, the system according to the first characteristic data TZ 1 The marked part is compared with the data in the first databaseMatching, where the comparison is based on the presence of the first characteristic data TZ in the first database 1 The data of the data are compared, the data which are matched with the comparison are extracted, and the matched data are stored;
s3: marking the data stored in the steps, generating a second database, and transmitting the second database to a characteristic data retrieval unit;
the characteristic data retrieval unit acquires and analyzes the transmitted second database, and the specific analysis mode is as follows: the feature data retrieving unit retrieves the source data again and extracts the second feature data TZ 2 Wherein the second characteristic data TZ 2 The retrieval is based on the success of the first characteristic data retrieval, the second characteristic data TZ is retrieved in the same way as the first characteristic data retrieval, but the two databases are different, and the second characteristic data TZ is retrieved 2 The searching is performed in the second database, wherein the specific searching mode is as follows:
p1: the characteristic data retrieval unit retrieves the second characteristic data TZ of the source data 2 Extracting second characteristic data which is defined as second characteristic data which can be identified in phrases and sentences and is positioned at a position behind the first data, and extracting second characteristic data TZ 2 Performing storage and memorization;
p2: extracted second characteristic data TZ 2 Screening and matching the second database in such a way that if the second characteristic data TZ 2 Exist in a second database:
the second database directly combines the first characteristic data TZ 1 And second characteristic data TZ 2 Screening out the matched information data in the second database, wherein the information data is a retrieval record, screening out the matched information data through comparison with the retrieval record, matching the information data with a corresponding retrieval result, and transmitting the retrieval result to a data output end;
if the second characteristic data TZ 2 Not present in the second database:
the system extracts the second feature numberAccording to TZ 2 Transmitting the data to a first database for screening, wherein the screening mode is the same as that of the first characteristic data TZ 1 In the mode of (2) and transmitting the screened data to a second database for storage, thereby combining the first characteristic data TZ 1 And second characteristic data TZ 2 Screening records, namely selecting screening records with the largest characteristic data similarity ratio, wherein the largest characteristic data similarity ratio is expressed as that the screening records respectively contain first characteristic data and second characteristic data;
p3: if the second characteristic data TZ 2 And the system judges that the obtained information inquiry does not reach the corresponding result and directly transmits the information data to the data output end.
As a further scheme of the invention: the characteristic data retrieval unit is in bidirectional electrical connection with the first database and the second database, the second database is a sub-database of the first database, and the first database is in unidirectional electrical connection with the second database.
As a further scheme of the invention: the characteristic data identification unit and the characteristic data reading unit are used for the first characteristic data and the second characteristic data, and the first characteristic data and the second characteristic data are stored in the characteristic data storage core.
Compared with the prior art, the invention has the beneficial effects that: the method comprises the steps of identifying and extracting the characteristic data of the acquired user information, further utilizing the characteristic data to narrow the information range queried by the user, and accelerating the retrieval of the user information by combining the retrieval of the characteristic data, so that the experience of the user retrieval is improved, and secondly, retrieving and storing the characteristic data to generate a corresponding matching template and a retrieval result, thereby facilitating the rapid response of a system when different subsequent users search and generating the information data result which the user wants to acquire.
Drawings
FIG. 1 is a schematic diagram of a system block diagram of the present invention.
Detailed Description
The technical solutions of the present invention will be clearly and completely described in connection with the embodiments, and it is obvious that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Referring to fig. 1, the present application provides an internet-based data query background management system, including:
the data input module is used for collecting internet data and transmitting the collected internet data to the data processing center;
the data processing center acquires the transmitted internet data, which is hereinafter referred to as source data, and performs the following analysis:
the method comprises the steps of transmitting acquired source data to a recognition unit, wherein the recognition unit is used for recognizing feature data in the source data, the feature data comprise words and phrases which can be recognized, the basis that the feature data can be recognized is that the feature data are acquired according to internet big data, the recognition is carried out through past retrieval records, the recognized feature data are subjected to marking processing, the acquired source data are transmitted to a first feature data extraction unit, the first feature data are words and phrases, the data which can be recognized and are located at the first position are defined as first feature data, the first feature data extraction unit carries out feature recognition on the transmitted data, a system automatically extracts the features according to the input words or phrases, the extracted first feature data are transmitted to a data feature retrieval unit, the data feature retrieval unit matches the feature data with data in a first database, and the first database is the source database, and the specific matching mode is as follows:
s1: marking the acquired source data, and marking the first characteristic data in the source data as TZ 1 After marking is completed, the first characteristic data TZ 1 Performing storage and memorization;
s2: first characteristic data TZ to be stored 1 Transmitting to a first database, the system according to the first characteristic data TZ 1 Marking portionThe comparison is carried out with the data in the first database according to the existence of the first characteristic data TZ in the first database 1 The data of the data are compared, the data which are matched with the comparison are extracted, and the matched data are stored;
s3: marking the data stored in the steps, generating a second database, and transmitting the second database to a characteristic data retrieval unit;
the characteristic data retrieval unit acquires and analyzes the transmitted second database, and the specific analysis mode is as follows: the feature data retrieving unit retrieves the source data again and extracts the second feature data TZ 2 Wherein the second characteristic data TZ 2 The retrieval is based on the success of the first characteristic data retrieval, the second characteristic data TZ is retrieved in the same way as the first characteristic data retrieval, but the two databases are different, and the second characteristic data TZ is retrieved 2 The searching is performed in the second database, wherein the specific searching mode is as follows:
p1: the characteristic data retrieval unit retrieves the second characteristic data TZ of the source data 2 Extracting second characteristic data which is defined as second characteristic data which can be identified in phrases and sentences and is positioned at a position behind the first data, and extracting second characteristic data TZ 2 Performing storage and memorization;
p2: extracted second characteristic data TZ 2 Screening and matching the second database in such a way that if the second characteristic data TZ 2 Exist in a second database:
the second database directly combines the first characteristic data TZ 1 And second characteristic data TZ 2 Screening out the matched information data in the second database, wherein the information data is a retrieval record, screening out the matched information data through comparison with the retrieval record, matching the information data with a corresponding retrieval result, and transmitting the retrieval result to a data output end;
if the second characteristic data TZ 2 Not present in the second database:
the system extracts the second characteristic data TZ 2 Transmitting the data to a first database for screening, wherein the screening mode is the same as that of the first characteristic data TZ 1 In the mode of (2) and transmitting the screened data to a second database for storage, thereby combining the first characteristic data TZ 1 And second characteristic data TZ 2 Screening records, namely selecting screening records with the largest characteristic data similarity ratio, wherein the largest characteristic data similarity ratio is expressed as that the screening records respectively contain first characteristic data and second characteristic data;
p3: if the second characteristic data TZ 2 And the system judges that the obtained information inquiry does not reach the corresponding result and directly transmits the information data to the data output end.
The data processing center comprises a characteristic data identification unit, a characteristic data reading unit, a characteristic data retrieval unit, a first database, a second database and a characteristic data storage core;
the data processing center is used for outputting the acquired data after processing, and transmitting the processed data to the data output end in a mode of transmitting the inquired information data to an operator through the intelligent display device.
The characteristic data retrieval unit is in bidirectional electrical connection with the first database and the second database, the second database is a sub-database of the first database, and the first database is in unidirectional electrical connection with the second database.
The characteristic data identification unit and the characteristic data reading unit are used for the first characteristic data and the second characteristic data, and the first characteristic data and the second characteristic data are stored in the characteristic data storage core.
The method comprises the steps of identifying and extracting the characteristic data of the acquired user information, further utilizing the characteristic data to narrow the information range queried by the user, and accelerating the retrieval of the user information by combining the retrieval of the characteristic data, so that the experience of the user retrieval is improved, and secondly, retrieving and storing the characteristic data to generate a corresponding matching template and a retrieval result, thereby facilitating the rapid response of a system when different subsequent users search and generating the information data result which the user wants to acquire.
The working principle of the invention is as follows: the user inputs information to be queried, the acquired information is transmitted to a data processing center through the acquisition of a data input end, corresponding data information is matched from a first database through the identification, acquisition and retrieval of characteristic data, a second database is generated, the information is finally matched from the second database according to the extraction, identification and retrieval of the second characteristic data, the result is transmitted to a data transmission end after the matching is completed, and the data transmission end displays the matched result to an operator through intelligent display equipment.
The above embodiments are only for illustrating the technical method of the present invention and not for limiting the same, and it should be understood by those skilled in the art that the technical method of the present invention may be modified or substituted without departing from the spirit and scope of the technical method of the present invention.

Claims (4)

1. The internet-based data query background management system is characterized by comprising:
the data input module is used for collecting the internet data and transmitting the collected internet data to the data processing center;
the data processing center acquires the transmitted internet data, performs analysis and calculation, transmits the internet data to the characteristic data identification unit and the characteristic data reading unit, respectively identifies and reads the characteristic data in the source data, generates first characteristic data and second characteristic data, stores the first characteristic data and the second characteristic data in the characteristic data storage core, then transmits the characteristic data to the characteristic data retrieval unit, retrieves the first database according to the first characteristic data and generates a second database, retrieves the second characteristic data after the retrieval is completed, directly performs matching and generates corresponding result information to be transmitted to the information output end if the second characteristic data exists in the second database, and transmits the second characteristic data to the first database to be retrieved and generates corresponding retrieval results by combining the retrieval records of the first characteristic data to be transmitted to the information output end if the second characteristic data does not exist in the second database;
if the first characteristic data and the second characteristic data are not in the first database and the second database, the system directly transmits the result information to the information output end.
2. The internet-based data query back-office system according to claim 1, wherein the feature data retrieving unit retrieves the first feature data and the second feature data in the following manner:
s1: marking the acquired source data, and marking the first characteristic data in the source data as TZ 1 After marking is completed, the first characteristic data TZ 1 Performing storage and memorization;
s2: first characteristic data TZ to be stored 1 Transmitting to a first database, the system according to the first characteristic data TZ 1 The marking part is compared and matched with the data in the first database, and the compared and matched data are stored;
s3: marking the data stored in the steps, generating a second database, and transmitting the second database to a characteristic data retrieval unit;
the characteristic data retrieval unit acquires and analyzes the transmitted second database, and the specific analysis mode is as follows: the feature data retrieving unit retrieves the source data again and extracts the second feature data TZ 2 Wherein the second characteristic data TZ 2 The retrieval is based on the success of the first characteristic data retrieval, the second characteristic retrieval mode is the same as the first characteristic data retrieval mode, wherein the specific retrieval mode is as follows:
p1: the characteristic data retrieval unit retrieves the second characteristic data TZ of the source data 2 Extracting and extracting the second characteristic data TZ 2 Performing storage and memorization;
p2: extracted second characteristic data TZ 2 Screening and matching the second database in such a way that if the second characteristic data TZ 2 Exist in a second database:
the second database directly combines the first characteristic data TZ 1 And second characteristic data TZ 2 Screening out the information data conforming to the second database, matching the information data with the corresponding search result, and transmitting the search result to a data output end;
if the second characteristic data TZ 2 Not present in the second database:
the system extracts the second characteristic data TZ 2 Transmitting the data to a first database for screening, wherein the screening mode is the same as that of the first characteristic data TZ 1 In the form of (a) and transmitting the screened data to a second database for storage while combining the first characteristic data TZ 1 And second characteristic data TZ 2 Screening records, namely selecting the screening record with the largest characteristic data similarity ratio, generating corresponding result information and transmitting the result information to an information output end;
p3: if the second characteristic data TZ 2 And the system judges that the obtained information inquiry does not reach the corresponding result and directly transmits the information data to the data output end.
3. The internet-based data query background management system according to claim 1, wherein the feature data retrieval unit is electrically connected to the first database and the second database in both directions, and the second database is a sub-database of the first database, and the first database is electrically connected to the second database in one direction.
4. The internet-based data query back-office system of claim 1, wherein the feature data identification unit and the feature data reading unit both act on the first feature data and the second feature data, and wherein the first feature data and the second feature data are both stored and within the feature data storage core.
CN202310486770.0A 2023-05-04 2023-05-04 Internet-based data query background management system Pending CN116561158A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310486770.0A CN116561158A (en) 2023-05-04 2023-05-04 Internet-based data query background management system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310486770.0A CN116561158A (en) 2023-05-04 2023-05-04 Internet-based data query background management system

Publications (1)

Publication Number Publication Date
CN116561158A true CN116561158A (en) 2023-08-08

Family

ID=87487289

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310486770.0A Pending CN116561158A (en) 2023-05-04 2023-05-04 Internet-based data query background management system

Country Status (1)

Country Link
CN (1) CN116561158A (en)

Similar Documents

Publication Publication Date Title
CN111597308A (en) Knowledge graph-based voice question-answering system and application method thereof
CN113590850A (en) Multimedia data searching method, device, equipment and storage medium
CN111859046A (en) Water pollution tracing system and method based on pollution element source analysis
CN113407785B (en) Data processing method and system based on distributed storage system
CN1629837A (en) Method and apparatus for processing, browsing and classified searching of electronic document and system thereof
CN111125145A (en) Automatic system for acquiring database information through natural language
CN115238154A (en) Search engine optimization system
CN113918702B (en) Semantic matching-based online law automatic question-answering method and system
CN114742032A (en) Interactive data analysis method, apparatus, device, medium, and program product
CN107943937B (en) Debtor asset monitoring method and system based on judicial public information analysis
CN118051590A (en) Question-answer type retrieval method and system based on large language model
CN117591738A (en) Information retrieval system and method based on cloud service
CN116842142A (en) Intelligent retrieval system for medical instrument
CN116561158A (en) Internet-based data query background management system
CN112347121A (en) Configurable method and system for converting natural language into sql
CN114238735B (en) Intelligent internet data acquisition method
CN113792111A (en) Unstructured data management system and method based on distributed storage
KR101592670B1 (en) Apparatus for searching data using index and method for using the apparatus
CN113886520A (en) Code retrieval method and system based on graph neural network and computer readable storage medium
CN112612893A (en) Electronic file case generation system
CN111125410A (en) Intelligent identification and retrieval system for massive graphic images
CN118013020B (en) Patent query method and system for generating joint training based on retrieval
CN113806321B (en) Log processing method and system
CN111339239B (en) Knowledge retrieval method and device, storage medium and server
CN113792129B (en) Intelligent session method, device, computer equipment and medium

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