Talk:Very large database/Notes: Difference between revisions

Revision as of 21:10, 7 October 2018

Latest revision as of 17:27, 12 October 2018

(4 intermediate revisions by the same user not shown)

Line 8:

*:: Ths actually arose from [https://web.archive.org/web/20171125204916/http://sqlturbo.com/presentation-best-practices-for-sql-server-very-large-databases-vldbs/ a presentation]

* [http://www.dba-oracle.com/t_best_practices_oracle_scaling_vldb.htm Don may have assumed database growth implies more users accessing it ... which may not be always true ... That said bigger Data warehouse more access required]

* BC-BackVLDBtips: [http://www.dba-oracle.com/t_backup_vldb.htm simple useful vldb and backup ref from Don ... ... ]

* [https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html mysql 8.0 merge engine for vldb]

* [https://blogs.msdn.microsoft.com/sqlcat/2018/01/22/sql-server-vldb-in-azure-dba-tasks-made-simple/ jan 2018:: reviewed sqlserver blog ... vldb kicking in at 3TB to 5TB]

* Widlake: [https://mwidlake.wordpress.com/2009/09/18/what-is-a-vldb/ ..a blog but some interesting pointers]

* RedBrick1996: [https://web.archive.org/web/19971010114605/http://www.redbrick.com/rbs-g/whitepapers/tenreq_wp.html Redbrick.com - 1996 - referenced by Connolly/Begg ... does not mention VLDB but indicates VLDB problems well below 1TB]

* ISACA-BKBP: [https://web.archive.org/web/20180629131442/https://www.isaca.org/Journal/archives/2012/Volume-1/Pages/Database-Backup-and-Recovery-Best-Practices.aspx ISCA Oracle/MSSQL2017 specifics on VLDB backup]

* [https://web.archive.org/web/20180903055442/https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-and-restore-of-sql-server-databases?view=sql-server-2017 MSSQL2017 backup recovery and availability]

* MYSQL-HA-SCALE: [https://web.archive.org/web/20161215030829/https://dev.mysql.com/doc/mysql-ha-scalability/en/ha-overview.html MySQL HA and Scalability]

* CERN-ORA-PART: [https://web.archive.org/web/20181012172456/https://indico.cern.ch/event/697301/attachments/1598206/2532649/Partitioning_guide_v18.pdf Oracle Partitioning Presentation to Cern ?? Very comprehensive]

== Content to be added to Article ==