CN111177671A - Data management platform and method and electronic equipment - Google Patents
Data management platform and method and electronic equipment Download PDFInfo
- Publication number
- CN111177671A CN111177671A CN201911324719.XA CN201911324719A CN111177671A CN 111177671 A CN111177671 A CN 111177671A CN 201911324719 A CN201911324719 A CN 201911324719A CN 111177671 A CN111177671 A CN 111177671A
- Authority
- CN
- China
- Prior art keywords
- data
- module
- query
- user
- platform
- 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
- 238000000034 method Methods 0.000 title claims abstract description 34
- 238000013523 data management Methods 0.000 title claims abstract description 18
- 238000012544 monitoring process Methods 0.000 claims abstract description 20
- 238000007726 management method Methods 0.000 claims abstract description 15
- 238000012795 verification Methods 0.000 claims description 25
- 230000002159 abnormal effect Effects 0.000 claims description 12
- 238000004458 analytical method Methods 0.000 claims description 5
- 238000012545 processing Methods 0.000 description 13
- 238000010586 diagram Methods 0.000 description 8
- 230000006870 function Effects 0.000 description 7
- 230000000694 effects Effects 0.000 description 6
- 239000008280 blood Substances 0.000 description 4
- 210000004369 blood Anatomy 0.000 description 4
- 238000004422 calculation algorithm Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 3
- 238000004590 computer program Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 230000007547 defect Effects 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000012827 research and development Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
- G06F21/31—User authentication
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
- G06F21/31—User authentication
- G06F21/41—User authentication where a single sign-on provides access to a plurality of computers
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L63/00—Network architectures or network communication protocols for network security
- H04L63/08—Network architectures or network communication protocols for network security for authentication of entities
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L63/00—Network architectures or network communication protocols for network security
- H04L63/08—Network architectures or network communication protocols for network security for authentication of entities
- H04L63/0815—Network architectures or network communication protocols for network security for authentication of entities providing single-sign-on or federations
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L63/00—Network architectures or network communication protocols for network security
- H04L63/08—Network architectures or network communication protocols for network security for authentication of entities
- H04L63/083—Network architectures or network communication protocols for network security for authentication of entities using passwords
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L63/00—Network architectures or network communication protocols for network security
- H04L63/12—Applying verification of the received information
- H04L63/126—Applying verification of the received information the source of the received data
Landscapes
- Engineering & Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Hardware Design (AREA)
- Computing Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Signal Processing (AREA)
- Computer Networks & Wireless Communication (AREA)
- Software Systems (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Storage Device Security (AREA)
Abstract
The invention discloses a data management platform, a method and an electronic device, wherein the platform comprises: the authority examination and approval management module is connected with the database interface and used for examining, approving and managing the access authorities of different users to the data tables in the database through the database interface; the display module is used for displaying the data table information of which the user has the access right; the system comprises an ad hoc query module, a message queue and a query module, wherein the ad hoc query module is used for receiving a user query task, sending the query task through the message queue and obtaining a query result; and the application module is used for completing data synchronization according to the configuration information of the data table. The invention aims to provide unified management for data platforms, improve the convenience of data use, provide data authority approval management, display configuration of data tables, online data query, data synchronization and data monitoring alarm, provide the entrance of each big data platform by adopting a single sign-on mode, greatly facilitate the operation of users on data and improve the user experience.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a data management platform, a data management method, electronic equipment and a computer readable medium.
Background
With the development of the internet and digital technology, more and more data are filling the lives of people. Basic processing of data mainly relates to three aspects of data query, data authority and data display, so that the number of derived data platforms is increased, but the query modes, authority control and other management of each data platform are different, so that data management is disordered, and a user can obtain the data only through complex operation. Taking the data of the privacy cluster as an example, a user needs to examine and approve on the bastion removing machine layer by layer, the examination and approval has no record, and the examination and approval cannot be transparent and tracked.
Disclosure of Invention
The invention aims to solve the technical problems that in the prior art, each platform is not uniform in data management and is complicated in data use.
In order to solve the above technical problem, a first aspect of the present invention provides a data management platform, including:
the authority examination and approval management module is connected with the database interface and used for examining, approving and managing the access authorities of different users to the data tables in the database through the database interface;
the display module is used for displaying the data table information of which the user has the access right;
the system comprises an ad hoc query module, a message queue and a query module, wherein the ad hoc query module is used for receiving a user query task, sending the query task through the message queue and obtaining a query result;
and the application module is used for completing data synchronization according to the configuration information of the data table.
According to a preferred embodiment of the present invention, the data table information includes a meaning of each data table and a meaning of each field, and the presentation module includes:
the receiving module is used for receiving the selection operation of a user on the data table and/or the field;
and the display module is used for displaying the meanings of the data tables and/or the fields with the access authority of the user and displaying the data of the data tables and/or the fields selected by the user.
According to a preferred embodiment of the present invention, the application module comprises:
the configuration information storage module is used for storing configuration information which corresponds to the script information one by one;
the monitoring module is used for monitoring whether newly stored configuration information exists;
and the synchronization module is used for synchronously executing script information corresponding to the newly stored configuration information when the newly stored configuration information is monitored.
According to a preferred embodiment of the invention, the platform further comprises:
and the single sign-on module is used for receiving a unified sign-on account number and a password of a user to finish the sign-on of different data platforms.
According to a preferred embodiment of the present invention, the single sign-on module comprises:
the receiving module is used for receiving a uniform login account and a uniform password of a user;
the verification module is used for sending the unified login account and the password to a unified server, receiving a verification code returned by the unified server, and verifying whether the unified login account and the password are correct or not according to the verification code;
and the login module is used for completing login of different data platforms when the unified login account and the password are correct.
According to a preferred embodiment of the invention, the platform further comprises:
the storage module is used for storing the query task and the query result of the ad hoc query module and the preset query time of the query task, and sending the corresponding query task to the ad hoc query module when the preset query time is reached;
the display module is further used for analyzing the query result and displaying the analysis result.
According to a preferred embodiment of the invention, the platform further comprises:
and the monitoring alarm module is used for monitoring whether the data of each data table is abnormal or not, and sending alarm information when the data is abnormal.
According to a preferred embodiment of the invention, the platform further comprises:
and the searching module is used for configuring a workflow or a blood relation map to search a data source.
In order to solve the above technical problem, a second aspect of the present invention provides a data management method, including:
examining and approving and managing access rights of different users to a data table in the database through a database interface;
displaying the data table information of which the user has access authority;
receiving a user query task, sending the query task through a message queue and acquiring a query result;
and completing data synchronization according to the configuration information of the data table.
According to a preferred embodiment of the present invention, the data table information includes a meaning of each data table and a meaning of each field, and the data table information showing that the user has access right includes:
receiving the selection operation of a user on a data table and/or a field;
the display device is used for displaying the meanings of the data tables and/or fields which are accessed by the user and displaying the data of the data tables and/or fields selected by the user.
According to a preferred embodiment of the present invention, the performing data synchronization according to the configuration information of the data table includes:
storing configuration information corresponding to the script information one by one;
monitoring whether newly stored configuration information exists;
and when the newly stored configuration information is monitored, synchronously executing script information corresponding to the newly stored configuration information.
According to a preferred embodiment of the invention, the method further comprises:
and receiving a unified login account and a password of the user to finish login of different data platforms.
According to a preferred embodiment of the present invention, the receiving a unified login account and password of a user to complete login to different data platforms includes:
receiving a unified login account and a password of a user;
sending the unified login account and the password to a unified server, receiving a verification code returned by the unified server, and verifying whether the unified login account and the password are correct or not according to the verification code;
and when the unified login account and the password are correct, completing login of different data platforms.
According to a preferred embodiment of the invention, the method further comprises:
storing the query task and the query result of the ad hoc query module and the preset query time of the query task, and sending the corresponding query task to the ad hoc query module when the preset query time is reached;
and analyzing the query result and displaying the analysis result.
According to a preferred embodiment of the invention, the method further comprises:
and monitoring whether the data of each data table is abnormal or not, and sending alarm information when the data is abnormal.
According to a preferred embodiment of the invention, the method further comprises:
configuring a workflow or a blood relationship map to search a data source.
In order to solve the above technical problem, a third aspect of the present invention provides an electronic apparatus comprising:
a processor; and
a memory storing computer executable instructions that, when executed, cause the processor to perform the method described above.
In order to solve the above technical problem, a fourth aspect of the present invention proposes a computer-readable storage medium, wherein the computer-readable storage medium stores one or more programs that, when executed by a processor, implement the above method.
The invention connects the authority examination and approval management module with the database interface, and realizes the examination and approval and management of the access authority of the data table and the field in the database through the database interface, thereby avoiding the complicated examination and approval process of continuously sending mails and leading the authority examination and approval to have traces. The data sheet information with the access right of the user is directly displayed through the display module, so that the defects that the user logs in a bastion machine and sees a terminal black window are overcome, and the user experience is greatly optimized; the ad hoc query module realizes real-time communication and message transmission of query results through a message queue, avoids a plurality of intermediate processes and greatly reduces the operation time of data personnel; data synchronization is supported by the application module. The invention aims to provide unified management for a data platform, improve the convenience of data use, provide data authority approval management, display configuration of a data table, online data query, data synchronization and data monitoring alarm, provide an entrance of each big data platform by adopting a single sign-on mode, support the functions of configuring a timer and probing the source of data, greatly facilitate the operation of a user on the data and improve the user experience.
Drawings
In order to make the technical problems solved by the present invention, the technical means adopted and the technical effects obtained more clear, the following will describe in detail the embodiments of the present invention with reference to the accompanying drawings. It should be noted, however, that the drawings described below are only illustrations of exemplary embodiments of the invention, from which other embodiments can be derived by those skilled in the art without inventive step.
FIG. 1 is a schematic diagram of a structural framework of a data management platform according to the present invention;
FIGS. 2 a-2 b are schematic diagrams of a display module displaying data table information according to the present invention;
FIGS. 3 a-3 b are alternative diagrams of the display module displaying spreadsheet information according to the present invention;
FIG. 4 is a flow chart of a data management method of the present invention;
FIG. 5 is a block diagram of an exemplary embodiment of an electronic device in accordance with the present invention;
FIG. 6 is a diagrammatic representation of one embodiment of a computer-readable medium of the present invention.
Detailed Description
Exemplary embodiments of the present invention will now be described more fully hereinafter with reference to the accompanying drawings, in which exemplary embodiments of the invention may be embodied in many specific forms, and should not be construed as limited to the embodiments set forth herein. Rather, these exemplary embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of the invention to those skilled in the art.
The structures, properties, effects or other characteristics described in a certain embodiment may be combined in any suitable manner in one or more other embodiments, while still complying with the technical idea of the invention.
In describing particular embodiments, specific details of structures, properties, effects, or other features are set forth in order to provide a thorough understanding of the embodiments by one skilled in the art. However, it is not excluded that a person skilled in the art may implement the invention in a specific case without the above-described structures, performances, effects or other features.
The flow chart in the drawings is only an exemplary flow demonstration, and does not represent that all the contents, operations and steps in the flow chart are necessarily included in the scheme of the invention, nor does it represent that the execution is necessarily performed in the order shown in the drawings. For example, some operations/steps in the flowcharts may be divided, some operations/steps may be combined or partially combined, and the like, and the execution order shown in the flowcharts may be changed according to actual situations without departing from the gist of the present invention.
The block diagrams in the figures generally represent functional entities and do not necessarily correspond to physically separate entities. I.e. these functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different networks and/or processor means and/or microcontroller means.
The same reference numerals denote the same or similar elements, components, or parts throughout the drawings, and thus, a repetitive description thereof may be omitted hereinafter. It will be further understood that, although the terms first, second, third, etc. may be used herein to describe various elements, components, or sections, these elements, components, or sections should not be limited by these terms. That is, these phrases are used only to distinguish one from another. For example, a first device may also be referred to as a second device without departing from the spirit of the present invention. Furthermore, the term "and/or", "and/or" is intended to include all combinations of any one or more of the listed items.
Fig. 1 is a schematic structural framework diagram of a data management platform provided by the present invention, and as shown in fig. 1, the platform includes: authority examination and approval management module 11, display module 12, ad hoc inquiry module 13 and application module 14, wherein:
the authority examination and approval management module 11 is connected with a database interface and is used for examining, approving and managing the access authorities of different users to the data tables in the database through the database interface;
for example, the database may be a database in a financial cluster such as a cloud map, a smart phone, etc., a database interface for operating the database is reserved in the database, and the permission approval management module 11 may control the database of the financial cluster through the database interface, and the data table has related permissions to fields, so that the permission approval has a trace to be found.
Specifically, the permission approval management module 11 may approve access permissions of different users to data tables and fields in the database according to approval information issued by an administrator; and configuring and managing the access rights of different users to the data tables and the fields in the database according to the user attribute information of the users, such as department role information (such as market department, research and development department and the like). Furthermore, the permission approval management module 11 may store the access permission as authentication information for authenticating access to the data table and the field, and in the data display and query process, only when a display or query task including authentication information corresponding to the data table and the field is included, the data table may be displayed or queried, so that different persons may have different display and query permissions on the data table, thereby protecting data privacy.
The display module 12 is used for displaying the data table information of which the user has the access right;
in the present invention, the data table information is unified information for all data tables in the database, including the meaning of each data table, and the meaning of each field, which may be a data dictionary specifically, and the presentation module 12 includes:
the receiving module is used for receiving the selection operation of a user on the data table and/or the field; the selection operation may be a click operation of a user on a data table header and/or a field, or a click operation on a "one-key generation" button in the display module.
And the display module is used for displaying the meanings of the data tables and/or the fields with the access authority of the user and displaying the data of the data tables and/or the fields selected by the user.
In one illustration, as shown in fig. 2a, the data tables of the database to which the user has access rights include table 1 and table 2, there is access to fields 1 and 3 of table 1, to fields 2 and 3 of table 2, in the display module 10, table 1 is displayed as "9 month new loan user statistics table", table 1 field 1 is "user name", table 1 field 3 is "gender", table 2 is "9 month new loan user statistics table", table 2 field 2 is "user name", table 2 field 3 is "contact information", as shown in fig. 2b, when the user clicks the field 1 of table 1 and the field 2 of table 2, a new data table 3 is generated from the field 1 of table 1 and the field 2 of table 2, and the data of the new data table 3 is displayed in the display module 10. In another illustration, as shown in fig. 3a, the data tables of the database to which the user has access authority include table 1 and table 2, the field 1 and the field 3 of table 1 have access authority, the field 2 and the field 3 of table 2 have access authority, table 1 is displayed in the display module 10 as "9 month new loan user statistics table", table 1 is displayed as "user name", table 1 is displayed as "gender", table 2 is displayed as "9 month new investment user statistics table", table 2 is displayed as "user name", table 2 is displayed as "contact method", and the display module 10 is displayed as "one key generation" button, when the user clicks the "one key generation" button, as shown in fig. 3b, the display module 10 displays data of all fields to which the user has access authority, that is, the field 1 of table 1 is displayed as "user gender" and the field 3 "are displayed, Data for field 2 "user name" and field 3 "contact address" of table 2.
The display module 12 can display the data of the corresponding field according to the selection of the user, and also supports the generation of the data of all fields with access authority of the user by one key, thereby avoiding the defects of logging in a bastion machine and looking at a terminal black window, and greatly optimizing the experience.
The ad hoc query module 13 is used for receiving a user query task, sending the query task through a message queue and acquiring a query result; the real-time communication and message transmission of the ad hoc query result are realized through the message queue technology, so that a plurality of intermediate processes are avoided, and the operation time of data personnel is greatly reduced.
And the application module 14 is used for completing data synchronization according to the configuration information of the data table.
Illustratively, the application module 14 includes:
the configuration information storage module is used for storing configuration information which corresponds to the script information one by one; specifically, when a script information is executed in the database, a configuration information corresponding to the script information one to one is automatically generated and stored in the configuration information storage module.
The monitoring module is used for monitoring whether newly stored configuration information exists;
and the synchronization module is used for synchronously executing script information corresponding to the newly stored configuration information when the newly stored configuration information is monitored.
Further, the data management platform of the present invention further provides a unified login entry for different platforms, and supports a single login function, and then the platform further includes:
and the single sign-on module is used for receiving a unified sign-on account number and a password of a user to finish the sign-on of different data platforms.
Illustratively, the single sign-on module comprises:
the receiving module is used for receiving a uniform login account and a uniform password of a user;
the verification module is used for sending the unified login account and the password to a unified server, receiving a verification code returned by the unified server, and verifying whether the unified login account and the password are correct or not according to the verification code; specifically, a set of verification algorithm is arranged between the verification module and the unified server, the unified server converts the login account number and the password into a verification code through the verification algorithm, and the verification module verifies the verification code to determine whether the login account number and the password are correct.
And the login module is used for completing login of different data platforms when the unified login account and the password are correct.
In addition, the data management platform of the present invention also has the functions of timing query and displaying query results, and then the platform further includes:
the storage module is used for storing the query task and the query result of the ad hoc query module and the preset query time of the query task, and sending the corresponding query task to the ad hoc query module when the preset query time is reached; the storage query task and the query result can be conveniently checked by a user at a later stage, and the function of timing query can be realized by storing the preset query time of the query task.
The display module is further used for analyzing the query result and displaying the analysis result.
In the invention, the ad hoc query module returns the query result to the display module after obtaining the query result, and the display module can analyze the query result and display the query result in a data result display mode such as a pie chart, a line chart and the like, so that a user can see the data result and the data change trend at a glance, and the visualization effect of the data result is achieved.
In addition, the data management platform of the present invention also supports the functions of data monitoring and data source searching, and then the platform further includes:
the monitoring alarm module is used for monitoring whether the data of each data table is abnormal or not, sending alarm information when the data is abnormal, specifically presetting the data format and the data range of each field in the data table, and prompting a user that certain data is abnormal in a highlight text form for the user to modify when the data format is different from the preset data format or the data exceeds the preset data range.
And the searching module is used for configuring a workflow or a blood relation map to search a data source.
Those skilled in the art will appreciate that the modules in the above-described embodiments of the apparatus may be distributed as described in the apparatus, and may be correspondingly modified and distributed in one or more apparatuses other than the above-described embodiments. The modules of the above embodiments may be combined into one module, or further split into multiple sub-modules.
Fig. 4 is a flow chart of a data management method of the present invention, the method comprising:
s1, approving and managing the access authority of different users to the data table in the database through a database interface;
the database can be a database in a financial cluster such as a cloud picture, a smart phone and the like, a database interface capable of operating the database is reserved in the database, the database of the financial cluster can be controlled through the database interface, and related rights from a data table to a field can be controlled, so that the right approval can be traced.
Specifically, the access rights of different users to the data tables and fields in the database can be examined and approved according to examination and approval information issued by an administrator; and configuring and managing the access rights of different users to the data tables and the fields in the database according to the user attribute information of the users, such as department role information (such as market department, research and development department and the like). Furthermore, the access authority can be stored as authentication information for authenticating the access of the data table and the field, and the data table can be displayed or inquired only when the data table and the field correspond to the authentication information in the data display and inquiry process, so that different persons can display and inquire the data table with different display and inquiry authorities, and the data privacy is protected.
S2, displaying the data table information of the user with access authority;
in the present invention, the data table information is unified information for all data tables in the database, including the meaning of each data table and the meaning of each field, which may be specifically a data dictionary, and the data table information showing that the user has access authority includes:
s21, receiving the selection operation of the user to the data table and/or the field;
the selection operation may be a click operation of a user on a data table header and/or a field, or a click operation on a "one-key generation" button in the display module.
And S22, displaying the meanings of the data tables and/or the fields which the user has the access right, and displaying the data of the data tables and/or the fields selected by the user.
Refer specifically to fig. 2 and 3 and the related description, and are not repeated here.
S3, receiving a user query task, sending the query task through a message queue and acquiring a query result;
the real-time communication and message transmission of the ad hoc query result are realized through the message queue technology, so that a plurality of intermediate processes are avoided, and the operation time of data personnel is greatly reduced.
Further, the following steps can be further executed in the step:
s31, storing the query task and the query result of the ad hoc query module and the preset query time of the query task, and sending the corresponding query task to the ad hoc query module when the preset query time is reached;
and S32, analyzing the query result and displaying the analysis result.
In the invention, the query result can be analyzed firstly and displayed in a data result display mode such as a pie chart, a line chart and the like, so that a user can see the data result and the data change trend at a glance, and the effect of visualizing the data result is achieved.
And S4, completing data synchronization according to the configuration information of the data table.
Specifically, the method comprises the following steps:
s41, storing configuration information corresponding to the script information one by one;
specifically, when a script information is executed in the database, a configuration information corresponding to the script information one to one is automatically generated and stored in the configuration information storage module.
S42, monitoring whether newly stored configuration information exists;
and S43, when the newly stored configuration information is monitored, synchronously executing script information corresponding to the newly stored configuration information.
In addition, the data management method of the present invention provides a unified login entry for different platforms, and supports single sign-on, data monitoring and data source search, and then the method further includes:
and S5, receiving the unified login account and password of the user to complete login of different data platforms.
Illustratively, this step includes:
s51, receiving a unified login account and password of the user;
s52, sending the unified login account and the password to a unified server, receiving a verification code returned by the unified server, and verifying whether the unified login account and the password are correct or not according to the verification code;
specifically, a set of verification algorithm is arranged between the verification module and the unified server, the unified server converts the login account number and the password into a verification code through the verification algorithm, and the verification module verifies the verification code to determine whether the login account number and the password are correct.
And S53, when the unified login account number and the password are correct, completing login of different data platforms.
And S6, monitoring whether the data of each data table is abnormal or not, and sending alarm information when the data is abnormal.
Specifically, the data format and the data range of each field in the data table may be preset, and when the data format is different from the preset data format or the data exceeds the preset data range, the user is prompted in a highlight text form that a certain data is abnormal for the user to modify.
S7, configuring a workflow or a blood margin map to search a data source.
In the following, embodiments of the electronic device of the present invention are described, which may be regarded as an implementation in physical form for the above-described embodiments of the method and apparatus of the present invention. Details described in the embodiments of the electronic device of the invention should be considered supplementary to the embodiments of the method or apparatus described above; for details which are not disclosed in embodiments of the electronic device of the invention, reference may be made to the above-described embodiments of the method or the apparatus.
Fig. 5 is a block diagram of an exemplary embodiment of an electronic device according to the present invention. The electronic device shown in fig. 5 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.
As shown in fig. 5, the electronic device 500 of the exemplary embodiment is represented in the form of a general-purpose data processing device. The components of the electronic device 500 may include, but are not limited to: at least one processing unit 510, at least one memory unit 520, a bus 530 connecting different electronic device components (including the memory unit 520 and the processing unit 510), a display unit 540, and the like.
The storage unit 520 stores a computer readable program, which may be a code of a source program or a read-only program. The program may be executed by the processing unit 510 such that the processing unit 510 performs the steps of various embodiments of the present invention. For example, the processing unit 510 may perform the steps as shown in fig. 4.
The memory unit 520 may include a readable medium in the form of a volatile memory unit, such as a random access memory unit (RAM)5201 and/or a cache memory unit 5202, and may further include a read only memory unit (ROM) 5203. The memory unit 520 may also include a program/utility 5204 having a set (at least one) of program modules 5205, such program modules 5205 including, but not limited to: operating the electronic device, one or more application programs, other program modules, and program data, each of which, or some combination thereof, may comprise an implementation of a network environment.
The electronic device 500 may also communicate with one or more external devices 300 (e.g., keyboard, display, network device, bluetooth device, etc.), enable a user to interact with the electronic device 500 via the external devices 500, and/or enable the electronic device 500 to communicate with one or more other data processing devices (e.g., router, modem, etc.). Such communication can occur via input/output (I/O) interfaces 550, and can also occur via network adapter 560 to one or more networks, such as a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the Internet. The network adapter 560 may communicate with other modules of the electronic device 500 via the bus 530. It should be appreciated that although not shown in FIG. 5, other hardware and/or software modules may be used in the electronic device 500, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID electronics, tape drives, and data backup storage electronics, among others.
FIG. 6 is a schematic diagram of one computer-readable medium embodiment of the present invention. As shown in fig. 6, the computer program may be stored on one or more computer readable media. The computer readable medium may be a readable signal medium or a readable storage medium. The readable storage medium may be, for example, but not limited to, an electronic device, apparatus, or device that is electronic, magnetic, optical, electromagnetic, infrared, or semiconductor, or a combination of any of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable disk, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. The computer program, when executed by one or more data processing devices, enables the computer-readable medium to implement the above-described method of the invention, namely: examining and approving and managing access rights of different users to a data table in the database through a database interface; displaying the data table information of which the user has access authority; receiving a user query task, sending the query task through a message queue and acquiring a query result; and completing data synchronization according to the configuration information of the data table.
Through the above description of the embodiments, those skilled in the art will readily understand that the exemplary embodiments of the present invention described herein may be implemented by software, or by software in combination with necessary hardware. Therefore, the technical solution according to the embodiment of the present invention can be embodied in the form of a software product, which can be stored in a computer-readable storage medium (which can be a CD-ROM, a usb disk, a removable hard disk, etc.) or on a network, and includes several instructions to make a data processing device (which can be a personal computer, a server, or a network device, etc.) execute the above-mentioned method according to the present invention.
The computer readable storage medium may include a propagated data signal with readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A readable storage medium may also be any readable medium that is not a readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution electronic device, apparatus, or device. Program code embodied on a readable storage medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., through the internet using an internet service provider).
In summary, the present invention can be implemented as a method, an apparatus, an electronic device, or a computer-readable medium executing a computer program. Some or all of the functions of the present invention may be implemented in practice using a general purpose data processing device such as a microprocessor or a Digital Signal Processor (DSP).
While the foregoing embodiments have described the objects, aspects and advantages of the present invention in further detail, it should be understood that the present invention is not inherently related to any particular computer, virtual machine or electronic device, and various general-purpose machines may be used to implement the present invention. The invention is not to be considered as limited to the specific embodiments thereof, but is to be understood as being modified in all respects, all changes and equivalents that come within the spirit and scope of the invention.
Claims (10)
1. A data management platform, the platform comprising:
the authority examination and approval management module is connected with the database interface and used for examining, approving and managing the access authorities of different users to the data tables in the database through the database interface;
the display module is used for displaying the data table information of which the user has the access right;
the system comprises an ad hoc query module, a message queue and a query module, wherein the ad hoc query module is used for receiving a user query task, sending the query task through the message queue and obtaining a query result;
and the application module is used for completing data synchronization according to the configuration information of the data table.
2. The platform of claim 1, wherein the spreadsheet information includes a meaning for each spreadsheet and a meaning for each field, and wherein the presentation module comprises:
the receiving module is used for receiving the selection operation of a user on the data table and/or the field;
and the display module is used for displaying the meanings of the data tables and/or the fields with the access authority of the user and displaying the data of the data tables and/or the fields selected by the user.
3. The platform of any of claims 1-2, wherein the application module comprises:
the configuration information storage module is used for storing configuration information which corresponds to the script information one by one;
the monitoring module is used for monitoring whether newly stored configuration information exists;
and the synchronization module is used for synchronously executing script information corresponding to the newly stored configuration information when the newly stored configuration information is monitored.
4. The platform of any one of claims 1-3, further comprising:
and the single sign-on module is used for receiving a unified sign-on account number and a password of a user to finish the sign-on of different data platforms.
5. The platform of any one of claims 1-4, wherein the single sign-on module comprises:
the receiving module is used for receiving a uniform login account and a uniform password of a user;
the verification module is used for sending the unified login account and the password to a unified server, receiving a verification code returned by the unified server, and verifying whether the unified login account and the password are correct or not according to the verification code;
and the login module is used for completing login of different data platforms when the unified login account and the password are correct.
6. The platform of any one of claims 1-5, further comprising:
the storage module is used for storing the query task and the query result of the ad hoc query module and the preset query time of the query task, and sending the corresponding query task to the ad hoc query module when the preset query time is reached;
the display module is further used for analyzing the query result and displaying the analysis result.
7. The platform of any one of claims 1-6, further comprising:
and the monitoring alarm module is used for monitoring whether the data of each data table is abnormal or not, and sending alarm information when the data is abnormal.
8. A method for managing data, the method comprising:
examining and approving and managing access rights of different users to a data table in the database through a database interface;
displaying the data table information of which the user has access authority;
receiving a user query task, sending the query task through a message queue and acquiring a query result;
and completing data synchronization according to the configuration information of the data table.
9. An electronic device, comprising:
a processor; and
a memory storing computer-executable instructions that, when executed, cause the processor to perform the method of any of claims 1-7.
10. A computer readable storage medium, wherein the computer readable storage medium stores one or more programs which, when executed by a processor, implement the method of any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911324719.XA CN111177671B (en) | 2019-12-16 | 2019-12-16 | Data management platform, method and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911324719.XA CN111177671B (en) | 2019-12-16 | 2019-12-16 | Data management platform, method and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111177671A true CN111177671A (en) | 2020-05-19 |
| CN111177671B CN111177671B (en) | 2024-05-17 |
Family
ID=70655527
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911324719.XA Active CN111177671B (en) | 2019-12-16 | 2019-12-16 | Data management platform, method and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111177671B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111737291A (en) * | 2020-06-11 | 2020-10-02 | 青岛海尔科技有限公司 | Method, device and database for inquiring equipment information |
| CN112348562A (en) * | 2020-09-27 | 2021-02-09 | 北京淇瑀信息科技有限公司 | Routing cost consumption-based computer-aided resource delivery management method and platform |
| CN112348554A (en) * | 2020-09-27 | 2021-02-09 | 北京淇瑀信息科技有限公司 | Computer-aided resource delivery management method and platform based on material maintenance |
| CN112511352A (en) * | 2020-12-01 | 2021-03-16 | 深圳市鹰硕技术有限公司 | User management method and system |
| CN112989781A (en) * | 2021-03-11 | 2021-06-18 | 携程旅游网络技术（上海）有限公司 | Automatic form data execution method and device, electronic equipment and storage medium |
| CN113919820A (en) * | 2021-11-02 | 2022-01-11 | 杭州以诺行汽车科技股份有限公司 | Formula management system based on ERP system and control method |
| CN116521776A (en) * | 2023-07-03 | 2023-08-01 | 陕西省君凯电子科技有限公司 | Quick information query system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090327131A1 (en) * | 2008-04-29 | 2009-12-31 | American Express Travel Related Services Company, Inc. | Dynamic account authentication using a mobile device |
| CN105868202A (en) * | 2015-01-21 | 2016-08-17 | 镇江雅迅软件有限责任公司 | Multi-platform access data management system |
| CN106357724A (en) * | 2016-08-18 | 2017-01-25 | 广州市利迪网络科技有限公司 | Uniformly integrated information management platform system |
| CN107634951A (en) * | 2017-09-22 | 2018-01-26 | 携程旅游网络技术（上海）有限公司 | Docker vessel safeties management method, system, equipment and storage medium |
| CN107895123A (en) * | 2017-11-13 | 2018-04-10 | 医渡云（北京）技术有限公司 | Data access authority control method and device, method for managing user right |
| CN109344185A (en) * | 2018-08-21 | 2019-02-15 | 广州飞硕信息科技股份有限公司 | A kind of data capture method and device |
| CN110009314A (en) * | 2019-04-18 | 2019-07-12 | 武汉鼠标科技有限公司 | A kind of educational system and teaching platform of the behavioural analysis based on big data |
-
2019
- 2019-12-16 CN CN201911324719.XA patent/CN111177671B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090327131A1 (en) * | 2008-04-29 | 2009-12-31 | American Express Travel Related Services Company, Inc. | Dynamic account authentication using a mobile device |
| CN105868202A (en) * | 2015-01-21 | 2016-08-17 | 镇江雅迅软件有限责任公司 | Multi-platform access data management system |
| CN106357724A (en) * | 2016-08-18 | 2017-01-25 | 广州市利迪网络科技有限公司 | Uniformly integrated information management platform system |
| CN107634951A (en) * | 2017-09-22 | 2018-01-26 | 携程旅游网络技术（上海）有限公司 | Docker vessel safeties management method, system, equipment and storage medium |
| CN107895123A (en) * | 2017-11-13 | 2018-04-10 | 医渡云（北京）技术有限公司 | Data access authority control method and device, method for managing user right |
| CN109344185A (en) * | 2018-08-21 | 2019-02-15 | 广州飞硕信息科技股份有限公司 | A kind of data capture method and device |
| CN110009314A (en) * | 2019-04-18 | 2019-07-12 | 武汉鼠标科技有限公司 | A kind of educational system and teaching platform of the behavioural analysis based on big data |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111737291A (en) * | 2020-06-11 | 2020-10-02 | 青岛海尔科技有限公司 | Method, device and database for inquiring equipment information |
| CN111737291B (en) * | 2020-06-11 | 2023-07-21 | 青岛海尔科技有限公司 | Method, device and database for inquiring equipment information |
| CN112348562A (en) * | 2020-09-27 | 2021-02-09 | 北京淇瑀信息科技有限公司 | Routing cost consumption-based computer-aided resource delivery management method and platform |
| CN112348554A (en) * | 2020-09-27 | 2021-02-09 | 北京淇瑀信息科技有限公司 | Computer-aided resource delivery management method and platform based on material maintenance |
| CN112348562B (en) * | 2020-09-27 | 2024-03-26 | 北京淇瑀信息科技有限公司 | Computer-aided resource release management method and platform based on route cost consumption |
| CN112511352A (en) * | 2020-12-01 | 2021-03-16 | 深圳市鹰硕技术有限公司 | User management method and system |
| CN112511352B (en) * | 2020-12-01 | 2023-01-24 | 深圳市鹰硕技术有限公司 | User management method and system |
| CN112989781A (en) * | 2021-03-11 | 2021-06-18 | 携程旅游网络技术（上海）有限公司 | Automatic form data execution method and device, electronic equipment and storage medium |
| CN112989781B (en) * | 2021-03-11 | 2023-11-24 | 携程旅游网络技术（上海）有限公司 | Form data automatic execution method, device, electronic equipment and storage medium |
| CN113919820A (en) * | 2021-11-02 | 2022-01-11 | 杭州以诺行汽车科技股份有限公司 | Formula management system based on ERP system and control method |
| CN116521776A (en) * | 2023-07-03 | 2023-08-01 | 陕西省君凯电子科技有限公司 | Quick information query system |
| CN116521776B (en) * | 2023-07-03 | 2023-09-05 | 陕西省君凯电子科技有限公司 | Quick information query system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111177671B (en) | 2024-05-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111177671B (en) | Data management platform, method and electronic equipment | |
| AU2017290063B2 (en) | Apparatuses, methods and systems for relevance scoring in a graph database using multiple pathways | |
| US10515212B1 (en) | Tracking sensitive data in a distributed computing environment | |
| TW201824021A (en) | Business data processing method and system thereof | |
| CN107040577A (en) | Project document in the environment based on cloud is shared and cooperates | |
| US20210241893A1 (en) | Dashboard Usage Tracking and Generation of Dashboard Recommendations | |
| CN111680313B (en) | Data processing method, device, equipment and storage medium | |
| CN113076104A (en) | Page generation method, device, equipment and storage medium | |
| CN110569266A (en) | Data query method, device, equipment and storage medium | |
| CN111177213A (en) | Privacy cluster self-service query platform and method and electronic equipment | |
| US20160358259A1 (en) | Aggregating account information obtained from multiple institutions | |
| CN112269799A (en) | Data query method, device, equipment and medium | |
| US20220300395A1 (en) | Contextual drill back to source code and other resources from log data | |
| CN109460363B (en) | Automatic testing method and device, electronic equipment and computer readable medium | |
| KR20110139896A (en) | Method for recommendation the financial goods | |
| US9250760B2 (en) | Customizing a dashboard responsive to usage activity | |
| US10637722B2 (en) | Automated remote message management | |
| CN111209184A (en) | Automatic testing method and device and electronic equipment | |
| US9208046B2 (en) | Method and system for optimizing testing efforts in system of systems testing | |
| WO2018183179A1 (en) | Method and apparatus for in-situ querying support for industrial environments | |
| US9275358B1 (en) | System, method, and computer program for automatically creating and submitting defect information associated with defects identified during a software development lifecycle to a defect tracking system | |
| CN113792138A (en) | Report generation method and device, electronic equipment and storage medium | |
| CN110928801A (en) | Role authority test method and device, computer medium and electronic equipment | |
| CN113722007A (en) | Configuration method, device and system of VPN branch equipment | |
| CN107609871B (en) | Payment track reproduction method, device, system, electronic 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 |