CN103870605A - Data base virtual image achieving method orientated to object - Google Patents

Data base virtual image achieving method orientated to object Download PDF

Info

Publication number
CN103870605A
CN103870605A CN201410136790.6A CN201410136790A CN103870605A CN 103870605 A CN103870605 A CN 103870605A CN 201410136790 A CN201410136790 A CN 201410136790A CN 103870605 A CN103870605 A CN 103870605A
Authority
CN
China
Prior art keywords
data base
virtual image
object oriented
implementation method
object class
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
Application number
CN201410136790.6A
Other languages
Chinese (zh)
Inventor
张可彦
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
NANJING UMA SOFTWARE TECHNOLOGY Co Ltd
Original Assignee
NANJING UMA SOFTWARE TECHNOLOGY Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by NANJING UMA SOFTWARE TECHNOLOGY Co Ltd filed Critical NANJING UMA SOFTWARE TECHNOLOGY Co Ltd
Priority to CN201410136790.6A priority Critical patent/CN103870605A/en
Publication of CN103870605A publication Critical patent/CN103870605A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/289Object oriented databases

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a data base virtual image achieving method orientated to an object. The method comprises the following steps that (a) a data base table and a view are extracted to form a virtual object class; (b) the virtual object class is stored in an internal memory; (c) data base operation is completed through access to the virtual object class; the same data structure is adopted in the object class, the data base table and the view; the same data structure comprises a field, an attribute, the data type, the storage length, progressive increase, keywords and/or field notes. According to the data base virtual image achieving method orientated to the object, the data base table and the view are extracted to form the virtual object class, and the data base operation is completed through access to the virtual object class, so that the developing speed of software engineering can be greatly accelerated, code redundancy and maintenance cost of the engineering are reduced, and quality and stability of the software engineering can be improved.

Description

