História stránky

...

• Definition is not in the system - the system requires the definition of database table and creates the new structure definition. After saving the definition, the system ensures the connection of definition to the DB Table.
• Definition is in the system - after confirming, the system ensures connection of definition to the DB Table.

Conversion table

Mapping columns between the table in the database and the columns in the structure definition is carried out by name. When generating SQL D2000 commands, D2000 DBManager captures names into quotation marks by default. In some cases, this is unwanted activity, so the D2000 DBManager process have the /NQ parameter.

...

Column (columns) that is (are) considered to be NOT NULL.
The value of NOT NULL column must be defined before inserting or modification in the database table (the operation to insert or modify the record tables). The list of possible NOT NULL columns is equal to the columns defined in Structure definition. If there are undefined values in these columns before inserting or modifying of tables, the action is terminated with error. All the values that do not comply with the NOT NULL condition, are listed, however, at most 10 for 1 column (it is in contrast with the DB engine - it returns only first conflicting column in the first conflicting row).

Example of error message, which is displayed in DBManager:

%D2DBM-E-*** Error in con 1:
%D2DBM-E-con 1: DBS_INSERT : Column "column1" [row # 7], "column3" [row # 3 7 8], "column5" [row # 1 2 3 4 5 6 7 8 9 10 ...] in table "dba"."test_js_column_multi" cannot be NULL!

Data category

Allows assigment of data category from business point of view to table column using Data category object type. By assigning data category to column a reference to assigned object comes into existence. It is then easily possible to find all usages of given data category. By assigning data category, attribute Export monitored is automatically selected.

Data purpose

Assignment of Data purpose object into column activates anonymization process on given column. Anonymization is automatic process which modifies values in anonymized column to which processing time as given in assigned data purpose has expired. New value will be set using value given in replacement attribute. Anonymization is run periodically, by default every hour and is performaed by D2000 DBManager process. For each column, which has data purpose assigned, those rows will be anonymized which value in time column increased by processing time is smaller than current time and is not between anonymized time intervals. By assigning data category, attribute Export monitored is automatically selected.

Time column

Attribute which marks absolute time type column of configured table, from which processing time of data in given column is measured. Attribute is mandatory if data purpose is defined.

Replacement

Attribute which defines value that will be set into column during process of anonymization. If value is not defined, empty (null) value is set which can be interpreted as deletion of value. For textual values it is possible to use combination of predefined text and mask of date and time which will be replaced by actual values of date and time at time of anonymization. The mask is written between brace brackets and uses the same characters as ESL function %TimeToStr. It is possible to use time mask multiple times in text, e.g.: "Anonymized on {dd.mm.yyyy} at {hh:mi:ss}.". For values of absolute time type only mask format {hh:mi:ss dd-mm-yyyy} can be used or actual date and time value using the same format or empty (null) value.

...

The mapping of D2000 types to Oracle database types is stated below in the table.

Kotva
casova_hlbka casova_hlbka

History depth - column

...

Time definition of the history depth.

History depth - Data purpose

Alternative form of history depth definition using Data purpose object type.

...