Data and Knowledge Management CHAPTER OUTLINE 5.1 Managing Data 5.2 The Database Approach 5.3 Big Data...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Data and Knowledge Management CHAPTER OUTLINE 5.1 Managing Data 5.2 The Database Approach 5.3 Big Data 5.4 Data Warehouses and Data Marts 5.5 Knowledge Management 5.6 Appendix: Fundamentals of Relational Database Operations LEARNING OBJECTIVES 5.1 Discuss ways that common challenges in managing data can be addressed using data governance. 5.2 Discuss the advantages and disadvantages of relational databases. 5.3 Define Big Data and its basic characteristics. 5.4 Explain the elements necessary to successfully implement and maintain data warehouses. 5.5 Describe the benefits and challenges of implementing knowledge management systems in organizations. 5.6 Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins. Opening Case Tracking Pot from Seed to Customer The Problem POM When Colorado's Amendment 64 legalized recreational mari- juana in 2012, most of its support came from voters in Denver and its surrounding metropolitan area, and not from the state's more rural ar- eas. As a result, Colorado remains divided over the drug, which is still illegal under federal law (as of March 2017). At least partially in response to this ongoing debate, Colorado has placed strict regulations on all aspects of the marijuana production process. These regulations mandate that producers and distributors track each plant throughout its life cycle. The problem was how to im- plement these regulations in an efficient, accountable, cost-effective manner. The IT Solution tuana growers and distributors are having to adjust to eas. As a result, Colorado remains divided illegal under federal law (as of March 2017). In fact, of 321 municipalities in Colorado, 228 opted out of allow- ing marijuana..Local officials and law enforcement throughout the state, unconvinced of the benefits of legalizing marijuana, have tried to push back against legalization, citing the federal government's ban on the drug. Meanwhile, investors, business owners, tourists, and many Colorado residents argue that legal recreational marijuana has benefited the state. The IT Solution Colorado's marijuana growers and distributors are having to adjust to regulations concerning their newly' legitimate businesses. Under the state's rules, growers must put a microchip on each plant so it can be recorded and monitored in Colorado's Marijuana Enforcement Track- ing Reporting Compliance (METRC; www.metrc.com) system. Franwell (www.franwell.com), a Florida-based technology com pany, developed METRC. The system provides end-to-end tracking and 118 Introduction 119 tracing of marijuana plants and products. Franwell developed the sys- tem specifically for government agencies in charge of legalized mari- juana enforcement. As of November 2016, METRC had registered over 20,000 users and tracked over 5 million plants and 4 million packages. Here is how METRC works. A yellow radio-frequency identification (RFID) tag placed on each plant enables officials consulting a statewide database to track crops from "bud to blunt." The tags contain 24-digit identification codes, and they are staked into the soil or wrapped around individual plants while they grow. The tags travel with the plants through the grow house, to harvest, and as the pot flowers are dried and cured for flavor. (A grow house is a property that is primarily used for the production of mar- ijuana.) For shipment to stores, each strain of marijuana is grouped into a batch that receives its own RFID tag, which remains on the pack- ages until the batch is sold. During scheduled and unscheduled visits to dispensaries or grow houses, state officials use RFID scanners and electronic inventories to ensure that none of the plants goes missing. Each plant tag costs 45 cents, and the batch package tag costs 25 cents. Growers contend that the tags are expensive. For many grow- ers, however, their biggest frustration is having to enter the data twice: once into their own accounting databases and again into the MITS sys- tem, which is not compatible with most other accounting programs. The penalties for mistakes in entering the data include loss of license and criminal charges. Given that the potential for mistakes is high, growers feel that these penalties are excessively harsh. For example, when a plant dies, growers must follow a lengthy ticketing procedure Other growers are installing their own RFID scanners to electronically track each plant's location in their warehouses. The Results As of November 2016, the state of Colorado had issued some 3,000 li- censes for marijuana cultivation, production, and testing facilities and retail stores in both the medical and recreational markets. Marijuana brought in nearly $80 million for the state in taxes and fees during the 2015 fiscal year (based on $996.5 million in total licensed marijuana sales). The revenue comes from a 2.9 percent retail and medical mar- ijuana sales tax, a 10 percent retail marijuana special sales tax, and a 15 percent marijuana excise tax, plus application and license fees for retail and medical marijuana. Those figures did not keep track of the economic contributions of thousands of tourists who come to Colorado partly for its marijuana. In fact, according to Colorado's Marijuana Enforcement Division, up to 90 percent of recreational marijuana sales in some areas, particularly mountain resort towns, are made to tourists. By May 2017, Alaska, Washington, Oregon, California, Massachu- setts, Nevada, Maine, Colorado, and the District of Columbia had le- galized nonmedical cultivation and uses of marijuana. Most of these states were planning to use an RFID system similar to Colorado's to monitor marijuana production and distribution. Sources: Compiled from T. Fuller, "Californians Legalize Marijuana in Vote that Could Echo Nationally," New York Times, November 9, 2016; J. Alsever, "Is Pot Losing Its Buzz in Colorado?" Fortune, June 29, 2016; R. Grenoble, "Revenue tem specifically for government agencies in charge of legalized mari- juana enforcement. As of November 2016, METRC had registered over 20,000 users and tracked over 5 million plants and 4 million packages. Here is how.METRC works. A yellow radio-frequency identification (RFID) tag placed on each plant enables officials consulting a statewide database to track crops from "bud to blunt." The tags contain 24-digit identification codes, and they are staked into the soil or wrapped around individual plants while they grow. The tags travel with the plants through the grow house, to harvest, and as the pot flowers are dried and cured for flavor. (A grow house is a property that is primarily used for the production of mar- ijuana.) For shipment to stores, each strain of marijuana is grouped into a batch that receives its own RFID tag, which remains on the pack- ages until the batch is sold. During scheduled and unscheduled visits to dispensaries or grow houses, state officials use RFID scanners and electronic inventories to ensure that none of the plants goes missing. Each plant tag costs 45 cents, and the batch package tag costs 25 cents. Growers contend that the tags are expensive. For many grow- ers, however, their biggest frustration is having to enter the data twice: once into their own accounting databases and again into the MITS sys- tem, which is not compatible with most other accounting programs. The penalties for mistakes in entering the data include loss of license and criminal charges. Given that the potential for mistakes is high, growers feel that these penalties are excessively harsh. For example, when a plant dies, growers must follow a lengthy ticketing procedure to document and delete that plant from the system or face severe pen- alties for a "missing" plant. Franwell is working to develop a system that integrates with grower databases. The company notes that the water- and chemical- resistant tags are relatively cheap given that orders are usually small. A spokeswoman for Colorado's marijuana enforcement division maintains that red tape and fees are "part of being regulated." Com- plaints notwithstanding, one grower stated that RFID tagging and capturing the data in the MITS database is necessary to legitimize the industry. The plant tags do provide some benefits to growers. Specifically, they offer knowledgeable growers a closer look at which strains are selling well or where a troublesome batch shipped. For example, when a batch of pot-infused gummy bears shipped from Native Roots (http://nativeroots303.com, the largest marijuana dispensary in Colorado) became moldy, the store manager used the data recorded on the METRC database to locate and recall only the rotten gummies. track each plant's location in their warehouses. The Results As of November 2016, the state of Colorado had issued some 3,000 li- censes for marijuana cultivation, production, and testing facilities and retail stores in both the medical and recreational markets. Marijuana brought in nearly $80 million for the state in taxes and fees during the 2015 fiscal year (based on $996.5 million in total licensed marijuana sales). The revenue comes from a 2.9 percent retail and medical mar- ijuana sales tax, a 10 percent retail marijuana special sales tax, and a 15 percent marijuana excise tax, plus application and license fees for retail and medical marijuana. Those figures did not keep track of the economic contributions of thousands of tourists who come to Colorado partly for its marijuana. In fact, according to Colorado's Marijuana Enforcement Division, up to 90 percent of recreational marijuana sales in some areas, particularly mountain resort towns, are made to tourists. By May 2017, Alaska, Washington, Oregon, California, Massachu- setts, Nevada, Maine, Colorado, and the District of Columbia had le- galized nonmedical cultivation and uses of marijuana. Most of these states were planning to use an RFID system similar to Colorado's to monitor marijuana production and distribution. Sources: Compiled from T. Fuller, "Californians Legalize Marijuana in Vote that Could Echo Nationally," New York Times, November 9, 2016; J. Alsever, "Is Pot Losing Its Buzz in Colorado?" Fortune, June 29, 2016; R. Grenoble, "Revenue from Colorado Marijuana Tax Expected to Double in 2015," The Huffington Post, September 21, 2015; K. Wyatt, "Colorado Pot Growers Save Big Bucks on Tax Holiday Caused by Quirk in State Law," US News and World Report, September 16, 2015; J. Frank, "Ahead of 2015 Vote, Campaign Pushes Marijuana Tax Question in Colorado," Denver Post, September 13, 2015; C. Cooper, "Colorado Profits, But Still Divided on Legal Weed," The Center for Public Integrity, August 16, 2015; R. Baca, "Colorado Pot Sales Spike in June, Top $50 Million for First Time," The Cannabist, August 13, 2015; H. Borrud, "Oregon Pot Tracking System Will Use RFID Technology," East Oregonian, June 14, 2015; S. Lohmeyer, "States Turn to Tech for Tracking Marijuana," GCN.com, May 26, 2015; K. Weise, "Tracking Colorado's Legal Pot, Plant by Plant," Bloomberg BusinessWeek, March 17-23, 2014; R. Hiscott, "RFID Tags Track Marijuana from Seed to Sale in Colorado," Mashable, February 11, 2014. Questions 1. Describe how database technology plays an important role en- abling Colorado to closely monitor the marijuana production and distribution process. 2. Describe potential disadvantages in using RFID tags to monitor marijuana production and distribution. Data and Knowledge Management CHAPTER OUTLINE 5.1 Managing Data 5.2 The Database Approach 5.3 Big Data 5.4 Data Warehouses and Data Marts 5.5 Knowledge Management 5.6 Appendix: Fundamentals of Relational Database Operations LEARNING OBJECTIVES 5.1 Discuss ways that common challenges in managing data can be addressed using data governance. 5.2 Discuss the advantages and disadvantages of relational databases. 5.3 Define Big Data and its basic characteristics. 5.4 Explain the elements necessary to successfully implement and maintain data warehouses. 5.5 Describe the benefits and challenges of implementing knowledge management systems in organizations. 5.6 Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins. Opening Case Tracking Pot from Seed to Customer The Problem POM When Colorado's Amendment 64 legalized recreational mari- juana in 2012, most of its support came from voters in Denver and its surrounding metropolitan area, and not from the state's more rural ar- eas. As a result, Colorado remains divided over the drug, which is still illegal under federal law (as of March 2017). At least partially in response to this ongoing debate, Colorado has placed strict regulations on all aspects of the marijuana production process. These regulations mandate that producers and distributors track each plant throughout its life cycle. The problem was how to im- plement these regulations in an efficient, accountable, cost-effective manner. The IT Solution tuana growers and distributors are having to adjust to eas. As a result, Colorado remains divided illegal under federal law (as of March 2017). In fact, of 321 municipalities in Colorado, 228 opted out of allow- ing marijuana..Local officials and law enforcement throughout the state, unconvinced of the benefits of legalizing marijuana, have tried to push back against legalization, citing the federal government's ban on the drug. Meanwhile, investors, business owners, tourists, and many Colorado residents argue that legal recreational marijuana has benefited the state. The IT Solution Colorado's marijuana growers and distributors are having to adjust to regulations concerning their newly' legitimate businesses. Under the state's rules, growers must put a microchip on each plant so it can be recorded and monitored in Colorado's Marijuana Enforcement Track- ing Reporting Compliance (METRC; www.metrc.com) system. Franwell (www.franwell.com), a Florida-based technology com pany, developed METRC. The system provides end-to-end tracking and 118 Introduction 119 tracing of marijuana plants and products. Franwell developed the sys- tem specifically for government agencies in charge of legalized mari- juana enforcement. As of November 2016, METRC had registered over 20,000 users and tracked over 5 million plants and 4 million packages. Here is how METRC works. A yellow radio-frequency identification (RFID) tag placed on each plant enables officials consulting a statewide database to track crops from "bud to blunt." The tags contain 24-digit identification codes, and they are staked into the soil or wrapped around individual plants while they grow. The tags travel with the plants through the grow house, to harvest, and as the pot flowers are dried and cured for flavor. (A grow house is a property that is primarily used for the production of mar- ijuana.) For shipment to stores, each strain of marijuana is grouped into a batch that receives its own RFID tag, which remains on the pack- ages until the batch is sold. During scheduled and unscheduled visits to dispensaries or grow houses, state officials use RFID scanners and electronic inventories to ensure that none of the plants goes missing. Each plant tag costs 45 cents, and the batch package tag costs 25 cents. Growers contend that the tags are expensive. For many grow- ers, however, their biggest frustration is having to enter the data twice: once into their own accounting databases and again into the MITS sys- tem, which is not compatible with most other accounting programs. The penalties for mistakes in entering the data include loss of license and criminal charges. Given that the potential for mistakes is high, growers feel that these penalties are excessively harsh. For example, when a plant dies, growers must follow a lengthy ticketing procedure Other growers are installing their own RFID scanners to electronically track each plant's location in their warehouses. The Results As of November 2016, the state of Colorado had issued some 3,000 li- censes for marijuana cultivation, production, and testing facilities and retail stores in both the medical and recreational markets. Marijuana brought in nearly $80 million for the state in taxes and fees during the 2015 fiscal year (based on $996.5 million in total licensed marijuana sales). The revenue comes from a 2.9 percent retail and medical mar- ijuana sales tax, a 10 percent retail marijuana special sales tax, and a 15 percent marijuana excise tax, plus application and license fees for retail and medical marijuana. Those figures did not keep track of the economic contributions of thousands of tourists who come to Colorado partly for its marijuana. In fact, according to Colorado's Marijuana Enforcement Division, up to 90 percent of recreational marijuana sales in some areas, particularly mountain resort towns, are made to tourists. By May 2017, Alaska, Washington, Oregon, California, Massachu- setts, Nevada, Maine, Colorado, and the District of Columbia had le- galized nonmedical cultivation and uses of marijuana. Most of these states were planning to use an RFID system similar to Colorado's to monitor marijuana production and distribution. Sources: Compiled from T. Fuller, "Californians Legalize Marijuana in Vote that Could Echo Nationally," New York Times, November 9, 2016; J. Alsever, "Is Pot Losing Its Buzz in Colorado?" Fortune, June 29, 2016; R. Grenoble, "Revenue tem specifically for government agencies in charge of legalized mari- juana enforcement. As of November 2016, METRC had registered over 20,000 users and tracked over 5 million plants and 4 million packages. Here is how.METRC works. A yellow radio-frequency identification (RFID) tag placed on each plant enables officials consulting a statewide database to track crops from "bud to blunt." The tags contain 24-digit identification codes, and they are staked into the soil or wrapped around individual plants while they grow. The tags travel with the plants through the grow house, to harvest, and as the pot flowers are dried and cured for flavor. (A grow house is a property that is primarily used for the production of mar- ijuana.) For shipment to stores, each strain of marijuana is grouped into a batch that receives its own RFID tag, which remains on the pack- ages until the batch is sold. During scheduled and unscheduled visits to dispensaries or grow houses, state officials use RFID scanners and electronic inventories to ensure that none of the plants goes missing. Each plant tag costs 45 cents, and the batch package tag costs 25 cents. Growers contend that the tags are expensive. For many grow- ers, however, their biggest frustration is having to enter the data twice: once into their own accounting databases and again into the MITS sys- tem, which is not compatible with most other accounting programs. The penalties for mistakes in entering the data include loss of license and criminal charges. Given that the potential for mistakes is high, growers feel that these penalties are excessively harsh. For example, when a plant dies, growers must follow a lengthy ticketing procedure to document and delete that plant from the system or face severe pen- alties for a "missing" plant. Franwell is working to develop a system that integrates with grower databases. The company notes that the water- and chemical- resistant tags are relatively cheap given that orders are usually small. A spokeswoman for Colorado's marijuana enforcement division maintains that red tape and fees are "part of being regulated." Com- plaints notwithstanding, one grower stated that RFID tagging and capturing the data in the MITS database is necessary to legitimize the industry. The plant tags do provide some benefits to growers. Specifically, they offer knowledgeable growers a closer look at which strains are selling well or where a troublesome batch shipped. For example, when a batch of pot-infused gummy bears shipped from Native Roots (http://nativeroots303.com, the largest marijuana dispensary in Colorado) became moldy, the store manager used the data recorded on the METRC database to locate and recall only the rotten gummies. track each plant's location in their warehouses. The Results As of November 2016, the state of Colorado had issued some 3,000 li- censes for marijuana cultivation, production, and testing facilities and retail stores in both the medical and recreational markets. Marijuana brought in nearly $80 million for the state in taxes and fees during the 2015 fiscal year (based on $996.5 million in total licensed marijuana sales). The revenue comes from a 2.9 percent retail and medical mar- ijuana sales tax, a 10 percent retail marijuana special sales tax, and a 15 percent marijuana excise tax, plus application and license fees for retail and medical marijuana. Those figures did not keep track of the economic contributions of thousands of tourists who come to Colorado partly for its marijuana. In fact, according to Colorado's Marijuana Enforcement Division, up to 90 percent of recreational marijuana sales in some areas, particularly mountain resort towns, are made to tourists. By May 2017, Alaska, Washington, Oregon, California, Massachu- setts, Nevada, Maine, Colorado, and the District of Columbia had le- galized nonmedical cultivation and uses of marijuana. Most of these states were planning to use an RFID system similar to Colorado's to monitor marijuana production and distribution. Sources: Compiled from T. Fuller, "Californians Legalize Marijuana in Vote that Could Echo Nationally," New York Times, November 9, 2016; J. Alsever, "Is Pot Losing Its Buzz in Colorado?" Fortune, June 29, 2016; R. Grenoble, "Revenue from Colorado Marijuana Tax Expected to Double in 2015," The Huffington Post, September 21, 2015; K. Wyatt, "Colorado Pot Growers Save Big Bucks on Tax Holiday Caused by Quirk in State Law," US News and World Report, September 16, 2015; J. Frank, "Ahead of 2015 Vote, Campaign Pushes Marijuana Tax Question in Colorado," Denver Post, September 13, 2015; C. Cooper, "Colorado Profits, But Still Divided on Legal Weed," The Center for Public Integrity, August 16, 2015; R. Baca, "Colorado Pot Sales Spike in June, Top $50 Million for First Time," The Cannabist, August 13, 2015; H. Borrud, "Oregon Pot Tracking System Will Use RFID Technology," East Oregonian, June 14, 2015; S. Lohmeyer, "States Turn to Tech for Tracking Marijuana," GCN.com, May 26, 2015; K. Weise, "Tracking Colorado's Legal Pot, Plant by Plant," Bloomberg BusinessWeek, March 17-23, 2014; R. Hiscott, "RFID Tags Track Marijuana from Seed to Sale in Colorado," Mashable, February 11, 2014. Questions 1. Describe how database technology plays an important role en- abling Colorado to closely monitor the marijuana production and distribution process. 2. Describe potential disadvantages in using RFID tags to monitor marijuana production and distribution.
Expert Answer:
Related Book For
Business Statistics In Practice Using Data Modeling And Analytics
ISBN: 9781259549465
8th Edition
Authors: Bruce L Bowerman, Richard T O'Connell, Emilly S. Murphree
Posted Date:
Students also viewed these marketing questions
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
The new line character is utilized solely as the last person in each message. On association with the server, a client can possibly (I) question the situation with a client by sending the client's...
-
A paper recycling company converts newspaper, mixed paper, white office paper, and cardboard into pulp for newsprint, packaging paper, and print stock quality paper. The following table summarizes...
-
What is the capacitance of a capacitor that stores 4.3 C of charge on its plates when a voltage of 1.5 V is applied between them?
-
The balance sheet of Indian River Electronics Corporation as of December 31, 2017, included 12.25% bonds having a face amount of $90 million. The bonds had been issued in 2010 and had a remaining...
-
Consider the following cash flow profile, and assume MARR is 10 percent/year. a. What does Descartes' rule of signs tell us about the IRR(s) of this project? b. What does Norstrom's criterion tell us...
-
The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests...
-
1/ You have two different assets (investments). Asset A (perpetuity) will pay you $1,000 in one year, $1,000 in two years, $1,000 in three years, and so on every year forever. Asset B will pay you...
-
Assume the total cost of a college education will be $360,000 when your child enters college in 15 years. You presently have $58,000 to invest. What annual rate of interest must you earn on your...
-
A.Profits.java A grocery store sells many cases of soft drink every day. In each case, there are 12 bottles and the store profits 20 cents per bottle. We want to compute the profit that the store has...
-
Given f(x) = 2x-1 and g(x)=5- find the following expressions. (a) (fog)(4) (b) (gof)(2) (c) (fof)(1) (d) (gog)(0) (a) (fog)(4)(Simplify your answer.)
-
Determine Shear Stress and Angle of Twist of Circular Shaft having Diameter D, Length L, Torque (Torsional Moment) T and Shear Modulus G?
-
4. [8 points] We would like to allow RISC-V (RV321/RV641) to support indexed indirect addressing. We want to support load and store instructions of the type lw x8, (x7,x6), which would generate a...
-
The following transactions occurred during March, the first month of operations for Quality Galleries, Incorporated: Capital stock was issued in exchange for $356,000 cash. Purchased $172,000 of...
-
Training, Employee Relations, and Compensation Final Project Assignment Instructions For your assignment in this course, you will be developing a training program for managers. The program needs to...
-
For each equation, (a) Write it in slope-intercept form (b) Give the slope of the line (c) Give the y-intercept (d) Graph the line. 7x - 3y = 3
-
Write a paragraph explaining how common causes of process variation differ from assignable causes of process variation.
-
Figure 2.5 gives a percentage pie chart of new vehicle market shares in the United States for 2014 as given by GoodCarBadCar.net. Use this pie chart and your results from Exercise 2.9 to write an...
-
When we construct a bar chart or graph, what is the effect of starting the vertical axis at a value that is far above zero? Explain.
-
Show that, in Theorem 19.17, the quadratic variation \(\langle Mangle_{t}\) is a \(\mathscr{G}_{t}\) stopping time.Direct calculation, use Lemma 19.16.c) and A. 15 Data From Theorem 19.17 19.17...
-
The proof of Theorem 19.29 uses, implicitly, the following beautiful result due to Skorokhod [239] which is to be proved: Lemma. Let \(b:[0, \infty) ightarrow \mathbb{R}\) be a continuous function...
-
We have seen in Lemma 19.27.a) that \(\operatorname{supp}\left[d L_{t}^{0}(\omega) ight] \subset\left\{t \geqslant 0: B_{t}(\omega)=0 ight\}\) for almost all \(\omega\). Show that...
Study smarter with the SolutionInn App