The Truth About Indexing: Making the Most of Indexing During Your ECM Migration

You have an Enterprise Content Management (ECM) migration project underway, but you’re not happy with the current indexing structure of your archives. It turns out…

OpenText  profile picture
OpenText

January 21, 20144 min read

QR code and smartphone, new technologies. Electronic digital technologies scanning, barcode
QR code and smartphone, new technologies. Electronic digital technologies scanning, barcode

AIMMWPYou have an Enterprise Content Management (ECM) migration project underway, but you’re not happy with the current indexing structure of your archives.

It turns out you’re in luck, because an ECM migration can be the perfect time to consider changing or enhancing the current indexing structure of your archives. As you’re adding to your indexes, you can enhance them as well and improve what’s already there.

Why is indexing important and an ECM migration a good time to restructure? Keep reading to find out.

Intro to Indexing

ECM repositories can store millions of statements, policies, images and other content. To keep all of that straight, they rely on metadata that describes the documents stored in the system. That metadata can be located in databases, control files, or can be appended to the document contents themselves within the source system. The metadata is used for many purposes including discovery, validation, storage, organization, retrieval, distribution, delivery and deletion of content.

Indexes help the system search out that metadata. Individual document types typically possess a unique set of indexes to describe their contents: an annual financial statement may be identified by searching for a customer’s name and a year, while a monthly statement could be associated with an account number and month.

Understanding those differences helps recreate the relationships between the documents, the target ECM system and the connected business applications.

Indexing is a crucial part of the ECM migration process, building in metadata enrichment, searchability and performance enhancement. During a migration, all indexing information has to be maintained and migrated to the target ECM system. Sometimes additional metadata is also needed in the target system, in which case it can be acquired, potentially by mining the content during the migration process to extract index information and meet the target system requirements and business use.

It’s important that everything lines up so that specific items can be found and delivered as needed. For that to happen, the right structure has to be in place.

Re-Indexing and Improving Your Current Structure

Other indexing issues can arise during an ECM migration. Metadata associations may be lost during the extraction phase, for example, a problem that’s particularly prevalent in legacy systems built in the days before XML, complicated by the fact that different document types often require different metadata rules and indexing requirements. To get around this, it is often necessary to rebuild indexes during the migration process through a technique called “re-indexing.” See an example of a re-indexing task within Process Manager on Figure 1 below.

Figure 1. Process flow for a re-indexing task within Actuate Content Services Process Manager.

Re-indexing involves adding and/or changing your current index structure – maybe because you want to enhance the performance of your current searching ability, or to add more indexes that would assist in tying together more document types during a search. The goal is to enhance the end user experience and make old legacy archives more usable and efficient.

And that comes back to why it makes sense to alter your problematic indexing structure during the migration process. Because you’re enhancing and adding to the indexes anyway, it’s the perfect time to change index tag names for consistency, programmatically add indexes to the documents by pulling information from external sources, and error check to ensure index fields are what they were intended to be. You can also redact indexes for Payment Card Industry (PCI) Compliance issues (i.e. masking parts of the credit card number or social security number) during this time.

The migration process gives you an opportunity to do all of this, lining up your indexes so metadata is in order and everything is easy to find.

For more information on indexing, as well as the other stages of the ECM migration process, read “ECM Content Migration: Best Practices in Document Archive Convergence,” a white paper co-written by Actuate and AIIM, the global community of information professionals.

Share this post

Share this post to x. Share to linkedin. Mail to
OpenText avatar image

OpenText

OpenText, The Information Company, enables organizations to gain insight through market-leading information management solutions, powered by OpenText Cloud Editions.

See all posts

More from the author

From the Great North to global innovation: How OpenText powers the future of tech

From the Great North to global innovation: How OpenText powers the future of tech

The beginning of the year is the perfect time to reflect on one’s successful journey and set our sights on the future. At OpenText, our…

February 28, 2025

3 min read

Why SAST + SCA is the key to protecting your organization in 2025

Why SAST + SCA is the key to protecting your organization in 2025

Software supply chain risk continues to rise—just last year we witnessed a staggering 156% year-over-year increase in malicious software supply chain attacks.

January 17, 2025

4 min read

All we want for Christmas:  An open letter to Santa from a modern legal team  

All we want for Christmas:  An open letter to Santa from a modern legal team  

As legal professionals embracing digital transformation, our wish list is a bit different this year.

December 11, 2024

4 min read

Stay in the loop!

Get our most popular content delivered monthly to your inbox.