Object relationship mapping model with fixed database schema

A database and model technology, applied in the field of database models, can solve problems such as no connection, no way to determine the structure of database tables, etc., and achieve the effect of reducing differences

Inactive Publication Date: 2010-08-04
袁梅宇
View PDF0 Cites 25 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This creates the following problem: If the user's business data model changes frequently, or needs to develop software suitable for different fields that requires the user to customize the business data model, because the user does not know or can not determine in advance what kind of data the user needs to store And the data format, it is impossible to determine the database table structure at design time, and a new database table has to be created to store data in a new format-causing frequent changes in the database schema, which will inevitably require frequent corresponding modifications to the client software , otherwise the client cannot access its data because it ...

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Object relationship mapping model with fixed database schema
  • Object relationship mapping model with fixed database schema

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0012] The entity table (1) stores the entity type name information, and the attribute table (2) stores entity attribute name and data type information, which together store the structure information of the entity. The entity instance table (3), the character string attribute table (4) and the numeric attribute table (5) together store the entity instance information. The entity relationship table (6) stores the relationships between entities.

[0013] In order to have a clearer understanding of the present invention, the following examples illustrate how to create and delete entities, how to add, delete, modify, and check entity instances, and how to create and delete relationships between entities. In actual use, it is easy to program the following formal description steps in an object-oriented language, thereby improving versatility and access efficiency.

[0014] The traditional way to create and delete entity types is to use SQL statements-CREATE TABLE and DROP TABLE. Since ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to an object relationship mapping model with a fixed database schema, which can store object-oriented information modeling elements (such as entities, attributes, relationships and the like). The invention is suitable for specific programming environments in which the database table structure can not or is not allowed to change and the users must be allowed to store various user defined data after the software development is completed and the software is delivered to the user. Since the database model uses limited number of database tables, when an object in a new format needs storing, the user does not need to create a database table and only needs to insert a new record into the fixed database table. The model supports the object-oriented information modeling concept, such as entities, relationships, attributes and the like, thereby ensuring that the information model reflecting the real world can be smoothly mapped to the fixed database schema.

Description

Technical field [0001] The invention is a database model that can store object-oriented information modeling elements (such as entities, attributes, relationships, etc.). It is suitable for the specific programming environment where the database table structure cannot or is not allowed to be changed after the software development is completed and delivered to the user, but the user must be allowed to store various user-defined data. The database model uses a limited number of database tables to store persistent data that can meet the needs of most applications, and is particularly suitable for storing business data in workflow applications. Background technique [0002] In the implementation of software engineering projects, it is often necessary to store information models and instance data after data modeling in a relational database for application access. Because of the mismatch between the relational model and the object-oriented description language (design object model) a...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
Inventor 袁梅宇
Owner 袁梅宇
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap