What is the best way to optimize a database with millions of records and hundreds of simultaneous queries?
The database holds 2 significant tables, in a one to many relationship (table1 has a column ...

Now I'm doing a normal topic and comment integrated app. Already carried out the functions like posting topic, posting comment, and setting the pointer of my comment to the Topic class.
But now the ...

I've question regarding how to store chat messages into ElasticSearch.
Our application stores chat interactions of different companies.
Main Class is ChatMessage which hold each separate line within ...

Explain with examples how the relational algebra operations(project , join and intersection) can be captured in datalog
Need help in this..exam up soon and no decent notes to go with it. I havent got ...

We have mariaDB with huge data in production.
We are going to implement Logstash with Elasticsearch in future instead of normal JAVA application to store and Index data. ELK is the NO-SQL DB.
We have ...

I have two tables in a database. One is the name of a provider (name, general info) the other is the type of provider. The provider can be more than one type. So in my provider database you can choose ...

If I have a table with say, a images field, I understand that it is better put images in a new table Images and link with a common ID so the number of images can expand.The rule seems to be that comma ...

I’m having a trouble with the design of a relational database.
I know how to design a relational database to store “resources”, I mean products, users, posts, comments, etc.
My problem is to design ...

I need some help with the JPA Framework.
I've read some answers "kind of" about this topic but I couldn't reach any conclusion.
First heres an examplo of the design i'm wooking with.
@BusinessObject
...

how do I show that something does increase the expressive power? For example I have given a problem in which I need to show that adding some certain function to the select-project-join queries of sql ...

as explained in previous posts I have a Postgresql relational database with about 10M rows. I would like to connect Neo4J directly to this existing database if it's possible and define the nodes as ...

I'm looking for some critical feedback on a relational database design I made for a project.
The database is needed for a 2nd year CS project at my school but we have not yet had any teachings on this ...

I have a relational database with two tables, properties and tenants. When I add a new property, I do not have a tenant, so the tenant table has no entry for that property. When I attempt to search ...

I was wondering what the best way to store non-relational metadata is in a MySQL database would be? The data won't be queried, so no indexes need to be applied to the data.
Here is the first example ...

I want to add a new column to an already existing table, but I want to give it a default value dependent on already existing data:
e.g. Each record has a start_date. Now I want to add an "open_until" ...

I'm learning SQL, so help is greatly appreciated.
I have three tables: league, player and team
league and player is many to many (as a player can be in more than one league)
team and player is many ...