Collaborative approaches to the management of e-learning (CAMEL)

A teaching and learning project funded by the Office of Learning, Enhancement, Access and Participation (LEAP) at the University of Greenwich.

Community Fisheries Development Office (CFDO) strategic plan, January 2004

In October 2000 the government of Cambodia announced a major change in fisheries management policy. The core elements of the new policy are the reduction of fishing lot concession areas by 56%, the broader participation of fishing communities in the management of fisheries and a focus on the efficient, sustainable and equitable use of the living aquatic resources. To facilitate the establishment and development of the Community Fisheries, support and monitor their activities, the Department of Fisheries was authorized1 to establish a Community Fisheries Development Office (CFDO). (Pdf contains 19 pages).

Symposium on participatory approaches to reservoir fisheries management: issues, challenges and policies. Dambulla, Sri Lanka, 04-06 Oct. 2004 Session I. Community-based fisheries management; experience in other countries: presentation on STREAM Vietnam’s experience

Established in early 2002, STREAM Vietnam has so far attained a number of good experiences and lessons in using participatory approaches for its work. The Country Office has been able to link to a wide range of stakeholders, and is working hard to build close relationships amongst them, so that institutional entities can better support the livelihoods of poor aquatic resources users, and support disadvantaged groups of people to improve their living standards by themselves. Reservoir fisheries and co-management are at early stage in Vietnam, but in certain places and industries co-management has brought about successful results by involving proactive participation of communities. Situated on the same continent and having many similarities, the interaction in agriculture and fisheries sector between Vietnam and Sri Lanka has brought the two countries closer. Being members of the STREAM family, there are great opportunities for exchange of experiences and lessons towards sustainable management of reservoir resources. (PDF has 11 pages.)

Panama City Fisheries Resources Office: FY 2009 Annual Report

HIGHLIGHTS FOR FY 2009 1. Completed the second of a two-year Gulf sturgeon population study on the Choctawhatchee River, Florida. The juvenile, sub adult and adult Gulf sturgeon population was estimated at 3,400 fish. 2. Three young of year Gulf sturgeon were collected by Corps of Engineers biologists in the upper Brothers Rivers. 3. Two YCC enrollees spent eight weeks assisting PCFO biologists and Tyndall AFB with various projects. 4. The Gulf Sturgeon 5-Year Summary and Evaluation was completed. 5. Karen Herrington co-authored a peer-reviewed journal article for a striped bass symposium at the annual American Fisheries Society meeting, which will be published in the symposium proceedings. The article reviews the past 25 years of striped bass restoration in the ACF and is titled “Restoration of Gulf Striped Bass: Lessons and Management Implications”. 6. We documented recent purple bankclimber recruitment in the Ochlockonee River for the first time in several years. 7. We provided over 200 genetic samples to Warm Springs Fish Technology Center to compare mussel populations and genetic diversity, rank populations by status, and facilitate recovery actions. 8. We established permanent mussel monitoring locations in Sawhatchee Creek and the Flint River to examine trends in population size, survival, and recruitment. 9. We provided a prioritized list to the Federal Emergency Management Agency of 197 stream crossings that occur near freshwater mussel populations in order to facilitate habitat restoration following major flooding in Alabama, Florida, and Georgia in the spring of 2009.

Panama City Fisheries Resources Office: FY 2008 Annual Report

