Stack Overflow
Stack Overflow

Questions tagged [temporal]

232 questions
7
votes
4 answers

Spatial vs. Temporal locality

I understand the definitions of the terms, but I am having trouble applying their concepts to code. For an exercise, we are asked to describe if the following code is spatial or temporal: for (int i=0; i<10; i++) { printf(some_array[i]); } I…
raphnguyen
  • 3,267
  • 16
  • 51
  • 73
7
votes
2 answers

How to Keep Modifier ID in System Versioned Temporal Tables?

I have a system-versioned table in sql server 2016. I want to store Modifier ID in its temporal (history) table while users are performing delete or update action on the table. Is there any built-in solution by sql server 2016 to do that?
Nima Rostami
  • 2,092
  • 3
  • 12
  • 23
6
votes
3 answers

SQL Server and allocate time into hour parts

Background: Ambulances and fire trucks have the dispatch time when an emergency occurred and a clear time for when the emergency was declared over. For example: an emergency (EventID = fire0001) occurs at 10:45:00 and ends at 11:30:00. Another…
David Fort Myers
  • 319
  • 4
  • 15
6
votes
1 answer

How would you make a Temporal Many-to-Many Relationship in SQL?

How would you represent a temporal many-to-many relation in SQL? Under non-temporal circumstances one would use a junction table (aka link/bridge/map) to connect the two sides. Is adding temporal tracking as simple as including a ValidStart and…
DavGarcia
  • 17,702
  • 14
  • 52
  • 94
6
votes
1 answer

Does Drools Fusion have a concept of "now"?

I'm trying to write a rule that delays firing until, at least, 15 minutes have passed since the last firing. However, the temporal operators in Drools Fusion only allow reasoning about two events in relation to each other and not one event in…
Francisco Canedo
  • 1,862
  • 2
  • 13
  • 16
6
votes
1 answer

Analyse code for spatial and temporal locality

Hi have some question regarding spatial and temporal locality. I have read in the course theory that spatial locality If one item is referenced, the likelihood of other address close by will be referenced soon temporal locality One item that is…
starcorn
  • 7,071
  • 19
  • 73
  • 118
6
votes
2 answers

How can we produce kappa and delta in the following model using Matlab?

I have a following stochastic model describing evolution of a process (Y) in space and time. Ds and Dt are domain in space (2D with x and y axes) and time (1D with t axis). This model is usually known as mixed-effects model or…
user238469
5
votes
2 answers

Is there a way to represent temporal data in RDFs?

I have bunch of temporal data which I want to convert to RDF format. Is there any accepted way of doing so? Example of tabulated data which should be somehow converted into RDF format: | Name | Date | Salary …
gintas
  • 2,070
  • 1
  • 16
  • 26
5
votes
4 answers

How to save all versions of posts in mysql database

It is popular to save all versions of posts when editing (like in stackexchange projects), as we can restore old versions. I wonder what is the best way to save all versions. Method 1: Store all versions in the same table, and adding a column for…
Googlebot
  • 13,096
  • 38
  • 113
  • 210
5
votes
2 answers

The best mechanism for alter columns of system versioning tables (Temporal Table)?

I have a system-versioning table with history table related as follows: CREATE TABLE [dbo].[ExpenseCenter_Archive]( [ExpenseCenterId] [tinyint] NOT NULL, [Name] [nvarchar](200) NOT NULL, [LineCode] [smallint] NOT NULL, [SysStartTime]…
Aiyoub
  • 4,703
  • 6
  • 22
  • 34
5
votes
5 answers

How to retrieve all kinds of dates and temporal values from text

I wanted to retrieve dates and other temporal entities from a set of Strings. Can this be done without parsing the string for dates in JAVA as most parsers deal with a limited scope of input patterns. But input is a manual entry which here and hence…
Identity1
  • 1,108
  • 13
  • 31
5
votes
3 answers

How to use HeidelTime temporal tagger inside a Java project?

I would like to automatically identify dates inside a stream of documents and in this sense I would like to use the code provided by the open source project Heideltime, available here (https://code.google.com/p/heideltime/). I have installed the…
Crista23
  • 2,717
  • 9
  • 41
  • 58
5
votes
2 answers

Implementation of Prolog extension handling temporal operators

I am looking for implementation of Prolog extension which handles temporal logic operators. Is there any info about this ? As temporal logic has been a significant part of logic, I am sure that there must have been discussions about this with…
user3541984
  • 111
  • 1
  • 2
  • 3
4
votes
4 answers

Suitability of Amazon SimpleDB for large temporal data sets eminating from thousands of separate devices

I'm trying to establish whether Amazon SimpleDB is suitable for a subset of data I have. I have thousands of deployed autonomous sensor devices recording data. Each sensor device essentially reports a couple of values four times an hour each day,…
Aitch
  • 910
  • 11
  • 20
4
votes
1 answer

Get Week and Year in Past Using LocalDate

I'm using the Java 8 time library to determine the previous weeks and year from today's date and then store those values in a map. I think I've figured out how to properly get the weeks, but I'm not entirely sure what the correct way is to get the…
Pr0pagate
  • 179
  • 8
1
2
3
…
15 16