Data field configuration method and related apparatus

By configuring data fields in a pre-defined table, the problem of low efficiency in field modification and maintenance in existing technologies is solved, enabling fast and efficient data field configuration and querying, and adapting to changes in product business needs.

CN114357006BActive Publication Date: 2025-11-21SHENZHEN SIWEI SOFTWARE TECH CO LTD
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
CN202111534986.7
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-12-15
Publication Date
2025-11-21
Estimated Expiration
2041-12-15

AI Technical Summary

Technical Problem

In existing technologies, modifying and maintaining data fields requires programmers to write code manually, which leads to decreased database performance and low query efficiency, making it impossible to meet business needs in a timely manner, and increasing labor costs and maintenance time.

Method used

Data fields can be configured through preset tables, including a main table describing the fields, an enumeration type value table, a cascading relationship table, and an administrative division table. This enables the configuration and storage of field attributes, supports multi-selection, hierarchical relationships, and regional selection, quickly generates complex fields, and allows users to directly call preset tables for configuration according to their needs.

Benefits of technology

It enables rapid and efficient configuration of data fields, supports the generation of fields with complex functions, reduces manual costs, improves database performance and query efficiency, and adapts to changes in product business needs.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114357006B_ABST
    Figure CN114357006B_ABST
Patent Text Reader

Abstract

The examples of the present application provide a data field configuration method and related devices, the method comprising: determining a first field to be configured; determining attribute content required by the first field to be configured; determining at least one preset table according to the attribute content, the preset table being used for setting and storing attribute content of a field; performing attribute configuration on the first field according to the at least one preset table, and updating the at least one preset table to obtain a second field. The embodiments of the present application can not only configure a data field, but also realize dynamic storage of fields of different modules, solve the problem that field attribute content can only be changed by modifying a background program, and thus can conveniently configure a data field to meet business requirements of different users.
Need to check novelty before this filing date? Find Prior Art

Description

TECHNICAL FIELD

[0001] The present application belongs to the technical field of computer, and particularly relates to a data field configuration method and related device. BACKGROUND

[0002] Currently, some data fields are defined by products in advance. For example, for a registration activity, a plurality of fields such as name, mobile phone number, ID number, etc. need to be configured, and then the product is configured on the page for users to fill in data. Or these fields are changed into strings and stored in a field, and the information filled by the user is also stored by being changed into a string.

[0003] However, as the business requirements of different products change, the fields on the page need to be modified in terms of type, name, or new fields need to be added or old fields need to be deleted. At this time, programmers need to re-write the program of the background after modification, and the table structure in the database also needs to be changed, which leads to a serious decline in the performance of the database or an exception in the execution of the program. The method of changing into a string leads to low efficiency and complex operation of querying and updating the fields. Such problems lead to a large amount of additional labor cost and maintenance time for product merchants, and the changes of the fields of the product page cannot meet the business requirements of the product merchants in time. SUMMARY

[0004] Embodiments of the present application provide a data field configuration method and related device, so as to provide the convenience and efficiency of the electronic device in configuring the data field.

[0005] In a first aspect, embodiments of the present application provide a data field configuration method, comprising:

[0006] determining a first field to be configured;

[0007] determining attribute content required by the first field to be configured;

[0008] determining at least one preset table according to the attribute content, the preset table being used for setting and storing the attribute content of the field;

[0009] performing attribute configuration on the first field according to the at least one preset table, and updating the at least one preset table to obtain a second field.

[0010] In a second aspect, embodiments of the present application further provide a data field configuration device, comprising:

[0011] a field determining unit configured to determine a first field to be configured;

[0012] an attribute content determining unit configured to determine attribute content required by the first field to be configured;

[0013] a preset table determining unit configured to determine at least one preset table according to the attribute content;

[0014] The dynamic configuration unit is configured to configure the first field according to at least one preset table, and update the at least one preset table to obtain a second field.

[0015] In a third aspect, an electronic device is provided, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and wherein the processor implements the steps of any method of the first aspect when executing the computer program.

[0016] In a fourth aspect, a computer readable storage medium is provided, which stores a computer program, and wherein the computer program is executable by a processor to implement the steps of any method of the first aspect.

