Archive for Month: August 2013

slide

Caché Monitor automatically downloads the required InterSystems Caché database driver

No manual intervention is required to use a Driver for InterSystems Caché. The driver is automatically downloaded from the web. Just select the driver for a Server. On the first connection the driver download starts, after the download is finished the connection is established. Select the driver and go:   If […]

slide

Caché Globals

Caché’s multidimensional arrays are called globals. Data can be stored in a global with any number of subscripts. What’s more, subscripts are typeless and can hold any sort of data. One subscript might be an integer, such as 34, while another could be a meaningful name, like “LineItems” – even […]

New features in Caché Monitor

Caché Monitor 2.03 (What is new in this release?) Main enhancements since last version are: Caché Server passwords are encrypted The password from a registered Server is now automatically encrypted. This is done by changing a property at the registered server or by adding a new server. It is also possible […]

slide

Bitmap Index

Bitmap indexes consist of a bitmap (bit vector) for each distinct column value. Each bitmap has one bit for every row in the table. The bit is on if the related row has the value represented by the bitmap. The advantage of bit map indexes is that complex queries can […]

slide

Support

If you have any questions or problems, please send a email to: support@cachemonitor.de        

Use it for free!

Caché Monitor Home Edition is free of charge!

slide

Combine tables across namespaces in a SQL Query – Part 2

The function in Caché Monitor is called “Create mapped table”. Create a new Namespace with a databaseTo try this feature it is recommended to create a new empty Namespace (and database for this namespace), e.g. called “CM_FEDERATED” as the federated namespace. All tables you want to JOIN in a query must […]

Specialized for Caché

Software developers who are familiar with InterSystems technologies should easily find their way through the use of InterSystems specific terms. The Server Navigator is the main tool and allows to browse and organize InterSystems Caché servers into groups, It shows database objects and structures such as tables, views, classes, indexes, constraints, procedures, […]

Query tables across namespaces

Caché Monitor helps by query tables in different namespaces. With the features mapped tables and federated namespace Caché Monitor support the request of writing SQL query across namespaces with the idea of a federated namespace. I got quite some people asking for an option to query some tables from different namespaces on a sql […]

Working with Caché Namspaces

Within Caché Monitors Server Navigator you see all available Namespaces on your Caché Servers. No need to know the name of the Namespace, no need to configure many many JDBC Connections by hand. Just click on the namespace and see all objects like tables, view, classes…   A namespace is a […]