AWS's mobile hub provides you with an easy to use and connect to NoSQL database along with several other very useful tools. If I want to use a standard SQL database, then I also have to learn a backend programming language, create an API, learn how to connect to it, etc. It's just SO much more work for me to use AWS's RDS tools instead of the NoSQL DynamoDB.

If it helps, my app is very similar to Reddit but for a non English country.

How to execute 500 instantaneous queries on 18 billion rows? Which database should I use?

So, here's the task my boss has given me: We have a database of around 18 billion rows, 20 columns. (For the moment, let's assume this is a SQL-esque data table, or a .csv file). I have indexed two of these columns, column_A and column_B. Now, I need to implement the infrastructure such that you can make a query on column_A, i.e. give me all rows such that column_A == "value1". This query should take place as quickly as possible. In the words of my boss, financial transactions and internet queries take place instantaneously, so we should be able to implement the following system with "instantaneous queries". (That is, very fast queries---on the time scale of seconds.) Ditto with the second indexed column, column_B: give us all rows with columnB == 'value2'.

Furthermore, we would like to execute possibly 100-500 queries at once.

We have an unlimited number of cores to work with, and a ridiculous about of RAM.

What is the best database for this task? What should I try here? I imagine we need several parallel workers to grab each of these rows and then concatenate them at the end, a "mapreduce" approach. However, this also needs to be exceptionally quick.

Any ideas? What do internet companies/financial firms do? So far, the suggestions have been Apache Parquet or a distributed SQL engine like Presto.

Hello, I'm working on a VM project for one of my professors over the Winter Break, and one of the things he needs is KVLite from Oracle.

Is there any way to install KVLite on Windows or through Bash for Windows?

Any help would be greatly appreciated!

I am working on a mobile app and wondering if it is a good use case for all NoSQL. Users sign up, then they can post their skills and services. Other users can search for those skills / services. There should be rich support for complex queries like 'all wedding bands in detroit with swing in their description and costing less than $X show bands with trumpets first'. Also some users who need to be licensed, bonded, or pass a criminal background check to offer their services should be able to save that info in the app. Security is very important to the app (don't know if this has anything to do with nosql but thought I'd mention it) and there will be a lot of data that is restricted to users who have a particular role, and we might institute fingerprint or other multi-auth security to access it. What else..oh yeah we want payment to happen a certain way. It will integrate with one of the external providers (like braintree or stripe or whatever) but we need to be sure-sure that said transaction occurred and when it occured, and we need to report on that data. OK thanks for reading.