HIGHLIGHTS FOR FY 2008 1. Completed the first of a two-year Gulf sturgeon population study on the Choctawhatchee River, Florida. The sub adult and adult Gulf sturgeon population was estimated at 2,800 fish. 2. Gulf sturgeon eggs were collected at three hard bottom sites in the Apalachicola River, Florida; two sites were previously confirmed spawning areas and one was a newly confirmed spawning area. 3. Documented 55 potential environmental threats to Gulf sturgeon spawning habitat in the Pea River, Florida and Alabama. 4. Assigned the Eglin AFB Road-Stream Crossing Working Group to guide the closure, repair and maintenance of roads and road stream crossings that impact threatened and endangered species. 5. Conducted 81 assessments of fish and stream invertebrates on and in watersheds surrounding Eglin AFB. 6. Provided technical support for the 5-year status review and reclassification proposed rule for the Okaloosa darter. 7. Initiated an intensive population genetic analysis of the Okaloosa darter throughout its range. Tissues from over 200 Okaloosa darters were collected and analyzed. 8. Established a GIS database to serve as a host for data from any sites sampled for mussels in Northeast Gulf of Mexico drainages. 9. Conducted habitat surveys at 115 locations in the Apalachicola River to assess the effects of drought-related mussel mortality and strandings, evaluate habitat conditions, and assess population demography. 10. A land use/aerial imagery threats assessment data analysis was completed for the Chipola River. A total of 266 impoundments/borrow pits and 471 unpaved road crossings were identified among the threats. 11. Okaloosa darters marked with elastomeric dyes were monitored in Mill Creek, Eglin AFB, to determine movement and habitat use following completion of a fish passage project. 3 12. Partners for Fish and Wildlife funded a streambank and riparian restoration project on Econfina Creek consisting of 3,900 feet of streambank fencing to exclude cattle access. One acre of riparian floodplain was planted with native trees. 13. We provided design and on-the-ground assistance for restoring surface hydrology at St. Vincent NWR. The project restored approximately 1.5 miles of tidal stream and 100 acres of wetlands. 14. A study was completed on 11 coastal streams to document large wood debris relationships with fluvial geomorphic characteristics. 15. We developed a Population Viability Analysis model for the fat threeridge mussel to determine current and future risk of extinction. 17. A Gulf Sturgeon Friends Group, “Gulf Sturgeon Preservation Society” was organized in FY 08. 18. Multiple outreach projects were completed to detail aquatic resource conservation needs and opportunities, including National Fishing Week, Earth Day, several festivals and school outreach.

Panama City Fisheries Resources Office: FY 2007 Annual Report

HIGHLIGHTS FOR FY 2007 1. Completed a three-year Gulf sturgeon population study on the Escambia River, Florida. The population was estimated at 451 fish. 2. Implemented the Gulf Striped Bass Restoration Plan by coordinating the 24th Annual Morone Workshop, leading the technical committee, transporting broodfish, coordinating stocking on the Apalachicola-Chattahoochee-Flint (ACF) river system, and evaluating post-stocking success. 3. Completed a survey to document the extent of aquatic resources, recreational fishing opportunities, and fishery management needs on Department of Defense (DoD) facilities located in Region 4. 4. Continued a project in the Apalachicola River to describe the effects of exceptional drought conditions on freshwater mussel recovery. 5. Initiated a study to locate extant populations of the federally endangered Ochlockonee moccasinshell in the Ochlockonee River Basin. We documented the first live individuals in 14 years. 6. Completed a five-year status review for seven threatened and endangered freshwater mussels in the NEG drainages. 7. Restored Mill Creek to improve habitat for the endangered Okaloosa darter by removing six fish passage barriers and creating approximately 3,000 linear feet of new and regenerated stream channel with floodplain and native vegetation. 8. Completed a fish passage project that connected about 5 miles of habitat in Little Rocky Creek, Eglin Air Force Base, to benefit the Okaloosa darter. 9. Completed a threats analysis to aquatic species in the Chipola River watershed using GIS stream data, aerial imagery, and land cover data. 10. Multiple outreach projects were completed to detail aquatic resource conservation needs and opportunities, including National Fishing Week, Earth Day, several festivals, and school outreach.

Panama City Fisheries Resources Office: FY 2006 Annual Report