[0017] It can be seen that, in the embodiments of the present application, the fields are configured by the preset tables first, and the preset tables corresponding to the fields are saved in the database. When the attribute contents of the fields need to be modified, the fields to be configured are determined first, the attribute contents to be configured for the fields are determined, at least one preset table is determined according to the attribute contents, the fields are configured according to the at least one preset table, and the contents in the corresponding preset tables are updated. The user can also display the configured fields as filtering conditions according to the preset rules, and complete the direct configuration by selecting and calling the preset tables of the selected fields. When the product user inputs the user data records, the data records are stored in the standard table or the extended table. In this way, the data fields can be configured conveniently to meet the business requirements of different users, and the user can query the attribute contents of the configured fields and the user data records input by the product user at any time. BRIEF DESCRIPTION OF DRAWINGS

[0018] In order to more clearly illustrate the technical solutions of the embodiments of the present application or the prior art, the drawings needed in the embodiments or the prior art description will be briefly introduced. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative labor.

[0019] Figure 1a is a process schematic diagram of a data field configuration method provided by the embodiments of the present application;

[0020] Figure 1b is a content schematic diagram of a preset table provided by the embodiments of the present application;

[0021] Figure 1c is a flowchart of generating a field provided by the embodiments of the present application;

[0022] Figure 1d is a user calling operation schematic diagram of a corresponding preset table provided by an embodiment of the present application;

[0023] Figure 1e is a user data record storage flow schematic diagram provided by an embodiment of the present application;

[0024] Figure 2 is a functional unit component block diagram of a data field configuration device provided by an embodiment of the present application;

[0025] Figure 3 is a structural block diagram of an electronic device provided by an embodiment of the present application. DETAILED DESCRIPTION

[0026] In order to enable persons skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be described clearly and completely below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only some of the embodiments of the present application, but not all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by persons skilled in the art without creative labor fall within the scope of protection of the present application.

[0027] The terms "first", "second", and the like in the specification and claims of the present application and the above-mentioned drawings are used to distinguish different objects, and are not used to describe a specific order. In addition, the terms "include" and "have" and any variations thereof are intended to cover non-exclusive inclusion. For example, a process, method, system, product or device that includes a series of steps or units is not limited to the listed steps or units, but can optionally include other steps or units not listed or can optionally include other steps or units inherent to the process, method, product or device.

[0028] In this document, the term "embodiment" means that the specific features, structures or characteristics described in connection with the embodiment can be included in at least one embodiment of the present application. The appearance of this phrase in various places in the specification does not necessarily mean the same embodiment, nor is it independent or alternative to other embodiments. It is explicitly and implicitly understood by those skilled in the art that the embodiments described herein can be combined with other embodiments.

[0029] Currently, many products provide services to users through pages, and users operate and interact through fields on product pages. Fields used on pages can be displayed on web pages and implemented by programmers by writing web page codes and programs. Or by converting fields and user input data into strings to achieve data storage. With product development and multifunctionalization, product vendors want products to meet different business needs, which requires changing the attribute content of the field. However, at this time, programmers need to rewrite the modified background program, and there may be problems such as serious performance degradation of the database or low efficiency of querying and updating fields and complex operations.

[0030] To solve the above problems, the embodiment of the application provides a data field configuration method, which can be applied to electronic equipment to configure data fields. The method can determine the fields to be configured, and determine at least one preset table stored in the database according to the attribute content to be configured, update the attribute content in the at least one preset table, and configure the fields, so as to configure the data fields according to different business needs.

[0031] The data field configuration method process related to the embodiment of the application is introduced below.

[0032] Please refer to Figure 1a , Figure 1a is a data field configuration method process schematic diagram provided by the embodiment of the application, which provides a data field configuration method applied to electronic equipment, and the method includes the following steps:

[0033] Step 110, determining a first field to be configured.

[0034] Step 120, determining attribute content to be configured for the first field.

[0035] Step 130, determining at least one preset table according to the attribute content, the preset table being used for setting and storing attribute content of the field.

[0036] In one possible embodiment, as shown in the preset table content Figure 1b , Figure 1b is a content schematic diagram of a preset table provided by the embodiment of the application, the preset table includes a field description master table, an enumerated type value table, a cascading relationship table and an administrative division table, the field description master table being used for setting and storing the configuration information, the enumerated type value table being used for setting and storing option content of a multiple selection field, the cascading relationship table being used for setting and storing a hierarchical relationship existing in the field, and the administrative division table being used for storing national administrative division information.

