DBSight Changelog

What's new in DBSight 4.3.22

Nov 11, 2013
  • This release fixes log analyzing exceptions when starting up.

New in DBSight 4.3.21 (Oct 21, 2013)

  • This release adds an option to customize facet search to use the Boolean operator OR.

New in DBSight 4.3.20 (Jul 1, 2013)

  • This version fixes a racing condition bug on Windows.

New in DBSight 4.3.19 (May 13, 2013)

  • Avoids exceptions during JSON embedded search when column names have uppercase characters.

New in DBSight 4.3.18 (Jan 8, 2013)

  • A major focus on improving robustness for managing the separated search process, including ensuring index replication works even when the index is updated, avoiding index replication notification noises from other dbsight systems, and each index takes a fixed 2 ports instead of sharing the ports.
  • An error in iPhone search result scaffolding has been fixed.

New in DBSight 4.3.17 (Nov 26, 2012)

  • This version adds an option to default to a specific sortBy column.
  • It has a fix to clean up HTTP connections cleanly.

New in DBSight 4.3.16 (Nov 13, 2012)

  • This version adds compression for more efficient index replication and adds protection for index data file correctness.

New in DBSight 4.3.15 (Oct 15, 2012)

  • This version will always merge an index when the merge threshhold is set to 0.
  • It avoids an NPE during search suggestion.

New in DBSight 4.3.14 (Aug 21, 2012)

  • This version optimizes parameter types to increase incremental SQL execution performance.

New in DBSight 4.3.13 (Jul 3, 2012)

  • This version adds index freshness and scheduling information to the front page.

New in DBSight 4.3.9 (May 15, 2012)

  • This version adds File Fetcher to search files on the local disk and passes the timeout from the search API to the connection to the searchers.

New in DBSight 4.3.8 (May 8, 2012)

  • This version adds efficient real-time statistics for top popular queries.
  • It fixes exceptions in the log when running with Tomcat.

New in DBSight 4.3.7 (Apr 17, 2012)

  • This version adds an email-style list-detail layout option to the datagrid scaffold.
  • It adds a jQuery UI theme to the narrow by(facet) section scaffold.

New in DBSight 4.3.4 (Mar 20, 2012)

  • This version adds Data Grid scaffolding including: themes, grid data representation, slide-in detail page, collapsible facet search, search suggestion, full-screen mode, and CSV export.
  • There are many bells and whistles.
  • An NPE with pre-defined data sources has been resolved.
  • There are other minor textual adjusts.

New in DBSight 4.3.0 (Dec 19, 2011)

  • This version fixes a highlighting issue when time-based ranking is enabled, and adds basic authentication to the search API.

New in DBSight 4.2.7 (Jul 25, 2011)

  • Search result scaffolding added Excel output format.

New in DBSight 4.2.6 (Jul 19, 2011)

  • This version supports multiple patterns for remote access security checking.
  • Directory listing has been disabled due to security concerns.

New in DBSight 4.2.5 (Jul 11, 2011)

  • Robustness was increased with automatic recovery from disconnected search servers.
  • Range search precision was increased for large integers.

New in DBSight 4.2.2 (Jun 20, 2011)

  • A note to the dashboard for skipped tasks to avoid multiple index creation scheduled at the same time has been added.

New in DBSight 4.2.1 (Jun 6, 2011)

  • This version focuses on index job scheduling and timing for load balancers to switch between servers when servers are busy indexing.
  • It avoids backlogging indexing jobs running on the same index.
  • It avoids indexing starting at the same moment.
  • It adds status notification via ping before and after each indexing job.
  • It corrects the index swapping sequence for zero search gap.
  • It updates the quartz library.

New in DBSight 4.2.0 (May 23, 2011)

  • Added an embeddable continuous scroll widget.
  • Added customizable port range for searching processes to use.
  • Enabled a single character word as part of a phrase.
  • Added Google Map API Key to Google Map Scaffolding.

