CN109375900A - A kind of tables of data and data field name automatic generation - Google Patents
A kind of tables of data and data field name automatic generation Download PDFInfo
- Publication number
- CN109375900A CN109375900A CN201811200778.1A CN201811200778A CN109375900A CN 109375900 A CN109375900 A CN 109375900A CN 201811200778 A CN201811200778 A CN 201811200778A CN 109375900 A CN109375900 A CN 109375900A
- Authority
- CN
- China
- Prior art keywords
- name
- data
- chinese
- tables
- pinyin
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/10—Requirements analysis; Specification techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/73—Program documentation
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Library & Information Science (AREA)
- Document Processing Apparatus (AREA)
Abstract
The present invention relates to field of computer technology, and in particular to a kind of tables of data and data field name automatic generation, it includes that tables of data name is automatically generated and automatically generated with data field name；The name of tables of data and data field is all to capitalize addend word combination producing by the corresponding first letter of pinyin of Chinese；It uses in database table name and field name automatically generated with a kind of format of fixation, capitalize the combined and spliced generation name of addend word by choosing the corresponding first letter of pinyin of several Chinese, initials in chinese pinyin front two is chosen in data table name, data field name chooses first four, corresponding letter digit deficiency then mends 0, and three bit digitals spliced below are then to carry out from increasing in corresponding character set to generate；It, which has, can make the table name in project consistent with field name style, Uniform Name process, form Naming conventions, can facilitate the maintenance and secondary development in project later period.
Description
[technical field]
The present invention relates to field of computer technology, and in particular to a kind of tables of data and data field name the side of automatically generating
Formula.
[background technique]
In actual system item development process, since Team Member names habit different, lead to the tables of data of system
Very big difference is had with the name style of data field.
Common naming method has: being spliced English word with " _ ", is write a Chinese character in simplified form hump nomenclature etc. with " _ " to splice English
Deng.Existing for these modes one common disadvantage is that none determine rule come generate name, everyone is ok
According to the hobby of oneself come customized name.Such as: login username can generally be named as user_account, can also be with
It is named as user_name, and user_account and user_name are to meet above-mentioned naming method rule.And one
A English word can correspond to multiple English words.If document name can be named as file_name, can also be named as
Document_name, more succinct can name are as follows: f_name or d_name.If the English level of developer is not
Together, then can have the name of one of member, with group membership fail to understand its representative the meaning the case where.
Therefore find a kind of unified and standard tables of data and data field name automatic generation become it is urgently to be resolved
Problem.
[summary of the invention]
In view of the defects and deficiencies of the prior art, the present invention intends to provide a kind of tables of data and data field to name
Automatic generation.
A kind of tables of data of the present invention and data field name automatic generation, it includes that tables of data name is automatic
It generates and data field name automatically generates；The name of tables of data and data field is all by the corresponding first letter of pinyin of Chinese
Capitalize addend word combination producing.
Further, the naming method of tables of data, default are by the corresponding first letter of pinyin of Chinese name the first two Chinese
Capitalization plus three bit digitals generate, and three bit digital initial values are " 001 ".
Further, the naming method of data field, default are by the corresponding first letter of pinyin of Chinese first four Chinese
Capitalization plus three bit digitals generate, and three bit digital initial values are " 001 ".
Further, further include following two kinds of situations in addition to default situations when tables of data is named:
A) it when the corresponding first letter of pinyin capitalization of Chinese name the first two Chinese is identical, i.e., is searched for when generation tables of data is named
It is had existed in tables of data name character set to Pinyin abbreviation combination, such as the corresponding name of " user's table " existing in system
" YH001 ", the tables of data for adding one entitled " user extends information table " at this time detect " YH " character when generating name
Combination has existed, then by number from " 002 " is increased to, so the name automatically generated is " YH002 "；
B) when the corresponding first letter of pinyin of Chinese name only has one, then with the 0 insufficient phonetic quantity of supplement, rear three digit
Word producing method it is same a) described in, such as there is the entitled province of Chinese of table, then the name automatically generated is " S0001 ".
Further, further include following three kinds of situations in addition to default situations when data field is named:
A) it when the corresponding first letter of pinyin capitalization of Chinese name first four Chinese is identical, i.e., is searched when generation data field is named
Rope is combined to Pinyin abbreviation and is had existed in data field name character set, then by three bit digitals in corresponding character set
Then carry out splicing from increasing and generate corresponding name, if a field name existing in system is " exam information ", from
The dynamic field generated is entitled " KSXX001 ", adds the field of one entitled " examinee information " at this time, detects " KSXX " in character
It is had existed in set, by number from " 002 " is increased to, so the name automatically generated is " KSXX002 "；
B) when the corresponding first letter of pinyin of Chinese name only has three, then 0 is mended at the 4th, rear three bit digitals producing method
As described in a)；
C) when the corresponding first letter of pinyin of Chinese name only has two, then in third, four are mended 0, and rear three bit digital generates
Mode is as described in a), as what field entitled " remarks " automatically generated is named as " BZ00001 "；
When the corresponding first letter of pinyin of Chinese name only has one, then second and third, four mend 0, rear three bit digital generates
Mode is as described in a).
The invention has the following beneficial effects: a kind of tables of data of the present invention and data field name automatic generation, it
Use in database table name and field name automatically generated with a kind of format of fixation, pass through and choose the corresponding phonetics of several Chinese
The combined and spliced generation of initial caps addend word is named, and initials in chinese pinyin front two, data field are chosen in data table name
Name chooses first four, and corresponding letter digit deficiency then mends 0, and three bit digitals spliced below are then in corresponding character set
Middle progress is from increasing to generate；It, which has, can make the table name in project consistent with field name style, Uniform Name process, form life
Name specification, can facilitate the maintenance and secondary development in project later period.
[Detailed description of the invention]
Described herein the drawings are intended to provide a further understanding of the invention, constitutes part of this application, but
It does not constitute improper limitations of the present invention, in the accompanying drawings:
Fig. 1 is name flow diagram of the invention；
[specific embodiment]
Come that the present invention will be described in detail below in conjunction with attached drawing and specific embodiment, illustrative examples therein and says
It is bright to be only used to explain the present invention but not as a limitation of the invention.
As shown in Figure 1, a kind of tables of data and data field described in present embodiment name automatic generation, it
It automatically generates including tables of data name and is automatically generated with data field name；The name of tables of data and data field is all in
The corresponding first letter of pinyin of text capitalizes addend word combination producing.
Further, the naming method of tables of data, default are by the corresponding first letter of pinyin of Chinese name the first two Chinese
Capitalization plus three bit digitals generate, and three bit digital initial values are " 001 ".The name automatically generated such as user's table is " YH001 ".
Further, the naming method of data field, default are by the corresponding first letter of pinyin of Chinese first four Chinese
Capitalization plus three bit digitals generate, and three bit digital initial values are " 001 ".The name generated such as " examinee information table " is " KSXX001 ".
Further, further include following two kinds of situations in addition to default situations when tables of data is named:
A) it when the corresponding first letter of pinyin capitalization of Chinese name the first two Chinese is identical, i.e., is searched for when generation tables of data is named
It is had existed in tables of data name character set to Pinyin abbreviation combination, such as the corresponding name of " user's table " existing in system
" YH001 ", the tables of data for adding one entitled " user extends information table " at this time detect " YH " character when generating name
Combination has existed, then by number from " 002 " is increased to, so the name automatically generated is " YH002 "；
B) when the corresponding first letter of pinyin of Chinese name only has one, then with the 0 insufficient phonetic quantity of supplement, rear three digit
Word producing method it is same a) described in, such as there is the entitled province of Chinese of table, then the name automatically generated is " S0001 ".
Further, further include following three kinds of situations in addition to default situations when data field is named:
A) it when the corresponding first letter of pinyin capitalization of Chinese name first four Chinese is identical, i.e., is searched when generation data field is named
Rope is combined to Pinyin abbreviation and is had existed in data field name character set, then by three bit digitals in corresponding character set
Then carry out splicing from increasing and generate corresponding name, if a field name existing in system is " exam information ", from
The dynamic field generated is entitled " KSXX001 ", adds the field of one entitled " examinee information " at this time, detects " KSXX " in character
It is had existed in set, by number from " 002 " is increased to, so the name automatically generated is " KSXX002 "；
B) when the corresponding first letter of pinyin of Chinese name only has three, then 0 is mended at the 4th, rear three bit digitals producing method
As described in a), as field name is named as " CJR0001 " for what " founder " automatically generated；
C) when the corresponding first letter of pinyin of Chinese name only has two, then in third, four are mended 0, and rear three bit digital generates
Mode is as described in a), as what field entitled " remarks " automatically generated is named as " BZ00001 "；
When the corresponding first letter of pinyin of Chinese name only has one, then second and third, four mend 0, rear three bit digital generates
Mode is as described in a), as what field entitled " surname " automatically generated is named as " X000001 ".
Name generating principle in the present invention is as follows:
Naming method of the invention is to be contacted using initials in chinese pinyin, while limiting letter and number
In conjunction with ratio, such as there is the identical situation of letter, the numerical value of numerical portion can be incremented by automatically.
1, it is described according to the field Chinese of typing, the method parsed using js first letter of pinyin dictionary, such as data field
Obtain corresponding at most 4 initial prefixes, then same prefix frequency of occurrence occur in database search, then plus one, finally
Field code is generated according to unalterable rules.
2, specific data field and data sheet field length digit restriction rule are as follows:
(1) limitation data field overall length is 7, and data sheet field overall length is 5.Data field letter is up to 4, number
2 are up to according to literary name section letter.
(2) spelling analyzing is carried out to field name, takes the initial of each Chinese.
(3) the initial code of formation is looked into database for data sheet field code length no more than 2
It is duplicate whether inquiry has, if repeated, obtains the numerical portion of current literary name section, and 1 is then added on Contemporary Digital, is combined into and works as
Preceding literary name section name；If do not repeated, the length of computational chart field numerical portion, total length 5 subtracts data sheet field letter portion
The length divided, obtains numerical portion length, is 3 if it is length, numerical portion 001, so that it is determined that last digital section
Point.
3, for the automatic generation of data field, with the generating mode of tables of data.
4, for the name of tables of data, data field for example:
(1) it increases a tables of data newly, is named client, automatically generate table code KH, select system type, it is automatic according to account
Founder and creation time are generated, clicks and saves, can go whether inquiry database repeats, if repeating existing KH001, is named
Otherwise KH002 is directly named KH001.
(2) it increases one data word section newly, is named name, automatically generate table code XM, select system type, field type,
Field length, whether it is customized be also automatically generated, founder and creation time are automatically generated according to system login account, click
It saves and increases newly, can go whether inquiry database repeats, if repeating existing XM00001, be named XM00002, otherwise directly
It is named XM00001.
A kind of tables of data of the present invention and data field name automatic generation, it is using to the table in database
Name and field name are automatically generated with a kind of format of fixation, capitalize addend word group by choosing the corresponding first letter of pinyin of several Chinese
It is merged and delivers a child into name, initials in chinese pinyin front two is chosen in data table name, data field name chooses first four, corresponding word
Female digit deficiency then mends 0, and three bit digitals spliced below are then to carry out from increasing in corresponding character set to generate；It
Consistent with field name style with the table name that can make in project, Uniform Name process forms Naming conventions, can facilitate project
The maintenance and secondary development in later period.
The above description is only a preferred embodiment of the present invention, thus it is all according to the configuration described in the scope of the patent application of the present invention,
The equivalent change or modification that feature and principle are done, is included in the scope of the patent application of the present invention.
Claims (5)
1. a kind of tables of data and data field name automatic generation, it is characterised in that: it includes that tables of data name is automatic raw
It is automatically generated at data field name；The name of tables of data and data field is all big by the corresponding first letter of pinyin of Chinese
Write addend word combination producing.
2. a kind of tables of data according to claim 1 and data field name automatic generation, it is characterised in that: data
The naming method of table, default are generated by the corresponding first letter of pinyin capitalization of Chinese name the first two Chinese plus three bit digitals, three
Bit digital initial value is " 001 ".
3. a kind of tables of data according to claim 1 and data field name automatic generation, it is characterised in that: data
The naming method of field, default are generated by the corresponding first letter of pinyin capitalization of Chinese first four Chinese plus three bit digitals, three
Bit digital initial value is " 001 ".
4. a kind of tables of data according to claim 1 and data field name automatic generation, it is characterised in that: in number
Further include following two kinds of situations in addition to default situations when being named according to table:
A) when the corresponding first letter of pinyin capitalization of Chinese name the first two Chinese is identical, i.e., spelling is searched when generation tables of data is named
Sound abbreviation combination has existed in tables of data name character set, such as the corresponding name of " user's table " existing in system
" YH001 ", the tables of data for adding one entitled " user extends information table " at this time detect " YH " character when generating name
Combination has existed, then by number from " 002 " is increased to, so the name automatically generated is " YH002 "；
B) when the corresponding first letter of pinyin of Chinese name only has one, then with the 0 insufficient phonetic quantity of supplement, rear three bit digital is produced
Raw mode it is same a) described in, such as there is the entitled province of Chinese an of table, then the name automatically generated is " S0001 ".
5. a kind of tables of data according to claim 1 and data field name automatic generation, it is characterised in that: in number
Further include following three kinds of situations in addition to default situations when being named according to field:
A) it when the corresponding first letter of pinyin capitalization of Chinese name first four Chinese is identical, i.e., is searched when generation data field is named
Pinyin abbreviation combination has existed in data field name character set, then carries out three bit digitals in corresponding character set
From increasing, then carries out splicing and generate corresponding name, it is automatic raw if a field name existing in system is " exam information "
At field it is entitled " KSXX001 ", at this time add one entitled " examinee information " field, detect " KSXX " in character set
In have existed, by number from increasing to " 002 ", so the name automatically generated is " KSXX002 "；
B) when the corresponding first letter of pinyin of Chinese name only has three, then 0 is mended at the 4th, rear three bit digitals producing method is for example a)
Described in；
C) when the corresponding first letter of pinyin of Chinese name only has two, then in third, four are mended 0, rear three bit digitals producing method
As described in a), as what field entitled " remarks " automatically generated is named as " BZ00001 "；
When the corresponding first letter of pinyin of Chinese name only has one, then second and third, four mend 0, rear three bit digitals producing method
As described in a).
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811200778.1A CN109375900A (en) | 2018-10-16 | 2018-10-16 | A kind of tables of data and data field name automatic generation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811200778.1A CN109375900A (en) | 2018-10-16 | 2018-10-16 | A kind of tables of data and data field name automatic generation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109375900A true CN109375900A (en) | 2019-02-22 |
Family
ID=65399840
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811200778.1A Pending CN109375900A (en) | 2018-10-16 | 2018-10-16 | A kind of tables of data and data field name automatic generation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109375900A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112051996A (en) * | 2020-08-18 | 2020-12-08 | 远光软件股份有限公司 | Modeling method and device based on development platform element unified naming dictionary |
| WO2021017273A1 (en) * | 2019-07-30 | 2021-02-04 | 平安科技（深圳）有限公司 | User account generation method and apparatus, medium, and computer device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102236560A (en) * | 2011-08-01 | 2011-11-09 | 苏州万图明电子软件有限公司 | New software module development method |
| CN104715032A (en) * | 2015-03-12 | 2015-06-17 | 福建工程学院 | Mapping system and method of Chinese and English table name and field name of report system |
| CN106202091A (en) * | 2015-05-04 | 2016-12-07 | 阿里巴巴集团控股有限公司 | A kind of field method to set up and device |
-
2018
- 2018-10-16 CN CN201811200778.1A patent/CN109375900A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102236560A (en) * | 2011-08-01 | 2011-11-09 | 苏州万图明电子软件有限公司 | New software module development method |
| CN104715032A (en) * | 2015-03-12 | 2015-06-17 | 福建工程学院 | Mapping system and method of Chinese and English table name and field name of report system |
| CN106202091A (en) * | 2015-05-04 | 2016-12-07 | 阿里巴巴集团控股有限公司 | A kind of field method to set up and device |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021017273A1 (en) * | 2019-07-30 | 2021-02-04 | 平安科技（深圳）有限公司 | User account generation method and apparatus, medium, and computer device |
| CN112051996A (en) * | 2020-08-18 | 2020-12-08 | 远光软件股份有限公司 | Modeling method and device based on development platform element unified naming dictionary |
| CN112051996B (en) * | 2020-08-18 | 2023-09-29 | 远光软件股份有限公司 | Modeling method and device based on development platform element unified naming dictionary |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Jamatia et al. | Part-of-speech tagging for code-mixed english-hindi twitter and facebook chat messages | |
| Archer et al. | Guidelines for normalising Early Modern English corpora: Decisions and justifications | |
| US20190018839A1 (en) | Knowledge map-based question-answer method, device, and storage medium | |
| RU2571373C2 (en) | Method of analysing text data tonality | |
| US10535042B2 (en) | Methods of offering guidance on common language usage utilizing a hashing function consisting of a hash triplet | |
| Cotterell et al. | An algerian arabic-french code-switched corpus | |
| CN104252533A (en) | Search method and search device | |
| CN107480133B (en) | Subjective question self-adaptive scoring method based on answer implication and dependency relationship | |
| CN106776495B (en) | Document logic structure reconstruction method | |
| CN101131706A (en) | Query amending method and system thereof | |
| Krstev et al. | Using textual and lexical resources in developing serbian wordnet | |
| CN112035506A (en) | Semantic recognition method and equipment | |
| CN109375900A (en) | A kind of tables of data and data field name automatic generation | |
| AU2021203728A1 (en) | User interface operation based on token frequency of use in text | |
| Almarsoomi et al. | AWSS: An algorithm for measuring Arabic word semantic similarity | |
| CN107679038B (en) | Method and device for extracting text paragraphs | |
| Weichselbraun et al. | Name variants for improving entity discovery and linking | |
| AU2015213366B2 (en) | User interface operation based on similar spelling of tokens in text | |
| Higashinaka et al. | Learning to generate naturalistic utterances using reviews in spoken dialogue systems | |
| Meelen et al. | Segmenting and POS tagging Classical Tibetan using a memory-based tagger | |
| JP2019016074A (en) | Ontology generation device, ontology generation program and ontology generation method | |
| KR101052004B1 (en) | Translation service provision method and system | |
| Shirude et al. | Automated Question Generation tool for structured data | |
| US7177796B1 (en) | Automated set up of web-based natural language interface | |
| CN101499056A (en) | Backward reference sentence pattern language analysis method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190222 |