[0037] Among them, at the beginning of the configuration, the product merchant configures by setting the content of the four preset tables to generate the required fields of product business requirements. The configuration information of the field is set by the field description master table, the enumeration type value table is set and filled with some option content with multiple selection field function, the cascade relationship sets the hierarchical relationship between the field and other fields, and the administrative division table stores the national administrative division information.

[0038] For example, the field description master table can include but is not limited to the following configuration information: field name, database field name, field type, whether to display, whether to support export, type module. The enumeration type table can include but is not limited to the following settings: field name, value, option, status, module. The cascade level table can include but is not limited to the following settings: field name, level, module, status. The administrative division table contains the national administrative division information.

[0039] It can be seen that in the present example, four different tables are preset, which can realize the selection of attribute content by the product merchant according to his own needs and efficiently complete the configuration of the field.

[0040] Step 140, attribute configuration of the first field according to the at least one preset table, and updating the at least one preset table to obtain a second field.

[0041] In one possible embodiment, before determining the first field to be configured, the method further comprises: configuring a first field by the preset table and updating the preset table; saving the preset table to the database.

[0042] Among them, when starting to configure a new field, the content in the table is set according to the preset table to configure the field, and after the configuration is completed, the content in the preset table is updated and saved, and the preset table corresponding to the field is saved in the database.

[0043] It can be seen that in the present example, the field is configured according to the preset table, the content in the preset table is updated and saved after the configuration is completed, and the preset table corresponding to the field is saved in the database. In this way, the field can be quickly and efficiently configured, and fields with complex functions can be configured. Moreover, the preset table can also store the attribute content of the field, and the preset table is stored in the database, which facilitates subsequent configuration of field attribute content and user call of field attribute content.

[0044] In one possible embodiment, as shown in the configuration field generation process of Figure 1c , the method comprises the following steps. Figure 1cis a flowchart of a process for configuring a field provided by an embodiment of the present application. The process comprises the following steps: configuring a first field by filling in the content of the configuration information in the field description master table; adding a multiple selection function to the first field by inputting option content into the enumerated type value table; setting the hierarchical relationship between the first field and other fields by using the cascade relationship table; adding a region selection function to the first field by using the administrative division table; and outputting the first field.

[0045] In the process of configuring a new field, configuration information is filled in according to the format of the configuration information contained in the field description master table, and then option content is input into the enumerated type value table to add a multiple selection function to the configured field. The hierarchical relationship is set according to the cascade relationship table, and the region selection function is added according to the administrative division table. Finally, the first field is output.

[0046] For example, the configuration information contained in the field description master table includes type module, field name, database field name, whether to display, sorting priority, whether to support filtering query, type of the field, controls contained in the field such as input box, and whether to support export. For the enumerated type value table, some fields in the product page need to have a multiple selection function. When configuring the field, the option content displayed when the user clicks the field is set and stored in the enumerated type value table. When the field is selected by the user in the product page, the option content is popped up. For the cascade relationship table, multiple fields are used to query goods. In the first field, information of a large brand is input. In the second field, information of a small brand is input according to the first field. In the third field, information of the goods that the user wants to query is input. In this case, there is a hierarchical relationship between multiple fields. The hierarchical relationship needs to be set by using the cascade relationship table. For the administrative division table, a field in the product page needs to be able to perform filtering query of administrative division. The province needs to be selected, and then the city needs to be selected. The information of the administrative division table needs to be displayed to the user. The function can be set by using the administrative division table.

[0047] As can be seen, in the present example, by using the four preset tables and setting and storing the attribute content of the field, a complex and diverse field can be configured and generated. This ensures that the user can quickly configure and generate the required field. The configured field can have diverse and complete attribute content, and the function of the field can be realized.

[0048] In one possible embodiment, as shown in Figure 1d , the method comprises the following steps: Figure 1dThis is a schematic diagram of a user retrieving a corresponding preset table according to an embodiment of this application. After saving the preset table to the database, the method further includes: displaying the configured fields as filter conditions for the user to select according to the preset rules used by the user; directly calling the corresponding preset table of the field selected by the user from the database based on the user's selection; and directly configuring and generating fields according to the corresponding preset table.

[0049] In this process, the pre-configured fields can be displayed as filter conditions for users to select based on the preset rules used by the user. Then, based on the user's selection, the preset table can be directly called up, and finally, the field can be directly configured based on the preset table.

