Search Modeling Tool for Enterprise Data Extraction
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Enterprise systems face challenges in searching and accessing data stored in relational databases, as data is often normalized and distributed across multiple tables, making it difficult for users to perform direct text searches or context-related manipulations.
Innovation Solution
A search modeling tool that communicates with multiple enterprise applications to create object definitions describing searchable data, allowing for extraction and manipulation of data in formats usable for text searching and user presentation, using common protocols to interface with various applications.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of substance
If data is stored in normalized form across multiple database tables to reduce redundancy, then data storage efficiency is improved, but data accessibility for text searching deteriorates
Solution Approach 1:
The patent introduces an intermediary layer (search interface, data extraction module) between the normalized database and the search function. This intermediary retrieves data from multiple normalized tables, reconstructs it into searchable formats, and presents it to users, thereby maintaining database normalization while enabling effective text searching without direct user access to complex table structures
Solution Approach 2:
The patent creates copies of normalized data in alternative formats optimized for searching. By extracting and reconstructing data from normalized tables into searchable representations (such as concatenated text fields or search indexes), the system enables text searching without modifying the underlying normalized database structure, thus preserving storage efficiency while improving search accessibility
2Measurement precision
If structured queries are used to extract data from normalized tables, then data extraction accuracy is improved, but search flexibility and user-friendly access deteriorate
Solution Approach 1:
The patent segments the search functionality into distinct modules: a structured query generation component that ensures accurate data extraction from normalized tables, and a flexible interface component that provides user-friendly search capabilities. This segmentation allows the system to maintain extraction precision through structured queries while offering versatility through multiple search modes (keyword, natural language, Boolean) at the user interface level
Solution Approach 2:
The patent implements dynamic query generation that adapts to different search types. Based on user input (keyword, natural language, or Boolean), the system dynamically constructs appropriate structured queries tailored to each search mode while maintaining accuracy in data extraction from the normalized database structure
3Ease of operation
If direct database access is allowed for text searching, then search capability is improved, but system performance and stability deteriorate
Solution Approach 1:
The patent extracts the search functionality from the core enterprise application system. By implementing a separate search module that interfaces with the database through controlled access points, the system enables text searching without allowing direct user access to the database. This extraction isolates search operations from the main system, preventing performance degradation while maintaining search capability
Data Source
AI summary
A search modeling tool is provided that can communicate with multiple enterprise applications to create object definitions describing searchable data stored in each application. The object definitions may be used to extract searchable data from the applications, thus allowing for manipulation of the data in formats usable for text searching, user presentation, and other applications. The search modeler may interface with each application using common protocols, allowing for generalization of object definitions and subsequent crawling across a variety of enterprise applications.