Report on the Iowa Economic Development Authority for the year ended June 30, 2012

Report on the Iowa Economic Development Authority for the year ended June 30, 2012

Mynodbcsv: Lightweight Zero-Config Database Solution for Handling Very Large CSV Files.

Volumes of data used in science and industry are growing rapidly. When researchers face the challenge of analyzing them, their format is often the first obstacle. Lack of standardized ways of exploring different data layouts requires an effort each time to solve the problem from scratch. Possibility to access data in a rich, uniform manner, e.g. using Structured Query Language (SQL) would offer expressiveness and user-friendliness. Comma-separated values (CSV) are one of the most common data storage formats. Despite its simplicity, with growing file size handling it becomes non-trivial. Importing CSVs into existing databases is time-consuming and troublesome, or even impossible if its horizontal dimension reaches thousands of columns. Most databases are optimized for handling large number of rows rather than columns, therefore, performance for datasets with non-typical layouts is often unacceptable. Other challenges include schema creation, updates and repeated data imports. To address the above-mentioned problems, I present a system for accessing very large CSV-based datasets by means of SQL. It's characterized by: "no copy" approach - data stay mostly in the CSV files; "zero configuration" - no need to specify database schema; written in C++, with boost [1], SQLite [2] and Qt [3], doesn't require installation and has very small size; query rewriting, dynamic creation of indices for appropriate columns and static data retrieval directly from CSV files ensure efficient plan execution; effortless support for millions of columns; due to per-value typing, using mixed text/numbers data is easy; very simple network protocol provides efficient interface for MATLAB and reduces implementation time for other languages. The software is available as freeware along with educational videos on its website [4]. It doesn't need any prerequisites to run, as all of the libraries are included in the distribution package. I test it against existing database solutions using a battery of benchmarks and discuss the results.

Audit report on the Iowa Agricultural Development Authority for the year ended June 30, 2013

Audit report on the Iowa Agricultural Development Authority for the year ended June 30, 2013

Audit report on the Iowa Lottery Authority for the year ended June 30, 2013

Audit report on the Iowa Lottery Authority for the year ended June 30, 2013

Audit report on the Council Bluffs Airport Authority for the year ended June 30, 2013

Audit report on the Council Bluffs Airport Authority for the year ended June 30, 2013

Iowa Finance Authority Performance Report, FY2005

Agency Performance Report

Iowa Finance Authority Performance Report, FY2006

Agency Performance Report

Iowa Finance Authority Performance Report, FY2007

Agency Performance Report

Iowa Finance Authority Performance Report, FY2008

Agency Performance Report

Iowa Finance Authority Performance Report, FY2009

Agency Performance Report

Iowa Finance Authority Performance Report, FY2010

Agency Performance Report

Iowa Finance Authority Agency Performance Plan, 2013

Agency Performance Plan

Iowa Natural Resources, Agency Performance Plan, FY2013

The work of the Department of Natural Resources impacts the lives of all Iowans. Iowans deserve a clean environment and quality natural areas for public use and enjoyment. This report reflects the progress made during fiscal year 2013 (FY13) toward our goals and provides information regarding the condition of our state’s natural resources and the effectiveness of our programs. In FY13, we continued to improve collaboration with other executive branch agencies. The DNR and DOT work very closely on the issuance of permits needed for road and bridge constructions, but recently we have also been working together to meet the administrative needs of the agencies. The DNR is working closely with the DOT to adopt an Electronic Records Management System used by the DOT. This system will improve accessibility to public documents and reduce the amount of paper files retained in storage. The DNR also continues to improve collaboration with other agencies, such as the Iowa Economic Development Authority as we work closely with them on business development in the state. The DNR strives to continually improve our customer service and how we can meet Iowan’s needs. As an example, the online reservation system for campground reservations has grown over the past eight years so that now 88% of the camping reservations are made online. The DNR continues to improve our online presence and accessibility. In FY13 the Iowa Legislature approved paying off the State’s bond debt used to construct Honey Creek Resort State Park. By removing this debt, the DNR will be able to focus more on the future of the Resort, rather than the past debt. Finally, in August of 2012, the DNR was faced with a tragic accident, where a seasonal parks employee died after rolling a mower into a lake. This incident has caused us to establish a Safety Program at the DNR and to review all of our departmental safety trainings, programs, and equipment. By focusing on our employee’s safety and well being, it is another way that we can demonstrate that at the DNR, our employees are our greatest asset.

Iowa Finance Authority Agency Performance Plan, 2014

Agency Performance Plan