Database System Development Life Cycle (DSDCL) is a method in database development. While the database language used to modify and retrieve data in a database is Data Manilation Language (DML). The DML that is often used is Structured Query Language (SQL) which is used to search and manipulate data in relational databases. SQL consists of simple syntax in the form of commands to manipulate data, these commands are called queries. The query language is used in implementing the Library System database using SQL Server 2008 RDBMS. The first step before performing DML using the query editor, must have a database and data that has been implemented with SQL Server 2008. In this discussion, only 4 (four) DML statements are explained. namely select, insert, update and delete by using the Library System database with SQL Server 2008 RDBMS. The select statement is used to display data from a table (1 or more) in the database. Update is used to make changes to data in tables in the database. Insert is used to fill in data and delete is used to delete data in tables in the database.

Database System Development Life Cycle (DSDLC) on System Libraries for Data Manipulation Language (DML) Using SQL Server 2008

Cassandra is a NoSQL database having a peer-to-peer, ring-type architecture. Cassandra offers fault-tolerance, data replication for higher availability as well as ensures no single point of failure. Given that Cassandra is a NoSQL database, it is evident that it lacks research that has gone into comparatively older and more widely and broadly used SQL databases. Cassandra’s growing popularity in recent times gives rise to the need to address any security-related or recovery-related concerns associated with its usage. This review paper discusses Cassandra’s existing deletion mechanism and presents some identified issues related to backup and recovery in the Cassandra database. Further, failure detection and handling of failures such as node failure or data center failure have been explored in the paper. In addition, several possible solutions to address backup and recovery, including recovery in case of disasters, have been reviewed.

/pdf/backup-and-recovery-mechanisms-of-cassandra-database-a-16ctbrplxa.pdf

Karina Bohora

Papers

Backup and Recovery Mechanisms of Cassandra Database: A Review