CN115544006B

CN115544006B - Method for constructing general database data operation model

Info

Publication number: CN115544006B
Application number: CN202211162803.8A
Authority: CN
Inventors: 杜太国
Original assignee: Beijing Shangli Technology And Culture Co ltd
Current assignee: Beijing Shangli Technology And Culture Co ltd
Priority date: 2022-09-23
Filing date: 2022-09-23
Publication date: 2023-07-04
Anticipated expiration: 2042-09-23
Also published as: CN115544006A

Abstract

The invention discloses a method for constructing a general database data operation model, which relates to the technical field of database data operation.

Description

Method for constructing general database data operation model

Technical Field

The invention relates to the technical field of database data operation, in particular to a method for constructing a general database data operation model.

Background

With the gradual development of networks, users have an increasing demand for network services and have a diversified trend. And most business processes will ultimately be manifested in the manipulation of data. The existing software development process develops what is needed according to business in a long period of time, even if a plurality of similar data operations are frequently encountered, the existing code is carried and pruned at most. And many functions of many systems are even more than 9, and finally, the user can realize the operation on the database data through front-end selection or input. These operations are mainly statistics, reports, inventory, additions, modifications, deletions, empties, imports, exports, etc. While the core SQL form of each data operation is generally the same, due to the variety of differences in business requirements and data structures, much time is wasted on development and maintenance for user needs, and is continually modified or redesigned to accommodate new business developments. In order to develop the result in half effort in long term, the user can find the result unchanged in the change and repeatedly train the user to construct a general data operation model by adopting proper dynamic variables.

Disclosure of Invention

In order to overcome the defects, the invention provides a method for constructing a general database data operation model, which integrates the operations of statistics, report forms, lists, addition, modification, deletion, emptying, importing and exporting nine cores into one functional page, realizes the inquiry and data maintenance of any structural table of a database through a front page, and also has the functions of creating/maintaining/empowering management of data operation items and using rules thereof.

A method for constructing a general database data operation model comprises the following steps:

step 1: the management module is used for creating, maintaining and weighting the data items by an administrator, and maintaining and weighting the usage rules of the data items according to the basic characteristics of the database table or the view structure, wherein the usage rules comprise, but are not limited to, field usage rules, data operation types and item association extensions;

step 2: when a user opens a page for the first time, a program automatically acquires items and using rules thereof according to authorization, operates and memorizes collection, performs on-line on-demand weighting on the items and the using rules thereof, automatically generates field list components and operation type options according to the rules, automatically initializes selection input according to the memory, and automatically configures collection components according to the collection;

step 3: when the user module switches the data operation types, the system reloads the applicable field list according to the types and confirms the usability, the user can perform custom setting row-column display on the field list, and the user selects or inputs the field list component; when the user selects to operate collection, the program automatically matches operation types, reloads field list components and initializes selection input according to collection;

step 4: after the user successfully executes the corresponding type of data operation, the user module outputs a data table or operation information, simultaneously automatically memorizes the operation input, simultaneously generates the operation log, and allows the user to custom name and collect the operation input

The user module is used for acquiring items and using rules thereof, and dynamically generating or loading a page component for a user to perform self-defining operation;

the management module is used for creating, maintaining and giving weight to data operation items and use rules thereof, and also comprises item management and rule management, wherein the item management is used for previewing/creating a table or view, creating the data operation items and initializing the use rules thereof and maintaining/giving weight to the operation items; the rule management is used for maintaining/giving rights to use rules, wherein the use rules comprise field rules, operation types and association extensions.

Preferably, the user module comprises an item permission area and a custom input area, wherein the item permission area is used for acquiring user permission items and adaptive rules and adaptive operation components thereof, and the custom input area is used for user to perform custom operation setting or input.

Preferably, the operation modes of the user in the project permit area include: statistics, report, inventory, add, modify, import, delete, empty.

Preferably, the modifying operation comprises single line modifying and line feeding, multiple line same value modifying, filtering same value modifying, file batch modifying and accessory uploading maintaining.

