Database Track

1100  PANEL: Borland Database Open Forum  
Moderator: Joe Overton — Borland

Type: Panel Discussion. Level: All.
Open discussion around what's on the drawing board for the future with customer feedback and candid communication between R&D and our customers.
Prerequisites: None.
1100 Tuesday, November 8, 2005 — 10:45am - 12:00pm
Room: Continental Parlor 7

2000  Developing Win32 Database Applications with Delphi
Cary Jensen — Jensen Data Systems, Inc.

Type: Preconference Tutorial. Level: Beginning.
This tutorial provides a fast-paced overview of Win32 database development in Delphi. It begins with an introduction to the Delphi data access mechanisms, including the advantages and limitations of each. Other topics include how and when to use data modules, the role of data-aware controls, as well as how and why to decouple your user interface from data access components. This foundation tutorial is intended for both the novice and experienced developer alike.
Prerequisites: Familiarity with database development and Delphi.
2000 Sunday, November 6, 2005 — 9:00am - 1:00pm
Room: Continental Ballroom 4

2114  Migrating Database Applications to use Borland Data Providers  
Martin Rudy — R & R Consulting

Type: Regular Session. Level: Beginning.
This session provides a comparison of the basic features database developers are familiar with in data connectivity options prior to Delphi 8 and shows a migration path to database applications using BDP. The intent is to show BDE (Paradox only), dbGo, dbExpress, and IBX users how to perform the same actions with BDP. A matrix mapping like components, methods, and properties between data connection options is presented.
Prerequisites: Basic understanding of Delphi and database development.
2114 Wednesday, November 9, 2005 — 3:15pm - 4:30pm
Room: Continental Ballroom 6

2116  Getting Started with dbExpress
Martin Rudy — R & R Consulting

Type: Regular Session. Level: Beginning.
One of the many data connectivity options for the Borland RAD products is dbExpress.This set of drivers and components provide connectivity to databases for the Windows, Microsoft .NET Framework, and Linux platforms. This presentation provides an introduction to using the dbExpress technology and some tricks and techniques to make your database development easier. We also cover features beyond basic data retrieval and updating.
Prerequisites: Basic database development with Delphi.
2116 Tuesday, November 8, 2005 — 3:15pm - 4:30pm
Room: Continental Ballroom 4 

2124  Configuring InterBase for Maximum Performance  
Bill Todd — The Database Group, Inc.

Type: Regular Session. Level: Beginning.
This session focuses on configuring InterBase for maximum performance with particular emphasis on new features including group commit, database flush, database linger, the 131,000 page maximum cache size, the 32k maximum page size, and the directives in the ibconfig file that affect performance.
Prerequisites: None.
2124 Wednesday, November 9, 2005 — 9:30am - 10:45am
Room: Continental Parlor 7

2146  ADO.NET: BDP 2.5
Ramesh Theivendran — Borland

Type: Regular Session. Level: Beginning.
This session introduces what's new in Borland Data Providers (BDP) 2.5 and covers most of the ADO.NET 2.0 features. See how the BDP 3.0 feature set will evolve for .NET 2.0.
Prerequisites: Familiarity with Microsoft .NET Framework, ADO.NET 1.x, and C#.
2146 Thursday, November 10, 2005 — 1:15pm - 2:30pm
Room: Continental Ballroom 4

2158  Building Distributed Database Applications in .NET  
Ramesh Theivendran — Borland

Type: Regular Session. Level: Beginning.
The Microsoft .NET Framework provides various frameworks for building distributed applications like ASP.NET, Web Services, Remoting, and Messaging. This session introduces these frameworks and mainly focus on .NET Remoting and Messaging for building distributed applications.
Prerequisites: Familiarity with Microsoft .NET Framework 1.1 and some C# programming.
2158 Thursday, November 10, 2005 — 8:00am - 9:15am
Room: Continental Ballroom 6

3008  Developing Database Applications with the Microsoft .NET Framework
Cary Jensen — Jensen Data Systems, Inc.

Type: Preconference Tutorial. Level: Intermediate.
Get a head start on developing database applications for the Microsoft .NET Framework in this fast-paced introduction to ADO.NET. This tutorial describes and demonstrates the roles of the most common classes in ADO.NET. Topics include connecting to databases, executing queries, working with result sets, navigating data, creating calculated fields and aggregates, persisting datasets, using views, and synchronizing visual controls. Special attention is paid to best practices in .NET database development. Examples in both Delphi and C# are shown.
Prerequisites: Familiarity with database development issues.
3008 Monday, November 7, 2005 — 9:00am - 1:00pm
Room: Continental Ballroom 4

3100  Developing TCP/IP-based Server Applications using Indy Components
Christian Wilkerson — iBASEt

Type: Regular Session. Level: Intermediate.
The Indy components that ship with Delphi cover just about every networking protocol. This presentation is on development using Indy Server components. It includes fibers, threads, HTTP, and even custom servers.
Prerequisites: Good working knowledge of Delphi.
3100 Tuesday, November 8, 2005 — 4:45pm - 6:00pm
Room: Continental Ballroom 4 

