Databases are the lifeline to enterprises, hosting mission critical data of various applications. Across an enterprise, SQLOne Search can help people find, analyze, and understand structured information in ways that were never possible before. Users can now locate information quickly and easily, that was previously hidden, thus relieving them from the clutches of Database/SQL know-how. This leads to superior business benefits like higher user satisfaction, increased productivity, higher sales, and greater efficiency.
SQLOne Search, can be used to search-enable any enterprise database. Read further to understand how SQLOne can address your enterprise search needs:
|
|
Search enabling your Public (Business) Websites
Public websites are the lifeline of businesses, and in many cases, they are a business entity by themselves. They serve as the window to the world, driving revenue and business processes. An effective search into your website resources can act as your best "Front-office" executive to your customers.
Integrating SQLOne search engine into your database-driven websites, can assist your customers to find the information they require in the most effective way thus driving increased revenue, higher productivity and increased customer satisfaction.
Solution Areas: E-Commerce websites, Online Retail websites, Online Travel/Hospitality websites, Customer Service Portals, Online Directories, Online Product Catalogues, etc.
Search Portal for your Enterprise Applications
It is a known fact that searching for information on the Internet has become easier than searching within the Intranet. This elusive information could reside within scores of enterprise application databases, ranging from Knowledge Management tools to business applications like CRM, HR Management, etc. Workers are constantly challenged to effectively find and reuse the necessary business information, to leverage the enterprise infrastructure investment and drive greater productivity.
With SQLOne Search you can launch an effective, integrated Search Portal to search across your mission critical enterprise applications.
Solution Areas: Intranet, Knowledge Management, CRM systems, HR Management systems, ERP systems, Financial systems, etc.
Search Enable Packaged products
Search could be a great and essential add-on to packaged products built and sold by Independent Software Vendors (ISVs). It can serve as an effective means for users to quickly access the information stored by the application.
ISVs can integrate SQLOne search API into their packaged products based on Java/J2EE to offer a sophisticated and customized product search to end-users. This provides the multiple benefits of instant integration of powerful search, search handled by "specialist" advantage, and higher productivity/business advantage to the end-users.
Solution Areas: Any Packaged Product/Application
Database Exploration and Analysis
Data analysts, administrators and developers could immensely be benefited by the powerful search based database exploration and analysis features offered by SQLOne. This enables users to find data, analyze data model, generate SQL queries etc., all within the context of search, which alleviates the need for different tools, understanding data models of the databases and knowledge about SQLs
Features vs Usage:
- Keyword based Search: With powerful keyword based search, users can identify any information across databases. SQLOne's ability to consider relationship between tables during search and result fetching provides users a complete view of the data entity being searched.
Advanced search options like table specific search, search with special operators, date range search etc., will be a powerful add-on for focussed search and analysis.
- SQL Query Generation: Along with the search results SQLOne automatically generates SQL queries which are used to fetch the result from the corresponding tables. The generated SQL Query could be used in many ways which includes, repeated data fetching, query usage within application code, for report building, to understand where the data resides etc.,
SQLOne also provides a query execution window within the search client, which could be used to execute the queries and verify the data.
- Data Model Analysis: SQLOne provides the structure details of the matching table from which the result data is fetched. It also provides a relationship diagram to show the related tables and how they are related with the matching table. Users could use this information to understand how the database is modeled and where the data resides.
For unmodeled databases (where primary and foreign keys are not defined for tables), the details provided by SQLOne could be used as a valuable information to remodel the database. For such databases SQLOne applies advanced heuristics to identify probable primary and foreign keys. SQLOne uses this information during search and result fetching. This information derived purely based on the existing data that is stored, could be used as an effective tool for remodeling.
All the above features are provided to users from within the simple search client interface, which makes it all the more powerful and useful for analysis.
|
