Pages having BigData tag
Lock Escalation is to change row locks into table lock. This method is dangerous and not effective. That is because it makes dead lock. In addition to that, vacancy of lock occurs.
Huge Row Locks Occurs
Sometimes a lot of row locks are necessary, in order to execute application. That is inevitable to keep data consistency.
On handling big data, number of records depends on master table's one also becomes big.
Read "Avoid Lock Escalation by Disk Swap" more
NoSQL is to solve problem of non-distributed database. But by adding distributed functions, RDBMS(Relational Database Management System) can do same things.
Advantage of NoSQL
NoSQL databases are basically very simple. But recently, they have some great functions about distributed data management.
The advantage of NoSQL is weak points of RDBMS.
for BigData, ex Hadoop, do not supports UPDATE and DELETE operation in
SQL. In addition to no transaction support, it makes the structure
Read "NoSQL vs Distributed Relational Database" more
NewSQL is database management system which have more functions than RDBMS. It has distributed data management functions, that NoSQL is good at. Alinous Elastic DB is a kind of NewSQL.
Use Case of Bigdata
BigData is not simply huge data. That is high resolution data.
Data Acquisition Changes
Recently, IoT (Internet of Things) is a trending keyword. The IoT products generates a lot of data.
That is because the way to acquire data is changed by it. It takes a lot of detailed information as huge logs. As time passed, the data become bigger and bigger.
Read "NewSQL for OLTP & Bigdata" more