Skip header Section
Skip Bibliometrics Section
Building a Scalable Data Warehouse with Data Vault 2.0October 2015
- Authors:
- Dan Linstedt,
- Michael Olschimke
Skip Abstract Section
Abstract
The Data Vault was invented by Dan Linstedt at the U.S. Department of Defense, and the standard has been successfully applied to data warehousing projects at organizations of different sizes, from small to large-size corporations. Due to its simplified design, which is adapted from nature, the Data Vault 2.0 standard helps prevent typical data warehousing failures. "Building a Scalable Data Warehouse" covers everything one needs to know to create a scalable data warehouse end to end, including a presentation of the Data Vault modeling technique, which provides the foundations to create a technical data warehouse layer. The book discusses how to build the data warehouse incrementally using the agile Data Vault 2.0 methodology. In addition, readers will learn how to create the input layer (the stage layer) and the presentation layer (data mart) of the Data Vault 2.0 architecture including implementation best practices. Drawing upon years of practical experience and using numerous examples and an easy to understand framework, Dan Linstedt and Michael Olschimke discuss: How to load each layer using SQL Server Integration Services (SSIS), including automation of the Data Vault loading processes. Important data warehouse technologies and practices. Data Quality Services (DQS) and Master Data Services (MDS) in the context of the Data Vault architecture. Provides a complete introduction to data warehousing, applications, and the business context so readers can get-up and running fast Explains theoretical concepts and provides hands-on instruction on how to build and implement a data warehouseDemystifies data vault modeling with beginning, intermediate, and advanced techniquesDiscusses the advantages of the data vault approach over other techniques, also including the latest updates to Data Vault 2.0 and multiple improvements to Data Vault 1.0
- Laudon KC, Laudon JP. Essentials of Management Information Systems. 11th ed. Prentice Hall; 2014.Google Scholar
- Loshin D. The Practitioner's Guide to Data Quality Improvement. Morgan Kaufmann; 2010. Google Scholar
- Ackoff, Russell. From data to wisdom. Journal of Applied Systems Analysis 1989;16:3-9.Google Scholar
- Pearlson KE, Saunders CS. Managing and Using Information Systems. 5th ed. Wiley; 2012. Google Scholar
- P. F. Drucker, The Coming of the New Organization, Harvard Business Review (January-February 1988).Google Scholar
- Jennex Murray E. Re-Visiting the Knowledge Pyramid. In: Proceedings of the 42nd Hawaii International Conference on System Sciences - 2009; January 5-8, 2009 Waikoloa, Hawaii. Google Scholar
- Golfarelli M, Rizzi S. Data Warehouse Design: Modern principles and methodologies. McGraw-Hill Education; 2009. Google Scholar
- D. Power, Data-Drive DSS Resources, website, available from http://dssresources.com/dsstypes/ddss.html.Google Scholar
- Inmon. Building the Data Warehouse. 5th ed. John Wiley and Sons; 2005. Google Scholar
- Rick Sherman: Business Intelligence Guidebook: From Data Integration to Analytics, p131. Google Scholar
- What Is Enterprise Data Warehouse, GeekInterview website, 2007, available from http://www.learn.geekinterview.com/data-warehouse/data-types/what-is-enterprise-data-warehouse.html.Google Scholar
- Kimball R, Ross M. The Data Warehouse Toolkit. 2nd ed. John Wiley & Sons; 2002.Google Scholar
- Oracle, Data Mart Concepts, 2007, website available from http://docs.oracle.com/html/E10312_01/dm_concepts.htm.Google Scholar
- Imhof C, Galemmo N, Geiger JG. Mastering Data Warehouse Design. John Wiley & Sons; 2003. Google Scholar
- J King, Business intelligence: One version of the truth, Computerworld, Dec 22, 2003, available from http://www.computerworld.com/s/article/88349/Business_Intelligence_One_Version_of_the_Truth.Google Scholar
- N Goyal: Real-Time Data Warehousing, PowerPoint presentation available online from http://www.scribd.com/doc/269892533/Real-Time-Data-Warehousing#scribd.Google Scholar
- V Rainardi: Building a Data Warehouse. Apress; 2007. Google Scholar
- Microsoft, SQL Server, Understanding pages and extents, 2015, available online from http://technet.microsoft.com/en-us/library/ms190969%28v=sql.105%29.aspx.Google Scholar
- Linstedt D, Graziano K. Super Charge your Data Warehouse. Createspace Independent Pub; 2011.Google Scholar
- Kimball R, Caserta J. The Data Warehouse ETL Toolkit. Wiley Publishing, Inc., Indianapolis; 2004.Google Scholar
- Inmon W, Strauss D, Neushloss G. DW 2.0: The Architecture for the Next Generation of Data Warehousing. Morgan Kaufmann; 2008. Google Scholar
- Yu Beng Leau, Wooi Khong Loo, Wai Yip Tham, Soo Fun Tan, Software Development Life Cycle AGILE vs Traditional Approaches, 2012 International Conference on Information and Network Technology, Singapore, p. 162f, available from http://www.ipcsit.com/vol37/030-ICINT2012-I2069.pdf.Google Scholar
- Szalvay, Victor. An Introduction to Agile Software Development. Danube Technologies Inc; 2004.Google Scholar
- Kimball R, Ross M. The Data Warehouse Lifecycle Toolkit. 3rd ed John Wiley & Sons, Indianapolis; 2013.Google Scholar
- Abramson, I. Data Warehouse: The Choice of Inmon vs. Kimball. IAS Inc. (PowerPoint slides). Available from http://www.scribd.com/doc/253618546/080827Abramson-Inmon-vs-Kimball#scribd.Google Scholar
- Inmon: Building the data warehouse, 4th edition, p. 91ff. Google Scholar
- Dan Linstedt: Data Vault 2.0 Training Slides, p. 12.Google Scholar
- Splunk - "Splunk for Big Data" in Philip Winslow et al. Does Size Matter Only?, p. 32.Google Scholar
- Mark Sweiger: Scalable Computer Architectures for Data Warehousing, p. 1.Google Scholar
- http://student.bus.olemiss.edu/files/Conlon/Others/Others/BUS669/ResearchPapers/From%20ACM/The%20IBM%20data%20warehouse%20architecture%20-bontempo.pdf.Google Scholar
- Golfarelli and Rizzi: Data Warehouse Design, p. 199.Google Scholar
- Vassiliadis 2000: Gulliver in the land of data warehousing: Practical experiences and observations of a researcher. In Proceedings 2nd International Workshop on Design and Management of Data Warehouses, Stockholm.Google Scholar
- Gupta et al. 1997b: Index selection for OLAP. In Proceedings 13th International Conference on Data Engineering, Birmingham, UK, p. 208-219. Google Scholar
- Mike Ferguson: Architecting a big data platform for Analytics, p. 5.Google Scholar
- James Kobielus: Living the Big Data Dream: Confidence, Confidentiality and Continuous Automation in the 21st Century: http://www.ibmbigdatahub.com/blog/living-big-data-dream-confidence-confidentiality-and-continuous-automation-21st-century.Google Scholar
- Mike Ferguson: Architecting a big data platform for Analytics, p. 5f.Google Scholar
- Bontempo, C. and Saracco, C. Database Management: Principles and Products. Prentice Hall, Upper Saddle River, N.J., 1995 in Charles Bontempo and George Zagelow: The IBM Data Warehouse Architecture, p. 44. Google Scholar
- https://technet.microsoft.com/en-us/magazine/2008.04.dwperformance.aspx.Google Scholar
- https://technet.microsoft.com/en-us/library/bb522541(v=sql.105).aspx.Google Scholar
- Dayong Gu, et al. "Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries," https://msdn.microsoft.com/en-us/library/gg567299.aspx.Google Scholar
- Harinarayan et al. Implementing Data Cubes Efficiently, p. 1.Google Scholar
- Joy Mundy, Warren Thornthwaite: "The Microsoft Data Warehouse Toolkit", Second Edition, p. 603f (System and Availability Management). Google Scholar
- Joy Mundy, Warren Thornthwaite: "The Microsoft Data Warehouse Toolkit", Second Edition, p. 114f (Setting up for High Availability). Google Scholar
- Dan Linstedt: Data Vault 2.0 Training, p. 9.Google Scholar
- Zaki, A. Business Rules and the Data Warehouse, http://altis.com.au/business-rules-and-the-data-warehouse/, August 19, 2011.Google Scholar
- Dan Linstedt: Data Vault 2.0 Training, p. 37.Google Scholar
- Kimball: "The Data Warehouse Lifecycle Toolkit," p. 542. Google Scholar
- http://blogs.pmi.org/blog/voices_on_project_management/2012/04/what-does-a-project-sponsor-re.htmlGoogle Scholar
- http://www2.cit.cornell.edu/computer/robohelp/cpmm/Project_Roles_and_Responsibilities.htmGoogle Scholar
- http://www.cwjobs.co.uk/careers-advice/profiles/it-managerGoogle Scholar
- The DAMA Guide to The Data Management Body of Knowledge (DAMA-DMBOK Guide), 1st edition, page 33. Google Scholar
- Li Sun: "A Metadata Manager's Role in Collaborative Projects: The Rutgers University Libraries Experience".Google Scholar
- James Persse: Project Management Success with CMMI, pp. 14f-15f, 17-18, 55. Google Scholar
- Paul E. McMahon: Integrating CMMI and Agile Development, p. 277. Google Scholar
- Jeannine M. Siviy, M. Lynn Penn, Robert W. Stoddard: CMMI and Six Sigma, p. 95.Google Scholar
- Dennis M. Ahern, Aaron Clouse, Richard Turner: CMMI Distilled, pp. 83f, 84f, 85f, 98f, 102, 102f.Google Scholar
- Mary Beth Chrissis, Mike Konrad, Sandy Shrum: CMMI for Development, pp. 35, 41f, 42-43, 43f, 44-45.Google Scholar
- http://www.ambysoft.com/books/dad.htmlGoogle Scholar
- Scott W. Ambler, Mark Lines: Disciplined Agile Delivery, pp. 22f, 87, 311ff, 111ff, 273ff, 267f, 309ff, 441ff, 465.Google Scholar
- Stober, Hansmann: Agile Software Development, pp. 27f, 119-120.Google Scholar
- Schwaber K, Beedle M. Agile software development with scrum. Englewood Cliffs, NJ: Prentice Hall; 2001. Google Scholar
- Hirotaka Takeuchi, Ikujiro Nonaka. The new new product development game. Harvard Business Review 1986.Google Scholar
- Dave West and Tom Grant, "Agile Development: Mainstream Adoption Has Changed Agility Trends in Real-World Adoption of Agile Methods," available from www.forrester.com/rb/Research/agile_development_mainstream_adoption_has_changed_agility/q/id/56100/t/2, 17.Google Scholar
- Resnick, Bjork, de la Maza: Professional Scrum with Team Foundation Server 2010, pp. 13, 14. Google Scholar
- Greg Cohen: Agile Excellence for Product Managers, p. 22. Google Scholar
- Sam Guckenheimer, Neno Loje: Agile Software Engineering with Visual Studio, p. 7.Google Scholar
- Kim H. Pries, Jon M. Quigley: Scrum Project Management, pp. 11, 66, 67. Google Scholar
- Beyer: User-Centered Agile Methods, p. 5. Google Scholar
- David Garmus, David Herron: Function Point Analysis, pp. 28-29.Google Scholar
- Varun Barthwal, Jaydeep Kishore, Bhagawati Prasad Joshi: Estimation of Software Metrics using Function Point Analysis, pp. 5, 11.Google Scholar
- Minerva Softcare: Function Point Analysis and Data Warehousing, p. 4.Google Scholar
- David Longstreet: Function Point Analysis Training Course, p. 7.Google Scholar
- Harput V, Kaindl H. Kramer S. Extending Function Point Analysis to Object-Oriented Requirements Specifications, Proceeding on 11th IEEE International Software Metrics Symposium (METRICS 2005). Google ScholarDigital Library
- Karthikeyan Sankaran: Function Points Based Estimation Model for Data Warehouses: retrieved from http://www.ewsolutions.com/resource-center/rwds_folder/rwds-archives/issue.2008-03-01.6090544414/document.2008-03-01.9435972766Google Scholar
- Karthikeyan Sankaran: Function Points Based Estimation Model for Data Warehouses: retrieved from http://www.ewsolutions.com/resource-center/rwds_folder/rwds-archives/issue.2008-03-01.6090544414/document.2008-03-01.9435972766 (modifed from its original version to reflect SSIS terminology).Google Scholar
- Carol Dekkers, Barbara Emmons: How Function Points Support the Capability Maturity Model Integration, http://www.crosstalkonline.org/storage/issue-archives/2002/200202/200202-Dekkers.pdfGoogle Scholar
- Ken Collier: Agile Analytics, p. 30.Google Scholar
- Dr. K.V.K.K. Prasad: "Data Warehouse Development Tools", pp. 25f, 26, 26f, 27, 25ff.Google Scholar
- Inmon et al. DW2.0 The Architecture for the Next Generation of Data Warehousing, p. 124. Google Scholar
- Valacich et al. "Essentials of Systems Analysis and Design", pp. 122ff, 133ff. Google Scholar
- http://technet.microsoft.com/en-us/library/ms174173%28v=sql.110%29.aspxGoogle Scholar
- http://technet.microsoft.com/en-us/library/ms190415.aspxGoogle Scholar
- http://technet.microsoft.com/en-us/library/ms173767%28v=sql.105%29.aspx#AnalysisServicesGoogle Scholar
- http://ditakurniawaty.blogspot.de/2012/06/software-testing.htmlGoogle Scholar
- http://www.mountaingoatsoftware.com/agile/scrum/sprint-review-meetingGoogle Scholar
- http://www.mountaingoatsoftware.com/agile/scrum/sprint-retrospectiveGoogle Scholar
- Tomkins, R. (1997). GE beats expected 13% rise, Financial Times, (10 October), p.22.Google Scholar
- Harry, M.J. (1998). The Vision of Six Sigma, 8 volumes, Phoenix, Arizona, Tri Star Publishing.Google Scholar
- Park SH, Lee MJ, Chung MY. Theory and Practice of Six Sigma. Seoul: Publishing Division of Korean Standards Association; 1999.Google Scholar
- Sung H. Park: "Six Sigma - For Quality and Productivity Promotion", pp. 1ff, 5, 5f, 6f, 7, 8, 8f, 30, 30f, 31, 33, 34, 37, 41.Google Scholar
- Michael C. Thomsett: Getting Started in Six Sigma, pp. 6-7.Google Scholar
- Jeannine M. Siviy, M. Lynn Penn, Robert W. Stoddard: CMMI and Six Sigma - Partners in Process Improvement, pp. 37f, 38, 38f. Google Scholar
- Craig Gygi, Neil DeCarlo, Bruce Williams: Six Sigma for Dummies, pp. 42, 54.Google Scholar
- Praveen Gupta: Six Sigma Business Scorecard, pp. 25, 31, 36.Google Scholar
- George Eckes: Six Sigma fo Everyone, p. 29.Google Scholar
- Terry L. Richardson: Total Quality Management, pp. 51, 55, 57, 137, 138ff, 144, 149, 170, 186, 200.Google Scholar
- Leo L. Pipino, Yang W. Lee, Richard Y. Wang: Data Quality Assessment, p. 212.Google Scholar
- DAMA UK Working Group: "The Six Primary Dimensions for Data Quality Assessment", p. 7ff.Google Scholar
- http://smartbridge.com/data-done-right-6-dimensions-of-data-quality-part-1/Google Scholar
- Leo L. Pipino, Yang W. Lee, Richard Y. Wang: "Data Quality Assessment", p. 211Google Scholar
- Phil Cykana, Alta Paul, Miranda Stern: DOD Guidelines on Data Quality Management, p. 154.Google Scholar
- Carlo Batini, Cinzia Cappiello, Chiara Francalanci, Andrea Maurino: Methodologies for Data Quality Assessment and Improvement, pp. 16:35-16:37 (figures 6 and 7).Google Scholar
- Manfred A. Jeusfeld, Christoph Quix, Matthias Jarke: Design and Analysis of Quality Information for Data Warehouses.Google Scholar
- http://asq.org/learn-about-quality/total-quality-management/overview/overview.htmlGoogle Scholar
- Linstedt, D, Super Charge Your Data Warehouse: Invaluable Data Modeling Rules to Implement Your Data Vault, 2012, available as pdf ebook from http://learndatavault.com/books/super-charge-your-data-warehouse/.Google Scholar
- Dörffler & Partner GmbH, Visual Data Vault (website), 2015, available at http://www.visualdatavault.com.Google Scholar
- Gibson Guitar, Community Forum website, 2008, available at http://forum.gibson.com/index.php?/topic/765-duplicate-serial-number/Google Scholar
- Michael Olschimke, Daniel Linstedt: "Visual Data Vault", http://www.visualdatavault.comGoogle Scholar
- Linstedt, D. Super Charge Your Data Warehouse: Invaluable Data Modeling Rules to Implement Your Data Vault, 2012. available as pdf ebook from http://learndatavault.com/books/super-charge-your-data-warehouse/.Google Scholar
- NASA. Aeronautics Educator Guide - Parts of an Airplane, 2014. available at http://www.nasa.gov/audience/foreducators/topnav/materials/listbytype/Aeronautics_Parts_of_Airplane.html.Google Scholar
- NASA. Liquid Hydrogen as a Propulsion Fuel, http://history.nasa.gov/SP-4404/app-b5.htm.Google Scholar
- U.S. Department of Transportation, Federal Aviation Administration: "Aviation Maintenance Technician Handbook", p. 2-6.Google Scholar
- Microsoft SQL Server, Technet Library, 2015. available at http://technet.microsoft.com/en-us/library/bb500305.aspx.Google Scholar
- Microsoft MSDN Library website, Contact Entities, 2015. available at http://msdn.microsoft.com/en-us/library/bb928236.aspx.Google Scholar
- Microsoft Developer Network, MSDN Library, Data Compression. available at http://msdn.microsoft.com/en-us/library/cc280449.aspx.Google Scholar
- Ralph Kimball: The Data Warehouse Toolkit, first edition 1997.Google Scholar
- Ralph Kimball and Margy Ross: The Data Warehouse Toolkit, 2nd edition, page 16, 16ff, 17, 20, 30f, 31f, 19, 95f, 97.Google Scholar
- Christopher Adamson: Star Schema - The complete reference, p. 4f, 5f, 6, 10f, 11, 12, 13, 86f, 87, 44, 45f, 157.Google Scholar
- Norman J. Ashford, et al., Airport Operations", 3rd edition, p. 415.Google Scholar
- http://technet.microsoft.com/en-us/library/cc278097(v=sql.100).aspx.Google Scholar
- Joy Mundy and Warren Thornthwaite: The Microsoft Data Warehouse Toolkit, 2nd Edition, pp. 33, 36. Google Scholar
- http://www.kimballgroup.com/2013/02/design-tip-152-slowly-changing-dimension-types-0-4-5-6-7/.Google Scholar
- http://www.symcorp.com/tech_expertise_design.html.Google Scholar
- Best Buy, Fiscal 2014 Annual Report.Google Scholar
- http://technet.microsoft.com/en-us/library/hh393556(v(sql.110).aspx.Google Scholar
- Soumendra Mohanty, Madhu Jagadeesh, Harsha Srivatsa: Big Data Imperatives, p. 83, 83ff, 92f.Google Scholar
- Christian Bolton, et al. "Professional SQL Server 2012 - Internals and Troubleshooting", pp. 31f, 81, 84ff, 104ff. Google Scholar
- http://sqlmag.com/database-administration/data-warehouse-workloads-and-use-cases.Google Scholar
- http://www.allthingsdistributed.com/2007/12/eventually_consistent.html.Google Scholar
- http://wiki.apache.org/cassandra/ArchitectureOverview.Google Scholar
- http://blog.mongodb.org/post/498145601/on-distributed-consistency-part-2-some.Google Scholar
- Lars George: "HBase: The Definitive Guide," p. 9.Google Scholar
- http://dl.acm.org/citation.cfm?id(564585.564601.Google Scholar
- http://blog.mongodb.org/post/475279604/on-distributed-consistency-part-1.Google Scholar
- Doug Vucevic: "Testing Data Warehouse Applications", p. 99. Google Scholar
- Scott W. Ambler, Mark Lines: "Disciplined Agile Delivery", p. 425.Google Scholar
- Vincent Rainardi: "Building a Data Warehouse", p. 486, 487. Google Scholar
- Ken Collier: "Agile Analytics" p. 169f.Google Scholar
- http://technet.microsoft.com/en-us/library/jj127250.aspx.Google Scholar
- Scott Klein, Herve Roggero: "Pro SQL Database for Windows Azure", pp. 3, 4. Google Scholar
- http://www.developer.com/services/getting-started-with-azure-hdinsight.html.Google Scholar
- http://msdn.microsoft.com/en-us/magazine/dn385705.aspx.Google Scholar
- Kimball: The Data Warehouse Lifecycle Toolkit, p. 157f. Google Scholar
- http://blogs.technet.com/b/dataplatforminsider/archive/2014/07/30/transitioning-from-smp-to-mpp-the-why-and-the-how.aspx.Google Scholar
- http://technet.microsoft.com/en-us/library/ms345392(v(sql.105).aspx.Google Scholar
- http://sqlmag.com/sql-server-2008/getting-started-parallel-data-warehouse.Google Scholar
- Ralph Kimball: "The Data Warehouse Lifecycle Toolkit, 2nd Edition", p. 164. Google Scholar
- Adam Jorgensen et al. "Professional Microsoft SQL Server 2012 Administration", p. 259f. Google Scholar
- Peter M. Chen, et al. "RAID: High-Performance, Reliable Secondary Storage".Google Scholar
- Adam Jorgensen et al. "Professional Microsoft SQL Server 2012 Administration", pp. 260, 260f, 262f, 252, 277, 279f, 290ff. Google Scholar
- http://www.zdnet.com/blog/storage/why-raid-6-stops-working-in-2019/805.Google Scholar
- http://www.adaptec.com/en-us/_common/compatibility/_education/raid_level_compar_wp.htm.Google Scholar
- http://technet.microsoft.com/en-us/library/ms190433(v(sql.105).aspx.Google Scholar
- HP: "Understanding endurance and performance characteristics of HP solid state drives," http://h20565.www2.hp.com/hpsc/doc/public/display?docId(emr_na-c03312456.Google Scholar
- http://sqlmag.com/storage/sql-server-storage-best-practices.Google Scholar
- http://msdn.microsoft.com/en-us/library/ms190768.aspx.Google Scholar
- http://technet.microsoft.com/en-us/library/ms175527(v(sql.105).aspx.Google Scholar
- http://msdn.microsoft.com/en-us/library/ms190787.aspx.Google Scholar
- http://technet.microsoft.com/en-us/library/aa224727(v(sql.80).aspx.Google Scholar
- Rainardi: "Building a Data Warehouse. With Examples in SQL Server", pp. 122, 125, 126. Google Scholar
- http://msdn.microsoft.com/en-us/library/ms189275.aspx.Google Scholar
- CreateStageArea.sql.Google Scholar
- http://technet.microsoft.com/en-us/library/ms190257(v(sql.105).aspx.Google Scholar
- http://msdn.microsoft.com/en-us/library/bb522469.aspx.Google Scholar
- http://www.inmoncif.com/registration/whitepapers/ttmeta-1.pdf.Google Scholar
- Alex Berson & Larry Dubov: "Master Data Management and Data Governance, Second Edition", p. 5.Google Scholar
- Joy Mundy and Warren Thornthwaite: "The Microsoft Data Warehouse Toolkit, Second Edition," pp. 165, 165f. Google Scholar
- http://searchdatamanagement.techtarget.com/definition/data-management.Google Scholar
- DAMA International: "DAMA-DMBOK Guide: The Data Guide to the Data Management Body of Knowledge," p. 4f. Google Scholar
- Duane Nickull: "A Modeling Methodology to Harmonize Disparate Data Models".Google Scholar
- Jeremy Kashel, Tim Kent, Martyn Bullerwell: "Microsoft SQL Server 2008 R2 Master Data Services," pp. 8, 13ff, 34, 37, 38f, 40f, 42, 37f, 126f, 132, 141, 94, 104, 104f. Google Scholar
- http://code7700.com/thrust_v_power.htmlGoogle Scholar
- Alex Berson & Larry Dubov: "Master Data Management and Data Governance, Second Edition", p. 7ff.Google Scholar
- Reeves, Laura L.: "A Manager's Guide to Data Warehousing", pp. 241-242. Google Scholar
- http://www.transtats.bts.gov/homedrillchart.aspGoogle Scholar
- Paul E. McMahon: "Integrating CMMI and Agile Development," pp. 60f, 61f. Google Scholar
- Mary Beth Chrissis, et al. "CMMI for Development," p. 133.Google Scholar
- Tyler Graham: "Microsoft SQL Server 2012: Master Data Services," Second Edition, pp. 71, 98, 115, 326ff, 327. Google Scholar
- http://msdn.microsoft.com/en-us/library/ff486954.aspx.Google Scholar
- http://msdn.microsoft.com/en-us/library/ff487062.aspx.Google Scholar
- http://msdn.microsoft.com/en-us/library/ff487016.aspx.Google Scholar
- http://msdn.microsoft.com/en-us/library/ee633854.aspx.Google Scholar
- http://msdn.microsoft.com/en-us/library/hh231028.aspx.Google Scholar
- http://msdn.microsoft.com/en-us/library/ff487013.aspx.Google Scholar
- https://msdn.microsoft.com/en-us/library/gg471534.aspx.Google Scholar
- W. H. Inmon, et al. "Corporate Information Factory," second edition, p. 169, 169f. Google Scholar
- Ralph Kimball and Jose Caserta: "The Data Warehouse ETL Toolkit," pp. 124ff, 352, 357, 359, 360ff, 362, 364ff, 367ff, 376, 379.Google Scholar
- http://www.merriam-webster.com/dictionary/volumetricGoogle Scholar
- Claudia Imhoff, et al. "Mastering Data Warehouse Design," p. 15.Google Scholar
- https://sqlmetadata.codeplex.com/Google Scholar
- https://sqlmetadata.codeplex.com/documentationGoogle Scholar
- David Marco, Michael Jennings: "Universal Meta Data Models", pp. 124ff, 134ff. Google Scholar
- Barbara von Halle: "Business Rules Applied," pp. 34, 436, 446.Google Scholar
- http://agilemodeling.com/artifacts/businessRule.htmGoogle Scholar
- David Marco, Michael Jennings: "Universal Meta Data Models", pp. 125, 126. Google Scholar
- Jennifer Stapleton: "DSDM: Business Focused Development," p. 197ff.Google Scholar
- Kimmo Palletvuori: "Security of Data Warehousing Server," TKK T-110.5290 Seminar on Network Security.Google Scholar
- http://web.stanford.edu/group/security/securecomputing/dataclass_chart.htmlGoogle Scholar
- Bharat Bhargava: "Security in Data Warehousing".Google Scholar
- Brian Knight, et al. "Professional Microsoft SQL Server 2014 Integration Services," p. 622, 622f. Google Scholar
- Quest Software: "Spotlight on Oracle 7.6: Getting Started Guide," p. 33ff.Google Scholar
- http://labs.consol.de/lang/en/nagios/check_mssql_healthGoogle Scholar
- http://www.cse.wustl.edu/~jain/cse567-06/ftp/net_traffic_monitors2Google Scholar
- http://logicalread.solarwinds.com/sql-server-buffer-hit-cache-ratio/#.VJ6dOsANAGoogle Scholar
- http://msdn.microsoft.com/en-us/library/ms141744.aspxGoogle Scholar
- http://msdn.microsoft.com/en-us/library/ms140246.aspxGoogle Scholar
- http://msdn.microsoft.com/en-us/library/ms136010.aspxGoogle Scholar
- http://msdn.microsoft.com/en-us/library/ms141122(v(sql.120)Google Scholar
- http://msdn.microsoft.com/en-us/library/ms186984.aspxGoogle Scholar
- http://msdn.microsoft.com/en-us/library/ff878135.aspxGoogle Scholar
- http://msdn.microsoft.com/en-us/library/bg126473(v(vs.85).aspxGoogle Scholar
- http://msdn.microsoft.com/en-us/library/aa392902(v(vs.85).aspxGoogle Scholar
- http://msdn.microsoft.com/en-us/library/ms345163(v(sql.120).aspxGoogle Scholar
- http://dougbert.com/blog/post/Adding-the-error-column-name-to-an-error-output.aspxGoogle Scholar
- http://www.rita.dot.gov/bts/.Google Scholar
- http://www.dot.gov/.Google Scholar
- http://www.transtats.bts.gov/DatabaseInfo.asp?DB_ID=120.Google Scholar
- http://www.swiss.com/corporate/en/company/about-us/facts-and-figures.Google Scholar
- http://msdn.microsoft.com/en-us/library/ms177456.aspx.Google Scholar
- Daniel Linstedt: DV2.0 and Hash Keys: Hash Keys and Architecture Changes, pp. 1, 2, 9.Google Scholar
- http://www.b-eye-network.com/blogs/linstedt/archives/2014/08/data_vault_20_b.php.Google Scholar
- Michael Coles, Rodney Landrum: Expert SQL Server 2008 Encryption, p. 151. Google Scholar
- Network Working Group: The MD5 Message-Digest Algorithm, http://tools.ietf.org/pdf/rfc1321.pdf.Google Scholar
- Information Technology Laboratory, National Institute of Standards and Technology: Secure Hash Standard (SHS), http://csrc.nist.gov/publications/fips/fips180-4/fips-180-4.pdf.Google Scholar
- RSA Laboratories: "PKCS #1: RSA Cryptography Standard," http://www.emc.com/emc-plus/rsa-labs/pkcs/files/h11300-wp-pkcs-1v2-2-rsa-cryptography-standard.pdf.Google Scholar
- http://support.microsoft.com/kb/889768.Google Scholar
- http://www.apprendre-en-ligne.net/crypto/bibliotheque/feistel/index.html.Google Scholar
- Microsoft: SQL Server to SQL Server PDW Migration Guide (AU2), p. 14.Google Scholar
- http://csrc.nist.gov/groups/STM/cavp/documents/shs/shaval.htm.Google Scholar
- http://www.ecma-international.org/publications/files/ECMA-ST/Ecma-006.pdf.Google Scholar
- http://www.iso.org/iso/catalogue_detail?csnumber=40874.Google Scholar
- http://blogs.msdn.com/b/jeremykuhne/archive/2005/07/21/441247.aspx.Google Scholar
- http://docs.oracle.com/javase/specs/jvms/se7/html/jvms-4.html.Google Scholar
- https://hbase.apache.org/apidocs/org/apache/hadoop/hbase/util/ByteBufferUtils.html.Google Scholar
- Alastair Aitchison: "Beginning Spatial with SQL Server 2008," p. 93. Google Scholar
- Intel: Endianness White Paper, http://www.pascal-man.com/navigation/faq-java-browser/jython/endian.pdfGoogle Scholar
- Marc Stevens: Single-block collision attack on MD5, http://marc-stevens.nl/research/md5-1block-collision/md5-1block-collision.pdf.Google Scholar
- http://preshing.com/20110504/hash-collision-probabilities/.Google Scholar
- http://technet.microsoft.com/en-us/library/ms190969%28v=sql.105%29.aspx.Google Scholar
- Frederick P. Brooks Jr.: "The Mythical Man-Month: Essays on Software Engineering, Anniversary Edition (2nd Edition)", p. 179. Google Scholar
- http://ssismhash.codeplex.com/.Google Scholar
- Ralph Kimball, Joe Caserta: The Data Warehouse ETL Toolkit, p. 353f.Google Scholar
- Brian Knight, et al.: Professional Microsoft SQL Server 2014 Integration Services, pp. 101ff, 105ff, 110, 104f. Google Scholar
- https://ssisctc.codeplex.com/.Google Scholar
- http://microsoft-ssis.blogspot.de/2012/01/custom-ssis-component-foreach-sorted.html.Google Scholar
- http://www.cdata.com/drivers/google/ado/.Google Scholar
- http://www.cdata.com/drivers/gsheets/ssis/.Google Scholar
- http://cdn.CData.com/help/RL1/rssis/RSBGSheets_p_DetectDataTypes.htm.Google Scholar
- Date C. An introduction to database systems. 7th ed. Reading, Menlo Park, New York: Addison-Wesley-Longman; 2000. Google Scholar
- Bertrand A. Use caution with SQL Server's MERGE statement, 2013, MSSQLTips.com website, available from http://www.mssqltips.com/sqlservertip/3074/use-caution-with-sql-servers-merge-statement/.Google Scholar
- David Loshin: "The Practitioner's Guide to Data Quality Improvement," pp. 4-6, 6f, 314, 314f, 270, 294f. Google Scholar
- Thomas C. Redman: "Data Quality for the Information Age", pp. 6f, 7ff, 8f, 9f, 10, 11, 22f. Google Scholar
- Larry P. English: "Information Quality Applied," pp. 251ff, 329, 332, 338, 345ff, 348ff, 351ff, 353, 356ff.Google Scholar
- Fisher et al. "Introduction to Information Quality," pp. 236f, 238f. Google Scholar
- Scott Ambler: "Refactoring Databases," p. 24f.Google Scholar
- Larry P. English: "Improving Data Warehouse and Business Information Quality," pp. 252, 260f, 261, 262, 267f, 274, 257ff. Google Scholar
- "DAMA Guide to the Data Management Body of Knowledge," pp. 305, 311.Google Scholar
- CDC Immunization Information Systems (IIS): "Deduplication Toolkit," retrieved from http://www.cdc.gov/vaccines/programs/iis/technical-guidance/deduplication.html.Google Scholar
- Leonard et al. "SQL Server 2012 Integration Services Design Patterns," p. 103f. Google Scholar
- "DAMA Guide to the Data Management Body of Knowledge," p. 310.Google Scholar
- https://msdn.microsoft.com/en-us/library/ms190768.aspx.Google Scholar
- U.S. Diplomatic Mission to Germany (website), 2015, "About the USA", available at http://usa.usembassy.de/travel-regions.htm.Google Scholar
- Microsoft, Microsoft Association Algorithm Technical Reference, 2015, available at https://msdn.microsoft.com/en-us/library/cc280428.aspx.Google Scholar
- Judith R. Davis, Robert Eve: "Data Virtualization," p. 47ff.Google Scholar
- Joy Mundy and Warren Thornthwaite: The Microsoft Data Warehouse Toolkit, Second Edition, pp. 245, 247, 247ff. Google Scholar
- https://msdn.microsoft.com/en-us/library/hh212940.aspx.Google Scholar
- https://msdn.microsoft.com/en-us/library/ms187597.aspx.Google Scholar
- https://msdn.microsoft.com/en-us/library/ms186995.aspx.Google Scholar
- https://msdn.microsoft.com/en-us/library/ms178681.aspx.Google Scholar
- https://msdn.microsoft.com/en-us/library/ms175662.aspx.Google Scholar
- https://msdn.microsoft.com/en-us/library/ms187975.aspx.Google Scholar
Cited By
- Giebler C, Gröger C, Hoos E, Schwarz H and Mitschang B Modeling Data Lakes with Data Vault: Practical Experiences, Assessment, and Lessons Learned Conceptual Modeling, (63-77)
- Gutenschwager K, Theile M, Wilhelm B and Rabe M Comparison of approaches to encrypt data for supply chain simulation applications in cloud environments Proceedings of the 2018 Winter Simulation Conference, (3084-3095)
Jussila J, Lehtonen T, Laitinen J, Makkonen M and Frank L Visualising maritime vessel open data for better situational awareness in ice conditions Proceedings of the 22nd International Academic Mindtrek Conference, (92-99)- Nogueira I, Romdhane M and Darmont J Modeling Data Lake Metadata with a Data Vault Proceedings of the 22nd International Database Engineering & Applications Symposium, (253-261)