InterBase/JDataStore TRACK SCHEDULE
Find out how to maximize the benefit of the new InterBase® support for SMP, transaction monitoring, JDBC, and the Microsoft® .NET Framework. Learn how the speed, power, and scalability of JDataStore™ can help you build mobile, embedded, and near-enterprise applications.
Sunday, September 12, 2004 — 8:00am - 12:00pm
2006 Introduction to InterBase, Part I
Quinn Wildman — Borland
Type: Preconference Tutorial.
Level: Beginning.
This tutorial is an introduction to InterBase. Coverage includes: using IBConsole; using InterBase ISQL; using InterBase command-line utilities; creating and modifying databases, datatypes, domains and tables; working with indexes; inserting, updating and deleting data; extracting data; understanding more about SELECT; and working with views. We also discuss database security, stored procedures, generators and triggers, exceptions and exception handling, transactions and versioning, and advanced and miscellaneous topics. Part one of a two-part tutorial.
Prerequisites: None
Room: J1
Sunday, September 12, 2004 — 1:00pm - 5:00pm
3006 Introduction to InterBase, Part II
Quinn Wildman — Borland
Type: Preconference Tutorial.
Level: Intermediate.
This tutorial is an introduction to InterBase. Coverage includes: using IBConsole; using InterBase ISQL; using InterBase command-line utilities; creating and modifying databases, datatypes, domains and tables; working with indexes; inserting, updating and deleting data; extracting data; understanding more about SELECT; and working with views. We also discuss database security, stored procedures, generators and triggers, exceptions and exception handling, transactions and versioning, and advanced and miscellaneous topics. Part two of a two-part tutorial.
Prerequisites: Introduction to InterBase, Part 1.
Room: J1
3046 Agile Database Techniques
Scott Ambler — Ronin International, Inc.
  
Type: Preconference Tutorial.
Level: Intermediate.
The goal of the Agile Data (AD) methodology (www.agiledata.org) is to define strategies that IT professionals can apply in a wide variety of situations to work together effectively on the data aspects of software systems. Agile software development is real and it's here to stay. If data professionals are to remain relevant they must adopt techniques that reflect the realities of modern development, and that includes working in an agile and evolutionary manner. This presentation explores techniques for evolutionary database development, including: Database refactoring; Agile-Modeling Driven Development (AMDD); Test-Driven Development (TDD); Mapping objects to relational databases; Database encapsulation strategies; Alternatives to relational databases; Techniques for working with legacy data; Concurrency control; Effective referential integrity; Real-world XML; and Tools for Agile DBAs.
Prerequisites: An open mind.
Room: A7
Monday, September 13, 2004 — 10:00am - 11:15am
2124 InterBase Performance Monitoring: Vision and Control
Craig Stuntz — Vertex Systems Corporation
   
Type: Regular Session.
Level: Beginning.
Learn how to: use InterBase performance-monitoring features to analyze in minute detail what the users of your InterBase server are doing, debug and test your applications, and take command when necessary.
Prerequisites: None.
Room: J1
Monday, September 13, 2004 — 2:00pm - 3:15pm
1182 Managed Code Database Advantage for the Microsoft .NET Framework Platform
Steve Shaughnessy — Borland
   
Type: Regular Session.
Level: All.
The Borland DataStore for the Microsoft .NET Framework database is written entirely in managed code. DataStore for .NET is highly scalable and capable of outperforming many database products not written in managed code. DataStore for .NET provides database mirroring capabilities that provide first class database fault tolerance and increased scalability. Because DataStore for .NET is written entirely in managed code, applications that are also written in managed code languages such as Delphi, C#, VB.NET, and others can safely execute in the same process as the kernel itself. Native (unmanaged) code cannot be trusted to execute in the same process as a database kernel. Much higher performance and reliability can be achieved for managed code applications that embed DataStore for .NET into the same process. DataStore for .NET also provides the same performance and reliability benefits for stored procedures and UDFs written in a popular managed code languages instead of a proprietary SQL-based stored procedure language.
Prerequisites: Basic knowledge of Delphi or C# programming and ADO.NET.
Room: J4
Monday, September 13, 2004 — 3:30pm - 4:45pm
2112 InterBase Security
Daniel Magin — better office
Type: Regular Session.
Level: Beginning.
Learn all about installing, managing, and deploying InterBase Server in a secure way. Where are most mistakes from Administrator made running InterBase in a perfectly secure way? Where are the most open doors in a network and how do you handle the connection between InterBase and my applications? These questions are answered.
Prerequisites: None.
Room: J4
Monday, September 13, 2004 — 5:00pm - 6:15pm
3236 Writing Applications with a Managed Code Database for .NET
Jens Ole Lauridsen — Borland
Type: Regular Session.
Level: Intermediate.
Write all your application logic including stored procedures and triggers in Delphi with Borland DataStore for the Microsoft .NET Framework. Deploy your application by simply adding one DLL for the database engine. Write database applications for a PDA using Compact .NET Framework in Windows CE. The database engine itself is written entirely in managed code and provides full crash recovery, row locking, and very high performance. DataStore has it own ADO provider and it can also be accessed through BDP.
Prerequisites: None.
Room: J4
Tuesday, September 14, 2004 — 8:00am - 9:15am
3104 Understanding InterBase Transactions
Bill Todd — The Database Group, Inc.
Type: Regular Session.
Level: Intermediate.
This session covers every aspect of transactions and save points and their affect on InterBase. Topics include isolation levels, the wait option, the record version option, the OIT, OAT, OST and next transaction; what they mean and when they change.
Prerequisites: Basic understanding of the InterBase versioning engine.
Room: J1
Tuesday, September 14, 2004 — 9:30am - 10:45am
2114 InterBase/JDataStore in Mobile World
Daniel Magin — better office
  