3106  ASP.NET Web Forms and Databases
Bob Swart — Bob Swart Training & Consultancy

Type: Regular Session. Level: Intermediate.
In this session, we cover ASP.NET Web Forms and multi-tier databases.
Prerequisites: ASP.NET Web development experience.
3106 Tuesday, November 8, 2005 — 4:45pm - 6:00pm
Room: Continental Ballroom 6

3120  Java Persistance Frameworks  
Patrick McMichael — Pillar Technology Group, LLC

Type: Regular Session. Level: Intermediate.
Are you a J2EE developer looking for alternatives to JDBC or CMP Entity Beans for handling your data interactions? Are you a Hibernate user wondering about the impact EJB 3.0 may have on your application architecture? This session provides an overview of and comparison between the Hibernate and EJB 3.0 solutions to POJO persistence. Pros and cons for each are examined, as are options for migration.
Prerequisites: A working knowledge of Java and relational database concepts helpful. Any background with object-relational mapping concepts is also beneficial.
3120 Thursday, November 10, 2005 — 9:30am - 10:45am
Room: Continental Parlor 3 

3144  Using InterBase and ADO.NET
Bill Todd — The Database Group, Inc.

Type: Regular Session. Level: Intermediate.
This session provides an introduction to building database applications with ADO.NET with particular emphasis on how to use the unique features of InterBase. Topics include working with generators, controlling updates through stored procedures, using stored procedures to flatten the data model for easier user access, making joins updatable, the ADO.NET disconnected data model, using the DataSet component, managing user updates, manipulating data in code using command objects and the DataReader, and much more.
Prerequisites: Familiarity with InterBase and the basics of ADO.NET.
3144 Wednesday, November 9, 2005 — 4:45pm - 6:00pm
Room: Continental Parlor 7

3166  InterBase Security: A Whole New Ballgame  
Bill Todd — The Database Group, Inc.

Type: Regular Session. Level: Intermediate.
This session focuses on the vast array of new features in InterBase that dramatically improve InterBase security. Topics include embedded user authentication, automatic re-routing of database connections, server-side aliases, database encryption, over-the-wire encryption, and operating system security.
Prerequisites: None.
3166 Thursday, November 10, 2005 — 1:15pm - 2:30pm
Room: Continental Parlor 7

3192  Developing for SQL Server 2005  
Euan Garden — Microsoft

Type: Regular Session. Level: Intermediate.
This session demonstrates some of the myriad of new developer-orientated features in SQL Server 2005 using examples (and very few slides) in T-SQL, C#, and Delphi for .NET.
Prerequisites: Understanding of RDBMS and the Microsoft .NET Framework.
3192 Wednesday, November 9, 2005 — 3:15pm - 4:30pm
Room: Continental Parlor 1-2 

3194  Embedded User Authentication in InterBase  
Charlie Caro — Borland

Type: Regular Session. Level: Intermediate.
This session describes the user definition language (UDL) that underlies InterBase embedded user authentication (EUA) introduced in IB7.5. The architecture is designed to be backward compatible with the existing server authentication technique, allowing two-way switching between those alternatives. If time permits, an audience discussion on possible EUA extensions that would improve utility of the feature is also planned.
Prerequisites: Familiarity with database authentication mechanisms.
3194 Tuesday, November 8, 2005 — 1:30pm - 2:45pm
Room: Continental Parlor 7

4114  Leveraging the Power of In-memory DataSets
Cary Jensen — Jensen Data Systems, Inc.

Type: Regular Session. Level: Advanced.
ClientDataSet expert, Cary Jensen, shares some of the fascinating and innovative ways that in-memory datasets can be used in real-world applications. Examples demonstrated include primed caches, business objects, data abstraction layers, and self-describing data transport objects. After this presentation, you will never think of in-memory datasets in the same way again. The techniques presented in this session use ClientDataSets, but can also be implemented using Microsoft .NET Framework DataSets.
Prerequisites: Familiarity with the Delphi ClientDataSet class.
4114 Thursday, November 10, 2005 — 9:30am - 10:45am
Room: Continental Ballroom 5

4118  High Speed Multi-threaded Database Applications
Christian Wilkerson — iBASEt

Type: Regular Session. Level: Advanced.
Delphi greatly simplifies writing multi-threaded Windows applications. However, mastering multi-threaded programming can be a monster task. This presentation demonstrates not only how to develop multi-threaded code, but how to develop it safely and reliably.
Prerequisites: Requires a working knowledge of database programming.
4118 Thursday, November 10, 2005 — 1:15pm - 2:30pm
Room: Continental Ballroom 5

9004  OR Mapping with InstantObjects  
Marco Cantu — Wintech Italia Srl

Type: Birds-of-a-Feather. Level: All.
InstantObjects is an open source and actively developed Object Relational Mapping framework for Delphi. Come and learn about it, see how to get involved, and check out what's cooking in the lab.
Prerequisites: None.
9004 Wednesday, November 9, 2005 — 7:00am - 7:45am
Room: Continental Ballroom 6