Computer Business Intelligence

Questions: 1. What four characteristics determine the value of information and how? Give examples in your answer? 2. What are the definitions of a database, a database management system, and the relational database model and what are the advantages of the relational database model? 3. What is a data-driven website, why would someone use one, and what benefits does offer? 4. In what ways can a data warehouse help managers be more effective and why is that important for a business? In what situations is it best to use a data warehouse above other data storage options? 5. Read the article below and discuss the definition of business intelligence and what it means for a company. What are the negative impacts of BI and how does a database and data warehouse support BI? Be sure to give examples either from the text or outside sources to support any personal views you include in you? Answes: 1. There are four characteristics. Those are as follows: (Moody Walsh, 2005): Information is sharable: This is the most unique characteristics of the information. Information can be shared among people, systems or devices. Proportionate to use: The value of information depends on the use. How much the information use, it will increase its value. Information is easy to spoil: An information can be easily spoilt by proving wrong values to it. Proportionate to accuracy: The value of information also depends on accuracy. When an information carries higher accuracy, than information value is also high. 2. Database: A database is a composed decision of information. The information is ordinarily composed of framework components of reality in a way that supports procedure asking for information. For example, acting the accessibility to domains in resorts in a way that empowers finding a resort with openings (Date, 1981). Database Management System: This is a decision of usages that allows you to shop, change, and draw out the purposes of enthusiasm from a data source. There are different sorts of DBMSs, which go from little techniques that run on systems to broad strategies that run on unified servers (Larson, 1982). Relational Database Model: "Relational database model" is the fundamental information layout, which is used extensively around the globe for information storage space and taking care of. This blueprint is fundamental and have all the properties and limits expected to process information with the storage space capability (Harrington, 2002). Advantages of Relational Database Model: User friendly Flexible Precision Secured Data Independency Data Manipulation Language 3. Data Driven website: "Data-driven" site is one that uses a data source (database) for securing and collecting purposes of investment. It can use for several purposes, like contact details, email ids, images, client record, products' record, trade offers, and links, and so on (https://www.DBWebDoctor.com, 2015). Benefits: There are several benefits of data driven website. Those are as follows (Computerbusinessresearch.com, 2015): Confirming the material of the page could be conceivable without specific information or capacities The level of rate when the page chief takes off changes Have vital measures of versatility Diminished mistake rate 4. "Data Warehouse (DW)" gives a particular workplace, allowing associations to draw out information from resource systems, decontaminate or secure the conveyed information, and professor monstrous of information to be saved in it; a philosophy known as ETL. DW is regarded a champion amongst the most extremely reasonable choice help and association, perception creative headway that have appeared in the latest very much a long while (Wixom Watson, 2001). In light of present circumstances, the appreciation of DW benefits by associations has been underneath objectives (Ramamurthy, Sen Sinha, 2008). Along these lines, this investigation, generally centres around two concentrates: most importantly, it gives, shows, and examines the part and estimation of DW as a section or an auto holder for association brains, furthermore, it is really dissecting both business and particular issues and difficulties of DW change or use with present frameworks and mechanical progression (Watson, Goodhue Wixom, 2002). A DW workplaces provide for us general and joined information in multidimensional perspective. Close by the general and joined perspective of information, an information delivering workplaces moreover provides for us OLAP resources. These advantages help us in occupying and fruitful examination of information in a multidimensional space. This investigation achieves information theory and information examination (Tutorialspoint.com, 2015). 5. Business intelligence: "Business intelligence (BI)" is a developer driven technique for reviewing information and familiarizing workable information with help association people, association boss and flip side customers settle on more instructed association choices. BI incorporates a variety of instruments, ventures and strategies that enable associations to gather information from internal structures and outside resources, set it up for examination, make and run concerns against the information, and make reviews, dashboards and information visualizations to make the methodical results open to business decision designers furthermore helpful labourers (SearchDataManagement, 2015). Negative impact of BI: Negative impacts of BI are: It stockpiles the history Costly for small and medium organisation The system is quite complex The use is very limited The implementation process is very slow Data warehouse to BI: A data warehouse is a kind rational DBMS that are planned to request and research rather than for game plan dealing with. It by and large contains routing information in light of plan information, notwithstanding it can gain information from distinctive resources. It perceives examination measure of work from a course of action measure of work and engages a relationship to mastermind information from a couple of advantages (Docs.oracle.com, 2015). 6. In the above mentioned table there are few issues, like: Customer Id of individual customer is same for several people. So if we want to make this table better, we should use unique customer ID for each customer. In the last row, customer last name is missing. It is recommended not to use any null value. Null field can report an error. In the Zip column, first value is different from others. It may be an error, which should be rectified. Last name and first name is same for two different customer. So at the time of finding, it can give erroneous result. To make this table high quality informative table, we can follow some simple rules, like: There should not be any null value Value should be in sorted manner ID is a unique value, so it should follow its uniqueness. All the value should maintain the data length parameter. References com,. (2015). Data-driven website - Computer Business Research. Retrieved 12 March 2015, from https://www.computerbusinessresearch.com/Home/database/data-driven-website Date, C. (1981). An introduction to database systems. Reading, Mass.: Addison-Wesley Pub. Co. oracle.com,. (2015). Business Intelligence. Retrieved 12 March 2015, from https://docs.oracle.com/cd/B19306_01/server.102/b14220/bus_intl.htm Harrington, J. (2002). Relational database design clearly explained. New York: Morgan Kaufmann Publishers. https://www.DBWebDoctor.com, T. (2015). What are Database Driven Web Sites? (Web Doctor Article). Dbwebdoctor.com. Retrieved 12 March 2015, from https://www.dbwebdoctor.com/article_database_driven_websites.asp Larson, J. (1982). Database management system anatomy. Lexington, Mass.: Lexington Books. Moody, D., Walsh, P. (2005). Measuring The Value Of Information: An Asset Valuation Approach. Melbourne: University of Melbourne. Ramamurthy, K., Sen, A., Sinha, A. (2008). An empirical investigation of the key determinants of data warehouse adoption. Decision Support Systems, 44(4), 817-841. doi:10.1016/j.dss.2007.10.006 SearchDataManagement,. (2015). What is business intelligence (BI)? - Definition from WhatIs.com. Retrieved 12 March 2015, from https://searchdatamanagement.techtarget.com/definition/business-intelligence com,. (2015). Data Warehousing Quick Guide. Retrieved 12 March 2015, from https://www.tutorialspoint.com/dwh/dwh_quick_guide.htm Watson, H., Goodhue, D., Wixom, B. (2002). The benefits of data warehousing: why some organizations realize exceptional payoffs. Information Management, 39(6), 491-502. doi:10.1016/s0378-7206(01)00120-3 Wixom, B., Watson, H. (2001). An Empirical Investigation of the Factors Affecting Data Warehousing Success. MIS Quarterly, 25(1), 17. doi:10.2307/3250957