CN113721901B - Low-code financial data analysis visualization engine - Google Patents

Low-code financial data analysis visualization engine Download PDF

Info

Publication number
CN113721901B
CN113721901B CN202110710831.8A CN202110710831A CN113721901B CN 113721901 B CN113721901 B CN 113721901B CN 202110710831 A CN202110710831 A CN 202110710831A CN 113721901 B CN113721901 B CN 113721901B
Authority
CN
China
Prior art keywords
page
data
database
user
users
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
CN202110710831.8A
Other languages
Chinese (zh)
Other versions
CN113721901A (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.)
State Grid Anhui Electric Power Co Ltd
Original Assignee
State Grid Anhui Electric Power 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 State Grid Anhui Electric Power Co Ltd filed Critical State Grid Anhui Electric Power Co Ltd
Priority to CN202110710831.8A priority Critical patent/CN113721901B/en
Publication of CN113721901A publication Critical patent/CN113721901A/en
Application granted granted Critical
Publication of CN113721901B publication Critical patent/CN113721901B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/34Graphical or visual programming
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/38Creation or generation of source code for implementing user interfaces
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting

Landscapes

  • Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Development Economics (AREA)
  • General Business, Economics & Management (AREA)
  • Technology Law (AREA)
  • Strategic Management (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • Human Computer Interaction (AREA)
  • Stored Programmes (AREA)

Abstract

本发明公开了一种低代码的财务数据分析可视化开发工具,所述开发工具包括:一数据通讯接口,与浏览器进行数据通信,用于提供用户交互UI窗口;一整合页面核心,用于接收用户通过浏览器制作的自定义操作界面,并将其转化为流程代码提供给API系统;一API系统,接收流程代码将其封装为BI软件并提供接口给整合页面核心以供用户运行网页小程序;一数据库接口,将API系统中的基本数据库与数据源中的目标数据库进行链接;还包括一自定义页面布局生成器用于生成用户自定义的可渲染的网页页面,以及一组件库,具有多种流程图形供用户拖拽,自定义页面布局生成器和组件库分别与整合页面核心连接。本发明面向非软件开发人员提供了统一的技术架构和极简的开发方法,简单高效。

The present invention discloses a low-code financial data analysis visualization development tool, the development tool includes: a data communication interface, which communicates data with a browser to provide a user interactive UI window; an integrated page core, which is used to receive a custom operation interface made by a user through a browser, and convert it into a process code and provide it to an API system; an API system, which receives the process code and encapsulates it into BI software and provides an interface to the integrated page core for users to run web applets; a database interface, which links the basic database in the API system with the target database in the data source; and also includes a custom page layout generator for generating user-defined renderable web pages, and a component library, which has a variety of process graphics for users to drag, and the custom page layout generator and the component library are respectively connected to the integrated page core. The present invention provides a unified technical architecture and a minimalist development method for non-software developers, which is simple and efficient.

Description

一种低代码的财务数据分析可视化引擎A low-code financial data analysis visualization engine

技术领域Technical Field

本发明涉及数据可视化技术领域,具体是一种面向非软件开发领域技术人员的无需编写代码即可构建成一个财务数据分析可视化网页的系统。The present invention relates to the technical field of data visualization, and in particular to a system for technical personnel in non-software development fields, which can construct a financial data analysis visualization web page without writing codes.

背景技术Background technique

由于现代企业的信息化基础普遍较好,数据积累量也越来越大,数据分析的需求也越来越高。传统的由技术人员主导的系统开发方式对业务需求的响应速度存在较为明显的延迟,且理解偏差较为明显。为了提高系统开发对业务需求的响应速度和理解的准确程度,系统开发的简单化、自动化、智能化的需求应时而生。As modern enterprises generally have a good informatization foundation, the amount of data accumulated is increasing, and the demand for data analysis is also increasing. The traditional system development method led by technical personnel has a significant delay in responding to business needs, and the understanding deviation is more obvious. In order to improve the response speed of system development to business needs and the accuracy of understanding, the demand for simplified, automated, and intelligent system development has emerged.

当前市面上解决此类需求的主要方式是专门开发的代码开发工具或者BI(Business Intelligence)开发工具,这种工具是将已有代码的可视化模块拖放到工作流中,并辅助编写一定的逻辑代码即可创建应用程序。虽然这种工作方式可以极大减轻开发人员的工作量,将大量的开发工作用可以拖拉拽进行组装的组件予以代替,从而提高开发人员的生产效率,但是这样的建设方式依然是以开发人员为主导,且这一类平台通常是面向比较通用的场景,为了不牺牲灵活性而提高了专业性的要求。Currently, the main way to solve such needs on the market is to use specially developed code development tools or BI (Business Intelligence) development tools. This tool drags and drops the visual modules of existing codes into the workflow, and assists in writing certain logic codes to create applications. Although this way of working can greatly reduce the workload of developers, replacing a large amount of development work with components that can be dragged and assembled, thereby improving the productivity of developers, this construction method is still dominated by developers, and this type of platform is usually oriented towards more general scenarios, and the professional requirements are increased in order not to sacrifice flexibility.

因此,亟需建立一种更低代码的数据分析可视化开发引擎,能够让目前无编程能力的业务人员,通过在该引擎的支持下,进行简单、直观的组装工作,即可开发出满足业务需求的数据分析产品,同时也能兼具专业性。Therefore, there is an urgent need to establish a data analysis visualization development engine with lower code, which can enable business personnel who currently have no programming skills to develop data analysis products that meet business needs while also being professional by performing simple and intuitive assembly work with the support of this engine.

发明内容Summary of the invention

本发明的目的是为了克服现有技术存在的以上不足或改进需求,提供一种面向工业企业的财务数据分析领域非技术人员的低代码可视化开发引擎,能够实现支持业务人员实现简单快速的数据分析网页的搭建和发布。The purpose of the present invention is to overcome the above-mentioned deficiencies or improvement needs of the prior art, and to provide a low-code visual development engine for non-technical personnel in the field of financial data analysis of industrial enterprises, which can support business personnel to achieve simple and fast construction and publishing of data analysis web pages.

为了解决上述技术问题,本发明提供了一种低代码的财务数据分析可视化开发工具,所述开发工具包括:一数据通讯接口,与浏览器进行数据通信,用于提供用户交互UI窗口;In order to solve the above technical problems, the present invention provides a low-code financial data analysis visualization development tool, the development tool comprising: a data communication interface, which communicates data with a browser and is used to provide a user interaction UI window;

一整合页面核心,用于接收用户通过浏览器制作的自定义操作界面,并将其转化为流程代码提供给API系统;An integrated page core is used to receive the custom operation interface created by the user through the browser, and convert it into process code to provide to the API system;

一API系统,接收流程代码将其封装为BI软件并提供接口给整合页面核心以供用户运行网页小程序;An API system that receives process codes and packages them into BI software and provides an interface to the integration page core for users to run web applets;

一数据库接口,将API系统中的基本数据库与数据源中的目标数据库进行链接;A database interface, which links the basic database in the API system with the target database in the data source;

还包括一自定义页面布局生成器用于生成用户自定义的可渲染的网页页面,以及一组件库,具有多种流程图形供用户拖拽;自定义页面布局生成器和组件库分别与整合页面核心连接。It also includes a custom page layout generator for generating user-defined renderable web pages, and a component library with a variety of process graphics for users to drag and drop; the custom page layout generator and the component library are respectively connected to the integrated page core.

进一步的,所述组件库包括:日历、下拉框、导航条、弹窗、柱状图、饼状图、折线图、热力图、地图。Furthermore, the component library includes: calendar, drop-down box, navigation bar, pop-up window, bar chart, pie chart, line chart, heat map, map.

进一步的,还可以通过选项更改所选择组件的基本属性信息,包括配色、线条。Furthermore, you can also use options to change the basic property information of the selected component, including color and lines.

进一步的,API系统针对访问流量还可以执行自适应负载均衡,使得权限高的人士优先被接入访问。Furthermore, the API system can also perform adaptive load balancing for access traffic, so that people with high permissions are given priority access.

本发明还提供了一种基于上述财务数据分析可视化开发工具的数据可视化分析页面的搭建方法,包含以下步骤:The present invention also provides a method for building a data visualization analysis page based on the above-mentioned financial data analysis visualization development tool, comprising the following steps:

步骤1、数据源配置:将数据库的属性参数用表单的形式提供给用户,用户通过浏览器填写好数据后,后台自动将参数拼装成数据库链接路径,将数据库的表格、数据同步至当前开发平台;Step 1, Data source configuration: Provide the attribute parameters of the database to the user in the form of a form. After the user fills in the data through the browser, the background automatically assembles the parameters into a database link path and synchronizes the database tables and data to the current development platform;

步骤2、建立API配置中心,包括如下配置项:Step 2: Establish an API configuration center, including the following configuration items:

a.开发设计API系统以生成平台基本数据库,包含但不仅限于用户表、权限表、菜单表、角色表、数据源表、API记录表;a. Develop and design the API system to generate the basic database of the platform, including but not limited to user table, permission table, menu table, role table, data source table, and API record table;

b.预定义常用数据类型模板,统一使用json格式传递,用于对应组件库中的各种组件所需数据源;b. Predefine common data type templates and uniformly transmit them in json format to correspond to the data sources required by various components in the component library;

c.建立接口自动生成引擎:将生成接口所需要的参数、所需要处理的数据以直观的表单的形式提供给用户,用户在开发平台上通过配置自己所需的数据所在域的名称、字段名称及其他相关信息;接收整合页面核心利用机器学习算法解析用户填写的表单和拖拽的组件所形成的数据处理流程即可生成对应的接口访问路径,从而使得用户避免操作代码学习即可完成接口的开发;c. Establish an automatic interface generation engine: Provide users with the parameters and data to be processed required for interface generation in the form of intuitive forms. Users can configure the name of the domain where the data they need, field name and other related information on the development platform. The receiving integration page core uses machine learning algorithms to parse the data processing flow formed by the form filled in by the user and the dragged components to generate the corresponding interface access path, so that users can complete the interface development without learning the operation code.

步骤3、建立页面配置中心:Step 3: Create a page configuration center:

1)提供自定义页面布局生成器,用户自定义一个或多个前端页面布局,布局解析引擎在后台将布局解析成html代码,通过对API与前端页面的拼装,生成自定义的可渲染的BI网页页面;1) Provide a custom page layout generator. Users can customize one or more front-end page layouts. The layout parsing engine parses the layout into HTML code in the background. By assembling the API and the front-end page, a custom renderable BI web page is generated.

