Types | Key Value Store | Column Store | Document Store | Graph Database |
Performance | High | High | High | Variable |
Scalability | High | High | Variable (High) | Variable |
Flexibility | High | Moderate | High | High |
Complexity | None | Low | Low | High |
Read | Consistent Read | Read rare | Read Intensive | More Read Intensive |
Write | Consistent Write | Write Many | Not write Intensive | Less Write Intensive |
Others | Caching
User Session Caching Contents |
IOT Quick stream OS |
Handle lots of variety of data | Data
Type may relate each other
Vertical Scaleout Horizontal Scaleout |
We'll explore scenarios involving nested queries, aggregations, custom scoring, and hybrid queries that combine multiple search criteria. 1. Nested Queries ElasticSearch Example: ElasticSearch supports nested documents, which allows for querying on nested fields with complex conditions. Query: Find products where the product has a review with a rating of 5 and the review text contains "excellent". { "query": { "nested": { "path": "reviews", "query": { "bool": { "must": [ { "match": { "reviews.rating": 5 } }, { "match": { "reviews.text": "excellent" } } ] } } } } } Redis Limitation: Redis does not support nested documents natively. While you can store nested structures in JSON documents using the RedisJSON module, querying these nested structures with complex condi...
Comments