Thursday 19 January 2012

Data warehousing for human Life - Contd 5


When I spoke about this topic to my teacher and well-wisher Mr.Bruce Andrews  he asked me the following questions to answer my self.
  • “The challenging part of designing a Data Warehouse is understanding what types of questions you may want to ask, which influences the structure of your data.”
  • “Are we going to try to measure ourselves through time?
My response is :
 
“The challenging part of designing a Data Warehouse is understanding what types of questions you may want to ask, which influences the structure of your data.”

The application we are trying to build should answer the basic questions. which are directly impacting and on analysing can improve our day to day life. Which we have in our mind as an adult, as an employee, as a young parent, as an ambitious person, as parent’s of an adult, as grand parents. Our application should be capable of answering 10-15 questions under each category.

As a young parent we would lie to have the following question answered:
  1. How active is my kid?
  2. How long he / she spend in physical activity?
  3. How long he / she spend in learning activity?
  4. How long he / she spend in extra curricular activity (painting, drawing etc...)?
  5. How long he / she spend in Internet?
  6. How long he / she spend in TV & electronic media?
  7. What are his / her eating habits?
  8. How may time he / she had minor medial problem for a period of time?
  9. What are his / her seasonal medical problems?
  10. What are his / her emotional reactions (mostly dissatisfied / happy / creepy)?
  11. What are his / her medical allergic situations?
  12. What are his / her physical allergic situations?
  13. Etc…
Note: These lists are for Illustrative purpose only. We can short list the objective questions after doing a research involving the SME’s.

Going by 80- 20 rule (Pareto rule), by understanding the 20 % of the things that impact our life we should be able to tune our life for better living. Our datawarehouse should be capable of covering that  20 %.


“Are we going to try to measure ourselves through time?

My answer is a ‘Yes’ and ‘No’.
Yes:  As I mentioned in my previous posts certain things can be analysed / compared with out an impact on time. Like the Intellectual capabilities, healthy habits etc…
                        Ex: How many languages my grandfather had known at the age of 30?
                              How many hours had my parents spent on entertainment activities?

No: The things which are impacted by time and may not provide value for today’s life style like driving a chariot, building a mud house etc…
                        Ex: (Being an Asian) does my grandfather know to speak Italian at the age of 30?

TID BIT:

Nicholas Felton:  One of the designers who built the Facebook’s Time line feature had virtually built a datawarehouse for individual’s life. The interesting part is that he landed in Facebook by building an analytical reporting tool for his personal life. Knowingly or unknowingly he ended up building  a personal datawarehouse, which he ended up doing so. Facebook is building a personal datawarehouse, which is answering some of our queries on entertainment habitat. 

COMMENTS:

I received an interesting email from last week posting
- Our brain is the best data warehouse and our senses are the input. We have to be very careful while interacting with brain.
There has been a misunderstanding; we are not contemplating neuroscience here. The application we are talking is an external product which helps us to analyse the data set externally, like we do for the business. To be philosophical, the data that we are trying capturing in this application is captured by our subconscious mind. It takes a long time for us to recognise what is there in the subconscious mind and it is difficult to analyse it objectively. Our application helps us to analyse objectively and on demand.

Next week let us see how we can build such an application...

No comments:

Post a Comment