|RE: [firebird-support] Database design comments
> > (Confirming, you did say that the table of brushes would contain500,000
> >items, right?)increase in
> Yah. Right now the database will have 500 000 brushes and will
> the future because every time they identify a competitor brush orthe
> manufacturer brush, they will put it on the database. Therefore, in
> future the database will have 1 million or more. I talk with the guyshere
> and we are assuming 1.5 million the worst case.Then the uniqueness of the require properties will significant impact on
how a complete solution might be constructed.
You haven't answered my previous question regarding the commonality of
the required properties -- i.e. what is the smallest and largest number
of brushes which will share the same required properties.
> >Also, while you may have 200 clients connected to the database, Ican't
> >believe that they all will be searching for matches simultaneously.mean
> Well, in fact this is true because this is a sales software. This
> that every day sales team will use it to identify the brush and sellit.
> But this can be resolved by multiple databases. So each salesdepartment
> have its own database and therefore just 10 clients will be accessingthe
> database at the same time. Do you know if firebird has tools formaitain
> multiple databases synchronized?Not built-in, but there are some third-party tools which can do this,
you can also build your own for a single table.
> >Is there any way to perform the similar-to search by looking for anrelevance
> >exact match based on all the properties, and then dropping the match
> >criteria based on an order of properties which have the least
> >for similarity.of
> Is not so simple. The objective of this search is identify my company
> brushes when you input competitor or manufacturer information of the
> brush. Sometimes is easy because you have all information, but most
> the times you don't have anything. Just a competitor part number. Somy
> job if provide all brushes that can be similar with the competitorbrush.
But the part number will yield you the specs for the "target" brush,
from their you will need to find the possible matching brush from your
firm's inventory. This seems to be an even easier task, since there
maybe 1.5 Million brushes, your firm will only have a small portion that
it sells. Thus is further reduces the number of 'candidates' which need
to be evaluated.
> Yah. I want to list all brushes with similarity higher than 85 %. Theuser
> also has the option to select the minimum level between 85% and 100%.Understood, but I am sure that there are some properties which will have
a higher importance/value to the similarity value, so by evaluating
these properties first, you can quickly reduce the size of the set for