Comparing and contrasting transactional databases and data warehouses

Topics: Database, Database management system, Data warehouse Pages: 11 (5074 words) Published: October 26, 2014

In this assignment I will be comparing and contrasting transactional databases and data warehouses, demonstrating the similarities and differences between them both. I will do this by first defining these database systems and the reason for their use. I will also be using key relevant theories and tools to back up my findings, to argue their differences and similarities as efficiently as possible. Where similarities between transactional databases and data warehouses do exist they are in the areas of information storage and use for cost efficiency. To fully understand the differences and comparisons of anything one must first define it. A transactional database is a database in which a user stores or manages data and this process is also defined as, ‘database transaction’ the database transaction refers to the work done within a database management system or less likely against a database.ADDIN CSL_CITATION { "citationItems" : [ { "id" : "ITEM-1", "itemData" : { "URL" : "http://www.databaseguides.com/what-is-a-transactional-database", "accessed" : { "date-parts" : [ [ "2014", "1", "4" ] ] }, "author" : [ { "dropping-particle" : "", "family" : "Clark", "given" : "Anthony", "non-dropping-particle" : "", "parse-names" : false, "suffix" : "" } ], "id" : "ITEM-1", "issued" : { "date-parts" : [ [ "2012" ] ] }, "title" : "What is a Transactional Database? \u00ab Database Guides", "type" : "webpage" }, "uris" : [ "http://www.mendeley.com/documents/?uuid=6c9f3566-8868-425e-8b63-a2d7f3ef6376" ] } ], "mendeley" : { "previouslyFormattedCitation" : "(Clark, 2012)" }, "properties" : { "noteIndex" : 0 }, "schema" : "https://github.com/citation-style-language/schema/raw/master/csl-citation.json" }(Clark, 2012) The purpose of database transaction is to imply integrity and credibility to stored data and will have a consistent state. ADDIN CSL_CITATION { "citationItems" : [ { "id" : "ITEM-1", "itemData" : { "URL" : "http://www.databaseguides.com/what-is-a-transactional-database", "accessed" : { "date-parts" : [ [ "2014", "1", "4" ] ] }, "author" : [ { "dropping-particle" : "", "family" : "Clark", "given" : "Anthony", "non-dropping-particle" : "", "parse-names" : false, "suffix" : "" } ], "id" : "ITEM-1", "issued" : { "date-parts" : [ [ "2012" ] ] }, "title" : "What is a Transactional Database? \u00ab Database Guides", "type" : "webpage" }, "uris" : [ "http://www.mendeley.com/documents/?uuid=6c9f3566-8868-425e-8b63-a2d7f3ef6376" ] } ], "mendeley" : { "previouslyFormattedCitation" : "(Clark, 2012)" }, "properties" : { "noteIndex" : 0 }, "schema" : "https://github.com/citation-style-language/schema/raw/master/csl-citation.json" }(Clark, 2012) A Data warehouse as defined by ADDIN CSL_CITATION { "citationItems" : [ { "id" : "ITEM-1", "itemData" : { "ISBN" : "978-0-13-305069-1", "author" : [ { "dropping-particle" : "", "family" : "Laudon", "given" : "Kenneth", "non-dropping-particle" : "", "parse-names" : false, "suffix" : "" }, { "dropping-particle" : "", "family" : "Laudon", "given" : "Jane", "non-dropping-particle" : "", "parse-names" : false, "suffix" : "" } ], "edition" : "13th", "id" : "ITEM-1", "issued" : { "date-parts" : [ [ "2014" ] ] }, "page" : "255", "publisher" : "Pearson Education", "publisher-place" : "Essex", "title" : "Management Information Systems: Managing the Digital Firm", "type" : "book" }, "uris" : [ "http://www.mendeley.com/documents/?uuid=d7b97610-75a3-4347-aa46-e7dd802821f4" ] } ], "mendeley" : { "previouslyFormattedCitation" : "(Laudon & Laudon, 2014)" }, "properties" : { "noteIndex" : 0 }, "schema" : "https://github.com/citation-style-language/schema/raw/master/csl-citation.json" }(Laudon & Laudon, 2014) “Is a database that stores current and historical data of potential interest to decision makers throughout the company”. The reason for the use of a data warehouse is mainly to analyse corporate data, this data can come from several places such as: Website transactions

Customer accounts
Systems for sales...

Bibliography: CSL_BIBLIOGRAPHY Altera Corporation. (2010). Memory System Design. In Embedded Design Handbook (p. 1). San Jose: Altera Corporation. Retrieved from http://www.altera.co.uk/literature/hb/nios2/edh_ed51008.pdf
Bocij, P., Greasley, A., & Hickie, S
Clark, A. (2012). What is a Transactional Database? « Database Guides. Retrieved January 04, 2014, from http://www.databaseguides.com/what-is-a-transactional-database
Codd, E., Codd, S
datawarehouse4u. (2008). Data Warehouse Schema Architecture - star schema. Retrieved January 07, 2014, from http://datawarehouse4u.info/Data-warehouse-schema-architecture-star-schema.html
Goessl, L
Goldstein, J. (2005). Writing SQL Queries: Let’s Start with the Basics. Retrieved January 07, 2014, from http://technet.microsoft.com/en-us/library/bb264565(v=sql.90).aspx
Laudon, K., & Laudon, J
Nenit. (2013). Understanding Star and Snowflake Schemas. Retrieved January 07, 2014, from http://www.nenit.net/articles/sql-server/ssas/schemas.aspx
Raman, V
Rouse, M. (2011). Denormalization. Retrieved January 04, 2014, from http://searchdatamanagement.techtarget.com/definition/denormalization
Rouse, M
Rouse, M. (2012b). In-memory database. Retrieved January 04, 2014, from http://whatis.techtarget.com/definition/in-memory-database
Rouse, M
TPC. (2013). TPC. Retrieved January 06, 2014, from http://www.tpc.org/
Tutorialspoint
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Databases and Data Warehouses Essay
  • Data Warehouse Essay
  • Database and Data Warehouse Essay
  • Data Warehouses Essay
  • Comparing the Contrasting Essay
  • Essay about Data Warehouses & Data Mining
  • Essay about Comparing and Contrasting
  • Comparing And Contrasting Essay

Become a StudyMode Member

Sign Up - It's Free