I have one problem regarding to develop a database design?

Harish Batchu

I need to save the documents like pdf, words, image files in database related to one particular user. But here i don't no how many columes i need to create.

Here i will give one example:

I have leased documents of one land. I need to store into database. I scanned one document i.e one document have several page right. Here i got a problem because i create fixed columes in database. if any person having more files what i created in database.

What should i do?

Give me solution for that.

ASAP

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke8y ago
Accepted answer
If you do plan to store and document in the database, then you really don't have to worry about pages. The ENTIRE document file goes into the varbinary column of the tables.

If you are having problem maintaining several documents for each user, you will need to implement one to many relationship.

For example:

User Table: UserID (primary key column), UserName, ....[other columns]

Document Table: DocumentID (primary key column), UserID (foreign key column), DocumentDescription, ....[other columns]

This way you can have multiple documents next to each user Id. Hope you get the point.
Jaish Mathews8y ago
If you are using RDBMS, then get out of this solution as you will face lot of scalability issues during many phases of SDLC and even after deployment. Always use document database solutions. If you really need to use RDBMS, don't store inside database, but store in a file system and then add Ref. text only inside RDBMS.