The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
162 views

Algorithm for rating books: Relative perception

So I am developing this application for rating books (think like IMDB for books) using relational database. Problem statement : Let's say book "A" deserves 8.5 in absolute sense. In case if A is ...
0
votes
1answer
202 views

Best way to implement database design for a set of entities

Lets say I have a scenario like so: I have many claims to get money from another entity and this claim has to go through two gateways. This claim is sent from an origin system and can possibly be ...
1
vote
0answers
102 views

Redmine - Database Structure/Normalization

I am using redmine for project management and issue tracking. I was looking at the database tables and the underlying structure and was wondering if anyone who is experienced with database ...
0
votes
0answers
94 views

Event sourcing with a read store - normal relational tables too?

I will be implementing Event Sourcing for the first time on a hobby project and I have what could be a really simple question: should the event store be the only storage area if you have a ...
0
votes
0answers
33 views

Not using Weak entities could denormalize DB?

In the following scenery in a ER and relational Model: Object 1-----N [Part] 1-----N [Subpart] 1-----N [Item] (Where "1-----N" is a 1 to N relationship; and [Entity] is weak). Solution 1: ...
0
votes
0answers
82 views

Fixing data duplication in two similar tables in different databases

I'm currently doing maintenance on an old order system that has grown into the poster child for bad coding practice. One of the tings I'm dealing with is a lot of data duplication, which I want to ...