HIGHLIGHTS FOR FY 2006 1. Captured and tagged 475 Gulf sturgeons in five Florida rivers and one bay. 2. Documented Gulf sturgeon marine movement and habitat use in the Gulf of Mexico. 3. Assisted the National Oceanic and Atmospheric Administration (NOAA) with the collection of Gulf sturgeon, implantation of acoustic tags, and monitoring of fish in a study to examine movement patterns and habitat use in Pensacola and Choctawhatchee bays post-Hurricane Ivan. 4. Provided technical assistance to Jon “Bo” Sawyer in completing a study – Summer Resting Areas of the Gulf Sturgeon in the Conecuh/Escambia River System, Alabama-Florida – for acquiring a Degree of Master of Science at Troy University, Alabama. 5. Coordinated tagging and data collection with NOAA observers aboard trawlers while collecting Gulf sturgeon during dredging operations in the coastal Gulf of Mexico. 6. Hosted the 7th Annual Gulf Sturgeon Workshop. 7. Implemented Gulf Striped Bass Restoration Plan by coordinating the 23rd Annual Morone Workshop, leading the technical committee, transporting broodfish, coordinating the stocking on the Apalachicola-Chattahoochee-Flint (ACF) river system, and evaluating post-stocking success. 8. Continued updating and managing the Freshwater Mussel Survey Database, a Geographic Information System (GIS) database, for over 800 unique sites in the Northeast Gulf (NEG) drainages in Alabama (AL), Georgia (GA), and Florida (FL). 9. Formed a recovery implementation team for listed mussels in the ACF river basin and oversaw grant cooperative agreements for 14 listed and candidate freshwater mussels in the NEG watersheds. 10. Initiated a project in the Apalachicola River to relocate mussels stranded as a result of drought conditions, and calculate river flows at which mussels would be exposed. 11. Initiated a project in Sawhatchee Creek, Georgia to determine the status of threatened and endangered (T&E) freshwater mussels and target restoration projects, population assessments, and potential population augmentation to lead toward recovery of the listed species. 12. Initiated a study to determine the age and growth of the endangered fat threeridge mussel (Amblema neislerii). 13. Provided technical assistance to the Panama City Ecological Services office for a biological opinion on the operations of Jim Woodruff Lock and Dam and its effects on the listed species and designated and proposed critical habitat in the Apalachicola River, Florida. 14. Assisted with a multi-State, inter-agency team to develop a management plan to restore the Alabama shad in the ACF river system. 15. Conducted fishery surveys on Tyndall AFB, Florida and Ft. Benning, Georgia and completed a report with recommendations for future recreational fishery needs. 16. Provided fishery technical assistance to four National Wildlife Refuges (NWR) (i.e., Okefenokee NWR, Banks Lake NWR, St. Vincent NWR, and St. Marks NWR). 17. Initiated an Aquatic Resources and Recreation Fishing Survey on Department of Defense facilities located in Region 4. 18. Identified 130 road-stream crossings on Eglin AFB for rehabilitation and elimination of sediment imputs. 19. Continued the Aquatics Monitoring Program at Eglin AFB to assess techniques that determine current status and sustainability of aquatic habitat and develop a measure to determine quality or degradation of habitat. 20. Assisted Eglin AFB Natural Resource managers in revising the installation’s Integrated Natural Resources Management Plan (INRMP) and its associated component plans. 21. Coordinated recovery efforts for the endangered Okaloosa darter including population/life history surveys, stream restoration, and outreach activities. 22. Initiated a comprehensive status review of the Okaloosa darter with analyses performed to assess available habitat, preferred habitats, range expansions/reductions/fragmentations, population size, and probability of extinction. 23. Assisted the Gulf Coastal Plain Ecosystem Partnership and the Florida Fish and Wildlife Conservation Commission (FWC) under a Memorandum of Agreement to develop conservation strategies, implement monitoring and assessment programs, and secure funds for aquatic management programs in six watersheds in northwest Florida and southeast Alabama. 24. Entered into a cooperative agreement with the U.S. Air Force to encourage the conservation and rehabilitation of natural resources at Hurlburt Field, Florida. 25. Multiple outreach projects were completed to detail aquatic resources’ conservation needs and opportunities; including National Fishing Week, Earth Day, several festivals, and school outreach.

