View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000343 | CaseTalk Modeler | Generation (SQL, XML, etc) | public | 2013-09-26 10:03 | 2022-01-10 20:40 |
Reporter | Marco Wobben | Assigned To | Marco Wobben | ||
Priority | normal | Severity | feature | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 7.2.1 | ||||
Target Version | 11.0 | Fixed in Version | 11.0 | ||
Summary | 0000343: Generate temporal database script | ||||
Description | Create tables including temporal requirements. | ||||
Additional Information | Custom 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. | ||||
Tags | No tags attached. | ||||
CaseTalk Edition | |||||
related to | 0002186 | closed | Marco Wobben | Generate Transitional Model |
related to | 0001729 | closed | Marco Wobben | Add SQL2011 generator |
related to | 0002730 | closed | Marco Wobben | Add BiTemporal support in MsSqlServer2016 |
related to | 0002738 | closed | Marco Wobben | Add BiTemporal support in Oracle 12 |
See also: https://en.wikipedia.org/wiki/Temporal_database https://mariadb.com/kb/en/library/system-versioned-tables/ |
|
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..." |
|
Asserted time and State time: https://www.sciencedirect.com/topics/computer-science/asserted-versioning |
|
SQL2011 support: https://www.dummies.com/programming/sql/how-to-track-data-with-sql2011-bitemporal-tables/ |
|
Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved. | |
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 |