DBMS InterSystems Caché 2014.1. Release notes
March 25, 2014 released the release of the DBMS Caché 2014.1. What is your version?
Functional development
Performance improvements
More about this and much more under the cut.
Starting with the 2014 version, Caché supports the handling of REST requests at the CSP Gateway level. To support a web application of a REST interface, you need to define a handler class, which, using the built-in URL matching tool, will transfer the call to the required class and method.
At the level of data transfer between the client (browser) and the database server, XML and JSON are supported.
An example of building a REST application in Caché is considered in Habré .
This innovation concerns the Caché NoSQL component — the Globals API, which allows you to work with Caché stored globals — most quickly and directly. To the existing Java, Node JS and C # API added Globals C API. In particular, this allows you to work with data in Caché and GlobalsDB directly from C and C ++ applications, such as Ruby, for example.
')
This release adds support for UDP sockets, which is implemented through the% Net.UDP class. The class allows interaction with the Caché server without connection support.
More information in the documentation of the class% Net.UDP .
In this version of Caché, support has been added for a single model of triggers that work for both object and SQL access for INSERT / UPDATE / DELETE events. New class triggers, however, do not cancel the existing% OnXXX callback family for object access: all these calls will continue to work and be supported.
This release supports the new SQL command, INSERT OR UPDATE. It works as an INSERT, but if the UNIQUE constraint for the inserted record is triggered, UPDATE is executed instead of INSERT. This innovation will be useful for cases when only one record with a certain value of a unique index is possible in the table, and instead of checking the existence of a record and further INSERT or UPDATE, you can use one SQL command INSERT OR UPDATE.
More details .
There was a utility for diagnosing the performance of MDX queries for OLAP solutions on DeepSee. If you have any questions about the performance of MDX queries using the % DeepSee.Diagnostics.MDXUtils utility, you can now collect all the necessary diagnostic information and send it to InterSystems support service.
Documentation
New component in BI technology InterSystems DeepSee.
Cube Manager provides a user-defined, web-based interface for defining cubes to groups in large BI solutions and schedule rebuilding and updating of cubes.
Cube Manager can be found in the DeepSee tab.
Model Browser allows you to visually see the connections between dependent cubes.
Details .
The performance of transaction rollbacks on TROLLBACK increased by 20% -40%. Improvement concerns both single long transactions, and mass cancellations of transactions at recovery from the log.
TuneTable calculates the selectivity (percentage) for each property. Selectivity is based on the assumption that values are evenly distributed. For example, in a table with a list of people, any particular birthday will appear in 0.27% of the data (1 time out of 365).
Starting from this version, for one value that occurs much more often than the others, the so-called Outlier Selectivity will be calculated, and for other values, the usual selectivity will be calculated. For example, if one value occurs 75% of cases, and the remaining 20 to 25 percent, then the selectivity will be calculated as (100% -75%) / 20 = 1.25%.
The most popular case of a value out of uniform distribution is NULL. If the number of entries with a NULL value significantly exceeds the number of the remaining values, then NULL is a statistical outlier and the OutlierSelectivity will be calculated for it.
Article in the documentation .
In this version, the functionality for defragmentation and compression of databases is again available.
The compression utility - moves unallocated space to the end of the file, as a result, the database file can be reduced by the amount of empty space.
Defragmenting globals - the utility redistributes the block locations for the global into databases in an incremental sequence, which results in a slight increase in performance during a sequential walkdown of the global.
More details .
Also starting with Caché 2014, two new promising InterSystems technologies are supported: Zen Mojo and Enterprise Manager.
Enterprise Manager (EM) is a product for effectively managing a large number of Caché and Ensemble installations. EM allows you to conveniently perform uniform configuration changes (for example, web application security settings, role and user management, or global mapping) simultaneously on multiple servers or server groups, which simplifies administration and minimizes errors.
Zen Mojo is a framework for rapid development of mobile and web applications with responsive design using popular JS frameworks (Dojo, jQuery, etc.). The release of Zen Mojo releases is not tied to Caché releases, and already today, the Zen Mojo version 1.06 is available for download to WRC customers and partners of InterSystems.
About Zen Mojo and Enterprise Manager will be separate detailed posts - stay tuned.
The full text of the Release Notes can be found here.
Functional development
- REST support;
- Globals C API;
- UDP support;
- Caché SQL development;
- Enterprise Manager support;
- DeepSee Cube Manager;
- common model of triggers for objects and SQL.
Performance improvements
- TROLLBACK performance up to 40%.
- MDX performance diagnostics.
- Improved query performance with UNION and improvements in Tune Tables.
- Defragmentation and compression of Caché databases.
More about this and much more under the cut.
REST support
Starting with the 2014 version, Caché supports the handling of REST requests at the CSP Gateway level. To support a web application of a REST interface, you need to define a handler class, which, using the built-in URL matching tool, will transfer the call to the required class and method.
At the level of data transfer between the client (browser) and the database server, XML and JSON are supported.
An example of building a REST application in Caché is considered in Habré .
Globals C API
This innovation concerns the Caché NoSQL component — the Globals API, which allows you to work with Caché stored globals — most quickly and directly. To the existing Java, Node JS and C # API added Globals C API. In particular, this allows you to work with data in Caché and GlobalsDB directly from C and C ++ applications, such as Ruby, for example.
')
UDP support
This release adds support for UDP sockets, which is implemented through the% Net.UDP class. The class allows interaction with the Caché server without connection support.
More information in the documentation of the class% Net.UDP .
Unified model for handling triggers for objects and SQL
In this version of Caché, support has been added for a single model of triggers that work for both object and SQL access for INSERT / UPDATE / DELETE events. New class triggers, however, do not cancel the existing% OnXXX callback family for object access: all these calls will continue to work and be supported.
New command in SQL: INSERT OR UPDATE
This release supports the new SQL command, INSERT OR UPDATE. It works as an INSERT, but if the UNIQUE constraint for the inserted record is triggered, UPDATE is executed instead of INSERT. This innovation will be useful for cases when only one record with a certain value of a unique index is possible in the table, and instead of checking the existence of a record and further INSERT or UPDATE, you can use one SQL command INSERT OR UPDATE.
More details .
MDX Performance Diagnostics
There was a utility for diagnosing the performance of MDX queries for OLAP solutions on DeepSee. If you have any questions about the performance of MDX queries using the % DeepSee.Diagnostics.MDXUtils utility, you can now collect all the necessary diagnostic information and send it to InterSystems support service.
Documentation
DeepSee Cube Manager
New component in BI technology InterSystems DeepSee.
Cube Manager provides a user-defined, web-based interface for defining cubes to groups in large BI solutions and schedule rebuilding and updating of cubes.
Cube Manager can be found in the DeepSee tab.
Model Browser allows you to visually see the connections between dependent cubes.
Details .
Increase Rollback performance
The performance of transaction rollbacks on TROLLBACK increased by 20% -40%. Improvement concerns both single long transactions, and mass cancellations of transactions at recovery from the log.
Support for separate calculation of selectivity property for values - emissions (outliers)
TuneTable calculates the selectivity (percentage) for each property. Selectivity is based on the assumption that values are evenly distributed. For example, in a table with a list of people, any particular birthday will appear in 0.27% of the data (1 time out of 365).
Starting from this version, for one value that occurs much more often than the others, the so-called Outlier Selectivity will be calculated, and for other values, the usual selectivity will be calculated. For example, if one value occurs 75% of cases, and the remaining 20 to 25 percent, then the selectivity will be calculated as (100% -75%) / 20 = 1.25%.
The most popular case of a value out of uniform distribution is NULL. If the number of entries with a NULL value significantly exceeds the number of the remaining values, then NULL is a statistical outlier and the OutlierSelectivity will be calculated for it.
Article in the documentation .
Defragmentation and compression: works again!
In this version, the functionality for defragmentation and compression of databases is again available.
The compression utility - moves unallocated space to the end of the file, as a result, the database file can be reduced by the amount of empty space.
Defragmenting globals - the utility redistributes the block locations for the global into databases in an incremental sequence, which results in a slight increase in performance during a sequential walkdown of the global.
More details .
Zen Mojo and Enterprise Manager
Also starting with Caché 2014, two new promising InterSystems technologies are supported: Zen Mojo and Enterprise Manager.
Enterprise Manager (EM) is a product for effectively managing a large number of Caché and Ensemble installations. EM allows you to conveniently perform uniform configuration changes (for example, web application security settings, role and user management, or global mapping) simultaneously on multiple servers or server groups, which simplifies administration and minimizes errors.
Zen Mojo is a framework for rapid development of mobile and web applications with responsive design using popular JS frameworks (Dojo, jQuery, etc.). The release of Zen Mojo releases is not tied to Caché releases, and already today, the Zen Mojo version 1.06 is available for download to WRC customers and partners of InterSystems.
About Zen Mojo and Enterprise Manager will be separate detailed posts - stay tuned.
The full text of the Release Notes can be found here.
Source: https://habr.com/ru/post/219697/
All Articles