update indices

[former_member283645]

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

[Former Member · Accepted solution]

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

[former_member283645 · Accepted solution]

Hi Jignesh,

Whag does 'indexes' and 'Accelarator files' mean!!!

Kind Regards

Eva

[Former Member · Accepted solution]

Hi,

Index : A database index is a data structure that improves the speed of data retrieval operations on a database table

Accelerator files: MDS server create accelerator file to speed up the data communication from memory instead of database,

if the repository loaded immediately : indices are loaded from accelerator files instead of being regenerate by reading them from database

if the repository loaded indices :rebuilds all MDM indexes files by reading and indexing data stored in the database this option generally used when changing MDM repository structure or if any error occur

Thanks,

Jignesh Patel

[Former Member · Accepted solution]

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