Optimal Scale-Up and Scale-Out for MySQL, NoSQL, and Memcached
Schooner, White Paper. DOWNLOAD (PDF)
Category: NewSQL, XML, RDF Data Stores, RDBMS
DB2 Best Practices papers (for Linux, Unix, and Windows)
These Best Practice papers present advice on the most optimal ways you can use DB2. LINK
Benchmarking XML Databases: New TPoX Benchmark Results Available
Abstract: TPoX stands for “Transaction Processing over XML” and is an XML database benchmark that Intel and IBM developed several years ago and then released as open source. A couple of months ago, the...
Data Modeling: From Conceptual Model to DBMS
Sparx Systems. This paper explains how to do conceptual modeling for relational databases using UML. DOWNLOAD (PDF)
Web Data Management
by Serge Abiteboul, Ioana Manolescu, Philippe Rigaux, Marie-Christine Rousset, Pierre Senellart; Published by Cambridge University Press 2011. For personal use only, not for distribution. The present site aims to provide a consistent material to...
CA Erwin Data Modeler`s Role in the Relational Cloud
Nuccio Piscopo. The paper introduces CA Erwin Data Modeler and how it can be used with the Cloud. DOWNLOAD (PDF)
The Short Guide to MySQL HA Options
Schooner Information Technology. > An analysis of today’s MySQL high-availability challenges and what asynchronous, semi-synchronous and fully synchronous replication offer toward reducing downtime, achieving full data consistency, automating failover, and simplifying administration. DOWNLOAD (PDF)
State of MariaDB, Dynamic Column in MariaDB
Michael (Monty) Widenious, MariaDB Describes MariaDB 5.1 a branch of MySQL 5.1. It also introduces the new features in versions 5.2(beta) and 5.3 (alpha). Copy of the presentation given at ICOODB Frankfurt 2010. DOWNLOAD...
Improving Data Quality Through Data Modeling
William McKnight. The paper explains the causes of poor data quality and how it can be improved using data modeling. DOWNLOAD (PDF)