Skip to Content

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 a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

    • Former Member eva majarova

      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

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.