Preferably, the user module further comprises a memory collection area, and the memory collection area is used for collecting and maintaining or selecting and using collection for user-defined operation.

Preferably, the user module further comprises an accessory area for a user to view and upload the accessory for maintenance.

Preferably, the user module further comprises a list setting area, wherein the list setting area is used for a user to display and hide the fields and customize the field arrangement sequence according to the service requirement, and the number of the display row and column groups and the width and the height are set according to the display resolution.

Preferably, the step 1 further includes the steps of:

step 11: if yes, step 12 is entered, if no, a new table or view is created by using data in the database or a new table is created by an external CSV file;

step 12: whether the database table or view associated with the data item changes structure, if so, entering step 14 if the item has been created, otherwise entering step 13;

step 13: creating a data operation item and initializing field rule parameters;

step 14: maintenance/weighting of data manipulation items and usage rules thereof.

The beneficial effects of the invention are as follows:

the invention integrates nine core operations of data statistics, report forms, lists, addition, modification, deletion, emptying, importing and exporting into one functional page, realizes the inquiry and data maintenance of any structural table of the database through the front page, has the powerful functions of data item rule maintenance and weighting management, simultaneously extremely strengthens the universality and convenience of the model, basically meets the requirement of most data inquiry maintenance in various industries, and provides firm guarantee for wide popularization and application.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below. Like elements or portions are generally identified by like reference numerals throughout the several figures. In the drawings, elements or portions thereof are not necessarily drawn to scale.

FIG. 1 is a schematic diagram of a user module and a management module in a method for constructing a general database data operation model according to the present invention;

FIG. 2 is a step diagram of a method for constructing a general database data operation model provided by the invention;

FIG. 3 is a diagram showing steps of management module project management/rule management in a method for constructing a general database data operation model according to the present invention;

FIG. 4 is a diagram of the core operation steps of a user module of a method for constructing a general database data operation model according to the present invention;

fig. 5 is a schematic diagram of a core function of a user module of a method for constructing a general database data operation model according to the present invention.

Fig. 6 is a schematic diagram of a front end interface of a user module of a method for constructing a general database data operation model according to the present invention.

Fig. 7 is a schematic diagram of a user module front end interface field list setting area of a general database data operation model construction method provided by the present invention.

Detailed Description

Embodiments of the technical scheme of the present invention will be described in detail below with reference to the accompanying drawings. The following examples are only for more clearly illustrating the technical aspects of the present invention, and thus are merely examples, and are not intended to limit the scope of the present invention.

It is noted that unless otherwise indicated, technical or scientific terms used herein should be given the ordinary meaning as understood by one of ordinary skill in the art to which this invention pertains.

As shown in fig. 1 and 2, a method for constructing a general database data operation model includes the following steps:

As shown in fig. 5, more specifically, the user module includes an item permission area, and a custom input area, where the item permission area is used to obtain a user permission item and an adapted rule and an adapted operation component, and the custom input area is used for a user to perform custom operation setting or input.

More specifically, the operation modes of the user in the project permit area include: statistics, report, inventory, add, modify, import, delete, empty.

The project permit area is an area a shown in fig. 6, and the operation modes of the area a include: licensing items, item license usage rules, rule license operation modes and field lists, field list license ordering and line display settings.

