CN106919615A - Data access method and system - Google Patents
Data access method and system Download PDFInfo
- Publication number
- CN106919615A CN106919615A CN201510999037.4A CN201510999037A CN106919615A CN 106919615 A CN106919615 A CN 106919615A CN 201510999037 A CN201510999037 A CN 201510999037A CN 106919615 A CN106919615 A CN 106919615A
- Authority
- CN
- China
- Prior art keywords
- data
- field
- model
- database
- type
- 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
The present invention relates to data processing field, a kind of data access method and system are disclosed.Wherein, the method includes：Create database model structure, the database model structure polytype field that at least the various models including predetermined quantity occur simultaneously；Based on data to be stored, selected section or whole fields create data model from the database model structure for being created, and generate field Map Profile corresponding with the data model；And stored in the database model structure data model based on the field Map Profile.By above-mentioned method and system, when due to business demand change needs to increase new data model when, without the storage that can just realize various data models is modified or increased to existing code.
Description
Technical field
The present invention relates to data processing field, in particular it relates to a kind of data access method and system.
Background technology
In actual applications, the field needed in business model data persistence to database is frequently encountered
Scape.Common practice is to design single database table structure to each business model according to business demand to enter
Row storage.So problems faced is often to increase the table that a business model is accomplished by designing a set of correlation
Structure is used for storage service model data, while needing bottom-up development data access program to complete this
The access of business model data, resulting workload is huge.
The content of the invention
It is an object of the invention to provide a kind of data access method and system, to solve of the prior art asking
Topic.
To achieve these goals, the present invention provides a kind of data access method, wherein, the method includes：
Database model structure is created, the database model structure at least various models including predetermined quantity are handed over
Polytype field of collection；Based on data to be stored from the database model structure for being created selector
Divide or whole fields create data model, generate field mapping corresponding with the data model and configure text
Part；And data model storage is arrived by the database model based on the field Map Profile
In structure.
Present invention also offers a kind of data access arrangement, wherein, the system includes：Model creating unit,
For creating database model structure, the database model structure at least various moulds including predetermined quantity
Polytype field that type occurs simultaneously；Model creation and dispensing unit, for based on data to be stored from institute
Selected section or whole fields create data model, generation and the number in the database model structure of establishment
According to the corresponding field Map Profile of model；And import unit, based on field mapping configuration text
Part stores in the database model structure data model.
By above-mentioned technical proposal, when due to business demand change needs to increase new data model when, can
Database model structure is created with the polytype field occured simultaneously based on various models, is then based on waiting to deposit
Storage data selected section or whole fields from the model structure for being created create data model, generation and institute
The corresponding field Map Profile of data model is stated, such that it is able to data model storage is arrived into described
In database model structure.Thus, can just be realized without being modified to existing code or being increased
The storage of various data models, correspondingly reduces development cost, improves development efficiency.
Other features and advantages of the present invention will be described in detail in subsequent specific embodiment part.
Brief description of the drawings
Accompanying drawing is, for providing a further understanding of the present invention, and to constitute the part of specification, with
Following specific embodiment is used to explain the present invention together, but is not construed as limiting the invention.
In accompanying drawing：
Fig. 1 is the flow chart of the data access method according to one embodiment of the present invention；And
Fig. 2 is the block diagram of the data access arrangement according to one embodiment of the present invention.
Specific embodiment
Specific embodiment of the invention is described in detail below in conjunction with accompanying drawing.It should be appreciated that
Specific embodiment described herein is merely to illustrate and explain the present invention, and is not limited to this hair
It is bright.
Fig. 1 is the flow chart of the data access method according to one embodiment of the present invention.
As shown in figure 1, being included according to the data access method that one embodiment of the present invention is provided：
S100, creates database model structure, and the database model structure at least includes predetermined quantity
Polytype field that various models occur simultaneously；
S102, based on data to be stored from the database model structure for being created selected section or whole word
Section creates data model, generates field Map Profile corresponding with the data model；And
S104, the database mould is arrived based on the field Map Profile by data model storage
In type structure.
When due to business demand change needs to increase new data model when, can be occured simultaneously based on various models
Polytype field create database model structure, be then based on data to be stored from the number for being created
Data model, generation and the data model pair are created according to selected section in the model structure of storehouse or whole fields
The field Map Profile answered, such that it is able to data model storage is arrived into the database model knot
In structure.Thus, various data models can just be realized without being modified to existing code or being increased
Storage, correspondingly reduce development cost, improve development efficiency.
In step S104, the data model can be stored to the number by data memory interface
According in the model structure of storehouse.
According to one embodiment of the present invention, the method also includes：
Interface is deleted to the database model knot by digital independent interface, data more new interface or data
Data model in structure is read out, updates or deletes.
By providing unified data-interface, it is ensured that the uniformity of program and flexibility.
According to one embodiment of the present invention, the field at least includes one of following：Character string class
The field of type, the field of numeric type, the field of date type, the field of binary data types and mark
Know the field of type.
Wherein, the field of identity type can be the field for showing model ID.
Fig. 2 is the block diagram of the data access arrangement according to one embodiment of the present invention.
As shown in Fig. 2 the data access arrangement of one embodiment of the present invention includes：Model creating unit
20, for creating model structure, the database model structure at least various models including predetermined quantity
The polytype field occured simultaneously；Model creation and dispensing unit 22, for based on data to be stored from institute
Selected section or whole fields create data model, generation and the number in the database model structure of establishment
According to the corresponding field Map Profile of model；And import unit 24, mapped based on the field and configured
File stores in the database model structure data model.
When due to business demand change needs to increase new data model when, can be occured simultaneously based on various models
Polytype field create database model structure, be then based on data to be stored from the number for being created
Data model, generation and the data model pair are created according to selected section in the model structure of storehouse or whole fields
The field Map Profile answered, such that it is able to data model storage is arrived into the database model knot
In structure.Thus, various data models can just be realized without being modified to existing code or being increased
Storage, correspondingly reduce development cost, improve development efficiency.
According to one embodiment of the present invention, the import unit 22 can be incited somebody to action by data memory interface
The data model is stored in the database model structure.
By providing unified data-interface, it is ensured that the uniformity of program and flexibility.
According to one embodiment of the present invention, the field at least includes one of following：Character string class
The field of type, the field of numeric type, the field of date type, the field of binary data types and mark
Know the field of type.
Wherein, the field of identity type can be the field for showing model ID.
It will be appreciated by those skilled in the art that what the above-mentioned description on field was merely exemplary, not
For limiting the present invention.
In the present invention, for predetermined quantity, those skilled in the art can be set according to actual conditions
Fixed, the present invention is defined not to this.
For example, can for example be wrapped by the database model structure of the above method of the present invention and system creation
Include：100 be used for store character string type field, 100 be used for store numeric type field,
50 are used to store the field of date type, 10 field, 1 use for being used to deposit binary system big data
In the field for showing model ID.
After create above-mentioned database model structure, data to be stored can be based on from being created
Selected section or whole fields create data model, generation and the data model in database model structure
Corresponding field Map Profile.Field Map Profile corresponding with the newly-built data model
Can be used for which field in specified database model structure belongs to the newly-built data model.On field
The example of Map Profile is as follows：
Be can be seen that from configuration above file can realize data model and data by the configuration file
Mapping between the model structure of storehouse, such as data above model have been used in database model structure
Attribute_2、Attribute_17、Attribute_37、Attribute_123、Attribute_145、
Attribute_187 fields, newly-built model will be automatically stored in these fields of database model.
Thus, can be by newly-built data model storage to the number based on the field Map Profile
In corresponding field according to storehouse model structure.
It will be appreciated by those skilled in the art that what above-mentioned example was merely exemplary, it is not intended to limit this
Invention.
The preferred embodiment of the present invention is described in detail above in association with accompanying drawing, but, the present invention is not limited
Detail in above-mentioned implementation method, in range of the technology design of the invention, can be to the present invention
Technical scheme carry out various simple variants, these simple variants belong to protection scope of the present invention.
It is further to note that each particular technique described in above-mentioned specific embodiment is special
Levy, in the case of reconcilable, can be combined by any suitable means.In order to avoid need not
The repetition wanted, the present invention is no longer separately illustrated to various possible combinations.
Additionally, can also be combined between a variety of implementation methods of the invention, as long as its
Without prejudice to thought of the invention, it should equally be considered as content disclosed in this invention.
Claims (7)
1. a kind of data access method, wherein, the method includes：
Create database model structure, the database model structure at least various moulds including predetermined quantity
Polytype field that type occurs simultaneously；
Based on data to be stored, selected section or whole fields are created from the database model structure for being created
Data model is built, field Map Profile corresponding with the data model is generated；And
Data model storage is arrived by the database model knot based on the field Map Profile
In structure.
2. method according to claim 1, wherein, by data memory interface by the data
Model is stored in the database model structure.
3. method according to claim 1, wherein, the method also includes：
Interface is deleted to the database model knot by digital independent interface, data more new interface or data
Data model in structure is read out, updates or deletes.
4. the method according to any one of claim 1-3, wherein, the field at least includes
One of below：The field of character string type, the field of numeric type, the field of date type, two
The field of binary data type and the field of identity type.
5. a kind of data access arrangement, wherein, the system includes：
Model creating unit, for creating database model structure, the database model structure is at least wrapped
Include polytype field that various models of predetermined quantity occur simultaneously；
Model creation and dispensing unit, for based on data to be stored from the database model structure for being created
Middle selected section or whole fields create data model, generate field mapping corresponding with the data model
Configuration file；And
Import unit, the data are arrived based on the field Map Profile by data model storage
In the model structure of storehouse.
6. system according to claim 5, wherein, the import unit is connect by data storage
Mouth is by data model storage to the database model structure.
7. the system according to claim 5 or 6, wherein, the field at least include it is following in
One of：The field of character string type, the field of numeric type, the field of date type, binary number
According to the field and the field of identity type of type.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510999037.4A CN106919615A (en) | 2015-12-28 | 2015-12-28 | Data access method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510999037.4A CN106919615A (en) | 2015-12-28 | 2015-12-28 | Data access method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106919615A true CN106919615A (en) | 2017-07-04 |
Family
ID=59455136
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510999037.4A Pending CN106919615A (en) | 2015-12-28 | 2015-12-28 | Data access method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106919615A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108256089A (en) * | 2018-01-24 | 2018-07-06 | 清华大学 | The transform method and device of Internet of Things machine data |
| CN111008189A (en) * | 2019-11-26 | 2020-04-14 | 浙江电子口岸有限公司 | Dynamic data model construction method |
| CN114286356A (en) * | 2021-12-29 | 2022-04-05 | 河北电信设计咨询有限公司 | System and method for constructing 5G business model based on database |
| CN114286356B (en) * | 2021-12-29 | 2024-07-30 | 河北电信设计咨询有限公司 | System and method for constructing 5G service model based on database |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1421517A1 (en) * | 2001-08-01 | 2004-05-26 | Berg-Jacobsen Holding AS | Adaptable database runtime kernel |
| CN101067814A (en) * | 2007-05-10 | 2007-11-07 | 浪潮集团山东通用软件有限公司 | Mapping conversion method between data access level Xml format data and relational data |
| CN102819547A (en) * | 2012-01-13 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method and device for configuring field attribute |
| CN102937965A (en) * | 2012-09-29 | 2013-02-20 | 山东浪潮齐鲁软件产业股份有限公司 | Meta-system design method based on data model |
| CN104361140A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Dynamically generated data model configuration device and method |
-
2015
- 2015-12-28 CN CN201510999037.4A patent/CN106919615A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1421517A1 (en) * | 2001-08-01 | 2004-05-26 | Berg-Jacobsen Holding AS | Adaptable database runtime kernel |
| CN101067814A (en) * | 2007-05-10 | 2007-11-07 | 浪潮集团山东通用软件有限公司 | Mapping conversion method between data access level Xml format data and relational data |
| CN102819547A (en) * | 2012-01-13 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method and device for configuring field attribute |
| CN102937965A (en) * | 2012-09-29 | 2013-02-20 | 山东浪潮齐鲁软件产业股份有限公司 | Meta-system design method based on data model |
| CN104361140A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Dynamically generated data model configuration device and method |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108256089A (en) * | 2018-01-24 | 2018-07-06 | 清华大学 | The transform method and device of Internet of Things machine data |
| CN108256089B (en) * | 2018-01-24 | 2019-06-18 | 清华大学 | The transform method and device of Internet of Things machine data |
| CN111008189A (en) * | 2019-11-26 | 2020-04-14 | 浙江电子口岸有限公司 | Dynamic data model construction method |
| CN111008189B (en) * | 2019-11-26 | 2023-08-25 | 浙江电子口岸有限公司 | Dynamic data model construction method |
| CN114286356A (en) * | 2021-12-29 | 2022-04-05 | 河北电信设计咨询有限公司 | System and method for constructing 5G business model based on database |
| CN114286356B (en) * | 2021-12-29 | 2024-07-30 | 河北电信设计咨询有限公司 | System and method for constructing 5G service model based on database |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102254029B (en) | View-based data access system and method | |
| CN103402194B (en) | A kind of method recommending software when software upgrading and realize the system of the method | |
| CN103488704B (en) | A kind of date storage method and device | |
| CN106599104A (en) | Mass data association method based on redis cluster | |
| CN104915383B (en) | A kind of method of automatic adaptation object during Universal Database accesses | |
| CN104601736A (en) | Method and device for realizing short uniform resource locator (URL) service | |
| CN107171934B (en) | Information processing method, instant communication client and the system of immediate communication tool | |
| EP1650681A3 (en) | Data structure, database system, and method for data management and/or conversion | |
| CN105989076A (en) | Data statistical method and device | |
| CN105389367A (en) | Power network graphic multi-tense and multi-level distributed storage method based on Mongo database | |
| CN109902126B (en) | Loading system supporting HIVE automatic partition and implementation method thereof | |
| CN108536745A (en) | Tables of data extracting method, terminal, equipment and storage medium based on Shell | |
| CN103853714A (en) | Data processing method and device | |
| CN108255859A (en) | A kind of method and system for being used to establish index for mass digital certificate | |
| CN104346466A (en) | Method and device of adding new attribute data in database | |
| CN102467525A (en) | Document associating method and system | |
| CN106528641A (en) | Data storage method and device and communication gateway machine | |
| CN106354775A (en) | Data dynamic configuration system and method based on custom fields | |
| CN106919615A (en) | Data access method and system | |
| CN105912723B (en) | A kind of storage method of custom field | |
| CN109271247A (en) | Memory Optimize Method, device, computer installation and storage medium | |
| CN104753891B (en) | A kind of XML message analysis method and device | |
| CN107820610B (en) | A kind of implementation method and its device of Multi-stage electronic map | |
| CN105138562A (en) | Data processing method and device of relational database | |
| CN107273443A (en) | A kind of hybrid index method based on big data model metadata |
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: 20170704 |
|
| RJ01 | Rejection of invention patent application after publication |