Documentation 7.5
Aqua Data Studio 7.5
1. Installation
    1.1 Minimum Requirements
    1.2 Installing Aqua Data Studio in Windows OS
    1.3 Installing Aqua Data Studio in Linux OS
    1.4 Installing Aqua Data Studio in Mac OS
    1.5 First steps towards Configuring
    1.6 Choose Your Language
    1.7 Character set and Internationalization
2. Server Registration
    2.1 Supported RDBMS Servers in ADS 7.5
    2.2 How to Register a Server in ADS 7.5
    2.3 How to Edit Server Properties
    2.4 How to Copy Server Configurations
    2.5 Troubleshoot Registrations
    2.6 Tips and Tricks
    2.6.1 How to Register a Server Clone
    2.6.2 Tab Coloring to Identify Servers
    2.6.3 Using Filter Options in Registration
    2.6.4 Using Advanced Properties
    2.6.5 Permissions in Server Registration
    2.6.6 Drag and Drop Features
    2.6.7 Navigating with Short cut Keys
    2.6.8 SQL Express 2005
    2.6.9 MSDE 2000
    2.6.10 PostgreSQL SSL
    2.7. JDBC Drivers and Server Registration
        2.7.1 Oracle 8i JDBC Drivers
        2.7.2 Oracle 9i JDBC Drivers
        2.7.3 Oracle 10g JDBC Drivers
        2.7.4 Oracle 11g JDBC Drivers
        2.7.5 DB2 iSeries JDBC Drivers
        2.7.6 DB2 7.2 JDBC Drivers
        2.7.7 DB2 UDB 8.1 and DB2 UDB 8.2
        2.7.8 DB2 UDB 9.0 and DB2 UDB 9.5
        2.7.9 SQL Server JDBC Drivers
        2.7.10 Sybase ASE JDBC Drivers
        2.7.11 Sybase Anywhere JDBC Drivers
        2.7.12 Sybase IQ JDBC Drivers
        2.7.13 Informix JDBC Drivers
        2.7.14 PostgreSQL JDBC Drivers
        2.7.15 MySQL JDBC Drivers
        2.7.16 Apache Derby JDBC Drivers
        2.7.17 SQLite JDBC Driver
        2.7.18 Firebird JDBC Driver
3. Connecting to a Server (CTRL + INSERT)
4. Disconnecting a Server (CTRL + DELETE)
5. Query Analyzer - SQL Tool in ADS 7.5
    5.1 Invoking the Query Analyzer (CTRL+Q)
    5.2 Using the Query Analyzer
    5.3 Query Analyzer and its Environment
    5.4 Using Advanced Properties
    5.5 Parameterized Scripts
    5.6 Displaying Results of Queries
    5.7 Saving Query Results
    5.8 Tips and Tricks
6. SQL History (CTRL+ ALT+H)
7. Automate your SQL scripts using ADS 7.5
    7.1.1 Adding Insert, Update, Delete and Select
    7.1.2 Introduce Columns and Value Stubs
    7.1.3 Comments and Morph to Delimited Text
    7.1.4 Formatting Statements
    7.2 Auto Completion
    7.3 Aqua Commands
8. Query Builder Tool in ADS 7.5
    8.1 Building Queries
    8.2 Workspace Reference
9. Charting Tool in ADS 7.5
    9.1 Working with Grids
    9.2 Working with Pivot Grids
    9.3 Working with new & Enhanced Charts
    9.4 Scripting Charts
    9.5 Chart Options
    9.6 Function Series
    9.7 Chart Gallery
10. SQL Query Tuning - Visual Explain Tools
    10.1 Invoking Execution Plans
    10.2 Using Explain Diagrams
    10.3 Sample Query Tuning Demo
11. GUI Tools for Creating Database Objects
    11.1.1 Creating Tables
    11.1.2 Creating Constraints
    11.1.3 Creating Indexes
    11.1.4 Creating Views and Triggers
    11.1.5 Creating Aliases and Synonyms
    11.1.6 Creating Storage Objects
    11.2 Multi Scripting Objects