The B area is a custom selection input area: the list field component availability corresponds to an operation mode, field checkouts may be grouped or aggregated by column in statistics and reporting mode, query results may include the column in manifest mode, the column may be modified in modification mode, text box entry and drop down box selection may be filtered in any mode, and the column values may be updated by entry in modification mode. When performing statistical operations: the B area list is checked and grouped or aggregated, and the total list number is counted without checking; report operation: the B field list only shows the grouping aggregate and filter fields, other aggregate value type fields are hidden but participate in the aggregate operation. The preview data is not checked. The method is simpler and more convenient than a statistical mode; inventory operation: and checking the field query list of the area B, and not checking 2 kilolines of preview full field data. If the field list has desensitization field, the desensitization switch of C area is visible, and the on or off is controlled by the authority of work number desensitization. The region D is an output region: outputting a table or information or exception of the execution result; if the field supports the accessories, the 'accessories' button in the area C can be seen to be clicked to open the area F of the assembly, and then the leftmost button in the area D is clicked to 'select' whether all accessories in the area E exist or not can be seen, if the accessories are available for downloading by clicking; the adding operation comprises the following steps: selecting the region B, adding a data field (light yellow or green background color) and inputting a value, if the primary key value is null, obtaining by a back-end sequence by default, wherein the input value of the light green background field cannot be null, and automatically processing an operation stamp (the number and time of an operator) by a model; and (3) importing operation: the "File" button in zone A selects CSV file with the same name as the project, and the additional import is completed, and zone D does not display the table back but prompts how many lines to import. The CSV file fields are not limited in sequence, more fields can be imported but are not necessarily required, the field names can be used for database table fields, aliases appointed by the items and even mixed, and the model can strictly verify and automatically process operation marks; and (3) emptying operation: directly executing all data of the empty table; deletion operation: the D area selects or selects the row in the table or the B area filters the input # and executes the deletion.

More specifically, the modifying operation comprises single line modifying and line feeding, multiple line same value modifying, filtering same value modifying, file batch modifying and accessory uploading maintaining.

Single line modification: selecting the data row of the D area (red), checking the column to be modified of the B area, inputting a value, and displaying the row back on the data table of the D area after the data is successfully executed, wherein the method is suitable for modifying data at low frequency because the front table is covered.

Single line modification line feed: and (3) selecting a C area line feed switch, selecting a D area data line, selecting a B area modified column, inputting a value, and after the execution is successful, rewriting the corresponding column value of the D area data table, and simultaneously automatically switching to the next line (red, with a prompt at the bottom) and refreshing the B area input frame data. The D area current table is kept and automatically lines are fed, so that the method is suitable for line-by-line field abnormal value high-frequency modification data.

Multiple rows of same value modification: and checking a plurality of rows in the D area table, checking a B area modified column, inputting a value, and displaying the modified rows back in the D area data table after the D area data table is successfully executed, wherein the front table is covered. So that it is suitable for multiple lines of same-value low-frequency modified data.

Screening the same-value modification: the B area input box sets the screening condition, selects the modification field and inputs the value of the number of the columns which are matched with the screening, and the D area is not displayed back but has a prompt. The method is suitable for the equivalent modification of large data volume.

File batch modification: the A area 'file' button selects CSV files with the same name as the project, checks the B area modification field, executes column values of the modification main key value peer-to-peer record, and the D area does not display the table back but has a prompting file number of columns and rows and data modification number of columns. Wherein the CSV file field order is not limited, and there may be more but not necessarily fewer primary keys and modified fields.

And (3) accessory maintenance: if the project table has field permission maintenance accessories (picture document compression packages and the like), an accessory button in a C area is visible, an accessory component F area is opened by clicking, and a field list branch, a submission, an addition and deletion improvement check list of the permission accessories can be seen. When the D area list is selected by clicking, whether accessories exist on the F area branch can be seen, and the addition, deletion and correction of the accessories are completed by selecting a single option.

More specifically, the user module further comprises a memory collection area, and the memory collection area is used for collecting, maintaining or selecting and using collection for user-defined operation.

The user module is shown in fig. 6 and 7 and comprises an a-G area. The user can realize 9 kinds of data operations at most through the user module, and a plurality of convenient aids are simultaneously arranged in the user module, so that the user operation is ensured to be more free, individual and quick, wherein the memory collection area is an E area shown in fig. 6.

As shown in fig. 4 and 6, the user role permission item and the adaptation rule thereof (rule role adaptation priority rule is from small to large) and the user collection setting are automatically acquired, operation mode options (8 at most) are generated in the area a, the adapted field list component (checkbox, text box and drop-down box) is automatically generated in the area B, the rows and columns are displayed according to the user custom setting, the collection options are loaded in the area E, the attachment list is loaded in the area F, and the execution area is the area C: the method comprises the steps of collecting, inquiring, maintaining (including accessories), expanding and exporting, wherein the availability of a desensitizing switch and an accessory button is automatically confirmed in a C area, an E area and an F area are assemblies belonging to the C area, and the C area five-star icon button and the accessory button are used for switching respectively; the user selects E area collection item or user-defined selection input to complete the required data query or maintenance operation.

More specifically, the user module further comprises an accessory area, and the accessory area is used for a user to check and upload and maintain the accessory.

The attachment zone is zone F shown in fig. 6.

More specifically, the user module further comprises a list setting area, wherein the list setting area is used for a user to display and hide the fields and customize the field arrangement sequence according to the service requirement, and the number of the display row and column groups and the width and the height are set according to the resolution of the display. The list setting area is located in a G area shown in fig. 7, and the G area is switched by a double arrow icon button on the right side of the A area.

Outputting the query data table or the operation information to a D area for display, wherein the D area is used for carrying out single click on the support ordering; after the operation is successful, the model automatically memorizes operation settings and inputs and generates an operation log; the user can maintain operation collection in E area according to need, up to 60 items are supported, sharing is supported, and setting is convenient for the user without personnel. The operation collection is used for storing user settings and inputs, and the operation collection is convenient and quick to reuse without setting every time.

As shown in fig. 3, more specifically, the step 1 further includes the following steps:

step 13: creating a data operation item and initializing field rule parameters;

The logic method for dynamically realizing various operations by the user module of the model focuses on the maintenance of the empowerment by using rules, wherein the using rules comprise field rule convention and table operation right (operation mode and association extension).

Field rule convention: the model aims at realizing operations such as adding, deleting, modifying, searching, guiding and the like of any table at the back end through the front end, so that the model can use any structural table only at the back end, the front end dynamically generates a matching component, and the key of coordination between the back end and the front end is table field parameter rule preparation. And determining a parameter table structure and appointing an identification rule by analyzing and integrating different points of various data operations. If the type column C indicates that the character type front end field is marked as a black character, and N indicates that the numerical value type front end field is marked as a blue character; d represents that the front end field of the date type is hooked as a red word; the rightmost column of the nickname identifies that the input value cannot be null when modifying the column; modification column 1 indicates that the field is a primary key, 2 indicates that the field is modifiable, 4 indicates that the field is an operation number, and 5 indicates that the field is an update timestamp; the import column selects the representation field to allow import; the valid column checkpointing indicates that the field permits use; desensitization is carried out when the desensitization checkpointed representation field is a sensitive data list query; fuzzy column checkpointing indicates that the field supports fuzzy screening; counting the allowable grouping of the column-hooked characters; the SUM column tick field allows SUM summation; the front end input control is a drop-down box if the option list has option input, otherwise, the front end input control is a text box;

table operation right: the model corresponds the operation right of the table, namely the operation mode and the association expansion to the use rule, and then configures different use rules to different roles or individuals, and as the rule establishes the table field use method, the operation mode and the association expansion, different users can execute different operations (add, delete, modify and guide) on different fields of the same table and even different data screening;

the model user module not only realizes the data operation core function, but also comprises a plurality of auxiliary methods so as to meet the more free, concise, individuation and shortcut requirements of users;

and (3) weight distribution adaption: the data operation items and rules are rapidly maintained, the users can be informed only when the users need to be on-line and have rights according to the needs, and the users basically and accurately adapt to little redundancy. Because the add-delete-modify-guide operation of the table may be entitled, the fields and data usage of the table may be entitled.

Operation memory and collection: the model can automatically memorize the selection and input operations of the user, and even the user can collect the operations, and the user does not need to repeatedly set the operations when using the book next time. This convenience is far beyond the design of any dedicated function page.

Custom field list: the user can select the own ordering mode, and can also customize the display, hiding, order adjustment and row of the list fields, wherein the hiding can shield the fields which are not needed by the user, the order adjustment supports multiple movements, the field battle team which the user wants can be rapidly completed, and the row setting can allocate the number and the row width of a single row field row and allocate the number and the row height of the display according to the user needs and the resolution of the display.

