{"id":364,"date":"2017-09-14T18:22:33","date_gmt":"2017-09-14T18:22:33","guid":{"rendered":"http:\/\/bocchinfuso.net\/?p=364"},"modified":"2017-10-06T19:28:41","modified_gmt":"2017-10-06T19:28:41","slug":"fit-mgt-5115-wk-3-discussion-post","status":"publish","type":"post","link":"http:\/\/bocchinfuso.net\/index.php\/2017\/09\/14\/fit-mgt-5115-wk-3-discussion-post\/","title":{"rendered":"FIT \u2013 MGT 5115 \u2013 Wk 3 Discussion Post"},"content":{"rendered":"

How does data quality impact business performance? Using your textbook as a resource, describe the functions of database technology, the differences between centralized and distributed database architecture, how data quality impacts performance, and the role of a master reference file in creating accurate and consistent data across the enterprise.<\/em><\/p>\n

When poor data quality such as missing and\/or erroneous data negatively impacts operations, it can cost organizations business, affecting revenues and profits. \u00a0Missing and\/or erroneous data can affect current revenues and can frustrate customer and place an organizations reputation at risk putting both existing and future business at stake. Data quality issues can decrease efficiency and increase costs, lack of confidence in data integrity causes organizations to spend time and money on data validation and error correction activities.<\/p>\n

The goal of a database is to store data in a structured way (maybe). \u00a0Two popular\u00a0database architectures are SQL and NoSQL databases. \u00a0SQL or RDBMS (Relational Database Management Systems) are relational with a defined schema. NoSQL databases or document databases are often schemaless and rely on key-value pairs defined at ingest. \u00a0As you can imagine ingesting (or inserting) data into a specified schema makes managing data integrity easier than defining the key-value pairs at the time of ingest.<\/p>\n

Centralized and distributed database architectures are quite intuitive. \u00a0Centralized database architectures centralize the storage and control of data while distributed database architectures allow data to be stored on edge devices such as laptops, tablets, and mobile devices or distributed using master\/master, master\/slave or parent\/child relationships. \u00a0Centralized database architectures offer greater control of data quality and security because all data is stored in a single physical location thus adds, updates and deletes can be made in a supervised and orderly fashion. \u00a0Centralized database architectures also allow for better security. It is easier to control physical and logical access to a centralized architecture, and the attack surface is limited when contrasted with a distributed system.<\/p>\n

Centralized and distributed database architectures each come with tradeoffs which should be considered when selecting an appropriate architecture. \u00a0With more and more processing being pushed to the edge (e.g. – mobile and IoT growth) and with ever increasing big data demands decentralized distributed databases like\u00a0Apache Cassandra<\/a>\u00a0and\u00a0RethinkDB<\/a>\u00a0are experiencing\u00a0massive\u00a0growth. \u00a0Centralized databases like Microsoft SQL Server,\u00a0MariaDB<\/a>\u00a0and others are still very prominent, but even these centralized database players are trying to adapt their architectures to support distributed database architectures to capitalize on the big data revolution.<\/p>\n

Master reference files provide a common point of reference and act as a single source truth for a given data entity. Data entities might include customer, product, supplier, employee or asset data. As a single source of truth, master reference files are used to feed data into enterprise systems and maintain data quality and integrity.<\/p>\n

References<\/strong><\/p>\n

Buckler, Craig. \u201cSQL vs NoSQL: The Differences \u2014 SitePoint.\u201d SitePoint, SitePoint, 18 Sept. 2015, www.sitepoint.com\/sql-vs-nosql-differences\/. Accessed 14 Sept. 2017.<\/p>\n

\u201cDo You Know How Data Quality Impacts Your Business?\u201d BackOffice Assicates, 23 July 23ADAD, resources.boaweb.com\/backoffice-blog\/do-you-know-how-data-quality-impacts-your-business. Accessed 14 Sept. 2017.<\/p>\n

Turban, Efraim, et al. Information technology for management digital strategies for insight, action, and sustainable performance. New Jersey (Estados Unidos), Wiley, 2015.<\/p>\n","protected":false},"excerpt":{"rendered":"

How does data quality impact business performance? Using your textbook as a resource, describe the functions of database technology, the differences between centralized and distributed database architecture, how data quality impacts performance, and the role of a master reference file in creating accurate and consistent data across the enterprise. When poor data quality such as […]<\/p>\n","protected":false},"author":1,"featured_media":37,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,8,2,1],"tags":[],"_links":{"self":[{"href":"http:\/\/bocchinfuso.net\/index.php\/wp-json\/wp\/v2\/posts\/364"}],"collection":[{"href":"http:\/\/bocchinfuso.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bocchinfuso.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bocchinfuso.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/bocchinfuso.net\/index.php\/wp-json\/wp\/v2\/comments?post=364"}],"version-history":[{"count":1,"href":"http:\/\/bocchinfuso.net\/index.php\/wp-json\/wp\/v2\/posts\/364\/revisions"}],"predecessor-version":[{"id":365,"href":"http:\/\/bocchinfuso.net\/index.php\/wp-json\/wp\/v2\/posts\/364\/revisions\/365"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/bocchinfuso.net\/index.php\/wp-json\/wp\/v2\/media\/37"}],"wp:attachment":[{"href":"http:\/\/bocchinfuso.net\/index.php\/wp-json\/wp\/v2\/media?parent=364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bocchinfuso.net\/index.php\/wp-json\/wp\/v2\/categories?post=364"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bocchinfuso.net\/index.php\/wp-json\/wp\/v2\/tags?post=364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}