Data Warehouse - sgml/signature GitHub Wiki
Data Quality
- https://kb.informatica.com/proddocs/Product%20Documentation/4/DE_90_PreparingDataGuide_en.pdf
- https://www.codeproject.com/Articles/1065295/SQL-Server-Table-and-Column-Naming-Conventions
- http://www.nyu.edu/classes/jcf/CSCI-GA.2433-001_sp15/slides/session4/PracticalRelationalDatabaseDesign.pdf
NoSQL
- http://ijariie.com/AdminUploadPdf/Study_of_NoSQL_Database_Along_With_Security_Comparison_ijariie8398.pdf
- https://www.digitalocean.com/community/tutorials/a-comparison-of-nosql-database-management-systems-and-models
- https://pages.awscloud.com/rs/112-TZM-766/images/Session2%20-%20QLDB_JPN_Focus_Week_Deep_Dive.pdf
Dynamo DB
- https://stackoverflow.com/questions/32620215/3-fields-composite-primary-key-unique-item-in-dynamodb
- https://pages.awscloud.com/rs/112-TZM-766/images/Purpose-built-databases.pdf
Redis
- https://masonoise.files.wordpress.com/2010/03/redis-cheatsheet-v1.pdf
- https://assets.digitalocean.com/books/how-to-manage-a-redis-database.pdf
Druid
- https://github.com/apache/druid/blob/master/docs/querying/searchquery.md
- https://druid.apache.org/faq
Tutorials
- https://www.codeproject.com/Articles/652108/Create-First-Data-WareHouse
- https://www.codeproject.com/Articles/5163401/Database-for-Financial-Accounting-Application-II
- https://help.gooddata.com/doc/en/building-on-gooddata-platform/data-preparation-and-distribution/data-preparation-and-distribution-pipeline/data-pipeline-reference/data-warehouse-reference/data-warehouse/database-schema-design/logical-schema-design-tables-and-views/primary-and-foreign-keys
- https://dataedo.com/tutorials/documenting-data-warehouse
- https://docs.oracle.com/database/121/DWHSG/concept.htm#DWHSG-GUID-452FBA23-6976-4590-AA41-1369647AD14D
References
- https://www.essentialsql.com/what-is-the-difference-between-a-primary-key-and-a-foreign-key/
- https://technet.microsoft.com/en-us/library/hh393512(v=sql.110).aspx
- https://dwbi1.wordpress.com/2012/08/01/initial-data-load/
- https://sigmodrecord.org/publications/sigmodRecord/0009/standards.pdf
- https://www.1keydata.com/datawarehousing/data-warehouse-architecture.html
- http://www.sarahmei.com/blog/2013/11/11/why-you-should-never-use-mongodb/
- http://blog.memsql.com/nosql/
- https://www.slideshare.net/AmazonWebServices/convert-and-migrate-your-nosql-database-or-data-warehouse-to-aws-may-2017-aws-online-tech-talks
- https://www.sciencedirect.com/science/article/pii/S1877050917300819
- https://www.service-architecture.com/articles/web-services/common_warehouse_meta-model_cwm.html https://opus.govst.edu/cgi/viewcontent.cgi?referer=&httpsredir=1&article=1180&context=capstones https://www.element61.be/en/resource/choice-between-tabular-or-multidimensional-models-sql-server-analysis-services-2012 http://graphdatamodeling.com/GraphDataModeling/History.html https://www.congruentsolutions.com/25-key-tools-in-apaches-15-years-history/ https://www.quickbase.com/articles/timeline-of-database-history https://www.geeksforgeeks.org/dbms-row-oriented-vs-column-oriented-data-stores/ https://en.wikibooks.org/wiki/The_Computer_Revolution/Databases/Database_Models https://codebots.com/data-management/types-of-databases-and-dbms-with-examples http://www.web-integration.info/en/blog/history-and-trends-in-the-development-of-databases/ https://www.cs.helsinki.fi/u/jilu/documents/Poly.pdf https://docs-iias.mybluemix.net/docs/content/SS6NHC/com.ibm.swg.im.dashdb.sql.ref.doc/doc/r0000927.html http://www.vldb.org/pvldb/vol6/p1080-barber.pdf https://www.ncbi.nlm.nih.gov/pmc/articles/PMC150357/ http://info.jethro.io/blog/database-architectures-business-intelligence-comparison https://parquet.apache.org/documentation/latest/ https://semanticommunity.info/Other/Big_Data_at_NIST