S
S
stanik2017-03-21 09:57:10
MySQL
stanik, 2017-03-21 09:57:10

How to store the text of abstracts in the database?

Hello.
There is a task to design a DB for documents. Let it be abstracts.
In the database, in addition to the title, description, category ID, author ID, you also need to store the abstract itself.
The question, in fact, is - where to store the abstract? Or add a TEXT field for it in the main table, or create a separate table in which to store the abstract ID and its text?
In the first case (the text in the main table), will there be any volumes in the selection for category pages (it is clear that the TEXT field will not participate in the SELECT selection)?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey Nikolaev, 2017-03-21
@gromdron

I would suggest the following solution: in the table we store the meta-data, the text of the abstract and the path to the file where the abstract is located. You can parse docx, doc, odt and other documents using console utilities.
Why? Everything is simple - the abstract can contain pictures, diagrams, formulas, etc.
If you store everything in the database, then you will either need to refuse this (and store only text without formatting), or blobs

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question