DZone published [April, 20, 2020] The business applications have requirements: take customer orders, deliver customer orders, track shipping, generate inventory report, end of the day/month/quarter business report, generate business dashboards, and more. These requirements evolve slowly. They remain even when you choose a NoSQL database. On NoSQL databases, challenges are addressed by a multitude of technologies and workarounds. Here are some of them: Copying the data with a different key to make the scans easier. Fetch all of the data needed to the application and then generate reports Load the data into relational databases to generate the report. Products provide workarounds with map-reduce views , APIs , etc. Finally, SQL itself has been unreasonably effective for both structured and semi-structured data. NoSQL databases like Couchbase , Cassandra , CosmosDB have extended SQL for JSON and wide-column data model. NoSQL has evolved...
A blog about all things data and data processing issues and interests. SQL, NoSQL, flexible schema, scale-up, scale-out, transactions, high availability.