• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
TSB Alfresco Cobrand White tagline

Technology Services Group

  • Home
  • Products
    • Alfresco Enterprise Viewer
    • OpenContent Search
    • OpenContent Case
    • OpenContent Forms
    • OpenMigrate
    • OpenContent Web Services
    • OpenCapture
    • OpenOverlay
  • Solutions
    • Alfresco Content Accelerator for Claims Management
      • Claims Demo Series
    • Alfresco Content Accelerator for Policy & Procedure Management
      • Compliance Demo Series
    • OpenContent Accounts Payable
    • OpenContent Contract Management
    • OpenContent Batch Records
    • OpenContent Government
    • OpenContent Corporate Forms
    • OpenContent Construction Management
    • OpenContent Digital Archive
    • OpenContent Human Resources
    • OpenContent Patient Records
  • Platforms
    • Alfresco Consulting
      • Alfresco Case Study – Canadian Museum of Human Rights
      • Alfresco Case Study – New York Philharmonic
      • Alfresco Case Study – New York Property Insurance Underwriting Association
      • Alfresco Case Study – American Society for Clinical Pathology
      • Alfresco Case Study – American Association of Insurance Services
      • Alfresco Case Study – United Cerebral Palsy
    • HBase
    • DynamoDB
    • OpenText & Documentum Consulting
      • Upgrades – A Well Documented Approach
      • Life Science Solutions
        • Life Sciences Project Sampling
    • Veeva Consulting
    • Ephesoft
    • Workshare
  • Case Studies
    • White Papers
    • 11 Billion Document Migration
    • Learning Zone
    • Digital Asset Collection – Canadian Museum of Human Rights
    • Digital Archive and Retrieval – ASCP
    • Digital Archives – New York Philharmonic
    • Insurance Claim Processing – New York Property Insurance
    • Policy Forms Management with Machine Learning – AAIS
    • Liferay and Alfresco Portal – United Cerebral Palsy of Greater Chicago
  • About
    • Contact Us
  • Blog

Documentum, Alfresco or a Database – What Developers need to consider

You are here: Home / Alfresco / Documentum, Alfresco or a Database – What Developers need to consider

October 23, 2013

Many times, TSG will get involved with clients that have strong developers on staff that come from a database development background and are unfamiliar with the capabilities of Enterprise Content Management (ECM).   As database systems expand from just the data to add related documents, the database paradigm approach will typically lead to database entries with file pointers to point/store the related documents.  This post will address the shortcomings of a database approach by sharing how leverage of an ECM system simplifies and shortens the development process as document related capabilities are added to the system.

Document Functions

In most situations, we see that the database application was developed first with a user request that got added later.  The database paradigm typically starts with the user request “We would like to store these documents with the data”, rather than a content management need from the beginning.  A good example would be contracts related to a particular project or sale.  In this case a contract management system for the data might have been created with database tools.  A developer could easily build a simple upload to a file system and then add an entry to the sale/project data to point to that file.  When requested, the developer could add a download of the file itself.  This is the approach many clients begin with that is pretty simple.  Once users experience some document capabilities, they may be quick to request additional capabilities including:

  • I would like to know who added the document and when (Audit – Attributes)
  • I would like only certain people to be able to see or change/update the file (Security)
  • I would like to version the file based on changes we discussed (Versioning-  Check-in/Check-out)
  • I would like to render the file to PDF (Renditions)
  • I would like to scan files into the system (Scanning)
  • I would like to annotate the file but only have selective people see my annotations (Annotate)
  • I would like to store related emails/documents with the document (Relationships/Folders)
  • I would like to be able to full-text search all the documents (Searching)

For the above functions, a database developer can quickly see the difficulty of adding the database entries as well as the functionality all in custom database code and entries.   Often times, database developers will justify the database approach in that ECM tools are, at their core, built on databases that point to file systems.  The key thing to understand is that the database model and functions include ALL the document management capabilities to begin with rather than the database developer having to develop from scratch.

