Let's say I have entity $e. Is there any generic way to store it as another row, which would have the same entity data but another primary key? Why I need this: I'm implementing some sort of Tempo...

Generally, I am excited by the Temporal Database feature. However, mysqldump is not supported for database export and restore. I can find no resource in the documentation (linked to above) that...

I need to seed data for my local development purpose in the following Temporal Table, the start date should be old. The given Table Schema is CREATE TABLE [dbo].[Contact]( [ContactID] [uniqueiden...

I'm having issue in Insertion of data in Temporal table using C# Entity Framework The Table schema is CREATE TABLE People( PeopleID int PRIMARY KEY NOT NULL, Name varchar(50) Null, LastName...

I'm looking at SQL Server 2016 temporal tables and can't find any efficient way to query for all historical records that are now deleted. I prefer not to soft-delete or moving to a 'deleted items ...

I am a newbie to Database Systems and I was wondering what is difference between Temporal database and Time-series database. I have searched on the internet but I am not getting any comparison of t...

I'm using database first entity framework 6. After changing some of the tables in my schema to be temporal tables, I started getting the following error when attempting to insert new data: Cannot ...

I currently have a non-temporal MySQL DB and need to change it to a temporal MySQL DB. In other words, I need to be able to retain a history of changes that have been made to a record over time for...

I am currently trying to create a database where a very large percentage of the data is temporal. After reading through many techniques for doing this (most involving 6nf normalization) I ran...

I have a SQL Server 2016 database with temporal tables. One temporal table is called Company. I am trying to query it to get current records and all historical records. I first tried the following ...

I have many table with data, which I want to convert to Microsoft Temporal table, But when I want to convert temporal table cause lost my data. My code is: Alter TABLE dbo.Employee ( [Employee...

I was reading about temporal databases and it seems they have built in time aspects. I wonder why would we need such a model? How different is it from a normal RDBMS? Can't we have a normal databa...

I'm curious if anyone has implemented or even knows of any bitemporal databases built on NoSQL platforms (e.g., riak).

Anyone know of any temporal (http://en.wikipedia.org/wiki/Temporal_database) extensions to SQL Server?

i want to store changes that i do on my "entity" table. This should be like a log. Currently it is implemented with this table in MySQL: CREATE TABLE `entitychange` ( `id` int(11) unsigned NOT NU...

I am looking for a suitable process by which to keep revisions, or snapshots of rows (and their relations) in a database. Take for example an eCommerce platform- A customer creates an order. The o...

My problem is simple: I have a table with a series of statuses and timestamps (for the sake of curiosity, these statuses indicate alarm levels) and I would like to query this table in order to get ...

I would like to know how to implement temporal tables in JPA 2 with EclipseLink. By temporal I mean tables who define validity period. One problem that I'm facing is that referencing tables can n...

This question is related to the schema that can be found in one of my other questions here. Basically in my database I store users, locations, sensors amongst other things. All of these things are ...

Should dates for a temporal database stored in one or 2 tables ? If one doesn't this violate normalisation ? PERSON1 DATE11 DATE21 INFO11 INFO21 DEPRECATED PERSON2 DATE21 DATE22 INFO21 INFO22 CURR...

We use a third-party product to manage our sports centre membership. We have several membership types (eg. junior, student, staff, community) and several membership statuses (eg. annual, active, in...