Functional Data Warehouse example essay topic

359 words
Question 1 - What is the difference between tacit knowledge, explicit knowledge and common knowledge. Tacit knowledge is the information that is found in an individual's memory. This knowledge was gathered through observation, individual experiences, and from interactions with other people. It is also improved through practice, drill, and visualization. Explicit knowledge is information found in written or other methods of recorded form, such as, video or audio tape. Textbooks, maps, dvds, etc. are all examples of information provided in explicit formats.

Common knowledge is knowledge shared among community members. Stoplights when red mean STOP and when green means GO. One drives on the right-hand side of the road. Sun rises in the east and it sets in the west are all examples of information that might be considered common knowledge for residents in the United States. Other communities might consider it common knowledge that you drive on the left-hand side of the road! Question 2 - What is a data warehouse?

How is it better than traditional information-gathering techniques? The data warehouse is a collection of integrated, subject-oriented databases designed to support the DSS (decision support) function, where each unit of data is non-volatile and relevant to some moment in time. The data warehouse provides a facility for integrating the data generated in a world of un integrated information systems. A functional data warehouse organizes and stores all of the available data needed for informational, analytical processing over a historical time perspective.

It is the goal of the data warehouse to reintegrate the data generated by the myriad of internal and external information systems to create a sense of unity about the data without surrendering its natural complexities. Question 3 - List and briefly describe the processes of the system development life cycle (SDLC) approach. The SDLC portrays the analysis and design processes as a series of iterative and recursive phases, each with its own set of required inputs, activities, and deliverables. These processes are problem definition, feasibility analysis, systems analysis, systems design, code generation, testing, implementation, and maintenance.