Enterprise Content Management System Capabilities

Another difficulty of the database/file system approach is maintaining system integrity.  Key to the backup/restore/migration/upgrade of ECM is the ability to snap shot, at a point in time both the file system and the related data (attributes).  We have seen system errors where directories of files have been deleted due to system error/hard disk failure or other outage situations.  ECM systems give the ability to restore the data/documents as well as maintain system integrity.

API/Service Orientated Architecture

The best approach for extending database applications to include ECM capabilities is via the API or Service Orientated Architecture (SOA).  OpenContent is TSG’s SOA for Documentum and Alfresco but also includes support for Solr/Lucene and limited SharePoint.  JavaDocs for our SOAP release are still available below:

https://tsgrp.wpengine.com/OpenSource/javadocs/soapwebservices/

Look for an updated document with our 2.1 release before the end of the year.

Database developers should recognize that building an SOA layer to a customized database as well as the supporting backup/recovery synch points with security and all the other functions will require a considerable amount of work.  Developers would be better served to leverage and reuse capabilities of ECM products rather than incur the cost, expense, instability and effort of building themselves.

Summary

Many applications start out as database-focused custom applications.  Database developers should recognize, as they add document capabilities, that leveraging ECM tools like Alfresco or Documentum, will reduce their coding and support efforts while producing a more reliable and stable system.

Let us know your thoughts below:

Filed Under: Alfresco, Documentum, OpenContent Management Suite, OpenContent Web Services

Reader Interactions

Comments

  1. Jorge Sapaj says

    October 23, 2013 at 10:15 am

    Hi Dave,
    I 100% agree with your post!. I Just like to add another key point into this matter. The application focus: Content-Centric applications vs Database/Transactional applications are different by nature as they involve different concepts and requirements and functionality.

    Beside this central point there is also the “Best Practice” concept and staff skills. Would a developer team be able to match the functionality of an ECM system that took many years of R&D to be built? Probably not. This is the essential concept behind any “licenseable” software, not just ECM. Right?

    Saludos,
    Jorge S.

    Reply

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Search

Related Posts

  • Alfresco No Code – Do More with OpenContent
  • Elastic Services for ECM – TSG OpenContent Roadmap
  • Print to Repository – OpenContent Print Driver Support
  • ECM 2.0 – Can you build it yourself?
  • Migrating to Alfresco – Reducing Risk, Stress and Cost with a Rolling Migration
  • Adobe Acrobat Alternative – Doing more with just a web browser
  • Building a Case Management Interface in Under 20 Minutes
  • Redaction for AWS, Alfresco, Documentum and Hadoop – Bulk Redaction upon Ingestion or Migration
  • Redaction for AWS, Alfresco, Documentum and Hadoop – Folder Case Redaction
  • Redacting Roadmap – User Scenarios

Recent Posts

  • Alfresco Content Accelerator and Alfresco Enterprise Viewer – Improving User Collaboration Efficiency
  • Alfresco Content Accelerator – Document Notification Distribution Lists
  • Alfresco Webinar – Productivity Anywhere: How modern claim and policy document processing can help the new work-from-home normal succeed
  • Alfresco – Viewing Annotations on Versions
  • Alfresco Content Accelerator – Collaboration Enhancements
stacks-of-paper

11 BILLION DOCUMENT
BENCHMARK
OVERVIEW

Learn how TSG was able to leverage DynamoDB, S3, ElasticSearch & AWS to successfully migrate 11 Billion documents.

Download White Paper

Footer

Search

Contact

22 West Washington St
5th Floor
Chicago, IL 60602

inquiry@tsgrp.com

312.372.7777

Copyright © 2023 · Technology Services Group, Inc. · Log in

This website uses cookies to improve your experience. Please accept this site's cookies, but you can opt-out if you wish. Privacy Policy ACCEPT | Cookie settings
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT