Direct View

from Wikipedia, the free encyclopedia

A direct view is a read and write view of a database . In contrast to a view , a direct view allows data to be inserted, changed or deleted and the changes to be written back consistently to the database. A direct view is not stored in the DBMS but in the form of metadata and is evaluated for generating the necessary SQL statements. This can be done either at runtime or by a code generator that generates program code from metadata.

Unlike a dataset in .NET , a Direct View contains or processes not only the data itself, but also the structure (i.e. the relational link) of the requested data and the program logic (e.g. calculation and plausibility rules ).

By linking several direct views (e.g. as a master-detail relationship between a master customer and a detail view via the contact person of the customer selected above), the program logic of a complex user dialog (e.g. a screen mask , a dynamic website or a report ) describe, model or configure without programming.

See also