All Questions
34
questions
0
votes
1
answer
94
views
Do transactions happen only in SQL database in Spring Boot projects?
I'm learning about SQL and NoSQL databases in Spring Boot projects. And I have a question about transactions in databases. I know that when you use @Transactional at a method, all the queries from ...
0
votes
1
answer
84
views
Data modelling - Nested object vs Separate DB Table
I'm designing Sticky notes Management Application (CRUD), where StickyNote has 3 attributes, heading, summary and task list. The task has 2 attributes - heading and summary.
A sticky note can have ...
0
votes
0
answers
238
views
How to retrieve jsonb data from db using spring jpa?
When interacting directly with a sql db (that contain a jsonb column), the query required is:
SELECT stuff FROM alerts WHERE id = '12345'
AND (stuff->'action'->>'actionId' = '123')
ORDER BY (...
0
votes
1
answer
343
views
dynamodb composite primary key design with multiple attributes
I am trying to design a dynamodb table to store data, in which multiple attributes constitutes as unique key. In this case how do I design a DynamoDBHashKey/primary key?
Currently I am thinking of ...
1
vote
1
answer
682
views
N1QL query in Java with WHERE and LIKE and underscore
I am trying to query all documents with id matching my key, ex: example_key_123
Statement statement = select("META().id").from(i("bucketname")).where(x("META().id").like(...
0
votes
1
answer
561
views
Realization of BFS in relational databases
I need to use a structure of ternary tree which has to be stored somewhere (I chose relational DB, but I still can change it).
My DB tree looks like:
For example my relation contains columns - Id, ...
0
votes
0
answers
49
views
NOSQL Performance and scalability
I am came across this article and found out overall the performance for NOSQL still slower than conventional SQL as per URL below.
http://tiborsimko.org/postgresql-mongodb-json-select-speed.html
I ...
-1
votes
1
answer
383
views
how can i do this query on dynamoDB + Android
I've got a DynamoDB table containing 'n' Book title in only one dynamoDB Item (and this freak me out)
in this structure, rentBook is the table on dynamoDB, with 2 attributes:
String StudentID
...
0
votes
1
answer
60
views
Mysql database to Nosql hbase using java
I want to convert this relation-ship "1 to many" Employees can have 0 or many Orders to Nosql hbase
0
votes
1
answer
120
views
Crate Common Crawl Example not working
I am trying to use this example of Crate with Common Crawl: https://github.com/crate/crate-commoncrawl
I have setup the Crate and even created the table schema using the instructions from the example.
...
5
votes
2
answers
985
views
orientdb: passing an Array to a query using 'IN' on an OType.LINKLIST field
I'm trying to pass an array of Category POJOs to the query using IN in the SQL:
public ShareObject[] search(String name, Category[] categories) {
...
OSQLSynchQuery<ODocument> query = new ...
5
votes
2
answers
20k
views
Recommendation for a Java in memory database [closed]
Looking for a recommendation. I have a command line utility that now needs to process a large amount of data coming from a web service in a form of a CSV.
I need to run multiple tests on the data to ...
-2
votes
3
answers
68
views
Advice required on choosing SQL or NoSQL framework for searching / persisting [closed]
We are trying to build to backend for a Job Portal for which we are building android and iPhone clients.
Here is a basic field which needs to be persisted/searchable.
User meta data and their ...
1
vote
1
answer
2k
views
Using an MD5 Hash as an index
I am writing a MongoDB Collection that contains a specific set of data, and I want to run comparisons against that data by taking an MD5 (or maybe SHA256) hash of the data and basing comparisons off ...
0
votes
1
answer
598
views
The sum of all clustering columns is too long (65927 > 65535)
While inserting to Cassandra db this error comes,I am inserting very huge data to the database,Is this error because of memory,i have enough disk space, as i know the row in the data base can hold ...