Panama City Fisheries Resources Office: FY 2005 Annual Report

HIGHLIGHTS FOR FY 2005 1. Assisted with a study to assess hurricane impacts to Gulf sturgeon critical foraging habitat. 2. Documented Gulf sturgeon marine movement and habitat use in the Gulf of Mexico. 3. Documented Gulf sturgeon spawning with the collection of fertilized eggs in the Apalachicola River, Florida. 4. Documented Gulf sturgeon spawning with the collection of fertilized eggs in the Yellow River, Florida. 5. Assisted with benthic invertebrate survey at Gulf sturgeon marine foraging grounds. 6. Implemented Gulf Striped Bass Restoration Plan by coordinating the 22nd Annual Morone Workshop, leading the technical committee, transporting broodfish, and coordinating the stocking on the Apalachicola-Chattahoochee-Flint (ACF) river system. 7. Over 87,000 Phase II Gulf striped bass were marked with sequential coded wire tags and stocked in the Apalachicola River. Post-stocking evaluations were conducted at 45 sites in the fall and spring and 8 thermal refuges in the summer. 8. Completed fishery surveys on 4 ponds on Eglin AFB totaling 53 acres, and completed a report with recommendations for future recreational fishery needs. 9. Completed final report for aquatic monitoring at Eglin AFB from 1999 to 2004. 10. Completed a field collection of the endangered Okaloosa darter to be incorporated into a status review to be completed in FY06. 11. Provided technical assistance to the Region 4 National Wildlife Refuge (NWR) program on changes to the fishery conservation targets for the region. Also provided technical assistance to four NWRs (i.e., Okefenokee NWR, Banks Lake NWR, St. Vincent NWR, and St. Marks NWR) relative to hurricanes and recreational fishing. 12. A draft mussel sampling protocol was tested in wadeable streams in Northwest Florida and southwest Georgia, and an associated field guide, poster, and Freshwater Mussel Survey Protocol and Identification workshop were completed in FY05. 13. Implemented recovery plan and candidate conservation actions for 14 listed and candidate freshwater mussels in the Northeast Gulf Watersheds. 14. Initiated or completed multiple stream restoration and watershed management projects. A total of 7.5 stream miles were restored for stream fishes, and 11 miles of coastline were enhanced for sea turtle lighting. A total of 630 acres of wetlands and 2,401 acres of understory habitat were restored. 15. Conducted a watershed assessment to develop a threats analysis for prioritizing restoration, protection, and enhancement to natural resources of Spring Creek, Georgia and Canoe Creek, Florida. 16. Continued the formation of an Unpaved Road Interagency Team of Federal, State, and local agencies in Northwest Florida to promote stream protection and restoration from unpaved road sediment runoff. Began the development of a technical committee agreement. 17. Conducted Alabama Unpaved Road Inventory within the Northeast Gulf Ecosystem. Data collection will be completed during FY06. 18. Finalized the development of two North Florida hydrophysiographic regional curves for use by the Florida Department of Transportation (DOT) and others involved with stream restoration and protection. Initiated the development of the Alabama Coastal Plain Riparian Reference Reach and Regional Curves for use by the Alabama Department of Environmental Management (ADEM). 19. Provided technical assistance in collecting data, analysis, and thesis formulation with Troy University, Alabama, to identify the influence of large woody debris in southeastern coastal plain streams. 20. Completed pre- and post-restoration fish community monitoring at several restoration projects including Big Escambia Creek, Magnolia Creek, and Oyster Lake, Florida. 21. Established a watershed partnership for the Chipola River in Alabama and Florida and expanded development and participation in the Spring Creek Watershed Partnership, Georgia. 22. Continued to identify barriers which inhibit the movement of aquatic species within the Northeast Gulf Ecoregion. 23. Completed a report on road crossing structures in Okaloosa darter streams to guide the closure/repair/maintenance of roads to contribute to recovery of the endangered species. In cooperation with Three Rivers RC&D Council, fish passage sites identified in the report were prioritized for restoration. 24. Monitored Aquatic Nuisance Species in the Apalachicola River and tested the sterility of exotic grass carp. 25. Multiple outreach projects were completed to detail aquatic resources conservation needs and opportunities. Participated in National Fishing Week event, several festivals, and school outreach.

