Questions tagged [elasticsearch]
Elasticsearch is an Open Source (Apache 2), Distributed, RESTful, Search Engine built on top of Lucene.
46 questions
0
votes
1
answer
57
views
Finding related items in OpenSearch between 2 datasets
I have a scenario where I have 2 sets of data:
All possible products
Products carried by a store
Dataset 2 is a subset of dataset 1.
If a user searches for a product that the store doesn't carry, I'...
0
votes
1
answer
95
views
How to architect an in-app search solution that accounts for access to data?
I have a lot of data that I would like to enable end-users to search on. I plan to use ElasticSearch (but am open to other technologies). This would also be an AWS native solution. For simplicity, let'...
-2
votes
1
answer
798
views
How to create Business rule engine in PostgreSQL? [closed]
Our organization is into Health Care RCM business. In that, we use to receive medical records (called as accounts, which is a business phrase) and our staff (Medical coders) use to do medical coding, ...
0
votes
1
answer
808
views
REST API Design: Should we have separate endpoints for same resource if the system uses both ElasticSearch and MySQL?
Suppose we have a resource which uses either MySQL or ElasticSearch, depending on whether the query params require full-text search or not.
For example the possible query filters are:
fk_id which is a ...
1
vote
0
answers
137
views
Backend Design: System requires both ElasticSearch and MySQL. In which scenario we fetch data from MySQL or ElasticSearch?
So, one of the backend system, having 5 resource types (tables) and some foreign keys as well, requires full text support for two of the tables.
Also, for some use-cases, we require inner-joins for ...
2
votes
2
answers
2k
views
What is the advantage of Kafka connector to MongoDB over using MongoDB change streams?
I need to stream changes from my MongoDB instance to Elasticsearch. I also need to perform complex transformations on changed documents. After doing some research I narrowed my options down to 2:
...
0
votes
1
answer
378
views
Do I have to use Filebeat to parse logs with logstash?
I was under the impression that Filebeat is only necessary if I wish to provide a constant, paced, fresh input to logstash.
But the tutorial here starts with configuring Filebeat to send log lines to ...
2
votes
1
answer
154
views
eCommerce category path - names vs IDs
I am building an eCommerce website and there is a Category table in my MongoDB database which has a field called path. This field is used to store category hierarchy e.g Boots category will have /...
0
votes
0
answers
51
views
Filtering data from elastic search based on mongodb
I've a list of items in my ElasticSearch.
User enters a query and I fetch the results from elastic search. Now, I've a requirement where I don't want to show the user the items which he has already ...
2
votes
1
answer
122
views
Elasticsearch and RDMBS combination
I read both this thread Elasticsearch and PostgreSQL combination and this one Elasticsearch and relational database combination, but I could not come to an answer.
Let's say I have to re-create a ...
1
vote
0
answers
206
views
Combine/Sync Amazon S3 and MongoDB Atlas with Elastic Search
I have many continuously growing (through scrapping) collections in MongoDB Atlas. The documents in each collection follows the following schema:
{
"source_url": "<some url on the web>",
"html":...
5
votes
1
answer
466
views
ReactJS with Elasticsearch app architecture
I want some advice regarding my architecture and hosting options.
I'm attempting to build an e-commerce site for e-books. It will use NestJS for the backend and ReactJS+Typescript for the frontend.
...
0
votes
0
answers
247
views
Elastic Search inverted index and index containing actual documents?
I have gone through Elastic working and understands how inverted index(faster look up) and index(
storing actual document disk in ES). My understanding is that inverted index has most of the required ...
2
votes
1
answer
2k
views
Elasticsearch and PostgreSQL combination
I have a marketplace application and I stored data in a PostgreSQL. I have performance problem for product search, I know I can improve search performance if I use Elasticsearch instead of PostgreSQL ...
0
votes
0
answers
331
views
Sorting and filtering: ElasticSearch vs MongoDB
This is a problem related to a typical e-commerce requirement.
I am using ElasticSearch for all the below use cases.
I am confused about whether or not to use MongoDB for the sorting part.
I have the ...
1
vote
0
answers
323
views
Log data anonymization with ELK
I'm considering using the ELK stack for logging within our company. To comply with our data retention policy, we would like to anonymize data after one year so it cannot be traced back to an ...
0
votes
1
answer
140
views
Is AWS Elasticsearch is completely managed service or is it just a Elasticsearch installation on set of ec2 instance
I want to understand the difference between AWS Elasticsearch service vs on-premise version. Does AWS provides a fully managed service for Elasticsearch (like DynamoDB, SQS etc) Do we have to manage ...
11
votes
6
answers
21k
views
Is it worth logging HTTP requests when they enter an API server?
I'm designing an API and have reached the topic of logging. I'm going to store my logs in Elasticsearch.
I'm certainly going to do some logging at the time the HTTP response is sent back to the ...
1
vote
1
answer
525
views
Designing a Social Network with Graph Databases
I am prototyping a social network as part of a project I am working on and want to learn the right way to do it as if it were for an industry leading company.
I've decided on implementing the social ...
-2
votes
1
answer
414
views
Elastic search vs chatbot?
I have an in-house built job scheduling application that accepts Job configurations in form of Apache Config files (something similar to XML).
There are tons of configurations (for example a way to ...
1
vote
1
answer
451
views
Some Guidance on Parent-Child Relationships in Elasticsearch
I would like some guidance in setting up my document structure Elasticsearch. The company I work for has an app that stores around 20,000 new phone records each day in a SQL database. And we feel we ...
1
vote
1
answer
2k
views
Logging architecture in microservices
We are going to develop an enterprise level application which will be run by a dozen microservices. Every microservice will be inside docker and all this will be orchestrated by Kubernetes.
Obviously, ...
1
vote
0
answers
100
views
Java dashboard for machine data
I am currently working on a project for a production facility. The machines in the production are saving so called 'Telemetry Data', measurements like water pressure, plastic volume or temperature ...
5
votes
1
answer
444
views
Design point for product search and auto-complete using Elastic search?
I need to implement product search using Elastic search similar to it is done on any scalable ecommerce site.I am planning below algorithm
for this
Whenever product is added to system, First add it ...
1
vote
0
answers
69
views
Giving search on customizable fields
I have some user defined custom fields corresponding to a ticket (A ticket is an entity which has subject, status and custom fields). I need to search tickets based on its custom field values.
A ...
0
votes
1
answer
115
views
Problems with evaluating results of search engine by comparison
We're building a search engine at a client's place. To evaluate the results, the client is comparing top N results of our search engine to top N results of a competitor. And they want me to get at ...
-3
votes
1
answer
761
views
Design the cache and search feature like hotel booking?
I need to design the feature like in encommerce(consider hotel booking site) we can enter the keyword/partial-keyword and need to return the relevant results.
For Example :- If site admin or hotel ...
1
vote
1
answer
438
views
Data layer Abstraction from Business layer for search
This is regarding designing a search api. We have 3 tier architecture now using Spring MVC. All communications are via REST api.
UI <-> Business <-> Data(sql).
Now to implement faster ...
3
votes
3
answers
2k
views
Architecting a universal search for a product with microservices
We are building a new product in real estate space and the end users of this product are not so tech savvy. To have better user experience with our product, we want our users to find relevant things ...
2
votes
1
answer
161
views
Decouple service complex query building from datastore
We have a very large search service (written in golang if it matters) that runs on top of ElasticSearch, receive requests, builds the correspondent query, and returns the results (with some post-...
2
votes
1
answer
2k
views
How to handle UI updates dependent on slow API responses
A side project I'm working on with some friends currently deals with an API interface that, for many reasons, is slow and cannot be changed to improve speed. I'm talking API responses that take ...
3
votes
1
answer
3k
views
Why is elastic search popular? [closed]
Elastic search is basically about indexing of data.
In database world,
Multiple indexes can be created on a MongoDB collection
Collection in MongoDB can be schema-less.
In MongoDB, BSON encoding of ...
8
votes
1
answer
4k
views
ElasticSearch vs SQL Server full text index for small datasets?
I've got a relatively high-traffic public-facing product-based website backed by SQL Server as the point of authority. It has some search capability on some of the columns of the Items table (year, ...
1
vote
1
answer
152
views
Is it good to consider elastic search a datastorage?
I am very new to elastic search and i need to know it is even useful to store data?
because i was curious to try my hands on how elastic search works and i used postman>run elastic search then added ...
3
votes
1
answer
2k
views
How should I store user activities in ElasticSearch and figure out popular searches?
I've got java logging user activities to Fluentd, Fluentd is then writing these activities into an elasticsearch index.
Every user activity is recorded, some include:
User1 follows user2
User1 likes ...
0
votes
1
answer
2k
views
Creating a facet filtering using Elasticsearch
I have been asked to create a filtering functionality for e-commerce application written in PHP. Since the app is using MySQL database, I made the decision to use Elasticsearch with Logstash and ...
2
votes
1
answer
897
views
How should I implement a full text search into my meteor web app?
I am making a web application using the javascript framework Meteor, which runs with mongodb. In the web app I have a db set up that holds individual video games in the documents. An example of this ...
4
votes
1
answer
2k
views
Best practices for dashboard of near real-time analytics
I’m currently building a dashboard to view some analytics about the data generated by my company's product.
We use MySQL as our database. The SQL queries to generate the analytics from the raw live ...
0
votes
2
answers
4k
views
How to properly index MongoDB with ElasticSearch?
we are working on a JAVA EE project which handles huge amount of data, but has to provide full-text-search option (in hungarian language).
So we started to think about what kind of architecture could ...
2
votes
1
answer
2k
views
Feeding events to Elasticsearch, do I really need Logstash?
I'm designing an analytics system that feeds all events to Elasticsearch. The event lifecycle is as follows:
Visitor does something.
Custom analytics server gathers data, makes an event out of it and ...
6
votes
1
answer
2k
views
Elasticsearch and relational database combination
Imagine I have a marketplace application - where users can search for products (we concentrate on clothes). Every product has an ID, name (text), description (text), price (numeric), size (numeric), ...
0
votes
0
answers
192
views
Using Google for full text database search
I have a lot of text and I am storing it in Elastic search. Using Lucene, NLP and Wordnet filters the search is good but not as good as Google's because none of these methods use AI for the search so ...
0
votes
0
answers
529
views
Google-like search solution for an enterprise application stack using Elasticsearch
I know, title is a little confusing but the problem is, too. I am working on a company, it has several different applications and wants these applications have search functionality. We have developed ...
3
votes
4
answers
2k
views
Are NoSQL databases the best choice for more efficiently querying large amounts of data?
We are planning to build a travel website in which we will be integrating multiple APIs (eg. DOTW, GTA, Expedia) for Hotels. I have initially tried to use MySQL but since there are huge amounts of ...
22
votes
3
answers
35k
views
Why would I use ElasticSearch if I already use a graph database?
I don't find any deep explanation on the web about a comparison between ElasticSearch and the graph databases.
Both are optimized to traverse data.
ElasticSearch seems to be optimized for analytics.
...
8
votes
2
answers
3k
views
How does Elastic Search approach the problem of distributed membership and consensus?
I already understand that Elastic Search is supposed to be deployed in a distributed topology, in that you can have multiple nodes for a cluster of ES instances.
I like the API, and it looks promising....