Functional Data Warehouse example essay topic
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.