Automatic line feed modification line by line: and selecting one row in the table in the modification operation, checking the column to be modified and the input data value, and after the execution and the submission are successful, automatically switching the downlink by the model and refreshing the field list control data, so that the operation efficiency is greatly improved.

Screening modification and deletion: screening condition preview data is input and confirmed. In the modification mode, the field value of the screening data can be modified by selecting the field to be modified and inputting a "= modification value"; and in the deleting mode, the text box inputs "#" again, so that the screening data line can be deleted.

Bulk modification or import of the breadth of CSV file fields: the model supports CSV file batch data modification or import, wherein the field sequence of the CSV file is not limited, the number of the fields can be more but not less than required, and the field names can be database table field names, aliases specified by the model or even a mixture of the database table field names and the aliases.

Five data screening methods: screening is supported in any mode of operation. Single or multiple equivalent methods up to 300, comma separated interval method, matching or not fuzzy method, empty-empty method (=0 or=1), check repeat method (=2).

Extremely simple date screening: the date type red field input box is used for inputting 0 to indicate the current period, -1 to indicate the first 1 period and 1 to indicate the last 1 period, and then the date type single selection is corresponding to the date type single selection, for example, the inquiry of screening and counting the last days or months or years is very convenient, and the time is not needed to be moved after collection.

Text filling and numerical self-addition: rule management supports direct entry or checking of input boxes. Where the packet text box supports "=n" to fill N rows down, "=n+m" to fill N rows down and from the left principal value +m, "=n++ M" to fill N rows down and from the left principal value arithmetic difference M to accumulate. If the text does not contain a value, the default left head value is 0. This innovative approach can operate on any position and leftmost value in the text string.

Table field ordering: inquiring the front paging table display of the data result, supporting the background switching of the mouse moving line, supporting the first reverse order switching and sequencing of the single-click table head, synchronizing the data sequence numbers, and switching the paging sequence numbers to be consistent.

The model is developed and put into use in 5 months in 2020, and is improved hundreds of times by 9 months in 2022, only the logic layer codes reach 28.5 ten thousand, and 238 and 962 method events are judged, so that complicated problems possibly occur are predicted, coordinated, controlled and solved. The model can select the empowerment to realize 9 data operations, supports the uploading and downloading of accessories, simultaneously extremely strengthens the universality and the convenience of the model, basically meets the most data query and maintenance requirements of all industries, and provides firm guarantee for wide popularization and application.

Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some or all of the technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit of the invention, and are intended to be included within the scope of the appended claims and description.

Claims

1. A method for constructing a data operation model of a general database, comprising:

2. The method for constructing a general database data operation model according to claim 1, wherein the user module comprises an item permission area, a custom input area, the item permission area is used for obtaining user permission items and rules and operation components adapted thereto, and the custom input area is used for user to perform custom operation setting or input.

3. The method for constructing a general database data operation model according to claim 2, wherein the operation modes of the user in the project permit area include: statistics, report, inventory, add, modify, import, delete, empty.

4. A method of constructing a model of a generic database data operation according to claim 3, wherein the modifying operation comprises a single line modification, a multiple line same value modification, a filter same value modification, a file batch modification, and an attachment upload maintenance.

5. The method of claim 2, wherein the user module further comprises a memory collection area, and the memory collection area is used for user to collect and maintain or select to use the user-defined operation.

6. The method of claim 2, wherein the user module further comprises an attachment area for viewing and uploading maintenance of the attachment by a user.

7. The method of claim 2, wherein the user module further comprises a list setting area, the list setting area is used for a user to display and hide the fields and customize the field arrangement sequence according to the service requirement, and the number of display lines and columns and the width and the height are set according to the display resolution.

8. The method for constructing a model of operation of data in a general database according to claim 1, wherein said step 1 further comprises the steps of:

step 13: creating a data operation item and initializing field rule parameters;