Panama City Fisheries Resources Office: FY 2004 Annual Report

HIGHLIGHTS FOR FY 2004 1. Completed the second of a 3-year Gulf sturgeon population estimate on the Escambia River, Florida. 2. Completed the first of a 2-year Gulf sturgeon population estimate on the Apalachicola River, Florida. 3. Conducted Gulf sturgeon presence-absence surveys in three other Florida river systems. 4. Documented Gulf sturgeon marine habitat use in the near shore waters of the Gulf of Mexico. 5. Identified environmental threats to Gulf sturgeon spawning habitat in the Choctawhatchee River, Florida. 6. Initiated a study to document Gulf sturgeon spawning with the collection of fertilized eggs in the Yellow River, Florida. 7. Implemented Gulf Striped Bass Restoration Plan by coordinating the 21st Annual Morone Workshop, leading the technical committee, transporting broodfish, and coordinating the stocking on the Apalachicola-Chattahoochee-Flint (ACF) river system. 8. Over 86,000 Phase II Gulf striped bass were marked with sequential coded wire tags and stocked in Lake Seminole and the Apalachicola River. Post-stocking evaluations were conducted at 31 sites. 9. Drafted updates to Apalachicola-Chattahoochee-Flint Striped Bass Restoration and Evaluation Five-Year Plan with partners. 10. Fishery surveys were conducted on Tyndall Air Force Base and St. Marks and St. Vincent National Wildlife Refuges. 11. Habitat evaluations and population surveys were completed at 153 Okaloosa darter stream sites. 12. Aquatic insect biomonitoring and identification of over 39,000 individual aquatic macroinvertebrates was completed and provided to Eglin Air Force Base. 13. Ten years of fishery data from Okefenokee and Banks Lake National Wildlife Refuges was analyzed with recommendations incorporated into the refuge Comprehensive Conservation Plan. 14. A draft mussel sampling protocol was tested in wadeable streams in northwest Florida and southwest Georgia. 15. Implemented recovery plan and candidate conservation actions for 14 listed and candidate freshwater mussels in the Northeast Gulf Watersheds. 16. Worked with partners in developing the Spring Creek Watershed Partnership in the Flint River basin, Georgia. 17. Multiple stream restoration and watershed management projects were initiated or completed. A total of 6.8 stream miles were restored for stream fishes, along with 56.4 miles of coastline were enhanced for sea turtle lighting. A total of 135 acres of wetlands and 58 acres of understory habitat were restored. 18. Multiple outreach projects were completed to detail aquatic resources conservation needs and opportunities. Participated in National Fishing Week event, BASS ProShops event, several festivals, and school outreach.

Panama City Fisheries Resources Office: FY 2003 Annual Report

