CN112214475B - 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
- CN112214475B CN112214475B CN202011215258.5A CN202011215258A CN112214475B CN 112214475 B CN112214475 B CN 112214475B CN 202011215258 A CN202011215258 A CN 202011215258A CN 112214475 B CN112214475 B CN 112214475B
- Authority
- CN
- China
- Prior art keywords
- data
- data source
- information
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000012550 audit Methods 0.000 claims abstract description 19
- 238000006243 chemical reaction Methods 0.000 claims description 8
- 210000001503 joint Anatomy 0.000 claims 2
- 238000012545 processing Methods 0.000 abstract description 4
- 238000013507 mapping Methods 0.000 description 4
- 238000003032 molecular docking Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/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—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method, a system, a storage medium and a terminal for configuring various data sources, which belong to the technical field of data source processing, wherein the method comprises the steps of configuring the data sources to be connected; judging whether the data source configuration is correct or not, and if the data source configuration is incorrect, sending out prompt information of incorrect configuration; if the result is correct, an auditing step is carried out; comparing the database information of the data source to be connected with preset audit 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; if the information exists, sending out prompt information of unqualified auditing. The invention judges whether the data source configuration is correct or not by configuring the plurality of data sources to be connected and checks the data sources, so that the sub-database of the data sources to be connected can be created, the configuration of the plurality of 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
Along with the development of internet technology, the intelligent travel plays a vital role in coordinating the demands of users, the configuration of travel resources and the like. However, as travel data in the internet has exploded, the data of the "wisdom travel" platform needs to be updated in real time to achieve the goal of providing users with more accurate cultural travel data.
The data update of the traditional "wisdom travel" platform relies on manual importation, i.e. manual addition, insertion, deletion, etc. The data source is used as a device or original media for providing certain needed data, stores all information for establishing database connection, can realize the connection of corresponding databases by providing correct data source names, and provides a new thought for the data update of the intelligent travel platform. At present, the configuration of data sources depends on the modification of access control codes by developers for different data source types, however, the workload of the data source configuration mode is too large, the efficiency is low, the data source configuration requirement of increasingly updated intelligent travel systems 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 solve the problem of low efficiency of a data source configuration mode in the prior art and provides a plurality of data source configuration methods, a plurality of data source configuration systems, a plurality of data source storage media and a plurality of data source terminals.
The aim of the invention is realized by the following technical scheme: a method of configuring a plurality of data sources, 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 the data source configuration is incorrect, sending out prompt information of incorrect configuration; if the result is correct, an auditing step is carried out; comparing the database information of the data source to be connected with preset audit 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; if the information exists, sending out prompt information of unqualified auditing.
As an option, the configuring the data source to be connected specifically includes: configuring the type of a data source to be connected; configuring connection attributes of all databases in a 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 audit information comprises a data source list which is not allowed to be connected and a field list which is not allowed to be connected; judging whether the data source to be connected comprises illegal information specifically comprises:
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 data source name of the data source to be connected is included in a data source list which is not allowed to be connected by preset auditing information, and if not, performing a field name auditing step of the database; if so, sending out prompt information of unqualified audit;
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 illegal information does not exist in the data source to be connected; if so, sending out prompt information of unqualified audit.
As an option, the creating a sub-database of the data source to be connected, and receiving the data information uploaded by the sub-database specifically includes: and creating a sub-database by taking the data source name as the 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 step of subscribing to the configuration: receiving data update notification information of a data source to be connected; acquiring a data interface address of the information to be updated according to the data update 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 explained that the technical features corresponding to the options of the above method may be combined with each other or replaced to form a new technical scheme.
The invention also includes a system for configuring a plurality of data sources, the 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 the data source configuration is incorrect, sending out prompt information of incorrect configuration; if the result is correct, an auditing step is carried out; 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; if the information exists, sending out prompt information of unqualified auditing.
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; 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 program 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 a data source to be connected; acquiring a data interface address of the information to be updated according to the data update 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 options of the above system may be combined with each other or replaced to form a new technical scheme.
The present invention also includes a storage medium having stored thereon computer instructions that when executed perform the steps of the above-described method of configuring a plurality of data sources.
The invention also includes a terminal comprising a memory and a processor, the memory having stored thereon computer instructions executable on the processor, the processor executing the steps of the above-described one of a plurality of data source configuration methods when the processor executes the computer instructions.
Compared with the prior art, the invention has the beneficial effects that:
(1) According to the method, the configuration of the plurality of data sources to be connected is carried out, whether the configuration of the data sources to be connected is correct is judged, after the configuration is correct, the database information of the data sources to be connected is checked, after the checking is passed, a sub database of the data sources to be connected is created, the data information uploaded by the sub database is received, the configuration of the plurality of 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 a smart travel platform can be met; the invention examines and approves the data source to be connected, realizes the rapid examination and approval and rapid connection of the data source, and greatly improves the working efficiency.
(2) The data update notification information comprises the interface address of the data information to be updated, and the data can be updated rapidly according to the interface address of the data information to be updated by receiving the data update notification information of the data source to be connected, so that the data update request of the intelligent travel platform is met.
Drawings
The following detailed description of the present invention is further detailed in conjunction with the accompanying drawings, which are provided to provide a further understanding of the present application, and in which like reference numerals are used to designate like or similar parts throughout the several views, and in which the illustrative examples and descriptions thereof are used to explain the present application and are not meant to be unduly limiting.
FIG. 1 is a flow chart of the method of embodiment 1 of the present invention;
fig. 2 is a schematic diagram of an operation page of a new data source according to embodiment 1 of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made apparent and fully understood from the accompanying drawings, in which some, but not all embodiments of the invention are shown. 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.
In the description of the present invention, it should be noted that directions or positional relationships indicated as being "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer", etc. are directions or positional relationships described based on the drawings are merely for convenience of describing the present invention and simplifying the description, and do not indicate or imply that the apparatus or elements to be referred to must have a specific orientation, be constructed and operated in a specific orientation, and thus should not be construed as limiting the present invention. Furthermore, the terms "first," "second," and the like 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 explicitly specified and limited otherwise, 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; can be directly connected or indirectly connected through an intermediate medium, and can be communication between two elements. The specific meaning of the above terms in the present invention will be understood in specific cases by those of ordinary skill in the art.
In addition, the technical features of the different embodiments of the present invention described below may be combined with each other as long as they do not collide with each other.
Example 1
As shown in fig. 1, in embodiment 1, a method for configuring multiple data sources, using a "smart 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 number of data sources to be connected specifically according to the actual service requirements, and can realize the connection with new data sources by adding the number of data sources to be connected.
S02: judging whether the data source configuration is correct or not, and if the data source configuration is incorrect, sending out prompt information of incorrect configuration; if the result is correct, an auditing step is carried out;
s03: comparing the database information of the data source to be connected with preset audit 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; if the information exists, sending out prompt information of unqualified auditing.
Further, the configuring 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, data source types include, but are not limited to, HTTP/HTTPS, FTP/STFP.
S012: configuring connection attributes of all databases in a data source to be connected; specifically, the HTTP request can be sent to the corresponding database to further obtain the API interface information of the database, so that the database is called. The database types include, but are not limited to, mysql, oracle, sqlsever, hive, and the file types stored in the database include, but are not limited to, txt file, text file, excel file, and csl file.
S013: and configuring related information of the data source to be connected, wherein the related information comprises a data source name, a user name, a password, a data source valid period, an interface request mode, message contents of an interface request, and the user name, the password, a driver name, a data archiving 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 data transmission is facilitated; when the number of databases in the data source to be connected is smaller than the minimum connection number, the connection between the databases to be connected and the intelligent travel platform is automatically disconnected.
Further, as shown in fig. 2, when the new data source to be connected needs to be subjected to data docking, the connection between the "intelligent travel" platform and the new data source to be connected can be realized only by adding configuration information of the new data source to be connected.
Further, in step S02, it is determined whether the configuration of the data source is correct, specifically, by the connection test, if the database in the data source to be connected is successfully connected with the "wisdom travel" platform, the configuration is correct, otherwise, the configuration is incorrect.
Further, the preset audit information includes 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 overdue connection can cause the potential risk of information leakage of the intelligent travel platform. In the step S03, determining whether the data source to be connected includes illegal information specifically includes:
s031: and acquiring the data source name 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 travel platform with each database in the data source to be connected so as to acquire the data source name of the data source to be connected and the field name of each database.
S032: judging whether the data source name of the data source to be connected is included in a data source list which is not allowed to be connected by preset auditing information, and if not, performing a field name auditing step of the database; if so, sending out prompt information of unqualified audit;
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 illegal information does not exist in the data source to be connected, and creating a sub-database of the data source to be connected; if so, sending out prompt information of unqualified audit.
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 creating a sub-database by taking the data source name as the table name, and uploading corresponding data in the database to the sub-database according to the field name.
Further, the method also comprises the step of information verification:
s035: and checking the data in the sub-database, and merging or deleting the redundant information. As an embodiment, if a field name in the statistical database is greater than 1, the field data information is merged.
As an option, after the sub-database is built, the database can be archived according to the names of the sub-databases, so that the sub-databases are convenient for developers to check.
Further, the method further comprises the step of S04 subscription configuration:
s041: receiving data update notification information of a data source to be connected;
s042: acquiring a data interface address of the information to be updated according to the data update 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 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 the platform corresponding to the data source to be connected according to the API interface calling address, and further obtains the information of the data to be updated in the data source to be connected.
Further, the data update notification information includes a data protocol type of a data source to be connected, the "intelligent 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 data update notification information sends data conversion request information to the platform corresponding to the data source to be connected, and after the platform corresponding to the data source to be connected receives the data conversion request information, the data information to be updated is packaged and then uploaded to the "intelligent travel" platform, so that effective docking of data of different protocol types is realized.
According to the method, the configuration of the plurality of data sources to be connected is carried out, whether the configuration of the data sources to be connected is correct is judged, after the configuration is correct, the database information of the data sources to be connected is checked, after the checking is passed, a sub database of the data sources to be connected is created, the data information uploaded by the sub database is received, the configuration of the plurality of 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 a smart travel platform can be met; the invention examines and approves the data source to be connected, realizes the rapid examination and approval and rapid connection of the data source, and greatly improves the working efficiency.
Example 2
The present embodiment provides a plurality of data source configuration systems, which have the same inventive concept as embodiment 1, including: 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 the data source configuration is incorrect, sending out prompt information of incorrect configuration; if the result is correct, an auditing step is carried out; 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; if the information exists, sending out prompt information of unqualified auditing.
Furthermore, the data source configuration unit can set the number of the data sources to be connected and the data sources to be connected specifically in real time according to the actual service requirement of the system, and the data sources to be connected are connected with the new data sources 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.
Still further, the type configuration module is configured to configure types of data sources to be connected, and the types of data sources include, but are not limited to, HTTP/HTTPS, FTP/STFP.
Further, the connection attribute configuration module is configured to configure connection attributes of the databases in the data sources to be connected. The database can be called by sending an HTTP request to the corresponding database to further acquire the API interface information of the database. The database types include, but are not limited to, mysql, oracle, sqlsever, hive, and the file types stored in the database include, but are not limited to, txt file, text file, excel file, and csl file.
Further, the related information configuration module is configured to configure related information of the data source to be connected, including a data source name, a user name, a password, a data source validity period, an interface request mode, a message content of an interface request, and a user name, a password, a driver name, a data archiving 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 data transmission is facilitated; and when the number of the databases in the data sources to be connected is smaller than the minimum connection number, automatically disconnecting the connection between the databases to be connected and the system.
More specifically, when the system needs to perform data docking on the 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.
Further, the system also comprises a data source configuration judging module for judging whether the data source configuration is correct or not specifically through a connection test, if the database in the data source to be connected is successfully connected with the system, the configuration is correct, otherwise, the configuration is incorrect.
Furthermore, the system further comprises an auditing unit, wherein the auditing unit stores preset auditing information, 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 overdue connection can cause the potential risk of information leakage of the intelligent travel platform.
Further, the auditing unit is used for judging whether the data source to be connected comprises illegal information, and specifically comprises an information acquisition module, a first comparison judging module and a second comparison judging 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 judgment module;
the first comparison judging module is used for judging whether the data source name of the data source to be connected is included in a data source list which is not allowed to be connected by preset auditing information, and if not, performing a field name auditing step of the database; if so, sending out prompt information of unqualified audit;
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 carrying out a sub-database creation step of the to-be-connected data source; if so, sending out prompt information of unqualified audit.
The system further comprises a sub-database creation unit connected with the output end of the auditing unit, and the system is used for creating a 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 does not have illegal information, and uploading corresponding data in the database to the sub-database according to the field name.
Further, the system also comprises a subscription configuration unit, a data updating notification unit and a data updating notification unit, wherein the subscription configuration unit is used for receiving data updating notification information of a data source to be connected; acquiring a data interface address of the information to be updated according to the data update 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 data sources of different platforms, determines an API interface calling address of a data source to be connected with a target 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 obtains the information of the data to be updated in the data source to be connected.
Further, the data update notification information includes a 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 data update notification information sends data conversion request information to the platform corresponding to the data source to be connected, and after the platform corresponding to the data source to be connected receives the data conversion request information, the data information to be updated is packaged and then uploaded to the system, so that effective docking of data of different protocol types is realized.
Example 3
The present embodiment provides a storage medium having the same inventive concept as embodiment 1, on which computer instructions are stored, which when executed perform the steps of one or more of the data source configuration methods of embodiment 1.
Based on such understanding, the technical solution of the present embodiment may be essentially or a part contributing to the prior art or a part of the technical solution may be embodied in the form of a software product stored in a storage medium, including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods of the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
Example 4
The present embodiment also provides a terminal having the same inventive concept as embodiment 1, including a memory and a processor, the memory storing computer instructions executable on the processor, the processor executing the steps of the one or more data source configuration methods of embodiment 1 when the processor executes the computer instructions. 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 invention.
The functional units in the embodiments provided in the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit.
The foregoing detailed description of the invention is provided for illustration, and it is not to be construed that the detailed description of the invention is limited to only those illustration, but that several simple deductions and substitutions can be made by those skilled in the art without departing from the spirit of the invention, and are to be considered as falling within the scope of the invention.
Claims (8)
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 the data source configuration is incorrect, sending out prompt information of incorrect configuration; if the result is correct, an auditing step is carried out;
comparing the database information of the data source to be connected with preset audit 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; if the information exists, sending out prompt information of unqualified auditing;
the method further comprises the subscription configuration step of:
receiving data update notification information of a data source to be connected;
acquiring a data interface address of information to be updated according to the data update notification information;
acquiring data information to be updated in a data source to be connected according to an interface address of the data update information;
the data update notification information comprises the data protocol type of the data source to be connected, the intelligent 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 data update notification information sends data conversion request information to the platform corresponding to the data source to be connected, and after the platform corresponding to the data source to be connected receives the data conversion request information, the data information to be updated is packaged and then uploaded to the intelligent travel platform, so that effective butt joint of data of different protocol types is realized;
the creation of the sub-database of the data source to be connected further comprises:
and checking the data in the sub-database, and merging or deleting the redundant information.
2. The method for configuring multiple data sources according to claim 1, wherein: the configuring the data source to be connected specifically comprises the following steps:
configuring the type of a data source to be connected;
configuring connection attributes of all databases in a 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, a driver name and a field name of a database in the data source to be connected.
3. The method for configuring multiple data sources according to claim 2, wherein: the preset audit information comprises a data source list which is not allowed to be connected and a field list which is not allowed to be connected;
judging whether the data source to be connected comprises illegal information specifically comprises:
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 data source name of the data source to be connected is included in a data source list which is not allowed to be connected by preset auditing information, and if not, performing a field name auditing step of the database; if so, sending out prompt information of unqualified audit;
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 illegal information does not exist in the data source to be connected; if so, sending out prompt information of unqualified audit.
4. The method for configuring multiple data sources according to claim 1, wherein: the creating a sub-database of the data source to be connected, and receiving the data information uploaded by the sub-database specifically includes:
and creating a sub-database by taking the data source name as the table name, and uploading corresponding data in the database to the sub-database according to the field name.
5. 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 the data source configuration is incorrect, sending out prompt information of incorrect configuration; if the result is correct, an auditing step is carried out;
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; if the information exists, sending out prompt information of unqualified auditing;
the system also comprises a subscription configuration unit, a data updating notification unit and a data updating notification unit, wherein the subscription configuration unit is used for receiving data updating notification information of a data source to be connected; acquiring a data interface address of the information to be updated according to the data update notification information; acquiring data information to be updated in a data source to be connected according to an interface address of the data update information;
the data update notification information comprises the data protocol type of the data source to be connected, the intelligent 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 data update notification information sends data conversion request information to the platform corresponding to the data source to be connected, and after the platform corresponding to the data source to be connected receives the data conversion request information, the data information to be updated is packaged and then uploaded to the intelligent travel platform, so that effective butt joint of data of different protocol types is realized;
the creation of the sub-database of the data source to be connected further comprises:
and checking the data in the sub-database, and merging or deleting the redundant information.
6. The multiple data source configuration system of claim 5, wherein: 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;
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 program 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.
7. A storage medium having stored thereon computer instructions, characterized by: the computer instructions, when executed, perform the steps of one or more data source configuration methods of any of claims 1-4.
8. A terminal comprising a memory and a processor, the memory having stored thereon computer instructions executable on the processor, characterized by: the processor, when executing the computer instructions, performs the steps of one or more data source configuration methods of any one of claims 1-4.
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 CN112214475A (en) | 2021-01-12 |
| CN112214475B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115685858B (en) * | 2023-01-05 | 2023-04-07 | 苏州慧工云信息科技有限公司 | JIT-based electronic billboard data controller and control method |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| 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 |
| CN111343146A (en) * | 2020-02-04 | 2020-06-26 | 北京字节跳动网络技术有限公司 | Data auditing method, system, computer readable medium and electronic equipment |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7268921B2 (en) * | 2001-12-14 | 2007-09-11 | Murata Kikai Kabushiki Kaisha | Internet facsimile apparatus and the apparatus setting method |
| WO2008005102A2 (en) * | 2006-05-13 | 2008-01-10 | Sap Ag | Consistent set of interfaces derived from a business object model |
| CN102629929B (en) * | 2012-04-18 | 2015-07-08 | 华为技术有限公司 | Method and system and device for obtaining data |
| CN106383914B (en) * | 2016-10-21 | 2020-03-17 | 广东亿迅科技有限公司 | Method and system for realizing configuration of multiple data sources based on cloud call platform |
| CN110896358A (en) * | 2018-09-13 | 2020-03-20 | 亿阳信通股份有限公司 | Dynamic updating method and device for resource data in NFV |
| CN109597823B (en) * | 2018-11-05 | 2023-08-29 | 中国平安财产保险股份有限公司 | Data source configuration method, device, computer equipment and storage medium |
| CN109558560B (en) * | 2018-11-30 | 2021-06-15 | 象山邱工联信息技术有限公司 | Cluster website management system based on cloud data management |
| CN110569249A (en) * | 2019-08-07 | 2019-12-13 | 阿里巴巴集团控股有限公司 | data change pushing method and device and electronic equipment |
-
2020
- 2020-11-04 CN CN202011215258.5A patent/CN112214475B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| 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 |
| CN111343146A (en) * | 2020-02-04 | 2020-06-26 | 北京字节跳动网络技术有限公司 | Data auditing method, system, computer readable medium and electronic equipment |
Non-Patent Citations (2)
| Title |
|---|
| Typechecking protocols with Mungo and StMungo: A session type toolchain for Java;Dimitrios Kouzapas 等;《Science of Computer Programming》;第155卷;52-75 * |
| 面向WIA-PA网络的边缘网关的研究与实现;王青;《中国优秀硕士学位论文全文数据库 信息科技辑》(第02期);I136-480 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112214475A (en) | 2021-01-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108762803B (en) | Configuration management method, device, terminal equipment and storage medium | |
| US9578027B1 (en) | Multiple data store authentication | |
| US8073932B2 (en) | Business logic device and processing method | |
| US8064583B1 (en) | Multiple data store authentication | |
| CN109739873A (en) | A kind of business datum querying method, device, equipment and readable storage medium storing program for executing | |
| CN109460841B (en) | User account opening method, system and storage medium | |
| CN112788128B (en) | Business information pushing method and device, storage medium and electronic device | |
| CN111111214B (en) | Game archiving processing method, device and system | |
| CN112448956B (en) | Authority processing method and device of short message verification code and computer equipment | |
| CN112214475B (en) | Method, system, storage medium and terminal for configuring multiple data sources | |
| CN112685391A (en) | Service data migration method and device, computer equipment and storage medium | |
| CN107800667B (en) | Information processing method and access processing device | |
| CN117556008A (en) | Interaction method, medium, device and computing equipment based on large language model | |
| WO2022033079A1 (en) | Pico base station configuration method and apparatus, and storage medium and electronic apparatus | |
| US8005902B2 (en) | System and method for accelerated dynamic data message generation and transmission | |
| CN114205325A (en) | Message sending method, device, server and storage medium | |
| CN116226178A (en) | Data query method and device, storage medium and electronic device | |
| CN109656632A (en) | Interface automatic adaptation method, device, electronic equipment and computer readable storage medium | |
| CN114445204A (en) | Cloud-plus-end-based tax control equipment service processing method and system | |
| CN111049877B (en) | Big data external output method and device and data open platform | |
| CN111010676B (en) | Short message caching method, device and system | |
| CN114006939A (en) | Message pushing method and device | |
| CN115086436B (en) | inter-API parameter verification method and device, computer equipment and storage medium | |
| CN112328672A (en) | Method, system, storage medium and terminal for mapping API (application program interface) interface by data service | |
| CN113568682B (en) | Rule data verification method, device, computer equipment and storage 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |