CN111008211B - Visual interface creating method and device, readable storage medium and electronic equipment - Google Patents

Visual interface creating method and device, readable storage medium and electronic equipment Download PDF

Info

Publication number
CN111008211B
CN111008211B CN201911244930.0A CN201911244930A CN111008211B CN 111008211 B CN111008211 B CN 111008211B CN 201911244930 A CN201911244930 A CN 201911244930A CN 111008211 B CN111008211 B CN 111008211B
Authority
CN
China
Prior art keywords
mode
data source
preset
unified
visual interface
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
Application number
CN201911244930.0A
Other languages
Chinese (zh)
Other versions
CN111008211A (en
Inventor
于帮付
左云鹏
杨威
史明玉
刘译璟
李鹏
武兆
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Percent Technology Group Co ltd
Original Assignee
Beijing Percent Technology Group Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Percent Technology Group Co ltd filed Critical Beijing Percent Technology Group Co ltd
Priority to CN201911244930.0A priority Critical patent/CN111008211B/en
Publication of CN111008211A publication Critical patent/CN111008211A/en
Application granted granted Critical
Publication of CN111008211B publication Critical patent/CN111008211B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
    • 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/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2433—Query languages
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/602—Providing cryptographic facilities or services
    • 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)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Mathematical Physics (AREA)
  • Human Computer Interaction (AREA)
  • Health & Medical Sciences (AREA)
  • Bioethics (AREA)
  • General Health & Medical Sciences (AREA)
  • Computer Hardware Design (AREA)
  • Computer Security & Cryptography (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The disclosure relates to a visual interface creating method and device, a readable storage medium and electronic equipment. The method comprises the following steps: acquiring data sources of multiple modes; unifying the data sources of the multiple modes into a preset mode and storing the preset mode; and aiming at each data source unified to the preset mode, carrying out SQL analysis on the target SQL statement so as to generate and display a visual interface. Therefore, under the condition that the visual interface meets most common data source modes, all data sources are unified through simple configuration, so that standardization of data source management is realized, the data source management is more convenient and faster, and the data source modes can be conveniently expanded. And the operation steps are simple, so that the user experience is improved.

Description

Visual interface creating method and device, readable storage medium and electronic equipment
Technical Field
The present disclosure relates to the field of database technologies, and in particular, to a method and an apparatus for creating a visual interface, a readable storage medium, and an electronic device.
Background
With the advent of the big data age, more and more types of data source products come out. In some data sharing and exchanging products, more data types need to be supported to improve the competitiveness of the products, and a high-efficiency and easy-to-use multi-data source analysis visual interface tool is particularly important. Some visualization interface products on the market today are too single in function, for example, only support page generation of a single data source, and the SQL parsing scheme is single (only support the query scheme), and the operation steps are cumbersome.
Disclosure of Invention
In order to overcome the problems in the related art, the present disclosure provides a method and an apparatus for creating a visual interface, a readable storage medium, and an electronic device.
In order to achieve the above object, according to a first aspect of embodiments of the present disclosure, there is provided a method for creating a visual interface, the method including:
acquiring data sources of multiple modes;
unifying the data sources of the multiple modes into a preset mode and storing the preset mode;
and aiming at each data source unified to the preset mode, carrying out SQL analysis on the target SQL statement so as to generate and display a visual interface.
Optionally, before the step of storing, the method further comprises:
acquiring password information of each data source;
and encrypting the password information.
Optionally, the method further comprises:
and writing all the data sources unified into the preset mode into the distributed cache.
Optionally, the preset mode is a URL mode.
Optionally, the performing SQL analysis on the target SQL statement for each data source unified as the preset mode to generate and display a visualization interface includes:
aiming at each data source unified to the preset mode, connecting the data sources;
and after the data source is successfully connected, SQL analysis is carried out on the target SQL statement so as to generate and display a visual interface.
Optionally, the connecting the data source for each piece of data unified into the preset mode includes:
aiming at each data source unified to the preset mode, acquiring basic information of the data source, wherein the basic information comprises Internet protocol address information and a port;
detecting connectivity of the port through telnet according to the basic information;
and when the port is determined to be communicated, executing database connection operation according to the basic information.
Optionally, the SQL parsing mode includes a query mode, a check mode, a comparison mode, and an acquisition mode;
after the data source is successfully connected, SQL analysis is carried out on the target SQL statement to generate and display a visual interface, and the method comprises the following steps:
initializing the target SQL statement after the data source is successfully connected;
acquiring a target analysis mode corresponding to the target SQL statement;
acquiring input parameters and/or output parameters corresponding to the target analysis mode in the initialized target SQL statement through an SQL analysis adapter;
converting the input parameters and/or the output parameters into JAVA basic types through a type conversion adapter to obtain new input parameters and/or new output parameters;
and generating a JSON file based on the new input parameters and/or the new output parameters, and performing interface configuration rendering through the JSON file to generate and display a visual interface.
According to a second aspect of the embodiments of the present disclosure, there is provided an apparatus for creating a visual interface, the apparatus including:
the acquisition module is used for acquiring data sources in multiple modes;
the data source adaptation module is used for unifying the data sources of the multiple modes acquired by the acquisition module into a preset mode and storing the preset mode;
and the analysis module is used for carrying out SQL analysis on the target SQL statement aiming at each data source which is stored by the data source adaptation module and is unified into the preset mode so as to generate and display a visual interface.
According to a third aspect of embodiments of the present disclosure, there is provided a computer readable storage medium, on which a computer program is stored, which when executed by a processor, performs the steps of the method provided by the first aspect of the present disclosure.
According to a fourth aspect of the embodiments of the present disclosure, there is provided an electronic apparatus including:
a memory having a computer program stored thereon;
a processor for executing the computer program in the memory to implement the steps of the method provided by the first aspect of the present disclosure.
In the technical scheme, firstly, data sources in multiple modes are obtained, and then the data sources in the multiple modes are unified into a preset mode and stored; and aiming at each data source unified into a preset mode, carrying out SQL analysis on the target SQL statement so as to generate and display a visual interface. Under the condition that the visual interface meets most common data source modes, all data sources are unified through simple configuration, so that the standardization of data source management is realized, the data source management is more convenient and faster, and the expansion of the data source modes is facilitated. And the operation steps are simple, so that the user experience is improved.
Additional features and advantages of the disclosure will be set forth in the detailed description which follows.
Drawings
The accompanying drawings, which are included to provide a further understanding of the disclosure and are incorporated in and constitute a part of this specification, illustrate embodiments of the disclosure and together with the description serve to explain the disclosure without limiting the disclosure. In the drawings:
FIG. 1 is a flow chart illustrating a method of creation of a visualization interface in accordance with an exemplary embodiment.
FIG. 2 is a schematic diagram illustrating a process for unifying multiple data sources into a pre-set mode, according to an example embodiment.
FIG. 3 is a flow diagram illustrating a method of SQL parsing in accordance with an exemplary embodiment.
FIG. 4A is a flow chart illustrating a method of connecting data sources according to an example embodiment.
FIG. 4B is a flow diagram illustrating a particular method of SQL parsing, according to an example embodiment.
FIG. 5 is a flowchart illustrating a method of creation of a visualization interface in accordance with another illustrative embodiment.
FIG. 6 is a flowchart illustrating a method of creation of a visualization interface in accordance with another exemplary embodiment.
FIG. 7 is a block diagram illustrating an apparatus for creation of a visualization interface in accordance with an exemplary embodiment.
FIG. 8 is a block diagram illustrating an electronic device in accordance with an example embodiment.
FIG. 9 is a block diagram of an electronic device shown in accordance with an example embodiment.
Detailed Description
The following detailed description of the embodiments of the disclosure refers to the accompanying drawings. It should be understood that the detailed description and specific examples, while indicating the present disclosure, are given by way of illustration and explanation only, not limitation.
FIG. 1 is a flow chart illustrating a method of creation of a visualization interface in accordance with an exemplary embodiment. As shown in fig. 1, the method may include the following steps 101 to 103.
In step 101, data sources of multiple modes are acquired.
In the present disclosure, the creation modes of the various data sources are various, and as shown in fig. 2, the creation modes of the data sources include a service mode, a SID mode, a TNS mode, a URL mode, and an HA mode, wherein the data sources supporting the service mode include Mysql, postgreSQL, SQL Server, oracle, the data sources supporting the SID mode or the TNS mode include Oracle, the data sources supporting the URL mode include Mysql, postgreSQL, SQL Server, oracle, phoenix, and High, and the data sources supporting the HA (High Available cluster) mode include High. Since various data sources are created in various modes, which is inconvenient for data source management, it is necessary to unify the various data sources into a preset mode for standardized storage (as shown in fig. 2). That is, after the data sources in the plurality of modes are acquired in step 101, the data sources in the plurality of modes may be unified into a preset mode and stored, that is, the following step 102 may be executed.
In step 102, data sources of multiple modes are unified into a preset mode and stored.
In the present disclosure, the preset mode may be any one of a service mode, a SID mode, a TNS mode, a URL model, and an HA mode, and may be set by a user or may be a default (for example, URL mode), which is not particularly limited in the present disclosure.
For example, multiple schema data sources may be unified into a URL schema by the URL adaptation formulas and drivers shown in Table 1:
TABLE 1 URL Adaptation formulas and drivers
Figure BDA0002307254050000051
In step 103, for each data source unified into a preset mode, SQL analysis is performed on the target SQL statement to generate and display a visualization interface.
In the present disclosure, after the data sources in the multiple modes are unified into the preset mode in step 102, SQL analysis may be performed on the target SQL statement for each data source unified into the preset mode to generate and display the visualization interface. The target SQL statement may be a query statement, a check statement, a comparison statement, or an acquisition statement for a preset table (set by a user or default) in the data source. Accordingly, the parsing mode of SQL may include a query mode, a check mode, a comparison mode, and an acquisition mode. The verification mode is to carry out integral verification on all information input by a user through an interface and prestored reference information and feed back the result of the integral verification; a comparison mode, which is to compare each piece of information input by a user through an interface with prestored reference information one by one; the collection mode is to receive and store the information input by the user through the corresponding interface.
In addition, the SQL parsing operation can be divided into two phases of data source connection and query parsing. The SQL analysis part is divided into two stages, so that the result can be responded more quickly, and unnecessary resource consumption is reduced. The problems that in the development process of sharing and exchanging multiple data sources, service is blocked for a long time when the URL of the SQL Server data source is wrong, network blocking is caused by massive retries of the Phoenix data source zookeeper and the like are well solved. Specifically, SQL parsing operations may be performed by steps 1031 and 1032 shown in fig. 3 to generate and expose a visualization interface.
In step 1031, data sources are connected for each data source unified in the preset pattern.
Specifically, the connection of the data sources may be performed through step 10311 to step 10313 shown in fig. 4A.
In step 10311, for each data source unified into a preset pattern, basic information of the data source is acquired.
In the present disclosure, the basic information may include internet protocol address information, a port, a data source name, password information, and the like, wherein the internet protocol address information may be an IP address or a domain name. In the present disclosure, the basic information may be obtained by accessing a database corresponding to the data source.
In step 10312, connectivity of the port is detected through telnet according to the basic information.
After the basic information of the data source is obtained in step 10311, telnet verification may be performed, so as to ensure connectivity of the port corresponding to the data source. When it is determined that the port is connected, a database connection operation, that is, the following step 10313 is performed according to the above basic information, and when it is determined that the port is disconnected, telent verification may be repeatedly performed.
In step 10313, upon determining that the ports are connected, a database connection operation is performed according to the basic information.
When the ports are determined to be communicated, database connection can be created through basic information of a data source, and after the database is ensured to be communicated, plan operation is executed on the target SQL statement in a splicing mode, so that the connectivity of the data source can be verified, and whether the target SQL statement has syntax errors or not can be detected.
After the port communication is verified through the telent, the database connection is carried out, so that the repeated database connection caused by the port fault can be avoided, and the SQL analysis efficiency in the big data table can be improved.
Returning to fig. 3, in step 1032, after the data source connection is successful, SQL parsing is performed on the target SQL statement to generate and display a visualization interface.
After the data source is successfully connected in step 1031, the SQL parsing operation may be performed on the target SQL statement, and specifically, may be implemented in steps 10321 to 10325 shown in fig. 4B.
In step 10321, after the data source connection is successful, the target SQL statement is initialized.
In the present disclosure, the initialization operation may include: SQL statement formatting (e.g., removing special characters such as spaces, carriage returns, etc.), SQL statement syntax checking, multilingual statement splitting, complex statement splitting, etc.
In step 10322, a target parsing scheme corresponding to the target SQL statement is obtained.
In the present disclosure, different SQL statements correspond to different parsing modes, for example, SQL is a query statement, and its corresponding parsing mode is a query mode; SQL is check statement, and its corresponding analysis mode is check mode.
In step 10323, an input parameter and/or an output parameter corresponding to the target parsing mode in the initialized target SQL statement is obtained through the SQL parsing adapter.
In the present disclosure, corresponding input parameters and/or output parameters may be obtained according to different target parsing modes. The query mode and the verification mode correspond to input parameters and output parameters; the comparison mode and the acquisition mode are both corresponding to input parameters.
In step 10324, the input parameters and/or the output parameters are converted into JAVA base types by the type conversion adapter, resulting in new input parameters and/or new output parameters.
After the corresponding input parameters and/or output parameters are obtained through step 10323, they may be uniformly converted into JAVA base types through the type conversion adapter, so as to realize the uniformity of different data source data types.
In step 10325, a JSON file is generated based on the new input parameters and/or the new output parameters, and interface configuration rendering is performed through the JSON file to generate and display a visualization interface.
After the input parameters and/or the output parameters are uniformly converted into JAVA base types through the step 10324, corresponding JSON files can be generated, and interface parameters are dynamically rendered through the JSON files, that is, the configuration of the visual interface is completed. Therefore, when a user clicks the page corresponding to the corresponding interface, the interface can be dynamically rendered to the page, and thus, the user can perform interface operation through the page.
In the technical scheme, firstly, data sources in multiple modes are obtained, and then the data sources in the multiple modes are unified into a preset mode and stored; and aiming at each data source unified into a preset mode, carrying out SQL analysis on the target SQL statement so as to generate and display a visual interface. Under the condition that the visual interface meets most of common data source modes, all data sources are unified through simple configuration, so that standardization of data source management is realized, the data source management is more convenient and faster, and the data source modes can be conveniently expanded. And the operation steps are simple, so that the user experience is improved.
In addition, in order to improve the security of data, encryption processing may be performed on the cryptographic information of each data source. Specifically, before storing the data source information, the method may further include steps 104 and 105 shown in fig. 5.
In step 104, cryptographic information for each data source is obtained.
The password information may be connection password information of the data source.
In step 105, the cryptographic information is encrypted.
For example, the above-described cryptographic information may be encrypted by an MD5 algorithm, an asymmetric encryption RSA algorithm, or the like.
Since the cryptographic information of the data source is stored in an encrypted manner, the cryptographic information in the basic information of the data source needs to be decrypted before the database connection operation is performed, i.e., before step 10313. And then, performing database connection according to the decrypted password information.
FIG. 6 is a flowchart illustrating a method of creation of a visualization interface in accordance with another illustrative embodiment. As shown in fig. 6, the method may further include the following step 106.
In step 106, the data sources unified into the preset mode are written into the distributed cache.
After the data sources in the multiple modes are unified into the preset mode in the step 102, the data sources unified into the preset mode may be written into the distributed cache. Correspondingly, when the basic information of the data source is obtained in step 10311, the distributed cache may be accessed first, and if the basic information of the data source exists in the distributed cache, that is, if the basic information of the data source is hit, the basic information of the data source is directly obtained from the distributed cache; if the basic information of the data source does not exist in the distributed cache, that is, the data source is not hit, the database corresponding to the data source is accessed to obtain the basic information, and the distributed cache is updated (that is, the basic information of the data source is stored in the distributed cache). Therefore, the SQL analysis efficiency can be improved, and meanwhile, the access pressure of the database is reduced.
FIG. 7 is a block diagram illustrating an apparatus for creation of a visualization interface in accordance with an exemplary embodiment. Referring to fig. 7, the apparatus 700 may include: an obtaining module 701, configured to obtain data sources in multiple modes; a data source adaptation module 702, configured to unify the data sources in the multiple modes acquired by the acquisition module 701 into a preset mode, and store the preset mode; and the analysis module 703 is configured to perform SQL analysis on the target SQL statement to generate and display a visualization interface for each data source unified into the preset mode, which is obtained by the data source adaptation module 702.
Optionally, the apparatus 700 may further include: a password information obtaining module, configured to obtain password information of each data source before the data source adapting module 702 performs storage; and the encryption module is used for encrypting the password information.
Optionally, the apparatus 700 may further include: and the cache module is used for writing all the data sources unified into the preset mode into the distributed cache.
Optionally, the preset mode is a URL mode.
Optionally, the parsing module 703 includes:
the connection submodule is used for connecting the data sources aiming at all the data sources unified to the preset mode;
and the analysis submodule is used for carrying out SQL analysis on the target SQL statement after the data source is successfully connected so as to generate and display a visual interface.
Optionally, the connection sub-module comprises:
the acquisition submodule is used for acquiring basic information of the data sources aiming at the data sources unified to the preset mode, wherein the basic information comprises internet protocol address information and ports;
the detection submodule is used for detecting the connectivity of the port through telnet according to the basic information;
and the execution submodule is used for executing database connection operation according to the basic information when the port is determined to be communicated.
Optionally, the SQL parsing mode includes a query mode, a check mode, a comparison mode, and an acquisition mode;
the parsing submodule includes:
the initialization submodule is used for initializing the target SQL statement after the data source is successfully connected;
the analysis mode acquisition sub-module is used for acquiring a target analysis mode corresponding to the target SQL statement;
the parameter acquisition sub-module is used for acquiring input parameters and/or output parameters corresponding to the target analysis mode in the initialized target SQL statement through the SQL analysis adapter;
the type conversion submodule is used for converting the input parameters and/or the output parameters into JAVA basic types through a type conversion adapter to obtain new input parameters and/or new output parameters;
and the generating submodule is used for generating a JSON file based on the new input parameters and/or the new output parameters, and performing interface configuration rendering through the JSON file to generate and display a visual interface.
With regard to the apparatus in the above-described embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated here.
The present disclosure also provides a computer-readable storage medium, on which a computer program is stored, which when executed by a processor, implements the steps of the method for creating a visualization interface provided by the present disclosure.
Fig. 8 is a block diagram illustrating an electronic device 800 in accordance with an example embodiment. As shown in fig. 8, the electronic device 800 may include: a processor 801, a memory 802. The electronic device 800 may also include one or more of a multimedia component 803, an input/output (I/O) interface 804, and a communications component 805.
The processor 801 is configured to control the overall operation of the electronic device 800, so as to complete all or part of the steps in the above-described method for creating a visual interface. The memory 802 is used to store various types of data to support operation at the electronic device 800, such as instructions for any application or method operating on the electronic device 800 and application-related data, such as contact data, transmitted and received messages, pictures, audio, video, and so forth. The Memory 802 may be implemented by any type of volatile or non-volatile Memory device or combination thereof, such as Static Random Access Memory (SRAM), electrically Erasable Programmable Read-Only Memory (EEPROM), erasable Programmable Read-Only Memory (EPROM), programmable Read-Only Memory (PROM), read-Only Memory (ROM), magnetic Memory, flash Memory, magnetic disk or optical disk. The multimedia components 803 may include screen and audio components. Wherein the screen may be, for example, a touch screen and the audio component is used for outputting and/or inputting audio signals. For example, the audio component may include a microphone for receiving external audio signals. The received audio signal may further be stored in the memory 802 or transmitted through the communication component 805. The audio assembly also includes at least one speaker for outputting audio signals. The I/O interface 804 provides an interface between the processor 801 and other interface modules, such as a keyboard, mouse, buttons, etc. These buttons may be virtual buttons or physical buttons. The communication component 805 is used for wired or wireless communication between the electronic device 800 and other devices. Wireless Communication, such as Wi-Fi, bluetooth, near Field Communication (NFC), 2G, 3G, 4G, NB-IOT, eMTC, or other 5G, or combinations thereof, which is not limited herein. The corresponding communication component 805 may therefore include: wi-Fi module, bluetooth module, NFC module, etc.
In an exemplary embodiment, the electronic Device 800 may be implemented by one or more Application Specific Integrated Circuits (ASICs), digital Signal Processors (DSPs), digital Signal Processing Devices (DSPDs), programmable Logic Devices (PLDs), field Programmable Gate Arrays (FPGAs), controllers, microcontrollers, microprocessors, or other electronic components for performing the above-mentioned creation method of the visual interface.
In another exemplary embodiment, a computer readable storage medium is also provided, which comprises program instructions, which when executed by a processor, implement the steps of the above-described method for creating a visualization interface. For example, the computer readable storage medium may be the memory 802 described above that includes program instructions executable by the processor 801 of the electronic device 800 to perform the method for creating a visualization interface described above.
Fig. 9 is a block diagram illustrating an electronic device 900 in accordance with an example embodiment. For example, the electronic device 900 may be provided as a server. Referring to fig. 9, the electronic device 900 includes a processor 922, which may be one or more in number, and a memory 932 for storing computer programs executable by the processor 922. The computer programs stored in memory 932 may include one or more modules that each correspond to a set of instructions. Further, the processor 922 may be configured to execute the computer program to perform the above-described creation method of the visualization interface.
Additionally, the electronic device 900 may also include a power component 926 and a communication component 950, the power component 926 may be configured to perform power management of the electronic device 900, and the communication component 950 may be configured to enable communication, e.g., wired or wireless communication, of the electronic device 900. The electronic device 900 may also include input/output (I/O) interfaces 958. The electronic device 900 may operate based on an operating system stored in the memory 932, such as Windows Server, mac OS XTM, unixTM, linuxTM, and the like.
In another exemplary embodiment, a computer readable storage medium is also provided, which comprises program instructions, which when executed by a processor, implement the steps of the above-described method for creating a visualization interface. For example, the computer readable storage medium may be the memory 932 described above that includes program instructions executable by the processor 922 of the electronic device 900 to perform the method for creating a visualization interface described above.
In another exemplary embodiment, a computer program product is also provided, which comprises a computer program executable by a programmable apparatus, the computer program having code portions for performing the above-mentioned method of creating a visualization interface when executed by the programmable apparatus.
The preferred embodiments of the present disclosure are described in detail with reference to the accompanying drawings, however, the present disclosure is not limited to the specific details of the above embodiments, and various simple modifications may be made to the technical solution of the present disclosure within the technical idea of the present disclosure, and these simple modifications all belong to the protection scope of the present disclosure.
It should be noted that the various features described in the above embodiments may be combined in any suitable manner without departing from the scope of the invention. In order to avoid unnecessary repetition, various possible combinations will not be separately described in this disclosure.
In addition, any combination of various embodiments of the present disclosure may be made, and the same should be considered as the disclosure of the present disclosure as long as it does not depart from the gist of the present disclosure.

Claims (9)

1. A method for creating a visual interface, the method comprising:
acquiring a data source of a plurality of modes, wherein the plurality of modes comprise a service mode, a SID mode, a TNS mode, a URL mode and an HA mode;
unifying the data sources of the multiple modes into a preset mode, and storing the preset mode, wherein the preset mode is any one of the service mode, the SID mode, the TNS mode, the URL mode and the HA mode;
aiming at each data source unified to the preset mode, SQL analysis is carried out on a target SQL statement so as to generate and display a visual interface;
wherein unifying the data sources of the plurality of modes into a preset mode includes:
unifying the data sources of the multiple modes into the preset mode through a preset adaptation formula and a preset driver.
2. The method of claim 1, wherein prior to the step of storing, the method further comprises:
acquiring password information of each data source;
and encrypting the password information.
3. The method of claim 1, further comprising:
and writing all the data sources unified into the preset mode into the distributed cache.
4. The method according to any one of claims 1-3, wherein the SQL parsing of the target SQL statement to generate and display the visualization interface for each data source unified as the preset schema comprises:
aiming at each data source unified to the preset mode, connecting the data sources;
and after the data source is successfully connected, performing SQL analysis on the target SQL statement to generate and display a visual interface.
5. The method of claim 4, wherein connecting the data sources for each data unified into the predetermined schema comprises:
aiming at each data source unified to the preset mode, acquiring basic information of the data source, wherein the basic information comprises Internet protocol address information and a port;
detecting connectivity of the port through telnet according to the basic information;
and when the port is determined to be communicated, executing database connection operation according to the basic information.
6. The method of claim 4, wherein the SQL parsing schema comprises a query schema, a check schema, a comparison schema, and a collection schema;
after the data source is successfully connected, SQL analysis is carried out on the target SQL statement to generate and display a visual interface, and the method comprises the following steps:
initializing the target SQL statement after the data source is successfully connected;
acquiring a target analysis mode corresponding to the target SQL statement;
acquiring input parameters and/or output parameters corresponding to the target analysis mode in the initialized target SQL statement through an SQL analysis adapter;
converting the input parameters and/or the output parameters into JAVA basic types through a type conversion adapter to obtain new input parameters and/or new output parameters;
and generating a JSON file based on the new input parameters and/or the new output parameters, and performing interface configuration rendering through the JSON file to generate and display a visual interface.
7. An apparatus for creating a visual interface, the apparatus comprising:
the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring a data source of a plurality of modes, and the plurality of modes comprise a service mode, a SID mode, a TNS mode, a URL mode and an HA mode;
a data source adaptation module, configured to unify the multiple modes of data sources acquired by the acquisition module into a preset mode, and store the preset mode, where the preset mode is any one of the service mode, the SID mode, the TNS mode, the URL mode, and the HA mode;
the analysis module is used for carrying out SQL analysis on a target SQL statement aiming at each data source which is stored by the data source adaptation module and unified into the preset mode so as to generate and display a visual interface;
the data source adaptation module is further configured to unify the data sources of the multiple modes into the preset mode through a preset adaptation formula and a preset driver.
8. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 6.
9. An electronic device, comprising:
a memory having a computer program stored thereon;
a processor for executing the computer program in the memory to carry out the steps of the method of any one of claims 1 to 6.
CN201911244930.0A 2019-12-06 2019-12-06 Visual interface creating method and device, readable storage medium and electronic equipment Active CN111008211B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911244930.0A CN111008211B (en) 2019-12-06 2019-12-06 Visual interface creating method and device, readable storage medium and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911244930.0A CN111008211B (en) 2019-12-06 2019-12-06 Visual interface creating method and device, readable storage medium and electronic equipment

Publications (2)

Publication Number Publication Date
CN111008211A CN111008211A (en) 2020-04-14
CN111008211B true CN111008211B (en) 2023-04-11

Family

ID=70115541

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911244930.0A Active CN111008211B (en) 2019-12-06 2019-12-06 Visual interface creating method and device, readable storage medium and electronic equipment

Country Status (1)

Country Link
CN (1) CN111008211B (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111552698B (en) * 2020-04-21 2023-06-06 重庆富民银行股份有限公司 SQL version control system and method for solving environmental difference
CN112131289A (en) * 2020-08-17 2020-12-25 武汉旷视金智科技有限公司 Data processing method and device, electronic equipment and storage medium
CN112182074A (en) * 2020-09-27 2021-01-05 中国建设银行股份有限公司 Data visualization method and device, electronic equipment and readable storage medium
CN112187827A (en) * 2020-10-16 2021-01-05 厦门市云客网络科技有限公司 Method for uniformly outputting different communication protocols and data structures
CN112363967B (en) * 2020-11-09 2023-11-14 成都卫士通信息产业股份有限公司 Method, device, equipment and medium for unifying interface standards of password equipment
CN114201945A (en) * 2021-12-14 2022-03-18 深圳壹账通智能科技有限公司 File conversion method and device, computer equipment and storage medium

Citations (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101930469A (en) * 2010-09-02 2010-12-29 江西省电力公司超高压分公司 Universal data access method of cross-platform multi-heterogeneous database in scheduling data service platform
CN102262561A (en) * 2011-07-01 2011-11-30 深圳市极限网络科技有限公司 Method for scheduling processing of massive tasks of databases
CN104573115A (en) * 2015-02-04 2015-04-29 新余兴邦信息产业有限公司 Method and system for achieving integration interface supporting operation of multi-type databases
CN106021378A (en) * 2016-05-11 2016-10-12 吕骏 Query and analysis method and system based on data extraction and data visualization
CN106372185A (en) * 2016-08-31 2017-02-01 广东京奥信息科技有限公司 Data preprocessing method for heterogeneous data sources
CN107066499A (en) * 2016-12-30 2017-08-18 江苏瑞中数据股份有限公司 The data query method of multi-source data management and visualization system is stored towards isomery
CN107958028A (en) * 2017-11-16 2018-04-24 平安科技（深圳）有限公司 Method, apparatus, storage medium and the terminal of data acquisition
CN108052635A (en) * 2017-12-20 2018-05-18 江苏瑞中数据股份有限公司 A kind of heterogeneous data source unifies conjunctive query method
US10157234B1 (en) * 2015-02-27 2018-12-18 Quest Software Inc. Systems and methods for transforming datasets
CN109522321A (en) * 2018-11-15 2019-03-26 北京锐安科技有限公司 A kind of data base query method, device, server and storage medium
EP3483739A1 (en) * 2017-05-12 2019-05-15 QlikTech International AB Cognitive rule engine
CN109766352A (en) * 2018-11-19 2019-05-17 成都四方伟业软件股份有限公司 The method and system that a kind of pair of heterogeneous data source is uniformly processed
CN110083347A (en) * 2019-03-18 2019-08-02 中科恒运股份有限公司 The realization system of Visualization Platform
EP3550444A1 (en) * 2018-04-02 2019-10-09 Thoughtspot Inc. Query generation based on a logical data model

Patent Citations (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101930469A (en) * 2010-09-02 2010-12-29 江西省电力公司超高压分公司 Universal data access method of cross-platform multi-heterogeneous database in scheduling data service platform
CN102262561A (en) * 2011-07-01 2011-11-30 深圳市极限网络科技有限公司 Method for scheduling processing of massive tasks of databases
CN104573115A (en) * 2015-02-04 2015-04-29 新余兴邦信息产业有限公司 Method and system for achieving integration interface supporting operation of multi-type databases
US10157234B1 (en) * 2015-02-27 2018-12-18 Quest Software Inc. Systems and methods for transforming datasets
CN106021378A (en) * 2016-05-11 2016-10-12 吕骏 Query and analysis method and system based on data extraction and data visualization
CN106372185A (en) * 2016-08-31 2017-02-01 广东京奥信息科技有限公司 Data preprocessing method for heterogeneous data sources
CN107066499A (en) * 2016-12-30 2017-08-18 江苏瑞中数据股份有限公司 The data query method of multi-source data management and visualization system is stored towards isomery
EP3483739A1 (en) * 2017-05-12 2019-05-15 QlikTech International AB Cognitive rule engine
CN107958028A (en) * 2017-11-16 2018-04-24 平安科技（深圳）有限公司 Method, apparatus, storage medium and the terminal of data acquisition
CN108052635A (en) * 2017-12-20 2018-05-18 江苏瑞中数据股份有限公司 A kind of heterogeneous data source unifies conjunctive query method
EP3550444A1 (en) * 2018-04-02 2019-10-09 Thoughtspot Inc. Query generation based on a logical data model
CN109522321A (en) * 2018-11-15 2019-03-26 北京锐安科技有限公司 A kind of data base query method, device, server and storage medium
CN109766352A (en) * 2018-11-19 2019-05-17 成都四方伟业软件股份有限公司 The method and system that a kind of pair of heterogeneous data source is uniformly processed
CN110083347A (en) * 2019-03-18 2019-08-02 中科恒运股份有限公司 The realization system of Visualization Platform

Also Published As

Publication number Publication date
CN111008211A (en) 2020-04-14

Similar Documents

Publication Publication Date Title
CN111008211B (en) Visual interface creating method and device, readable storage medium and electronic equipment
EP3916604A1 (en) Method and apparatus for processing privacy data of block chain, device, storage medium and coputer program product
CN108762791B (en) Firmware upgrading method and device
CN110417543B (en) Data encryption method, device and storage medium
WO2019024230A1 (en) Information encryption and decryption method and device, computer equipment and storage medium
CN111683066B (en) Heterogeneous system integration method, heterogeneous system integration device, computer equipment and storage medium
WO2020233049A1 (en) Data authorization method and apparatus of blockchain system, storage medium, and electronic device
JP2015230707A (en) Kernel program, method nd device inherent in relational database
JP6793667B2 (en) Application download method and equipment
CN111200593A (en) Application login method and device and electronic equipment
CN115208951B (en) Request processing method, request processing device, electronic equipment and computer readable storage medium
EP3511853A1 (en) Security authentication method, integrated circuit and system
US20200389366A1 (en) Method for managing multiple servers and device employing method
US20200396073A1 (en) System and method for testing authentication and reviewing implementation processes of an application programming interface in a software development platform
CN111510326A (en) Master-slave equipment configuration information synchronization method, system, terminal equipment and storage medium
CN114416773B (en) Data processing method, device, storage medium and server
US20150065117A1 (en) Mobile device configuration system and method
CN111427860A (en) Distributed storage system and data processing method thereof
WO2019178981A1 (en) Password management method and device employing customized rules, terminal apparatus, and storage medium
CN113794706A (en) Data processing method and device, electronic equipment and readable storage medium
CN113590593A (en) Method and device for generating data table information, storage medium and electronic device
CN116244682A (en) Database access method, device, equipment and storage medium
CN114117388A (en) Device registration method, device registration apparatus, electronic device, and storage medium
CN113965360A (en) Intelligent device cloud server access method, device, medium, device and system
CN112333150A (en) Data decryption method and device, storage medium and computing equipment

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
CB02 Change of applicant information
CB02 Change of applicant information

Address after: No.27, 1st floor, building 14, Haidian Road, zhongjiancai District, Beijing 100096

Applicant after: Beijing PERCENT Technology Group Co.,Ltd.

Address before: No.27, 1st floor, building 14, Haidian Road, zhongjiancai District, Beijing 100096

Applicant before: BEIJING BAIFENDIAN INFORMATION SCIENCE & TECHNOLOGY Co.,Ltd.

GR01 Patent grant
GR01 Patent grant