CN105302814A - Method and system for storing multiple custom fields - Google Patents
Method and system for storing multiple custom fields Download PDFInfo
- Publication number
- CN105302814A CN105302814A CN201410276834.5A CN201410276834A CN105302814A CN 105302814 A CN105302814 A CN 105302814A CN 201410276834 A CN201410276834 A CN 201410276834A CN 105302814 A CN105302814 A CN 105302814A
- Authority
- CN
- China
- Prior art keywords
- data
- data type
- type
- rows
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 31
- 238000013507 mapping Methods 0.000 claims abstract description 37
- 238000013461 design Methods 0.000 claims abstract description 32
- 230000007246 mechanism Effects 0.000 claims description 18
- 238000001514 detection method Methods 0.000 claims description 10
- 238000012545 processing Methods 0.000 abstract description 4
- 230000009466 transformation Effects 0.000 abstract 1
- 239000003550 marker Substances 0.000 description 6
- 230000008569 process Effects 0.000 description 4
- 238000006243 chemical reaction Methods 0.000 description 3
- 238000012217 deletion Methods 0.000 description 3
- 230000037430 deletion Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 239000000203 mixture Substances 0.000 description 3
- 102100024452 DNA-directed RNA polymerase III subunit RPC1 Human genes 0.000 description 2
- 101000689002 Homo sapiens DNA-directed RNA polymerase III subunit RPC1 Proteins 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000012938 design process Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000009885 systemic effect Effects 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a method and a system for storing a plurality of custom fields. The method comprises: defining a database table with N data columns and a table structure information; using a custom data field name and a specified data type of a design user as parameter values and transmitting the custom data field name and the specified data type of the design user to a mapping function; and according to a mapping rule, defining a first data field name and a first data type for the design user, and defining a second data field name and a second data type for the design user. According to the present invention, data records correspond to the correct data types and format transformation does not need to be carried out during data processing; the method and the system are convenient for the user to query data quickly, the user does not need to traverse all the data, query efficiency is high, and the method and the system are applicable to data query with a large data volume; flexibility of the user-defined field for the design user is increased, form, web page or application can all be designed from scratch by the user, and changed if necessary.
Description
Technical field
The present invention relates to data processing field and store custom field technology, particularly a kind of method and system storing multiple custom field.
Background technology
The development of science and technology has promoted the variation of user's request, and user recognizes that general system cannot meet the business demand of its personalization gradually in the process using software.So user starts to consider to use the software customized, user's request, by demand analysis, is combined the application software designed and be more close to the users by software developer with software feature.But, if customer service frequently changes or newly increased requirement, customized software often needs frequently to change according to demand, adds the fund cost of user on the one hand, user may take other softwares with the use of mode, this has deviated from the original intention of customized software undoubtedly; On the other hand, user feedback demand, exploitation and debugging software need the regular hour, affect the business processing mode of user.
For the situation that software requirement often changes, existing way mainly contains:
On-the-fly modify table, insert newer field, this way can realize in the simple situation of list structure, if the very large and table often variation of data volume, so by on-the-fly modifying the non-constant of mode performance of table;
Use vertical table, add a record in vertical table, just can add a field, but when execution data query for the query statement more complicated of vertical table and search efficiency is not high, the situation that same inapplicable data volume is large;
Reserved field, the null field fixedly reserving some when design table allows user's designed, designed when needed, but reserved field likely can be used never, or not enough, still faces the problem increasing field in the end; And standards entities and field portions cannot be changed;
Application number is the patent of invention of " for multiple tenant stores the method and system of custom field in the multi-tenant database system " of 200580009510.4, this invention proposes the method holding the such as changeable mode such as dynamic table and row data in fixed physical database schema, many tenants custom field is stored in the single field in object data structure, and this single field can comprise different data types to each tenant.Solve user and add themselves self-defining data except the standards entities of standard application outfit and field to Database Systems.But in the method, the data value storage of different user data field, in individual data row, when especially data type is not identical, needs the step through format conversion, reducing the efficiency of inquiry when inquiring about.
Therefore, expect to there is a kind of method, they both can realize user according to business demand custom field content, can take into account data access performance again.
Summary of the invention
For current Problems existing, the invention provides a kind of method and system storing multiple custom field, realize the pre-defined data rows comprising fixed qty data type, and dynamically increase newly or prompting message when definable data rows quantity reaches threshold values, by designing user sets itself.
The invention provides a kind of method storing multiple custom field, comprising:
Definition has database table and the list structure information of N number of data rows, and the kind of the data type of the N number of data rows of described database table comprises { Χ
1, Χ
2..., Χ
m, and the data rows quantity of often kind of data type is { Y
1, Y
2..., Y
m, i.e. Y
1+ Y
2+ ... + Y
m=N, wherein, the kind inequality of data type, 1≤m≤N;
The self-defining data field name of designing user and specified data type are passed to mapping function as parameter value;
According to mapping ruler, for designing user defines the first Data field names and the first data type, and define the second Data field names and the second data type for designing user, described mapping ruler comprises:
According to the first data type, in list structure information, find corresponding data type X
idata rows information, wherein 1≤i≤m;
According to the second data type, in list structure information, find corresponding data type X
jdata rows information, wherein 1≤j≤m;
During i ≠ j, the first data type is different from the second data type, and the first Data field names is stored to X
idata rows corresponding in list structure information, is stored to X by the second Data field names
jdata rows corresponding in list structure information;
During i=j, the first data type is identical with the second data type, and the first Data field names and the second Data field names are stored to X successively
idata rows corresponding in list structure information.
Wherein, data field and custom field.Because different program languages has different features, difference is more or less had during definition data type name, therefore adopt X in summary of the invention to identify technician in the field of being convenient to understand, any diacritic symbolic can be used, be not limited to this expression way.Equally, the quantity N of data rows, the quantity Y of the data rows that data type is corresponding, wherein N, Y is positive integer, and N is greater than 1, in this definition step the numerical value of N, Y preferably by designing user according to business characteristic sets itself, also can be that N is determined by system, Y be set according to business characteristic by designing user.
List structure information comprises design Table I D (Identity), custom field title, data type, corresponding data column number.The existing way of list structure information comprises: as Database Systems object, as external resource files.First data type and second data type of designing user design can be identical data types, can be also different data types, applicable equally when defining other custom field data types.
Preferably, also comprise detection and can customize data type X
i, X
jdata rows quantity whether reach threshold values condition, if reached, trigger early warning mechanism.
Preferred further, described threshold values condition refers to that the data rows quantity that can customize data type reaches a certain limit value, or, there is no the corresponding data type that can customize.
Preferred further, described early warning mechanism comprises:
According to each increasable data rows quantity preset, the dynamically newly-increased data rows quantity reaching the data type of threshold values, or, send reminder message to designing user.
For the data rows quantity of data type reaching threshold values condition, more preferably adopt the data rows dynamically increasing some the type; Or send prompting to designing user, prompting can also the data field of self-defined this data type several again, or reach limit value and cannot complete custom field.
Preferably, also comprising according to the mapping relations of list structure message reflection is that user is at database table access data record.User, by using the custom content of design, carries out the operation of data record, comprises and increases data, deletion data, Update Table, data query.
The invention provides a kind of system storing multiple custom field, comprising:
Pretreatment module, for defining the database table and list structure information with N number of data rows, the kind of the data type of the N number of data rows of described database table comprises { Χ
1, Χ
2..., Χ
m, and the data rows quantity of often kind of data type is { Y
1, Y
2..., Y
m, i.e. Y
1+ Y
2+ ... + Y
m=N, wherein, the kind inequality of data type, 1≤m≤N;
Design module, for designing user self-defining data field name and specified data type;
Mapping block, for being passed to mapping function using the self-defining data field name of designing user and specified data type as parameter value;
Definition module, for according to mapping ruler, for designing user defines the first Data field names and the first data type, and define the second Data field names and the second data type for designing user, described mapping ruler comprises:
According to the first data type, in list structure information, find corresponding data type X
idata rows information, wherein 1≤i≤m;
According to the second data type, in list structure information, find corresponding data type X
jdata rows information, wherein 1≤j≤m;
During i ≠ j, the first data type is different from the second data type, and the first Data field names is stored to X
idata rows corresponding in list structure information, is stored to X by the second Data field names
jdata rows corresponding in list structure information;
During i=j, the first data type is identical with the second data type, and the first Data field names and the second Data field names are stored to X successively
idata rows corresponding in list structure information.
Preferably, also comprising detection module, can customize data type X for detecting
i, X
jdata rows quantity whether reach threshold values condition, if reached, trigger early warning mechanism.Threshold values condition and early warning mechanism need preset before execution detection module, can set in advance in predefine module or set at design module.
Preferred further, described threshold values condition refers to that the data rows quantity that can customize data type reaches a certain limit value, or, there is no the corresponding data type that can customize.
Preferred further, described early warning mechanism comprises:
According to each increasable data rows quantity preset, the dynamically newly-increased data rows quantity reaching the data type of threshold values, or, send reminder message to designing user.
Preferably, also comprising data access module, is that user is at database table access data record according to the mapping relations of list structure message reflection.User, by using the custom content of designing user design, carries out the operation of data record, comprises and increases data, deletion data, Update Table, data query.
The beneficial effect that technical solution of the present invention is brought is: the data type that data record is corresponding correct, does not need through format conversion when carrying out data processing; Person's fast query data easy to use, without the need to traveling through all data, search efficiency is high, the data query that applicable data amount is large; Adding the dirigibility of designing user custom field, can grow out of nothing whole designed, designed list, webpage or application, becoming with needing.
Accompanying drawing explanation
Fig. 1 is a kind of process flow diagram storing the method for multiple custom field that the embodiment of the present invention provides;
Fig. 2 a is the method example one of the multiple custom field of storage that the embodiment of the present invention provides;
Fig. 2 b is the method example two of the multiple custom field of storage that the embodiment of the present invention provides;
Fig. 3 a is the example being expressed as list structure information that the embodiment of the present invention provides;
Fig. 3 b is the concrete example of the list structure information that is expressed as that the embodiment of the present invention provides;
Fig. 4 is that the custom field that the embodiment of the present invention provides has designed the concrete example of rear access data;
Fig. 5 is the system construction drawing that the embodiment of the present invention provides;
Fig. 6 a is a kind of calcspar one storing the system of multiple custom field that the embodiment of the present invention provides;
Fig. 6 b is a kind of calcspar two storing the system of multiple custom field that the embodiment of the present invention provides.
Embodiment
Mention to make the present invention a kind of store multiple custom field method and system and advantage clearly clear and definite, referring to accompanying drawing, the present invention is further described in detail.Should be appreciated that specific embodiment described herein only in order to explain the present invention, be not intended to limit the present invention.
Fig. 1 is a kind of process flow diagram storing the method for multiple custom field that the embodiment of the present invention provides, and as shown in Figure 1, the method comprises:
Step 101, definition has database table and the list structure information of N number of data rows.
Wherein, need consider when designing user or system definition that a people defines and define situation for many people for single and a people.One people defines and refers to that designing user is a people for single, and user is also a people, and that define and use can be same people, also can be different people; One people defines and refers to that designing user is a people for many people, and user is many people, and preferably, designing user need consider definition user ID (Identity), different users is made a distinction.
List structure information preferably leaves in database table as during Database Systems object; List structure information is as the file type being preferably xml form, txt form, ini form during external resource files.
Step 102, is passed to mapping function using the custom field title of designing user and specified data type as parameter value.
Self-defining for designing user front end field name is passed to mapping function with the data type of specifying as parameter value and carries out mapping process.
Step 103, detects the data rows quantity that can customize data type and whether reaches threshold values condition.
Adopt detecting step, preferred designing user need set the threshold values of data rows quantity corresponding to definable data type in advance when self-defined, the threshold values of various data type can be identical, such as definable data type { character type, numeric type, date type, picture type, long text-type } data rows quantity threshold values be { 2, 2, 2, 2, 2} or { 0, 0, 0, 0, 0}, also can be that different threshold values is set according to the usage frequency of data type, such as definable data type { character type, numeric type, date type, picture type, long text-type } data rows quantity threshold values be { 5, 5, 2, 2, 1}.When the data rows quantity of definable data type reaches threshold values, namely satisfy condition "Yes", performs step 104; Otherwise satisfy condition "No", perform step 105.
Step 104, triggers early warning mechanism.
When the data rows quantity of definable data type reaches threshold values, trigger early warning mechanism.The data type reaching threshold values is preferably adopted to the data rows dynamically increasing some, or user is initiated a message promptings or the form of both combinations.Again early warning mechanism is triggered when again reaching threshold values in use procedure.
The setting of threshold values condition and early warning mechanism also can be default, preferably adopts the mode of designing user sets itself.
Step 105, according to mapping ruler, is designing user define field title and data type.
According to the data type of designing user custom field, in list structure information, find the information of corresponding data rows, comprise the row number of definable data rows quantity and correspondence thereof.The self-defined multiple field of designing user, data type comprises same data type and different types of data, according to mapping ruler, stores custom field title successively to corresponding data rows.
Step 103 and step 104 are preferred steps, decide whether adopt this two steps in its sole discretion by designing user.
Fig. 2 a is the method example one of the multiple custom field of storage that the embodiment of the present invention provides, as shown in the figure, initialization definitions has the database table T200 of 160 column data row in a database, this data rows is also referred to as self-defining data row, custom field row, custom field, comprise: 50 column data types are the data rows 201 of character type, and column number is from C1 to C50; 50 column data types are the data rows 202 of numeric type, and column number is from C51 to C100; 30 column data types are the data rows 203 of date type, and column number is from C101 to C130; 20 column data types are the data rows 204 of picture type, and column number is from C131 to C150; 10 column data types are the data rows 205 of long text-type, and column number is from C151 to C160.This embodiment is different according to the usage frequency of data type, by conventional data type many definition some when initialization, the data type be of little use is defined some less when initialization.
In addition, be not limited to the data type that Fig. 2 a mentions when designing user is self-defined, designing user can increase or reduce the kind of data type; Also can adjust according to the data rows quantity of practical business type to data type when designing user is self-defined; Designing user also can adjust numbering, such as character type column number A1-A50, numeric type column number B1-B50, date type column number C1-C30, picture type column number D1-D20, long text-type column number E1-E10.All data rows are all empty before the use, do not take any physical space.If designing user deletes the field of certain defined mistake, detect this field whether individualism, if individualism, direct delete data record and data rows, if there is association, then need first to delete associated data record, then perform and delete data rows operation; Or only perform the operation emptying data record, data rows is reusable.
Fig. 3 a is the example being expressed as list structure information that the embodiment of the present invention provides, as shown in Figure 3 a, list structure information T300 comprises T_ID (design Table I D (Identity)) 301, FIELD_NAME (custom field title) 302, DATA_TYPE (data type) 303, COL_NUM (corresponding data column number) 304, F_MARKER (field mark) 305.
The present embodiment list structure information comprises F_MARKER (field mark) to distinguish the situation that in design process, multiple custom field title is identical, is further preferred form.For convenience of explanation, list structure information shows as the form of table in the present embodiment, but is not limited to this kind of form, also can be the file of other types.If there is multiple user, then designing user need increase field USER_ID (user ID (Identity)) in list structure information, further consideration, if having hierarchical relationship between multiple user, then must consider to add priority assignation.
So that in table 1 employee table (T1), custom field is for object lesson, composition graphs 2a and Fig. 3 a, carries out further description to self-defined multiple field.
Table 1 employee shows (T1)
| Field name | Data type | Field name | Data type |
| Job number (ID) * | Character type | Name | Character type |
| Sex | Character type | Photo | Picture type |
| ID (identity number) card No. | Character type | Department | Character type |
| Position | Character type | Basic wage | Numeric type |
| Position wage | Numeric type | Basis bonus | Numeric type |
| The registration date | Date type | Leave office the date | Date type |
First Data field names is " job number (ID) ", and " * " represents required item, and the job number ID (Identity) of each employee is unique number.First data type is character type, and according to mapping ruler, the list structure information provided at Fig. 3 a is searched, definable DATA_TYPE is the COL_NUM of character type is C1 ..., C50, be stored in below FIELD_NAME corresponding to C1 by " job number (ID) ", F_MARKER value is m
1; Second Data field names is " name ", second data type is character type, according to mapping ruler, the list structure information provided at Fig. 3 a is searched, definable DATA_TYPE is the COL_NUM of character type is C2 ..., C50, " name " be stored in below FIELD_NAME corresponding to C2, F_MARKER value is m
2; 3rd Data field names is " sex ", 3rd data type is character type, according to mapping ruler, the list structure information provided at Fig. 3 a is searched, definable DATA_TYPE is the COL_NUM of character type is C3 ..., C50, " sex " be stored in below FIELD_NAME corresponding to C3, F_MARKER value is m
3; 4th Data field names is " photo ", 4th data type is picture type, according to mapping ruler, the list structure information provided at Fig. 3 a is searched, definable DATA_TYPE is the COL_NUM of picture type is C131 ..., C150, " photo " be stored in below FIELD_NAME corresponding to C131, F_MARKER value is m
4.Other field informations are stored in list structure information according to identical rule successively, and as shown in Figure 3 b, Fig. 3 b is the concrete example of the list structure information that is expressed as that the embodiment of the present invention provides to the situation after employee's table (T1) stores.
Fig. 2 b is the method example two of the multiple custom field of storage that the embodiment of the present invention provides, as shown in the figure, the database table T200' of initialization definitions 160 column data row, comprising: 50 column data types are the data rows 201 of character type, and column number is from C1 to C50 in a database; 50 column data types are the data rows 202 of numeric type, and column number is from C51 to C100; 30 column data types are the data rows 203 of date type, and column number is from C101 to C130; 20 column data types are the data rows 204 of picture type, and column number is from C131 to C150; 10 column data types are the data rows 205 of long text-type, and column number is from C151 to C160.Contain unlike, Fig. 2 b the data rows 206 that the 10 column data types dynamically increased are character type with Fig. 2 a, associative list 2 carries out further description.
Table 2 threshold values condition
| Data type | Threshold values conditional value | Dynamic expansion amount |
| Character type | 2 | 10 |
| Numeric type | 2 | 10 |
| Date type | 2 | 5 |
| Picture type | 2 | 5 |
| Long text-type | 2 | 3 |
The present embodiment adopts unified threshold values condition to all data types, namely triggers early warning mechanism, for the data rows of each dynamic extending of character type 10 character types when the data rows quantity of the data type that can customize is less than or equal to 2; For the data rows of each dynamic extending of numeric type 10 numeric types; For each dynamic extending of date type 5 date type data rows; For the data rows of each dynamic extending of picture type 5 picture type; For the long text-type data rows of each dynamic extending of long text-type 3.Be appreciated that the data rows quantity that character type 201 can customize reaches threshold values condition by Fig. 2 b, trigger early warning mechanism, therefore the data rows of dynamic expansion 10 character types.Designing user also according to practical business situation adjustment threshold values condition, can comprise the data rows quantity of threshold values conditional value and dynamic expansion.
Fig. 4 is that the custom field that the embodiment of the present invention provides has designed the concrete example of rear access data, composition graphs 3b, as shown in the figure, user adopts the database table T400 of design content typing four data of designing user, wherein data rows C1 is required item, job number (ID) must be filled out, and other data rows contents are non-required item.Can verify with further Optimal performance to some data rows, such as, figure place checking be carried out to the ID (identity number) card No. in data rows C4, data rows C101, C102 date typing is limited etc.The present embodiment is not distinguished user's information, and when multiple user uses this design access data, designing user need be considered to increase user ID (Identity), manages the data record of different users.
For the data in the embodiment that Fig. 4 provides, if choose certain data to delete, first check under preferable case if whether these data are and other data correlations, association, can not delete, or user is initiated a message to remind to determine whether continue to delete by user; If only use certain column data, then only inquire about this column data, other incoherent data are without the need to traversal, such as, extract worker and demonstrate,prove number, the data rows inquiring ID (identity number) card No. corresponding in list structure information is numbered C4, perform SQL query statement " selectC4fromT1 " and all identification card number code datas can be found in a database: " 123456789 ", " 321587468 ", " 456123897 ", " 582369741 ".
Fig. 5 is the system construction drawing that the embodiment of the present invention provides, and as shown in the figure, this embodiment is by designing end 52, and network 54, server 56, use side 58 is formed.Design end 52 can be desktop computer, notebook, pad, smart mobile phone, PDA, designs the quantity of end 52 in addition and is not limited to single, multiple designing user can Joint Designing list, a webpage or an application; Network 54 can be LAN (Local Area Network), only in a certain region user access and, can be also wide area network, provide access port to user, realization access at a distance.In particular cases, designing user carries out self-definition design by means of only design end 52, then designing end 52 for user, does not externally share; The design content of server 56 design Storage user, in view of the requirement stored data is different, this server can be internal server, is safeguarded by designing user oneself or tissue.Also can be the cloud server that third party provides separately, third party cooperates with numerous user, independent operation.This server also can carry out record to user's access data; More than one under use side 58 preferable case, and can be desktop computer, notebook, pad, smart mobile phone, PDA, the user of use side cannot change design content.
Fig. 6 a is a kind of calcspar one storing the system of multiple custom field that the embodiment of the present invention provides, and as shown in the figure, this system comprises pretreatment module 62, design module 64, mapping block 66, definition module 68.Pretreatment module 62 is for defining the database table and list structure information with N number of data rows, and wherein the numerical value of N can be set according to business characteristic by designing user, also can be the value that system is fixed; Self-defining for designing user Data field names, for designing user self-defining data field name and specified data type, is passed to mapping block 66 with the data type of specifying as parameter value simultaneously and maps by design module 64; Mapping block 66 is bridges that custom content realizes conversion; According to mapping ruler, at definition module 68, self-defining for designing user Data field names and the data type of specifying are stored into corresponding data rows in list structure information.
Fig. 6 b is a kind of calcspar two storing the system of multiple custom field that the embodiment of the present invention provides, as shown in the figure, this system comprises pretreatment module 62, design module 64, mapping block 66, detection module 67, definition module 68, data access module 69, wherein, pretreatment module 62 comprises predefined database table and list structure message unit 621, pre-set threshold value and alarm mode unit 622.Differently from Fig. 6 a be, the present embodiment adds detection module 67 and data access module 69 simultaneously, and whether detection module 67 reaches threshold values condition for detecting the data rows quantity that can customize data type, if reached, triggers early warning mechanism.For realizing early warning mechanism, in pretreatment module 62, add pre-set threshold value and alarm mode unit 622 accordingly to make detection module 67 can work well.
Pretreatment module 62 comprises predefined database table and list structure message unit 621, pre-set threshold value and alarm mode unit 622.Predefined database table and list structure message unit 621 are for defining the database table and list structure information with N number of data rows, for N number of data rows distributes data type, optimal way is that conventional data type can distribute more data rows quantity, and the data type be of little use distributes less data rows quantity.N is set by systemic presupposition or designing user, and data rows quantity is preferably set by designing user; Pre-set threshold value and alarm mode unit 622, preferably operate this unit by designing user, the numerical value of designing user sets itself threshold values, namely the data rows quantity of definable data type reaches a certain limit value, alarm mode comprises the data rows quantity that automatic expansion reaches threshold values, or to initiate a message prompting to designing user.
Design module 64, for designing user self-defining data field name and specified data type, user completes the interface of custom field content by design module 64.
Mapping block 66 is for being passed to mapping function using self-defining for designing user Data field names and the data type of specifying as parameter value.
Whether detection module 67 reaches threshold values condition for the self-defining data field name that detects mapping block 66 and transmit and data rows quantity corresponding to the data type of specifying, if reached, triggers early warning mechanism, starts early warning.
Definition module 68 for the Data field names that defines for designing user and corresponding data type in list structure information and database table set up contact, successively Data field names is stored to the data rows that in list structure information, corresponding data type is corresponding.
Data access module 69, for user at database table access data, comprises and increases data, deletion data, Update Table, data query.
Composition graphs 5, Fig. 6 a and the system described in Fig. 6 b have following several use-pattern: can be arranged on the design end 52 shown in Fig. 5, directly used at design end 52 by user, design end 52 and use side 58 overlap, or the user of use side 58 uses URL (UniformResourceLocator: uniform resource locator) to access design end 52 by network 54; Can be arranged on server 56, the user of use side 58 uses URL (UniformResourceLocator: uniform resource locator) by network 54 access services device 56, by the data record of server 56 unified management user; Data record is arranged on use side 58, manages its data record voluntarily by user.
The above is to preferably embodiment of the present invention, and the art personnel should be appreciated that described embodiment and non-limiting protection scope of the present invention.Do not departing under Spirit Essence of the present invention and principle, can carry out changing or revising in details, all should be encompassed within right of the present invention.
Claims (10)
1. store a method for multiple custom field, it is characterized in that, comprising:
Definition has database table and the list structure information of N number of data rows, and the kind of the data type of the N number of data rows of described database table comprises { Χ
1, Χ
2..., Χ
m, and the data rows quantity of often kind of data type is { Y
1, Y
2..., Y
m, i.e. Y
1+ Y
2+ ... + Y
m=N, wherein, the kind inequality of data type, 1≤m≤N;
The self-defining data field name of designing user and specified data type are passed to mapping function as parameter value;
According to mapping ruler, for designing user defines the first Data field names and the first data type, and define the second Data field names and the second data type for designing user, described mapping ruler comprises:
According to the first data type, in list structure information, find corresponding data type X
idata rows information, wherein 1≤i≤m;
According to the second data type, in list structure information, find corresponding data type X
jdata rows information, wherein 1≤j≤m;
During i ≠ j, the first data type is different from the second data type, and the first Data field names is stored to X
idata rows corresponding in list structure information, is stored to X by the second Data field names
jdata rows corresponding in list structure information;
During i=j, the first data type is identical with the second data type, and the first Data field names and the second Data field names are stored to X successively
idata rows corresponding in list structure information.
2. the method for claim 1, is characterized in that, also comprises detection and can customize data type X
i, X
jdata rows quantity whether reach threshold values condition, if reached, trigger early warning mechanism.
3. method as claimed in claim 2, it is characterized in that, described threshold values condition refers to that the data rows quantity that can customize data type reaches a certain limit value, or, there is no the corresponding data type that can customize.
4. method as claimed in claim 2, it is characterized in that, described early warning mechanism comprises:
According to each increasable data rows quantity preset, the dynamically newly-increased data rows quantity reaching the data type of threshold values, or, send reminder message to designing user.
5. the method as described in any one of Claims 1-4, is characterized in that, also comprising according to the mapping relations of list structure message reflection is that user is at database table access data.
6. store a system for multiple custom field, it is characterized in that, comprising:
Pretreatment module, for defining the database table and list structure information with N number of data rows, the kind of the data type of the N number of data rows of described database table comprises { Χ
1, Χ
2..., Χ
m, and the data rows quantity of often kind of data type is { Y
1, Y
2..., Y
m, i.e. Y
1+ Y
2+ ... + Y
m=N, wherein, the kind inequality of data type, m≤N;
Design module, for designing user self-defining data field name and specified data type;
Mapping block, for being passed to mapping function using the self-defining data field name of designing user and specified data type as parameter value;
Definition module, for according to mapping ruler, for designing user defines the first Data field names and the first data type, and define the second Data field names and the second data type for designing user, described mapping ruler comprises:
According to the first data type, in list structure information, find corresponding data type X
idata rows information, wherein 1≤i≤m;
According to the second data type, in list structure information, find corresponding data type X
jdata rows information, wherein 1≤j≤m;
During i ≠ j, the first data type is different from the second data type, and the first Data field names is stored to X
idata rows corresponding in list structure information, is stored to X by the second Data field names
jdata rows corresponding in list structure information;
During i=j, the first data type is identical with the second data type, and the first Data field names and the second Data field names are stored to X successively
idata rows corresponding in list structure information.
7. system as claimed in claim 6, is characterized in that, also comprise detection module, can customize data type X for detecting
i, X
jdata rows quantity whether reach threshold values condition, if reached, trigger early warning mechanism.
8. system as claimed in claim 7, it is characterized in that, described threshold values condition refers to that the data rows quantity that can customize data type reaches a certain limit value, or, there is no the corresponding data type that can customize.
9. system as claimed in claim 7, it is characterized in that, described early warning mechanism comprises:
According to each increasable data rows quantity preset, the dynamically newly-increased data rows quantity reaching the data type of threshold values, or, send reminder message to designing user.
10. the system as described in any one of claim 5 to 9, is characterized in that, also comprises data access module, is that user is at database table access data according to the mapping relations of list structure message reflection.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410276834.5A CN105302814A (en) | 2014-06-20 | 2014-06-20 | Method and system for storing multiple custom fields |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410276834.5A CN105302814A (en) | 2014-06-20 | 2014-06-20 | Method and system for storing multiple custom fields |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105302814A true CN105302814A (en) | 2016-02-03 |
Family
ID=55200090
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410276834.5A Pending CN105302814A (en) | 2014-06-20 | 2014-06-20 | Method and system for storing multiple custom fields |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105302814A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106528810A (en) * | 2016-11-18 | 2017-03-22 | 党玉龙 | Method for integrating heterogeneous data to facilitate rapid big data analysis |
| CN110069486A (en) * | 2017-09-27 | 2019-07-30 | 北京国双科技有限公司 | A kind of method and device storing custom parameter |
| CN110417863A (en) * | 2019-06-27 | 2019-11-05 | 华为技术有限公司 | Generate method and apparatus, identity authentication method and the device of identity code |
| CN111061742A (en) * | 2019-12-25 | 2020-04-24 | 北京数起科技有限公司 | Method and device for marking data and service system thereof |
| CN112835886A (en) * | 2019-11-25 | 2021-05-25 | 浙江大搜车软件技术有限公司 | Data table field adding method and device |
| CN116955358A (en) * | 2023-07-27 | 2023-10-27 | 合众人寿保险股份有限公司 | A form data storage method, device, equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101120337A (en) * | 2004-04-02 | 2008-02-06 | 易享信息技术（上海）有限公司 | Custom entities and fields in a multi-tenant database system |
| CN101739453A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Method and device for carrying out condition query on database table |
| CN101763283A (en) * | 2010-01-26 | 2010-06-30 | 上海交通大学 | Automatic generation method for compensating transaction under network environment |
| CN102004953A (en) * | 2010-11-09 | 2011-04-06 | 浪潮集团山东通用软件有限公司 | Method for realizing multi-dimensional overall budget |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| CN103077185A (en) * | 2012-12-18 | 2013-05-01 | 厦门雅迅网络股份有限公司 | Object-based user-defined information-expanding method |
| CN103164323A (en) * | 2011-12-09 | 2013-06-19 | 深圳市腾讯计算机系统有限公司 | Data automatic generation method and data automatic generation system |
| CN103631570A (en) * | 2012-08-21 | 2014-03-12 | 镇江雅迅软件有限责任公司 | Form self-definition method |
-
2014
- 2014-06-20 CN CN201410276834.5A patent/CN105302814A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101120337A (en) * | 2004-04-02 | 2008-02-06 | 易享信息技术（上海）有限公司 | Custom entities and fields in a multi-tenant database system |
| CN101777057A (en) * | 2004-04-02 | 2010-07-14 | 易享信息技术（上海）有限公司 | Methods and systems for storing customer fields for multiple tenants in multi-tenant database system |
| CN101739453A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Method and device for carrying out condition query on database table |
| CN101763283A (en) * | 2010-01-26 | 2010-06-30 | 上海交通大学 | Automatic generation method for compensating transaction under network environment |
| CN102004953A (en) * | 2010-11-09 | 2011-04-06 | 浪潮集团山东通用软件有限公司 | Method for realizing multi-dimensional overall budget |
| CN103164323A (en) * | 2011-12-09 | 2013-06-19 | 深圳市腾讯计算机系统有限公司 | Data automatic generation method and data automatic generation system |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| CN103631570A (en) * | 2012-08-21 | 2014-03-12 | 镇江雅迅软件有限责任公司 | Form self-definition method |
| CN103077185A (en) * | 2012-12-18 | 2013-05-01 | 厦门雅迅网络股份有限公司 | Object-based user-defined information-expanding method |
Non-Patent Citations (1)
| Title |
|---|
| 李洪波: "多租户环境下的数据存储模式和映射机制研究", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106528810A (en) * | 2016-11-18 | 2017-03-22 | 党玉龙 | Method for integrating heterogeneous data to facilitate rapid big data analysis |
| CN110069486A (en) * | 2017-09-27 | 2019-07-30 | 北京国双科技有限公司 | A kind of method and device storing custom parameter |
| CN110417863A (en) * | 2019-06-27 | 2019-11-05 | 华为技术有限公司 | Generate method and apparatus, identity authentication method and the device of identity code |
| CN110417863B (en) * | 2019-06-27 | 2021-01-29 | 华为技术有限公司 | Method and device for generating identification code, and method and device for identity authentication |
| CN112835886A (en) * | 2019-11-25 | 2021-05-25 | 浙江大搜车软件技术有限公司 | Data table field adding method and device |
| CN111061742A (en) * | 2019-12-25 | 2020-04-24 | 北京数起科技有限公司 | Method and device for marking data and service system thereof |
| CN111061742B (en) * | 2019-12-25 | 2021-01-12 | 北京数起科技有限公司 | Method and device for marking data and service system thereof |
| CN116955358A (en) * | 2023-07-27 | 2023-10-27 | 合众人寿保险股份有限公司 | A form data storage method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20230334030A1 (en) | System and method for slowly changing dimension and metadata versioning in a multidimensional database environment | |
| CN107402988B (en) | Distributed NewSQL database system and semi-structured data query method | |
| US11615142B2 (en) | Mapping and query service between object oriented programming objects and deep key-value data stores | |
| CN101876983B (en) | Method for partitioning database and system thereof | |
| US11263212B1 (en) | Dynamic partition selection | |
| CN105302814A (en) | Method and system for storing multiple custom fields | |
| McKenzie et al. | A weighted multi-attribute method for matching user-generated points of interest | |
| Wang et al. | Schema management for document stores | |
| US10275475B2 (en) | Scalable analysis platform for semi-structured data | |
| US10762068B2 (en) | Virtual columns to expose row specific details for query execution in column store databases | |
| CN110457341B (en) | Data aggregation method, device, computer equipment and storage medium | |
| US20150363435A1 (en) | Declarative Virtual Data Model Management | |
| US8631032B2 (en) | Mechanisms to persist hierarchical object relations | |
| US10650044B2 (en) | Method and apparatus for converting from a source database system to a destination database system | |
| CN104123346A (en) | Structural data searching method | |
| CN107229718A (en) | The method and apparatus for handling report data | |
| CN104699742A (en) | Extreme visualization enabling extension for large data sets | |
| CN112905600A (en) | Data query method and device, storage medium and electronic equipment | |
| US11023465B2 (en) | Cross-asset data modeling in multi-asset databases | |
| CN107103011B (en) | Method and device for realizing terminal data search | |
| CN110362630A (en) | Data managing method, device, equipment and computer readable storage medium | |
| CN104317964A (en) | Object-relational mapping method and system based on iBatis | |
| CN104714974A (en) | Method and device for parsing and reprocessing query statement | |
| US20140019473A1 (en) | Database View Modeling Using Existing Data Model | |
| US10824803B2 (en) | System and method for logical identification of differences between spreadsheets |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160203 |