Entities that access the data access layer

A data access layer and data access technology, which is applied to the entity field of the access data access layer, can solve the problem of losing the control and inspection capabilities of continuous functional programming phrases

Inactive Publication Date: 2011-12-21
SIEMENS AG
View PDF7 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0013] Unfortunately, the main disadvantage of skipping the DAL layer is the possible loss of some of the persistent functionality for the entities of the data model and along with it some of the control and inspection capabilities available for programming phrases

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
  • Entities that access the data access layer
  • Entities that access the data access layer
  • Entities that access the data access layer

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0093] Example 1: Direct Link

[0094] In an exemplary embodiment, in an MES scenario, let us assume the following three basic DAL entities are part of the Production Order Management component:

[0095] - A "campaign" entity, representing a production request to manufacture a specific quantity of a product.

[0096] — An "Order" entity, representing the operations required to produce a particular material, and related information. Movements consist of one or more orders.

[0097] - "Item" entity: represents the manufacturing step used to complete the execution of the entire production order. An order consists of one or more items.

[0098] A very simple example of a virtual entity aggregates data of the following nature:

[0099] — entry identifier (obtained from entry)

[0100] — entry estimated start time (obtained from entry)

[0101] — entry estimated end time (obtained from entry)

[0102] — the identifier of the order to which the item belongs (obtained from th...

example 2

[0111] Example 2: Optional Side Entities

[0112] In the exemplary embodiment, let us assume that the entry entity contains a property called the device ID that references the executing device that is associated to the entry, if any, such as image 3 The virtual entity shown in Figure T2.

[0113] In this case, such secondary entities are marked as optional since the association is not mandatory, i.e. the entry does not necessarily have an associated device.

[0114] Read methods invoked on this virtual entity descriptor return all entry instances, whether or not they point to associated devices. Properties extracted from equipment entities have invalid values ​​for virtual entity instances for which no association to the equipment entity exists.

[0115] find side entities

[0116] According to the second additional side-entity type, the directly linked side-entity can be marked as a "lookup" side-entity.

[0117] Lookup side-entities that require at least one set of ...

example 3

[0121] Example 3: Find side entities

[0122] image 3 The virtual entity graphs T3a and T3b describe two virtual entity descriptors, the difference being that the motion side-entity is marked as "lookup" in the second virtual entity descriptor.

[0123] For a first virtual entity, a call to a write method on an instance of this virtual entity means that, depending on the data, a write method on both an order and a movement instance can be called.

[0124] Instead, for the second virtual entity, a call to the write method on an instance of this virtual entity means that only the order instance is written, and in particular, it points to the value given for its "identifier property" , such as Campaign.Name(campaign.name) The given value matches the campaign instance.

[0125] pivot link

[0126] In an embodiment of the proposed invention, it is preferred to mark certain back link side entities as pivot link side entities.

[0127] In fact, it should be noted that in bac...

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

Exposes entities that access the data access layer. The present invention provides a method and system for entities of a data access layer. The data access layer follows an entity-relationship model, wherein data is described according to entities and their relationships; wherein, a CRUD interface is provided for entities; The invention includes the following: a) defining a meta-entity, hereinafter referred to as a virtual entity, obtained as a composition of parts of one or more entities; b) describing a virtual entity via a virtual entity descriptor as wherein via a link Connect the hierarchical structure of entities with a parent-child structure; in the virtual entity descriptor, specify which properties to obtain from each entity to form part of the virtual entity; c) provide a CRUD interface on the virtual entity; d) at runtime , the virtual entity is accessed via its CRUD interface, implemented as a set of calls to CRUD methods that access the entities that make up the virtual entity.

Description

technical field [0001] The invention relates to a method, a system for accessing entities of a data access layer according to the preambles of claims 1 and 14 respectively. Background technique [0002] Most businesses and manufacturing processes use database management systems to store and retrieve data, the information needed to perform their tasks. A conceptual description of such information for a particular domain of interest is called a "physical data model". [0003] Software applications are usually kept separate from the database structures at the "database level" (DB level) used to process the physical data model information. This is done by means of a "Data Abstraction Layer" (DAL), which is an implementation of a "Logical Mathematical Model". A very common type of logical data model is the "Entity-Relationship Model" (ERM), where data is described in terms of entities, ie data structures representing real-world objects, and the relationships between them. [0...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F9/4435G06F9/4493
Inventor A.博埃罗D.科尔索
Owner SIEMENS AG
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