Login  |  Register
E-mail:
Password:
Forgot your password?
E-Mail:

Authorization

DBMS Linter Modifications List of 2008

16.01.2009

Technical modifications in various components of the basic Linter versions:

General Changes

  • Interfaces for Python (significantly enhanced) and Ruby (new)
  • ADO.NET 2.0 interface
  • Program interface for managing the DBMS kernel, backup server and other utilities
  • Functionality for integrating the .NET-provider with Microsoft Visual Studio 2005 and 2008

LINPHP Interface

  • Option for fetching BLOB field values in the same way as for other field types (CO_FETCH_BLOBS_AS_USUAL_DATA)
  • Fetching BLOB values from a cursor returned by a stored procedure
  • BIND for BLOB values added
  • Work with the database optimized by removing extra calls
  • Possibility to set transformation of parameters via a php.ini file
  • New interfaces PDO and ADO
  • New PHP versions (5,6) now supported

Full Text Search System

  • Construction for building attributive indices implemented: <CREATE [OR REPLACE] PHRASE XML INDEX Column ON Table;>
  • Automatic selection of filter by file contents or BLOB value
  • Indexed document secrecy tabs now supported
  • /PPOOL key added for DBMS kernel start and setting the phrase index creation buffer size
  • New filter for UTF-8 documents added
  • Filters, sorting algorithms and main memory use optimized

LinDeskX Utility

  • Automatic database connection added
  • SNMP agent and remote database management enabled
  • Event mechanism added

INL Utility

  • Column encoding information can be displayed
  • ECHO {ON|OFF|ERROR} command added

SQL and Stored Procedure Language

  • Regular expression search added (SIMILAR predicate and SUBSTRING( ... SIMILAR ... ESCAPE ...) function)
  • Stored events added
  • NOW, CONCAT, and UNIX_TIMESTAMP functions added for compatibility with MySQL
  • FROM_DAYS function added
  • LEAD and LAG functions added, with syntax similar to those in Oracle (OVER (PARTITION BY ... ORDER BY...) construction)
  • EXTRACT function for working with date fields added
  • VSIZE function returning the number of bytes in the argument internal view added
  • Sub-queries allowed in the left part of the IN and NOT IN predicates, equalities and inequalities
  • Sub-queries allowed in a SELECT list (with some limitations)
  • Non-constant templates allowed in LIKE and NOT LIKE predicates
  • Expressions in lists allowed in the right part of the IN and NOT IN predicates
  • Empty list in the right part of the NOT IN predicate allowed
  • Duplicate column names in sub-queries allowed
  • ORDER BY construction allowed in sub-queries (makes sense in combination with ROWNUM construction)
  • BOOLEAN expressions allowed (in a SELECT list; in INSERT in VALUES list; in UPDATE after =; in GROUP BY; in ORDER BY)
  • Reference of an external character key to a primary key of the same type but different length allowed
  • LINTER_SYSTEM_USER pseudo-value returning the numeric ID of the current user added
  • CORRECT INDEX and CORRECT BITMAP commands added to make minor corrections to the table structure
  • Commands for temporary reference integrity prohibition added
  • SORT {DATA|INDEX} hint added for sorting method selection management
  • UNION/INTERSECT/EXCEPT operation result command naming modified
  • Commands for deleting the source code of stored procedures and triggers from the database added
  • BY APPEND modifier allowed at the end of ALTER TABLE ADD PRIMARY KEY, ALTER TABLE ADD UNIQUE, ALTER TABLE ADD FOREIGN KEY (creating an index by successively adding elements, not by sorting)
  • SLEEP function for stored procedures added
  • Transaction support added to the stored procedure language
  • OVER ([PARTITION BY : ORDER BY ...) construction for agregate functions now supported (partial support of SQL2003 analytical capabilities)
  • Conversion of an inequality predicate pair to a range search predicate optimized
  • Calculation of complex queries with several AND and OR predicate junctions optimized
  • Time quantization of queries implemented to enhance execution of parallel queries

DBMS Kernel

  • Kernel interface enhanced to support new startup parameters
  • Multilanguage assembly for Windows CE revised
  • Automatic authentication for UNIX added
  • Detailed information about loaded page types shown during startup with the /trace=decomp key
  • UNION ALL query execution optimized
  • Sorting optimized using hash search of pages in the sorting pool
  • /IGNERROR kernel start key added to ignore database recovery errors
  • New columns added to the $$$CHAN information table: BASE_PRIORITY - channel priority, QUERY_PRIORITY - current query priority, CURRENT_PRIORITY - current execution quantum priority
  • Index structure testing by TEST TABLE command (and TESTDB utility) optimized
  • Parallel processing of several SELECT queries optimized
Main | Back to the list
ѕрокрутить вверх