Comparing and contrasting transactional databases and data warehouses
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",
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",
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