Certain issues need to be clarified and resolved before we can enter into a reasonable discussion. Pre-requisite Resolution Labels In a profession that demands precision, it is important that we use precise labels, to avoid confusion, and so that we can communicate without having to use long-winded descriptions and qualifiers. What you have posted as … Read more
Konrad. I recently faced with dealing with Models+Associations+Stores. This wasn’t very pleasent experience. Here is what I’ve learned: Let’s say we have Store1, Store2, Model1, Model2, Grid1, Grid2. Grid1 uses Store1, Store1 uses Model1 and similarly Grid2 uses Store2, Store2 uses Model2. So far all is working, data is loading and so on. But now … Read more
Surrogate key, synthetic key and artificial key are synonyms. Technical key is another one. They all mean “primary key which doesn’t have a business meaning”. They are distinct from natural or business keys which have a meaning beyond the system at hand. For instance, consider the SO user account. We are identified by two keys. … Read more
There is a catch in what you ask for: it all depends on your data. Fundamentally Redis is a data structure server. How you structure your data depends almost entirely on what it is and how you need to access it. The simple and common cases are fairly well covered by the links you list. … Read more
Good on you, for eliminating Nulls. I have never allowed Nulls in any of my databases. Of course, if nulls are prohibited, then missing information will have to be handled by some other means. Unfortunately, those other means are much too complex to be discussed in detail here. Actually it is not so hard at … Read more
pgModeler looks promising: http://pgmodeler.com.br
What are the core principles and motivating forces behind the party model? To the extent that I’ve used it, it’s mostly about code reuse and flexibility. We’ve used it before in the guest / user / admin model and it certainly proves its value when you need to move a user from one group to … Read more
Which table is the child in the relationship? Answer that, and you know which table needs the foreign key column, referencing the parent’s [typically] primary key. That’s for a one-to-many relationship… A many-to-many would require you to add a third table, using the keys from both of the two tables as it’s primary key.
Good question, the problem is that it depends on the definion of the terms, I think they differ slightly based on the sources. I would agree with previous answer – domain models are for describing the problem domain, at least the part you need to develop a solution. You describe all the various entities, their … Read more