ydupont
commented
11 years ago Until access to new wiki:
Feature:Job title
Headline: Add job titles for employees
Description: The database structure shall be extended by introducing job titles for employees.
Motivation: The current data structure of Contribution:mySqlMany and Contribution:mySqlOne only allows two-dimensional reporting. Adding 'job titles' enables us making aggregating data three-dimensional and therefore also more advanced reporting commonly used in the area of Business Intelligence (i.e. OLAP cubes). In addition, if implemented in a normalized structure, it motivates to use more complex join queries across several tables.
Relationships:
- See Contribution:mySqlOneReporting for a impementation of this feature
- The present feature should be applicable to any data model of companies, specifically Feature:Flatness and Feature:Nesting.
rlaemmel
It turns out that we don' t have any feature that deals with joins in an interesting way.
In a basic sense, we deal with joins in the context of total and cut. That is, we join when we lookup a company id via its name and then we use the foreign key of employees for company id.
Thus, we should see whether we want to revise a feature or add a designated feature to deal with joins more interestingly.
This is related to this issue: #47
So we could go for @ydupont 's job description feature, if we slightly massage it:
http://101companies.org/wiki/Feature:Job_description
More thinking needed by @ydupont .
Once done, assign to me.
I was about to submit when we agree that job description could have a two-leveled motivation: it would deal with joins and it would add another dimension in a DWH context.