Skip to Content
avatar image
Former Member

update indices

Hi,

when i try to load my repository i can see a option 'update indices'.

Does it mean that repository structural changes when compared to previous load are only updated !!!!

Not very clear, can any one explain me in simple words!!

Kind Regards

Eva

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 25, 2010 at 10:55 AM

    Hi Eva,

    There is a significant difference between the loading time for loading with or without indices. If the indices are created once, there is normally no need to load the repository with indices again. The indices have to be recreated only if an error occurs. By loading with indices, the load time can increase several times compared to a load time for loading without indices.

    Load Repository Immediate

    1. Loads indexes from accelerator files instead of being regenerated by reading the data them from the DB and creating index.

    2. Automatically builds indexes stored in out-of-date accelerator files.

    3. Is usually fast.

    Load Repository with Update Indices

    1. Rebuilds all MDM indexes files by reading and indexing data stored in the DB. The results are flushed on disk as accelerator files.

    2. Necessary by repository schema changes or if any error occurs.

    3. Might take significant amount of time to complete.

    Thanks,

    Jignesh Patel

    Edited by: jignesh patel on Oct 25, 2010 5:28 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Eva,

      Indexes: As per my understanding, There are many tables created in DBMS(Sql, Oracle etc) for a single repository like Role, Users, Main table, sub tables as well as other tables. So the linking between these tables(Relational DBMS) is nothing but indexing for fast retrieval of data. So when ever you make changes in your repository at schema level using MDM console, the same should be reflected at your DBMS level for changed structure and thus indexing should be updated using update indices in order to get accumulated the same structure changes for your DBMS tables.

      Accelerator files: As per my understanding, you have Accelerator directory (location) which is nothing but a path to store MDM Server index files to access to your DBMS data faster. These accelerator files provide a way to connect your DBMS quickly and thus help in faster retrieval of data.

      Regards,

      Mandeep Saini

  • avatar image
    Former Member
    Oct 23, 2010 at 11:29 PM

    Hi Eva,

    Update Indices option si always visible. It doesn't mean that there is any change in repository structure. When you choose Immediate, MDM automatically updates indices that it knows to be out of date as a result of changes you make to the MDM repository data through MDM Data Manager. However, when the structure of the repository has been modified through MDM Console, MDM cannot know precisely which indices need to be updated. In these cases, you should choose Update Indices rather than Immediate when you load the repository.

    After restoring an MDM repository from an archive, it is recommended that you use the Update Indices option of the Load Repository command.

    Thanks,

    Anshuk Saxena

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2010 at 12:23 PM

    Hello Eva,

    Please refer section "5.5 Accelerator files" on page 7 of below document...

    [http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70b0caa1-92e5-2c10-c687-a8d05e778e59?quicklink=index&overridelayout=true]

    Regards,

    Shaailesh.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2010 at 09:59 AM

    Hi Eva,

    As above, it will be present all the time.

    Basically when you select it, the synchronisation betwen DB and the accelerator files will happen.

    Its a must when structural changes are done in the Console.

    Thanks,

    Priti

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2010 at 11:09 AM

    In one liner as per my understanding when you choose update indices - MDM server asks for data from Database and refesh whole structure in loading.

    Hope it helps

    Rgds

    Deep

    Add comment
    10|10000 characters needed characters exceeded