12. Tools and Features available in ADS 7.5
    12.1 How to Import Data using ADS 7.5
    12.2 How to Export Data using ADS 7.5
    12.3 Generate SQL Scripts using ADS 7.5
    12.4 Table Data Editor
    12.5 Server Script Generator
    12.6 Using Object Search in ADS 7.5
    12.7 Comparing two Database Schemas
    12.8 Using Explain White Board
    12.9 Using Execution Monitor
    12.10 Generating ER Diagrams
13. Procedure Editor
    13.1 Sample Stored Procedure
14. Function Editor
    14.1 Sample User Defined Function
15. Package Editor
    15.1 Sample Package Editing Demo
16. SQL Debugger
    16.1 Invoking ADS 7.5 SQL Debuggers
    16.2 Features of ADS 7.5 Debuggers
    16.2.1 Oracle Debugger
    16.2.2 DB2 Debugger
    16.2.3 MS SQL Debugger
    16.2.4 Sybase Debugger
    16.3 Debugging Stored Procedure Demo
17. ER Modeler in ADS 7.5
    17.1 Notation and Normalization
    17.2 Working with ER Modeler
    17.2.1 Creating Tables
    17.2.2 Creating Indexes
    17.2.3 Creating Constraints
    17.2.4 Creating Relationships
    17.2.5 Adding Notes and Regions
    17.2.6 Saving an ER Model
    17.3 Forward Engineering
    17.4 Reverse Engineering
    17.5 ER Modeler Demo
18. Version Control in ADS 7.5
    18.1 Using Subversion Repository
    18.2 Using CVS Repository
    18.3 File Search in Version Control
    18.3 Tips and Tricks
19. DBA Corner
    19.1 ORACLE DBA Tools
    19.1.1 Server Statistics
     19.1.2 Rollback Manager
     19.1.3 Log Manager
     19.1.4 Session Manager
     19.1.5 Instance Manager
     19.1.6 Storage Manager
     19.1.7 Security Manager
     19.1.8 SGA Manager
    19.2 SQL SERVER DBA Tools
    19.2.1 Instance Manager
    19.2.2 Session Manager
    19.2.3 Security Manager
    19.2.4 Storage Manager
    19.2.5 SQL Agent Manager
    19.3 SYBASE DBA Tools
    19.3.1 Instance Manager
    19.3.2 Session Manager
    19.3.3 Security Manager
    19.3.4 Storage Manager
    19.4 MySQL DBA Tools
    19.4.1 Instance Manager
    19.4.2 Session Manager
    19.4.3 Storage Manager
    19.4.4 Security Manager
    19.5 DB2 for LUW DBA Tools
    19.5.1 Instance Manager
    19.5.2 Session Manager
    19.5.3 Storage Manager
    19.5.4 Security Manager
20. Compare Tools in ADS 7.5
    20.1 File Compare
    20.2 Results Compare
    20.3 Directory Compare
    20.4 Tab Compare
    20.5 Schema Compare
    20.6 Copy History Compare
21. Editors available in ADS 7.5
    21.1.1 SQL Editor
    21.1.2 Java and JavaScript Editor
    21.1.3 HTML Editor
    21.1.4 XML Editor
    21.1.5 Text Editor
    21.1.6 Regular Expressions
    21.2 Image Viewer
22. Application Workspace and Options
    22.1 Menus and Toolbar
    22.2 Shortcuts
    22.3 Schema and Script Browser
    22.4 Details View
23. Aqua Data Studio 7.5 OPTIONS
    23.1 General Options
    23.2 Editor Options
    23.3 Compare and Results Options
    23.4 Query Analyzer Options
    23.5 Scripts and Results Options
    23.6 Visual Explain Options
    23.7 Formatter Options
    23.8 Permissions and Registration Options
    23.9 Key Mapping Options and Key Assist Tool
    23.10 Settings: Find the application settings
    23.11 Command line
