background preloader

Databases

Facebook Twitter

Ispirer - Home.

MySQL

Migrating data. Introduction Migrating or moving data is a common task. Whether it is copying data across the network to a new filesystem, or copying logical volumes within the same volume group or to a different volume group or maybe just creating a backup of a filesystem. The reasons for moving or copying data could be for performance issues, or general growth of data where there is not enough space in its current environment. There are different tools that can be used for the above-mentioned data movement tasks, such as migratepv, cplv, tar, cpio, cp or rsync.

For jfs, you can use splitcopy or, for jfs2, use snapshot to take a copy of a filesystem. There is no golden rule on what method would best suit a certain data movement. Back to top Using tar and cp to copy data to a new filesystem When applying updates to an application filesystem, a backup would be taken first, most probably to tape. . # df -g … /dev/fslv00 1.00 0.03 97% 22 1% /opt/pluto First, the backup (copied) filesystem needs to be created.

Other DBMS

Is the Relational Database Doomed? Recently, a lot of new non-relational databases have cropped up both inside and outside the cloud. One key message this sends is, "if you want vast, on-demand scalability, you need a non-relational database". If that is true, then is this a sign that the once mighty relational database finally has a chink in its armor? Is this a sign that relational databases have had their day and will decline over time? In this post, we'll look at the current trend of moving away from relational databases in certain situations and what this means for the future of the relational database. Relational databases have been around for over 30 years. First, Some Background A relational database is essentially a group of tables (entities). Relational databases are facilitated through Relational Database Management Systems (RDBMS). The reasons for the dominance of relational databases are not trivial.

However, to offer all of this, relational databases have to be incredibly complex internally. The New Breed. Migrating data.

DB2

Data Governance.