2)提供组件库,用户选定需要用的组件,将组件拖至前面预定义好的网页页面中对应的位置,拼装成完整的静态页面;当对各组件命名完成并确认后,所述整合页面核心会根据组件的名称和连接关系智能地在前台生成业务处理流程和在后台生成代码的执行流程;组件建立完成后,可自动或手动地选中配置好的接口进行关联,从而将组件和数据实现贯通,使整个页面成为完整的可交互的页面。2) Provide a component library, and users select the components they need and drag the components to the corresponding positions in the predefined web pages to assemble them into a complete static page; when the components are named and confirmed, the integrated page core will intelligently generate the business processing flow in the foreground and the code execution flow in the background according to the names and connection relationships of the components; after the components are established, the configured interfaces can be automatically or manually selected for association, so as to connect the components and data and make the entire page a complete and interactive page.

进一步的,还包括步骤4、权限配置,对配置好的页面可以进行权限控制:选中页面后,从角色列表中选中特定的可以访问该页面的角色,或者从人员列表中选中可以访问该页面的具体人员。Furthermore, it also includes step 4, permission configuration, and permission control can be performed on the configured page: after selecting the page, select a specific role that can access the page from the role list, or select a specific person who can access the page from the person list.

进一步的,还包括流程修改控件以供用户进行必要的流程修改和调整。Furthermore, it also includes process modification controls for users to make necessary process modifications and adjustments.