OODB Object Oriented Data Base virtual image implementation method
Technical field
The present invention relates to a kind of database mirroring implementation method, relate in particular to a kind of OODB Object Oriented Data Base virtual image implementation method.
Background technology
Enterprise Resources Plan ERP (Enterprise Resource Planning), it utilizes computer technology, the logistics of enterprise, the stream of people, cash flow, information flow are united and managed, client is needed together with the production and operating activities of enterprises and supplier's resource consolidation, the series of problems such as the operation situation that solve enterprise product cost problem for business decision layer provides, improves operating efficiency and fund, make it to become can be completely by carry on the work a kind of brand-new effective management method of management of user's request.ERP runs through the operation flow of whole company, as the core of IT application in enterprises, is responsible for inheriting other data of information system or service logic, integrates inside and outside portion of enterprise resource, makes it maximized for enterprises service, reaches generation zero inventory.Along with the application of ecommerce, mobile Internet, ERP Information System Function is extended to the links such as supplier, client, logistics accordingly, is widely used in every field, and can be optimized improvement to links easily.
The current database for Enterprise Resources Plan, relatively more conventional is MVC framework, and (Model View Controller model-view-controller) Model (model) represents that application program core, View (view) show that data (data-base recording), Controller (controller) process input (write into Databasce record).Existing framework, taking Model as control module, for engineering project is brought following hidden danger: 1, Model object is a lot, causes very redundancy of code; 2, Function Extension, must need to revise tri-layers of Model, View, Controller, safeguards and upgrades pretty troublesome.
Summary of the invention
Technical matters to be solved by this invention is to provide a kind of OODB Object Oriented Data Base virtual image implementation method, can greatly accelerate the tempo of development of soft project, reduces code redundancy and the maintenance cost of engineering, and can improve quality and the stability of soft project.
The present invention solves the problems of the technologies described above the technical scheme adopting to be to provide a kind of OODB Object Oriented Data Base virtual image implementation method, comprises the steps: a) extracted data storehouse table and view formation virtual objects class; B) virtual objects class is stored in internal memory; C) complete database manipulation by accessing described virtual objects class.
Above-mentioned OODB Object Oriented Data Base virtual image implementation method, wherein, described object class, database table and view adopt identical data structure.
Above-mentioned OODB Object Oriented Data Base virtual image implementation method, whether wherein, whether described identical data structure comprise field, attribute, data type, memory length, increase progressively, key word and/or field remarks.
Above-mentioned OODB Object Oriented Data Base virtual image implementation method, wherein, the database manipulation of described step in c) comprises that data increase, delete, amendment and/or query manipulation.
The present invention contrasts prior art following beneficial effect: OODB Object Oriented Data Base virtual image implementation method provided by the invention, form virtual objects class by extracted data storehouse table and view, and utilize the described virtual objects class of access to complete database manipulation, thereby can practical function interface configurations, the rights management of field level/record level and multilingual, greatly accelerate the tempo of development of soft project, reduce code redundancy and the maintenance cost of engineering, and can improve quality and the stability of soft project.
Brief description of the drawings
Fig. 1 is OODB Object Oriented Data Base virtual image system architecture schematic diagram of the present invention;
Fig. 2 is OODB Object Oriented Data Base virtual image realization flow schematic diagram of the present invention.
Embodiment
Below in conjunction with drawings and Examples, the invention will be further described.
Fig. 1 is OODB Object Oriented Data Base virtual image system architecture schematic diagram of the present invention; Fig. 2 is OODB Object Oriented Data Base virtual image realization flow schematic diagram of the present invention.
Refer to Fig. 1 and Fig. 2, OODB Object Oriented Data Base virtual image implementation method provided by the invention comprises the steps:
Step S1: extracted data storehouse table and view form virtual objects class; Described object class, database table and view adopt identical data structure; Comprise identical field, attribute, data type, memory length, whether increase progressively, the data structure such as key word and/or field remarks whether;
Specifically comprise following operation:
1) initObject is written into list structure initialization virtual objects, and the attribute of virtual objects mapping has: field name, type of database, field value, whether major key, whether legal identity, whether can be empty, whether have default value, whether return to foreground, field description;
2) getObjectColumns obtains the list field of virtual objects mapping;
3) columnExists judges whether row exist;
4) executeSql carries out SQL statement;
5) getMaxID obtains last record;
6) Query carries out SQL and looks into new statement.
Step S2: virtual objects class is stored in internal memory; When maiden visit virtual objects, virtual objects can be written into database structure automatically, calls initialization object method initObject.
Step S3: complete database manipulation by accessing described virtual objects class; The method comprising has:
1) listColumns (vObject, tableName): the processing showing with list;
2) detailColumns (vObject, tableName): the processing that details show;
3) dataSearch (vObject, tableName, searchField): the processing of search;
4) columnSort (vObject, tableName, sortColumn): the processing of sequence;
5) newData (vObject, tableName, newData): the processing of newly-increased record, comprises interface display, two call methods of data processing;
6) deleteData (vObject, tableName, deleteRecord): the processing of deletion record, comprises interface display, two call methods of data processing;
7) modifyData (vObject, tableName, modifyRecord, newData): the processing of amendment record, comprises interface display, two call methods of data processing.
In sum, OODB Object Oriented Data Base virtual image implementation method provided by the invention, form virtual objects class by extracted data storehouse table and view, and utilize the described virtual objects class of access to complete database manipulation, thereby realize the fast Development of soft project, reduce significantly the code redundancy of engineering, relatively traditional MVC, at least reduce by 30% size of code, not only can shorten the duration of soft project, reduce the maintenance cost of engineering, also improved the quality of soft project, improve the stability of engineering.
Although the present invention discloses as above with preferred embodiment; so it is not in order to limit the present invention, any those skilled in the art, without departing from the spirit and scope of the present invention; when doing a little amendment and perfect, therefore protection scope of the present invention is worked as with being as the criterion that claims were defined.

Claims (4)

1. an OODB Object Oriented Data Base virtual image implementation method, is characterized in that, comprises the steps:
A) extracted data storehouse table and view form virtual objects class;
B) virtual objects class is stored in internal memory;
C) complete database manipulation by accessing described virtual objects class.
2. OODB Object Oriented Data Base virtual image implementation method as claimed in claim 1, is characterized in that, described object class, database table and view adopt identical data structure.
3. OODB Object Oriented Data Base virtual image implementation method as claimed in claim 2, is characterized in that, whether whether described identical data structure comprise field, attribute, data type, memory length, increase progressively, key word and/or field remarks.
4. OODB Object Oriented Data Base virtual image implementation method as claimed in claim 1, is characterized in that, the database manipulation of described step in c) comprises that data increase, delete, amendment and/or query manipulation.
CN201410136790.6A 2014-04-08 2014-04-08 Data base virtual image achieving method orientated to object Pending CN103870605A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410136790.6A CN103870605A (en) 2014-04-08 2014-04-08 Data base virtual image achieving method orientated to object

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410136790.6A CN103870605A (en) 2014-04-08 2014-04-08 Data base virtual image achieving method orientated to object