New in DBSight 4.1.9 (Apr 5, 2011)

  • Indexing was made much faster for large indexes.

New in DBSight 4.1.3 (Feb 8, 2011)

  • This version adds an embeddable Javascript library to add search UI to any page via JSONP.
  • Dynamic sorting now supports simpler syntax for each column.
  • A facet search display order bug has been fixed.
  • Facet search for integers has been fixed.
  • A facet result sorting order bug has been fixed.
  • This release has much more efficient pagination for single-shard search.

New in DBSight 4.1.1 (Jan 24, 2011)

  • This version adds an option to disable narrowBy(facet) search.
  • It automatically supports JSONP callback by setting the content type and encoding to JSON data.

New in DBSight 4.0.9 (Jan 10, 2011)

  • Support for decimal range facet search was added.
  • Support for float type for sum or average columns was added.
  • Search timeout was fixed to 60 seconds in distributed mode.
  • The precision of the sum() and average() functions for facet search was increased.

New in DBSight 4.0.8 (Dec 20, 2010)

  • This version adds support for database fields with Unix time in seconds.
  • It adds the parameter facetLimit to control the number of facet counts for improving performance when the number of facet counts is large.

New in DBSight 4.0.7 (Dec 13, 2010)

  • An API for a customized fetcher to submit files directly has been added.

New in DBSight 4.0.6 (Dec 6, 2010)

  • The date storage format was changed to support a wider range of dates.
  • An option was added to set dynamic selectable columns to transmit only required columns for more performance.
  • Language support was added for Danish, Finnish, Hindi, Hungarian, Indonesian, Italian, Norwegian, Romanian, Swedish, Spanish, and Turkish.

New in DBSight 4.0.5 (Nov 29, 2010)

  • This version adds a FreeMarker syntax online editor to modify the search result template.
  • It adds automatic detection and adjusts the default heap size for 32 and 64 bit JVMs.

New in DBSight 4.0.4 (Nov 22, 2010)

  • This version fixes a minor display issue on the dashboard page.
  • The XML configuration format has been transparently upgraded to prepare for future new features.

New in DBSight 4.0.3 (Oct 25, 2010)

  • Collect and display status for each remote searcher instance.
  • Improved throughput performance by optimizing and reusing HTTP connections.
  • Displaying values with the same column names has been fixed.
  • A score is added to each result during sorting.

New in DBSight 4.0.2 (Oct 18, 2010)

  • This version properly releases a used port number after each index update to ensure resource reuse.
  • Range query under distributed search mode was fixed.

New in DBSight 4.0.1 (Oct 11, 2010)

  • This release separates out the searching as a different operating system process.
  • This eliminates Java stop-the-world Global Garbage Collection, improves performance by avoiding memory fragmentation, and ensures greater scalability for a single node.
  • Other major features includes automatically re-ranking facet searches according to usage, and role-based access control for role-specific contents.

New in DBSight 3.3.0 (Oct 5, 2010)

  • Multi Index Search mode automatically searches all indexes with non-negative display order.
  • A facet search caching error for some specific searches was fixed.

New in DBSight 3.2.9 (Sep 27, 2010)

  • This release will automatically take a thread dump for hanging indexing processes.
  • It fixes a IBM JDK threading issue for indexing.
  • It fixes a search exception after updating content directly via Submit API.

New in DBSight 3.2.8 (Sep 20, 2010)

  • For the Chinese, Japanese, and Korean languages, full-width form Latin words are automatically converted to half-width form to match words in the index.

New in DBSight 3.2.7 (Sep 13, 2010)

  • This release adds gzip and deflate compression for sharded search and the Java search API.
  • It improves the Average function for each facet search.
  • It avoids a connection timeout issue via round robin connection reuse.
  • It will properly release the spell checker reader to avoid a file deletion error.

New in DBSight 3.2.6 (Aug 23, 2010)

  • Memory efficiency was improved by more than 75% for a single valued facet search.
  • A facets counting error caused by zero-valued boosting was fixed.