进一步的,数据库的属性参数包括地址、端口、账号、密码;所述数据处理流程包括数据跳转、实体业务逻辑跳转处理流程;机器学习算法采用神经网络训练;页面布局生成器还包含预览、拖拽、编辑等功能以便于操作。Furthermore, the attribute parameters of the database include address, port, account, and password; the data processing flow includes data jump and entity business logic jump processing flow; the machine learning algorithm uses neural network training; the page layout generator also includes preview, drag, edit and other functions for easy operation.

本发明还提供了一种计算机设备,包括存储器、处理器及存储在存储器上并可在处理器上运行的计算机程序,其特征在于,所述存储器执行所述程序时实现上述步骤。The present invention also provides a computer device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the above steps are implemented when the memory executes the program.

本发明还提供了一种处理器,其特征在于,所述处理器用于运行程序,其中,所述程序运行时执行上述步骤。The present invention also provides a processor, characterized in that the processor is used to run a program, wherein the above steps are executed when the program is running.

本发明所述的方案与现有的技术相比,具有如下的有益效果是:Compared with the prior art, the solution of the present invention has the following beneficial effects:

1.本发明的学习成本非常低,但开发效率显著。通过本发明,业务人员(非软件开发领域技术人员)可以轻松掌控需求的实现过程,可以摆脱编程语言的约束。1. The learning cost of the present invention is very low, but the development efficiency is remarkable. Through the present invention, business personnel (non-software development technicians) can easily control the realization process of requirements and get rid of the constraints of programming languages.

2.本发明创造了一种新的人机交互方式:规避了维护过程中文档与代码的一致性问题,最大限度简化了知识转移和软件工程控制过程,为系统维护提供了巨大的便利,针对需求变更,可直接通过图形化工具修改系统原型,简易方便。2. The present invention creates a new human-computer interaction mode: it avoids the consistency problem between documents and codes during the maintenance process, simplifies the knowledge transfer and software engineering control process to the greatest extent, and provides great convenience for system maintenance. In response to changes in requirements, the system prototype can be modified directly through graphical tools, which is simple and convenient.

