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 […]

query_editor_folding

Caché Monitor 2.03

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        

cachemonitor_on_monitor

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 […]

cache_log_files

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, […]

create_mapped_table

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 […]

namespaces

Working with Namspaces

In 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 […]