on 10-23-2010 10:30 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.