Talk:Very large database/Notes: Difference between revisions

Revision as of 08:13, 5 October 2018

Latest revision as of 17:27, 12 October 2018

(11 intermediate revisions by the same user not shown)

Line 2:

== Potentially usable references ==

* [https://web.archive.org/web/20080529020704/http://www.computerworld.com/action/article.do?command=viewArticleBasic&taxonomyName=databases&articleId=9087918&taxonomyId=53&intsrc=kc_feat May 2008 Computer weekly about largest databases at the time] 06:36, 4 October 2018 (UTC)

Line 9 ⟶ 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 ==

There is some content to be added to the article. Some are waiting simply to link cites in the references above in a suitable manner.

===Performance===

* Performance issues in VLDBs will also be applicable and solutions will useful for sub-VLDBs, but for VLDB the issues are more pronounced.

===Objects===

* In a typically VLDB only a small proportion of the objects are likely to contribute to the VLDB. In in content store database these may relate to documents store in or without the database. Sometimes they will relate to transactional tables like a Bank online system where there will be a large number of financial transactions (that can be archived and retained after a suitable period of months). ''(currently not references covering)''