HIGHLIGHTS FOR FY 2003 1. Continued a 3-year threatened Gulf sturgeon population estimate in the Escambia River, Florida and conducted presence-absence surveys in 4 other Florida river systems and 1 bay. 2. Five juvenile Gulf sturgeon collected, near the mouth of the Choctawhatchee River, Florida, were equipped with sonic tags and monitored while over-wintering in Choctawhatchee Bay. 3. Continued to examine Gulf sturgeon marine habitat use. 4. Implemented Gulf Striped Bass Restoration Plan by coordinating the 20th Annual Morone Workshop, leading the technical committee, transporting broodfish, and coordinating the stocking on the Apalachicola-Chattahoochee-Flint (ACF) river system. 5. Over 73,000 Phase II Gulf striped bass were marked with sequential coded wire tags and stocked in the Apalachicola River. Post-stocking evaluations were conducted at 31 sites. 6. Three stream fisheries assessment s were completed to evaluate the fish community at sites slated for habitat restoration by the Partners for Fish and Wildlife Program (PFW). 7. PFW program identified restoration needs and opportunities for 10 areas. 8. Developed an Unpaved Road Evaluation Handbook. 9. Completed restoration of Chipola River Greenway, Seibenhener Streambank Restoration, Blackwater River State Forest, and Anderson Property. 10. Assessments for fluvial geomorphic conditions for design criteria were completed for 3 projects. 11. Geomorphology in Florida streams initiated development of Rosgen regional curves for Northwest Florida for use by the Florida Department of Transportation. 12. Developed a Memorandum of Understanding between partners for enhancing, protecting, and restoring stream, wetland, and upland habitat in northwest Florida 13. Completed aquatic fauna and fish surveys with new emphasis on integration of data from reach level into watershed and landscape scale and keeping database current. 14. Compliance based sampling of impaired waterbodies on Eglin Air Force Base in conjunction with Florida Department of Environmental Protection for Total Maximum Daily Load development support. 15. Surveyed 20 sites for the federally endangered Okaloosa darter, provided habitat descriptions, worked with partners to implement key recovery tasks and set priorities for restoration. 16. Worked with partners to develop a freshwater mussel survey protocol to provide standard operating procedures for establishing the presence/absence of federally listed mussel species within a Federal project area. 17. GIS database was created to identify all known freshwater mussel records from the northeast Gulf ecosystem. 18. Completed recovery plan for seven freshwater mussels and drafted candidate elevation package for seven additional mussels. Developed proposals to implement recovery plan. 19. Worked with Corps of Engineers and State partners to develop improved reservoir operating policies to benefit both riverine and reservoir fisheries for the ACF river system. 20. Multiple outreach projects were completed to detail aquatic resources conservation opportunities. 21. Multiple stream restoration and watershed management projects initiated or completed (see Appendix A).

Panama City Fisheries Resources Office: FY 2002 Annual Report

HIGHLIGHTS FOR FY 2002 1. United States Senator Bob Graham assisted with a Gulf sturgeon survey. 2. Completed 3-year Gulf sturgeon population study in the Choctawhatchee River drainage. 3. Completed Gulf sturgeon potential spawning habitat survey for Northwest Florida and Southeast Alabama river systems. 4. Initiated Gulf sturgeon marine habitat and food resources study. 5. Completed Gulf sturgeon sentinel fish study. 6. Coordinated and conducted tagging of over 110,000 Phase II striped bass at Welaka and Warm Springs National Fish Hatchery. 7. Completed Okefenokee National Wildlife Refuge fishery sampling. 8. Developed a manuscript regarding the fishery of Banks Lake NWR. 9. Initiated development of a fish Index of Biotic Integrity for Florida panhandle streams. 10. Coordinated Okaloosa darter workshop. 11. Continued examining insect communities on Eglin AFB. 12. Sponsored and coordinated stream restoration workshop. 13. Provided technical assistance via Partners for Fish and Wildlife for stream restoration within the Northeast Gulf Ecosystem. 14. Finalized regional curve development in the Northern Region of Florida and secured significant funds for FY03 to expand to other regions in Florida. 15. Initiated freshwater mussel conservation in the Northeastern Gulf Ecosystem.

Mesophotic coral ecosystems research strategy: international workshop to prioritize research and management needs for mesophotic coral ecosystems, Jupiter, Florida, 12-15 July 2008

