User:Durwin
From Ingres Community Wiki
Durwin Wright, Senior Architect
My main responsibilities include the following: (1) Windows Daily and Release Builds; (2) OpenROAD Server Architecture and (3) OpenROAD eClient Architecture. I am currently involved in the OpenROAD Unicode project. I am interested in various aspects of Ingres character set handling. The idiosyncracies of Ingres Date datatypes interests me as well.
You can view my LinkedIn profile at
http://www.linkedin.com/in/durwinwright
Feel free to connect with me.
Contents |
My Background Summary
System Developer, Connectivity Developer and Project Manager in the last 30 years. Responsible for connectivity development projects using Ingres, Oracle, MS-SQL Server, Sybase, Informix, IBM-DB2, IBM-UDB, CA-Datacom, CA-IDMS, IBM-CICS, IBM-IMS and IBM-VSAM. Managed projects on numerous platforms that include: MVS, VM/370, AIX, HP-UX, Solaris, Windows and Windows CE. Have working knowledge of VB.NET, C# and MS Common Language Runtime (CLR). Also familiar with C and C++.
Additional URLs:
http://durwinwright.myplaxo.com/
My Specialties
Managed large developmentSkills in the following areas: C, C++, IBM 370 Assembler, Java, ODBC, JDBC, .NET Data Provider, ADO, ASP, ASP.NET, Visual Basic, VB.NET, OpenROAD, Ingres, Oracle, MS SQL Server, Informix, Sybase, IBM DB2, CA Datacom, CA IDMS, IBM CICS, IBM IMS, MVS, VM/370, Windows, Linux, AIX, HP-UX, Solaris, OpenVMS.
My Projects
There are a number of projects that I am either directly involved or that I am interested. The following sections are a summary of these projects along with my comments.
Empire Clients
- Investigating the depcoupling of the eClient COM registrations from the Servr registrations. Currently when the eClient and the Server (or Development) are on the same machine, this is an overlap of the registrations for the ORRSO.DLL and the ORPS.DLL.
- Investigating the introduction of MSI packaging for the eClient runtime. This would allow the runtime to be pushed from an Active Directory environment or allow an ordinary user to have their privileges termporarily elevated to allow an installation of the eClient runtime if it has been published.
- Investigating how to to allow users to package their eClient applicatinos as MSI packages.
- Investigating what it will take to allow the eClient to exist on a Microsoft Terminal Server or a Citrix Srver.
- Investigating how to install an eClient without any need to be either a local Administrator or a Power User.
- Actively working on the Empire Unicode project. One of the derivative sub-projects is to gain a a complete understanding of how Ingres handles character sets, transliteration of character sets between Ingres clients and Ingres servers and coercion between Ingres multibyte and UTF-16 datatypes.
Empire Server
- Investigating how to allow multiple Server instalations to co-exist on the same Windows system. Preferably associated with an specific Ingres installation.
- Investigating how to allow multiple Server instalations to co-exist on the same Windows system. Preferably associated with an specific Ingres installation. This project will affect all aspects the Server and Client infrastructure.
- The areas that are going to be affected are as follows:
- Client connectivity to Server
- Building the 3GL runtime on UNIX and Linux without any proprietary 3rd party software dependencies
- Replacing the Server Pooler COM-based infrastructure with an open source infrastructure.
- Replacing the Server Slave COM-based infrastructure with an open source infrastructure
- Removing the internal COM datatype dependencies
- Removing the dependency on COM/DCOM to launch the Server Pooler and Server Slave Processes
- Removing the dependency on COM/DCOM for messaging services
- Changes will be made to both the COM-based and COM-independent versions of the OpenROAD Server
Empire Project
- Investigating adding support to allow the use of UWIN or CYGWIN to build the Empire 4GL Development. There is a need to use MKS Tools today.
- Working on setting up the internal code management infrastructure for the Empire, OpenROAD 4.1 and OpenROAD 2006 development environments.
Proxy Generator (ProxyGen)
- Investigating whether Proxy Generator (ProxyGen) can be used to help create an ability for Empire 4GL clients to directly consume Web Services.
Empire Administrator
- Providing input into the requirements for the Empire Administrator requirements.
- Investigating the requirements for zero-footprint Empire Server Administrators.
WiX Generated Installer
- WiX, Windows Installer XML, is an open source project sponsored by Microsoft employers that provides a tool to generate Microsoft Installer packages -- .MSI, .MSM and .MSP.
- Research is underway to see how this technology can be used to improve the installer experience for various open source projects on Windows. These projects include the following:
- Improvements to eClient runtime installer
- Improvements to eClient User application deployment
- Improvements to eClient diagnostic capabilities
- Creation of a small footprint (under 7 Mb) eClient Net package
- Integration into Empire Workbench that will allow the creation of a variety of user application deployment options
- Experiences of others inside and outside of Ingres will also be captured as well.
Empire Codeline Management
The introduction of OpenROAD to the open source work has presented a number of challenges. This project will concern itself with how we can support development and support of the commerical versions of OpenROAD, support development of major features in OpenROAD and Empire and support the contributions made by the community.
This effort is one of our biggest challenges. While the initial offering of Empire will be the 4GL, this project will investigate the full implications of open sourcing both the 3GL and the 4GL. While there has not been a definative timeframe for the Empire 3GL open source event, we must start the preparation to support this future activity.
Articles and Content
- Piccolo Reporting Options This is an excellent analysis of Piccolo Reporting capabilities created by Ralph Loen.
Presentations
The following are a list of presentations that I have created or some of my favorite presentations done by others.
- OpenROAD Architectural Directions - This presentation was given at the Ingres 2008 Engineering Summit. It represents the current thoughts on how we should proceed with the next generation of the OpenROAD Server. It should be considered a work-in-progress.
- OpenROAD 2006 HTTP Transport - This presentation was created by a former OpenROAD Architect that describes the OpenROAD 2006 HTTP Transport as an alternative to DCOM.
- OpenROAD eClient: A Look Under the Hood - This presentation was created by Joe Kronk to describe how the OpenROAD eClient is implemented.
- OpenROAD Unicode Project Status - This presentation was created to describe the status of the OpenROAD Unicode project on April 2008. It also shows the first OpenROAD UTF8 application that displays 13 languages on a single OpenROAD frame. This include two languages, Vietnamese and Gujarati, that do not have current Ingres II_CHARSETxx settings. The data can be entered and displayed without regard for the codepage or locale setting on the client system.
- OpenROAD Signature GUID Mockup - This presentation was created by Durwin Wright to describe how the OpenROAD Signature GUID show look. This is backup informatoin for a proposal that is being investigated that will allow an administrator to configure OpenROAD Server Slaves to launch in different environments. This has the potential of allowing a production and test OpenROAD Server to co-exist on the same system. It should be considered a work-in-progress.
- OpenROAD Connection Examples - This presentation shows how to override userid and passwords from an OpenROAD application. It also shows how Ingres Dynamic Vnodes can be cretaed to access Ingres and Enterprise Access Servers. Please contact Durwin Wright to obtain access to the OpenROAD sample applications.
- Globalization: Unicode in Ingres - This is a presentation created by Jo Peel that describes Unicode support in Ingres.
- How Transparent Is OpenROAD Unicode Support - Part 1 - This is a presentations given by Durwin Wright at the UK IUA 2006 Event. Part 1 of this presentation provides an overview of Unicode.
- How Transparent Is OpenROAD Unicode Support - Part 2 - This is a presentations given by Durwin Wright at the UK IUA 2006 Event. Part 2 of this presentation describes Phase I, Phase II and Phase III of the OpenROAD Unicode Project.
Interesting Resources
During investigation of various projects, I come across a number of interesting links. The following will be used to share some of the more interesting links with others.
Interesting Ingres Community Resources
- TBD
Interesting WiX Resources
- TBD
Interesting Microsoft Resources
- TBD
