|
|
| Cache Monitor is an SQL development tool for InterSystems database Cache. It supports developers with features, like: advanced SQL Query Editor with FK-JOIN hints,SQL Syntax highlighting,SQL Code completion, Graphical SQL execution plan and many more |
|
| Updated |
May 19, 2008 05:03:33 | | Size | 4419 kb | | Licence | Freeware | | Status | Minor Update | | Languages | English | | Tags | sql, editor, database, intersystems, query, tool, tuning, execution plan | | OS | Windows ME, Windows NT, Windows 2000, Windows XP, Windows 2003, Windows Vista, Windows CE, Unix, Mac OS | | Homepage | cachemonitor.de | | Email | info@cachemonitor.de | | Author | Andreas Schneider |
|
|
click for full size
|
Description: Cache Monitor is the SQL development tool designed for InterSystems database Cache. It supports developers with features, like: Advanced SQL Query Editor,Cache-SQL Syntax highlighting,SQL Code completion,SQL History buffer for executed SQL commands,SQL Code formatting,Graphical SQL execution plan and more.
You see the process ID (PID) from your connection on the Tabpane on every Query Analyzer. Code completion allows you to type a few characters and then display a list of context-sensitive possibilities to complete the text you are typing. Editor code completion brings up a list of Tables or Columns (also known as Intellisense). Code completion can be triggered by pressing [CTRL+SPACE] or by typing a hotchar or keyword, such as '.' or ',' in an SELECT list. After typing the keyword ON in a JOIN clause, Caché Monitor displays foreign key join suggestion
Cache-SQL formatting can executed from context menu to make your code, or the code of others, much easier to read ("Format SQL"). The also supports of course: Undo/Redo and Search and Replace.
With Hyperlink navigation you can simple navigate from the editor to Tables metadata. When you presses the CTRL key and hovers the mouse cursor over a certain code element, the element is changed to a hyperlink. When you holds the CTRL key and clicks on the hyperlink, the "go to Tables metadata" action is performed. | Short tags: sql, editor, database, intersystems, query, tool, tuning, execution plan | System Requirements: Java Runtime Environment 6.0 (JRE 6.0) | Change Info: V 0.40:
Query Analyzer
- Executing stored procedures with CALL no longe raise exception if the resultset is bigger than 99 rows and the option "block fetch" is used.
- Better code complition in some situations
Server Navigator / Table Browser
- Max Rows and Max Chars can now be configured. Max Rows limit the rows fetched from server. Max Chars limit the size of charfields fetched from server
V 0.39:
This Version is a minor release for better support for Caché 2008.1
and his JDBC Driver. Use Java Runtime Environment 6!! AND Caché JDBC Driver for Java 6 !! | |
| Free Download Caché Monitor 0.40 from sql-monitor.de |
| Similar software shotlights: | - OraSphere: Query Master 1.4 Fast multi-threaded SQL and PL/SQL tool with a script library and an advanced grid for developers and DBAs. PL/SQL editor; DB Object browser; bind variables; powerful grid; execution plan; popup w/ db
- UncleOra for Oracle 1.32.02 Fast multi-threaded SQL and PL/SQL tool with a script library and an advanced grid for developers and DBAs. PL/SQL editor; DB Object browser; bind variables; powerful grid; execution plan; popup w/ db
| | Find all software similar on Caché Monitor 0.40 |
| Similar smart reviews: | - Database Tour Pro 5.1.0.715. Manage your database with variety of functions! For a software developer, a «Swiss knife»-style tool can be incredibly useful, but only when that?s the «right» tool. The problem is, nobody can tell you exactly, how to determine whether a tool is «right». A right tool must be full-featured, but it must not be overloaded with features; a right tool must have laconic and functional interface, but
- ClockWise 3.30b, Tune Your Time! ClockWise is an ultimately wise time control center. It plays as an all-in-one smartly organized app, handling all accounting, scheduling, and informational functions related to dates and times. The programs main window shows as much information as you really need in as small amount of screen space required to not bothering you. There is the Expanded View, showing you
- Aurora Web Editor 2.2, Site Editor with a Human Face Nowadays, the term «website» is really diffused. Google «is a website»? Amazon «is a website»? A personal homepage of an Oxford professor or New-York worker «is a website»? Then, what does it mean «to create a web-site»? OK, lets turn back from the philosophy to the practice. Suppose, you want
- DecryptSQL, Conquer Encrypted Queries Remember the plot of any blockbuster or spy movie you watched recently? A good guy pursues a bad but clever secret agent, almost captures him, but
Suddenly, the bad guys traces disappear, and the good guy has little or no clue of where the trace would continue. Dealing with someone elses code is a lot similar. As soon as you decide youve figured
- Select Fast! Improve query performance. Select Fast! is unique software created by a professional developer to ease the life and work of colleagues. Select Fast! for Oracle is a tool for automating the repetitive tasks associated with the SQL tuning process on Oracle databases. The vital purpose of this program is to help you find the best action to improve the performance of the query. Check out this excellent
- Tidycode Pl/Sql Formatter 2.4.2, Making It Pretty This utility can seem «just a small helper», but detailed analysis can say you it is really smart and really helpful (Ill even say indispensable) for almost any database programmer. Its functionality can be easily guessed by name: it just formats PL/SQL code (as well as plain good SQL), and the way he does it can be characterized as «just right»
- Visual SQL Designer. Ease Your Work With Data. Visual SQL-Designer is powerful software that can easily create complex SQL queries for any database. With this useful tool, you will be able to construct the most part of necessary queries using just visual interface of the user. That is really convenient. Now, when you have got Visual SQL designer, you do not have to spend hours creating queries, whether you are good at SQL or have
- Internet Usage Monitor Lite 8.0 «Time, keeps going,» we think; especially when using a dial-up Internet connection. The dial-up brings you many positive revelations, like the understanding of the value of time and the «Time is Money» proverb :) And you, dial-up Internet user, suddenly obtain one new wish: Its a wish to count time accurately and reliably. You become suspicious. You want
- Network Eagle Monitor Knowing the status of the local network and being able to troubleshoot existing problems is the key task of any system administrator or anyone actively working in a network environment. There are many approaches to efficient network monitoring, but most of them are quite complex and are not adequately suited for daily use by a wide range of users. Fortunately, there are solutions that
| | Find all smart reviews similar on Caché Monitor 0.40 |
|