[0050] For example, a user-defined preset rule could refer to filtering fields with the same characteristics from the configured fields based on the features of the desired fields, allowing users to perform queries. This is not limited to any particular field, as long as the preset rule facilitates the filtering operation for the user. For instance, a product vendor might need a field that allows "display," "multi-selection," and whose field name is "age." The preset rule for this product page would allow users to enter attribute content in the search bar to query the database, find the configured fields with the same attribute content, and display them at the bottom of the product page for the vendor to select.

[0051] As can be seen in the example, the previously configured fields are displayed according to the user's preset rules. Then, based on the user's selection, the corresponding preset table for the selected field is retrieved from the database, and the field is directly configured and generated based on that preset table. This allows product vendors to quickly and conveniently call the previously configured preset table to configure fields for the same business needs across different products, eliminating the need for repetitive configuration of fields with identical attributes. This greatly improves the usability of the preset table and allows for modification to adapt to different fields required by different modules.

[0052] In one possible embodiment, such as Figure 1e The user data record storage process shown is as follows: Figure 1e This is a schematic diagram of a user data record storage process provided in an embodiment of this application. After obtaining the second field, the method further includes: obtaining the user data record input by the product user and the third field corresponding to the user data record; determining whether the third field is a standard field; if it is, storing the user data record in a standard table; if it is not, storing the user data record in an extended table, wherein the extended table and the standard table are stored in a database.

[0053] Wherein, when the product user uses the product, the product user inputs information in a field of the product page, i.e., the third field, so as to obtain the user data record input by the user and determine the corresponding field input by the user. Then, it is judged whether the third field is a standard field, and finally, the user data record is stored in the standard table or the extended table according to the judgment result.

[0054] It can be seen that in the example, the user data record input by the product user is obtained, and it is judged according to the corresponding third field whether it is a standard field, and the user data record is stored in the standard table and the extended table. Through this method, the user data record can be distinguished and stored in different tables, so that the product merchant can take different technical measures for the user data record collected according to different fields.

[0055] In one possible embodiment, the judgment of whether the third field is a standard field further includes: obtaining the attribute content of the third field according to the third field; judging whether the attribute content of the third field can be contained by the attribute content in the preset table; if it is judged that it can, it is judged that the third field is the standard field; if it is judged that it cannot, it is judged that the third field is an extended field.

[0056] Wherein, when judging whether the third field is a standard field, the attribute content of the third field is obtained first, and whether the attribute content of the third field can be contained by the attribute content contained in the preset table is judged, and according to the judgment result, it is determined whether the third field is a standard field or an extended field.

[0057] It can be seen that in the example, according to whether the attribute content of the third field corresponding to the user data record can be contained by the attribute content in the preset table, the third field is distinguished into a standard field and an extended field to decide whether the user data record is stored in the standard table or the extended table. In this way, the fields not configured by the preset table can be distinguished, and the user data record collected by these fields is stored in another table, so that when these fields need to be modified and configured later, the change of the program code does not affect the data record collected by the field configured by the preset table.

[0058] It can be seen that in the example, Figure 1a The data field configuration method provided in the embodiment of the application is shown in the process schematic diagram. According to the determination of the first field to be configured, the attribute content to be configured is determined, and at least one preset table storing the attribute content is determined according to the attribute content to be configured. The attribute configuration is performed according to the preset table and is updated, and the second field is obtained. In this way, the attribute content of the field to be configured can be changed and saved quickly and efficiently, the product page field can adapt to the change of the product business demand, and the attribute content of the configured field can be conveniently and quickly queried and called by the user later.

[0059] The following is an apparatus embodiment of the present application, which belongs to the same concept as the method embodiments of the present application and is used to execute the method described in the embodiments of the present application. For the convenience of description, the apparatus embodiment of the present application only shows the parts related to the apparatus embodiment of the present application, and the specific technical details not disclosed are referred to the description of the method embodiments of the present application, which will not be described here one by one.

[0060] The embodiment of the present application provides a data field configuration apparatus, which can be used for an electronic device. Specifically, the data field configuration is used to execute the steps executed by the electronic device in the above application test method. The data field configuration provided by the embodiment of the present application can include the modules corresponding to the corresponding steps.

