CN112214475A - Method, system, storage medium and terminal for configuring multiple data sources - Google Patents
Method, system, storage medium and terminal for configuring multiple data sources Download PDFInfo
- Publication number
- CN112214475A CN112214475A CN202011215258.5A CN202011215258A CN112214475A CN 112214475 A CN112214475 A CN 112214475A CN 202011215258 A CN202011215258 A CN 202011215258A CN 112214475 A CN112214475 A CN 112214475A
- Authority
- CN
- China
- Prior art keywords
- data source
- information
- data
- database
- configuration
- 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.)
- Granted
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- 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/23—Updating
-
- 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—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/14—Travel agencies
-
- Y—GENERAL 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE 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/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The invention discloses a method, a system, a storage medium and a terminal for configuring various data sources, belonging to the technical field of data source processing, wherein the method comprises the steps of configuring data sources to be connected; judging whether the data source configuration is correct or not, and if not, sending out prompt information of incorrect configuration; if the result is correct, entering an auditing step; comparing the database information of the data source to be connected with preset auditing information, judging whether illegal information exists in the data source to be connected, if not, creating a sub-database of the data source to be connected, and receiving the data information uploaded by the sub-database; and if so, sending out prompt information that the audit is unqualified. According to the invention, the configuration of the plurality of data sources to be connected is carried out, whether the configuration of the data sources is correct or not is judged, and the verification of the data sources is carried out, so that the sub-database of the data sources to be connected can be created, the configuration of multiple data sources is realized, different data sources can be added by adding the configuration information of the data sources, and the configuration efficiency is high.
Description
Technical Field
The present invention relates to the field of data source processing technologies, and in particular, to a method, a system, a storage medium, and a terminal for configuring multiple data sources.
Background
The intelligent text travel plays a vital role in coordinating user requirements, travel resource allocation and the like along with the development of internet technology. However, as the tourism data in the internet is explosively increased, the data of the "smart travel" platform needs to be updated in real time, so as to achieve the purpose of providing more accurate cultural tourism data for the user.
Data updating of a traditional 'smart travel' platform depends on manual import, namely manual addition, insertion, deletion and the like. The data source is used as a device or an original medium for providing certain type of required data, stores all information for establishing database connection, can realize the connection of the corresponding database by providing a correct data source name, and provides a new idea for the data updating of the intelligent travel platform. At present, the configuration of a data source depends on a developer to modify access control codes for different data source types, however, the workload of the data source configuration mode is too large, the efficiency is low, the requirement of increasingly updated data source configuration of an intelligent travel system cannot be met, and how to efficiently configure various data sources is a problem which needs to be solved at present.
Disclosure of Invention
The invention aims to overcome the problem of low efficiency of a data source configuration mode in the prior art, and provides a method, a system, a storage medium and a terminal for configuring multiple data sources.
The purpose of the invention is realized by the following technical scheme: a multiple data source configuration method, the method comprising the steps of:
configuring a data source to be connected; judging whether the data source configuration is correct or not, and if not, sending out prompt information of incorrect configuration; if the result is correct, entering an auditing step; comparing the database information of the data source to be connected with preset auditing information, judging whether illegal information exists in the data source to be connected, if not, creating a sub-database of the data source to be connected, and receiving the data information uploaded by the sub-database; and if so, sending out prompt information that the audit is unqualified.
As an option, the configuring the data source to be connected specifically includes: configuring the type of a data source to be connected; configuring the connection attribute of each database in the data source to be connected; and configuring relevant information of the data source to be connected, wherein the relevant information comprises a data source name, a user name, a password, an interface request mode, message content of an interface request, and the user name, the password, a driver name, the maximum connection number, the minimum connection number and a field name of a database in the data source to be connected.
As an option, the preset auditing information includes a data source list which is not allowed to be connected and a field list which is not allowed to be connected; the step of judging whether the data source to be connected includes illegal information specifically includes:
acquiring a data source name and a field name of each database according to the connection attribute of each database in the data source to be connected; judging whether the name of the data source to be connected is included in a list of the data source which is not allowed to be connected by preset auditing information, and if not, auditing the field name of the database; if yes, sending out prompt information that the audit is unqualified;
judging whether the field name of the database to be connected is included in a field list which is not allowed to be connected by preset auditing information, and if not, judging that the data source to be connected does not have illegal information; and if so, sending out prompt information that the audit is unqualified.
As an option, the creating a sub-database of the data source to be connected, and the receiving the data information uploaded by the sub-database specifically includes: and establishing a sub-database by taking the name of the data source as a table name, and uploading corresponding data in the database to the sub-database according to the field name.
As an option, the method further comprises the subscription configuration step: receiving data updating notification information of a data source to be connected; acquiring a data interface address of information to be continuously updated according to the data updating notification information; and acquiring the data information to be updated in the data source to be connected according to the interface address of the data updating information.
It should be further noted that the technical features corresponding to the above-mentioned method options can be combined with each other or replaced to form a new technical solution.
The invention also includes a multiple data source configuration system, comprising:
the data source configuration unit is used for configuring the data source to be connected; the configuration judging unit is used for judging whether the data source configuration is correct or not, and if not, sending prompt information of incorrect configuration; if the result is correct, entering an auditing step; the auditing unit is used for comparing the database information of the data source to be connected with preset auditing information, judging whether illegal information exists in the data source to be connected, if not, creating a sub-database of the data source to be connected, and receiving the data information uploaded by the sub-database; and if so, sending out prompt information that the audit is unqualified.
As an option, the data source configuration unit specifically includes:
the type configuration module is used for configuring the type of the data source to be connected; the connection attribute configuration module is used for configuring the connection attribute of each database in the data source to be connected; and the related information configuration module is used for configuring related information of the data source to be connected, wherein the related information comprises a data source name, a driver name, an interface request mode, message content of an interface request, and a user name, a password, a maximum connection number, a minimum connection number and a field name of a database in the data source to be connected.
As an option, the system further includes a subscription configuration unit, configured to receive data update notification information of the data source to be connected; acquiring a data interface address of information to be continuously updated according to the data updating notification information; and acquiring the data information to be updated in the data source to be connected according to the interface address of the data updating information.
It should be further noted that the technical features corresponding to the above-mentioned system options can be combined with each other or replaced to form a new technical solution.
The present invention also includes a storage medium having stored thereon computer instructions which, when executed, perform the steps of the above-described method for configuring a plurality of data sources.
The invention also includes a terminal comprising a memory and a processor, wherein the memory stores computer instructions executable on the processor, and the processor executes the computer instructions to perform the steps of the above-mentioned multiple data source configuration method.
Compared with the prior art, the invention has the beneficial effects that:
(1) according to the method, the multiple data sources to be connected are configured, whether the configuration of the data sources to be connected is correct or not is judged, when the configuration is correct, the database information of the data sources to be connected is checked, after the check is passed, the sub-database of the data sources to be connected is created, and the data information uploaded by the sub-database is received, so that the configuration of multiple data sources is realized, different data sources can be added by adding the configuration information of the data sources, the configuration efficiency is high, and the real-time updating requirement of an intelligent text travel platform can be met; the invention carries out examination and approval on the data source to be connected, realizes quick examination and approval and quick connection on the data source and greatly improves the working efficiency.
(2) The data updating notification information comprises the interface address of the data information to be updated, and the data updating notification information of the data source to be connected is received, so that the data can be quickly updated according to the interface address of the data information to be updated, and the data updating notification information is suitable for the data updating requirement of the intelligent travel platform.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention.
FIG. 1 is a flowchart of a method of example 1 of the present invention;
fig. 2 is a schematic diagram of an operation page of a newly added data source in embodiment 1 of the present invention.
Detailed Description
The technical solutions of the present invention will be described clearly and completely with reference to the accompanying drawings, and it should be understood that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In the description of the present invention, it should be noted that directions or positional relationships indicated by "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer", and the like are directions or positional relationships described based on the drawings, and are only for convenience of description and simplification of description, and do not indicate or imply that the device or element referred to must have a specific orientation, be configured and operated in a specific orientation, and thus, should not be construed as limiting the present invention. Furthermore, the terms "first" and "second" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.
In the description of the present invention, it should be noted that, unless otherwise explicitly stated or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, and may be, for example, fixedly connected, detachably connected, or integrally connected; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meanings of the above terms in the present invention can be understood in specific cases to those skilled in the art.
In addition, the technical features involved in the different embodiments of the present invention described below may be combined with each other as long as they do not conflict with each other.
Example 1
As shown in fig. 1, in embodiment 1, a method for configuring multiple data sources, which uses an "intelligent travel" platform as an execution subject, specifically includes the following steps:
s01: configuring a data source to be connected; specifically, the intelligent travel platform can set the number of data sources to be connected and the data sources to be connected in real time according to actual business requirements, and realizes connection with a new data source by adding the number of the data sources to be connected.
S02: judging whether the data source configuration is correct or not, and if not, sending out prompt information of incorrect configuration; if the result is correct, entering an auditing step;
s03: comparing the database information of the data source to be connected with preset auditing information, judging whether illegal information exists in the data source to be connected, if not, creating a sub-database of the data source to be connected, and receiving the data information uploaded by the sub-database; and if so, sending out prompt information that the audit is unqualified.
Further, the configuring of the data source to be connected in step S01 specifically includes:
s011: configuring the type of a data source to be connected; as a specific example, the data source types include, but are not limited to, HTTP/HTTPS, FTP/STFP.
S012: configuring the connection attribute of each database in the data source to be connected; specifically, the API interface information of the database may be obtained by sending an HTTP request to the corresponding database, thereby implementing the invocation of the database. The database types include but are not limited to mysql, oracle, sqlsever and hive, and the file types stored in the database include but are not limited to txt files, text files, excel files and csl files.
S013: and configuring relevant information of the data source to be connected, wherein the relevant information comprises a data source name, a user name, a password, a data source validity period, an interface request mode and message content of an interface request, and the user name, the password, a driver name, a data filing name, the maximum connection number, the minimum connection number and a field name of a database in the data source to be connected. The maximum connection number of the databases in the data sources to be connected is configured, so that efficient and stable transmission of data is facilitated; when the number of the databases in the data source to be connected is less than the minimum connection number, the connection between the databases to be connected and the intelligent text travel platform is automatically disconnected.
Furthermore, as shown in fig. 2, when data docking needs to be performed on a new data source to be connected, connection between the "smart travel" platform and the new data source to be connected can be implemented only by adding configuration information of the new data source to be connected.
Further, in step S02, it is determined whether the data source configuration is correct, and it is determined through a connection test, if the connection between the database in the data source to be connected and the "smart travel" platform is successful, the configuration is correct, otherwise, the configuration is incorrect.
Further, the preset auditing information comprises a data source list which is not allowed to be connected and a field list which is not allowed to be connected, illegal information exists in the data source list which is not allowed to be connected and the field list which is not allowed to be connected, and the intelligent travel platform has the potential risk of information leakage due to overdue connection. In step S03, the determining whether the data source to be connected includes the illegal information specifically includes:
s031: and acquiring the name of the data source and the field name of each database according to the connection attribute of each database in the data source to be connected, namely, connecting the intelligent text travel platform with each database in the data source to be connected so as to acquire the name of the data source to be connected and the field name of each database.
S032: judging whether the name of the data source to be connected is included in a list of the data source which is not allowed to be connected by preset auditing information, and if not, auditing the field name of the database; if yes, sending out prompt information that the audit is unqualified;
s033: judging whether the field name of the database to be connected is included in a field list which is not allowed to be connected by preset audit information, if not, judging that the data source to be connected has no illegal information, and performing a sub-database establishing step of the data source to be connected; and if so, sending out prompt information that the audit is unqualified.
Further, creating a sub-database of the data source to be connected, and receiving the data information uploaded by the sub-database specifically includes:
s034: and establishing a sub-database by taking the name of the data source as a table name, and uploading corresponding data in the database to the sub-database according to the field name.
Further, the method also comprises an information verification step:
s035: and checking the data in the sub-database, and merging or deleting redundant information. As an embodiment, field names in the database are counted, and if a field name is greater than 1, the field data information is merged.
As an option, after the sub-database is established, the sub-database can be filed according to the name of the sub-database, so that a developer can conveniently check the sub-database.
Further, the method further comprises the step of S04 subscription configuration:
s041: receiving data updating notification information of a data source to be connected;
s042: acquiring a data interface address of information to be continuously updated according to the data updating notification information;
s042: and acquiring the data information to be updated in the data source to be connected according to the interface address of the data updating information.
Specifically, the intelligent travel platform stores interface mapping relations supporting different platform data sources, determines an API (application programming interface) interface calling address of a target data source to be connected according to the interface mapping relations, determines a data interface address of the data source to be connected corresponding to information to be updated in the platform according to the API interface calling address, and further acquires the data information to be updated in the data source to be connected.
Furthermore, the data updating notification information includes a data protocol type of the data source to be connected, the intelligent text travel platform judges whether the data protocol type of the data source to be connected is the same as the data protocol type of the platform, if not, the intelligent text travel platform sends data conversion request information to the platform corresponding to the data source to be connected, and after receiving the data conversion request information, the platform corresponding to the data source to be connected encapsulates the data information to be updated and uploads the encapsulated data information to the intelligent text travel platform, so that effective butt joint of data with different protocol types is realized.
According to the method, the multiple data sources to be connected are configured, whether the configuration of the data sources to be connected is correct or not is judged, when the configuration is correct, the database information of the data sources to be connected is checked, after the check is passed, the sub-database of the data sources to be connected is created, and the data information uploaded by the sub-database is received, so that the configuration of multiple data sources is realized, different data sources can be added by adding the configuration information of the data sources, the configuration efficiency is high, and the real-time updating requirement of an intelligent text travel platform can be met; the invention carries out examination and approval on the data source to be connected, realizes quick examination and approval and quick connection on the data source and greatly improves the working efficiency.
Example 2
The embodiment provides a system for configuring multiple data sources, which has the same inventive concept as embodiment 1, and the system comprises: the data source configuration unit is used for configuring the data source to be connected; the configuration judging unit is used for judging whether the data source configuration is correct or not, and if not, sending prompt information of incorrect configuration; if the result is correct, entering an auditing step; the auditing unit is used for comparing the database information of the data source to be connected with preset auditing information, judging whether illegal information exists in the data source to be connected, if not, creating a sub-database of the data source to be connected, and receiving the data information uploaded by the sub-database; and if so, sending out prompt information that the audit is unqualified.
Furthermore, the data source configuration unit can set the number of the data sources to be connected and the data sources to be connected in real time according to the actual service requirements of the system, and the connection with the new data source is realized by adding the number of the data sources to be connected.
Further, the data source configuration unit specifically includes a type configuration module, a connection attribute configuration module, and a related information configuration module.
Furthermore, the type configuration module is used for configuring the type of the data source to be connected, and the type of the data source includes but is not limited to HTTP/HTTPS and FTP/STFP.
Furthermore, the connection attribute configuration module is used for configuring the connection attribute of each database in the data source to be connected. The API information of the database can be acquired by sending HTTP requests to the corresponding database, and then the database can be called. The database types include but are not limited to mysql, oracle, sqlsever and hive, and the file types stored in the database include but are not limited to txt files, text files, excel files and csl files.
Furthermore, the related information configuration module is configured to configure related information of the data source to be connected, including a name of the data source, a user name, a password, a validity period of the data source, an interface request mode, a message content of the interface request, and a user name, a password, a driver name, a data filing name, a maximum connection number, a minimum connection number, and a field name of a database in the data source to be connected. The maximum connection number of the databases in the data sources to be connected is configured, so that efficient and stable transmission of data is facilitated; and when the number of the databases in the data source to be connected is less than the minimum connection number, the connection between the database to be connected and the system is automatically disconnected.
More specifically, when the system needs to perform data docking on a new data source to be connected, the connection between the system and the new data source to be connected can be realized only by adding configuration information of the new data source to be connected.
The system further comprises a data source configuration judging module, which is used for judging whether the data source configuration is correct or not, and specifically judging through a connection test, wherein if the connection between the database in the data source to be connected and the system is successful, the configuration is correct, otherwise, the configuration is incorrect.
Furthermore, the system further comprises an auditing unit, wherein preset auditing information is stored in the auditing unit, the preset auditing information comprises a data source list which is not allowed to be connected and a field list which is not allowed to be connected, illegal information exists in the data source list which is not allowed to be connected and the field list which is not allowed to be connected, and the intelligent travel platform has potential risk of information leakage due to overdue connection.
Furthermore, the auditing unit is used for judging whether the data source to be connected includes illegal information, and specifically comprises an information acquisition module, a first comparison and judgment module and a second comparison and judgment module, wherein,
the information acquisition module is used for acquiring the data source name of the data source to be connected and the field name of each database according to the connection attribute of each database in the data source to be connected and transmitting the information to the first comparison and judgment module;
the first comparison and judgment module is used for judging whether the name of the data source to be connected is included in a list of the data source which is not allowed to be connected by preset verification information, and if not, performing a field name verification step of the database; if yes, sending out prompt information that the audit is unqualified;
the second comparison and judgment module is used for judging whether the field name of the to-be-connected database is included in a field list which is not allowed to be connected by preset audit information, if not, judging that the to-be-connected data source does not have illegal information, and performing a sub-database creation step of the to-be-connected data source; and if so, sending out prompt information that the audit is unqualified.
The system further comprises a sub-database creating unit which is connected with the output end of the auditing unit and used for creating the sub-database by taking the name of the data source as the name of the table after the auditing unit judges that the data source to be connected has no illegal information, and uploading the corresponding data in the database to the sub-database according to the name of the field.
Further, the system also comprises a subscription configuration unit, which is used for receiving the data updating notification information of the data source to be connected; acquiring a data interface address of information to be continuously updated according to the data updating notification information; and acquiring the data information to be updated in the data source to be connected according to the interface address of the data updating information.
Specifically, the system stores interface mapping relations supporting different platform data sources, determines an API interface calling address of a target data source to be connected according to the interface mapping relations, determines a data interface address of information to be updated in a platform corresponding to the data source to be connected according to the API interface calling address, and further acquires the data information to be updated in the data source to be connected.
Furthermore, the data updating notification information includes the data protocol type of the data source to be connected, the system judges whether the data protocol type of the data source to be connected is the same as the data protocol type of the platform, if not, the system sends data conversion request information to the platform corresponding to the data source to be connected, and after receiving the data conversion request information, the platform corresponding to the data source to be connected encapsulates the data information to be updated and uploads the encapsulated data information to the system, so that effective butt joint of data with different protocol types is realized.
Example 3
The present embodiment provides a storage medium, which has the same inventive concept as embodiment 1, and has stored thereon computer instructions, which when executed perform the steps of one of the multiple data source configuration methods in embodiment 1.
Based on such understanding, the technical solution of the present embodiment or parts of the technical solution may be essentially implemented in the form of a software product, which is stored in a storage medium and includes several instructions to enable a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method of the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
Example 4
The present embodiment also provides a terminal, which has the same inventive concept as that of embodiment 1, and includes a memory and a processor, where the memory stores computer instructions executable on the processor, and the processor executes the computer instructions to perform the steps of the method for configuring multiple data sources in embodiment 1. The processor may be a single or multi-core central processing unit or a specific integrated circuit, or one or more integrated circuits configured to implement the present invention.
Each functional unit in the embodiments provided by the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
The above detailed description is for the purpose of describing the invention in detail, and it should not be construed that the detailed description is limited to the description, and it will be apparent to those skilled in the art that various modifications and substitutions can be made without departing from the spirit of the invention.
Claims (10)
1. A method for configuring multiple data sources is characterized in that: the method comprises the following steps:
configuring a data source to be connected;
judging whether the data source configuration is correct or not, and if not, sending out prompt information of incorrect configuration; if the result is correct, entering an auditing step;
comparing the database information of the data source to be connected with preset auditing information, judging whether illegal information exists in the data source to be connected, if not, creating a sub-database of the data source to be connected, and receiving the data information uploaded by the sub-database; and if so, sending out prompt information that the audit is unqualified.
2. The method of claim 1, wherein the method further comprises: the configuring of the data source to be connected specifically includes:
configuring the type of a data source to be connected;
configuring the connection attribute of each database in the data source to be connected;
and configuring relevant information of the data source to be connected, wherein the relevant information comprises a data source name, a user name, a password, an interface request mode, message content of an interface request, and the user name, the password, the maximum connection number, the minimum connection number, the driver name and the field name of a database in the data source to be connected.
3. The method of claim 2, wherein the method further comprises: the preset auditing information comprises a data source list which is not allowed to be connected and a field list which is not allowed to be connected;
the step of judging whether the data source to be connected includes illegal information specifically includes:
acquiring a data source name and a field name of each database according to the connection attribute of each database in the data source to be connected;
judging whether the name of the data source to be connected is included in a list of the data source which is not allowed to be connected by preset auditing information, and if not, auditing the field name of the database; if yes, sending out prompt information that the audit is unqualified;
judging whether the field name of the database to be connected is included in a field list which is not allowed to be connected by preset auditing information, and if not, judging that the data source to be connected does not have illegal information; and if so, sending out prompt information that the audit is unqualified.
4. The method of claim 1, wherein the method further comprises: the creating of the sub-database of the data source to be connected and the receiving of the data information uploaded by the sub-database specifically include:
and establishing a sub-database by taking the name of the data source as a table name, and uploading corresponding data in the database to the sub-database according to the field name.
5. The method of claim 1, wherein the method further comprises: the method further comprises a subscription configuration step:
receiving data updating notification information of a data source to be connected;
acquiring a data interface address of information to be continuously updated according to the data updating notification information;
and acquiring the data information to be updated in the data source to be connected according to the interface address of the data updating information.
6. A multiple data source configuration system, characterized by: the system comprises:
the data source configuration unit is used for configuring the data source to be connected;
the configuration judging unit is used for judging whether the data source configuration is correct or not, and if not, sending prompt information of incorrect configuration; if the result is correct, entering an auditing step;
the auditing unit is used for comparing the database information of the data source to be connected with preset auditing information, judging whether illegal information exists in the data source to be connected, if not, creating a sub-database of the data source to be connected, and receiving the data information uploaded by the sub-database; and if so, sending out prompt information that the audit is unqualified.
7. The method of claim 6, wherein the method further comprises: the data source configuration unit specifically includes:
the type configuration module is used for configuring the type of the data source to be connected;
the connection attribute configuration module is used for configuring the connection attribute of each database in the data source to be connected;
and the related information configuration module is used for configuring related information of the data source to be connected, wherein the related information comprises a data source name, a driver name, an interface request mode, message content of an interface request, and a user name, a password, a maximum connection number, a minimum connection number and a field name of a database in the data source to be connected.
8. The method of claim 6, wherein the method further comprises: the system also comprises a subscription configuration unit, which is used for receiving the data updating notification information of the data source to be connected; acquiring a data interface address of information to be continuously updated according to the data updating notification information; and acquiring the data information to be updated in the data source to be connected according to the interface address of the data updating information.
9. A storage medium having stored thereon computer instructions, characterized in that: the computer instructions when executed perform the steps of the method of configuring a plurality of data sources of any of claims 1-5.
10. A terminal comprising a memory and a processor, the memory having stored thereon computer instructions executable on the processor, the terminal comprising: the processor, when executing the computer instructions, performs the steps of the method for configuring a plurality of data sources of any of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011215258.5A CN112214475B (en) | 2020-11-04 | 2020-11-04 | Method, system, storage medium and terminal for configuring multiple data sources |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011215258.5A CN112214475B (en) | 2020-11-04 | 2020-11-04 | Method, system, storage medium and terminal for configuring multiple data sources |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112214475A true CN112214475A (en) | 2021-01-12 |
| CN112214475B CN112214475B (en) | 2023-07-07 |
Family
ID=74058200
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011215258.5A Active CN112214475B (en) | 2020-11-04 | 2020-11-04 | Method, system, storage medium and terminal for configuring multiple data sources |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112214475B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115685858A (en) * | 2023-01-05 | 2023-02-03 | 苏州慧工云信息科技有限公司 | JIT-based electronic billboard data controller and control method |
Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030112472A1 (en) * | 2001-12-14 | 2003-06-19 | Murata Kikai Kabushiki Kaisha | Internet facsimile apparatus and the apparatus setting method |
| US20080120129A1 (en) * | 2006-05-13 | 2008-05-22 | Michael Seubert | Consistent set of interfaces derived from a business object model |
| CN102629929A (en) * | 2012-04-18 | 2012-08-08 | 华为技术有限公司 | Method and system and device for obtaining data |
| CN106383914A (en) * | 2016-10-21 | 2017-02-08 | 广东亿迅科技有限公司 | Method and system for realizing configuration of multiple data sources based on cloud call platform |
| CN106470216A (en) * | 2015-08-14 | 2017-03-01 | 江贻芳 | A kind of Content Management System based on information sharing, interaction |
| CN108596741A (en) * | 2018-05-09 | 2018-09-28 | 平安科技（深圳）有限公司 | Network sale product management method, device, terminal device and storage medium |
| CN109558560A (en) * | 2018-11-30 | 2019-04-02 | 象山邱工联信息技术有限公司 | Cluster Web site management system based on cloud data management |
| CN109597823A (en) * | 2018-11-05 | 2019-04-09 | 中国平安财产保险股份有限公司 | Data source configuration method, device, computer equipment and storage medium |
| CN110138730A (en) * | 2019-04-02 | 2019-08-16 | 视联动力信息技术股份有限公司 | A kind of method for subscribing of protocol conversion device, device and storage medium |
| CN110430275A (en) * | 2019-08-09 | 2019-11-08 | 中国工商银行股份有限公司 | Data processing method, system, calculates equipment and medium at device |
| CN110569249A (en) * | 2019-08-07 | 2019-12-13 | 阿里巴巴集团控股有限公司 | data change pushing method and device and electronic equipment |
| CN110896358A (en) * | 2018-09-13 | 2020-03-20 | 亿阳信通股份有限公司 | Dynamic updating method and device for resource data in NFV |
| CN111343146A (en) * | 2020-02-04 | 2020-06-26 | 北京字节跳动网络技术有限公司 | Data auditing method, system, computer readable medium and electronic equipment |
-
2020
- 2020-11-04 CN CN202011215258.5A patent/CN112214475B/en active Active
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030112472A1 (en) * | 2001-12-14 | 2003-06-19 | Murata Kikai Kabushiki Kaisha | Internet facsimile apparatus and the apparatus setting method |
| US20080120129A1 (en) * | 2006-05-13 | 2008-05-22 | Michael Seubert | Consistent set of interfaces derived from a business object model |
| CN102629929A (en) * | 2012-04-18 | 2012-08-08 | 华为技术有限公司 | Method and system and device for obtaining data |
| CN106470216A (en) * | 2015-08-14 | 2017-03-01 | 江贻芳 | A kind of Content Management System based on information sharing, interaction |
| CN106383914A (en) * | 2016-10-21 | 2017-02-08 | 广东亿迅科技有限公司 | Method and system for realizing configuration of multiple data sources based on cloud call platform |
| CN108596741A (en) * | 2018-05-09 | 2018-09-28 | 平安科技（深圳）有限公司 | Network sale product management method, device, terminal device and storage medium |
| CN110896358A (en) * | 2018-09-13 | 2020-03-20 | 亿阳信通股份有限公司 | Dynamic updating method and device for resource data in NFV |
| CN109597823A (en) * | 2018-11-05 | 2019-04-09 | 中国平安财产保险股份有限公司 | Data source configuration method, device, computer equipment and storage medium |
| CN109558560A (en) * | 2018-11-30 | 2019-04-02 | 象山邱工联信息技术有限公司 | Cluster Web site management system based on cloud data management |
| CN110138730A (en) * | 2019-04-02 | 2019-08-16 | 视联动力信息技术股份有限公司 | A kind of method for subscribing of protocol conversion device, device and storage medium |
| CN110569249A (en) * | 2019-08-07 | 2019-12-13 | 阿里巴巴集团控股有限公司 | data change pushing method and device and electronic equipment |
| CN110430275A (en) * | 2019-08-09 | 2019-11-08 | 中国工商银行股份有限公司 | Data processing method, system, calculates equipment and medium at device |
| CN111343146A (en) * | 2020-02-04 | 2020-06-26 | 北京字节跳动网络技术有限公司 | Data auditing method, system, computer readable medium and electronic equipment |
Non-Patent Citations (2)
| Title |
|---|
| DIMITRIOS KOUZAPAS 等: "Typechecking protocols with Mungo and StMungo: A session type toolchain for Java", 《SCIENCE OF COMPUTER PROGRAMMING》 * |
| 王青: "面向WIA-PA网络的边缘网关的研究与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115685858A (en) * | 2023-01-05 | 2023-02-03 | 苏州慧工云信息科技有限公司 | JIT-based electronic billboard data controller and control method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112214475B (en) | 2023-07-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108762803B (en) | Configuration management method, device, terminal equipment and storage medium | |
| CN109739873A (en) | A kind of business datum querying method, device, equipment and readable storage medium storing program for executing | |
| CN109783249B (en) | Platform access method and device, terminal and computer readable storage medium | |
| CN111737227B (en) | Data modification method and system | |
| CN110647460B (en) | Test resource management method and device and test client | |
| CN111177776A (en) | Multi-tenant data isolation method and system | |
| CN110673933A (en) | ZooKeeper-based distributed asynchronous queue implementation method, device, equipment and medium | |
| CN108763323B (en) | Meteorological grid point file application method based on resource set and big data technology | |
| US20220377556A1 (en) | Internet-of-things device registration method and apparatus, device, and storage medium | |
| CN110895603A (en) | Multi-system account information integration method and device | |
| CN112214475A (en) | Method, system, storage medium and terminal for configuring multiple data sources | |
| CN113935010A (en) | Mobile banking login method and device based on block chain and 5G message | |
| WO2022033079A1 (en) | Pico base station configuration method and apparatus, and storage medium and electronic apparatus | |
| CN111046245A (en) | Multi-source heterogeneous data source fusion calculation method, system, equipment and storage medium | |
| CN112395339B (en) | Intersystem data admission verification method, device, computer equipment and storage medium | |
| CN113204747A (en) | Account management method, account management device, server and storage medium | |
| CN108647139B (en) | System test method, device, storage medium and electronic device | |
| CN110807000A (en) | File repair method and device, electronic equipment and storage medium | |
| CN112328672A (en) | Method, system, storage medium and terminal for mapping API (application program interface) interface by data service | |
| CN116204428A (en) | Test case generation method and device | |
| CN111880864B (en) | HTTP-based model calling method, system, computer device and storage medium | |
| CN114445204A (en) | Cloud-plus-end-based tax control equipment service processing method and system | |
| CN111324654A (en) | Interface calling method, system, computer device and computer readable storage medium | |
| CN111752559A (en) | Front-end and back-end separation system, method, device and storage medium | |
| CN111061543A (en) | Multi-tenant workflow engine service method, device and server |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |