CN106126569B

CN106126569B - A kind of rapid data method of servicing and system

Info

Publication number: CN106126569B
Application number: CN201610436679.8A
Authority: CN
Inventors: 王刚; 顾翔宇; 袁毅; 谢慧; 孙振兴
Original assignee: Nanjing Le Yunle Technology Co Ltd
Current assignee: Wang Gang
Priority date: 2016-06-17
Filing date: 2016-06-17
Publication date: 2018-06-12
Anticipated expiration: 2036-06-17
Also published as: CN106126569A

Abstract

The present invention relates to a kind of rapid data method of servicing and systems, metadata is configured for business object in this method, so as to when the page is shown, backstage parses metadata, obtain specific business datum, and the data of backstage parsing are illustrated in by page presentation resolving on the page by back page, foreground.The present invention can quickly build data query and safeguard the page by way of page configuration, and can be inquired and be safeguarded with what fraction limited, have good maintainable and scalability.

Description

Rapid data service method and system

[ technical field ] A method for producing a semiconductor device

The invention belongs to the field of computers and databases, and particularly relates to a quick data service method and system based on metadata

[ background of the invention ]

In the existing data management field, functions such as data maintenance, process approval, complex data calculation and the like are generally required to be provided. Among them, data maintenance work accounts for a large part of the scale. In addition, in the later data maintenance process, due to the change of the requirement, the requirements of field increase and decrease, display change, new data source maintenance and the like are frequently generated. Especially in the industry with relatively unstable service, the situation is common, which results in poor system expandability and difficult maintenance.

In the prior art, there are two solutions to the above problem: the first method is to reserve a plurality of fields as spare fields in the construction process of the data system, but the number of the reserved fields used by the processing method is limited, so that the method cannot cope with large-batch field changes, and the data redundancy condition exists, so that the resources are wasted, and the meaning display of the reserved fields in the use process is not intuitive. Secondly, the data system is customized again according to new requirements, the method is used in most cases at present, but the data system which does not enter the maintenance period is relatively simple to customize, and for the system which already enters the maintenance period, the customization brings the problems of difficult actual operation, long period, influence on the stability of the original system and the like; if the system is newly developed, a main system can be formed by a plurality of customizations, and a plurality of auxiliary systems share one service library, thereby greatly increasing the difficulty of system maintenance.

In a word, the solutions in the prior art have problems of data redundancy and unclear meaning of reserved fields, or problems of poor subsequent expansibility and difficult maintenance. Therefore, a new solution for data management is needed.

[ summary of the invention ]

In order to solve the above problems in the prior art, the present invention provides a fast data service method and system.

The technical scheme adopted by the invention is as follows:

a fast data service method, the method comprising the steps of:

1) defining each business object in the data service system by using the metadata, wherein the business object comprises metadata information and data detail metadata information of a table of the business object;

2) when a page request sent by a user is received, acquiring a service object id of a request operation and user group information of the user from the page request;

3) acquiring functions and filtering conditions provided by corresponding service objects according to the service object ids;

4) acquiring the functions and filtering conditions of the user group according to the user group information;

5) combining the results obtained in steps 3 and 4, thereby obtaining functions and filtering conditions available for the user;

6) acquiring data detail metadata information corresponding to the business object;

7) analyzing default values, selection ranges, page query conditions and sequencing of all the fields according to the data detail metadata information;

8) and 5-7, constructing a data query statement according to the result obtained in the step 5-7, and executing data query in a corresponding database so as to obtain the data corresponding to the business object.

9) And analyzing and generating a form, a button and a query page according to the metadata information of the business object and the result and the data obtained in the step 5-8.

Preferably, the method also comprises the steps of establishing a permission system through menu management, role management, user group management and data permission management; wherein,

the menu management comprises a service group, a specific service and a module three-level menu, wherein a specific service object can be configured in the module, and configured metadata is associated, so that a menu tree is formed, and a role individual menu tree can be constructed on the basis of the menu tree;

the role management can distribute roles with different authorities to different users, and the roles can be customized;

the user group management comprises two modes of a static group and a dynamic group, wherein the static group adds a system user to the user group through an adding method provided by a system, and the dynamic group dynamically defines the user from the system user and adds the user to the user group in a mode of configuring query conditions;

the data authority management is to associate roles with data authorities, the data authorities include authority of a table and field authorities, the authority of the table includes addition, deletion, modification, inquiry and row filtering authority of the table, and the field authorities include whether access authority exists on fields of the table.

Preferably, the parsing and generating the table includes adding the metadata of each column of the table to an object array of metadata one by one, where one field corresponds to one object, and generating the table based on the object array and the acquired display data.

Preferably, the parsing to generate the form includes the following steps:

a) opening a dialog box of a form page and generating an empty form;

b) for each field of the form, generating a corresponding page control according to the display style of the field;

c) converting definitions related to the pages in the metadata into page elements;

d) and acquiring a selection range, namely for the field with the selection range, loading the corresponding selection range according to the selection range index.

e) And loading the triggering event of the linkage between the fields.

f) And acquiring default values of all the fields and filling the page.

The invention also provides a rapid data service system, which comprises:

the metadata configuration module is used for defining each business object in the data service system by using metadata, and comprises metadata information and data detail metadata information of a table of the business object;

the metadata analysis module is used for acquiring a service object id of a request operation and user group information of a user from a page request when the page request sent by the user is received; acquiring functions and filtering conditions provided by corresponding service objects according to the service object ids; acquiring the functions and filtering conditions of the user group according to the user group information; combining the obtained results to obtain the functions and filtering conditions available for the user; analyzing default values, selection ranges, page query conditions and sequencing of all the fields according to the data detail metadata information; and constructing a data query statement, and executing data query in a corresponding database so as to acquire data corresponding to the business object.

And the page display analysis module is used for analyzing and generating a table, a form, a button and a query page according to the metadata information of the service object and the result and the data obtained by the metadata analysis module.

Preferably, the system further comprises a rights management module including a menu management module, a role management module, a user group management module, and a data rights management module, wherein,

the menu management module is used for managing a service group, a specific service and a module three-level menu, a specific service object can be configured in the module, and the configured metadata is associated, so that a menu tree is formed, and a role individual menu tree can be constructed on the basis of the menu tree;

the role management module can distribute roles with different authorities to different users, and the roles can be customized;

the user group management module comprises two modes of a static group and a dynamic group, wherein the static group adds a system user to a user group through an adding method provided by a system, and the dynamic group dynamically defines the user from the system user and adds the user to the user group in a mode of configuring query conditions;

the data authority management module is used for associating roles with data authorities, the data authorities comprise authority of a table and field authorities, the authority of the table comprises addition, deletion, modification, inquiry and row filtering authority of the table, and the field authorities comprise whether access authority exists on fields of the table.

The beneficial effects of the invention include: through the page configuration mode, the data query and maintenance page can be quickly constructed, and the query and maintenance can be carried out in a permission-based mode. The configuration is carried out on the page, so that the method has good maintainability, and when a certain data field needs to be adjusted, the data field can be modified through the configuration and takes effect immediately, thereby solving the problem of difficult expansion. Meanwhile, all the data query and maintenance pages share one analysis page, and after the analysis page is adjusted, all the data query and maintenance pages are changed correspondingly, so that convenience is brought to system maintenance.

[ description of the drawings ]

The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, and are not to be considered limiting of the invention, in which:

FIG. 1 is a metadata parsing process of the present invention;

FIG. 2 is a rights model relationship diagram of the present invention;

FIG. 3 is a diagram of the overall logical framework of the system of the present invention;

FIG. 4 is a diagram of a student personal data viewing and maintenance platform in relation to other business systems;

fig. 5 is a block diagram of a student personal data viewing and maintenance platform module.

[ detailed description ] embodiments

The present invention will now be described in detail with reference to the drawings and specific embodiments, wherein the exemplary embodiments and descriptions are provided only for the purpose of illustrating the present invention and are not to be construed as limiting the present invention.

In the rapid construction process of the data service system, the metadata is used as the basis of the data service, and the data object is defined by configuring the metadata.

The following is a specific embodiment of a table that uses metadata to define business objects:

name of field	Means of
		Name of table English	Table names accessible in a database
Name of table display	The name of the business object displayed on the interface
		Whether or not there is an add button	Whether the table provides an add function
Whether or not there is a delete button	Whether the table provides a delete function
		Whether there is a modification button	Whether the table provides a modify function
Whether or not to use	Whether the table continues to be used
		Filtration conditions	The table filters the data range operated on in subsequent processes

For data detail, the following is a specific embodiment of data detail using metadata to define a field of a business object:

through the metadata in the data detail table, the invention makes a detailed definition for a field, wherein:

english field: it needs to be consistent with the field names in the database.

Whether to display: if not, the field is not displayed on the page.

Default values are as follows: the default value is defined by adopting a binary group mode, namely < type, value >, wherein the type comprises a fixed value and a variable; a fixed value indicates that its value is a fixed character, such as a line of description or a line in a selection box; the variable indicates that the value is dynamically acquired, the system provides a common variable expression mode, and the system can be dynamically expanded, for example, the variable curdata indicates the current date, the variable uid indicates the random ID, the variable curuser indicates the ID of the login user, and the like.

Display style: the interface plug-in element of the invention is used for definition, if the text is represented by textbox, the drop-down box is represented by combbox, and the parsing is carried out according to the textbox and the combbox.

Linkage fields, linkage modes and linkage conditions are used for expressing the association relation among fields on a form page, the linkage fields need fields inside a business object, the linkage modes comprise style and select modes, style represents style linkage, for example, the linkage fields are set to be read only, select represents selection frame linkage, the linkage conditions represent the association relation of contents in two pull-down frames, and when one field needs to be linked with a plurality of fields, all three fields related to linkage of the field can be represented by arrays.

Whether to provide a query: indicating whether the field provides a query function. When at least one field in one business object provides the query function, the general query function is provided on the displayed page. If none of the fields provide a query, no query function is provided; .

Whether the primary key: the method is used for defining whether the field is a primary key or not, a plurality of fields in the same business object can be all primary keys, so that a joint primary key is formed, and when one business object does not have a primary key, the provided add-delete-modify function can be prompted.

Ascending/descending order: whether the field participates in the page table sorting is defined, and if the field is sorted, which sorting method is used, ascending and descending are optional.

Selecting a range: the pull-down content in the field pull-down box is defined by using the form of select, and the value of the pull-down content is fixed to two fields, id (i.e. the identifier of the content) and value (the specific value of the content).

The above embodiment completes the configuration of the metadata through two tables, and when the business object needs to be increased or decreased, the business object can be increased or decreased in a manner of configuring the metadata for the business object.

On the basis of the configured metadata, the data service of the invention can analyze the metadata, thereby acquiring and displaying the corresponding business object. Specifically, after the metadata configuration is completed, when a certain user sends a display request of a page, specific service data needs to be acquired on the basis of analyzing the metadata, and a corresponding page is returned. The basic process comprises the following steps:

1) acquiring the id of a service object requesting operation, the number of displayed pages and the current page number from a page request, and user group information of a user sending the request;

2) analyzing the service object according to the service object id;

3) analyzing the data detail of the service object according to the service object id;

4) and constructing a data query statement according to the analysis result, and executing data query in a corresponding database so as to acquire data corresponding to the business object.

Referring to fig. 1, a specific parsing process is shown:

wherein the step 2 comprises:

2.1) acquiring functions and filtering conditions provided by a business object, specifically, acquiring an integral line filtering condition, a table name or a view name of the business object, a button name provided by the business object and a button method from a metadata configuration table corresponding to the business object according to a business object id;

2.2) acquiring the function and the filtering condition of the role to the service object, specifically, acquiring the row filtering condition of the user group, the button name and the corresponding button method according to the user group information of the role.

2.3) combining the results obtained in the steps 2.1 and 2.2, thereby obtaining the final line filtering condition, the button name and the button method which are available for the user.

The step 3 includes:

3.1) obtaining the detail configuration information. Specifically, data detail metadata information corresponding to the business object is obtained.

And 3.2) analyzing the default value of each field according to the detailed configuration information, directly taking out the value if the default value is a fixed value, and calling a corresponding method to obtain the specific value of the variable and assigning the specific value to the default value field if the default value is a variable.

3.3) analyzing the selection range of each field according to the detail configuration information. For the field with the selection range, after the select statement of the selection range is obtained, the statement is put into an array, and the position of the array is recorded. And after all the fields are analyzed, executing select statements in the array in batch to obtain the selection range of each field. The subsequent page can obtain the pull-down selection content according to the array position.

And 3.4) analyzing the page query condition according to the detail configuration information. Specifically, if a field provides a query condition, the field English name and the field display name of the field are obtained, and a two-dimensional array of the query condition is formed.

And 3.5) analyzing the sorting according to the detail configuration information. Specifically, if there is a field to provide sorting, a sorting criterion is formed according to the field name and the sorting rule.

The specific steps of the step 4 include:

4.1) forming a query statement according to the list or view name, the line filtering condition and the sequencing basis obtained by analysis, the page number required by the page and the line number displayed on each page, and taking out data after executing the query statement;

and 4.2) acquiring data corresponding to the data items in the table one by one according to the data detail acquired by analysis, and constructing and returning a page according to the data.

Through the analysis of the metadata, the background can transmit the following data to the foreground, and the foreground constructs a page based on the following data:

1) the button information comprises button nouns, button icons and corresponding methods of the buttons.

2) Data detail information including field english name, display name, whether to display, display style, rank, selection range, whether may be empty, etc.

3) An array of available query conditions, each element in the array including the field english name and display name providing the query.

4) Page count and number of display lines per page.

5) And the data information comprises specific data corresponding to each field, namely the data information displayed on the page.

6) And selecting a range, wherein the selection range comprises a plurality of indexes, each index corresponds to an array of fields with the selection range, and the array is the array obtained in the step 3.3.

After the analysis process is completed, the foreground displays the analysis by using the page according to the analysis result, and the page display analysis process mainly displays the data converted by the background on the page in an analysis mode. One set of page layout corresponds to one page, and all the data maintenance pages access the same page. The page contains the resolution function of JS. The layout of data maintenance mainly comprises a form, a button and a query page, and is sequentially generated in the page display and analysis process, and the specific steps are as follows:

1) and analyzing to generate a table.

Adding the metadata of each column generated by the background one by one into an object array of the metadata, wherein one field corresponds to one object; for the field with the pull-down selection, the object has the display format attribute which is the name of the relevant processing function, the processing function mainly finds the selection range through the pull-down selection range index of the field, and then the display value is obtained according to the value of the selection range.

And calling a table construction interface based on the processed object array and the display data acquired from the background and the background to generate a table. In addition, a corresponding construction interface is called according to the current page, the display line number of each page and the total line number obtained by background analysis, a table page turning function is generated, and a trigger event function of page change is loaded.

2) Analysis generation button

And calling a button construction interface based on the button name, the button icon and the button corresponding method acquired by the background, and generating the button.

3) Parsing to generate query pages

The query page mainly comprises three parts, namely a query field, a query relation and finally query content. The query fields are populated from a background generated list of available queries, with the default being "unlimited", i.e., all field queries. The query relationship is fixed, and comprises, equal to, greater than, less than, and uses comprise by default; the query content is a text box.

The query comprises two query modes, wherein one mode is that when the query field is unlimited, the query content is a whole, and all the fields providing the query are retrieved according to the query content; the other is that when the query field is a fixed field, the query content can be separated by a space, and a plurality of query contents are used for retrieval at the same time.

4) Parsing to generate a form

The form is displayed mainly according to the analysis of the background on the metadata, and the page layout can adopt a fixed two-column mode. Comprises the following steps:

4.1) opening a dialog box of the form page and generating an empty form;

4.2) for each field, generating a corresponding page control according to the display style of the field;