3.数据分析低代码开发平台是面向无编程能力且从事数据分析工作的业务人员而构建的。业务人员只需要按照习惯的数据分析的工作流程分析数据,将每一个步骤的分析过程和结果按正确的流程保存下来,最后点击发布,即可完成一个面向特定主题的数据分析软件的搭建和发布。3. The data analysis low-code development platform is built for business personnel who have no programming skills and are engaged in data analysis. Business personnel only need to analyze data according to the usual data analysis workflow, save the analysis process and results of each step according to the correct process, and finally click to publish, and they can complete the construction and release of a data analysis software for a specific topic.

本发明的其它特征和优点将在随后的说明书中阐述,并且,部分地从说明书中变得显而易见,或者通过实施本发明而了解。本发明的目的和其他优点可通过在说明书、权利要求书以及附图中所特别指出的结构来实现和获得。Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention can be realized and obtained by the structures particularly pointed out in the description, claims and drawings.

附图说明BRIEF DESCRIPTION OF THE DRAWINGS

附图用来提供对本发明技术方案的进一步理解,并且构成说明书的一部分,与本申请的实施例一起用于解释本发明的技术方案,并不构成对本发明技术方案的限制。The accompanying drawings are used to provide a further understanding of the technical solution of the present invention and constitute a part of the specification. Together with the embodiments of the present application, they are used to explain the technical solution of the present invention and do not constitute a limitation on the technical solution of the present invention.

图1是本发明一实施例所提供的可视化引擎的原理框图;FIG1 is a block diagram of a visualization engine according to an embodiment of the present invention;

图2是本发明一实施例所提供的可视化引擎的实施拓扑图。FIG. 2 is an implementation topology diagram of a visualization engine provided in an embodiment of the present invention.

具体实施方式Detailed ways

为使相关技术人员能更好的理解本发明,对本次申请的目的、技术方案和优点有更加清晰的了解,下面将结合具体实例和附图对本发明做进一步说明。应当理解,此处所描述的具体实施例仅仅用于解释本发明,并不用于限定本发明。需要说明的是,在不冲突的情况下,本申请中的实施例及实施例中的特征可以相互任意组合。In order to enable relevant technical personnel to better understand the present invention and have a clearer understanding of the purpose, technical solutions and advantages of this application, the present invention will be further described below in conjunction with specific examples and drawings. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not intended to limit the present invention. It should be noted that, in the absence of conflict, the embodiments in this application and the features in the embodiments can be combined arbitrarily with each other.

本发明提供了一种“低代码BI软件制作开发平台”,尤其涉及一种低代码的财务数据分析可视化引擎,其原理框图如图1所示,开发平台包括如下主要部件:一数据通讯接口,与包括但不限于Chrome、Firefox等浏览器进行数据通信,用于提供用户交互UI窗口;一整合页面核心,用于接收用户通过浏览器制作的自定义操作界面,并将其转化为流程代码提供给API系统;一API系统,接收流程代码将其封装为BI软件并提供接口给整合页面核心以供用户运行网页小程序;一数据库接口,将API系统中数据库与数据源中的目标数据库进行链接;还包括一自定义页面布局生成器用于生成用户自定义的可渲染的网页页面,以及一组件库,具有柱状图、饼状图、条形图等流程图形供用户拖曳。The present invention provides a "low-code BI software production and development platform", and in particular relates to a low-code financial data analysis visualization engine, whose principle block diagram is shown in Figure 1. The development platform includes the following main components: a data communication interface, which communicates data with browsers including but not limited to Chrome, Firefox, etc., to provide a user interaction UI window; an integrated page core, which is used to receive a custom operation interface made by a user through a browser, and convert it into a process code and provide it to an API system; an API system, which receives the process code and encapsulates it into BI software and provides an interface to the integrated page core for users to run web applets; a database interface, which links the database in the API system with the target database in the data source; and also includes a custom page layout generator for generating user-defined renderable web pages, and a component library with process graphics such as bar charts, pie charts, and bar charts for users to drag.

结合图2所示的拓扑结构,本发明配套的基于上述财务数据分析可视化引擎的数据可视化分析页面的搭建方法,包含以下步骤:In conjunction with the topological structure shown in FIG2 , the method for building a data visualization analysis page based on the above-mentioned financial data analysis visualization engine according to the present invention comprises the following steps:

步骤1、数据源配置:将数据库的地址、端口、账号、密码等属性参数用表单的形式提供给用户,用户通过浏览器填写好数据后,后台自动将参数拼装成数据库链接路径,将数据库的表格、数据同步至当前开发平台;Step 1, Data source configuration: Provide the database address, port, account, password and other attribute parameters to the user in the form of a form. After the user fills in the data through the browser, the background automatically assembles the parameters into a database link path and synchronizes the database tables and data to the current development platform;

步骤2、建立API配置中心,包括如下配置项:Step 2: Establish an API configuration center, including the following configuration items:

a.开发设计API系统以生成平台基本数据库,包含但不仅限于用户表、权限表、菜单表、角色表、数据源表、API记录表;a. Develop and design the API system to generate the basic database of the platform, including but not limited to user table, permission table, menu table, role table, data source table, and API record table;

b.预定义常用数据类型模板,统一使用json格式传递,用于对应组件库中的各种组件所需数据源;b. Predefine common data type templates and uniformly transmit them in json format to correspond to the data sources required by various components in the component library;

c.建立接口自动生成引擎:将生成接口所需要的参数、所需要处理的数据以直观的表单的形式提供给用户,用户在开发平台上可以通过配置自己所需的数据所在域的名称、字段名称等信息;由可视化引擎利用神经网络等机器学习算法解析用户填写的表单和拖曳组件后形成的数据处理流程(数据跳转、实体业务逻辑跳转处理流程)即可生成对应的接口访问路径,从而使得用户避免操作代码学习编写即可完成接口的开发;c. Establish an automatic interface generation engine: Provide users with the parameters and data to be processed required for interface generation in the form of intuitive forms. Users can configure the name of the domain and field name of the data they need on the development platform. The visualization engine uses machine learning algorithms such as neural networks to analyze the form filled out by users and the data processing flow (data jump, entity business logic jump processing flow) formed after dragging components to generate the corresponding interface access path, so that users can complete interface development without learning to write operation codes.

步骤3、建立页面配置中心:Step 3: Create a page configuration center:

1)提供自定义页面布局生成器。用户通过对预先提供的矩形框进行组合,组装一个前端页面布局,布局解析引擎在后台将该组合解析成html代码,通过对API与前端页面的拼装,生成自定义的可渲染的BI网页页面;生成器还包含预览、拖拽、编辑等功能以便于操作;1) Provide a custom page layout generator. Users can assemble a front-end page layout by combining pre-provided rectangular frames. The layout parsing engine parses the combination into HTML code in the background, and generates a custom renderable BI web page by assembling the API and the front-end page. The generator also includes preview, drag and drop, and editing functions for easy operation.

2)提供组件库。平台携带了一整套完整的网页组件库,包含数据可视化领域几乎所有类型的前端展示组件,例如:日历、下拉框、导航条、弹窗、柱状图、饼状图、折线图、热力图、地图等等。还可以通过选项更改配色、线条等组件基本属性信息。用户选定需要用的组件,将组件拖至前面预定义好的网页布局中对应的位置,拼装成完整的静态页面;当对各组件命名完成并确认后,所述引擎会根据组件的名称和连接关系智能地在前台生成业务处理流程和在后台生成代码的执行流程。组件建立完成后,可自动或手动地选中配置好的接口进行关联,从而将组件和数据实现贯通,使整个页面成为完整的可交互的页面。2) Provide a component library. The platform carries a complete set of web component libraries, including almost all types of front-end display components in the field of data visualization, such as calendars, drop-down boxes, navigation bars, pop-ups, bar charts, pie charts, line charts, heat maps, maps, etc. You can also change the basic attribute information of components such as color and lines through options. The user selects the components he needs to use, drags the components to the corresponding positions in the predefined web page layout, and assembles them into a complete static page; when the naming of each component is completed and confirmed, the engine will intelligently generate the business processing flow in the foreground and the execution flow of the code in the background according to the name and connection relationship of the component. After the component is established, the configured interface can be automatically or manually selected for association, so as to connect the components and data, making the entire page a complete and interactive page.

还可以包括流程修改控件以供用户进行必要的修改和调整。Process modification controls may also be included for the user to make necessary modifications and adjustments.

步骤4、权限配置。对配置好的页面可以进行权限控制。页面搭建完成后,默认只能本人浏览。选中页面后,从角色列表中选中特定的可以访问该页面的角色,或者从人员列表中选中可以访问该页面的具体人员,从而将该页面的浏览权限开放给更多人。不同的登录用户会生成自己所属的私有接口请求,不会产生混用等问题。Step 4: Permission configuration. Permission control can be performed on the configured pages. After the page is built, it can only be browsed by the user by default. After selecting the page, select a specific role that can access the page from the role list, or select a specific person who can access the page from the personnel list, so as to open the browsing rights of the page to more people. Different logged-in users will generate their own private interface requests, and there will be no problems such as mixing.

上述各步骤顺序可对调。此外,API系统针对访问流量还可以执行自适应负载均衡,使得权限高的人士优先被接入访问。The order of the above steps can be reversed. In addition, the API system can also perform adaptive load balancing for access traffic, so that people with high permissions are given priority access.

本发明还提供了一种计算机设备,包括存储器、处理器及存储在存储器上并可在处理器上运行的计算机程序,所述存储器执行所述程序时实现上述步骤。The present invention also provides a computer device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the above steps are implemented when the memory executes the program.

