All Questions
Tagged with database-design java
29
questions
0
votes
1
answer
372
views
Clarification on using timestamp without time zone and LocalDateTime in UTC-centric systems
I'm seeking clarification regarding the usage of timestamp without time zone in a database and its corresponding Java type, LocalDateTime. The current setup I'm working on involves servers and (...
user175557
0
votes
2
answers
691
views
Microservices - create post for logged in user
I am working on a small project with microservices architecture in Spring Boot. As to not make unnecessary calls to users-microservice, I have duplicated some necessary User data (id, name, summary, ...
- 1
1
vote
1
answer
182
views
Feature Store Design for input data like JSON, CSV and Excel
I need a design approach for a feature store which accepts input data in the forms of CSV, EXCEL, JSON etc.
The backend stack we support is Java, Spring boot and oracle DB.
Note :
Each file ...
- 113
15
votes
4
answers
3k
views
Should entities contain information about their amount?
Can I get some thoughts on the entity design?
Let's say I have an entity called Book. Let's say I create a specific instance of that book. It has a title A and an author B. Since there can be multiple ...
- 169
2
votes
1
answer
994
views
Best approach to handle user statuses and keep their history
I am developing a Spring application which has a few different modules. There will be a bunch of users added in the database.
I want to add a feature, which will allow me to track users' availability,...
- 149
1
vote
0
answers
110
views
Practice for modeling class - multiple container relationship
I have a class that could:
Have multiple types of containers
Have multiple types of implementations
and what I did to model so far is:
public interface ChildClass {
Container getContainer();
...
- 172
2
votes
1
answer
157
views
Better practice of workaround for implementing a type field in Java
We have a class in our company's main library as follows:
public class User {
private long id;
private UserType type;
// Getters, setters, constructors, etc.
}
and have several options ...
- 172
1
vote
2
answers
156
views
How to manage item locations in an inventory
I have to manage item locations and life cycle as a new requirement. I'm not familiar in warehousing/inventory/storage systems, so maybe my question is trivial.
The task:
We have original items that ...
- 147
1
vote
2
answers
6k
views
How to process huge amount of data with limited processing ressources? [closed]
I receive daily from an external source a very large amount of data (around 250GB with 260 million rows of fixed width text) distributed over 5 text files. I am writing a Java application that should ...
- 49
0
votes
2
answers
576
views
JSON in Database Schema Design
I'm working on a web application with constantly changing requirements. The relationships between entities in the database have mostly remained the same but the attributes of each entity type changes ...
- 186
2
votes
2
answers
2k
views
Ways to store objects, inherited from one superclass in a database
For my personal project I need to store 2D shapes in a Postgres database. For example Circle, Pentagon, Rectangle and so on. At first I've done it like so: all shapes are inherited from an abstract ...
- 133
-1
votes
2
answers
242
views
Hierarchy in ER and OO Model
So, it might be a very fundamental question, but I'm pretty confusing right now...
It's all about Element and ElementCategory: an element belongs to a category, a categoty can have many elements - a ...
- 55
1
vote
1
answer
4k
views
Class Design for JPA Entities with Multiple Tables Referring to Same Business Object
I have an application that works with products from various external data sources (in DataSourceProduct) and it also maintains its own version of the product (in MasterProduct). Here's the DB schema:
...
- 285
1
vote
2
answers
179
views
Performance: One table vs multiple tables (generated programatically) for the same logical entity?
I want to ask for any suggestions for an architecture I can implement for a Java app I need to create (initial thoughts below).
It is supposed to be a local Swing application for tracking financial ...
- 121
4
votes
1
answer
10k
views
What is the best way to store a formula in a database for a table driven formula? [closed]
So I am changing my code over to a table driven formula system to make it sustainable in the long term.
So basically I have 5 foreign keys that will get me to a single formula to use. However I'm ...
- 151