CN110309145A - A kind of tables of data method of adjustment, tables of data creation method and device - Google Patents
A kind of tables of data method of adjustment, tables of data creation method and device Download PDFInfo
- Publication number
- CN110309145A CN110309145A CN201910298698.2A CN201910298698A CN110309145A CN 110309145 A CN110309145 A CN 110309145A CN 201910298698 A CN201910298698 A CN 201910298698A CN 110309145 A CN110309145 A CN 110309145A
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- executable code
- field
- parameter
- 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
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This specification embodiment provides a kind of tables of data method of adjustment, tables of data creation method and device.The tables of data method of adjustment includes: to receive tables of data adjustment request；The tables of data adjustment request includes tables of data mark, change type and change parameter；Obtain the corresponding executable code of the change type；In conjunction with the change parameter, executes the executable code and the corresponding tables of data of tables of data mark is adjusted.Pass through the tables of data method of adjustment, tables of data creation method and device, database table structure adjustment can not only be managed collectively, the waste for additionally writing time caused by code and resource is avoided, simultaneously also by standardization table structure adjustment, avoids the not rigorous introduced risk of coding.
Description
Technical field
This specification embodiment is related to field of computer technology, in particular to a kind of tables of data method of adjustment, tables of data wound
Construction method and device.
Background technique
Database is for carrying out tissue, storage and the data acquisition system of management to data.Storage has various in the database
When the data of type, data are managed and are called for convenience, data can be stored according to corresponding logical relation
In different tables.Meanwhile different tables is corresponding with different structures, it can the word of different field type is provided in table
Section is realized with this and carries out classification storage to all data, is targetedly called to data convenient for user.
As data volume increases, business scenario is increasingly sophisticated, and the quantity of table and corresponding table structure in database is also got over
Come more.When because business demand variation etc. reasons, need in database table or corresponding table structure be adjusted when
It waits, generally requires to execute corresponding operation to table or table structure.But in actual application, lacking preferably can be directly right
The method that table is adjusted, and corresponding code is developed there is still a need for the change for table structure in database, and write installation
The handbook of code installs code.Due to the difference of business scenario, the rate of code reuse developed is relatively low.In this way
One, when the quantity of the required table being adjusted is more, it not only can increase unnecessary workload to developer, also can
So that coding is not rigorous to generate corresponding quality risk.
Summary of the invention
The purpose of this specification embodiment is to provide a kind of tables of data method of adjustment, tables of data creation method and device, with
It solves to be adjusted or lack when creating preferable processing method, treatment effeciency for the tables of data in database in the prior art
It is low, to waste time and the problem of resource.
In order to solve the above technical problems, the application proposes a kind of tables of data method of adjustment, tables of data creation method and device
It is achieved in that
A kind of tables of data method of adjustment, comprising:
Receive tables of data adjustment request；The tables of data adjustment request includes tables of data mark, change type and change ginseng
Number；
Obtain the corresponding executable code of the change type；
In conjunction with the change parameter, executes the executable code and the corresponding tables of data of tables of data mark is adjusted
It is whole.
A kind of data table adjusting apparatus, comprising:
Request receiving module, for receiving data table adjustment request；The tables of data adjustment request include tables of data mark,
Change type and change parameter；
Executable code obtains module, for obtaining the change type and the corresponding executable code of change parameter；
Tables of data adjusts module, adjusts for identifying corresponding tables of data to tables of data using the executable code
It is whole.
A kind of tables of data creation method, comprising:
Receive tables of data request to create；The tables of data request to create includes tables of data mark and change parameter；
Obtain the corresponding executable code of the creation parameter；
Execute the tables of data that the executable code creation corresponds to tables of data mark.
A kind of tables of data creating device, comprising:
Request to create receiving module, for receiving data table request to create；The tables of data request to create includes tables of data
Mark and change parameter；
Executable code obtains module, for obtaining the corresponding executable code of the creation parameter；
Tables of data creation module corresponds to the data of tables of data mark for executing the executable code creation
Table.
The technical solution provided by above this specification embodiment is as it can be seen that this specification embodiment is receiving tables of data tune
After whole request, corresponding executable code is obtained for wherein entrained change type and change parameter, then obtains number
Corresponding tables of data is identified according to table, so as to make corresponding adjustment to the tables of data using the executable code, thus
Realize the adjustment of data list structure；After receiving tables of data request to create, can according to creation parameter obtain it is corresponding can
Code is executed, and is able to carry out the tables of data that the executable code creation corresponds to tables of data mark and passes through the above method
Embodiment can be seen that this method and corresponding executable code can be directly acquired according to change type and change parameter, directly
It connects and corresponding operation is carried out to tables of data to be treated.So, avoiding needs when being adjusted to data list structure
Targetedly code is additionally write, while the adjustment for data list structure that standardized, convenient for carrying out to the code write
Management, also saves corresponding resource and time while averting risks.
Detailed description of the invention
In order to illustrate more clearly of this specification embodiment or technical solution in the prior art, below will to embodiment or
Attached drawing needed to be used in the description of the prior art is briefly described, it should be apparent that, the accompanying drawings in the following description is only
The some embodiments recorded in this specification, for those of ordinary skill in the art, before not making the creative labor
It puts, is also possible to obtain other drawings based on these drawings.
Fig. 1 is a kind of flow chart of tables of data method of adjustment of this specification embodiment；
Fig. 2 is a kind of module map of data table adjusting apparatus of this specification embodiment；
Fig. 3 is a kind of flow chart of tables of data creation method of this specification embodiment；
Fig. 4 is a kind of module map of tables of data creating device of this specification embodiment；
Fig. 5 is a kind of schematic diagram of tables of data adjustment request of this specification embodiment；
Fig. 6 is a kind of schematic diagram of tables of data adjustment request of this specification embodiment.
Specific embodiment
Below in conjunction with the attached drawing in this specification embodiment, the technical solution in this specification embodiment is carried out clear
Chu is fully described by, it is clear that described embodiment is only this specification a part of the embodiment, rather than whole implementation
Example.The embodiment of base in this manual, those of ordinary skill in the art are obtained without making creative work
Every other embodiment, all should belong to this specification protection range.
A kind of specific embodiment of tables of data method of adjustment of the application is introduced below in conjunction with attached drawing 1.The execution of the method
Main body is server, and the specific implementation step of the tables of data method of adjustment is as follows:
S100: tables of data adjustment request is received.
Tables of data is the table stored in the database.Database is to come tissue, storage and management number according to data structure
According to data acquisition system.For the ease of being classified to data and being managed, store data in table in the database.Different numbers
There is different structures according to table, can specifically show as different tables with different fields, different fields has different
The attributes such as field name, data type, field length.Therefore, when business demand or application scenarios change, for data
Every attribute of field and field in table generally requires to be changed accordingly, to need to carry out phase for data list structure
The adjustment answered.
Tables of data adjustment request is to be directed to the request that data list structure is adjusted.When user or other servers according to
The demand of current environment when needing to be adjusted the data list structure in database, can will need the data that be adjusted
The identification information of table and the particular content of adjustment are recorded in the tables of data adjustment request, and are sent to and are executed the tables of data
The server of method of adjustment.Server upon receiving the request, can parse the tables of data adjustment request and execute
Corresponding operation.
According to the difference for the type that tables of data needs to be adjusted, the tables of data adjustment request may include that field increases
Request, the modification request of tables of data removal request, field removal request, field are respectively used to request and execute increase field, delete number
According to table, delete the operations such as field, modification field parameter.
It include tables of data mark in the tables of data adjustment request.It can be searched in the database by tables of data mark
To corresponding tables of data.The tables of data mark includes but is not limited to tables of data Chinese, tables of data English name, tables of data
Physical name.It may include multiple tables of data marks in tables of data adjustment request, need to identify for tables of data at this time corresponding
Tables of data successively executes adjustment operation.
It also include change type in the tables of data adjustment request.Change type refers to the class being adjusted for tables of data
Type can specifically include field and increase type, tables of data deletion type, field deletion type, field modification type, is respectively used to
Instruction modification type is to increase field, delete tables of data, delete field, modification field.
It also include change parameter in the tables of data adjustment request.Change parameter is used to indicate to be changed with this tables of data
Operate related parameter information.
When the tables of data adjustment request includes that field increases request, the change parameter may include added word segment mark
Knowledge and new field parameter etc., new field mark, which can be, can search the newly-increased field to after addition field
The mark of index, new field parameter can be the information such as the field name, field length, field data types of new field.
When the tables of data adjustment request includes field removal request, the change parameter may include cancel (CANCL) segment mark
Know, the deletion field identification, can serve to indicate that and searches the field for needing to delete.
When the tables of data adjustment request includes field modification request, the change parameter may include modification field mark
Know and modification parameter, the modification field identification are used to indicate the field for needing to modify, the modification parameter expression is repaired
The modified field parameter information of the field changed.
It can also include modification time in the change parameter.Correspond to same tables of data in database, it is understood that there may be more
The tables of data of a different editions with different modification times, these tables of data may have certain difference in structure,
Selection may not necessarily have the rule accordingly modified according to modification time when needing to carry out tables of data adjustment.When
When in change parameter including the modification time corresponding to tables of data mark, it can be obtained according to modification time and tables of data mark
Determining tables of data.For example, a certain tables of data is adjusted on the 1st in January, also adjusted within 3rd in January, it is current to need
For January, the version of the tables of data modified on the 1st is modified, then when in change parameter can include the modification on January 1
Between, the version that adjustment on January 1 is obtained when being adjusted for tables of data in the later period executes corresponding operation.Pass through modification
The setting of time, it is ensured that when obtaining tables of data, can uniquely choose corresponding tables of data, avoid and go out when choosing tables of data
Existing chaotic problem.When the tables of data adjustment request is to create new tables of data, not due to targeted tables of data
It is necessarily present in database, modification time can not be included in adjustment instruction, avoid operation chaotic.
It can also include Database Identification in the tables of data adjustment request.Database Identification is deposited for searching tables of data
The database of storage, so that convenient call corresponding tables of data in the database.The tables of data adjustment request may include a variety of
Database Identification, to be operated simultaneously for the tables of data in multiple databases.The type of the database includes but not
It is limited to oracle, mysql, mongodb etc..It is corresponded to correspondingly, tables of data mark entrained in tables of data adjustment request exists
Database Identification.
The tables of data adjustment request, which can be, utilizes EXCEL format record tables of data mark, change type and change ginseng
The request of the information such as number.As shown in table 1, one embodiment of tables of data adjustment request is recorded using Microsoft Excel for the application.
Table 1
| Tables of data mark | Field identification | Change type | Field name | Field length | Data type | Modification time |
| Tables of data A | Institution Number | Modify field | Institution Number | 12 | varchar | 2019/3/12 |
| Tables of data B | Effective date | Increase field | Effective date | 8 | varchar | 2019/3/15 |
| Tables of data B | Due date | Increase field | Due date | 8 | varchar | 2019/3/15 |
| Tables of data C | \ | Delete tables of data | \ | \ | \ | \ |
In upper table 1, tables of data mark, field identification, change type, field name, field are recorded using Microsoft Excel
The information such as length, data type, modification time.It, can be rapidly and accurately when receiving the tables of data adjustment request
Corresponding information is therefrom extracted, the efficiency of data point reuse is improved.Certainly, the tables of data adjustment request is also possible to other
The request of format, such as txt format.There is no limit on showing format for tables of data adjustment request.
After receiving tables of data adjustment request, the tables of data can also be obtained and identify corresponding tables of data, and benefit
The correctness of the change parameter is verified with the tables of data.It is illustrated using a specific example, is directed to receiving
The field removal request of tables of data A, and when change parameter includes the field B for needing to delete in tables of data A, first acquisition tables of data
A, and check in tables of data A with the presence or absence of field B.If the field B is not present in tables of data A, authentication failed is ignored described
Tables of data adjustment request；If being proved to be successful in tables of data A there are the field B, subsequent step is executed.Specific authentication
Method can be adjusted correspondingly according to change parameter.By the verification operation for being directed to change parameter, it is ensured that adjust operation
Feasibility avoids and still carries out the problem of corresponding operation is to waste of resource in the case where instruction errors.
Certainly, the tables of data adjustment request is not limited to the format of foregoing description.If Fig. 5, Fig. 6 are actual applications
In tables of data adjustment request schematic diagram.It wherein not only may include the information such as Database Identification, tables of data mark, it can also be with
Comprising information such as modification people, release status, data item physics names, so that practical situations are preferably directed to, to tables of data
Adjustment process is illustrated.
S200: the corresponding executable code of the change type is obtained.
Executable code can be used for executing the modification to complete paired data table, and comply with the generation of adjustment instruction
Code.Different change types and change parameter are corresponding with corresponding executable code.Correspondingly, according to tables of data adjustment request
Difference, the executable code can be used for new field, delete tables of data, delete field and modification field.
The executable code can be the tables of data adjustment script of encapsulation in advance in the server.Server is receiving
After tables of data adjustment request, the change type according to included in request calls corresponding tables of data adjustment script, further according to
The specific requirement of change parameter is modified accordingly tables of data adjustment script, to obtain the adjustment of this data list structure
Required tables of data adjusts script.The executable code executes phase only for the part for needing to modify in tables of data
The operation answered, and do not need to be modified for entire tables of data, so, the time is not only saved, also avoids repairing
Change content excessively to be easier the problems such as introducing loophole risk.
When may identify comprising more than one tables of data with corresponding change type in the tables of data adjustment request, respectively
Executable code corresponding to each tables of data is obtained, thus for needing the tables of data being adjusted successively to execute adjustment behaviour
Make.
S300: it in conjunction with the change parameter, executes the executable code and corresponding tables of data is identified to the tables of data
It is adjusted.
, can be in conjunction with the change parameter after getting the executable code corresponding to change type, it can described in execution
It executes code to handle the corresponding tables of data of data table name, to obtain number required for meeting tables of data adjustment request
According to table structure.Specific processing mode, which can be, executes the executable code directly to realize the tune to data list structure
It is whole, for example, can directly execute the script in the database to data when the executable code is data point reuse script
Table structure is modified.
It, can also be according to number before identifying corresponding tables of data to tables of data using the executable code and being adjusted
Corresponding tables of data in database is obtained with modification time according to the tables of data mark in table adjustment request, to execute adjustment data
The operation of table structure.If obtaining correctness of the tables of data to verify change parameter in advance in the step s 100, executing
It does not need additionally to obtain the tables of data before step S300, be executed directly against the tables of data obtained in step S100 corresponding
Operation.
When the tables of data adjustment request is that field increases request, is carried in the executable code and increase field
The field attributes information such as field name, field length, field data types executes the executable code in tables of data mark pair
The new field is added in the tables of data answered identifies corresponding field.
When the tables of data adjustment request is tables of data removal request, executes the executable code and delete corresponding to number
The tables of data identified according to table.
When the tables of data adjustment request is field removal request, cancel (CANCL) segment mark is carried in the executable code
Know, executes the executable code and delete the corresponding word of the deletion field identification in the corresponding tables of data of tables of data mark
Section.
When the tables of data adjustment request is field modification request, modification field tune is carried in the executable code
The information such as field name, field length, field data types after whole execute the executable code and identify in the tables of data
The modification parameter of the corresponding field of the modification field identification is modified in corresponding tables of data.
After completing the adjustment for data list structure, the modification time of tables of data adjusted is changed to current
Time.So, if being saved in the database with different version before adjustment with tables of data adjusted, when needing to select
When specific tables of data is checked, called or modified, tables of data can be distinguished according to modification time, so as to avoid
Operate chaotic problem.
If the tables of data in the data point reuse request is under the jurisdiction of different databases, i.e., wrapped in the described data point reuse request
When containing Database Identification, when handling tables of data using executable code, need to obtain from corresponding database
Tables of data, and adjustment operation is executed in corresponding database, to avoid interfering between different data.
Since the tables of data adjustment request may include more than one tables of data mark, handled to tables of data
When, can according to the executable code of acquired corresponding each tables of data, successively to the tables of data that is adjusted of needs into
Row processing, until being fully completed.
It, can be with verify data after handling the tables of data using the executable code and identifying corresponding tables of data
Whether table meets the requirement of tables of data adjustment request.Verify data table can be for change parameter, check data adjusted
Whether table meets the requirement of change type and change parameter.For example, being directed to tables of data M, need to delete field in tables of data M
C.Then after using corresponding executable code processing tables of data M, can check whether there is also field C in tables of data M.If number
According to field C is not present in table M, shows to operate successfully, the tables of data can be stored into database；If in tables of data M still
So there are field C, then illustrate operation failure.Above-mentioned example is intended merely to be illustrated verification process, specific verification operation
It is not limited to the above example, can carry out corresponding verification operation as the case may be.
If after verifying, the requirement for not meeting tables of data adjustment request has failed for the adjustment of data list structure,
The tables of data can be fed back into user.User can be checked when receiving the tables of data for adjustment process,
Error reason is found, and according to the requirement of tables of data adjustment request, tables of data is adjusted correspondingly and feeds back to server.Clothes
Business device saves after the tables of data for receiving user's input using the tables of data as tables of data adjusted.
Above-mentioned tables of data method of adjustment is explained below in conjunction with a specific Sample Scenario.Server is connecing
After receiving tables of data adjustment request as shown in Table 1, need to carry out for tables of data A, tables of data B and tables of data C corresponding
Adjustment.By taking tables of data B as an example, firstly, search modification time is on March 15th, 2019 in the database, tables of data is identified as number
According to the tables of data of table B, tables of data as shown in table 2 below is obtained.
Table 2
| Business Name | Type of service | The business amount of money | Business number | Operator |
| AAA | XX1 | 500 | 1234 | XX |
| BBB | XX1 | 500 | 1235 | XX |
| CCC | XX2 | 500 | 1236 | XX |
| DDD | XX3 | 500 | 1237 | XX |
After finding the tables of data, according to the change type and change parameter in tables of data adjustment request, needle is verified
It is whether effective to the adjustment instruction of tables of data B.Due to needing the increase " effective date " and " due date " two in tables of data B
Field searches whether the field in the presence of " effective date " and " due date " in tables of data B in advance.Due in tables of data B simultaneously
There is no above-mentioned two field, then this tables of data adjustment request is effective, continues to execute subsequent operation.
According to field name, the field length for being directed to newly-increased " effective date " and " due date " two fields in table 1
With the requirement of data type, corresponding executable code is generated, that is, corresponds to the executable code of tables of data B.In the database
The executable code is executed, the tables of data B after being adjusted is as shown in table 3 below.
Table 3
| Business Name | Type of service | The business amount of money | Business number | Operator | Effective date | Due date |
| AAA | XX1 | 500 | 1234 | XX | ||
| BBB | XX1 | 500 | 1235 | XX | ||
| CCC | XX2 | 500 | 1236 | XX | ||
| DDD | XX3 | 500 | 1237 | XX |
After the tables of data B after being adjusted, according to the demand of change type and change parameter, search in tables of data B
With the presence or absence of newly-increased " effective date " and " due date " two fields, and check the corresponding field length of field, data class
The attributes such as type.By verifying, illustrate that this tables of data Format adjusting is correct, it can be using the corresponding tables of data of table 3 as new modification
Tables of data saved.
By above method embodiment and the explanation of Sample Scenario as can be seen that the tables of data method of adjustment of the application, energy
It is enough operated for different databases, has been managed collectively different types of database, meanwhile, specify the number that needs are modified
According to the belonging positions of table, the change of data list structure can be accurately realized.Also, this method is utilized, without for difference
Table structure change request write corresponding code, and alleviate the burden of developer, also avoid for entire tables of data
It modifies and is easy the risk of initiation, to be more advantageous to the implementation for the related work that operator executes for tables of data.
A kind of embodiment of report generation device of the application introduced below, as shown in Fig. 2, the device includes:
Request receiving module 210, for receiving data table adjustment request；The tables of data adjustment request includes tables of data mark
Knowledge, change type and change parameter；
Executable code obtains module 220, for obtaining the corresponding executable code of the change type；
Tables of data adjusts module 230, for executing the executable code to the tables of data in conjunction with the change parameter
Corresponding tables of data is identified to be adjusted.
A kind of embodiment of tables of data creation method of the application is introduced below in conjunction with attached drawing 3.The executing subject of the method
For server, steps are as follows for the specific execution of the method:
310: receiving tables of data request to create.
The tables of data request to create, for creating a new tables of data.When user or other servers needs are directed to
The elements such as current business demand can be by the identification information and tool for the tables of data for needing to create when creating a new tables of data
The creation reference record of body is sent to the service for executing the tables of data creation method in the tables of data request to create
Device.Server upon receiving the request, can parse the tables of data request to create and execute the behaviour of creation tables of data
Make.
It include creation parameter in the tables of data request to create.The creation parameter may include created tables of data
In field identification information and the contents such as field parameter.Field identification information can be used in after creating tables of data to wherein
Field searched, the information such as described field parameter, including field name, field length, field data types.
320: obtaining the corresponding executable code of the creation parameter.
The executable code can be used for executing and realizing the creation for tables of data.Different creation parameters is corresponding
There is corresponding executable code.The executable code can be the tables of data creation script of encapsulation in advance in the server.Clothes
Device be engaged in after receiving tables of data request to create, corresponding tables of data creation script is called, according to creation parameter to the number
It is modified accordingly according to table creation script, to obtain tables of data creation script required for this tables of data creates.
It may be comprising more than one tables of data mark and corresponding creation parameter, this in the tables of data request to create
In the case of, it is identified for different tables of data, successively creates corresponding tables of data.
330: executing the tables of data that the executable code creation corresponds to tables of data mark.
The executable code is executed, the tables of data for corresponding to tables of data mark can be obtained.For example, can described in
When execution code is data creation script, creation of the script completion for tables of data can be directly executed in the database.
After the creation for completing the tables of data, when the modification time of the tables of data after creation can be changed to current
Between.So, convenient according to modification time pair if need to check tables of data, called or modified in subsequent process
Tables of data is searched.
It also include Database Identification in the tables of data request to create.After creating tables of data, the tables of data is deposited
It is stored in the corresponding database of Database Identification.
Pass through the explanation of the embodiment of above-mentioned tables of data creation method, it can be seen that the tables of data creation method of the application,
Corresponding executable code directly can be obtained according to the tables of data request to create and creation parameter that are received, and directly execute institute
State the creation that executable code completes tables of data.So, the burden of developer is not only alleviated, while also having unified wound
Format is built so as to avoid the risk being likely to occur, convenient for the implementation of the subsequent related work for tables of data.
A kind of embodiment of tables of data creating device of the application introduced below, as shown in figure 4, described device includes:
Request to create receiving module 410, for receiving data table request to create；The tables of data request to create includes data
Table mark and creation parameter；
Executable code obtains module 420, for obtaining the corresponding executable code of the creation parameter；
Tables of data creation module 430 corresponds to the number of tables of data mark for executing the executable code creation
According to table.
In the 1990s, the improvement of a technology can be distinguished clearly be on hardware improvement (for example,
Improvement to circuit structures such as diode, transistor, switches) or software on improvement (improvement for method flow).So
And with the development of technology, the improvement of current many method flows can be considered as directly improving for hardware circuit.
Designer nearly all obtains corresponding hardware circuit by the way that improved method flow to be programmed into hardware circuit.Cause
This, it cannot be said that the improvement of a method flow cannot be realized with hardware entities module.For example, programmable logic device
(Programmable Logic Device, PLD) (such as field programmable gate array (Field Programmable Gate
Array, FPGA)) it is exactly such a integrated circuit, logic function determines device programming by user.By designer
Voluntarily programming comes a digital display circuit " integrated " on a piece of PLD, designs and makes without asking chip maker
Dedicated IC chip 2.Moreover, nowadays, substitution manually makes IC chip, and this programming is also used instead mostly
" logic compiler (logic compiler) " software realizes that software compiler used is similar when it writes with program development
Seemingly, and the source code before compiling also handy specific programming language is write, this is referred to as hardware description language
(Hardware Description Language, HDL), and HDL is also not only a kind of, but there are many kind, such as ABEL
(Advanced Boolean Expression Language)、AHDL(Altera Hardware Description
Language)、Confluence、CUPL(Cornell University Programming Language)、HDCal、JHDL
(Java Hardware Description Language)、Lava、Lola、MyHDL、PALASM、RHDL(Ruby
Hardware Description Language) etc., VHDL (Very-High-Speed is most generally used at present
Integrated Circuit Hardware Description Language) and Verilog2.Those skilled in the art
It will be apparent to the skilled artisan that only needing method flow slightly programming in logic and being programmed into integrated circuit with above-mentioned several hardware description languages
In, so that it may it is readily available the hardware circuit for realizing the logical method process.
System, device, module or the unit that above-described embodiment illustrates can specifically realize by computer chip or entity,
Or it is realized by the product with certain function.It is a kind of typically to realize that equipment is computer.Specifically, computer for example may be used
Think personal computer, laptop computer, cellular phone, camera phone, smart phone, personal digital assistant, media play
It is any in device, navigation equipment, electronic mail equipment, game console, tablet computer, wearable device or these equipment
The combination of equipment.
As seen through the above description of the embodiments, those skilled in the art can be understood that this specification
It can realize by means of software and necessary general hardware platform.Based on this understanding, the technical solution of this specification
Substantially the part that contributes to existing technology can be embodied in the form of software products in other words, the computer software
Product can store in storage medium, such as ROM/RAM, magnetic disk, CD, including some instructions are used so that a computer
Equipment (can be personal computer, server or the network equipment etc.) executes each embodiment of this specification or embodiment
Certain parts described in method.
All the embodiments in this specification are described in a progressive manner, same and similar portion between each embodiment
Dividing may refer to each other, and each embodiment focuses on the differences from other embodiments.Especially for system reality
For applying example, since it is substantially similar to the method embodiment, so being described relatively simple, related place is referring to embodiment of the method
Part explanation.
This specification can be used in numerous general or special purpose computing system environments or configuration.Such as: personal computer,
Server computer, handheld device or portable device, laptop device, multicomputer system, microprocessor-based system,
Set top box, programmable consumer-elcetronics devices, network PC, minicomputer, mainframe computer including any of the above system are set
Standby distributed computing environment etc..
This specification can describe in the general context of computer-executable instructions executed by a computer, such as journey
Sequence module.Generally, program module include routines performing specific tasks or implementing specific abstract data types, programs, objects,
Component, data structure etc..This specification can also be practiced in a distributed computing environment, in these distributed computing environment
In, by executing task by the connected remote processing devices of communication network.In a distributed computing environment, program module
It can be located in the local and remote computer storage media including storage equipment.
Although depicting this specification by embodiment, it will be appreciated by the skilled addressee that there are many become for this specification
Shape and the spirit changed without departing from this specification, it is desirable to which the attached claims include these deformations and change without departing from this
The spirit of specification.
Claims (15)
1. a kind of tables of data method of adjustment characterized by comprising
Receive tables of data adjustment request；The tables of data adjustment request includes tables of data mark, change type and change parameter；
Obtain the corresponding executable code of the change type；
In conjunction with the change parameter, executes the executable code and the corresponding tables of data of tables of data mark is adjusted.
2. the method as described in claim 1, which is characterized in that the tables of data adjustment request includes being remembered using EXCEL format
Record the request of tables of data mark, change type and change parameter.
3. the method as described in claim 1, which is characterized in that the tables of data adjustment request includes that field increases request, institute
Stating change type includes that field increases type, and the change parameter includes field identification and field parameter；Become described in the combination
More parameter executes the executable code and is adjusted to the corresponding tables of data of tables of data mark, comprising:
The executable code is executed, it is corresponding to be identified based on the field identification and the field parameter in the tables of data
Field is added in tables of data.
4. the method as described in claim 1, which is characterized in that the tables of data adjustment request includes tables of data removal request,
The change type includes that tables of data deletes type；Change parameter described in the combination executes the executable code to described
Tables of data identifies corresponding tables of data and is adjusted, comprising:
It executes the executable code and deletes the corresponding tables of data of the tables of data mark.
5. the method as described in claim 1, which is characterized in that the tables of data adjustment request includes field removal request, institute
Stating change type includes that field deletes type, and the change parameter includes field identification；Change parameter described in the combination executes
The executable code identifies corresponding tables of data to the tables of data and is adjusted, comprising:
It executes the executable code and deletes the corresponding word of the field identification in the corresponding tables of data of tables of data mark
Section.
6. the method as described in claim 1, which is characterized in that the tables of data adjustment request includes field modification request, institute
Stating change type includes field modification type, and the change parameter includes field identification and field parameter；Become described in the combination
More parameter executes the executable code and is adjusted to the corresponding tables of data of tables of data mark, comprising:
The executable code is executed, described in identifying in corresponding tables of data based on the field parameter to the tables of data
The corresponding field of field identification is modified.
7. the method as described in claim 3 or 6, which is characterized in that the field parameter comprises at least one of the following: field name
Title, field length, field data types.
8. the method as described in claim 1, which is characterized in that after the reception tables of data adjustment request, further includes:
It obtains the tables of data and identifies corresponding tables of data, verify the change parameter；
Correspondingly, described obtain the corresponding executable code of the change parameter, comprising:
If being proved to be successful, the corresponding executable code of the change parameter is obtained.
9. the method as described in claim 1, which is characterized in that the executable code includes tables of data adjustment script.
10. the method as described in claim 1, which is characterized in that the change parameter includes modification time；Described in the combination
Change parameter executes the executable code and is adjusted to the corresponding tables of data of tables of data mark, comprising:
Obtain the tables of data for corresponding to tables of data mark and modification time；
In conjunction with the change parameter, executes the executable code and the tables of data is adjusted.
11. the method as described in claim 1, which is characterized in that further include Database Identification in the tables of data adjustment request；
Change parameter described in the combination executes the executable code and is adjusted to the corresponding tables of data of tables of data mark,
Include:
The tables of data is obtained in the corresponding database of the Database Identification identifies corresponding tables of data；
In conjunction with the change parameter, executes the executable code and the tables of data is adjusted.
12. the method as described in claim 1, which is characterized in that change parameter described in the combination executes the executable generation
After code is adjusted the corresponding tables of data of tables of data mark, further includes:
Verify the requirement whether tables of data adjusted meets tables of data adjustment request；
If not meeting, the tables of data adjusted is fed back into user；
The tables of data of user's input is received as tables of data adjusted.
13. a kind of data table adjusting apparatus characterized by comprising
Request receiving module, for receiving data table adjustment request；The tables of data adjustment request includes tables of data mark, change
Type and change parameter；
Executable code obtains module, for obtaining the corresponding executable code of the change type；
Tables of data adjusts module, for executing the executable code to tables of data mark pair in conjunction with the change parameter
The tables of data answered is adjusted.
14. a kind of tables of data creation method characterized by comprising
Receive tables of data request to create；The tables of data request to create includes tables of data mark and creation parameter；
Obtain the corresponding executable code of the creation parameter；
Execute the tables of data that the executable code creation corresponds to tables of data mark.
15. a kind of tables of data creating device characterized by comprising
Request to create receiving module, for receiving data table request to create；The tables of data request to create includes tables of data mark
With creation parameter；
Executable code obtains module, for obtaining the corresponding executable code of the creation parameter；
Tables of data creation module corresponds to the tables of data of tables of data mark for executing the executable code creation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910298698.2A CN110309145A (en) | 2019-04-15 | 2019-04-15 | A kind of tables of data method of adjustment, tables of data creation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910298698.2A CN110309145A (en) | 2019-04-15 | 2019-04-15 | A kind of tables of data method of adjustment, tables of data creation method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110309145A true CN110309145A (en) | 2019-10-08 |
Family
ID=68074574
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910298698.2A Pending CN110309145A (en) | 2019-04-15 | 2019-04-15 | A kind of tables of data method of adjustment, tables of data creation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110309145A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113220691A (en) * | 2021-05-31 | 2021-08-06 | 北京互金新融科技有限公司 | Database table creating method and device for database table, and electronic equipment |
| WO2021169272A1 (en) * | 2020-02-27 | 2021-09-02 | 平安科技（深圳）有限公司 | Database table changing method and apparatus, computer device, and storage medium |
| CN114154469A (en) * | 2021-12-02 | 2022-03-08 | 北京字跳网络技术有限公司 | Document form processing method, device, equipment and medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104636471A (en) * | 2015-02-12 | 2015-05-20 | 中国农业银行股份有限公司 | Procedure code finding method and device |
| CN105354036A (en) * | 2015-11-26 | 2016-02-24 | 深圳市金证科技股份有限公司 | Database operation code generating method and apparatus |
| CN105677324A (en) * | 2015-12-31 | 2016-06-15 | 合肥大多数信息科技有限公司 | Method for automatically generating entity type codes |
| CN106933837A (en) * | 2015-12-29 | 2017-07-07 | 航天信息股份有限公司 | A kind of database table model and creation method |
| CN107704597A (en) * | 2017-10-13 | 2018-02-16 | 携程旅游网络技术（上海）有限公司 | Relevant database to Hive ETL script creation methods |
-
2019
- 2019-04-15 CN CN201910298698.2A patent/CN110309145A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104636471A (en) * | 2015-02-12 | 2015-05-20 | 中国农业银行股份有限公司 | Procedure code finding method and device |
| CN105354036A (en) * | 2015-11-26 | 2016-02-24 | 深圳市金证科技股份有限公司 | Database operation code generating method and apparatus |
| CN106933837A (en) * | 2015-12-29 | 2017-07-07 | 航天信息股份有限公司 | A kind of database table model and creation method |
| CN105677324A (en) * | 2015-12-31 | 2016-06-15 | 合肥大多数信息科技有限公司 | Method for automatically generating entity type codes |
| CN107704597A (en) * | 2017-10-13 | 2018-02-16 | 携程旅游网络技术（上海）有限公司 | Relevant database to Hive ETL script creation methods |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021169272A1 (en) * | 2020-02-27 | 2021-09-02 | 平安科技（深圳）有限公司 | Database table changing method and apparatus, computer device, and storage medium |
| CN113220691A (en) * | 2021-05-31 | 2021-08-06 | 北京互金新融科技有限公司 | Database table creating method and device for database table, and electronic equipment |
| CN113220691B (en) * | 2021-05-31 | 2024-02-06 | 北京互金新融科技有限公司 | Database table creation method, database table creation device and electronic equipment |
| CN114154469A (en) * | 2021-12-02 | 2022-03-08 | 北京字跳网络技术有限公司 | Document form processing method, device, equipment and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11363087B2 (en) | Leveraging microservices to orchestrate media workflows in the cloud | |
| US20200348921A1 (en) | Microservice update system | |
| US20140006459A1 (en) | Rule-based automated test data generation | |
| CN112488855B (en) | Business verification method and device based on rule template | |
| CN110309145A (en) | A kind of tables of data method of adjustment, tables of data creation method and device | |
| CN108196878A (en) | Method and device for generating application program installation package, electronic equipment and storage medium | |
| CN106250143A (en) | The OTA upgrade method of a kind of wearable device and device | |
| CN106156119A (en) | A kind of distributed transaction communication means, system and device | |
| CN108345511A (en) | A kind of application data verification method, device and electronic equipment | |
| CN114981775B (en) | Cloud-based API metadata management method and system for integrated API management | |
| US8862937B2 (en) | Method and system for migrating data from multiple sources | |
| CN102054217B (en) | Entity morphing in metamodel-based tools | |
| US20100306638A1 (en) | Object templates for data-driven applications | |
| US10402406B2 (en) | Predictive database for computer processes | |
| CN110058864A (en) | The dispositions method and device of micro services | |
| CN110990274B (en) | Data processing method, device and system for generating test cases | |
| US11899570B2 (en) | System and method for optimizing assessment and implementation of microservices code for cloud platforms | |
| US20140304683A1 (en) | Method, server and computer-readable recording media for managing metastore | |
| CN107273300A (en) | A kind of applied program testing method and device | |
| CN111159040A (en) | Test data generation method, device, equipment and storage medium | |
| CN111125067B (en) | Data maintenance method and device | |
| CN116610568A (en) | Method, device, equipment and medium for identifying dependency relationship of codes | |
| US20220066745A1 (en) | Code generating software and systems for software applications | |
| CN111625232B (en) | Method and device for generating application program installation package, readable medium and electronic equipment | |
| CN104375993A (en) | Data processing method and device |
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 |
Application publication date: 20191008 |
|
| RJ01 | Rejection of invention patent application after publication |