All Questions
Tagged with data-modeling database
19 questions
-1
votes
1
answer
213
views
Modeling a CSV file: What is the standard? Python or SQL?
I have a wide CSV file of about 350mb, and want to load it into a SQL database and properly model the data to make it easier to use for analysis.
I could split the data into tables with python and ...
- 111
3
votes
2
answers
427
views
What to do when putting logic into the database seems to be the only option?
I am currently working on an application that models a complex business process that consists of many steps, each having a 1:n relationship with subsequent steps. The software is written Java using ...
- 149
1
vote
1
answer
4k
views
SQL Database schema for Catering/Menu management
Background
I'm building a Private Chef booking service where you can book a Chef to cook you a custom Menu. I'm having trouble creating a SQL db schema that accurately represents the domain while ...
- 111
3
votes
2
answers
873
views
Is Excel data model as good as or better than Microsoft Access?
I'm working with several Excel worksheets and workbooks that need to consolidated or linked to each other. These workbooks will track client interactions for different team members.
I did the initial ...
- 51
-1
votes
2
answers
355
views
Correct place to store semi dynamic data
What I mean by semi dynamic data are data that are expected to be changed only with product versions.
Now imagine this scenario, In version 1 of the product, I have item status : SUCCESS , FAIL
In ...
- 241
-1
votes
2
answers
2k
views
When self-referencing in a table, do you prefer `parent_id = null` or `parent_id = id` for a row referencing to itself?
For the discussion, I will provide my example. But I am interested in the broad guidelines.
I save in my postgres DB legislation (law texts) composed of a single header (H), paragraphs (P), sub-...
- 155
2
votes
2
answers
1k
views
Index / Unique on `deleted_at` column?
We have an Accounts table in a Postgres DB that has a unique index on user_id and product. Users can have many accounts, there's no product table. Occasionally users will create an account ...
- 129
2
votes
1
answer
148
views
How to model rdbms relationships as graph relationships?
I am modeling our existing database in transition to a graph database.
Currently here is how I can interpret the database a graph relationships
group -have-> groups
group -have-> participants
...
- 123
2
votes
1
answer
2k
views
Proper modeling and name convention for an intermediate table between intermediates
I have 4 entities: Event, Message, Flow and Document.
Event table stores a limited (seeded) number of records. Message has many events and each event can be related to many messages. The name ...
1
vote
2
answers
125
views
Database Modeling Question
I am having a doubt while creating a DB, and I would like to know if there are objective arguments that could help me mak a better decision.
Case
A project that can have several revisions, so I ...
- 119
0
votes
2
answers
273
views
Is it acceptable to break MVC by storing data in the DOM in order to reduce load on the Database Server, ever?
I am currently using NodeJS & Express to load webpages which contain element content that is rendered via a query to MongoDB.
A GET request will create Button elements, binding the MongoDB _id ...
- 119
3
votes
2
answers
243
views
How to model relational data that can be organized in multiple ways? [closed]
I’m working in a project that is building a system to manage data (10-20 million records) collected by a research organization. One of the challenges is that even though the data is superficially ...
- 39
2
votes
1
answer
394
views
many to many relationships in ER Diagramme
Relational database management systems can’t have M:M relationships, so before converting a data model to a database in Access, SQL Server, mysql, or other relational DBMS, the data modeler must solve ...
- 406
2
votes
1
answer
505
views
Data modeling for NoSQL document database
Below are the common phases applied, for a real world requirement(data) map to DBMS specific schema.
Conceptual models ER/EER/CODASYL/Hierarchical bridge the gap, in mapping the real world data(...
- 2,305
0
votes
4
answers
3k
views
Efficient way to search data based on multiple attributes
We are building a system where we accumulate data from many of our internal services, process them and generate set of data called Jobs saved to database. Our client application running on client ...
- 127