Haciendo Visible lo invisible
Raul Merida | Servicios Profesionales
Administración de Bases de Datos
Agenda
Tendencias
Ratios
DBArtisan
Beneficios
Características
Tendencia creciente
“90% of enterprises have
More than one DBMS” (Forrester Research)
Heterogeneous DBMS’s creates challenges:
•
DBA resources/skills issues
•
Consistent administration efforts
•
Greater time to resolve issues impacts SLAs
•
Increases cost (Tools, Training & HC)
Ratios DB/DBA
2010
2005
2000
1995
1990
30
40
Number o
f datab
ases/instances
Current Avg.
industry ratio 35:1
50
2015
Limited to 5TB per DBA
Por qué DBArtisan
•
Demostrada herramienta de gestión de bases de datos
•
DBArtisan potencia las habilidades de los DBAs
•
Mejora la productividad en entornos de múltiples motores
de bases de datos.
•
Mitiga el desafío de manejar una complejidad creciente.
•
Homogeniza procesos habituales.
Beneficios
Reduce costs and increase flexibility across database platforms
Organizations can easily manage multiple platforms from a single,
consistent, and comprehensive console
Rich cross-platform capabilities eliminate the need to retrain staff
when new platforms are added or resources need to be shifted
Leverage existing resources, even as demands grow
Highly scalable for managing large, complex datasets
Easy-to-use interface helps novice DBAs handle tasks that normally
require highly experienced staff
Superior diagnostic capabilities help fully exploit existing hardware
investments
Beneficios
Improve database performance and service quality
Using DBArtisan Workbench, IT departments can diagnose problems
quickly, prevent bottlenecks, and proactively plan for storage
Tuning capabilities ensure that applications are deployed efficiently
Cross-platform administration with one standard solution
Rich and consistent feature implementation across platforms make it
easy to be productive in heterogeneous environments or unfamiliar
databases
Enable higher availability and better performance
Intelligent diagnostics help prevent problems before they happen
Diagnosis and correction capabilities minimize slow performance and
down-time
Beneficios
Focus on value-add, not repetitive tasks
Automation of common tasks such object and schema migration,
SQL editing and job scheduling minimize time spent on tedious
chores
Rich utilities and editors reduce errors and save time
Effectively manage database security
Manage users, roles, privileges, and permissions from one interface
to establish and maintain security across platforms
Need
DBArtisan Delivers
Greater Efficiency
Time saving features DBAs use
throughout the day
Explorer Performance -
Using our new data source explorer framework, we’ve greatly improved performance of the explorer tree. Now DBArtisan is able to pre-populate the entire contents of the explorer tree so the DBA can instantly seeeverything.
ISQL enhancement
Need to write SQL code faster? Need to write code in DB2, MySQL, Oracle, SQL Server, Sybase? New SQL code assist features will help you work error-free. SQL editor now supports real-time syntax checking of code as well as object names. Plus full object look-up throughout the SQL statement, and code complete.
Streamline Tasks
“Set it and Forget it“ features
to streamline workflow and
improve ease of use
Data source Management
Managing data sources can be time-consuming; capturing registered data source information for backup, migrating them to other machines, or sharing data source information with others in your organization. The new DBArtisan 8.7 makes it easy to quickly export and import registered data source information .
Object Filtering
Customers asked and we delivered! Three new filtering capabilities enable DBAs to better control the user interface and work more efficiently.
Simple, name-based filtering lets DBAs hide objects based on naming. When typing characters in the data source tree and object list filter boxes the list is updated to show only matching objects. Complex, user-defined object name filtering lets them create their own custom filters at the data source level. And node filtering is defined at the platform level.
Detalle de características
Need
DBArtisan Delivers
Globalization
Language is no barrier
Unicode Support
Is your customer global? Dealing with data across the continents in
multiple languages? DBArtisan 8.7 offers full Unicode character support so
DBAs can work with data in different languages and display the text
correctly on screen
DB2 z/OS
DBArtisan is a powerful, yet
affordable tool for DB2 z/OS
administration
DBArtisan offers many new features and enhancements for z/OS
administrators including: object filtering, extended alter in tables, data
import and export, migration support, generation of LOAD utility control
statements, plus many Version 8 and Version 9 specific improvements.
Detalle de características
Feature
Description
Enhanced ISQL Editor
“On-the-fly” syntax checking of both code and object names, full object look-up throughout the SQL statement, and code complete. Code complete will dynamically walk you through statements, prompting you with dropdowns, to ensure proper syntax is used.Detalle de características
Feature
Description
New Filtering
Capabilities
Three new features: simple, name-based filtering lets you hide objects based on naming, complex, user-defined object name filtering, node filtering is defined at the platform level.
Detalle de características
Feature
Description
Data Source Explorer
Performance
Enhancements
The tree display for the data source Explorer and related functionality has been reworked so connecting has been simplified, tree organization better reflects
ownership and containment, and more right-click object actions are available directly from the tree.
Detalle de características
Feature
Description
Unicode Support
Full Unicode character support throughout the application, allowing you to work with data in different languages and display the text correctly on screen.Detalle de características
Feature
Description
Enhanced DB2 for z/OS
Support
Many new features for z/OS administrators including: object filtering, extended alter in tables, data import and export, migration support, generation of LOAD utility control statements, plus many Version 8 and Version 9 specific improvements.