nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

why a DMS?

ucf

Hello everybody,
I don't know if this is the right place to post this question or not but I'm working on an internship project where I used Alfresco, for my prsentation I need to know what's the problem with storing document in an ordinary relational database, and what's the benefit of using alfresco in terms of time and performance?
regards,

Find more posts tagged with

Comments

mrogers

Here's some pointers.

An ordinary relational database is concerned about the relationship between rows and columns of data.   That may involve storing the rows of data on disk in certain formats to enable efficient access and extensive indexes and clever algorithms to search for and join data together.      Also a database expends a lot of effort on the so called ACID properties.   And the primary interface to a RDBMS is SQL.    You can look up more details about the theoretical underpinnings of a RDBMS.

So great big chunks of text are not really what an RDBMS is about.   It makes little sense in trying to form a relationship between the text of one book and another.   So Rdbms tend to have blob objects and store content off on the side. They also may have restrictions on the data size.   Fine so far as it goes but the access to the content is via SQL so that can be a bottleneck especially if big volumes of data is being shifted.    Remember that SQL is supposed to be about tables of data so its not optimised for streaming content.

So there's another type of database nosql that may help in your content management mission.   You may like to consider that as well.

So the content management system like alfresco.   Presents the content over lots of different interfaces especially streaming.
Provides higher level functionality such as versioning, transformation, rules, workflow and search. search is a very different beast to SQL.
May provide a user interface.   Forms, actions,   Timers etc,etc.
May have records management functionality.
Will enable applications like Wcm or case management or digital asset management.

ucf

thank you Sir, it's been helpfull, but I want to know if there is any way to measure the time or cost won by optimizing the data straming time in the two cases in order to present some rigorous arguments with measurable parameters
regards

mrogers

Someone on these forums wrote an Oracle Store for alfresco. I asked for some benchmark comparisons but never saw answers.

ucf

thank you for your help,
if any one got an idea concerning this issue please help, I'll have to give my presentation soon, and I have just few arguments like workflow management, search, versioning, but not really rigorous convenient measures.