New in DBSight 3.2.5 (Aug 16, 2010)

  • Added iPhone scaffolding.
  • An option was added to skip a facet search that has only one entry.
  • A parameter to control the Lucene query boolean operator was added.
  • Facet cache performance was improved.
  • Wildcard search was fixed.
  • A negative-only query was fixed.

New in DBSight 3.2.4 (Aug 2, 2010)

  • This version improves memory efficiency by reducing memory usage for sparse valued facet search.
  • It adds index name and remote host name for multi index search and shard search to render results differently.
  • It fixes possible NULL valued primary key cases during the indexing process.
  • dbsight's jar file locations are displayed in the system report page to avoid possible duplicated jar files in the classpath.

New in DBSight 3.2.3 (Jul 19, 2010)

  • This version adds an adapter to crawl and synchronize data on SalesForce.com and create full text searches on the data.
  • It adds an option to optimize the index after indexing.
  • API changes: an API for a customizable fetcher to delete old records has been added.

New in DBSight 3.2.2 (Jul 12, 2010)

  • Sharded Search is added so that users can automatically combine results from distributed search nodes, with correct weight and ranking calculated.
  • Facet search and pagination still works during sharded search mode.

New in DBSight 3.0.3 (Mar 8, 2010)

  • The number of search results explained via debug option is now adjustable.
  • Option to switch between default Lucene parser and ComplexPhraseQueryParser is added.
  • Improve performance and Removing 255 length limit for CommaSemicolonExtendedAnalyzer.
  • Fix displaying error when show content via primary key column.

New in DBSight 3.0.2 (Mar 8, 2010)

  • Fix exception when using Synonyms and Reserved Words to analyze content.
  • CommaSemicolonExtendedAnalyzer can work well during searching.

New in DBSight 3.0.1 (Mar 8, 2010)

  • Configurable Query Timeout is added to handle query timeout to avoid non-responding database connections.

New in DBSight 3.0.0 (Mar 8, 2010)

  • Lucene 3.0 compatible.
  • Freemarker template is added to Facet Search definition xml file.
  • Facet Types Editing Window is added.
  • Synonyms and Stop Words are configured individually.
  • Avoid overwriting reserved, spell_check, stopwords, synonyms file.
  • Configurable Reserved Words is added.
  • Update POI library to process Word Doc, Excel, and PowerPoint files.

New in DBSight 2.2.1 (Mar 8, 2010)

  • IKAnalyzer is added for better support for international language, especially Chinese, and customizable dictionary.
  • Added DBSight version to index configuration file.
  • Incremental Indexing Sql improves performance by not requiring order by modified date.
  • Sum and Avg for any field is added in facet search results.

New in DBSight 2.1.9 (Oct 12, 2009)

  • An old history data reading error is ignored.

New in DBSight 2.1.8 (Sep 29, 2009)

  • Paginated SQL retrieval for PostgreSQL result sets has been added.
  • Single Valued Facet warm up has been added when updating new indexes.
  • Configuration loading exception has been fixed.

New in DBSight 2.1.3 (May 11, 2009)

  • Added support for time before 1970. Need to re-create index when upgrading.
  • Shutdown hanging with tomcat is fixed.
  • Fix Scaffolding error.
  • Removed hard coded indexing log level.

New in DBSight 2.1.1 (Mar 23, 2009)

  • JSONP scaffolding was added.
  • Result-Per-Page partial scaffolding was added.
  • The Spell Checking suggestion is avoided if a field query is included.
  • The User Input value was added to the SearchResult.
  • A configurable number of NarrowBy (Facet Search) choices was added.
  • The SqlServer Driver name was fixed.
  • The page for empty results was fixed.
  • NarrayBy in boolean operartor OR mode was fixed.
  • Boosting a document by a value was fixed.
  • PatternSyntaxException of Advanced Incremental SQL was fixed.

