Caché Monitor | SQL for InterSystems database Caché
Welcome to the home of Caché Monitor PDF Print E-mail
Caché Monitor is an lighweight integrated environment for accessing, configuring, managing, and administering many components of InterSystems database Caché. Caché Monitor combines tools with a smart sql editor to provide easy access for Caché developers and administrators to the database.

 

Caché Monitor is FREEWARE and can be used from any platform with an JAVA 6 (1.6) (Windows,Linux,Apple Mac)

 

Caché Monitor for InterSystems Caché

Features

  • Handles multiple connections.
  • Asynchronus database communication
  • Server Navigator
  • Object Explorer
  • Query Analyzer
    Fast SQL Query Editor (SQL Query Analyzer) for creating SQL queries with Color coding of Caché SQL keywords to minimize syntax and spelling errors (Syntax highlighting). Caché-SQL Code completion provide context sensitiv information about database objects (Tables,Views,Columns and Indexes), also known as Intellisense. SQL Code formatting. The graphical SQL execution plan uses icons to represent the execution of statements and sql queries in InterSystens Cachè. This graphical approach is very useful for understanding the performance characteristics of a sql query.
  • SQL History
    Caché Monitor automatically saves every SQL statement executed against InterSystems Caché. These statements can be searched and recalled.
  • Tools / Performance Management
      • Tool to analyze performance by identifying slowly executing queries

      •  

Caché Monitor for InterSystems Caché

 

 

The forum contains messages from people using Caché Monitor. Join the discussion! If you have a question about Caché Monitor or how to use them, please visit the Caché Monitor Support Forum for answers and help from other users.

 

 

If you do not know InterSystems CACHÉ, here are some information about the database from InterSystems: InterSystems CACHÉ is a post-relational database that uniquely offers three integrated data access options: a robust object database, high performance SQL, and rich multidimensional access. Caché enables rapid Web application development, extraordinary transaction processing speed, massive scalability, and real-time queries against transactional data - with minimal maintenance requirements. Caché is available for Windows, OpenVMS, Mac OS X, Linux and major UNIX platforms and it is deployed on systems ranging from two to over 50,000 simultaneous users. For more details, please visit InterSystems website, you find also information about InterSystems Caché at wikipedia

 

 

If you need a SQL Query Tool for any other Database than Caché? Please read ahead. These tools are very good:

  • The Universal Database Tool - DbVisualizer is a database tool useful for developers and database administrators to aid develop and maintain their databases. It is the perfect solution since the same tool can be used on all major operating systems accessing a wide range of databases.
     [YES! It can also connect to Caché, like Caché Monitor ;) ]

  • Aqua Data Studio - is a database developer's complete Integrated Development Environment (IDE). The IDE provides three major areas of functionality: A) Database query and administration tool B) Suite of compare tools for databases, source control and filesystems, and C) a complete and integrated source control client for Subversion (SVN) and CVS
    [Again another Java and JDBC based Query Tool. So it can also connect Caché]
  • SQuirrel SQL The SQuirreL SQL client provides a simple graphical interface to relational databases. Because it is built using Java, it can access any JDBC-compliant database running on any machine, allowing remote access to multiple databases. A SQuirreL user can:
    - easily view and edit data in any JDBC-compliant database,
    - view the database’s meta-data,
    - work with multiple databases on both local and remote machines,
    - use a single, consistent interface to work with different database engines, and
    - expand the tool’s capabilities and include DB-specific functionality using plugins.

You find more JAVA/JDBC based Client Tools here.

 
 

Database News

Database Journal News
Daily Database News and Information for the Database Professional
  • Keeping up with High Availability - Automating MySQL Failovers
    Automating failover situations can benefit an organization along with the database administrator who is on call. This article discusses how to setup Keepalived and how it may help in automated failovers for a Multi-Master MySQL cluster.


  • Synchronizing SQL Server and SQL Azure
    SQL Azure Data Sync provides data synchronization between the cloud and local SQL Server databases. Learn how SQL Azure Data Sync allows you to keep the most concurrent information in the cloud while allowing mobile users, businesses, and enterprise data sources all to have access to this data.


  • Identifying and Eliminating the Dreaded Cartesian Product
    Cartesian Products usually don't provide useful information and often result in mistakes that can hurt your database developer career. Learn to spot Cartesian Joins and banish them from your SELECT queries forever.


  • Top 9 SQL Server Developer Interview Questions
    The questions you may wish to ask or that will be asked during a SQL Server Developer interview will vary. Deanna Dicken shares the top 9 interview questions she asks when interviewing a potential SQL Server developer.


  • Working with ADO.NET Data Service in a .NET Framework Client Application
    Learn how to consume and make use of the ADO.NET Data Service in a .NET Framework Client Application. This article demonstrates the process by creating a simple web application that uses an existing ADO.NET Data Service.