features
Integrated Environment
Studio is an integrated development environment that enables developers to create, edit, tune, and deploy server-side objects residing on kdb databases. Its q facilities create a unified development environment for kdb programming, simplifying scripting, object management, reverse-engineering, database project management, version control and deployment. With Studio, programmers can develop and maintain high-quality, high-performance client/server kdb+ based applications in less time, and with greater accuracy.
Q Statement Creation and Data Editing
The ql session window has intellisense prompting the user with database objects such as table and column names at the press of a button. Since Studio loads q directly into server memory, without round tripping through the filesystem, any syntax errors in are detected and reported immediately. This ensures that statements are built correctly the first time. From within the data grid programmers can view result sets of upto 120 million rows, and data can be selected, copied, drag 'n dropped, or exported and opened in Excel.
Result Set Views
Result Sets can be viewed in either grid view or 'classic' view, with a summary view.
High Productivity
Even the most experienced kdb+ programmers find Studio to be a highly productive development environment, with a number of programming aids that facilitate the writing of server-side logic.
Features include:
- Compatible with vanilla, real-time, history kdb+ servers and ticker plants
- Multiple, concurrent kdb/kdb+ connections
- Upto 125 million rows grid view of result set
- Ultrafast datatransfer -> 1 million rows / sec
- Syntax highlighting for q keywords
- Intellisense prompting of database objects
- Reports errors in queries
- Drag'n Drop features
- Open data directly into Microsoft Excel - allowing charting
- Export to Excel, csv, tab,xml and native kdb+formats
Database Project Management
Studio works with text files, and hence is comptible with most version control systems. Developers can easily work with original Q source code in files, or with live database objects.
Q Scripting Power
Studio provides helpful scripting facilities, including an ad-hoc q scratch area
Excel Integration
This functionality allows data to be opened directly in Excel for further processing, e.g. charting, report generation, csv export etc.
Debugging and Profiling Functionality
Helps to debug programmable objects such as stored procedures.
Enables capture metrics of functions as they are executed in the database. This information helps identify and isolate efficiency and performance problems, and can be stored in a database for future reference.
Non-Invasive Installation
Studio does not install any of its own helper objects, such as views or stored procedures, on your production database servers. It requires only a client-side installation.
kdb is a product from KX Systems and an evaluation version of kdb+ can be requested via the KX Systems website.