REINDEXING OF A DYNAMIC DATABASE


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting REINDEXING OF A DYNAMIC DATABASE
# 1  
Old 08-21-2011
REINDEXING OF A DYNAMIC DATABASE

REINDEXING A DATABASE
Hello,
I have a database which in fact is a personal dictionary of a special kind to handle name homophones The structure is as follows:
a=b=c=d=e=f
This structure is an instruction to the program that whenever it encounters such a set of correlations it should treat them as one and link them together.
The database unfortunately is not static but is dynamic and as more and more data streams in, the databse structure needs to be changed radically. In other words the existing links need to be restructured.
An example will make this clear:
Existing database with a linked list:
samar=shamar=sammar=samara=sammara=shamra=samra
New input
samar=shamar=sammar=shammar
samara=samara
shamra=samra
This would mean that the existing index would need to be reindexed such that the final output would be:
samar=shamar=sammar=shammar
samara=samara
shamra=samra
Note that =shammar has been added and that
samara=samara
shamra=samra
have been removed from the existing index and provided a new status.
I have tried all tricks possible to get the database to be re-indexed programmatically but I seem to get wrong results, which would mean that the program for indexing homophones into groups fails.
Any help given by way of a script would be gratefully acknowledged
# 2  
Old 08-21-2011
Show what you have tried so far...and what are the rules for removing an existing index with new input is it the match on first item of the list...explain clearly as your post is confusing.
# 3  
Old 08-22-2011
Hello,
I had written a macro and a script specific to Ultraedit to handle the reindexing. But both have not worked. Hence the request for a script in Perl or in Awk to handle the reindexing.
Basically what I need is a script which will reindex a database as and when new matches pop in.
This means that if I have an existing string such as a=b=c=d=e
and on analysis I find that that in fact a=b=c=d is to be reindexed as
a=b=f (a new entity "f" is to be added)
c=d
e
The existing string
a=b=c=d=e
should read as:
a=b=f
c=d
e
I hope what I have explained makes the problem clear.
Many thanks for your query
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

CRON Job to copy database and replace existing database

I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the... (1 Reply)
Discussion started by: nzrobert
1 Replies

2. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies

3. Solaris

redirect solaris database from linux database..

hi.. i have a need .. my php runs on my linux redhat box with mysql.. i want my php code to refer another mysql database which is in solaris 10 x86... can u tell me the procedure .. how it can be done through php .. sorry am new to php... is it possible to redirect from linux mysql to... (7 Replies)
Discussion started by: senkerth
7 Replies

4. Shell Programming and Scripting

Help with Dynamic variable

I need some variable help TEMP1=Jane TEMP2=Sue X=1 eval USER=TEMP${X} echo $USER This gives output USER1 I would like to get Jane I have tried eval USER='TEMP${X}' eval USER="TEMP${X}" eval USER=`TEMP${X}` (3 Replies)
Discussion started by: Jotne
3 Replies

5. UNIX for Advanced & Expert Users

Dynamic Tunnel

Hi All, Anyone here already done similar to the queries below ? Is there is a way to have a setup that would allow an SA to easily hook any prod server (external ip) to an internal ip without network reconfigurations ? Your comments here will be much appreciated. Thanks (4 Replies)
Discussion started by: linuxgeek
4 Replies

6. UNIX for Advanced & Expert Users

Sql dynamic table / dynamic inserts

I have a file that reads File (X.txt) Contents of record 1: rdrDESTINATION_ADDRESS (String) "91 971502573813" rdrDESTINATION_IMSI (String) "000000000000000" rdrORIGINATING_ADDRESS (String) "d0 movies" rdrORIGINATING_IMSI (String) "000000000000000" rdrTRAFFIC_EVENT_TIME... (0 Replies)
Discussion started by: magedfawzy
0 Replies

7. Shell Programming and Scripting

Dynamic update loop query on Sybase database

Hello Guys, I'm new to Shell scripting, and i need someone to help me with this issue: I'm trying to do a dynamic update query on Sysbase database table using shell script. Lets say, the Update query is "update Table set id=X" , where X is dynamic value for the loop index. If the loop is... (10 Replies)
Discussion started by: Alaeddin
10 Replies

8. UNIX for Dummies Questions & Answers

dynamic pid?

hi, i noticed that the pid of a process can change.. is that true? like now i do a ps on my terminal.. and there is a list of process with their pids.. and later with the same process, (without qutting and runnign the same process) this time round, their pid are different? is it true? (2 Replies)
Discussion started by: yls177
2 Replies
Login or Register to Ask a Question