本发明还提供了一种处理器,所述处理器用于运行程序,其中,所述程序运行时执行上述步骤。The present invention also provides a processor, which is used to run a program, wherein the above steps are executed when the program is running.

综上,本发明面向非软件开发人员提供了统一的技术架构和极简的开发方法,用户可以在低代码开发平台上根据自己的需要选择合适的系统甚至完全定制一套个性化的系统。In summary, the present invention provides a unified technical architecture and a minimalist development method for non-software developers. Users can choose a suitable system according to their needs on the low-code development platform or even completely customize a personalized system.

虽然本发明所揭露的实施方式如上,但所述的内容仅为便于理解本发明而采用的实施方式,并非用以限定本发明。任何本发明所属领域内的技术人员,在不脱离本发明所揭露的精神和原则的前提下,可以在实施的形式及细节上进行任何的修改与变化、等同替换等,这些都属于本发明的保护范围。因此,本发明的专利保护范围,仍须以所附的权利要求书所界定的范围为准。Although the embodiments disclosed in the present invention are as above, the contents described are only embodiments adopted for facilitating the understanding of the present invention and are not intended to limit the present invention. Any technician in the field to which the present invention belongs can make any modifications and changes, equivalent substitutions, etc. in the form and details of implementation without departing from the spirit and principles disclosed in the present invention, and these all belong to the protection scope of the present invention. Therefore, the patent protection scope of the present invention shall still be subject to the scope defined by the attached claims.

Claims (9)