New in DBSight 2.1.0 (Mar 2, 2009)

  • Multiple-Choice Partial Scaffolding was added.
  • Suggest-as-you-type now works for 1 character also.
  • Column-specific partial scaffolding was added so that it can be applied several times.
  • Scaffolding now can be applied to subdirectories.
  • Performance for spell checking dictionary generation was greatly improved for large indexes.
  • Performance for deletion detection was greatly improved and efficient.
  • Different versions of the same jdbc drivers can be used.
  • Multiple-Choice Query was added.
  • Scaffolding for RSS syndication was fixed.
  • A problem in which jQuery.js was included twice was fixed.

New in DBSight 2.0.9 (Feb 9, 2009)

  • Support for negative-only queries has been added.
  • There is an additional directory to store customized scaffolding. Hierarchical date search has been added.
  • More memory-efficient duplication checking.
  • Direct Lucene querying in the search API has been added.
  • Hierachical facet search link has been improved to handle child filtered columns.
  • The delete action also deletes buffer index entries.
  • Performance has been improved by skipping empty buffer indexes.
  • The Jgroups dependency has been removed to simplify license checking.

New in DBSight 2.0.8 (Jan 12, 2009)

  • Numeric range search with inclusive/exclusive on both ends is added.
  • Deletion SQL choice with incremental indexing is made clearer.
  • Multiple schedules can be added/changed/deleted.
  • The Lucene library is updated to latest release.
  • Buffer Index can selectively update a specific index field.
  • Buffer index cache flushing is resolved.
  • Configurable email notification for indexing processes is added.
  • AJAX Search Suggestions partial scaffolding is added.
  • HA Cluster mode support subscribing incremental index changes and a spell-check index.
  • Tag cloud generation via partial scaffold is streamlined.

New in DBSight 2.0.7 (Dec 29, 2008)

  • This release adds an option to schedule deletion detection for incremental indexing.
  • It adds a customizable fetcher for data sources other than databases.
  • It adds job scheduling for the spell check dictionary.
  • It fixes a possible format error for the period table.
  • It fixes problems handling negative queries like "night -title:sky".

New in DBSight 2.0.6 (Dec 8, 2008)

  • This release adds multiple scheduling for the same index.
  • It includes counting integer zeros for facet searching.
  • It improves numeric facet search by adding open-ended ranges.
  • A bug related to reading float numbers into integers has been fixed.
  • Caching has been added for multi-row queries.
  • Batching has been added for multi-row queries.

New in DBSight 2.0.5 (Nov 17, 2008)

  • This release adds index-specific spell checking.
  • It fixes highlighter highlighting without summarizing.
  • It adds optional classpath for indexing to resolve a Tomcat jsdk classpath issue.
  • It simplifies narrowBy rendering logic.
  • It improves search performance by optimizing on Facet Search.

New in DBSight 2.0.4 (Nov 10, 2008)

  • This release improves search performance by avoiding repeatedly loading configuration files.
  • It defaults to getting an auto-commit database connection to avoid extra setAutoCommit operations.
  • It fixes incorrect error reporting for BufferIndex submit.do.

New in DBSight 2.0.2 (Oct 27, 2008)

  • This release improves search performance by avoiding repeatedly loading configuration files.
  • It defaults to getting an auto-commit database connection to avoid extra setAutoCommit operations.
  • It fixes incorrect error reporting for BufferIndex submit.do.

New in DBSight 2.0 (Oct 6, 2008)

  • A new Scaffolding Engine for more flexible result page rendering has been added.
  • Developers can create customized re-usable scaffolding.
  • A Tag cloud scaffold has been added.
  • It is easier to add JDBC libraries.
  • The performance of SQL retrieval has been greatly enhanced by batching SQL.

New in DBSight 1.6.0 (Sep 15, 2008)

  • This release fixes Lucene memory leaking when refreshing the index in memory-only mode.
  • It adds configurable max field length.
  • It can process an empty query by matching all documents in multi-index search mode.
  • It handles SqlServer special empty or all zero date time format.