All Questions
Tagged with database-design data
25
questions
1
vote
1
answer
532
views
SQL Foreign Key Relationships and External Data
I work for a company that wants an external system built outside of their core system. I can't share an SQL database, and can't store data in their database. So I am forced to maintain my own SQL ...
- 127
2
votes
2
answers
1k
views
Storing unchangeable data in database vs in code
Hi I am trying to create a role based dynamic route authorization system on my NodeJS ExpressJS powered API server.
Scenario:
There will be some roles like Admin, StandardUser etc. and they can't be ...
1
vote
1
answer
56
views
Storage and partitioning in Cosmos DB
I'm working on designing a system for reporting/storing information on hardware devices (IoT-like), and trying to figure out how that would best be structured in Azure's Cosmos DB.
Every device will ...
- 4,638
2
votes
2
answers
3k
views
From Oracle to Apache Parquet : how to handle eventual consistency?
I have an existing production Oracle Database. However, there are performance issues for certain kind of operations, because of the volume of the data, or the complexity of queries.
That's why I ...
- 31
2
votes
1
answer
100
views
Techniques for handling large reporting periods in MSSQL
We have a fairly large database with some fairly large tables (100s of millions of rows). Some of those tables are reported on.
We have indexes in place to make this as fast as possible, but still ...
- 137
1
vote
2
answers
71
views
Architecture of "tags" for contacts in a marketing system and hard-coded IDs so functions can refer to them
I have these tables: contacts, tags, contact_tags.
(contact_tags has columns contact_id and tag_id.)
Administrators can manually create new tags via an internal website.
Administrators can also ...
- 157
0
votes
1
answer
638
views
Encoding of timestamps over cosmological time (64-bit linear vs 32-bit logarithmic)
I understand this is the place to ask questions pertaining to software design. If my question is considered to opinion-based, is there a forum or something better suited for the discussion?
...
- 119
-2
votes
2
answers
131
views
database/orm model design for contacts
I am building a internal crm which has contacts which are just people with first name, last name, email, phone etc. Contacts can be one or more types e.t.c. job candidates, hiring managers, customers, ...
- 109
8
votes
4
answers
1k
views
Database design for fields that should be NOT NULL eventually, but may not yet have a value
I have encountered this problem a number of times. Let's say you have a large object that you want to store in the database. Perhaps it's a dating profile for a user, and it has 100 fields. All of ...
- 189
38
votes
7
answers
14k
views
Modeling first and lastname separately
Which arguments should someone consider when designing a new system and has to either store the name of a person as one field or separately as first/last name?
Pros for single field:
Simpler UI
No ...
- 505
0
votes
1
answer
150
views
Apart from immutability, does blockchain offer any other advantages?
I am trying to understand the broader implications of blockchain apart from the main advantage of immutability. Are there any?
It seems like the distributed nature of the ledger can be an asset when ...
- 3,315
0
votes
2
answers
2k
views
How to store large amount of session data
Current project that i'm working has a requirement to capture data relevant to a session and store. Purpose of this is to use these data for the analytics. Clients would use these data to generate ...
- 153
2
votes
2
answers
915
views
What are the some common practices for storing and accessing data for analytics?
If you need to access application information from a database for analytics, is it better to copy the information first and analyse the copy or is it okay to analyse the data retrieved fresh from the ...
- 129
5
votes
4
answers
2k
views
When redesigning an application that uses Metric & English units for data, how do I store data in datatabase?
In my application users compute some engineering data (physical quantities like lengths, and weights).
Currently the core formulas work on and assume English system, but user can select English or ...
- 8,247
1
vote
2
answers
59
views
Modify existing column or link to what the change is?
I am making a game. In this game people can modify a value of an object. Let's picture it like so.
House is the object
price is the value
Mold is the modifier
Should I reflect changes to the price ...
- 1,898