1.一种基于低代码的财务数据分析可视化开发工具的数据可视化分析页面的搭建方法,其特征在于:1. A method for building a data visualization analysis page based on a low-code financial data analysis visualization development tool, characterized in that: 所述开发工具包括:一数据通讯接口,与浏览器进行数据通信,用于提供用户交互UI窗口;一整合页面核心,用于接收用户通过浏览器制作的自定义操作界面,并将其转化为流程代码提供给API系统;一API系统,接收流程代码将其封装为BI软件并提供接口给整合页面核心以供用户运行网页小程序;一数据库接口,将API系统中的基本数据库与数据源中的目标数据库进行链接;还包括一自定义页面布局生成器用于生成用户自定义的可渲染的网页页面,以及一组件库,具有多种流程图形供用户拖拽,自定义页面布局生成器和组件库分别与整合页面核心连接;The development tool includes: a data communication interface for data communication with the browser to provide a user interactive UI window; an integrated page core for receiving a custom operation interface made by a user through a browser, and converting it into a process code and providing it to the API system; an API system for receiving the process code, encapsulating it into BI software and providing an interface to the integrated page core for users to run web applets; a database interface for linking the basic database in the API system with the target database in the data source; and also includes a custom page layout generator for generating user-defined renderable web pages, and a component library with a variety of process graphics for users to drag and drop, and the custom page layout generator and the component library are respectively connected to the integrated page core; 所述方法包含以下步骤:The method comprises the following steps: 步骤1、数据源配置:将数据库的属性参数用表单的形式提供给用户,用户通过浏览器填写好数据后,后台自动将参数拼装成数据库链接路径,将数据库的表格、数据同步至当前开发平台;Step 1: Data source configuration: Provide the attribute parameters of the database to the user in the form of a form. After the user fills in the data through the browser, the background automatically assembles the parameters into a database link path and synchronizes the database tables and data to the current development platform. 步骤2、建立API配置中心,包括如下配置项:Step 2: Establish an API configuration center, including the following configuration items: a.开发设计API系统以生成平台基本数据库,包含但不仅限于用户表、权限表、菜单表、角色表、数据源表、API记录表;a. Develop and design the API system to generate the basic database of the platform, including but not limited to user table, permission table, menu table, role table, data source table, and API record table; b.预定义常用数据类型模板,统一使用json格式传递,用于对应组件库中的各种组件所需数据源;b. Predefine common data type templates and uniformly transmit them in json format to correspond to the data sources required by various components in the component library; c.建立接口自动生成引擎:将生成接口所需要的参数、所需要处理的数据以直观的表单的形式提供给用户,用户在开发平台上通过配置自己所需的数据所在域的名称、字段名称及其他相关信息;接收整合页面核心利用机器学习算法解析用户填写的表单和拖拽的组件所形成的数据处理流程即可生成对应的接口访问路径;c. Establish an automatic interface generation engine: Provide the parameters required for interface generation and the data to be processed to users in the form of intuitive forms. Users can configure the name of the domain where the data they need, field name and other related information on the development platform. The receiving integration page core uses machine learning algorithms to analyze the data processing flow formed by the form filled in by the user and the dragged components to generate the corresponding interface access path; 步骤3、建立页面配置中心:Step 3: Create a page configuration center: 1)提供自定义页面布局生成器,用户自定义一个或多个前端页面布局,布局解析引擎在后台将布局解析成html代码,通过对API与前端页面的拼装,生成自定义的可渲染的BI网页页面;1) Provide a custom page layout generator. Users can customize one or more front-end page layouts. The layout parsing engine parses the layout into HTML code in the background. By assembling the API and the front-end page, a custom renderable BI web page is generated. 2)提供组件库,用户选定需要用的组件,将组件拖至前面预定义好的网页页面中对应的位置,拼装成完整的静态页面;当对各组件命名完成并确认后,所述整合页面核心会根据组件的名称和连接关系智能地在前台生成业务处理流程和在后台生成代码的执行流程;组件建立完成后,可自动或手动地选中配置好的接口进行关联,从而将组件和数据实现贯通,使整个页面成为完整的可交互的页面。2) Provide a component library, and users select the components they need and drag the components to the corresponding positions in the predefined web pages to assemble them into a complete static page; after the components are named and confirmed, the integrated page core will intelligently generate the business processing flow in the foreground and the code execution flow in the background according to the names and connection relationships of the components; after the components are established, the configured interfaces can be automatically or manually selected for association, so as to connect the components and data and make the entire page a complete and interactive page. 2.如权利要求1所述的方法,所述组件库包括:日历、下拉框、导航条、弹窗、柱状图、饼状图、折线图、热力图、地图。2. According to the method as claimed in claim 1, the component library includes: a calendar, a drop-down box, a navigation bar, a pop-up window, a bar chart, a pie chart, a line chart, a heat map, and a map. 3.如权利要求1所述的方法,其特征在于:还可以通过选项更改所选择组件的基本属性信息,包括配色、线条。3. The method as claimed in claim 1 is characterized in that: basic attribute information of the selected component, including color and lines, can also be changed through options. 4.如权利要求1所述的方法,其特征在于:API系统针对访问流量还可以执行自适应负载均衡,使得权限高的人士优先被接入访问。4. The method as claimed in claim 1 is characterized in that: the API system can also perform adaptive load balancing for access traffic, so that people with high authority are given priority in access. 5.如权利要求1所述的方法,其特征在于,还包括:步骤4、权限配置,对配置好的页面可以进行权限控制:选中页面后,从角色列表中选中可以访问该页面的角色,或者从人员列表中选中可以访问该页面的具体人员。5. The method as claimed in claim 1 is characterized in that it also includes: step 4, permission configuration, and permission control can be performed on the configured page: after selecting the page, select the role that can access the page from the role list, or select the specific person who can access the page from the personnel list. 6.如权利要求1所述的方法,其特征在于,还包括流程修改控件以供用户进行流程修改和调整。6. The method of claim 1, further comprising a process modification control for allowing a user to modify and adjust the process. 7.如权利要求1所述的方法,其特征在于,数据库的属性参数包括地址、端口、账号、密码。7. The method according to claim 1, characterized in that the attribute parameters of the database include address, port, account number, and password. 8.如权利要求1所述的方法,其特征在于,所述数据处理流程包括数据跳转、实体业务逻辑跳转处理流程。8. The method according to claim 1 is characterized in that the data processing flow includes data jump and entity business logic jump processing flow. 9.如权利要求1所述的方法,其特征在于,机器学习算法采用神经网络训练;页面布局生成器包含预览、拖拽、编辑多项功能。9. The method as claimed in claim 1 is characterized in that the machine learning algorithm adopts neural network training; the page layout generator includes multiple functions such as preview, drag and drop, and editing.
CN202110710831.8A 2021-06-25 2021-06-25 Low-code financial data analysis visualization engine Active CN113721901B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110710831.8A CN113721901B (en) 2021-06-25 2021-06-25 Low-code financial data analysis visualization engine

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110710831.8A CN113721901B (en) 2021-06-25 2021-06-25 Low-code financial data analysis visualization engine

Publications (2)

Publication Number Publication Date
CN113721901A CN113721901A (en) 2021-11-30
CN113721901B true CN113721901B (en) 2024-07-12

Family

ID=78672938

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110710831.8A Active CN113721901B (en) 2021-06-25 2021-06-25 Low-code financial data analysis visualization engine

Country Status (1)

Country Link
CN (1) CN113721901B (en)

