93 reputation
6
bio website
location
age
visits member for 1 year, 1 month
seen Feb 21 at 15:23

Feb
21
comment H2 database binary file full of @^@^@^@^
I opened vim in hex editing mode with :setlocal display=uhex, it shows those are actually null values: <00><00><00><00><00>
Dec
17
comment Rent weekly cost database design
You're right, however calculating intervals requires checking gaps and intersections, there's an article "The SQL of Gaps and Islands in Sequences" and it explains how that task is not trivial at all.
Dec
13
comment Why NOSql should be more performant than RDBMS under structured data loads?
accepting your comment :) thank you
Jun
12
comment H2 ALTER TABLE ADD COLUMN BEFORE/AFTER
I know it is irrelevant in practice but in the documentation they have put this possibility for a reason. In my case it is that we often print the schema to paper and want some order for readability reasons.
May
20
comment Database design: Two 1 to many relationships to the same table
My solution #2 to which of your four groups belongs? The "Denormalized Partitioning Attribute Solution" is not quite clear to me..
May
17
comment Database design: Two 1 to many relationships to the same table
I need not only to know whether it is a corporation or natural person but also to know the respective id, so I need an id number and not only a value of 1 or 2! Solution 3 is what I found here I have two columns with ids to corporation or natural person
Mar
29
comment h2 Java server synchronization and caching
Indeed I want to continue to use my relational h2 database, what I'm surprised is that there's no library to simply add a caching and synchronization layer between the application and the database. By the way in some sense I have a central database, however each client has to keep its JLists and Tables updated with the database without continuously querying the central database.
Mar
25
comment Rent weekly cost database design
The problem with intervals of time and a daily coefficient is that I must check for overlapping intervals, empty intervals and calculate a coefficient which returns a correct price. Given that they will give me excel files with the cost per week calculating intervals from that and maintaining it always consistent might be harder than simply putting a cost for each day.
Mar
25
comment Rent weekly cost database design
I updated my question to the latest design changes so as not to make confusion, I think the coefficient cannot be used because I want to deal also with the most specific case (that is each building unit also inside the same building having a different cost each week). Can you update your answer to this requirement?
Mar
15
comment Rent weekly cost database design
Your table as I understand it, would have 2*5*4*365*365 = 5329000 rows in the case of 2 Buildings,5 Rooms, 4 Categories and of course all possible combinations of intervals of day in the year? or maybe I don't understand the relation between startdate and weekcoefficient..
Mar
15
comment Rent weekly cost database design
cost of a room is also based on day of the year or week of the year.. that's the main point of my question