Release DBMS InterSystems Caché 2016.1
Hello! We are glad to present you a new version of Caché 2016.1, which was released in the second half of March. There are really many important and interesting changes, so I suggest to go straight to them.
A complete and detailed list of changes is available here: Caché 2016.1 Release Notes
The first and long-awaited innovation is improved performance and new mechanisms for working with JSON in Caché.
')
JSON parsing is now implemented in Caché at the kernel level, which has significantly improved performance when working with large volume JSON. And the replacement of% ZEN.ProxyObject, which was previously used to work with JSON, came with the new dynamic objects% Object and% Array, which are more efficient and convenient when writing code.
Example:
More information can be found in the article by Eduard Lebedyuk on Habré and in the article by Stefan Wittmann on our Developer Community.
Go ahead. The next major change in Caché 2016.1 is the improved performance of SQL execution. InterSystems is constantly working to improve SQL access in Caché, and this release is no exception:
Next on the list is Business Intelligence. Caché 2016.1 introduces new REST services for accessing the DeepSee engine. Services are intended for receiving data of pivot tables and execution of MDX queries with returning the result in the form of JSON. Various information services are also available for obtaining lists of DeepSee cubes, summary tables, and various information about cubes (Dimensions, Members of Cubes (Members), Measures (Measures), etc.).
For JavaScript developers, the good news is that this release also includes a JavaScript library that provides access to DeepSee REST services.
More information can be found in the documentation for Caché 2016.1 in the section " Tools for Creating DeepSee Web Clients ".
This does not end the changes in DeepSee! List of the most important of them:
The technology for working with text in natural language iKnow also received updates: iKnow Architect, added to provide the user with a convenient way to manage iKnow-domains, was added to the System Management Portal; In addition, support for Swedish and Japanese has been added.
The ZEN Mojo web framework has received support and fairly tight integration with Twitter Bootstrap. More information can be found in the documentation, in the " Helper Plugin for Bootstrap " chapter in the " Using Zen Mojo Plugins " section.
Caché also added support for .NET Entity Framefork (versions 5 and 6), which should rejoice .NET developers working with Caché. As always, all the details can be found in the documentation, in the " Using the Caché Entity Framework Provider " chapter of the " Using .NET and the ADO.NET Managed Provider with Caché " section.
Of the other important changes:
This is not all changes in Caché 2016.1. I remind you that the full list of changes can be found on the link .
Thank you for your attention and to new releases!
A complete and detailed list of changes is available here: Caché 2016.1 Release Notes
Improved JSON support
The first and long-awaited innovation is improved performance and new mechanisms for working with JSON in Caché.
')
JSON parsing is now implemented in Caché at the kernel level, which has significantly improved performance when working with large volume JSON. And the replacement of% ZEN.ProxyObject, which was previously used to work with JSON, came with the new dynamic objects% Object and% Array, which are more efficient and convenient when writing code.
Example:
set object = { "firstName": "Sergey", "lastName": "Sarkisyan", "age": 22 } set array = [ 1, 2, "string", true ] do array.$push("InterSystems").$push("Caché").$push("2016.1") write array.$toJSON() => [ 1, 2, "string", true, "InterSystems", "Caché", "2016.1" ] More information can be found in the article by Eduard Lebedyuk on Habré and in the article by Stefan Wittmann on our Developer Community.
SQL enhancements
Go ahead. The next major change in Caché 2016.1 is the improved performance of SQL execution. InterSystems is constantly working to improve SQL access in Caché, and this release is no exception:
- Performance optimization for xDBC server code.
- Improving the performance of SQL queries. In this release, the SQL query handler generates more efficient code for most common SQL operations.
- Improved ability to undo operations.
DeepSee REST
Next on the list is Business Intelligence. Caché 2016.1 introduces new REST services for accessing the DeepSee engine. Services are intended for receiving data of pivot tables and execution of MDX queries with returning the result in the form of JSON. Various information services are also available for obtaining lists of DeepSee cubes, summary tables, and various information about cubes (Dimensions, Members of Cubes (Members), Measures (Measures), etc.).
For JavaScript developers, the good news is that this release also includes a JavaScript library that provides access to DeepSee REST services.
More information can be found in the documentation for Caché 2016.1 in the section " Tools for Creating DeepSee Web Clients ".
This does not end the changes in DeepSee! List of the most important of them:
List of changes
- Parallel DeepSee Cube Synchronization - % SynchronizeCube can now use multiple DeepSee agents to simultaneously update cubes.
- Common calculated members of cubes - the calculated members defined in the Analyzer can now be available for other pivot tables from the same cube. Details can be found in the " Defining Calculated Elements " chapter of the " Using the DeepSee Analyzer " section of the documentation.
- Detailed lists, depending on the indicators - now for the Indicator you can specify a detailed list (Listing), which will be displayed when receiving detailed information about the cell containing the data of this Indicator.
- Analyzer and Architect now allow you to resize interface panels.
- New system methods for receiving and executing MDX queries of pivot tables (Details can be found in the documentation of the class% DeepSee.Utils ):
- % GetMDXFromPivot () - returns the text of the MDX request of the pivot table. Optionally executes the request.
- % ExecutePivot () - performs a pivot table request. Optionally returns associated with table% DeepSee.ResultSet
- % GetResultSetFromPivot () - returns% DeepSee.ResultSet for the pivot table. Optionally executes the request.
- % GetMDXFromPivot () - returns the text of the MDX request of the pivot table. Optionally executes the request.
- Ability to specify additional filtering options for detailed lists when using plugins - plugins provide the ability to define your own Indicators in DeepSee. In previous versions, the detailed lists from the plugin always showed all the lines that were used to calculate the Indicator. This release adds the ability to limit such detailed lists to a specific subset of lines.
- The new% OnAfterBuildCube method - in addition to the existing ability to define logic before building a cube, added a similar ability to define its own logic after construction.
- New $$$ VARIABLES token - DeepSee has a new $$$ VARIABLES token that can be used when accessing dashboards by URL. This token will be replaced with the value of the corresponding variable of the pivot table. Example: someURL & someVARIABLE = $$$ VARIABLES will replace $$$ VARIABLES with the value of the variable someVARIABLE. For more information, see the " Accessing Dashboards from Your Application " chapter in the " DeepSee Implementation Guide " documentation.
- Filter by date and first day of the week - now when using the filter by date, the system settings of the first day of the week are taken into account.
InterSystems iKnow
The technology for working with text in natural language iKnow also received updates: iKnow Architect, added to provide the user with a convenient way to manage iKnow-domains, was added to the System Management Portal; In addition, support for Swedish and Japanese has been added.
Zen mojo
The ZEN Mojo web framework has received support and fairly tight integration with Twitter Bootstrap. More information can be found in the documentation, in the " Helper Plugin for Bootstrap " chapter in the " Using Zen Mojo Plugins " section.
.NET Entity Framework
Caché also added support for .NET Entity Framefork (versions 5 and 6), which should rejoice .NET developers working with Caché. As always, all the details can be found in the documentation, in the " Using the Caché Entity Framework Provider " chapter of the " Using .NET and the ADO.NET Managed Provider with Caché " section.
Other changes
Of the other important changes:
- Improved performance and reduced network load when using mirroring.
- Support for larger TCP windows has been added, which should improve throughput between the nodes of the mirror with a large delay.
- This release includes the Open SSL version 1.0.1p library.
- Improved audit reliability (by adding mandatory journaling of the audit base).
- Added Windows x64 support for Apache 2.4.
- ECP application servers began to cache long strings. Various improvements in performance, scalability and security.
This is not all changes in Caché 2016.1. I remind you that the full list of changes can be found on the link .
Thank you for your attention and to new releases!
Source: https://habr.com/ru/post/281062/
All Articles