Families Citing this family (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114358049A (en) * 2021-12-08 2022-04-15 杭州电子科技大学 Electroencephalogram EEG signal analysis platform based on low code generation technology
CN114493169A (en) * 2021-12-31 2022-05-13 武汉达梦数据库股份有限公司 A data analysis engine system, implementation method, device and storage medium
CN114115883B (en) * 2022-01-26 2022-06-03 广州云徙科技有限公司 Method for quickly constructing front-end application by using middle station service capability
CN114461200A (en) * 2022-01-27 2022-05-10 广东精工智能系统有限公司 A low-code development application and method based on cloud SaaS platform
CN114610298A (en) * 2022-02-18 2022-06-10 深圳市佐朋数字科技有限公司 A low-code API design and development method, system and storage medium
CN114579127B (en) * 2022-03-17 2025-05-20 抖音视界有限公司 Page deployment method and device, computer equipment and storage medium
CN115268861B (en) * 2022-06-21 2023-04-11 北京志凌海纳科技有限公司 Introduction method, system, equipment and storage medium of custom component
CN115934068B (en) * 2022-11-11 2024-07-19 中电金信软件有限公司 Data statistics page generation method, display method, server and mobile terminal
CN115964037B (en) * 2023-01-05 2023-08-29 三峡高科信息技术有限责任公司 Engineering data visualization low-code configuration method and system
CN116244010B (en) * 2023-02-16 2024-09-03 阿里巴巴(中国)有限公司 Conference collaboration tool processing system, method and device
CN116225438A (en) * 2023-05-10 2023-06-06 和创(北京)科技股份有限公司 Custom configuration multifunctional workbench system
CN118245551B (en) * 2024-05-28 2024-07-23 杭州跃翔科技有限公司 A low-code platform data transmission method and system based on BI platform

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105700888A (en) * 2016-01-14 2016-06-22 国网山东省电力公司物资公司 Visualization rapid developing platform based on jbpm workflow engine

Family Cites Families (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101256492A (en) * 2008-03-31 2008-09-03 宋乃辉 Software development method and system for executing model drive structure
US8813028B2 (en) * 2012-07-19 2014-08-19 Arshad Farooqi Mobile application creation system
KR101456506B1 (en) * 2012-08-06 2014-10-31 인크로스 주식회사 An authoring tool for web applications and the authoring method thereof
US20140047409A1 (en) * 2012-08-13 2014-02-13 Magnet Systems Inc. Enterprise application development tool
WO2015147656A2 (en) * 2014-03-26 2015-10-01 Auckland Uniservices Limited Automatic process and system for software development kit for application programming interface
CN108701254B (en) * 2016-08-22 2022-11-18 甲骨文国际公司 Systems and methods for dynamic family tracking, reconstruction and lifecycle management
US10216494B2 (en) * 2016-12-03 2019-02-26 Thomas STACHURA Spreadsheet-based software application development
US10650611B1 (en) * 2017-09-12 2020-05-12 Atlatl Software, Inc. Systems and methods for graphical programming
CN107844299B (en) * 2017-12-01 2021-01-22 浪潮软件股份有限公司 Method for implementing Web application development tool
CN110647323A (en) * 2019-09-17 2020-01-03 北京快威科创信息技术有限公司 Code-free business application software development platform

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105700888A (en) * 2016-01-14 2016-06-22 国网山东省电力公司物资公司 Visualization rapid developing platform based on jbpm workflow engine

Also Published As

Publication number Publication date
CN113721901A (en) 2021-11-30

Similar Documents

Publication Publication Date Title
CN113721901B (en) Low-code financial data analysis visualization engine
CN104732306B (en) Rapid development system and method for business application system
CN104679488B (en) A kind of flow custom development platform and flow custom development approach
CN103218225B (en) A kind of unified survey sends out control software development system
CN108512691A (en) Cloud automatic early-warning O&M monitoring system based on Hadoop
CN103645908B (en) Full life circle development achievement system of intemetware
CN112668295A (en) Management system and method based on user-defined form and Activiti workflow
CN114115883B (en) Method for quickly constructing front-end application by using middle station service capability
CN111881662A (en) Form generation method, device, processing equipment and storage medium
CN104049957A (en) Rapid modeling frame of general business model based on star structure
CN114461200A (en) A low-code development application and method based on cloud SaaS platform
CN102426519A (en) BPEL template and service multiplexing method and system based on associated data
CN114089958A (en) Form visualization configuration method and device
CN114548056A (en) Rich text editing method, device and equipment
CN102938096B (en) A kind of implementation method of the power plant registration information declaration system of dynamic configuration
CN108491195A (en) Equipment controls page generation method and system
KR20170083718A (en) System of Building Responsive Website And Method there-of
JP2020017277A (en) Web reporting design system for programming event operation, based on graphic interface
CN116382643A (en) A running system based on a low-code platform
CN107122171A (en) Automatically generate the method and system of data manipulation in operation flow
CN114168117A (en) A designer-based low-code development tool and storage device for Xinchuang
CN104063231B (en) Test resource rapid access method based on HIT-TENA
Brabra et al. Model-driven elasticity for cloud resources
CN114238072A (en) HIL requirements design method, apparatus, computer equipment and storage medium
CN116707127B (en) Visual quick configuration system of digital monitored control system human-computer interface of transformer substation

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