Folie 1 - PowerPoint PPT Presentation

1 / 49
About This Presentation
Title:

Folie 1

Description:

IBExpert is the leading GUI tool for Firebird and InterBase databases. ... relationships and see, for example, how joins are made ideal for beginners. ... – PowerPoint PPT presentation

Number of Views:62
Avg rating:3.0/5.0
Slides: 50
Provided by: holger7
Category:
Tags: beginners | blob | folie

less

Transcript and Presenter's Notes

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.

3
  • Database registration

Register your database for IBExpert use and
select a wide range of settings, options and
defaults, specific to this particular database.
4
With 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.
5
Communications 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

8
IBExpert Editor features
  • multiple pages
  • customized toolbars for each editor and page
  • right-click context-sensitive menus throughout
  • customizable short cuts

9
User 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
  • print results
  • filter queries

and compare individual query performance
12
analyze query plans
  • and performance

13
  • Visual Query Builder

Construct your queries by point click view
relationships and see, for example, how joins are
made ideal for beginners.
14
Script 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

15
Stored procedures triggers
  • stored procedure trigger editors
  • customize templates
  • create a procedure from a query
  • or directly from the Table Field Editors
  • debug
  • analyze performance

16
Stored 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!
18
Dependencies 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

19
  • IBEBlock

IBExperts 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

21
IBEBlock 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

22
Database 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
  • manage subject areas
  • model options for all objects

24
Database Backup Restore
  • Your database backups and restores can be started
    manually or automated using IBExpertBackupRestore.

25
Database 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

26
Database Monitoring
Monitor your database(s)
  • who is logged on where
  • observe key database information
  • monitor statements
  • and transactions

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.

29
Test data generator
  • generate test data specifically for your own
    database

30
  • Data Analysis / OLAP
  • IBExpert's integrated OLAP and data warehouse
    component quickly and easily analyzes data in the
    database.
  • Use to build cubes, manage dimensions and
    measures.

31
IBExpert 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.

32
Blob 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
  • Report Manager
  • 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
  • Environment options

customize your working environment
36
Further options include
  • Editor Options
  • Visual Options
  • Keyboard Templates
  • General Templates
  • Code formatting options
  • Object Editor Options

37
IBExpert 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

38
IBExpert 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.
  • IBExpertBackupRestore
  • IBExpertJobScheduler
  • IBExpertInstanceManager
  • IBExpertTransactionMonitor
  • as well as IBEScript.exe and IBEScript.dll

40
IBExpertBackupRestore
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

41
IBExpertJobScheduler
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
  • IBExpertWebForms
  • create database-based web applications without
    any html knowledge

43
  • IBExpertDemoDB
  • 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
  • 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)
47
IBExpert 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
Write a Comment
User Comments (0)
About PowerShow.com