Stack Overflow
Stack Overflow

Questions tagged [bi-temporal]

Bitemporal design denotes both the valid time and transaction time of the data in two timelines with timestamps for both valid times in a temporal database.

In simple words, bitemporal is a way to maintain historical/timeline data and timestamps of the change in data. For example, you can create and save the historical/timeline record of a row every time it changes with a active/inactive flag or using a modified/touched timestamp to the old and newly modified row; either you save every change in the same table or create another(log/archive) table to save the historical changes(and the present table will have only the latest updated row).

21 questions
5
votes
2 answers

Is using only 3 timestamps for a bitemporal SQL database possible?

When implementing a bitemporal database in SQL, it is usually recommended to use the following timestamps: ValidStart ValidEnd TransactionStart TransactionEnd I have used this approach a few times before, but I have always wondered why having…
danielhc
  • 479
  • 1
  • 5
  • 12
4
votes
1 answer

Deleting/Updating BiTemporal Triples in MarkLogic 8

With the introduction of new BiTemporal features in MarkLogic8, you can track changes in two time axes: valid and system times. These features are also supported for triples. So you can go back in time along those two axes and possibly see the…
user5552435
  • 51
  • 5
4
votes
2 answers

In what cases are bitemporal tables actually used?

I am trying to collect information about temporal databases. I know it is not a modern technology, but I saw that many people who work with databases don't ever know how temporal approach works (I asked some senior programmers and system analysts…
Andrea Gottardi
  • 295
  • 2
  • 3
  • 20
4
votes
1 answer

Best practice for SCD date pairs (closing / opening timestamps)

When implementing temporal datetime pairs, which is the better approach? Approach 1 _RK FROM_DTTM TO_DTTM 1 01-JAN-2012 00:00:00 31-DEC-2012 23:59:59 ------------> Old record closed out 1 01-JAN-2013 00:00:00 31-DEC-4949…
Allan Bowe
  • 11,461
  • 18
  • 65
  • 114
3
votes
1 answer

What's different about Database as a Value in Datomic vs BiTemporal Indexes in Cassandra?

The Datomic database has the concept of 'Database as a Value'. This means that you can get a reference to the database at a point in time - and query against it. It appears that BiTemporal Indexes in Cassandra do almost the same thing. My question…
hawkeye
  • 31,052
  • 27
  • 133
  • 271
2
votes
1 answer

Calculating Moving Average on bi-temporal dataset

I'm trying to calculate moving average on a bitemporal dataset. The dataset consists of a data date and an effective date(the date at which the data became available). The data for this date could be restated several times in future(same data date…
Satish
  • 2,710
  • 5
  • 30
  • 43
2
votes
0 answers

Bitemporal integrity checks

The need for this comes from the fact, that we now have numerous sources updating sensitive bi-temporal tables, we are a little bit alert and want to cover our backs. I used "Developing Time-Oriented Database Applications in SQL" by Richard…
Palcente
  • 563
  • 2
  • 6
  • 20
1
vote
1 answer

How to delete temporal documents from MarkLogic database physically?

I came across the temporal function "temporal.documentDelete" which "logically deletes" temporal documents in a MarkLogic database hence removing it from the latest collection. But the document is still not physically deleted from MarkLogic…
sharu
  • 51
  • 4
1
vote
1 answer

Temporal Data Management in Google Cloud Datastore

Is there an api (like hibernate, etc) to manage temporal data in Google Cloud Datastore? Basically i need to maintain bi-temporal data in my datastore. Is there an api that i can use to easily manage this?
Abhinav Pathak
  • 98
  • 8
0
votes
1 answer

Bi-temporal SQL table querying

I'm trying to model a SQL table to store salary changes for employees. One approach is using a bi-temporal table as follows: Here an employee was hired on 10/1/2015 with salary of 100,000. Then on 2/15/2016 he had a performance review and his boss…
Alec Bryte
  • 536
  • 4
  • 14
0
votes
1 answer

Installing temporal_tables and cyanaudit extensions in PostgreSQL for Windows

I have an auditing and slowly changing dimensions (SCD) use case that requires the installation of the PostgreSQL temporal_tables and cyanaudit extensions. However my PostgreSQL server is on Windows and after searching high and low, I still haven't…
JDaniel
  • 77
  • 4
  • 8
0
votes
1 answer

Is there an optimal timestamp format for querying bi-temporal data in MarkLogic?

I have two date formats for validStartDtTm (name of validAxes) stored in one collection. I want to harmonize all of the dates into one uniform format and wanted to know if there were any best practices for bi-temporal date format in MarkLogic.…
Hank
  • 109
  • 3
0
votes
1 answer

delete only archived data from bi-temporal collection

MarkLogic version : 9.0-6.2 I'm using bi-temporal data Management, and want to delete (physical delete not logical delete)only archive data which are older than 2 months from temporal collection.And latest version of document should be retained in…
Hemalatha Sivasubramani
  • 11
  • 2
0
votes
2 answers

Application-time period tables

I am implementing a bitemporal solution for a few of our tables, using the native temporal table features, and some custom columns and code to handle the application/valid time. However, I just stumbled across a reference to something which is…
Crogacht
  • 60
  • 1
  • 6
0
votes
1 answer

Why is the end date in a temporal table the maximum system time and not just NULL

We are looking at implementing a bitemporal solution for a few of our tables, because they must record both application time and system time. I know SQL 2016 has native support for only the system-time component, so we will be converting tables to…
Crogacht
  • 60
  • 1
  • 6
1
2