How to design a database in the absence of clear categories?

Question

Database design

If there is a certain set of data, then it can be cataloged somehow, and if there are none? Is there some kind of dynamic database design technique? Or, for example, you need to create a news site, but there is no set of some stories and the news itself - how to design a site so that later restrictions do not affect scalability and performance?

Answer 1

Try to dig towards cataloging with tags

Answer 2

EAV model or no sql alternative

Answer 3

try drawing a UML diagram of the project first. Often this solves many issues.
P.s. The news itself on my site has three categories: headline, preview (displayed in the general list of news, often it’s just the first paragraph of the news itself, but sometimes it’s a summary of what it’s about), and the third one is the full text of the news. Sometimes even in HTML format, if the news has a complex structure. In the database, a record consists of five fields: id, type, header, preview, view.
type is the type to which category the news belongs. Now I'm thinking of changing it to a set of tags.
You may have a different database structure, but this is all solved using UML

Answer 4

Design the database as a catalog of metadata, which you will then use to "assemble" objects. This allows you to type and extend types as you work. But there is one significant BUT, it will work slower.