Big unstructure Text Data Query Problem

Hello,I have a file system.Many unstructure text store in it .For example ,
ISSUED BY: CHINA EASTERN AIRLINES ORG/DST: SHA/XNN ARL-D

E/R:
TOUR CODE:

PASSENGER: NONAME

EXCH: CONJ TKT: 881-88888888/14

O FM:1XIY MU OPEN Q OPEN SUPQ21 20K OPEN FOR
USE
T3-- RL:

TO: XNN

FC: 06MAR13SHA MU KMG480.00//XIY MU XNN200.00CNY680.00END

FARE: CNY 680.00|FOP:CC

TAX: CNY100.00CN|OI:

TAX: CNY200.00YQ|

TOTAL: CNY 980.00|TKTN: 881-888888888

Now I want to transfer this unstructure text to structure object fot query
by field.For exmple,
select * from TKT where TKT.ORG=SHA

TKT database may have TB data.
I use oracle to do this . But performance is poor. Also I try some object
DB like Versant.But performane is sitll poor.
Can elasticsearch hold this query with good performance(Query can return
result in 2-3 second)

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

IMHO you should think of building a JSon doc from your text files using an ETL tool or your own code.
Then you will be able to query it easily (and build facets on top of it BTW) and very fast.

My 2 cents.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 9 mai 2013 à 02:57, jj r7raul1984@gmail.com a écrit :

Hello,I have a file system.Many unstructure text store in it .For example ,
ISSUED BY: CHINA EASTERN AIRLINES ORG/DST: SHA/XNN ARL-D
E/R:
TOUR CODE:
PASSENGER: NONAME
EXCH: CONJ TKT: 881-88888888/14
O FM:1XIY MU OPEN Q OPEN SUPQ21 20K OPEN FOR USE
T3-- RL:
TO: XNN
FC: 06MAR13SHA MU KMG480.00//XIY MU XNN200.00CNY680.00END
FARE: CNY 680.00|FOP:CC
TAX: CNY100.00CN|OI:
TAX: CNY200.00YQ|
TOTAL: CNY 980.00|TKTN: 881-888888888

Now I want to transfer this unstructure text to structure object fot query by field.For exmple,
select * from TKT where TKT.ORG=SHA

TKT database may have TB data.
I use oracle to do this . But performance is poor. Also I try some object DB like Versant.But performane is sitll poor.
Can elasticsearch hold this query with good performance(Query can return result in 2-3 second)

You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Thank you~ Where is the ES China company?How to contact ?

在 2013年5月9日星期四UTC+8上午10时31分31秒,David Pilato写道:

IMHO you should think of building a JSon doc from your text files using an
ETL tool or your own code.
Then you will be able to query it easily (and build facets on top of it
BTW) and very fast.

My 2 cents.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 9 mai 2013 à 02:57, jj <r7rau...@gmail.com <javascript:>> a écrit :

Hello,I have a file system.Many unstructure text store in it .For example
,
ISSUED BY: CHINA EASTERN AIRLINES ORG/DST: SHA/XNN
ARL-D
E/R:
TOUR CODE:

PASSENGER: NONAME

EXCH: CONJ TKT: 881-88888888/14

O FM:1XIY MU OPEN Q OPEN SUPQ21 20K OPEN
FOR USE
T3-- RL:

TO: XNN

FC: 06MAR13SHA MU KMG480.00//XIY MU XNN200.00CNY680.00END

FARE: CNY 680.00|FOP:CC

TAX: CNY100.00CN|OI:

TAX: CNY200.00YQ|

TOTAL: CNY 980.00|TKTN: 881-888888888

Now I want to transfer this unstructure text to structure object fot
query by field.For exmple,
select * from TKT where TKT.ORG=SHA

TKT database may have TB data.
I use oracle to do this . But performance is poor. Also I try some object
DB like Versant.But performane is sitll poor.
Can elasticsearch hold this query with good performance(Query can return
result in 2-3 second)

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com <javascript:>.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Hello,I want to use ES to build index for query. Use Versant to store
object. How to write river plugin ?

在 2013年5月9日星期四UTC+8上午8时57分19秒,jj写道:

Hello,I have a file system.Many unstructure text store in it .For example
,
ISSUED BY: CHINA EASTERN AIRLINES ORG/DST: SHA/XNN
ARL-D
E/R:
TOUR CODE:

PASSENGER: NONAME

EXCH: CONJ TKT: 881-88888888/14

O FM:1XIY MU OPEN Q OPEN SUPQ21 20K OPEN
FOR USE
T3-- RL:

TO: XNN

FC: 06MAR13SHA MU KMG480.00//XIY MU XNN200.00CNY680.00END

FARE: CNY 680.00|FOP:CC

TAX: CNY100.00CN|OI:

TAX: CNY200.00YQ|

TOTAL: CNY 980.00|TKTN: 881-888888888

Now I want to transfer this unstructure text to structure object fot
query by field.For exmple,
select * from TKT where TKT.ORG=SHA

TKT database may have TB data.
I use oracle to do this . But performance is poor. Also I try some object
DB like Versant.But performane is sitll poor.
Can elasticsearch hold this query with good performance(Query can return
result in 2-3 second)

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

See http://elasticsearch.com/

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 9 mai 2013 à 05:06, jj r7raul1984@gmail.com a écrit :

Thank you~ Where is the ES China company?How to contact ?

在 2013年5月9日星期四UTC+8上午10时31分31秒,David Pilato写道:

IMHO you should think of building a JSon doc from your text files using an ETL tool or your own code.
Then you will be able to query it easily (and build facets on top of it BTW) and very fast.

My 2 cents.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 9 mai 2013 à 02:57, jj r7rau...@gmail.com a écrit :

Hello,I have a file system.Many unstructure text store in it .For example ,
ISSUED BY: CHINA EASTERN AIRLINES ORG/DST: SHA/XNN ARL-D
E/R:
TOUR CODE:
PASSENGER: NONAME
EXCH: CONJ TKT: 881-88888888/14
O FM:1XIY MU OPEN Q OPEN SUPQ21 20K OPEN FOR USE
T3-- RL:
TO: XNN
FC: 06MAR13SHA MU KMG480.00//XIY MU XNN200.00CNY680.00END
FARE: CNY 680.00|FOP:CC
TAX: CNY100.00CN|OI:
TAX: CNY200.00YQ|
TOTAL: CNY 980.00|TKTN: 881-888888888

Now I want to transfer this unstructure text to structure object fot query by field.For exmple,
select * from TKT where TKT.ORG=SHA

TKT database may have TB data.
I use oracle to do this . But performance is poor. Also I try some object DB like Versant.But performane is sitll poor.
Can elasticsearch hold this query with good performance(Query can return result in 2-3 second)

You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearc...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.