Can Elastic Search help existing systems? Any tools that can get rid of stored procedures in existing system?


(Architha) #1

Hi Team,

I have an existing project which has huge number of database tables and many stored procedures . If I have to enhance the project using elastic search , what steps should I have to follow ?
And , if the structure of the JSON documents is defined , Is there any tool that can help me get my JSON object from the database ?


(Mark Walkom) #2

Dunno, that's a bit of a broad question for us to answer.
What problems do you want to solve?

Logstash can do it with the JDBC input.


(Architha) #3

Thanks for the response. The problems that i have to solve are

  1. The existing project is slow , i want to enhance it
  2. The stored procedures that are used in the existing system are too many, want to replace them using Elastic search.

(Doug Turnbull) #4
  1. The existing project is slow , i want to enhance it

Which parts of it are slow? Can you give examples of specific use cases?

  1. The stored procedures that are used in the existing system are too many, want to replace them using Elastic search.

Too many stored procedures? To recreate that in Elasticsearch, that would just be more client code that builds ES queries. I suppose this is totally up to your taste in what you'd prefer to manage, but the complexity is probably high in either case.


(system) #5