[0061] The embodiment of the present application can divide the function modules of the data field configuration according to the above method examples. For example, each function module can be divided according to each function, or two or more functions can be integrated in one processing module. The integrated module can be realized in the form of hardware or in the form of software function module. The division of the modules in the embodiment of the present application is illustrative, and is only a logical function division. When actually implemented, there can be another division mode.

[0062] In the case of dividing each function module according to each function, Figure 2 is a functional unit composition block diagram of a data field configuration apparatus provided by the embodiment of the present application. As Figure 2 shown, the data field configuration apparatus can include:

[0063] A determination field unit 210 for determining a first field to be configured;

[0064] A determination attribute content unit 220 for determining attribute content required by the first field to be configured;

[0065] A determination preset table unit 230 for determining at least one preset table according to the attribute content;

[0066] In one possible embodiment, the determination preset table unit 230 is specifically used for: a preset table, the preset table includes a field description master table, an enumerated type value table, a cascading relationship table and an administrative division table, the field description master table is used to set and store the configuration information, the enumerated type value table is used to set and store the option content of the multiple selection field, the cascading relationship table is used to set and store the hierarchical relationship existing in the field, and the administrative division table is used to store the national administrative division information.

[0067] The dynamic configuration unit 240 is configured to configure a first field according to at least one preset table and update the at least one preset table to obtain a second field.

[0068] In one possible embodiment, in the aspect of configuring the field, the dynamic configuration unit 240 is specifically configured to configure the first field by using the preset table and update the preset table, and save the preset table to a database.

[0069] In one possible embodiment, in the aspect of configuring the field, the dynamic configuration unit 240 is specifically configured to configure the first field by filling in the field to depict the content of the configuration information in the master table, add a multiple selection function to the first field by inputting option content to the enumeration type value table, set a hierarchical relationship between the first field and other fields by using the cascading relationship table, add a region selection function to the first field by using the administrative division table, and finally output the first field.

[0070] In one possible embodiment, in the aspect of calling the preset table, the dynamic configuration unit 240 is specifically configured to display the configured field as a filtering condition for a user to select according to a preset rule used by the user, directly call a corresponding preset table of a field selected by the user from the database according to the selection of the user, and finally directly configure and generate a field according to the corresponding preset table.

[0071] In one possible embodiment, in the aspect of storing the user data record, the dynamic configuration unit 240 is specifically configured to obtain a user data record input by a product user and a third field corresponding to the user data record, determine whether the third field is a standard field, store the user data record in a standard table if the third field is the standard field, and store the user data record in an extended table if the third field is not the standard field, wherein the extended table and the standard table are stored in a database.

[0072] In one possible embodiment, in the aspect of storing the user data record, the dynamic configuration unit 240 is specifically configured to obtain attribute content of the third field according to the third field, determine whether the attribute content of the third field can be included in attribute content in the preset table, determine that the third field is the standard field if the attribute content of the third field can be included in the attribute content in the preset table, and determine that the third field is an extended field if the attribute content of the third field cannot be included in the attribute content in the preset table.

[0073] It should be noted that the application test apparatus described in the embodiments of the present application is presented in the form of functional units. The term "unit" used herein should be understood as the broadest possible meaning, and the object for implementing the described functions of each "unit" may be, for example, an integrated circuit ASIC, a single circuit, a processor (shared, dedicated, or chip set) and memory for executing one or more software or solid programs, a combination logic circuit, and / or other suitable components for providing the above-mentioned functions.

[0074] Figure 3 is a structural block diagram of an electronic device provided by an embodiment of the present application, as shown in Figure 3 The electronic device 300 can include one or more of the following components: a processor 310, a memory 320 coupled with the processor 310, wherein the memory 320 can store one or more computer programs, and the one or more computer programs can be configured to be executed by the one or more processors 310 to implement the method described in the above embodiments.

[0075] The processor 310 can include one or more processing cores. The processor 310 connects various parts in the entire electronic device 300 by various interfaces and lines, and performs various functions and processes data of the electronic device 300 by running or executing instructions, programs, code sets or instruction sets stored in the memory 320, and calling data stored in the memory 320. Alternatively, the processor 310 can be implemented in at least one of a hardware form of a digital signal processing (DSP), a field-programmable gate array (FPGA), and a programmable logic array (PLA). The processor 310 can integrate a combination of one or more of a central processing unit (CPU), a graphics processor (GPU), and a modem. Among them, the CPU is mainly used to process operating systems, user interfaces, and application programs; the GPU is used to render and draw display content; and the modem is used to process wireless communication. It can be understood that the above-mentioned modem can also not be integrated into the processor 310, but can be implemented by a separate communication chip.

