Cox Colvin & Associates, Inc.

Saturday, June 26, 2010

Paradox Relational Database Turns 25!

In 1985, the Ansa Software Company (Richard Schwartz and Robert Shostak) introduced Paradox for DOS, the first relational database for the PC market. This database was ahead of the curve from day one, offering true relational database capabilities, query-by-example, and a fairly robust form generating and reporting interface. Later versions included the Paradox Application Language (PAL) that essentially allowed users to develop stand alone database applications using a rudimentary graphical user interface. PAL’s user interface was a forerunner of many of the programming environments in use today.

As MS-Windows took hold in the 1990s, Paradox (then owned by Borland Software) was the only pre-Windows database software to successfully negotiate the transition, partly because of its basic file structure. It was so well designed that databases developed in the late 1980s can still be read by the latest versions of Paradox. Despite the recent dominance of MS-Access in the PC market, Paradox (now owned by Corel) still maintains a world-wide presence, a strong user community, and a passionate following. There aren’t many software products today that can boast that they’ve survived a quarter century. I bought my first copy (Version 1.1) in 1986 and still use Paradox everyday. It’s still a great way to manage data.

As a side note, Paradox was introduced to the computing public on page 11 in the September 23, 1985 issue of InfoWorld. On the facing page of that issue was the announcement that Steve Jobs, looking not a day over 15, had resigned from Apple.

I we can help you develop or maintain your Paradox application, please drop us a line at info@coxcolvin.com, include Paradox in the subject,

Tuesday, June 22, 2010

International Conference: Green Remediation - Environment, Energy, Economics

On June 15-17, 2010 I attended the the International Conference on Green Remediation at the University of Massachusetts Amherst. The conference included a wide range of technical presentations which covered environmental, energy and economic aspects of green and sustainable remediation. Some of the presentation topics included energy requirements of treatment systems, air emissions, water use requirements and impacts on water resources, land and ecosystem use and impacts, energy use and renewables, material consumption, reuse, and waste generation. In addition to attending the presentations, I presented a poster during the conference poster session. The poster topic discussed the uncertainties and barriers associated with green and sustainable remediation encountered during a RCRA Corrective Action cleanup. Overall, the conference was very informative and provided a good indication of the current state of green and sustainable remediation from the perspective of government agencies, public and private sectors, and academia. Conference presentations and posters will be posted on-line by the end of this month. Manuscripts of proceedings will be posted on-line sometime toward the end of summer. It will be well worth your time to take a look at some of the presentations, posters, and manuscripts once they are posted on-line!

Thursday, June 17, 2010

EPA Extends Comment Period on Plan for Stricter PCE and TCE Drinking Water Limits

The Safe Drinking Water Act requires EPA to conduct a periodic review of existing National Primary Drinking Water Regulations and to determine which, if any, need to be revised. The purpose of the review, known as the Six-Year Review, is to identify those and limits requiring revision to improve or strengthen public health protection. EPA published its detailed review on March 29 2010 (75 FR 15500, March 29, 2010) and believes that four compounds are candidates for regulatory revision including acrylamide, epichlorohydrin, and the ubiquitous groundwater contaminants tetrachloroethene (PCE), and trichloroethene (TCE). The review suggest that stricter limits may be required for the compounds. Lowering of the MCLs for PCE and TCE would not only affect public drinking water supplies, but would require significant changes in groundwater monitoring programs and, in some cases, would push monitoring programs into corrective measures. EPA established a 60 day comment period for the March publication. This most recent extension, announced in a June 1 Federal Register notice, provides an additional 30 days (until July 1, 2010) to provide comments.

Wednesday, June 2, 2010

DERR Biocriteria/QHEI Training

On May 25 and 26 I attended an Ohio EPA, Department of Emergency and Remedial Response sponsored Biocriteria/Stream Habitat training. The training was geared toward environmental professionals working in the Voluntary Action Program (VAP) who may not be completing Biocriteria/Stream Habitat assessments on a regular basis, but need to know the basics because these types of assessments may be included in No Further Action (NFA) letters for VAP sites. During the training we were provided with an overview of the three components of Biocriteria/Stream Habitat assessments, including:

Index of Biotic Integrity (IBI, fish evaluation),
Invertebrate Community Index (ICI), and
Qualitative Habitat Evaluation Index (QHEI).

On day one, all the participants were given the opportunity to electro-fish and set out invertebrate samplers (Hester-Dendy) in Blacklick Creek, which flows behind the Ohio EPA Field Office. Day two was set aside for QHEI field work, which was completed in Blacklick Creek and a small recovering drainage swale near Brice Road.

Throughout the training, a general theme emerged - the biology of a stream is a better indicator of a VAP site's impact on that water body than chemical parameters monitored through surface water and sediment grab samples. Often, even if chemical standards are not met, biological/habitat assessment activities are able to demonstrate that the stream meets it Ohio EPA use designation, and that additional assessment or remedial activities are not needed. Interestingly, the instructors indicated that the stream and riparian habitat, or lack thereof, is more often the cause of stream impairment at VAP sites, not the release of chemicals of concern to the stream. The take home message was that chemical analysis alone may not give a CP the complete picture of how a VAP site affected the stream; rather a biological/habitat assessment including an IBI, ICI, and QHEI provides a better representation.