Tag Info

Hot answers tagged

3

Generally, I've seen these intermediate levels referred to by the "grain" of the aggregation at which the data is stored. For example, if you have an intermediate aggregation in which the data is stored at the level of a person for a day, we would call that the person-day grain. This can be applied generically throughout most schemas.


2

I am quite sure that the term you are looking for is derived relation. In relational jargon, a single and normalized table is called a base relation (or base table). It can be said that this category of relations are the “concrete” tables that are stored in a RDBMS. The result obtained by joining two or more of these separate base relations (or base ...


2

You should have a 'language' table as well as your current 'person' table. It would look something like the following: Person table +----------+------------+ | PersonID | LanguageID | +----------+------------+ | 1 | 2 | | 1 | 5 | | 1 | 9 | +----------+------------+ Language table ...


1

Why do you think that you will not be able to bare a join? In fact if I understand correctly, your other idea is to put a list of tags into a varchar column (am I correct?) and search links by searching text in that column and that will definitely be much slower since you will have to full-scan the links table for every search. Joins are normal, every-day ...


1

Merge them. Sometimes it's worthwhile to have a separate Addresses table, but generally it's simplest to make those fields of a single Customers dimension. Because addresses are nearly unique, you're not going to save many records by hiving them out to their own table. If your Customers table is really large, and addresses change relatively often then ...


1

It's right to use Entity name for prefix/suffix to represent a table schema as your class Entity is a mapping to table schema not the data of the table. And in terms of data mapping a single instance of the Entity will always represent the row as the row will have all those columns which are attributes in entity and a List of the Entity will represent a ...



Only top voted, non community-wiki answers of a minimum length are eligible