phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Randy <ruw...@gmail.com>
Subject Custom Indexing Plug-in for Phoenix
Date Tue, 04 Apr 2017 00:27:52 GMT
Wondering if anyone knows whether there is an approach to swap in custom
indexing implementation, while leveraging all other functionalities of
Phoenix. The initial goal is just in SELECT query, but would be nice to
make custom index maintenance integrated in record life cycle as well.

Phoenix supports secondary index already, but need to be more flexible with
real large data set when the format and quality varies.

For example, assuming we have a table "PEOPLE" which has a column "NAME"
stored person's name. If there is a record with "Joe Smith" as the value of
"NAME" column, it would be really powerful if we can find it by variants or
partial name as criteria. Ideally all the following query would find the
same record if we can plug-in a custom indexing implementation in Phoenix:

SELECT * FROM PEOPLE WHERE NAME='Joe Smith';
SELECT * FROM PEOPLE WHERE NAME='Smith,Joe';
SELECT * FROM PEOPLE WHERE NAME='Joseph Smith';

Given the secondary index has global vs. local implementation. I would
imagine there is some level of abstraction already on consuming the index.
Not expecting it would be official supported API, just some guidance on
where to start would be greatly appreciated.

Thanks,

Randy

Mime
View raw message