Unified Index Search for Unstructured Relational Databases
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current information search methods in unstructured relational databases are time-consuming and require manual processing, often involving multiple users and queries, with difficulties in accessing data across multiple databases and ensuring accuracy, especially for non-skilled users and in professional settings like dispatch and financial systems.
Innovation Solution
A method that indexes records across multiple databases with standardized report forms, converts search queries into compatible terms, and generates reports using preferred display formats, ensuring accurate and efficient data retrieval by creating multiple parallel queries and displaying results in relevant formats, while ensuring accurate correspondence to initial search terms.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If manual processing of search queries is used in unstructured relational databases, then users can access data across multiple databases, but the search query processing time is excessive and requires involvement of multiple users
Solution Approach 1:
The patent applies preliminary action by pre-indexing records from multiple unstructured relational databases into a unified index structure before search operations. This pre-processing step organizes data in advance, enabling rapid query execution without requiring manual intervention during actual search operations, thus resolving the time consumption issue while maintaining multi-database accessibility
Solution Approach 2:
The patent introduces an intermediary search system that acts as a mediator between users and multiple unstructured relational databases. This intermediary component translates user queries into database-specific search operations and aggregates results, eliminating the need for multiple users to manually access each database while significantly reducing processing time
2Ease of operation
If data is retrieved from specific databases using queries to users operating the database, then data access is enabled, but the process is time-consuming and quick access to specialists is not guaranteed
Solution Approach 1:
The patent implements self-service by enabling the search system to autonomously execute queries across multiple databases without requiring human operators. The system automatically retrieves data from relevant databases, processes results, and delivers information to users, eliminating dependency on specialist availability while maintaining ease of data access
Solution Approach 2:
The patent creates a universal search interface that can access and query multiple different database types through a single system. This multi-functional approach allows any user to access any database in the system through the same interface, removing the need for specialized knowledge of individual database systems while dramatically reducing access time
3Loss of information
If repeated queries are sent to obtain additional information after initial data retrieval, then complete information can be obtained, but the process is time-consuming and requires waiting for query execution
Solution Approach 1:
The patent applies preliminary action by pre-establishing relationships and associations between records across databases in the unified index. When a search is performed, the system can immediately retrieve related information (such as contracts, responsible persons, and additional details) alongside the primary results, eliminating the need for sequential repeated queries and providing complete information in a single operation
Solution Approach 2:
The patent merges multiple information retrieval operations into a single unified search process. By combining primary data retrieval with associated information gathering in one coordinated operation, the system delivers complete information sets without requiring multiple separate queries, thus maintaining information completeness while dramatically reducing total retrieval time
4Adaptability or versatility
If information is presented in different formats from multiple databases, then comprehensive data coverage is achieved, but the probability of inaccurate presentation increases for non-skilled users
Solution Approach 1:
The patent applies homogeneity by standardizing the presentation format of information retrieved from multiple databases with different native formats. The system transforms diverse data sources into a unified, consistent output format that is easily interpretable by non-skilled users, thereby maintaining comprehensive data coverage while eliminating presentation inaccuracies through format standardization
Data Source
Figure 1
Figure 2
Figure 3
AI summary
The invention relates to a method for processing search queries for a plurality of unstructured relational databases, wherein each of the databases comprises preset report forms with preset record display forms in reports, the method consisting in the following: records in databases are indexed by forming a common index, and preferential record display forms are used for indexing each data record; after an initial search query is made, the query terms are converted into terms corresponding to the preferential record display forms; relevant records are searched for using the converted query terms; the preset report forms which use the relevant records found are determined; and a report is generated about the relevant records, found as a result of the search, using, to display the found relevant records, the preset report forms that use the found relevant records.