24. Aqua Data Studio Technical Support
    24.1 Error Logging

9.3 Working with new & Enhanced Charts

Feature Overview

  •    Chart Types - Enhanced Charts include OHLC (open-high-low-close) charts, Candlestick charts, Bubble charts, Stacked charts and Scatter charts.
  •    Chart Functions - Support for Functions include Addition, Subtraction, Scalar, Power, Log, Linear Regression and Moving Average.
  •    Column Shape Type - Support for Cylinder, Cone & Pyramid versions of all Column & Bar charts is added  

 





3D High Low Close 3D Candlestick Moving Average + Stack New Functions






Cone
Pyramid
Cylinder Exploded Pie

 

Working with Candlestick Charts

Candlestick charts can be effectively used in Aqua Data Studio 7.5 to plot data-driven charts.

 
Candlestick Chart
  1. Candlesticks are used to show stock price
  2. Each candlestick shows the stock's high, low, opening and closing prices. The wick shows the stock's high and low prices
  3. The body of a candlestick shows the stock's opening and closing prices
  4. A day is an up day if the closing price is greater than the opening price
  5. The body color is used to flag if it is an up day (GREEN) or down day (RED)

Working with Open-high-low-close Chart


Open-high-close Chart
  1. In a high-low-close plot the vertical line represents the high and low values over one unit of time.
  2. The close value is represented by a "tick" to the right. The open value, if present, is represented by a tick to the left.
  3. If today's close is higher than yesterday's close - the bar is colored green/blue.
  4. If today's close is lower than yesterday's close - the bar is colored red.
  5. If today's close is equal to yesterday's close - the bar is colored the same as yesterday.

Working with Bubble Charts


Bubble Chart

A bubble chart is a two-dimensional scatterplot where a third variable is represented by the size of the points.

  1. In a high-low-close plot the vertical line represents the high and low values over one unit of time.
  2. The close value is represented by a "tick" to the right. The open value, if present, is represented by a tick to the left.
  3. If today's close is higher than yesterday's close - the bar is colored green/blue.
  4. If today's close is lower than yesterday's close - the bar is colored red.
  5. If today's close is equal to yesterday's close - the bar is colored the same as yesterday.

 Working with Stacked Area Charts


Stacked Area Chart

A stacked area chart is used to map multiple series over different categories like time.

  1. The stacked area displays trends of each category so that the areas are stacked, but each series does not overlap the preceding series.
  2. Stacked area can chart multiple data sets as an area.

Working with Scatter Line Charts


Scatter Line Chart

The scatter line chart in Aqua Data Studio 7.5 allows you to create a chart with two value axes to show one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis.

  1. The scatter line chart displays points at the intersection of x and y numerical values, making these values into single data points.
  2. Scatter line charts can plot numerical values like day or hour along the horizontal axis.

Working with Stacked Bar Chart


Stacked bar Chart

The Stacked Bar chart in Aqua Data Studio 7.5 allows you to create a chart displaying the results of multiple queries stacked on top of each other vertically.

  1. The Stacked Bar consists of data points represented by segments of each bar, as well as total value represented by data points of each Series selected in the Chart options.
  2. Each series is denoted by a different color and the entire bar is the total for the data series

Working with Scatter Charts


Scatter Chart

The scatter chart in Aqua Data Studio 7.5 allows you to create a chart showing one piece of information, such as stock value along the x-axis and another piece of information such as Company, along the y-axis. A scatter chart is used to map correlation between sets of numbers.

  1. The scatter graph consists of plotted points "scattered" around an X-Y grid. The pattern may reveal a relationship between the two variables measured by the X and Y axes. In 2D scatter graphs, you can illustrate trends in the plotted points by adding a "Moving Average".
  2. Scatter graphs can chart multiple data sets, each represented by a different symbol, each having any number of data points.