On July 12-15, 2008, researchers and resource managers met in Jupiter, Florida to discuss and review the state of knowledge regarding mesophotic coral ecosystems, develop a working definition for these ecosystems, identify critical resource management information needs, and develop a Mesophotic Coral Ecosystems Research Strategy to assist the U.S. National Oceanic and Atmospheric Administration (NOAA) and other agencies and institutions in their research prioritization and strategic planning for mesophotic coral ecosystems. Workshop participants included representatives from international, Federal, and state governments; academia; and nongovernmental organizations. The Mesophotic Coral Ecosystems Workshop was hosted by the Perry Institute for Marine Science (PIMS) and organized by NOAA and the U.S. Geological Survey (USGS). The workshop goals, objectives, schedule, and products were governed by a Steering Committee consisting of members from NOAA (National Centers for Coastal Ocean Science’s Center for Sponsored Coastal Ocean Research, the Office of Ocean Exploration and Research’s NOAA Undersea Research Program, and the National Marine Fisheries Service), USGS, PIMS, the Caribbean Coral Reef Institute, and the Bishop Museum.

Predicting the performance of an office under climate change: A study of metrics, sensitivity and zonal resolution

Climate change is expected to have significant impact on the future thermal performance of buildings. Building simulation and sensitivity analysis can be employed to predict these impacts, guiding interventions to adapt buildings to future conditions. This article explores the use of simulation to study the impact of climate change on a theoretical office building in the UK, employing a probabilistic approach. The work studies (1) appropriate performance metrics and underlying modelling assumptions, (2) sensitivity of computational results to identify key design parameters and (3) the impact of zonal resolution. The conclusions highlight the importance of assumptions in the field of electricity conversion factors, proper management of internal heat gains, and the need to use an appropriately detailed zonal resolution. © 2010 Elsevier B.V. All rights reserved.

Remote Wireless Communications for Construction Management: A Case Study

The recent advances in urban wireless communications and protocols that spurred the development of city-wide wireless infrastructure motivated this research, since in many cases, construction sites are not conveniently located for wired connectivity. Large scale transportation projects for example, such as new highways, railroad tracks and the networks of utilities (power-lines, phone lines, mobile towers, etc) that usually follow them are constructed in areas where wired infrastructure for data exchange is often expensive and time-consuming to deploy. The communication difficulties that can be encountered in such construction sites can be addressed with a wireless communications link between the construction site and the decision-making office. This paper presents a case study on long-range, wireless communications suitable for data exchange between construction sites and engineering headquarters. The purpose of this study was to define the requirements for a reliable wireless communications model where common types of electronic construction data will be exchanged in a fast and efficient manner, and construction site personnel will be able to interact and share knowledge, information and electronic resources with the office staff.

Client-based Logging: A New Paradigm of Distributed Transaction Management

The proliferation of inexpensive workstations and networks has created a new era in distributed computing. At the same time, non-traditional applications such as computer-aided design (CAD), computer-aided software engineering (CASE), geographic-information systems (GIS), and office-information systems (OIS) have placed increased demands for high-performance transaction processing on database systems. The combination of these factors gives rise to significant challenges in the design of modern database systems. In this thesis, we propose novel techniques whose aim is to improve the performance and scalability of these new database systems. These techniques exploit client resources through client-based transaction management. Client-based transaction management is realized by providing logging facilities locally even when data is shared in a global environment. This thesis presents several recovery algorithms which utilize client disks for storing recovery related information (i.e., log records). Our algorithms work with both coarse and fine-granularity locking and they do not require the merging of client logs at any time. Moreover, our algorithms support fine-granularity locking with multiple clients permitted to concurrently update different portions of the same database page. The database state is recovered correctly when there is a complex crash as well as when the updates performed by different clients on a page are not present on the disk version of the page, even though some of the updating transactions have committed. This thesis also presents the implementation of the proposed algorithms in a memory-mapped storage manager as well as a detailed performance study of these algorithms using the OO1 database benchmark. The performance results show that client-based logging is superior to traditional server-based logging. This is because client-based logging is an effective way to reduce dependencies on server CPU and disk resources and, thus, prevents the server from becoming a performance bottleneck as quickly when the number of clients accessing the database increases.