[0076] The memory 320 can include a random access memory (RAM) and can also include a read-only memory (ROM). The memory 320 can be used to store instructions, programs, codes, code sets, or instruction sets. The memory 320 can include a program storage area and a data storage area, where the program storage area can store instructions for implementing an operating system, instructions for implementing at least one function (such as a touch function, a sound playing function, an image playing function, etc.), instructions for implementing the various method embodiments described above, and the like. The data storage area can also store data created by the electronic device 300 in use, and the like.

[0077] It can be understood that the electronic device 300 can include more or fewer structural elements than those in the above structural block diagram, for example, a power module, a physical key, a WiFi (Wireless Fidelity) module, a speaker, a Bluetooth module, a sensor, and the like, which are not limited herein.

[0078] The above-described embodiments can be implemented in whole or in part by software, hardware, firmware, or any combination thereof. When implemented by software, the above-described embodiments can be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions or computer programs. When the computer instructions or computer programs are loaded or executed on a computer, the entire or partial processes or functions described in the embodiments of the present application are generated. The computer can be a general-purpose computer, a special-purpose computer, a computer network, or other programmable devices. The computer instructions can be stored in a computer-readable storage medium or transferred from one computer-readable storage medium to another, for example, the computer instructions can be transferred from one website, computer, server, or data center to another via a wired or wireless manner. The computer-readable storage medium can be any available medium accessible by a computer or a data storage device such as a server, data center, or the like, which includes one or more available medium collections. The available medium can be a magnetic medium (e.g., a floppy disk, a hard disk, a magnetic tape), an optical medium (e.g., a DVD), or a semiconductor medium. The semiconductor medium can be a solid state disk.

[0079] The embodiments of the present application also provide a computer storage medium, where the computer storage medium stores a computer program for electronic data exchange, and the computer program causes a computer to execute some or all steps of any method described in the above method embodiments, and the computer includes an electronic device.

[0080] The embodiment of the present application further provides a computer program product, which comprises a non-transitory computer-readable storage medium storing a computer program, and the computer program is operable to cause a computer to execute part or all of the steps of any method described in the above method embodiments. The computer program product can be a software installation package, and the computer comprises an electronic device.

[0081] It should be understood that, in various embodiments of the present application, the size of the sequence number of the above processes does not mean the order of execution, and the execution order of the processes should be determined according to its function and inherent logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0082] In several embodiments provided in the present application, it should be understood that the disclosed methods, devices and systems can be implemented in other ways. For example, the above-described device embodiments are only schematic; for example, the division of the units is only a logical function division, and actual implementation can have another division manner; for example, a plurality of units or components can be combined or integrated into another system, or some features can be omitted or not executed. In addition, the coupling or direct coupling or communication connection between the units shown or discussed can be indirect coupling or communication connection through some interface, device or unit, and can be electrical, mechanical or other forms.

[0083] The units described as separate components can or can not be physically separated, and the components shown as units can or can not be physical units, that is, they can be located in one place, or can be distributed on a plurality of network units. According to actual needs, part or all of the units can be selected to achieve the purpose of the present embodiment.

[0084] In addition, each functional unit in each embodiment of the present application can be integrated in one processing unit, or each unit can be physically included separately, or two or more units can be integrated in one unit. The integrated unit can be realized in the form of hardware, or in the form of hardware plus software functional unit.

[0085] The integrated unit implemented in the form of software functional units can be stored in a computer readable storage medium. The software functional unit is stored in a storage medium, including a plurality of instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute part of the steps of the method described in various embodiments of the present application. The aforementioned storage medium includes a U disk, a mobile hard disk, a magnetic disk, an optical disk, a volatile memory or a non-volatile memory. The non-volatile memory can be a read-only memory (ROM), a programmable read-only memory (PROM), an erasable programmable read-only memory (EPROM), an electrically EPROM (EEPROM) or a flash memory. The volatile memory can be a random access memory (RAM) used as an external cache. By way of example but not limitation, many forms of random access memory (RAM) can be used, such as static random access memory (SRAM), dynamic random access memory (DRAM), synchronous dynamic random access memory (SDRAM), double data rate SDRAM (DDR SDRAM), enhanced SDRAM (ESDRAM), synchlink DRAM (SLDRAM) and direct rambus RAM (DR RAM). Various media that can store program codes.

