View Issue Details

IDProjectCategoryView StatusLast Update
0000343CaseTalk ModelerGeneration (SQL, XML, etc)public2022-01-10 20:40
ReporterMarco Wobben Assigned ToMarco Wobben  
PrioritynormalSeverityfeatureReproducibilityalways
Status closedResolutionfixed 
Product Version7.2.1 
Target Version11.0Fixed in Version11.0 
Summary0000343: Generate temporal database script
DescriptionCreate tables including temporal requirements.
Additional InformationCustom attributes allow facts to store History definitions. These are not interpreted by CaseTalk, yet allow for temporal dimensions on tables.

The GLR is destructive in a sense, and therefor the different temporal requirements are lost, a more sensitive approach is required for this. For instance columns with similar temporal settings are to be treated similar, and different from other columns.

Therefor the temporal settings (custom attributes) on facts should be moved from otft to roles.
TagsNo tags attached.
CaseTalk Edition

Relationships

related to 0002186 closedMarco Wobben Generate Transitional Model 
related to 0001729 closedMarco Wobben Add SQL2011 generator 
related to 0002730 closedMarco Wobben Add BiTemporal support in MsSqlServer2016 
related to 0002738 closedMarco Wobben Add BiTemporal support in Oracle 12 

Activities

Marco Wobben

Marco Wobben

2015-11-18 13:57

administrator   ~0000475

Last edited: 2018-07-11 18:32

See also:
https://en.wikipedia.org/wiki/Temporal_database
https://mariadb.com/kb/en/library/system-versioned-tables/

Marco Wobben

Marco Wobben

2018-07-11 18:48

administrator   ~0001219

Last edited: 2018-07-11 18:52

From the temporal page on wikipedia:

"..Valid time is the time for which a fact is true in the real world. A valid time period may be in the past, span the current time, or occur in the future. For the example above, to record valid time, the Person table has two fields added, Valid-From and Valid-To. These specify the period when a person's address is valid in the real world.

..Transaction time records the time period during which a database entry is accepted as correct. This enables queries that show the state of the database at a given time. Transaction time periods can only occur in the past or up to the current time. In a transaction time table, records are never deleted. Only new records can be inserted, and existing ones updated by setting their transaction end time to show that they are no longer current. To enable transaction time in the example above, two more fields are added to the Person table: Transaction-From and Transaction-To. Transaction-From is the time a transaction was made, and Transaction-To is the time that the transaction was superseded (which may be infinity if it has not yet been superseded). This makes the table into a bitemporal table..."

Marco Wobben

Marco Wobben

2019-09-28 21:29

administrator   ~0001531

Asserted time and State time:
https://www.sciencedirect.com/topics/computer-science/asserted-versioning
Marco Wobben

Marco Wobben

2020-11-04 17:10

administrator   ~0001805

SQL2011 support:
https://www.dummies.com/programming/sql/how-to-track-data-with-sql2011-bitemporal-tables/
Marco Wobben

Marco Wobben

2022-01-10 20:40

administrator   ~0002503

Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved.

Issue History

Date Modified Username Field Change
2013-09-26 10:03 Marco Wobben New Issue
2013-09-26 10:03 Marco Wobben Status new => assigned
2013-09-26 10:03 Marco Wobben Assigned To => Marco Wobben
2015-11-18 13:57 Marco Wobben Note Added: 0000475
2016-01-20 12:56 Marco Wobben Category Generation => Generation (SQL, XML, etc)
2018-07-11 18:32 Marco Wobben Note Edited: 0000475
2018-07-11 18:48 Marco Wobben Note Added: 0001219
2018-07-11 18:52 Marco Wobben Note Edited: 0001219
2019-07-22 13:37 Marco Wobben Relationship added related to 0002186
2019-09-28 21:29 Marco Wobben Note Added: 0001531
2020-11-04 17:10 Marco Wobben Note Added: 0001805
2020-11-05 12:13 Marco Wobben Relationship added related to 0001729
2020-11-05 22:59 Marco Wobben Target Version Future => 11.0
2020-11-07 08:53 Marco Wobben Relationship added related to 0002730
2020-11-11 22:30 Marco Wobben Severity major => feature
2020-11-11 22:30 Marco Wobben View Status private => public
2020-11-14 11:20 Marco Wobben Relationship added related to 0002738
2021-01-12 21:17 Marco Wobben Status assigned => resolved
2021-01-12 21:17 Marco Wobben Resolution open => fixed
2021-01-12 21:17 Marco Wobben Fixed in Version => 11.0
2022-01-10 20:40 Marco Wobben Note Added: 0002503
2022-01-10 20:40 Marco Wobben Status resolved => closed