Type: Regular Session.
Level: Beginning.
This session is an introduction to using InterBase and JDataStore for mobile applications for PocketPC, Palm, smartphones, and other mobile devices.
Prerequisites: None.
Room: J1
Tuesday, September 14, 2004 — 1:30pm - 2:45pm
2150 Optimization I: Optimizing InterBase Applications
Craig Stuntz — Vertex Systems Corporation
Type: Regular Session.
Level: Beginning.
Learn how to design and optimize InterBase client applications. We discuss good design, patterns for common tasks, and when and how to optimize.
Prerequisites: Familiarity with the basics of developing database applications in Delphi.
Room: J1
Tuesday, September 14, 2004 — 3:00pm - 4:15pm
3150 Optimization II: Optimizing InterBase SQL and Metadata
Craig Stuntz — Vertex Systems Corporation
Type: Regular Session.
Level: Intermediate.
The second part of a series on optimization of InterBase applications, this session explains how to tune SQL statements and metadata design for maximum performance.
Prerequisites: Basic familiarity with SQL.
Room: J1
Tuesday, September 14, 2004 — 4:30pm - 5:45pm
1180 Technical Overview of InterBase 7.5
Charlie Caro — Borland
Type: Regular Session.
Level: All.
Learn about the upcoming InterBase 7.5 release, its feature set, and benefits to customers. Topics include new administrative techniques, security, SQL support, engine capabilities, deployment flexibility, and defects repaired in this release.
Prerequisites: Database developers and end users.
Room: J4
Tuesday, September 14, 2004 — 8:00pm - 9:00pm
1108 PANEL: Meet the InterBase Team
Moderator: Jon Arthur — Borland
Type: Panel Discussion.
Level: All.
Where do we want to take InterBase in the future? This session is an interactive discussion of the future of InterBase and the improvements that will best serve the community of users.
Prerequisites: None.
Room: J4
Wednesday, September 15, 2004 — 8:00am - 9:15am
1140 Why Use InterBase?
Bill Todd — The Database Group, Inc.
Type: Regular Session.
Level: All.
If you have not considered InterBase you might not be using the best tool for your database applications. Learn how InterBase works, how it compares to other relational databases, and what unique benefits it offers. If you need a small, fast, easy to deploy self-maintaining, self-tuning relational database, learn what Borland's best-kept secret can offer.
Prerequisites: Some experience with relational database systems.
Room: J1
Wednesday, September 15, 2004 — 9:30am - 10:45am
3244 Using Multiple Instances of InterBase on the Same Server
Shaunak Mistry — Borland
Type: Regular Session.
Level: Intermediate.
Starting with InterBase 7.5 you will have the ability to launch multiple instances of InterBase on the same server. This functionality will allow you to embed your application with a particular version of InterBase or allow you to partition your databases on a per Server basis for performance reasons. Even if you do not plan to use the multiple instance of InterBase, your installation and application might be affected by these changes.
Prerequisites: Some knowledge of InterBase or other databases.
Room: J4
Wednesday, September 15, 2004 — 11:00am - 12:15pm
1188 Enhancements to InterBase from 5.6 to 7.5
Sriram Balasubramanian — Borland
Type: Regular Session.
Level: All.
This session takes you through the new features and enhancements to InterBase from the year 2000 to the present.
Prerequisites: None.
Room: J1
3118 InterBase and JDataStore Database Design
Daniel Magin — better office
Type: Regular Session.
Level: Intermediate.
Database design is the heart of many applications. Your application can only be as good as the database design. Learn the most common mistakes in database design and how to create a better database with replication. Speed up your SQL statements by only changing the database design. Enhanced features such as stored procedures and new user defined functions are covered.
Prerequisites: Experience with SQL.
Room: J4
Wednesday, September 15, 2004 — 1:15pm - 2:30pm
2104 Disaster Recovery with InterBase
Bill Todd — The Database Group, Inc.
Type: Regular Session.
Level: Beginning.
Whether you are worried about a hard drive failure, server crash, or fire, this session shows you the options for protecting your data from disaster. Topics include backup strategies, RAID, shadowing, replication, forced writes, and roll-forward recovery.
Prerequisites: None.
Room: J1
|
