CN106933837A - A kind of database table model and creation method - Google Patents
A kind of database table model and creation method Download PDFInfo
- Publication number
- CN106933837A CN106933837A CN201511018430.7A CN201511018430A CN106933837A CN 106933837 A CN106933837 A CN 106933837A CN 201511018430 A CN201511018430 A CN 201511018430A CN 106933837 A CN106933837 A CN 106933837A
- Authority
- CN
- China
- Prior art keywords
- database
- model
- database table
- structural model
- field
- 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
-
- 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/2291—User-Defined Types; Storage management thereof
Abstract
The invention discloses a kind of database table model and creation method, the model manages database table, the essential information of data storage storehouse table by table structural model table；By the description information of field model table data storage storehouse literary name section；Information in table structural model table and field model table is called by unified interface, perform the establishment and management of database table, so, basic database table in database is managed by one unification of establishment, flexible data model, the operation of all about database table is all done by the table structural model table of the present embodiment, it is adaptable to multiple business data model.Good interface is provided simultaneously, so as to developer be freed from uninteresting repeated work, reduce size of code, error probability is reduced simultaneously, increases the stability of a system, when data list structure changes, only need to be changed in respective interface, backstage code need not be changed, operation is simplified, operating efficiency is improved.
Description
Technical field
The invention belongs to database management technology field, and in particular to database table model and creation method.
Background technology
In project development process, database table is a most basic element in database, is the basis of other objects.Data in database want the persistence and realizing to increase, delete, change, inquiring about and be required for database table.Under normal circumstances, many database tables are created in a database, and needs to realize the increase of the table, deletion, modification, query function.
In the prior art, the database table in database is by corresponding code building, with certain structure.If the structure of the table changes, need to change corresponding code, so, the growth that the workload of exploitation will be at double.
It is entitled《A kind of WEB form datas access method and system》, Patent No. 201510315502 Chinese patent, disclose a kind of method and system of WEB form datas access, the method passes through open user interface layer, integrated Object Relation Mapping and database access layer, and developer is by keeping Web page form fields identical with database field name, realize that the additions and deletions of WEB lists change the data manipulation looked into, and then data access is realized, without excessive configuration, and if there is configuration error, the bottom meeting intelligent correction of system, makes system reliable and stable.But, the additions and deletions that above-mentioned patent provides the data of the existing table of database change and look into, and for newly-increased database table then without processing method.
The content of the invention
The purpose of the embodiment of the present invention is to provide a kind of database table model and creation method, by the database table model, establishment, modification, the deletion action of tables of data can be realized, and corresponding additions and deletions can be carried out to the data of table change to look into operation, the additions and deletions that database table and table data in larger scope can be completed change and look into, and function is more perfect.
According to an aspect of the invention, there is provided a kind of database table model, the model includes：Table structural model table, field model table, unified interface；
Wherein, the table structural model table is used to manage database table, the essential information of data storage storehouse table；The field model table is the sublist of table structural model table, for the description information of data storage storehouse literary name section；The unified interface is used to connect the table structural model table and database table, for being called by information in table structural model table and field model table, performs the establishment and management of database table.
In such scheme, the database table model also includes definable interface, the definable interface is connected with the table structural model table, essential information and field information for providing a user with table structural model table by way of interface, realizes the management to database table.
In such scheme, the essential information of the database table includes：The ID of database table, title, purposes.
In such scheme, the description information of the database table field includes：Field name, field type and field length.
In such scheme, the unified interface is further used for：
The ID of the database table in table structural model table obtains the field information of database table, and generation is built table statement and creates database table；
Lax entropy in the ID and field model table of the database table in table structural model, changes database table；
The ID of the database table in table structural model deletes database table；
The field information of the ID corresponding database tables of acquisition of the database table in table structural model realizes the inquiry of database table；
The ID of the database table in table structural model interpolation datas in corresponding database table；
According to incoming parameter, form corresponding insertion sentence and insert data；
The ID of the database table in table structural model changes data in corresponding database table；
According to incoming parameter, form corresponding renewal sentence and update the data；
The ID of the database table in table structural model deletes data in corresponding database table；
According to incoming parameter, form corresponding cancel statement and delete data；
The ID of the database table in table structural model inquires about data in corresponding database table；
According to incoming parameter, form corresponding query statement and return to Query Result.
According to another aspect of the present invention, a kind of creation method of database table model is additionally provided, methods described comprises the following steps：
Create table structural model table, the essential information of data storage storehouse table in the table structural model table；
On the basis of the table structural model table, create table structural model table field model table as table structural model table sublist, and in the field model table data storage storehouse literary name section description information；
Unified interface is set up, the table structural model table, field model table and database table is connected, by the essential information in unified interface call list structural model table and field model table, corresponding establishment and management is performed to the database table.
In such scheme, methods described also includes：
Design definable interface, the definable interface is connected with the table structural model table, and table structural model table, the essential information of field model table and field information are provided a user with by way of interface, provides the user the entrance for realizing database table management.
In such scheme, the essential information of the database table includes：The ID of database table, title, purposes.
In such scheme, the description information of the database table field includes：Field name, field type and field length.
It is described corresponding establishment to be performed to the database table and is managed in such scheme, further include：
The ID of the database table in table structural model table obtains the field information of database table, and generation is built table statement and creates database table；
Lax entropy in the ID and field model table of the database table in table structural model, changes database table；
The ID of the database table in table structural model deletes database table；
The field information of the ID corresponding database tables of acquisition of the database table in table structural model realizes the inquiry of database table；
The ID of the database table in table structural model interpolation datas in corresponding database table；
According to incoming parameter, form corresponding insertion sentence and insert data；
The ID of the database table in table structural model changes data in corresponding database table；
According to incoming parameter, form corresponding renewal sentence and update the data；
The ID of the database table in table structural model deletes data in corresponding database table；
According to incoming parameter, form corresponding cancel statement and delete data；
The ID of the database table in table structural model inquires about data in corresponding database table；
According to incoming parameter, form corresponding query statement and return to Query Result.
As can be seen from the above technical solutions, the database table model of the present embodiment, database table, the essential information of data storage storehouse table are managed by table structural model table；By the description information of field model table data storage storehouse literary name section；Information in table structural model table and field model table is called by unified interface, perform the establishment and management of database table, so, the basic database table in database is managed by creating a unified data model, the operation of all about database table is all done by the table structural model table of the present embodiment, including creates table, modification table, increase, modification, deletion, the inquiry of deleting table and table data etc..The present invention uses flexible database model, suitable for multiple business data model, and the access of database table and table data is realized by unified interface, reduce size of code, good interface is provided simultaneously, simplify operation, improve operating efficiency, so as to developer be freed from uninteresting repeated work, size of code is reduced, while reducing error probability, increase the stability of a system, when data list structure changes, it is only necessary in respective interface modification, it is not necessary to change backstage code；Using unified interface, normalization, uniformity and the flexibility of code are improved.
Brief description of the drawings
Technical scheme in order to illustrate more clearly the embodiments of the present invention, the accompanying drawing to be used needed for being described to embodiment below is briefly described, apparently, drawings in the following description are only some embodiments of the present invention, for those of ordinary skill in the art, without having to pay creative labor, other accompanying drawings can also be obtained according to these accompanying drawings.
Fig. 1 is the structural representation of the database table model of first embodiment of the invention；
Fig. 2 is the structure chart of the table structural model table of the database table model of first embodiment of the invention；
Fig. 3 is the structure chart of the field model table of the database table model of first embodiment of the invention；
Fig. 4 is the visualization structure figure at the definable interface of first embodiment of the invention；
Fig. 5 is the database table model creation method flow schematic diagram of second embodiment of the invention；
Fig. 6 is the database table model creation method flow schematic diagram of second embodiment of the invention；
Fig. 7 is the definable surface chart that the database table model that second embodiment of the invention is created performs " addition table " operation；
Fig. 8 is the definable surface chart that the database table model that second embodiment of the invention is created performs " addition field " operation.
Specific embodiment
Those skilled in the art of the present technique are appreciated that unless expressly stated singulative " " used herein, " one ", " described " and " being somebody's turn to do " may also comprise plural form.It should be further understood that, used in specification of the invention wording " including " refer to the presence of the feature, integer, step, operation, element and/or component, but it is not excluded that in the presence of or add one or more other features, integer, step, operation, element, component and/or their group.It should be understood that when we claim element to be " connected " or during " coupled " to another element, it can be directly connected or coupled to other elements, or can also there is intermediary element.Additionally, " connection " used herein or " coupling " can include wireless connection or coupling.Wording "and/or" used herein includes one or more associated any cells for listing item and all combines.
Those skilled in the art of the present technique are appreciated that unless otherwise defined, all terms used herein（Including technical term and scientific terminology）With with art of the present invention in those of ordinary skill general understanding identical meaning.It should also be understood that those terms defined in such as general dictionary should be understood that with the meaning consistent with the meaning in the context of prior art, and unless defined as here, will not be with idealizing or excessively formal implication be explained.
For ease of the understanding to the embodiment of the present invention, embodiments of the present invention are described below in detail, are exemplary by reference to the implementation method of Description of Drawings, be only used for explaining the present invention, and be not construed as limiting the claims.
First embodiment
Present embodiments provide for a kind of database table model, Fig. 1 is the structural representation of the database table model of first embodiment of the invention.Under normal circumstances, it is to need frequently to be read there was only little traffic table in a project for database, and most database table is some cardinal data tables, and the field of these tables is relatively fewer and data volume very little.Therefore, the present invention manages these base data table by creating a unified data model, and the operation of all about these tables is all done by this model, including creates table, modification table, increase, modification, deletion, the inquiry of deleting table and table data etc..
As shown in figure 1, the database table model of present embodiment includes：Table structural model table 1, field model table 2, unified interface 3；
Wherein, the table of table structural model 1 is used to manage database table, the essential information of data storage storehouse table；The field model table 2 is the sublist of table structural model table, for the description information of data storage storehouse literary name section；The unified interface 3 is used to connect the table structural model table and database table, for being called by information in table structural model table and field model table, performs the establishment and management of database table.
The essential information of database table here includes：The ID of database table, title, purposes, above- mentioned information is stored and shown by table structural model table.
The description information of database table field here includes：Field name, field type and field length.Here the description information also other information including field, such as：Decimal digits, page display order, page display title, the information such as default value, for data message the page displaying.
Preferably, the table structural model table can also include definable interface 4, the definable interface 4 is connected with the table structural model table 1, essential information and field information for providing a user with table structural model table by way of interface, realizes the management to database table.
Here the management to database table includes all of establishment and management operation, such as：
The ID of the database table in table structural model table obtains the field information of database table, and generation is built table statement and creates database table；
Lax entropy in the ID and field model table of the database table in table structural model, changes database table；
The ID of the database table in table structural model deletes database table；
The field information of the ID corresponding database tables of acquisition of the database table in table structural model realizes the inquiry of database table；
The ID of the database table in table structural model interpolation datas in corresponding database table；
According to incoming parameter, form corresponding insertion sentence and insert data；
The ID of the database table in table structural model changes data in corresponding database table；
According to incoming parameter, form corresponding renewal sentence and update the data；
The ID of the database table in table structural model deletes data in corresponding database table；
According to incoming parameter, form corresponding cancel statement and delete data；
The ID of the database table in table structural model inquires about data in corresponding database table；
According to incoming parameter, form corresponding query statement and return to Query Result.
Below by the specific descriptions to first embodiment, first embodiment is described in further detail.
The database table model of the present embodiment, including：Table structural model table, field model table, unified interface, definable interface.
Fig. 2 is the structure chart of the table structural model table of the database table model of the present embodiment.As shown in Fig. 2 the table structural model table structure of the present embodiment includes ID, type, the effect of database table.Wherein, ID is used for location entity table；The exhibition method of the type decision table data of table, such as list mode, tile mode etc.；The effect of table is, in order to record the purposes of the table, to be easy to quickly understand data structure.
Fig. 3 is the structure chart of the field model table of the database table model of the present embodiment.As shown in figure 3, the title of the field model table of the present embodiment including database table field, type and associated description information etc. length.These description informations determine the displaying of the SQL and front page layout information that create database table, it is numeric type such as to define a field, length 10, it is accurate to decimal point 2, so corresponding Database field is number (10,2), the input frame of front page layout also will accordingly have the limitation of numeral and decimal place.
Fig. 4 is the visualization structure figure at the definable interface of the present embodiment.Under definable showing interface as shown in Figure 4, table structural model table can accordingly be operated by definable interface.Interfaceization design is for a user very important, and the present embodiment provides concise interface, realizes the management of database table and field.
As shown in figure 4, the present embodiment it is exemplary create 6 table structural models, respectively by table be named as test 1 to test 6, wherein the management to table includes：Whether whether inquiry list is listed, displaying table type, creates entity table and the detailed description to table, specified otherwise.Client this interface can also be carried out as needed it is self-defined, such as directly increase delete option.
The database table model of present embodiment, database table, the essential information of data storage storehouse table are managed by table structural model table；By the description information of field model table data storage storehouse literary name section；Information in table structural model table and field model table is called by unified interface, perform the establishment and management of database table, so, the basic database table in database is managed by creating a unified data model, the operation of all about database table is all done by the table structural model table of the present embodiment, including creates table, modification table, increase, modification, deletion, the inquiry of deleting table and table data etc..It can be seen that, the present embodiment uses flexible database model, suitable for multiple business data model, and the access of database table and table data is realized by unified interface, reduce size of code, good interface is provided simultaneously, simplify operation, improve operating efficiency, so as to developer be freed from uninteresting repeated work, reduce size of code, error probability is reduced simultaneously, increases the stability of a system, when data list structure changes, only need to be changed in respective interface, it is not necessary to change backstage code；Using unified interface, normalization, uniformity and the flexibility of code are improved.
Second embodiment
Present embodiment is the creation method of database model table.Fig. 5 is the database table model creation method flow schematic diagram of second embodiment of the invention.As shown in figure 5, the database model table creation method of present embodiment comprises the following steps：
Step S201, creates table structural model table, the essential information of data storage storehouse table in the table structural model table.
Step S202, on the basis of the table structural model table, create table structural model table field model table as table structural model table sublist, and in the field model table data storage storehouse literary name section description information.
Step S203, sets up unified interface, connects the table structural model table, field model table and database table, by the essential information in unified interface call list structural model table and field model table, corresponding establishment and management is performed to the database table.
Present embodiment is described further below by specific second embodiment.
Fig. 6 is the database table model creation method flow schematic diagram of second embodiment of the invention.As shown in fig. 6, the database model creation method of the present embodiment, comprises the following steps：
Step S301, creates the essential informations such as table structural model table, ID, type, the effect of data storage storehouse table.
Step S302, is root with the table structural model table for being created, and creates the description informations on field such as field model table, field name, field type, the field length of literary name section of data storage storehouse table.
Step S303, sets up unified interface, and the table structural model table, field model table and database table are connected by the unified interface, and the data in call list structural model table and field model table carry out corresponding operating to database table.
Step S304, design definable interface, definable interface is connected with the table structural model table, so as to provide a user with the essential information and field information of table structural model table by way of interface, realizes the management to database table.
Explanation is needed exist for, step S303 and step S304 does not simultaneously exist relation sequentially, but a complementary process.
Step S305, the operation such as establishment, inquiry, deletion, modification of input database table and field at definable interface, by unified interface, performs corresponding operation.
Here to the operation of database table and field, including：
Database table is created, CreateTable (int TableID) obtains the field information of table according to TableID, and table statement and establishment table are built in generation.
Fig. 7 is the definable surface chart that the database table model that second embodiment of the invention is created performs " addition table " operation.One essential information of database table of this interface definition, according to these information association location database tables and its field information.Fig. 8 is the definable surface chart that the database table model that second embodiment of the invention is created performs " addition field " operation.These information are combined with Fig. 7, form the complete information of database table.
Modification database table, AlterTable (int TableID, int
FieldID), i.e., according to TableID and FieldID, table structure is changed.
Database table is deleted, DropTable (int TableID) deletes table according to TableID.
The field information of database table is inquired about, GetTableField (int TableID) obtains certain field information of table according to TableID.
Certain data of table is added, InsertTableData (Map dataMap), that is, according to incoming parameter, forms corresponding insertion sentence and inserts data.
Certain data of table is changed, UpdateTableData (Map dataMap), that is, according to incoming parameter, forms corresponding renewal sentence and updates the data.
Certain data of table is deleted, DeleteTableData (Map dataMap), that is, according to incoming parameter, forms corresponding cancel statement and deletes data.
Certain data of table are inquired about, QueryTableData (Map dataMap), that is, according to incoming parameter, forms corresponding query statement and returns to Query Result.
As shown in fig. 7, the table structural model process to create entitled " test 7 ".Under the Option Box of " addition table ", assignment is carried out by the attribute to table, create a new table structural model.Here the attribute of table can include：Whether whether inquiry list is listed, table type, creates entity table, the detailed description of table and specified otherwise etc., it is also possible to the attributes section including other tables, such as creation time, create explanation.Establishment attribute exemplary herein is the model table " test 7 " of " list, document table, there is entity table ".
As shown in figure 8, being the operation to field.Under the Option Box of " addition field ", assignment is carried out by field attribute, so as to realize the operation to " addition field ".Here the attribute of field can include：Field ID, field name, field length, whether code field, field type, decimal place, put in order, whether allow room, display length, composite attribute, sublist, whether editable, whether major key, table details, automatically generate rule etc., it is also possible to field attribute is configured as needed.Exemplary illustration as shown in Figure 8 is not construed as limiting to the present invention.
The creation method of the database table model of present embodiment, using flexible database model, suitable for multiple business data model, and realize that the additions and deletions of database table and table data change by unified interface and look into, reduce size of code, good interface is provided simultaneously, simplify operation, improve operating efficiency, so as to developer be freed from uninteresting repeated work, reduce size of code, error probability is reduced simultaneously, increases the stability of a system, when data list structure changes, only need to be changed in respective interface, it is not necessary to change backstage code；Using unified interface, normalization, uniformity and the flexibility of code are improved.
As seen through the above description of the embodiments, those skilled in the art can be understood that the present invention can add the mode of required general hardware platform to realize by software.Based on such understanding, the part that technical scheme substantially contributes to prior art in other words can be embodied in the form of software product, the computer software product can be stored in storage medium, such as ROM/RAM, magnetic disc, CD, including some instructions are used to so that a computer equipment（Can be personal computer, server, or network equipment etc.）Perform the method described in some parts of each embodiment of the invention or embodiment.
Each embodiment in this specification is described by the way of progressive, and identical similar part is mutually referring to what each embodiment was stressed is the difference with other embodiment between each embodiment.For especially for device or system embodiment, because it is substantially similar to embodiment of the method, so describing fairly simple, the relevent part can refer to the partial explaination of embodiments of method.Apparatus and system embodiment described above is only schematical, the wherein described unit illustrated as separating component can be or may not be physically separate, the part shown as unit can be or may not be physical location, a place is may be located at, or can also be distributed on multiple NEs.Some or all of module therein can be according to the actual needs selected to realize the purpose of this embodiment scheme.Those of ordinary skill in the art are without creative efforts, you can to understand and implement.
The above; the only present invention preferably specific embodiment, but protection scope of the present invention is not limited thereto, any one skilled in the art the invention discloses technical scope in; the change or replacement that can be readily occurred in, should all be included within the scope of the present invention.Therefore, protection scope of the present invention should be defined by scope of the claims.
Claims (10)
1. a kind of database table model, it is characterised in that the model includes：Table structural model table, field model table, unified interface；
Wherein, the table structural model table is used to manage database table, the essential information of data storage storehouse table；The field model table is the sublist of table structural model table, for the description information of data storage storehouse literary name section；The unified interface is used to connect the table structural model table and database table, for being called by information in table structural model table and field model table, performs the establishment and management of database table.
2. database table model according to claim 1, it is characterized in that, the database table model also includes definable interface, the definable interface is connected with the table structural model table, essential information and field information for providing a user with table structural model table by way of interface, realize the management to database table.
3. database table model according to claim 1 and 2, it is characterised in that the essential information of the database table includes：The ID of database table, title, purposes.
4. database table model according to claim 1 and 2, it is characterised in that the description information of the database table field includes：Field name, field type and field length.
5. database table model according to claim 1 and 2, it is characterised in that the unified interface is further used for：
The ID of the database table in table structural model table obtains the field information of database table, and generation is built table statement and creates database table；
Lax entropy in the ID and field model table of the database table in table structural model, changes database table；
The ID of the database table in table structural model deletes database table；
The field information of the ID corresponding database tables of acquisition of the database table in table structural model realizes the inquiry of database table；
The ID of the database table in table structural model interpolation datas in corresponding database table；
According to incoming parameter, form corresponding insertion sentence and insert data；
The ID of the database table in table structural model changes data in corresponding database table；
According to incoming parameter, form corresponding renewal sentence and update the data；
The ID of the database table in table structural model deletes data in corresponding database table；
According to incoming parameter, form corresponding cancel statement and delete data；
The ID of the database table in table structural model inquires about data in corresponding database table；
According to incoming parameter, form corresponding query statement and return to Query Result.
6. a kind of creation method of database table model, it is characterised in that methods described comprises the following steps：
Create table structural model table, the essential information of data storage storehouse table in the table structural model table；
On the basis of the table structural model table, create table structural model table field model table as table structural model table sublist, and in the field model table data storage storehouse literary name section description information；
Unified interface is set up, the table structural model table, field model table and database table is connected, by the essential information in unified interface call list structural model table and field model table, corresponding establishment and management is performed to the database table.
7. creation method according to claim 6, it is characterised in that methods described also includes：
Design definable interface, the definable interface is connected with the table structural model table, and table structural model table, the essential information of field model table and field information are provided a user with by way of interface, provides the user the entrance for realizing database table management.
8. the creation method according to claim 6 or 7, it is characterised in that the essential information of the database table includes：The ID of database table, title, purposes.
9. the creation method according to claim 6 or 7, it is characterised in that the description information of the database table field includes：Field name, field type and field length.
10. the creation method according to claim 6 or 7, it is characterised in that it is described the database table is performed it is corresponding create and manage, further include：
The ID of the database table in table structural model table obtains the field information of database table, and generation is built table statement and creates database table；
Lax entropy in the ID and field model table of the database table in table structural model, changes database table；
The ID of the database table in table structural model deletes database table；
The field information of the ID corresponding database tables of acquisition of the database table in table structural model realizes the inquiry of database table；
The ID of the database table in table structural model interpolation datas in corresponding database table；
According to incoming parameter, form corresponding insertion sentence and insert data；
The ID of the database table in table structural model changes data in corresponding database table；
According to incoming parameter, form corresponding renewal sentence and update the data；
The ID of the database table in table structural model deletes data in corresponding database table；
According to incoming parameter, form corresponding cancel statement and delete data；
The ID of the database table in table structural model inquires about data in corresponding database table；
According to incoming parameter, form corresponding query statement and return to Query Result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511018430.7A CN106933837A (en) | 2015-12-29 | 2015-12-29 | A kind of database table model and creation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511018430.7A CN106933837A (en) | 2015-12-29 | 2015-12-29 | A kind of database table model and creation method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106933837A true CN106933837A (en) | 2017-07-07 |
Family
ID=59442245
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201511018430.7A Pending CN106933837A (en) | 2015-12-29 | 2015-12-29 | A kind of database table model and creation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106933837A (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109582803A (en) * | 2018-11-30 | 2019-04-05 | 广东电网有限责任公司 | The construction method and system of competitive intelligence database |
| CN110109893A (en) * | 2018-02-02 | 2019-08-09 | 北京京东尚科信息技术有限公司 | The method and apparatus of data modeling and operation |
| WO2019153555A1 (en) * | 2018-02-12 | 2019-08-15 | 平安科技（深圳）有限公司 | Method and device for generating er relationships, computer device, and storage medium |
| WO2019153514A1 (en) * | 2018-02-12 | 2019-08-15 | 平安科技（深圳）有限公司 | Service system dynamic generation method and apparatus, computer device, and storage medium |
| CN110222032A (en) * | 2019-05-22 | 2019-09-10 | 武汉掌游科技有限公司 | A kind of generalised event model based on software data analysis |
| CN110309145A (en) * | 2019-04-15 | 2019-10-08 | 中国银行股份有限公司 | A kind of tables of data method of adjustment, tables of data creation method and device |
| CN110490761A (en) * | 2019-07-26 | 2019-11-22 | 广西电网有限责任公司 | A kind of power grid distribution net equipment account data model modelling approach |
| CN110866012A (en) * | 2019-11-11 | 2020-03-06 | 北京知道创宇信息技术股份有限公司 | Table structure management method, device, server and readable storage medium |
| CN111241053A (en) * | 2018-11-29 | 2020-06-05 | 中国移动通信集团四川有限公司 | Data table creating method, device, equipment and storage medium |
| CN112487006A (en) * | 2020-11-30 | 2021-03-12 | 山东浪潮通软信息科技有限公司 | Implementation method for dynamically editing data structure and generating database table |
| CN112486990A (en) * | 2020-11-27 | 2021-03-12 | 山东浪潮通软信息科技有限公司 | Method and equipment for synchronizing database table structure according to model description |
| CN112559528A (en) * | 2020-12-15 | 2021-03-26 | 北京动力机械研究所 | Engine steady-state data mining and statistical method and device |
| CN112835887A (en) * | 2019-11-25 | 2021-05-25 | 航天信息股份有限公司 | Database management method, database management device, computing equipment and storage medium |
| CN114048194A (en) * | 2022-01-12 | 2022-02-15 | 树根互联股份有限公司 | Data management method and device and electronic equipment |
| CN117271532A (en) * | 2023-11-22 | 2023-12-22 | 舟谱数据技术南京有限公司 | Method, device and equipment for displaying database table structure and readable storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101105813A (en) * | 2007-09-11 | 2008-01-16 | 金蝶软件（中国）有限公司 | Data base extension method and device |
| CN102346785A (en) * | 2011-11-15 | 2012-02-08 | 北京创腾科技有限公司 | Method and device for directly self-defining field of database |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| CN103092589A (en) * | 2011-11-03 | 2013-05-08 | 浙江省公众信息产业有限公司 | SSH (Struts, Spring and Hibernate) frame based code automatic generation method |
| CN103226478A (en) * | 2013-05-22 | 2013-07-31 | 北京金和软件股份有限公司 | Method for automatically generating and using code |
| CN105069033A (en) * | 2015-07-22 | 2015-11-18 | 北京京东尚科信息技术有限公司 | Method and device for creating database table model |
-
2015
- 2015-12-29 CN CN201511018430.7A patent/CN106933837A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101105813A (en) * | 2007-09-11 | 2008-01-16 | 金蝶软件（中国）有限公司 | Data base extension method and device |
| CN103092589A (en) * | 2011-11-03 | 2013-05-08 | 浙江省公众信息产业有限公司 | SSH (Struts, Spring and Hibernate) frame based code automatic generation method |
| CN102346785A (en) * | 2011-11-15 | 2012-02-08 | 北京创腾科技有限公司 | Method and device for directly self-defining field of database |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| CN103226478A (en) * | 2013-05-22 | 2013-07-31 | 北京金和软件股份有限公司 | Method for automatically generating and using code |
| CN105069033A (en) * | 2015-07-22 | 2015-11-18 | 北京京东尚科信息技术有限公司 | Method and device for creating database table model |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110109893A (en) * | 2018-02-02 | 2019-08-09 | 北京京东尚科信息技术有限公司 | The method and apparatus of data modeling and operation |
| WO2019153555A1 (en) * | 2018-02-12 | 2019-08-15 | 平安科技（深圳）有限公司 | Method and device for generating er relationships, computer device, and storage medium |
| WO2019153514A1 (en) * | 2018-02-12 | 2019-08-15 | 平安科技（深圳）有限公司 | Service system dynamic generation method and apparatus, computer device, and storage medium |
| CN111241053A (en) * | 2018-11-29 | 2020-06-05 | 中国移动通信集团四川有限公司 | Data table creating method, device, equipment and storage medium |
| CN111241053B (en) * | 2018-11-29 | 2022-08-23 | 中国移动通信集团四川有限公司 | Data table creating method, device, equipment and storage medium |
| CN109582803A (en) * | 2018-11-30 | 2019-04-05 | 广东电网有限责任公司 | The construction method and system of competitive intelligence database |
| CN110309145A (en) * | 2019-04-15 | 2019-10-08 | 中国银行股份有限公司 | A kind of tables of data method of adjustment, tables of data creation method and device |
| CN110222032A (en) * | 2019-05-22 | 2019-09-10 | 武汉掌游科技有限公司 | A kind of generalised event model based on software data analysis |
| CN110490761B (en) * | 2019-07-26 | 2022-06-28 | 广西电网有限责任公司 | Power grid distribution network equipment ledger data model modeling method |
| CN110490761A (en) * | 2019-07-26 | 2019-11-22 | 广西电网有限责任公司 | A kind of power grid distribution net equipment account data model modelling approach |
| CN110866012A (en) * | 2019-11-11 | 2020-03-06 | 北京知道创宇信息技术股份有限公司 | Table structure management method, device, server and readable storage medium |
| CN112835887A (en) * | 2019-11-25 | 2021-05-25 | 航天信息股份有限公司 | Database management method, database management device, computing equipment and storage medium |
| CN112486990A (en) * | 2020-11-27 | 2021-03-12 | 山东浪潮通软信息科技有限公司 | Method and equipment for synchronizing database table structure according to model description |
| CN112486990B (en) * | 2020-11-27 | 2023-05-02 | 浪潮通用软件有限公司 | Method and equipment for describing synchronous database table structure according to model |
| CN112487006A (en) * | 2020-11-30 | 2021-03-12 | 山东浪潮通软信息科技有限公司 | Implementation method for dynamically editing data structure and generating database table |
| CN112559528A (en) * | 2020-12-15 | 2021-03-26 | 北京动力机械研究所 | Engine steady-state data mining and statistical method and device |
| CN114048194A (en) * | 2022-01-12 | 2022-02-15 | 树根互联股份有限公司 | Data management method and device and electronic equipment |
| CN117271532A (en) * | 2023-11-22 | 2023-12-22 | 舟谱数据技术南京有限公司 | Method, device and equipment for displaying database table structure and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106933837A (en) | A kind of database table model and creation method | |
| CN103294475B (en) | The business automatic creation system of graphic based business scenario and domain template and method | |
| CN109145047B (en) | User tag portrait configuration method, data processing device and storage medium | |
| CN102426582B (en) | Data manipulation management devices and data manipulation management method | |
| CN102254029A (en) | View-based data access system and method | |
| CN102902763B (en) | The method of association, retrieving information process data and process information task and device | |
| CN113760971B (en) | Method, computing device and storage medium for retrieving data of a graph database | |
| CN102985922A (en) | Method and apparatus for managing distributed computations within a computation space | |
| CN112311571B (en) | Network topology generation method and device, electronic equipment and non-transitory storage medium | |
| CN102375827A (en) | Method for fast loading versioned electricity network model database | |
| KR101244466B1 (en) | Method for data modelling using NoSQL | |
| CN106886568A (en) | One kind point table method, device and electronic equipment | |
| CN111666355B (en) | Model construction method and device for field, data and scene three-layer model | |
| CN109885585A (en) | Support the distributed data base system and method for storing process, trigger and view | |
| JP4265974B2 (en) | Information processing device | |
| CN103793401B (en) | Set up the method and device of the shared index of multiple database table | |
| CN117369843A (en) | Graphical interface drawing method of network configuration tool | |
| CN110222032A (en) | A kind of generalised event model based on software data analysis | |
| US6839749B1 (en) | Network representation and manipulation thereof | |
| CN108959584A (en) | A kind of method and device of the processing diagram data based on community structure | |
| CN112162731B (en) | Data expansion method, device, storage medium and electronic device | |
| US9031998B2 (en) | Analytics enablement objects | |
| KR101107582B1 (en) | Web ontology editing and operating system | |
| CN109376148B (en) | Data processing method and device for slow change dimension table and electronic equipment | |
| CN112905627A (en) | Data processing method, data processing device, computer equipment and storage medium |
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: 20170707 |
|
| RJ01 | Rejection of invention patent application after publication |