Questions tagged [datahistory]
6 questions
12
votes
1 answer
How to create history fact table?
I have some entities in my Data Warehouse:
Person - with attributes personId, dateFrom, dateTo, and others those can be changed, e.g. last name, birth date and so on - slowly changing dimension
Document - documentId, number, type
Address -…
Argnist
- 535
- 1
- 5
- 18
6
votes
3 answers
Implementing a data history / versioning solution for a Hibernate-based application (with a twist)
First the basic facts: Java webapp, Spring, Hibernate, MySQL.
The situation is that I have a complex object model of e.g. a Car. It's
composed of many objects (Engine, Tires, ...) with many-to-one and one-to-many relationships between them.
Now…
Janne
- 3,647
- 7
- 28
- 34
5
votes
1 answer
Get buckets average of a date_histogram, elasticsearch
I have the following query where get the a data and I create an aggregation of each past hour:
query = {
"query": {
"bool": {
"must": [
{ "term": {"deviceId":device} },
…
Joabe da Luz
- 1,030
- 2
- 18
- 32
3
votes
3 answers
Hibernate: Is there a way to programatically create new tables that resemble an existing one?
I have a web app that have many tables (each represents a POJO). I wrote mapping files for each class and then use Hibernate's SchemaExport to generate the tables in my database. Now I want to create 2 additional tables for each existing table that…
tomato
- 5,644
- 13
- 43
- 48
2
votes
1 answer
Creating a column that'll show previous rates
I'm creating a column that will show an old address. Whenever an address is updated the old address is expired the day before the new one is supposed to take effect and a new row with the same account number will be added with the new address (ex:…
supeercod
- 27
- 4
0
votes
4 answers
Showing large amount of data
What is the general guideline on displaying large volume of data in UI?
One approach came to my mind was to load few records initially and then based on user input load subsequent records.
Are there any resources available from where I can learn?…
Abichellam
- 509
- 2
- 7
- 17