cancel
Showing results for 
Search instead for 
Did you mean: 

update indices

former_member283645
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
Participant
0 Kudos

Hi Jignesh,

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

Kind Regards

Eva

Former Member
0 Kudos

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
0 Kudos

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

Answers (4)

Answers (4)

former_member182007
Active Contributor
0 Kudos

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

former_member208981
Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.