Skip to main content
11 votes

Prevent analytics from crashing the production database

I will start with the simplest solution, per amon's comment - create a read replica - if you are hosting your database in a cloud provider, this is typically just a few clicks or a few changes to your ...
DavidT's user avatar
  • 3,358
9 votes

Prevent analytics from crashing the production database

The usual practice is to make a distinction between OLTP for day-to-day transaction processing, where users need high speed response time, and OLAP for in-depth analytics (dashboards and other ...
Christophe's user avatar
  • 78.4k
6 votes

Object-oriented programming design with relational database tables

(Note: The question had been substantially re-written after this answer was posted. The original question seemed to be more about using OO to design a relational database, so this answer is focused ...
Ben Cottrell's user avatar
  • 11.9k
5 votes

Mixing up UML and non-UML diagrams

Design documentation is meant for people. Machines don't care. People care because these documents help them build the system or maintain it. Worse case scenario, the documents are a box-ticking ...
Greg Burghardt's user avatar
4 votes

Mixing up UML and non-UML diagrams

Diagrams are only tools to express ideas, and you should always use tools that best suit your needs. Some modeling languages, such as C4 even explicitly foresee a mix of diagrams, with high level ...
Christophe's user avatar
  • 78.4k
4 votes

Mixing up UML and non-UML diagrams

Someone did a survey : A survey on the practical use of UML for different software architecture viewpoints While the top popular viewpoints for the UML-based software architecture modeling are the ...
Ewan's user avatar
  • 77k
3 votes

Designing a database schema for a website related to my town's history

You should consider using an existing content management system instead of basically rolling your own. Most have functionality for managing media, including analysis and maybe indexing of metadata.
Hans-Martin Mosner's user avatar
3 votes
Accepted

Designing a database schema for a website related to my town's history

I would do away with the database altogether and think of a way to store the image metadata in either EXIF or XMP data alongside or inside the image itself. For searching through the images, I would ...
RibaldEddie's user avatar
  • 3,283
3 votes

how to deal with schema/constraint changes in insert-only Relational DBs?

The historical insert only table should only have 1 constraint, and that is to the primary key of the record that it is keeping tracking of. No other constraints/FKs should exist, even though they ...
Jon Raynor's user avatar
  • 11.6k
2 votes

Does it make sense to use a graph database (Neo4j) for a diagramming app?

If your diagrams somehow represent graphs (nodes and edges) there is indeed a natural match for the mapping of your database. Graph database also offer flexibility when you need to associate more ...
Christophe's user avatar
  • 78.4k
2 votes

Table referential integrity varying according to application logic

You are on the right track with copying the data when the dispatch happen. For keeping the copy I see two viable alternatives. Obviously, you need an intermediate table shipment_line_item for all ...
Doc Brown's user avatar
  • 209k
2 votes

how to deal with schema/constraint changes in insert-only Relational DBs?

The purpose of a schema in an RBDMS is to ensure data structure integrity. If you want to have a changing-over-time structure for your data you either need a technology that allows loose data ...
ArwynFr's user avatar
  • 167
1 vote

Prevent analytics from crashing the production database

I don't disagree with the prior answers, however, I would not start there. I would do some analysis and tracking of the overall performance of the system. Since the OP indicates that the load on the ...
cse's user avatar
  • 11
1 vote

Table referential integrity varying according to application logic

There are some sensible options: Records in table y needs to be immutable; however, of course, they also need to be updateable.  So, you need versioning of records in table y of some sort.  Old table ...
Erik Eidt's user avatar
  • 34.2k
1 vote
Accepted

What is the best practice for hierarchical container - item relationship in a SQL database?

What is the best practice for hierarchical container? You have already described it with suggested schema and query. This is a standard setup, and you have it exactly right. actual issue ... while ...
J_H's user avatar
  • 7,338

Only top scored, non community-wiki answers of a minimum length are eligible