[0086] Although the present application is disclosed as above, the present application is not limited thereto. Any person skilled in the art can easily think of changes or replacements without departing from the spirit and scope of the present application, and various modifications can be made, including combinations of different functions and implementation steps, including software and hardware implementations, which are all within the protection scope of the present application.

Claims

1. A method of configuring a data field, characterized by, The method applied to an electronic device comprises: determining a first field to be configured; determining attribute content required for configuration of the first field; selecting at least one preset table according to the attribute type of the attribute content, the preset table comprising a field description master table, an enumerated type value table, a cascading relationship table and an administrative division table, the field description master table being used for setting and storing configuration information, the enumerated type value table being used for setting and storing option content of a multiple selection field, the cascading relationship table being used for setting and storing a hierarchical relationship existing in the field, and the administrative division table being used for storing national administrative division information; performing attribute configuration on the first field according to the at least one preset table, and updating the at least one preset table to obtain a second field; obtaining user data records input by a product user and a third field corresponding to the user data records; judging whether the third field is a standard field; obtaining attribute content of the third field according to the third field; judging whether the attribute content of the third field can be contained by attribute content in the preset table; if the judgment is yes, judging that the third field is the standard field; if the judgment is no, judging that the third field is an extended field; if the judgment is yes, storing the user data records in a standard table; if the judgment is no, storing the user data records in an extended table, the extended table and the standard table being stored in a database.

2. The method of claim 1, wherein, Before the determination of the first field to be configured, the method further comprises: configuring a first field through the preset table, and updating the preset table; saving the preset table to a database.

3. The method of claim 2, wherein, The configuration of the first field through the preset table comprises the following steps: configuring the first field by filling in content of the configuration information in the field description master table; adding a multiple selection function to the first field by inputting option content into the enumerated type value table; setting a hierarchical relationship between the first field and other fields through the cascading relationship table; adding a region selection function to the first field through the administrative division table; outputting the first field.

4. The method of claim 2, wherein, After the saving of the preset table to the database, the method further comprises: displaying the configured field as a filtering condition for user selection according to preset rules used by the user; directly calling a corresponding preset table of a field selected by the user from the database; directly configuring a generated field according to the corresponding preset table.

5. A data field configuration apparatus characterized by comprising: The device applied to an electronic device comprises: a field determination unit configured to determine a first field to be configured; an attribute content determination unit configured to determine attribute content required for configuration of the first field; a preset table determination unit configured to select at least one preset table according to the attribute type of the attribute content, the preset table comprising a field description master table, an enumerated type value table, a cascading relationship table and an administrative division table, the field description master table being used for setting and storing configuration information, the enumerated type value table being used for setting and storing option content of a multiple selection field, the cascading relationship table being used for setting and storing a hierarchical relationship existing in the field, and the administrative division table being used for storing national administrative division information; The dynamic configuration unit is configured to configure attributes of the first field according to the at least one preset table, and update the at least one preset table to obtain a second field; obtaining a user data record input by a product user and a third field corresponding to the user data record; judging whether the third field is a standard field; obtaining attribute content of the third field according to the third field; judging whether the attribute content of the third field can be contained in attribute content in the preset table; if the judgment is yes, judging that the third field is the standard field; if the judgment is no, judging that the third field is an extended field; if the judgment is yes, storing the user data record into a standard table; if the judgment is no, storing the user data record into an extended table, the extended table and the standard table being stored in a database.

6. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, The processor executes the computer program to implement the steps of the method according to any one of claims 1 to 4.

7. A computer-readable storage medium storing a computer program, wherein the computer program comprises the following steps of: receiving a request for a resource from a client; determining whether the client is authorized to access the resource; and if the client is authorized to access the resource, providing the resource to the client. The computer program is executed by the processor to implement the steps of the method according to any one of claims 1 to 4.

Citation Information

Patent Citations

  • Method and device for configuring field attribute

    CN102819547A

  • Business system field configuration method and device, server and readable storage medium

    CN108334534A

  • Field management method and device, computer equipment and storage medium

    CN110297823A

  • Multi-Client Generic Persistence for Extension Fields

    US20110153576A1