CN112540991B - System logic construction method based on data table relation - Google Patents
System logic construction method based on data table relation Download PDFInfo
- Publication number
- CN112540991B CN112540991B CN202011443302.8A CN202011443302A CN112540991B CN 112540991 B CN112540991 B CN 112540991B CN 202011443302 A CN202011443302 A CN 202011443302A CN 112540991 B CN112540991 B CN 112540991B
- Authority
- CN
- China
- Prior art keywords
- field
- fields
- user
- control
- empty
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
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/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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24558—Binary matching operations
- G06F16/2456—Join operations
-
- 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/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44521—Dynamic linking or loading; Link editing at or after load time, e.g. Java class loading
- G06F9/44526—Plug-ins; Add-ons
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Probability & Statistics with Applications (AREA)
- Computational Linguistics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention relates to the technical field of computers, in particular to a system logic construction method based on a data table relation, which comprises the following steps: A) connecting the existing database of the user; B) acquiring a database main table and an association table; C) generating a corresponding dragging control according to the field of the database; D) responding to the dragging of a user and generating a target page; E) and generating corresponding system operation logic according to the control and the corresponding field contained in the target page. The substantial effects of the invention are as follows: the existing database of the user is connected, the field of the user is obtained firstly, then the dragging control is generated according to the field, the new page is built without building a new data table through improvement in sequence, system logic of the newly built page can be fused with an original system, after data of the original system is updated, the newly built page can directly obtain changed data for service processing, and the problem of data asynchronization is avoided.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a system logic construction method based on a data table relation.
Background
Usually, the C/S structure adopts a two-layer structure, where the server is responsible for data management and the client is responsible for completing interaction tasks with the user. The client is connected with the server through the network, receives the request of the user, and makes the request to the server through the network to operate the database. The server receives the request of the client, submits the data to the client, and the client calculates the data and presents the result to the user. The C/S structure has the main characteristics of strong interactivity, safe access mode, high response speed and contribution to processing a large amount of data. And thus become a mode of office automation for an increasingly wide range of business users. However, the C/S structure lacks versatility, and the system maintenance and upgrade needs to be redesigned and developed, which increases the difficulty of maintenance and management. Therefore, enterprises without program development ability are difficult to build own office automation systems. The visual page generation technology comes up, the visible page generation adopts a what you see is what you get building mode, splicing of background association codes is automatically completed in the background, and a user only needs to build a simple UI interface, so that the construction of an office automation system can be completed, and great convenience is brought to the building of a user system.
However, in the existing visual page generation technology, various controls such as a text input box, a drop-down box, a radio box, a multi-choice box, a picture placeholder and the like are generated firstly, then a user inputs the name, the variable type and the like of the control, a new data table is generated in a background at the same time, and new fields are added into the new data table after the user adds the new control and defines the attribute of the control until the user completes the construction of a page, and the background also completes the construction of the data table. However, the data table is newly built, and has no data, so that the function of newly building a page can be realized only after independent data synchronization is required. When the original data of the user is changed, data synchronization needs to be carried out again, so that the function of newly building the page is disconnected with the function of the original system in practice.
For example, chinese patent CN110377858A, published 2019, 10, 25, a system for generating a dynamic form page by visual drag includes a design interface, where the design interface includes a component area, a design area, and a parameter configuration area: the component area comprises a basic component and a shared component, wherein the basic component comprises a layout component, a form component, an interaction component and a display component; the layout component can realize one-row multi-column and multi-layer nested layout, and a plurality of div layers are arranged in one row of a page to display areas; when the multilayer components are nested, the internal components are contained when the external components are dragged to other areas; and a status bar is arranged at the bottom of the design area, each component dragged into the design area is provided with a unique ID attribute, the nesting relation of the components is obtained, the nesting relation is displayed in the status bar, and the ID component is directly positioned by clicking the name of a certain component in the status bar. Although the technical scheme can realize free layout and can adapt to various webpage designs, the technical problem that a new page is disjointed from original data cannot be solved.
Disclosure of Invention
The technical problem to be solved by the invention is as follows: the logic of a newly built page is disjointed from an original system when the visual page is created at present. The method can complete the construction of the system logic while quickly constructing the page.
In order to solve the technical problems, the technical scheme adopted by the invention is as follows: a system logic construction method based on data table relationship comprises the following steps: A) connecting the existing database of the user; B) acquiring a database main table and an association table; C) generating a corresponding dragging control according to the field of the database; D) responding to the dragging of a user and generating a target page; E) and generating corresponding system operation logic according to the control and the corresponding field contained in the target page. The existing database of the user is connected, the field of the user is obtained firstly, then the dragging control is generated according to the field, the new page is built without building a new data table through improvement in sequence, system logic of the newly built page can be fused with an original system, after data of the original system is updated, the newly built page can directly obtain changed data for service processing, and the problem of data asynchronization is avoided.
Preferably, the method for obtaining the association table of the main table in the step B) includes: B1) reading fields and field attributes of the main table to obtain a non-empty field set of the main table; B2) reading fields and field attributes of other user tables in a database of a user to obtain a non-empty field set of each user table; B3) and taking the user table with the non-empty intersection of the non-empty field set and the non-empty field set of the main table as an association table of the main table. The set of fields related to the service can be obtained through the association table, and the efficiency of building a new page can be improved.
Preferably, in step C), the method for generating a corresponding drag control according to a field of the database includes: C1) counting the use frequency of fields of the user table, and arranging the fields in descending order according to the use frequency; C2) generating a dragging control for each field, wherein the dragging control comprises an icon and a control attribute modification box, when the icon of the control is clicked, the control attribute modification box is displayed near a mouse pointer, and the control attribute modification box comprises a control type selection bar, a control name modification area and a control default value modification area; C3) and arranging the dragging controls corresponding to the fields beside the target page generation area according to the field sequencing. The controls are generated according to the fields firstly, and then the type of the control corresponding to each field can be modified, so that the new page can be conveniently built.
Preferably, in step C1), the method for counting the usage frequency of the fields of the user table includes: traversing the user table, acquiring fields of each user table, defining the weight of non-empty fields as 1, and calculating the use frequency of the fields as follows: and theta is alpha multiplied by beta, wherein theta is the use frequency of the field, alpha is the non-null value ratio of the field in the current user table, and beta is the non-null value ratio of the field in the whole user table. The use frequency of the field is represented by the non-null value ratio, and the use frequency of the field can be accurately and quickly obtained.
Preferably, the non-null value ratio α of the field in the current user table is calculated by:
wherein N is the total number of the table, and T is a null value field of the field in the table; the calculation method of the non-null value ratio beta of the fields in all the user tables comprises the following steps:
wherein, mu i The ratio of the fields in each table to the non-empty fields, and M is the number of tables in which the fields exist; the ratio mu of the fields in each table to the non-empty fields i The calculation method comprises the following steps:
where K is the corresponding number of rows under a field, H J The number of null value fields in a column corresponding to a certain field in the table.
Preferably, in step C1), the usage frequency θ of the field is δ × α × β, where δ is the table weight, the table weight of the main table is 1, and the table weights of the other user tables are less than 1.
Preferably, the table weight calculation method of the user table includes: calculating the use probability rho of each data field in the table, calculating the use probability sigma of the table in the use process, calculating the probability omega of non-empty fields inserted in the table, and taking the average value of the use probability rho of each data field in the table, the use probability sigma of the table in the use process and the probability omega of non-empty fields inserted in the table as the table weight of the user table. The scientificity of the field usage frequency can be further improved by combining the weights of the user table.
Preferably, in step E), the method for generating the system operation logic includes: E1) acquiring a form area and a result display area contained in a target page according to the type and the position of a control contained in the target page; E2) and if the fields contained in the form area and the result display area are distributed in a plurality of user tables, generating a query statement for simultaneously querying the plurality of user tables, wherein a condition field in the query statement comprises the fields contained in the form area, and a result field in the query statement comprises the fields contained in the result display area. By automatically generating the system operation logic, the query statement is provided, namely the building of the system logic is automatically completed, and the building speed of a new page is increased.
The substantial effects of the invention are as follows: the existing database of the user is connected, the field of the user is obtained firstly, then the dragging control is generated according to the field, the new page is built without building a new data table through improvement in sequence, system logic of the newly built page can be fused with an original system, after data of the original system is updated, the newly built page can directly obtain changed data for service processing, and the problem of data asynchronization is avoided.
Drawings
Fig. 1 is a flow chart of a system logic construction method according to an embodiment.
FIG. 2 is a flowchart illustrating a method for obtaining an association table of a master table according to an embodiment.
FIG. 3 is a flowchart of a method for generating a drag control according to an embodiment.
Detailed Description
The following provides a more detailed description of the present invention, with reference to the accompanying drawings.
The first embodiment is as follows:
a method for constructing system logic based on data table relationship, as shown in FIG. 1, includes the following steps: A) connecting the existing database of the user; B) acquiring a database main table and an association table; C) generating a corresponding dragging control according to the field of the database; D) responding to the dragging of a user and generating a target page; E) and generating corresponding system operation logic according to the control and the corresponding field contained in the target page.
As shown in fig. 2, the method for obtaining the association table of the main table in step B) includes: B1) reading fields and field attributes of the main table to obtain a non-empty field set of the main table; B2) reading fields and field attributes of other user tables in a database of a user to obtain a non-empty field set of each user table; B3) and taking the user table with the non-empty intersection of the non-empty field set and the non-empty field set of the main table as an association table of the main table.
As shown in fig. 3, in step C), the method for generating a corresponding drag control according to a field of the database includes: C1) counting the use frequency of fields of the user table, and arranging the fields in descending order according to the use frequency; C2) generating a dragging control for each field, wherein the dragging control comprises an icon and a control attribute modification frame, when the icon of the control is clicked, the control attribute modification frame is displayed near a mouse pointer, and the control attribute modification frame comprises a control type selection bar, a control name modification area and a control default value modification area; C3) and arranging the dragging controls corresponding to the fields beside the target page generation area according to field sequencing. In step C1), the method for counting the usage frequency of the fields of the user table includes: traversing the user table, acquiring the field of each user table, defining the weight of a non-empty field as 1, and calculating the use frequency of the field as: and theta is alpha multiplied by beta, wherein theta is the use frequency of the field, alpha is the non-null value ratio of the field in the current user table, and beta is the non-null value ratio of the field in the whole user table.
The calculation method of the non-null value ratio alpha of the field in the current user table comprises the following steps:
wherein N is the total number of the table, and T is a null value field of the field in the table;the calculation method of the non-null value ratio beta of the fields in all the user tables comprises the following steps:
wherein, mu i The ratio of the fields in each table to the non-empty fields, and M is the number of tables in which the fields exist; ratio of fields to non-empty fields in each table i The calculation method comprises the following steps:
where K is the corresponding number of rows under the field, H J The number of null value fields in a column corresponding to a certain field in the table. Step C1), the usage frequency θ of the field is δ × α × β, where δ is the table weight, the table weight of the main table is 1, and the table weights of the other user tables are less than 1.
The table weight calculation method of the user table comprises the following steps: calculating the use probability rho of each data field in the table, calculating the use probability sigma of the table in the use process, calculating the probability omega of non-empty fields inserted in the table, and taking the average value of the use probability rho of each data field in the table, the use probability sigma of the table in the use process and the probability omega of the non-empty fields inserted in the table as the table weight of the user table. The scientificity of the field usage frequency can be further improved by combining the weights of the user table.
In step E), the method for generating the system operation logic comprises the following steps: E1) acquiring a form area and a result display area contained in a target page according to the type and the position of a control contained in the target page; E2) and if the fields contained in the form area and the result display area are distributed in the plurality of user tables, generating a query sentence for simultaneously querying the plurality of user tables, wherein the condition fields in the query sentence comprise the fields contained in the form area, and the result fields in the query sentence comprise the fields contained in the result display area.
The beneficial technical effects of this embodiment do: the existing database of the user is connected, the field of the user is obtained firstly, then the dragging control is generated according to the field, the new page is built without building a new data table through improvement in sequence, system logic of the newly built page can be fused with an original system, after data of the original system is updated, the newly built page can directly obtain changed data for service processing, and the problem of data asynchronization is avoided. The set of fields related to the service can be obtained through the association table, and the efficiency of building a new page can be improved. By automatically generating the system operation logic, the query statement is provided, namely the building of the system logic is automatically completed, and the building speed of a new page is increased.
The above-described embodiments are only preferred embodiments of the present invention, and are not intended to limit the present invention in any way, and other variations and modifications may be made without departing from the spirit of the invention as set forth in the claims.
Claims (5)
1. A system logic construction method based on data table relationship is characterized in that,
the method comprises the following steps:
A) connecting the existing database of the user;
B) acquiring a database main table and an association table;
C) generating a corresponding dragging control according to the field of the database;
in step C), the method for generating the corresponding dragging control according to the field of the database comprises the following steps:
C1) counting the use frequency of fields of the user table, and arranging the fields in descending order according to the use frequency;
C2) generating a dragging control for each field, wherein the dragging control comprises an icon and a control attribute modification box, when the icon of the control is clicked, the control attribute modification box is displayed near a mouse pointer, and the control attribute modification box comprises a control type selection bar, a control name modification area and a control default value modification area;
C3) arranging dragging controls corresponding to the fields beside a target page generation area according to field sequencing;
in step C1), the method for counting the usage frequency of the fields of the user table includes:
traversing the user table, acquiring the field of each user table, defining the weight of a non-empty field as 1, and calculating the use frequency of the field as: θ is α × β, where θ is the frequency of use of the field, α is the non-null ratio of the field in the current user table, and β is the non-null ratio of the field in all the user tables;
the calculation method of the non-null value ratio alpha of the field in the current user table comprises the following steps:
wherein N is the total number of the table, and T is a null value field of the field in the table;
the calculation method of the non-null value ratio beta of the fields in all the user tables comprises the following steps:
wherein, mu i The ratio of the fields in each table to the non-empty fields, and M is the number of tables in which the fields exist;
ratio mu of non-empty fields of said fields in each table i The calculation method comprises the following steps:
where K is the corresponding number of rows under the field, H J The number of null value fields in a column corresponding to a certain field in the table;
D) responding to the dragging of a user and generating a target page;
E) and generating corresponding system operation logic according to the control and the corresponding field contained in the target page.
2. The method for building system logic based on data table relationship as claimed in claim 1,
the method for obtaining the association table of the main table in the step B) comprises the following steps:
B1) reading fields and field attributes of the main table to obtain a non-empty field set of the main table;
B2) reading fields and field attributes of other user tables in a database of a user to obtain a non-empty field set of each user table;
B3) and taking the user table with the non-empty intersection of the non-empty field set and the non-empty field set of the main table as an association table of the main table.
3. The method for building system logic based on data table relationship as claimed in claim 1,
step C1), the usage frequency θ of the field is δ × α × β, where δ is the table weight, the table weight of the main table is 1, and the table weights of the other user tables are less than 1.
4. The method for building system logic based on data table relationship as claimed in claim 3,
the table weight calculation method of the user table comprises the following steps:
calculating the use probability rho of each data field in the table, calculating the use probability sigma of the table in the use process, calculating the probability omega of non-empty fields inserted in the table, and taking the average value of the use probability rho of each data field in the table, the use probability sigma of the table in the use process and the probability omega of the non-empty fields inserted in the table as the table weight of the user table.
5. The method for building system logic based on data table relationship as claimed in claim 1 or 2,
in step E), the method for generating the system operation logic comprises the following steps:
E1) acquiring a form area and a result display area contained in a target page according to the type and the position of a control contained in the target page;
E2) and if the fields contained in the form area and the result display area are distributed in the plurality of user tables, generating a query sentence for simultaneously querying the plurality of user tables, wherein the condition fields in the query sentence comprise the fields contained in the form area, and the result fields in the query sentence comprise the fields contained in the result display area.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011443302.8A CN112540991B (en) | 2020-12-08 | 2020-12-08 | System logic construction method based on data table relation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011443302.8A CN112540991B (en) | 2020-12-08 | 2020-12-08 | System logic construction method based on data table relation |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112540991A CN112540991A (en) | 2021-03-23 |
| CN112540991B true CN112540991B (en) | 2022-09-30 |
Family
ID=75020050
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011443302.8A Active CN112540991B (en) | 2020-12-08 | 2020-12-08 | System logic construction method based on data table relation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112540991B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114640530B (en) * | 2022-03-24 | 2023-12-29 | 深信服科技股份有限公司 | Data leakage detection method and device, electronic equipment and readable storage medium |
| CN117492721B (en) * | 2023-12-29 | 2024-04-16 | 中建三局信息科技有限公司 | General rapid development method applied to building digital information system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101576823A (en) * | 2009-06-11 | 2009-11-11 | 阿里巴巴集团控股有限公司 | Method for verifying form control and device |
| CN101697123A (en) * | 2009-10-20 | 2010-04-21 | 金蝶软件（中国）有限公司 | Method and device for modifying interface layout in ERP system and ERP system |
| CN104102489A (en) * | 2014-07-24 | 2014-10-15 | 深圳市神州通在线科技有限公司 | Third-party database APP (Application) construction system and construction method |
| CN111178023A (en) * | 2019-12-30 | 2020-05-19 | 广东飞企互联科技股份有限公司 | Visual self-defined report design system |
| CN111897817A (en) * | 2020-07-23 | 2020-11-06 | 苏州创腾软件有限公司 | Visual form configuration method, device and system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9262462B2 (en) * | 2012-07-26 | 2016-02-16 | Mongodb, Inc. | Aggregation framework system architecture and method |
-
2020
- 2020-12-08 CN CN202011443302.8A patent/CN112540991B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101576823A (en) * | 2009-06-11 | 2009-11-11 | 阿里巴巴集团控股有限公司 | Method for verifying form control and device |
| CN101697123A (en) * | 2009-10-20 | 2010-04-21 | 金蝶软件（中国）有限公司 | Method and device for modifying interface layout in ERP system and ERP system |
| CN104102489A (en) * | 2014-07-24 | 2014-10-15 | 深圳市神州通在线科技有限公司 | Third-party database APP (Application) construction system and construction method |
| CN111178023A (en) * | 2019-12-30 | 2020-05-19 | 广东飞企互联科技股份有限公司 | Visual self-defined report design system |
| CN111897817A (en) * | 2020-07-23 | 2020-11-06 | 苏州创腾软件有限公司 | Visual form configuration method, device and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112540991A (en) | 2021-03-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10222943B2 (en) | Cellular user interface | |
| US7594181B2 (en) | Prototyping graphical user interfaces | |
| US9639814B2 (en) | Automated default dimension selection within a multidimensional enterprise software system | |
| US10733034B2 (en) | Trace messaging for distributed execution of data processing pipelines | |
| US8667405B2 (en) | Browser-based development tools and methods for developing the same | |
| CN112540991B (en) | System logic construction method based on data table relation | |
| EP2916276A1 (en) | System including a data repository and a data importing component | |
| US11468389B2 (en) | Systems and methods for analytics, predictions, and reporting | |
| US20140317563A1 (en) | Generate field mapping | |
| US10891041B1 (en) | Data preparation user interface for aggregate comparison of datasets at different nodes in a process flow | |
| US10565560B2 (en) | Alternative people charting for organizational charts | |
| US20160224534A1 (en) | Grid-based user interface system | |
| JP2020017277A (en) | Web reporting design system for programming event operation, based on graphic interface | |
| US20100049734A1 (en) | Fast search views over business objects | |
| US11768591B2 (en) | Dynamic graphical containers | |
| CN117010198A (en) | Multi-user multi-view model modeling interaction method based on SysML | |
| CN101436309A (en) | Method and apparatus for modifying formula operator | |
| US20140169217A1 (en) | System and method for displaying network data | |
| CN115810064A (en) | Map making and publishing platform construction method based on open source GIS technology | |
| CN105653750A (en) | Realization method for assembly layout in human computer interface 3D designing system | |
| CN110851521B (en) | Method, device and storage medium for data visualization | |
| Krahl | An introduction to Extend [hierarchical simulation modelling tool] | |
| CN112527870B (en) | Electronic report generation method, device, electronic equipment and storage medium | |
| US11522820B2 (en) | Conversational natural language interfaces for data analysis | |
| US20200258275A1 (en) | Bar chart optimization |
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 |