WAREVALLEY Orange

Orange 

• # Integrated development tool that helps all users manage database and handle data quickly and easily, hence enhancing work convenience
• # Provides intuitive GUI
• # Readily available for developers as well as DBA, administrators, and consultants
• # Since its launch in 2001, it has provided many customers and users with convenient tools to handle databases, proving optimal solutions for database operations

 

 

• Comprehensive database management solution
• Provides various tools for development processes for developers

• Provides convenience tools for various monitors and performance management for administrators
• Orange Ade Edition supporting various DBMS with a single program

• Supports online reorganization for DBA
• Provides various editions customized to administrators and DBA roles (Standard/DBA/Reorg Edition)

• GS certification level 1

 

Orange Ade

• Provides intuitive and easy-to-use GUI
• Available in multilingual projects with Unicode support
• Performs multiple tasks simultaneously using multi-thread oriented structure
• Enhances color and label settings to distinguish each session when connecting multiple sessions
• Uses a variety of DBMS simultaneously with a single program
• Schema Browser that can quickly and easily grasp the object information of database
• Convenient development of SQL syntax
• Table Editor, Loader, and Unloader to help change data
• ER Viewer to create, compare and analyze object relationship diagrams
• Object Report that generates various object specifications in a report form
• Various object creation scripts in the database
• Provides grammars, functions, and hints to help create SQL
• Other convenient development tools

 

Orange Standard

• Easy data editing of LOB, XML, Geometry. DBMS Xplan function that shows the actual execution plan
• Tuning Advisor that presents SQL statement tuning opinion
• Automatic display of objects or available words in the schema when creating SQL syntax
• Organized to distinguish development or operation sessions by displaying labels and colors for each DB session
• Supports SFTP in real-time trace and plan view, which are the main functions of orange
• Schema Browser that can quickly and easily grasp the object information of database
• Convenient development of SQL or PL/SQL syntax
• Tuning Advisor that presents SQL statement tuning opinion
• Table Editor, Loader, and Unloader to help change data
• ER Viewer to create, compare and analyze object relationship diagrams
• Object Report that generates various object specifications in a report form
• Various object creation scripts in the database
• Provides grammars, functions, and hints to help create SQL
• Other convenient development tools
• SQL Monitor that can easily and quickly check the Top N SQL that causes performance degradation for SQL in the memory of the database
• Session Monitor that facilitates session troubleshooting by retrieving a list of sessions connected to the database with various options
• Provides session and process information for all running transactions, information about related rollback segments and transaction status, etc.
• Provides lock and lock tree information generated in each session

 

Orange DBA Edition

• Real-time monitoring at session level using ASH
• Easy Data Editing of LOB, XML, Geometry
• DBMS Xplan function that shows the actual execution plan
• Tuning Advisor that presents SQL statement tuning opinion
• Automatic display of objects or available words in the schema when creating SQL syntax
• Organized to distinguish development or operation sessions by displaying labels and colors for each DB session
• Supports SFTP in real-time trace and plan view, which are the main functions of orange

 

Instance Monitor (Database Monitor)

It finds the most important and frequently viewed critical statistics of instance operational management statistics on nine graphs. By supporting the file storage feature, graphs representing past statistics can be rechecked at any time.

 

Wait Event Monitor

A Wait Event can be monitored in a transient performance degradation situation. It sets the update interval in seconds to provide the feature to view the Wait Event information that changes according to a given time interval at a glance through the list, graph, and chart.

 

ASH Monitor

It supports real-time monitoring at the session level using ASH (Active Session History) information in the latest 1 hour. When selecting a specific section, Top SQL, Session, and Wait Event information that was performed in the selected section can be used to analyze the failure and the cause of performance degradation not only in the present but also in the past at the session-level. Available to use from 10g.

 

Space Manager

It provides usage for table spaces and data files in a variety of forms. All the situations can be systematically managed by showing stored segment information by segment type and user which used to be provided by table space.

 

Security Manager

All security-related information such as user, role, permission, and profile, defined in the database can be easily retrieved from a variety of perspectives, and user information changes can be easily made, including adding a new user and granting/withdrawal of permission.

 

Stats Manager

In a Cost-Based Optimizer operating environment, statistical information on segment objects such as tables, indexes, and clusters can be easily managed through various options.

 

Health Check

As an online check service to identify and analyze the cause of database load in terms of performance, and to improve problems, the feature determines the health metrics of key elements for database operation.

 

Graph & Report

By performing pre-defined/user-defined SQL to grasp database operation status and performance, the results are provided as graphs and reports in various forms.

 

Log Miner

The Redo Log, which stores the history of changes in the database, can be retrieved with various options and can recover changes such as Update, Insert, and Delete.

 

AWR Manager

It is mainly used by database administrators and the performance of the database can be monitored in a report format. The report types include Auto Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR), AWR SQL, AWR Diff, and Active Session History (ASH) reports.

 

Data Quality Manager

Analyzes the data defect through the verification of the data itself, and supports analyzing the factors that can cause errors later. Analysis item – Distinct Count / Null Count / Space Count / Minimum Value / Maximum Value / Various data analysis support. It also provides analysis data such as Summary / Pattern / Distinct Value List and Chart based on these element data. The user enters SQL for the business rules required for analysis to register the business rule and provide execution results.

 

FEATURED +

 

 

Provides integrated security function by interworking with Chakra Max and Trusted Orange solution

 

SUPPORTED DATABASE

Oracle 7.3 or later

Tibero 3 or later

Altibase HDB 5 or later

XDB 6.5.1 or later

IBM DB2 UDB 9.1 or later

Sybase IQ 12.6 or later

Sybase IQ ASE 12.5 or later

SQL Server 2000 or later

PetaSQL 1 or later

 

Orange Ade

Apache hive

Mysql

Maria

Cubrid

PostgreSQL

Greenplum

PPAS

Teradata

SAP HANA

 

Orange Standard

Oracle

Microsoft SQL Server

IBM DB2

Sybase IQ ASE

Sybase IQ

Tibero

Altibase

PetaSQL

 

Orange DBA Edition

Oracle

Microsoft SQL Server

IBM DB2

Sybase IQ ASE

Sybase IQ

Tibero

Altibase

PetaSQL