[go: up one dir, main page]

CN107391612A - Field configuration method and device - Google Patents

Field configuration method and device Download PDF

Info

Publication number
CN107391612A
CN107391612A CN201710536340.XA CN201710536340A CN107391612A CN 107391612 A CN107391612 A CN 107391612A CN 201710536340 A CN201710536340 A CN 201710536340A CN 107391612 A CN107391612 A CN 107391612A
Authority
CN
China
Prior art keywords
field
metadata
configuration
data
user
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.)
Granted
Application number
CN201710536340.XA
Other languages
Chinese (zh)
Other versions
CN107391612B (en
Inventor
索寒生
刘超
潘东麟
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
PETRIFACTION CENTURY INFORMATION TECHNOLOGY Corp
Original Assignee
PETRIFACTION CENTURY INFORMATION TECHNOLOGY Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by PETRIFACTION CENTURY INFORMATION TECHNOLOGY Corp filed Critical PETRIFACTION CENTURY INFORMATION TECHNOLOGY Corp
Priority to CN201710536340.XA priority Critical patent/CN107391612B/en
Publication of CN107391612A publication Critical patent/CN107391612A/en
Application granted granted Critical
Publication of CN107391612B publication Critical patent/CN107391612B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/211Schema design and management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2291User-Defined Types; Storage management thereof

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention provides a kind of field configuration method and device, and method includes obtaining user's table mark from user's table metadata table;According to user's table identifier lookup field configuration metadata table, to obtain field configuration metadata set;The field configuration metadata set is selected, to obtain configuration field name;Newly-increased data are generated in field metadata table;The field metadata table is used to store the metadata of the configured field in the tables of data of user.Above-mentioned field configuration method and device, user's table by obtaining current data table identifies configures metadata table come Lookup Field, selected with the extended field to current data table, and the extended field relevant information chosen is added in field metadata table, so as to realize the field configuration of current data table, when the field of system loads current data table, loaded by field metadata table, you can loading extended field.

Description

Field configuration method and device
Technical field
The present invention relates to field of computer technology, more particularly to a kind of field configuration method and device.
Background technology
With the development of Internet technology and the maturation of application software, start to rise in 21 century a kind of innovates completely Software application mode software services (Software-as-a-Service, abbreviation SaaS).It is that one kind is carried by Internet For the pattern of software, manufacturer by application software unified plan on the server of oneself, client can according to oneself actual demand, Required application software service is ordered to manufacturer by internet, by the service ordered how much and the payment of time long short manufacturer branch With, and the service provided by internet acquisition manufacturer.For many small business, SaaS be sophistication most Good approach, it eliminates enterprise's purchase, builds and safeguards infrastructure and the needs of application program.
With deepening continuously for SaaS software applications, software systems are while customer service demand is met, also increasingly Face the challenge of user's differentiation requirement.In in general SaaS system developments, the characteristics of being limited to relevant database, business The attribute of data is typically what is solidified, and system can only meet the personalized requirement of user's Show Styles;Or pass through reserved field Mode, increase response to service attribute individual demand for system, the scope of personalized definition carried out using aforesaid way With it is limited in one's ability.Therefore, a kind of field configuration method is needed badly to realize the individual demand of user service data Show Styles.
The content of the invention
The present invention provides a kind of field configuration method and device, and sample is shown to solve user service data in the prior art The personalized definition of formula can not meet demand technical problem.
One aspect of the present invention provides a kind of field configuration method, including:
User's table mark is obtained from user's table metadata table, wherein, user's table metadata table is used for the number for storing user According to the metadata of table;
According to user's table identifier lookup field configuration metadata table, to obtain field configuration metadata set, wherein, field is matched somebody with somebody Put the metadata that metadata table is used to store the extended field in the tables of data of user;Field configuration metadata set includes at least one Individual field configuration metadata item, field configuration metadata item include configuration field name;
Field configuration metadata set is selected, to obtain configuration field name;
Newly-increased data are generated in field metadata table, increasing data newly includes user's table mark and configuration field name;Field Metadata table is used to store the metadata of the configured field in the tables of data of user.
Further, after user's table mark is obtained from user's table metadata table, in addition to:
According to user's table identifier lookup field metadata table, to obtain field metadata set, wherein, field metadata set bag Include at least one field metadata item;Field metadata item includes selected state;
Field metadata set is selected, and the selected state of selected field metadata item is labeled as having selected In, by the selected state of not selected field metadata item labeled as unselected;Selected state is used to sentence in load field The disconnected field whether loaded corresponding to corresponding field metadata item.
Further, according to user's table identifier lookup field configuration metadata table, with obtain field configuration metadata set it Afterwards, in addition to:
Field configuration metadata set is selected, to obtain field data to be deleted, field data to be deleted includes first and expanded Open up field identification;
Searched according to the first extended field mark in configuration data table, to obtain the first lookup result, wherein, configure number It is used for the data message for storing user's extended field according to table;
Judge whether include the data item in configuration data table in the first lookup result;If so, then by lookup result from Put in tables of data and delete, and simultaneously delete field data to be deleted from field configuration metadata set.
Further, in addition to:If not including the data item in the configuration data table in the first lookup result, will treat Field data is deleted to delete from the field configuration metadata set.
Further, according to user's table identifier lookup field configuration metadata table, with obtain field configuration metadata set it Afterwards, in addition to:
Field configuration metadata set is selected, to obtain field data to be changed, field data to be changed includes the Two extended fields identify and can change information;
Searched according to the second extended field mark in configuration data table, to obtain the second lookup result, wherein, configure number It is used for the data message for storing user's extended field according to table;
Judge whether include the data item in configuration data table in the second lookup result;If it is not, then to field configuration member number It is modified according to the information of changing of field data to be changed in table.
Another aspect of the present invention provides a kind of field configuration device, including:
User's table identifier acquisition module, for obtaining user's table mark from user's table metadata table, wherein, user's list cell Tables of data is used for the metadata for storing the tables of data of user;
Field configuration metadata set acquisition module, for according to user's table identifier lookup field configuration metadata table, to obtain Field configuration metadata set is taken, wherein, field configuration metadata table is used to store the member of the extended field in the tables of data of user Data;Field configuration metadata set includes at least one field configuration metadata item, and field configuration metadata item includes configuration words Section name;
First choice module, for selecting field configuration metadata set, to obtain configuration field name;
Newly-increased data generation module, for generating newly-increased data in field metadata table, newly-increased data include user's table Mark and configuration field name;Field metadata table is used to store the metadata of the configured field in the tables of data of user.
Further, said apparatus also includes:
Field metadata set acquisition module, for obtaining use from user's table metadata table in user's table identifier acquisition module After family table mark, according to user's table identifier lookup field metadata table, to obtain field metadata set, wherein, field member number Include at least one field metadata item according to collection;Field metadata item includes selected state;
Second selecting module, for selecting field metadata set, and by the choosing of selected field metadata item Middle status indication is has chosen, by the selected state of not selected field metadata item labeled as unselected;Selected state is used Judge whether to load the field corresponding to corresponding field metadata item when in load field.
Further, said apparatus also includes:
3rd selecting module, in field configuration metadata set acquisition module according to user's table identifier lookup field configuration Metadata table, after obtaining field configuration metadata set, field configuration metadata set is selected, to obtain field to be deleted Data, field data to be deleted identify including the first extended field;
First searching modul, for being searched according to the first extended field mark in configuration data table, looked into obtaining first Result is looked for, wherein, configuration data table is used for the data message for storing user's extended field;
First judge module, for judging whether include the data item in configuration data table in the first lookup result;If so, Trigger the first removing module;
First removing module, for lookup result to be deleted from configuration data table, and simultaneously will field data be deleted from Deleted in field configuration metadata set.
Further, in addition to the second removing module, for not including the configuration data table in the first lookup result In data item when, field data to be deleted is deleted from the field configuration metadata set.
Further, said apparatus also includes:
4th selecting module, for selecting field configuration metadata set, to obtain field data to be changed, treat more Segment data of altering includes the second extended field and identifies and can change information;
Second searching modul, for being searched according to the second extended field mark in configuration data table, looked into obtaining second Result is looked for, wherein, configuration data table is used for the data message for storing user's extended field;
Second judge module, for judging whether include the data item in configuration data table in the second lookup result;If it is not, Triggering change module;
Module is changed, for being modified to the information of changing of field data to be changed in field configuration metadata table.
Field configuration method and device provided by the invention, identified by the user's table for obtaining current data table to search word Section configuration metadata table, is selected, and the extended field relevant information chosen is added with the extended field to current data table It is added in field metadata table, so as to realize the field configuration of current data table, when the field of system loads current data table, Loaded by field metadata table, you can loading extended field.
Brief description of the drawings
The invention will be described in more detail below based on embodiments and refering to the accompanying drawings.Wherein:
Fig. 1 is a schematic flow sheet of the field configuration method that the embodiment of the present invention one provides;
Fig. 2 a are the graph of a relation between the tenant that the embodiment of the present invention one provides and user's table;
Fig. 2 b are the graph of a relation between each metadata table that the embodiment of the present invention one provides;
Fig. 3 is another schematic flow sheet for the field configuration method that the embodiment of the present invention one provides;
Fig. 4 is the another schematic flow sheet for the field configuration method that the embodiment of the present invention one provides;
Fig. 5 is the another schematic flow sheet for the field configuration method that the embodiment of the present invention one provides;
Fig. 6 is a structural representation of the field configuration device that the embodiment of the present invention two provides;
Fig. 7 is another structural representation for the field configuration device that the embodiment of the present invention two provides;
Fig. 8 is the another structural representation for the field configuration device that the embodiment of the present invention two provides;
Fig. 9 is the another structural representation for the field configuration device that the embodiment of the present invention two provides.
In the accompanying drawings, identical part uses identical reference.Accompanying drawing is not drawn according to the ratio of reality.
Embodiment
Below in conjunction with accompanying drawing, the invention will be further described.
Embodiments of the present invention are described in detail below with reference to drawings and Examples, whereby implementation personnel of the invention Can fully understand how application technology means solve technical problem to the present invention, and reach the implementation process of technique effect and according to The present invention is embodied according to above-mentioned implementation process.If it should be noted that do not form conflict, each embodiment in the present invention And each feature in each embodiment can be combined with each other, the technical scheme formed protection scope of the present invention it It is interior.
Embodiment one
Fig. 1 is a schematic flow sheet of the field configuration method that the embodiment of the present invention one provides;As shown in figure 1, this implementation Example provides a kind of field configuration method, including step 101- steps 104.
Wherein, step 101, user's table mark is obtained from user's table metadata table, wherein, user's table metadata table is used for Store the metadata of the tables of data of user.
The relevant information of all tables of data of the user, such as the table of tables of data are would know that by user's table metadata table Name, field name, field label and whether the field of the tables of data can be configured, between each table as shown in 2a and Fig. 2 b Graph of a relation, tenant 4 is used to store the relevant information that tenant buys main body (object for renting SaaS systems), user in Fig. 2 a The information using user under table 1- user table storage tenancy entity, is many-to-one relation with tenant 4.In Fig. 2 b, if can Configuration being carried out by whether can configure field setting in user's table metadata table to the field of the tables of data, can only be carried out The tables of data that configurable field is set, field configuration (personalized customization is carried out according to user's request) could be carried out.
In practical application, system is loaded all tables of data of user according to user's table metadata table, to During the display of family, title (the settable name for only showing the tables of data that can carry out field configuration of all tables of data of user can be only shown Claim), user chooses the title for the tables of data for needing to carry out field configuration, and so as to obtain user's table mark, (title of tables of data is all User's table mark can be corresponded to), user's table is identified as the major key of user's table metadata table, and selected tables of data is hereinafter It is referred to as current data table.
Step 102, according to user's table identifier lookup field configuration metadata table, to obtain field configuration metadata set, its In, field configuration metadata table is used to store the metadata of the extended field in the tables of data of user;Field configuration metadata set Including at least one field configuration metadata item, field configuration metadata item includes configuration field name.
Extended field is the field for being used to carry out field configuration for current data table.It is in practical application, current choosing After tables of data, the related extended field of the current tables of data can be found out and be shown by field configuration metadata table by system To user, in display, configuration field name can be displayed for user's selection.In this step, field configuration metadata set bag At least one field configuration metadata item (a line record of the i.e. field configuration metadata table of field configuration metadata item) is included, that is, is worked as Preceding tables of data allows for being extended the configuration of field, could carry out carrying out configuration operation to it, so as to meet user personality Change configuration demand (if current data table can not be extended the configuration of field, then the present embodiment then with prior art indifference It is different).
Step 103, field configuration metadata set is selected, to obtain configuration field name.
In actual applications, in order to directly perceived, be shown to user for configuration field name, field configuration metadata set is carried out During selection, what user chose is configuration field name, and what is actually chosen is one or more field configuration metadata items, such as Fig. 2 b Shown, field configuration metadata item includes field configuration metadata table mark (being represented in table with ID), tenant ID, table id and (used Family table mark), field name (i.e. configuration field name) and field type.
Step 104, newly-increased data are generated in field metadata table, increasing data newly includes user's table mark and configuration field Name;Field metadata table is used to store the metadata of the configured field in the tables of data of user.
Newly-increased data are the record in field metadata table, and newly-increased data can be one and record, or a plurality of record, take It is certainly single choice or multiselect when user is being selected configuration field name, sets with specific reference to actual conditions, do not do herein Limit.As shown in Figure 2 b, field metadata table includes field metadata table mark (being represented in table with ID), tenant ID, table id (i.e. User's table identifies), it is field name (i.e. configuration field name), field label, whether essential and whether selected.
Field metadata table is used to store all numbers of the metadata, i.e. user of the configured field in the tables of data of user It is stored according to the metadata of the configured field of table in field metadata table.
In this step, it is that the extended field that current data table is chosen is added in field metadata table by user, with reality The field configuration of existing current data table.When the system loads current tables of data, relevant field is loaded by field metadata table It will can be loaded for all fields that current data table configures.
The function that the present embodiment is realized is that the extended field in field configuration metadata table is added into field metadata table In, so as to realize the field configuration of user's current data table.
The field configuration method that the present embodiment provides, user's table by obtaining current data table identifies matches somebody with somebody come Lookup Field Metadata table is put, is selected with the extended field to current data table, and the extended field relevant information chosen is added to In field metadata table, so as to realize the field configuration of current data table, when the field of system loads current data table, pass through Field metadata table is loaded, you can loading extended field.
Further, as shown in figure 3, in a specific embodiment of the invention, step is also included after step 101 102a-103a。
Wherein, step 102a, according to user's table identifier lookup field metadata table, to obtain field metadata set, wherein, Field metadata set includes at least one field metadata item;Field metadata item includes selected state.
Field metadata item is a record in field metadata table, and field metadata item including user's table except identifying And field name, in addition to selected state.Selected state includes having chosen and unselected two states.
In actual applications, the field metadata set (i.e. configured field) of active user's table is all loaded onto boundary by system It face, may be configured as that field name only is shown into user, user chooses corresponding field metadata item by selecting field name, will Selected state corresponding with selected field name is labeled as having chosen in field metadata table, with not selected field name pair The selected state answered is labeled as unselected.
Step 103a, field metadata set is selected, and by the selected state mark of selected field metadata item It is designated as having chosen, by the selected state of not selected field metadata item labeled as unselected;Selected state is used to load Judge whether to load the field corresponding to corresponding field metadata item during field.
When status display is chosen in choosing, system can just load the field corresponding to the field metadata item.
The present embodiment is another application of field configuration method, i.e., configured field is selected, pass through field Selected state in metadata realizes field configuration.When system loads, it is the field member chosen only to load selected state Field corresponding to data item.
In another specific embodiment of the invention, as shown in figure 4, also including step 103b- steps after step 102 105b, the present embodiment are used to delete extended field.
Wherein, step 103b, field configuration metadata set is selected, to obtain field data to be deleted, field to be deleted Data identify including the first extended field, and the first extended field mark is the ID in field configuration metadata table.Field Count to be deleted According to one or more records in as field configuration metadata set, therefore field to be deleted includes configuration field name, in addition, Field to be deleted also includes the first extended field and identified.Configuration field name can be shown to user by system, and user passes through configuration field Name is selected the extended field to be deleted, so as to obtain and the configuration field name of the extended field to be deleted corresponding first Extended field identifies.
Step 104b, searched according to the first extended field mark in configuration data table, to obtain the first lookup result, its In, configuration data table is used for the data message for storing user's extended field.
Step 105b, judge whether include the data item in configuration data table in the first lookup result;If so, go to step 106b is performed, if it is not, going to step 107b execution.
If the first lookup result includes the data item in configuration data table, illustrate corresponding to now the first extended field mark Extended field has data (data storage of extended field is in configuration data table), and otherwise, the extended field does not have data.
Step 106b, lookup result is deleted from configuration data table, and simultaneously will field data be deleted from field configuration Deleted in metadata set.
When extended field corresponding to the first extended field mark has data, not only by field configuration metadata table the Extended field relevant information corresponding to one extended field mark is deleted, and should also be believed the related of the extended field in configuration data table Breath is deleted.
Step 107b, field data to be deleted is deleted from field configuration metadata set.
In a specific embodiment of the invention, as shown in figure 5, also including step 103c- steps after step 102 106c, the present embodiment are used to be modified the information of changing of extended field.
Step 103c, field configuration metadata set is selected, to obtain field data to be changed, Field Count to be changed Identify according to including the second extended field and information can be changed.The second extended field mark is with the first extended field mark herein ID attributes in field configuration metadata table, in order to carry out area with the first extended field mark selected during deletion extended field Point, referred to herein as the second extended field mark.
Step 104c, searched according to the second extended field mark in configuration data table, to obtain the second lookup result, its In, configuration data table is used for the data message for storing user's extended field.
Step 105c, judge whether include the data item in configuration data table in the second lookup result;If it is not, go to step 106c is performed, if so, terminating to perform.
If the second lookup result includes the data item in configuration data table, illustrate corresponding to now the second extended field mark Extended field has data (data storage of extended field is in configuration data table), does not allow the correlation to the extended field herein Information is modified (for Information Security), and otherwise, the extended field does not have data.
Step 106c, the information of changing of field data to be changed in field configuration metadata table is modified.
Information, which can be changed, includes field name and field type.
Embodiment two
The present embodiment is device embodiment, for performing the method in above-described embodiment one.
Fig. 6 is a structural representation of the field configuration device that the embodiment of the present invention two provides;As shown in fig. 6, this implementation Example provides a kind of field configuration device, including user's table identifier acquisition module 201, field configuration metadata set acquisition module 202, First choice module 203 and newly-increased data generation module 204.
Wherein, user's table identifier acquisition module 201, for obtaining user's table mark from user's table metadata table, wherein, User's table metadata table is used for the metadata for storing the tables of data of user.
Field configuration metadata set acquisition module 202, for according to user's table identifier lookup field configuration metadata table, with Field configuration metadata set is obtained, wherein, field configuration metadata table is used to store the extended field in the tables of data of user Metadata;Field configuration metadata set includes at least one field configuration metadata item, and field configuration metadata item includes configuration Field name.
First choice module 203, for selecting field configuration metadata set, to obtain configuration field name.
Newly-increased data generation module 204, for generating newly-increased data in field metadata table, newly-increased data include user Table identifies and configuration field name;Field metadata table is used to store the metadata of the configured field in the tables of data of user.
Further, as shown in fig. 7, in another specific embodiment of the invention, field configuration device also includes field The selecting module 206 of metadata set acquisition module 205 and second.
Wherein, field metadata set acquisition module 205, for according to user's table identifier lookup field metadata table, to obtain Field metadata set is taken, wherein, field metadata set includes at least one field metadata item;Field metadata item includes choosing State.
Second selecting module 206, for selecting field metadata set, and by selected field metadata item Selected state is labeled as having chosen, by the selected state of not selected field metadata item labeled as unselected;Selected state For judging whether to load the field corresponding to corresponding field metadata item in load field.
Further, as shown in figure 8, in another specific embodiment of the invention, field configuration device also includes the 3rd Selecting module 207, the first searching modul 208, the first judge module 209, the first removing module 210 and the second removing module 211.
Wherein, the 3rd selecting module 207, for selecting field configuration metadata set, to obtain Field Count to be deleted According to field data to be deleted identifies including the first extended field;
First searching modul 208, for being searched according to the first extended field mark in configuration data table, to obtain first Lookup result, wherein, configuration data table is used for the data message for storing user's extended field.
First judge module 209, for judging whether include the data item in configuration data table in the first lookup result;If It is to trigger the first removing module, if it is not, the second removing module of triggering.
First removing module 210, will field data be deleted for lookup result to be deleted from configuration data table, and simultaneously Deleted from field configuration metadata set.
Second removing module 211, for field data to be deleted to be deleted from field configuration metadata set.
Further, as shown in figure 9, in another specific embodiment of the invention, field configuration device also includes the 4th Selecting module 212, the second searching modul 213, the second judge module 214 and change module 215.
Wherein, the 4th selecting module 212, for selecting field configuration metadata set, to obtain field to be changed Data, field data to be changed include the second extended field and identify and can change information.
Second searching modul 213, for being searched according to the second extended field mark in configuration data table, to obtain second Lookup result, wherein, configuration data table is used for the data message for storing user's extended field.
Second judge module 214, for judging whether include the data item in configuration data table in the second lookup result;If It is no, triggering change module.
Module 215 is changed, for being carried out more to the information of changing of field data to be changed in field configuration metadata table Change.
The present embodiment be with one corresponding device embodiment of embodiment of the method, for details, reference can be made to the description in embodiment one, It will not be repeated here.
It should be understood that disclosed embodiment of this invention is not limited to specific structure disclosed herein, processing step Or material, and the equivalent substitute for these features that those of ordinary skill in the related art are understood should be extended to.It should also manage Solution, term as used herein are only used for describing the purpose of specific embodiment, and are not intended to limit.
" one embodiment " or " embodiment " mentioned in specification means special characteristic, the structure described in conjunction with the embodiments Or during characteristic is included at least one embodiment of the present invention.Therefore, the phrase " reality that specification various places throughout occurs Apply example " or " embodiment " same embodiment might not be referred both to.
In addition, described feature, structure or characteristic can be attached to one or more in any other suitable manner in fact Apply in example.In superincumbent description, there is provided some concrete details, such as material etc., to provide to embodiments of the invention Comprehensive understanding.However, those skilled in the relevant art are readily apparent that, the present invention is without said one or multiple concrete details Realize, or can also use other methods, component, material etc. to realize.In other examples, known structure, material or operation It is not shown or described in detail in order to avoid obscuring various aspects of the invention.
Although above-mentioned example is used to illustrate principle of the present invention in one or more apply, for the technology of this area For personnel, in the case of without departing substantially from the principle and thought of the present invention, hence it is evident that can in form, the details of usage and implementation It is upper that various modifications may be made and does not have to pay creative work.Therefore, the present invention is defined by the appended claims.

Claims (10)

  1. A kind of 1. field configuration method, it is characterised in that including:
    User's table mark is obtained from user's table metadata table, wherein, user's table metadata table is used for the number for storing user According to the metadata of table;
    According to user's table identifier lookup field configuration metadata table, to obtain field configuration metadata set, wherein, the word Section configuration metadata table is used to store the metadata of the extended field in the tables of data of user;The field configuration metadata set bag At least one field configuration metadata item is included, the field configuration metadata item includes configuration field name;
    The field configuration metadata set is selected, to obtain configuration field name;
    Newly-increased data are generated in field metadata table, the newly-increased data include user's table mark and the configuration field Name;The field metadata table is used to store the metadata of the configured field in the tables of data of user.
  2. 2. field configuration method according to claim 1, it is characterised in that user's table is obtained from user's table metadata table After mark, in addition to:
    According to field metadata table described in user's table identifier lookup, to obtain field metadata set, wherein, the field member Data set includes at least one field metadata item;The field metadata item includes selected state;
    The field metadata set is selected, and the selected state of selected field metadata item is labeled as having selected In, by the selected state of not selected field metadata item labeled as unselected;Selected state is used to sentence in load field The disconnected field whether loaded corresponding to corresponding field metadata item.
  3. 3. field configuration method according to claim 1, it is characterised in that matched somebody with somebody according to user's table identifier lookup field Metadata table is put, after obtaining field configuration metadata set, in addition to:
    The field configuration metadata set is selected, to obtain field data to be deleted, the field data to be deleted includes the One extended field identifies;
    Searched according to first extended field mark in configuration data table, to obtain the first lookup result, wherein, it is described to match somebody with somebody Put the data message that tables of data is used to store user's extended field;
    Judge whether include the data item in the configuration data table in the first lookup result;If so, then by the lookup result Delete from the configuration data table, and simultaneously delete field data to be deleted from the field configuration metadata set.
  4. 4. field configuration method according to claim 3, it is characterised in that also include:If do not wrapped in the first lookup result The data item in the configuration data table is included, then is deleted field data to be deleted from the field configuration metadata set.
  5. 5. the field configuration method according to any one of claim 1-4, it is characterised in that identified according to user's table Lookup Field configures metadata table, after obtaining field configuration metadata set, in addition to:
    The field configuration metadata set is selected, to obtain field data to be changed, the field data bag to be changed Include the second extended field mark and information can be changed;
    Searched according to second extended field mark in configuration data table, to obtain the second lookup result, wherein, it is described to match somebody with somebody Put the data message that tables of data is used to store user's extended field;
    Judge whether include the data item in the configuration data table in the second lookup result;If it is not, then to the field configuration The information of changing of field data to be changed is modified in metadata table.
  6. A kind of 6. field configuration device, it is characterised in that including:
    User's table identifier acquisition module, for obtaining user's table mark from user's table metadata table, wherein, user's list cell Tables of data is used for the metadata for storing the tables of data of user;
    Field configuration metadata set acquisition module, for according to user's table identifier lookup field configuration metadata table, to obtain Field configuration metadata set is taken, wherein, the field configuration metadata table is used to store the extended field in the tables of data of user Metadata;The field configuration metadata set includes at least one field configuration metadata item, the field configuration metadata Item includes configuration field name;
    First choice module, for selecting the field configuration metadata set, to obtain configuration field name;
    Newly-increased data generation module, for generating newly-increased data in field metadata table, the newly-increased data include the use Family table mark and the configuration field name;The field metadata table is used to store the configured field in the tables of data of user Metadata.
  7. 7. field configuration device according to claim 6, it is characterised in that also include:
    Field metadata set acquisition module, for obtaining use from user's table metadata table in user's table identifier acquisition module After family table mark, according to field metadata table described in user's table identifier lookup, to obtain field metadata set, wherein, The field metadata set includes at least one field metadata item;The field metadata item includes selected state;
    Second selecting module, for selecting the field metadata set, and by the choosing of selected field metadata item Middle status indication is has chosen, by the selected state of not selected field metadata item labeled as unselected;Selected state is used Judge whether to load the field corresponding to corresponding field metadata item when in load field.
  8. 8. field configuration device according to claim 6, it is characterised in that also include:
    3rd selecting module, in the field configuration metadata set acquisition module according to user's table identifier lookup field Metadata table is configured, after obtaining field configuration metadata set, the field configuration metadata set is selected, to obtain Field data to be deleted, the field data to be deleted identify including the first extended field;
    First searching modul, for being searched according to first extended field mark in configuration data table, looked into obtaining first Result is looked for, wherein, the configuration data table is used for the data message for storing user's extended field;
    First judge module, for judging whether include the data item in the configuration data table in the first lookup result;If so, Trigger the first removing module;
    First removing module, for the lookup result to be deleted from the configuration data table, and simultaneously will Field Count be deleted Deleted according to from the field configuration metadata set.
  9. 9. field configuration device according to claim 8, it is characterised in that also including the second removing module, for When not including the data item in the configuration data table in one lookup result, by field data to be deleted from the field configuration member number Deleted according to concentrating.
  10. 10. the field configuration device according to any one of claim 6-9, it is characterised in that also include:
    4th selecting module, in the field configuration metadata set acquisition module according to user's table identifier lookup field Metadata table is configured, after obtaining field configuration metadata set, the field configuration metadata set is selected, to obtain Field data to be changed, the field data to be changed include the second extended field and identify and can change information;
    Second searching modul, for being searched according to second extended field mark in configuration data table, looked into obtaining second Result is looked for, wherein, the configuration data table is used for the data message for storing user's extended field;
    Second judge module, for judging whether include the data item in the configuration data table in the second lookup result;If it is not, Triggering change module;
    Module is changed, for being carried out more to information can be changed described in field data to be changed in the field configuration metadata table Change.
CN201710536340.XA 2017-07-04 2017-07-04 Method and device for configuring field Active CN107391612B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710536340.XA CN107391612B (en) 2017-07-04 2017-07-04 Method and device for configuring field

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710536340.XA CN107391612B (en) 2017-07-04 2017-07-04 Method and device for configuring field

Publications (2)

Publication Number Publication Date
CN107391612A true CN107391612A (en) 2017-11-24
CN107391612B CN107391612B (en) 2020-06-12

Family

ID=60334731

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710536340.XA Active CN107391612B (en) 2017-07-04 2017-07-04 Method and device for configuring field

Country Status (1)

Country Link
CN (1) CN107391612B (en)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109308296A (en) * 2018-09-30 2019-02-05 税友软件集团股份有限公司 A kind of generation method, device and the computer readable storage medium of business datum table
CN110109981A (en) * 2019-04-04 2019-08-09 平安科技(深圳)有限公司 Information displaying method, device, computer equipment and the storage medium of work queue
CN110276002A (en) * 2019-06-26 2019-09-24 浙江大搜车软件技术有限公司 Search for application data processing method, device, computer equipment and storage medium
CN110618988A (en) * 2019-09-20 2019-12-27 中国银行股份有限公司 Data processing method and device based on big data platform
CN111125262A (en) * 2018-10-31 2020-05-08 北京国双科技有限公司 Method and device for processing field information, storage medium and processor
CN113590593A (en) * 2021-08-04 2021-11-02 浙江大华技术股份有限公司 Method and device for generating data table information, storage medium and electronic device

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102779040A (en) * 2012-06-21 2012-11-14 东莞市微模式软件有限公司 Method and device for generating user-defined form
CN102819547A (en) * 2012-01-13 2012-12-12 金蝶软件(中国)有限公司 Method and device for configuring field attribute
CN105447122A (en) * 2015-11-16 2016-03-30 中国人民解放军理工大学 Implementation method for autonomously creating file system based on multi-table association
CN106354775A (en) * 2016-08-23 2017-01-25 成都科来软件有限公司 Data dynamic configuration system and method based on custom fields
CN106681698A (en) * 2015-11-05 2017-05-17 阿里巴巴集团控股有限公司 Dynamic list generating method and device

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102819547A (en) * 2012-01-13 2012-12-12 金蝶软件(中国)有限公司 Method and device for configuring field attribute
CN102779040A (en) * 2012-06-21 2012-11-14 东莞市微模式软件有限公司 Method and device for generating user-defined form
CN106681698A (en) * 2015-11-05 2017-05-17 阿里巴巴集团控股有限公司 Dynamic list generating method and device
CN105447122A (en) * 2015-11-16 2016-03-30 中国人民解放军理工大学 Implementation method for autonomously creating file system based on multi-table association
CN106354775A (en) * 2016-08-23 2017-01-25 成都科来软件有限公司 Data dynamic configuration system and method based on custom fields

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109308296A (en) * 2018-09-30 2019-02-05 税友软件集团股份有限公司 A kind of generation method, device and the computer readable storage medium of business datum table
CN111125262A (en) * 2018-10-31 2020-05-08 北京国双科技有限公司 Method and device for processing field information, storage medium and processor
CN111125262B (en) * 2018-10-31 2024-02-13 北京国双科技有限公司 Method and device for processing field information, storage medium and processor
CN110109981A (en) * 2019-04-04 2019-08-09 平安科技(深圳)有限公司 Information displaying method, device, computer equipment and the storage medium of work queue
CN110109981B (en) * 2019-04-04 2023-07-25 平安科技(深圳)有限公司 Information display method and device for work queue, computer equipment and storage medium
CN110276002A (en) * 2019-06-26 2019-09-24 浙江大搜车软件技术有限公司 Search for application data processing method, device, computer equipment and storage medium
CN110276002B (en) * 2019-06-26 2021-08-03 浙江大搜车软件技术有限公司 Search application data processing method and device, computer equipment and storage medium
CN110618988A (en) * 2019-09-20 2019-12-27 中国银行股份有限公司 Data processing method and device based on big data platform
CN113590593A (en) * 2021-08-04 2021-11-02 浙江大华技术股份有限公司 Method and device for generating data table information, storage medium and electronic device

Also Published As

Publication number Publication date
CN107391612B (en) 2020-06-12

Similar Documents

Publication Publication Date Title
CN107391612A (en) Field configuration method and device
US11106626B2 (en) Managing changes to one or more files via linked mapping records
US7904885B2 (en) Change management for structure objects
US8321803B2 (en) Aggregating service components
CN104346185B (en) Application object attributes update method, device and application platform
US20090089072A1 (en) Configuration management database (cmdb) which establishes policy artifacts and automatic tagging of the same
CN108255709A (en) Script tests method, apparatus, terminal device and the storage medium of written in code
CN107644286A (en) Workflow processing method and device
CN105302533A (en) Code synchronizing method and apparatus
CN109716324A (en) Direct table association in in-memory data library
US8423564B1 (en) Methods and apparatus for managing and updating stored information
CA2733091A1 (en) System, method and computer program product for managing data storage and rule-driven communications for a plurality of tenants
CN107301179A (en) The method and apparatus of data base read-write separation
CN106844730A (en) The display methods and device of file content
CN106649602A (en) Way, device and server of processing business object data
CN108156030A (en) The method and device that a kind of configuration strategy synchronizes
CN110244951B (en) Application publishing method and device
CN108228846A (en) Resource file management method and device
CN102844774A (en) Web page control method, computer system and program
CN116401407A (en) Node attribute configuration method, device, equipment and storage medium of mind map
US7818288B1 (en) eTOM enhancement of functional requirements modeling
US20020049688A1 (en) Means for and method of displaying a visual decision tree model
US8869030B2 (en) Hierarchical representation of contextual information
CN102682038A (en) Database change method and device
KR102232003B1 (en) Method for object management using trace identifier, apparatus for the same, computer program for the same, and recording medium storing computer program thereof

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