Data Aggregation Examples
Below are examples of data aggregation, which were performed via the CaseSearchExtRest#groupByQuery(POST) service. The syntax of the **Group By** clause was described in the article Lucene Index Queries. The examples were performed using the SoapUI tool.
Data mining and aggregation services
The Mercury DB system offers many services that implement various methods of searching for cases, both in the logical and business layers of the system. In order to standardize and centralize, two main services were created, containing several advanced search methods.
Extended Search and Data Aggregation Services - CaseSearchExt
Example//testcluster.hgdb.io/mercury-ws-app/restServices/CaseSearchExtRest.wadl.
Index Fields Management Services - CaseIndexerFieldsManager
Example//testcluster.hgdb.io/mercury-ws-app/restServices/CaseIndexerFieldsManagerRest.wadl.
Index Lucene
The basis for searching in the Mercury DB system is the [Lucene] Index (https://lucene.apache.org). This article will present the principles of creating field names, which are the basis for implementing search queries. It will also present the division of fields according to their type, category (division according to field origin) and search method (division according to field type).
Introduction to Mercury DB (HgDB) 3.0
Mercury DB is a service server (SOAP and REST) that enables the management of any objects, also referred to as cases. The engine is based on the relational SQL model, whereby data is stored in a relational database. The combination of objects and relations allows for the utilization of Mercury DB as an object database, supporting ACID transactions (atomicity, consistency, isolation, durability), as well as integration with traditional BI (business intelligence) systems for business data analysis. It facilitates interconnectivity between the domains of NoSQL databases (e.g., ElasticSearch, MongoDB) and those of relational databases (e.g., Oracle, DB2, PostgreSQL, MySQL).
Lucene Index Queries
The basic search engine in the HgDB database is the Apache Lucene index implementation. Lucene Core is a Java library that provides advanced indexing and search features, as well as spell checking, hit highlighting, and advanced analysis capabilities. This article will describe the rules for creating search and aggregate queries that apply in Mercury DB (HgDb) 3.0.
Search Services - CaseSearch
The service is generated based on the ICaseSearchAction interface, which implements SOAP services.