Multitenant Database Containers (MDC) | Multiple Components One System (MCOS) |
All the tenant DB sharing the same system HANA revision | Independent HANA revision of each HANA instance |
No additional SAP HANA License | Separate SAP HANA License |
No additional hypervisor virtualization license and hardware independent | No additional hypervisor virtualization license and hardware independent |
No additional machine for hardware/vm management console | No additional machine for hardware/vm management console |
No support on storage snap shot backup | Support on storage snap shot backup |
Shared SAP HANA Binaries - Yes | Shared SAP HANA Binaries - No |
1 Linux license | 1 Linux license |
Support > 4 socket hardware | Support > 4 socket hardware |
Support > 1TB memory | Support > 1TB memory |
Tenant DB only can restore to tenant DB | No dependency of tenant DB backup/restore |
Multiple BW on HANA - Yes | Multiple BW on HANA - No |
No Performance degrade | No Performance degrade |
No additional maintenance required for vsphere patch, Lpar patching | No additional maintenance required for vsphere patch, Lpar patching |
Hardware Resource Management – SAP HANA internal | Hardware Resource Management - SAP HANA internal |
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