4.3) converting definitions in the metadata about page relevance to page elements, such as: if yes, setting the corresponding page element to be readonly true.

4.4) obtaining the selection range, namely for the selection range, loading the corresponding selection range according to the selection range index.

4.5) loading the linkage trigger event.

4.6) obtaining the default value of each field and filling the page.

5) Push button function

For the buttons, the invention mainly provides three buttons of adding, deleting and modifying on the page, and the corresponding operations of the three buttons are consistent with the common operation method, namely, the number is obtained from the page and the data operation is carried out through the main key.

In the analysis process, the user group information of the user role is analyzed, so that the authority of each user needs to be distributed and managed actually. The authority distribution management is mainly to distribute configured accessible pages according to an authority system so as to facilitate multiple persons to use data with different authorities. Referring to fig. 2, the rights hierarchy is divided into menus, roles, user groups, and data rights for control.

And (3) menu management:

the system of the present invention provides three levels of menus. The first level menu is a service group, i.e. a classification of a plurality of similar services, the second level menu is a specific service, i.e. corresponding to each service, and the third level menu is a module, i.e. a specific module under each service. And configuring a specifically used business object in the module, and associating the configured metadata. Thus, a menu tree is formed. And then, dragging the defined role on the menu tree of the whole system to form a personalized menu tree of the role for displaying on a corresponding page.

And (3) role management:

the role management is the core of the authority management, and the roles are not well customized by the system but can be customized, so that roles with different authorities can be allocated to different user groups. And realizing authority distribution by associating roles with menus, user groups and data authorities.

User group management:

two modes of static group and dynamic group are supported in user group management. Static groups are added from a system user through an adding method provided by the system; the dynamic group is a dynamic delineation of users from system users by means of configuring query conditions. The user group implements the authority control through the association with the role.

Data authority management:

data rights management is the association of roles with data rights, which contain the rights and field rights of a table. Wherein the permissions of a table include add, delete, modify, query, and line filter permissions for the table, and the field permissions include whether there is access to a field of the table. After setting, the method plays a role in the metadata analysis process. Forming different roles to see different data depending on the rights.

In the system processing process, after a user logs in, the user group is selected at first, and after the user group is selected, menus and data authorities corresponding to roles which the user may contain can be merged and displayed.

Referring to fig. 3, which is a diagram of the overall logical framework of the system incorporating the permissions, as shown in the figure, the permission mode of the system of the present invention is relatively fixed, but specific data is determined according to the service, for example, how many menus are on the menu tree. Based on the above logical framework, the fast data service system of the present invention can be constructed by the following 5 steps,

1) determining the service data, which can be an existing table or an attempt in a database, or a newly created or imported table;

2) defining metadata of the service data;

3) creating or selecting a role for a user;

4) creating or selecting a user group and a menu for a user;

5) and configuring the relation of roles to user groups, menus and data permissions.

The specific implementation case is as follows: student personal data viewing and maintaining platform

In colleges and universities, generally, relevant data of students are stored in a plurality of relevant business systems, a unified viewing place is lacked, meanwhile, the plurality of business systems are used for collecting personal information of the students, the students need to be maintained in the plurality of business systems, and a large amount of data are inconsistent. In order to solve the problem, a student personal data viewing and maintaining platform needs to be built, meanwhile, services in a service system are continuously increased, and the content of student personal information collection is also continuously adjusted, so that the requirements on maintainability and expandability are brought to the platform construction.

By using the method and the system for establishing the personal data maintenance platform for the students, the requirements of maintainability and expandability in the platform construction process are well met. Specifically, the data is divided into two types, one type is data which needs to be filled by students and then is shared by other service systems in a data sharing mode; one type is data which is acquired from different business systems and is uniformly viewed by students.

The relational graph of the platform and other business systems is shown in fig. 4, wherein the platform and other business systems exchange data through a data sharing tool, the exchange is bidirectional, taking a student system as an example, the prize evaluation and optimization data generated by the student system are synchronized into the platform through the sharing tool, the platform is internally provided with tables with the same table structure, the synchronized data are stored, and the data are only used for students to inquire; meanwhile, the natural information of the students, such as the heights, the weights, the contact calls and the like of the students, is stored in the platform, and the information is exchanged into the student system through the data sharing platform.

Inside the platform, a module structure diagram is shown in fig. 5, wherein the database is divided into three parts, namely, metadata configuration information of the service data, permission configuration data, and service data.

The modules are divided into four types, one is metadata configuration management, and the metadata configuration management comprises data object configuration and data object detail configuration; the second type is authority configuration management, which mainly comprises user management, user group management, role management, data authority management and menu management; the third type is a data viewing type module which is divided into student data viewing, educational administration data viewing, all-purpose card data viewing and book borrowing viewing according to data classification, the module number is generated according to metadata and authority configuration data, and the module only has a query part and is not provided with a deleting button; the fourth category is the information filling category, which mainly includes personal basic information filling, outside school prize winning information filling, contact information filling, employment intention filling and the like. The personal basic information can only be modified but can not be added or deleted in the filling process, the information winning prize can be added, deleted, checked and the data of the contact way are mobile phones, dormitories, qq and mailboxes which are defaulted by each person, wherein the personal basic information can only be modified except the dormitories, and the dormitories are read-only information. The employment intention is to provide graduate with the choice of the employment intention, and most information belongs to the selection box with the drop-down box.

In the data viewing and maintaining page, the data authority configuration of students needs additional description, that is, each student can only view and maintain own information, and the implementation mode is realized by defining line filtering conditions on the data authority of roles. In the line filtering condition, a predefined variable (login ID) is used, and in the metadata analysis process, the data of the student is only taken out by replacing the variable.

The above description is only a preferred embodiment of the present invention, and all equivalent changes or modifications of the structure, characteristics and principles described in the present invention are included in the scope of the present invention.

Claims

1. A fast data service method, characterized in that the method comprises the steps of:

8) constructing a data query statement according to the result obtained in the step 5-7, and executing data query in a corresponding database so as to obtain data corresponding to the business object;

2. The method of claim 1, further comprising establishing a rights hierarchy through menu management, role management, user group management, and data rights management; wherein,

the role management can allocate roles with different authorities to different user groups, and the roles can be customized;

3. The method according to any one of claims 1-2, wherein parsing to generate the table comprises adding the metadata of each column of the table one by one to an object array of metadata, one field corresponding to one object, and generating the table based on the object array and the acquired display data.

4. The method according to any of claims 1-2, wherein parsing the generated form comprises the steps of:

a) opening a dialog box of a form page and generating an empty form;

d) acquiring a selection range, namely for the fields with the selection range, loading the corresponding selection range according to the selection range index;

e) loading a triggering event of linkage between fields;

f) and acquiring default values of all the fields and filling the page.

5. A fast data serving system, comprising:

the metadata analysis module is used for acquiring a service object id of a request operation and user group information of a user from a page request when the page request sent by the user is received; acquiring functions and filtering conditions provided by corresponding service objects according to the service object ids; acquiring the functions and filtering conditions of the user group according to the user group information; combining the obtained results to obtain the functions and filtering conditions available for the user; analyzing default values, selection ranges, page query conditions and sequencing of all the fields according to the data detail metadata information; constructing a data query statement, and executing data query in a corresponding database so as to acquire data corresponding to the business object;

6. The fast data service system of claim 5, further comprising a rights management module including a menu management module, a role management module, a user group management module, and a data rights management module, wherein,

the role management module can allocate roles with different authorities to different user groups, and the roles can be customized;

7. The fast data service system according to any one of claims 5 to 6, wherein the parsing to generate the table comprises adding the metadata of each column of the table to an object array of metadata one by one, one field corresponding to one object, and generating the table based on the object data and the acquired display data.

8. The fast data service system of any one of claims 5-6, wherein parsing the generated form comprises:

a) opening a dialog box of a form page and generating an empty form;

e) loading a triggering event of linkage between fields;

f) and acquiring default values of all the fields and filling the page.