Title: Folie 1
1(No Transcript)
2 the only tools youll ever need!
- IBExpert is the leading GUI tool for Firebird and
InterBase databases. - Produced by IBExpert KG, headed by Holger Klemt,
who has more than 18 years experience in database
design and development. - The following provides an overview of the many
features and options offered by IBExpert. See how
fast you can develop and administrate your
Firebird/InterBase database with the aid of
IBExpert.
3Register your database for IBExpert use and
select a wide range of settings, options and
defaults, specific to this particular database.
4With many options including log files, backup
restore files, default paths, filters, scripts,
transactions, and so on.
Test your connection and youre then ready to
start working with IBExpert.
5Communications Diagnostics
- delivers a detailed protocol of the test connect
to a registered InterBase/Firebird server and
the results - detailed status information concerning the
various steps taken to make the connection is
displayed - indicates problem areas if the connection is not
achieved
6- A database connection is made by simply
double-clicking on the registered database name
in the IBExpert DB Explorer, the main database
navigator. - Your databases and their objects are all clearly
displayed here in a tree structure.
You can sort your database objects into
projects, and view database and object details in
the SQL Assistant below it.
SQL Assistant
7- All database objects can be created, altered and
deleted in the IBExpert Object Editors
8IBExpert Editor features
- multiple pages
- customized toolbars for each editor and page
- right-click context-sensitive menus throughout
- customizable short cuts
9User Grant Managers
- In addition to the Grant pages in the individual
object editors, IBExpert also provides a User
Manager
and a Grant Manager.
10- For queries and hand-coding, use IBExperts SQL
Editor.
11 and compare individual query performance
12analyze query plans
13Construct your queries by point click view
relationships and see, for example, how joins are
made ideal for beginners.
14Script Executive
- capable of more complex work than the SQL Editor
- use for executing multiple scripts from a single
script - full Unicode support
- select individual statements for analysis or
deletion - own language extensions
15Stored procedures triggers
- stored procedure trigger editors
- customize templates
- create a procedure from a query
- or directly from the Table Field Editors
- debug
- analyze performance
16Stored procedure trigger debugger
- IBExpert interprets the procedure and runs the
commands one at a time.
- you can watch certain parameters
- analyze the performance and indices used
- and even change values on the fly
Functions include breakpoints, step into, trace
or run to cursor.
17- SP/Triggers/Views Analyzer
Analyze all procedures, triggers and views at the
click of a button and then optimize. Its that
simple with IBExpert!
18Dependencies Viewer
Before manipulating or deleting database objects,
check for
- any dependencies upon an object
- an object's dependency upon other objects
- direct or indirect recursion
19IBExperts own script extensions
- A set of DDL, DML and other statements that are
executed on the server and on the client side,
including some specific constructions applicable
only in IBExpert or IBEScript, independent of the
database server version. - The syntax of IBEBlock is similar to that of
stored procedures but there are many important
extensions.
20- With EXECUTE IBEBLOCK you will be able to
- work with different connections within a single
IBEBLOCK at the same time - move (copy) data from one database to another
- join tables from different databases
- compare data from different databases and
synchronize them - populate a table with test data using random
values or values from other tables or even from
other databases - access external databases via ODBC drivers
- transaction control across multiple databases
- integration of many IBExpert functions in batch
files - dispatch and receive e-mails
- ... and much more
21IBEBlock example complete metadata extract
- execute ibeblock
- as
- begin
- cbb 'execute ibeblock (LogLine variant)
- as
- begin
- ibec_progress(LogLine)
- end'
- db ibec_GetDefaultConnection()
- ibec_ExtractMetadata(db, 'E\meta.sql',
'GenerateCreate ExtractPrivileges
ExtractDescriptions', cbb) - end
22Database Designer
- create a new database visually
- manipulate an existing database
- or reverse engineer your database to create a
model
23- generate a script from your model
- model options for all objects
24Database Backup Restore
- Your database backups and restores can be started
manually or automated using IBExpertBackupRestore.
25Database Statistics
- useful for detecting solving a variety of
performance problems - retrieves displays important database
statistical information, which can be exported to
numerous file formats or printed
26Database Monitoring
Monitor your database(s)
- who is logged on where
- observe key database information
27- search your database metadata
- extract your database metadata
- print your database metadata
28- Compare the data of two tables in different
databases and obtain a script detailing all
discrepancies, including the corresponding
INSERT, UPDATE and DELETE statements.
- Compare database versions or database SQL scripts
with IBExpert's Database Comparer.
29Test data generator
- generate test data specifically for your own
database
30- IBExpert's integrated OLAP and data warehouse
component quickly and easily analyzes data in the
database.
- Use to build cubes, manage dimensions and
measures.
31IBExpert ODBC Viewer
- Browse data from any ODBC source available on
your PC and export data from an ODBC source
into an SQL script or directly into a
Firebird/InterBase database.
32Blob Viewer/Editor
Enables blob fields in an open grid to be viewed
as Text, Hex, Picture (PNG and TIFF images are
supported), RTF, Web Page, XML or As Unicode
Text. An As BLR page appears additionally when
blobs with subtype 2 data are recognized.
33- create a new report on any volume or in the
database - double-click on database entries to automatically
create required objects - supports the printing of Unicode strings
- many export filters available
- IBEBlock commands for automatic report execution
in command-line mode, for example with batch
files
34- Generate HTML Documentation
Generate fully-linked software documentation with
just a few mouse clicks.
35 customize your working environment
36Further options include
- Editor Options
- Visual Options
- Keyboard Templates
- General Templates
- Code formatting options
- Object Editor Options
37IBExpert has even more functions .
- Recompute selectivity of all indices
- Recompile all triggers
- Database Monitoring
- Database Properties
- SQL Monitor
- Log Manager
- Localize IBExpert
- Recompile all stored procedures
- Database Validation
- Database Shutdown
- Database Online
- Server Properties/Log
- Localize IB Messages
38IBExpert Developer Studio isnt just the IDE
youve seen here. It also includes
- IBExpert Server Tools automate your routine
administration tasks - IBExpertWebForms create database-based web
applications without any html knowledge - IBExpertDemoDB ideal for benchmark testing
- IBExpertLive over 200 hours of lectures and
tutorials
39- IBExpert Server Tools
- Automate your routine administration tasks using
the HK-Software services control center.
- IBExpertTransactionMonitor
- as well as IBEScript.exe and IBEScript.dll
40IBExpertBackupRestore
IBExpertInstanceManager
- automatic backup and restore facilities for
Firebird and InterBase databases - for any number of databases
- separate backup, restore, schedule and log
mailing parameters for each database - compress backup files and restore to an
alternative server - automatic e-mail function
- install several instances of the Firebird server
on one Windows machine using different ports - database monitoring
- e-mail notification
- use different SYSDBA passwords
- use multiple CPUs more effectively
- use old and new Firebird versions on one machine
41IBExpertJobScheduler
IBExpertTransactionManager
- schedule regular jobs to run automatically
- e.g. if you wish a certain IBEBlock to be
executed on a daily basis or every two hours - specify e-mail notification
- monitors, views and analyzes dynamic transactions
within Firebird and InterBase databases - pick out those transactions that slow
performance, and optimize them
IBEScript.exe IBEScript.dll
- execute any valid IBExpert script in batch files
- encrypt script files
- all IBEScripts managed in the IBExpert DB
Explorer - use IBEScript.dll to integrate IBExpert scripts
in your own application
42- create database-based web applications without
any html knowledge
43- ideal for benchmark testing
- specify the number of data sets to be generated,
and it generates the same random data sets every
time
44- IBExpertLive is a streaming system based on the
Firebird server, allowing you to view our
comprehensive collection of Firebird
presentations and tutorials.
45- And all our products are supported by
- Comprehensive online documentationwww.ibexpert.co
m/doc - Support forumswww.firebirdexperts.com
- Newsgroupsnews//ibexpert.info/interbase.ibexpert
.en
46(No Transcript)
47IBExpert Server Tools license fees
Further IBExpert KG products services can be
found at our website at www.ibexpert.com.
48- Still not convinced?
- Then download the IBExpert Trial Version, a
fully-functional 45-day IBExpert version, today
from - www.ibexpert.com/download
49 the only tools youll ever need!
- Further information Purchase
- www.ibexpert.com www.ibexpert.com/shopinfo_at_ibexpe
rt.com