Publications (1)

Publication Number Publication Date
CN103870605A true CN103870605A (en) 2014-06-18

Family

ID=50909135

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410136790.6A Pending CN103870605A (en) 2014-04-08 2014-04-08 Data base virtual image achieving method orientated to object

Country Status (1)

Country Link
CN (1) CN103870605A (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105373391A (en) * 2015-12-08 2016-03-02 浪潮电子信息产业股份有限公司 Method for manufacturing WINDOWS multi-language mirror image
CN105447143A (en) * 2015-11-24 2016-03-30 许源平 Object-oriented database system based on category fiber bundle model and construction method thereof
WO2016101301A1 (en) * 2014-12-25 2016-06-30 广东电子工业研究院有限公司 Objectification and virtualization mechanism for mode of relational database table
CN110032554A (en) * 2019-04-10 2019-07-19 北京字节跳动网络技术有限公司 Management method, device, storage medium and the electronic equipment of data warehouse table

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7213026B2 (en) * 2002-08-23 2007-05-01 Sun Microsystems, Inc. Apparatus and method for associating classes
CN101989274A (en) * 2009-07-31 2011-03-23 上海杉达学院 Searching method by utilizing language integrated query
CN103150344A (en) * 2013-02-06 2013-06-12 湖北微驾技术有限公司 Driving training examination system data access method based on ORM (object relational mapping) framework

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7213026B2 (en) * 2002-08-23 2007-05-01 Sun Microsystems, Inc. Apparatus and method for associating classes
CN101989274A (en) * 2009-07-31 2011-03-23 上海杉达学院 Searching method by utilizing language integrated query
CN103150344A (en) * 2013-02-06 2013-06-12 湖北微驾技术有限公司 Driving training examination system data access method based on ORM (object relational mapping) framework

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
郭建宇: "基于Hibernate的建委定额与管理平台的设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 *

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2016101301A1 (en) * 2014-12-25 2016-06-30 广东电子工业研究院有限公司 Objectification and virtualization mechanism for mode of relational database table
CN105447143A (en) * 2015-11-24 2016-03-30 许源平 Object-oriented database system based on category fiber bundle model and construction method thereof
CN105447143B (en) * 2015-11-24 2018-11-02 许源平 Object-Oriented Database System and its construction method based on scope fiber cluster model
CN105373391A (en) * 2015-12-08 2016-03-02 浪潮电子信息产业股份有限公司 Method for manufacturing WINDOWS multi-language mirror image
CN110032554A (en) * 2019-04-10 2019-07-19 北京字节跳动网络技术有限公司 Management method, device, storage medium and the electronic equipment of data warehouse table

Similar Documents

Publication Publication Date Title
CN107391653B (en) Distributed NewSQL database system and picture data storage method
US10452634B2 (en) Provide consumer oriented data service
US10726039B2 (en) Systems and methods for updating database indexes
US20130093759A1 (en) Augmented Reality Display Apparatus And Related Methods Using Database Record Data
US9703834B2 (en) Topological query in multi-tenancy environment
US10019241B2 (en) Extendable framework for developing applications
US20170111363A1 (en) Security descriptors for record access queries
US11783254B2 (en) Method and system for implementing an adaptive data governance system
US10482141B2 (en) Extensible moderation framework
EP2590088B1 (en) Database queries enriched in rules
US10915551B2 (en) Change management for shared objects in multi-tenancy systems
CN111858615B (en) Database table generation method, system, computer system and readable storage medium
US8805777B2 (en) Data record collapse and split functionality
CN111061475B (en) Software code generating method, device, computer equipment and storage medium
CN102270225A (en) Data change log monitoring method and device
US8782631B2 (en) Copy management of process versions over lifecycle
CN105956087A (en) Data and code version management system and method
US11295068B2 (en) Techniques and architectures for native data field lifecycle management
CN103870605A (en) Data base virtual image achieving method orientated to object
US8892502B2 (en) Parallel processing of semantically grouped data in data warehouse environments
CN108984236A (en) A kind of implementation method and equipment of virtual management platform
US20160062997A1 (en) Serialized Child Associations in Parent Record
CN103226592A (en) Database-based file system and file storage method
KR102153259B1 (en) Data domain recommendation method and method for constructing integrated data repository management system using recommended domain
CN102426680A (en) Logical chart of accounts with hashing

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20140618

RJ01 Rejection of invention patent application after publication