For  testing  purposes,  a  standalone  script  called  fclient.php  was  used  to  populate  this 

table  with  20,000  random  businesses  in  random  locations  around  Ireland.  The  business 

names were plucked from a file of Irish surnames found on the internet. It was a long file, 

so I selected only the  K  surnames. A real implementation can of course handle business 

names beginning with any alphanumeric character. Each surname was prepended to one 

of  a  selection  of  random  business  types,  which  is  consistent  with  its  corresponding 

category  id.  The  street  names  are  also  fake,  but  the  towns,  counties  and  area  codes  on 

every row are consistent with each other. The telephone numbers are completely random, 

except for the few areas of Dublin that were manually included, which have accurate 3 

digit  prefixes  (I  think)  followed  by  randomly  generated  4 digit  suffixes.  The  web 

addresses  are  of  the  form 

www.biznamebizcategory.ie

  and  the  emails  are  all 

info@biznamebizcategory.ie

. Approximately one business in ten has a picture ad and its 

filename is generated as bizid_bizname.png. Approximately one business in four has an 

XML shop and its generated filename is bizid_bizname.xml. 

The category table has three columns: 

  cid (primary key)  unique category identifier, used for category specific searches 

  category   text description of the category 

  shopform   associated  smart form  used to query XML database(s) if this category 

is most closely related to user`s query 

Again, for testing purposes, this table was given 65 rows, 

for 65 different business categories. 

Lastly, areacode has two columns 

  code  (primary  key)   an  area  code  (national  dialling 

code)  without  leading  zero  or  a   1    followed  by  a 

three digit Dublin area prefix. 

  adjacent   any area code which is adjacent to the code 

in the primary key 

Fig. 1: Detail of the areacode adjacency table 

28