Stack Overflow
Stack Overflow

Questions tagged [temporal]

232 questions
24
votes
3 answers

How can I use System-Versioned Temporal Table with Entity Framework?

I can use temporal tables in SQL Server 2016. Entity Framework 6 unfortunately does not know this feature yet. Is there the possibility of a workaround to use the new querying options (see msdn) with Entity Framework 6? I created a simple demo…
cSteusloff
  • 2,110
  • 4
  • 22
  • 45
15
votes
4 answers

Confused between Temporal and Spatial locality in real life code

I was reading this question, I wanted to ask more about the code that he showed i.e for(i = 0; i < 20; i++) for(j = 0; j < 10; j++) a[i] = a[i]*j; The questions are, I understand temporal locality, I think that references to i and j…
user379888
14
votes
4 answers

Seed data with old dates in Temporal Table - SQL Server

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] [uniqueidentifier] NOT NULL, [ContactNumber]…
B.Balamanigandan
  • 3,915
  • 5
  • 55
  • 107
12
votes
2 answers

How to deploy temporal tables with dacpac and SqlPackage.exe

We are trying to work with temporal tables in SQL Server 2016. We are developing the SQL scripts in SSDT 15.1.6 in Visual Studio 2017, but we are experiencing issues when trying to deploy the dacpac that is generated during the build. Our dacpac is…
larrydice
  • 321
  • 2
  • 9
12
votes
1 answer

Can a date string be validated by DateTimeFormatter without catching exception?

Considering that flow control via exceptions is considered (by many) to be an anti-pattern, is it possible to validate that a string represents a valid date using the temporal library (java.time.*), without catching an exception? Consider the…
Bohemian
  • 365,064
  • 84
  • 522
  • 658
12
votes
6 answers

See if the current time falls within a specific range of time in the current day in Java

I am sure this was done 1000 times in 1000 different places. The question is I want to know if there is a better/standard/faster way to check if current "time" is between two time values given in hh:mm:ss format. For example, my big business logic…
ring bearer
  • 18,848
  • 7
  • 53
  • 68
11
votes
1 answer

Principal component analysis (PCA) of time series data: spatial and temporal pattern

Suppose I have yearly precipitation data for 100 stations from 1951 to 1980. In some papers, I find people apply PCA to the time series and then plot the spatial loadings map (with values from -1 to 1), and also plot the time series of the PCs. For …
Yang Yang
  • 971
  • 3
  • 17
  • 41
11
votes
2 answers

When program will benefit from prefetch & non-temporal load/store?

I did a test with this for (i32 i = 0; i < 0x800000; ++i) { // Hopefully this can disable hardware prefetch i32 k = (i * 997 & 0x7FFFFF) * 0x40; _mm_prefetch(data + ((i + 1) * 997 & 0x7FFFFF) * 0x40, _MM_HINT_NTA); …
BlueWanderer
  • 2,546
  • 2
  • 19
  • 35
10
votes
3 answers

Avoid schema mismatch in System-Versioned tables

Looking for a workaround for: Error: SQL71609: System-versioned current and history tables do not have matching schemes. Mismatched column: 'XXXX'. When trying to use SQL 2016 System-Versioned (Temporal) tables in SSDT for Visual Studio 2015. I've…
Andrew Barnett
  • 4,406
  • 1
  • 20
  • 24
10
votes
4 answers

Are there any design patterns for bitemporal NoSQL databases?

I'm curious if anyone has implemented or even knows of any bitemporal databases built on NoSQL platforms (e.g., riak).
Pinko
  • 3,037
  • 2
  • 18
  • 15
10
votes
3 answers

Temporal Expression library in .NET

Does anyone know of a library to handle events and recurring events likes the temporal expression libraries that exist for ruby like Runt (http://runt.rubyforge.org/) or TExp (http://texp.rubyforge.org/). Those libraries are perfect for what I need,…
Peter
  • 689
  • 9
  • 19
9
votes
1 answer

Trying to store a temporal collection with Erwin Vervaet's framework and getting ClassCastException

I'm trying to use the Bitemporal framework of Erwin Vervaet to store with Hibernate a temporal collection instead of a temporal property as in his example. (there is a presentation of the framework here) I'm trying to store a collection of…
cdarwin
  • 3,801
  • 8
  • 38
  • 56
9
votes
2 answers

Temporal libraries for Java

I'm looking for temporal libraries for Java, i.e. libraries which allow to store multiple historical version of the same concept. I'm looking for a library which has an API to do something like: Instant i1 = Instant.valueOf("2010-01-01"); Instant…
cdarwin
  • 3,801
  • 8
  • 38
  • 56
9
votes
3 answers

Temporal Extraction (i.e. Extract date/time entities from free form text) - How?

Has anyone found a simple, but effective way to extract date references from text? I've done a fair amount of searching for temporal extraction tools, but there isn't a lot out there. There are a few white papers, but it seems to fall into a…
henry74
  • 869
  • 1
  • 8
  • 14
9
votes
0 answers

Temporal property optimization with Entity Framework

I want to implement temporal properties using an approach similar to that described here, using Entity Framework code-first for database storage. I want it optimized for getting the current value and have lazy loading for the history, but I don't…
Chris
  • 1,490
  • 1
  • 11
  • 14
1
2 3
…
15 16