Web-based report generators, data visualization, and Web-to-database connectivity

Because some Web users will be able to design a template to visualize information from scratch, while other users need to automatically visualize information by changing some parameters, providing different levels of customization of the information is a desirable goal. Our system allows the automatic generation of visualizations given the semantics of the data, and the static or pre-specified visualization by creating an interface language. We address information visualization taking into consideration the Web, where the presentation of the retrieved information is a challenge. ^ We provide a model to narrow the gap between the user's way of expressing queries and database manipulation languages (SQL) without changing the system itself thus improving the query specification process. We develop a Web interface model that is integrated with the HTML language to create a powerful language that facilitates the construction of Web-based database reports. ^ As opposed to other papers, this model offers a new way of exploring databases focusing on providing Web connectivity to databases with minimal or no result buffering, formatting, or extra programming. We describe how to easily connect the database to the Web. In addition, we offer an enhanced way on viewing and exploring the contents of a database, allowing users to customize their views depending on the contents and the structure of the data. Current database front-ends typically attempt to display the database objects in a flat view making it difficult for users to grasp the contents and the structure of their result. Our model narrows the gap between databases and the Web. ^ The overall objective of this research is to construct a model that accesses different databases easily across the net and generates SQL, forms, and reports across all platforms without requiring the developer to code a complex application. This increases the speed of development. In addition, using only the Web browsers, the end-user can retrieve data from databases remotely to make necessary modifications and manipulations of data using the Web formatted forms and reports, independent of the platform, without having to open different applications, or learn to use anything but their Web browser. We introduce a strategic method to generate and construct SQL queries, enabling inexperienced users that are not well exposed to the SQL world to build syntactically and semantically a valid SQL query and to understand the retrieved data. The generated SQL query will be validated against the database schema to ensure harmless and efficient SQL execution. (Abstract shortened by UMI.)^

Dynamic data retrieval on the World Wide Web

Methods for accessing data on the Web have been the focus of active research over the past few years. In this thesis we propose a method for representing Web sites as data sources. We designed a Data Extractor data retrieval solution that allows us to define queries to Web sites and process resulting data sets. Data Extractor is being integrated into the MSemODB heterogeneous database management system. With its help database queries can be distributed over both local and Web data sources within MSemODB framework. ^ Data Extractor treats Web sites as data sources, controlling query execution and data retrieval. It works as an intermediary between the applications and the sites. Data Extractor utilizes a twofold “custom wrapper” approach for information retrieval. Wrappers for the majority of sites are easily built using a powerful and expressive scripting language, while complex cases are processed using Java-based wrappers that utilize specially designed library of data retrieval, parsing and Web access routines. In addition to wrapper development we thoroughly investigate issues associated with Web site selection, analysis and processing. ^ Data Extractor is designed to act as a data retrieval server, as well as an embedded data retrieval solution. We also use it to create mobile agents that are shipped over the Internet to the client's computer to perform data retrieval on behalf of the user. This approach allows Data Extractor to distribute and scale well. ^ This study confirms feasibility of building custom wrappers for Web sites. This approach provides accuracy of data retrieval, and power and flexibility in handling of complex cases. ^

The role of community college faculty in teaching and learning for sustainable development

The purpose of this study was to explore the attitudes, beliefs, and practices of community college professors regarding education for sustainable development (ESD). In-depth interviews with 14 professors from different disciplines were conducted. The participants taught at Miami Dade College, Florida, a Talloires Declaration signatory since 2006, and all had attended Green Studies professional development workshops. Written documents such as assignments and samples of student work were used for triangulation. The annual report of the college’s Earth Ethics Institute and its Web site served as additional sources. The interviews were recorded, transcribed, and analyzed for common themes. The Talloires Declaration’s 10-point action plan and the key characteristics of ESD (UN DESD, 2006) served as the conceptual framework. The study found that the professors considered ESD an essential issue. The majority discussed the economic and social aspects of ESD; however, the environmental aspect was mentioned most frequently. The professors’ conceptualizations of ESD were influenced by their experiences and evidenced by the metaphors they used. Although their engagement with ESD differed, the professors expressed optimism toward ESD related teaching and learning. They regarded ESD as compatible with their subjects, and most had already been infusing sustainability into their courses or planned to do so. Additionally, the participants’ teaching practices reflected many of the characteristics of ESD. Even though the professors considered ESD challenging, they believed that they could make contributions to the college’s effort. The metaphor of “Planting a Seed” was frequently used to describe this holistic approach. The study also found that many professors regarded interpersonal relationships and communication significant factors for the advancement of ESD. The participants described several challenges to integrating ESD at their college. These related to time constraints, density of curriculum, institutional size and fragmentation, dearth of administrative support and incentives, students’ lack of academic preparation and sustainability awareness, students’ inability to focus on ESD because of personal, social, or economic circumstances, and professors’ frustration about a divisive atmosphere as a result of their engagement with sustainability. Despite these obstacles, the professors believed that ESD could be successfully woven into the community college experience.

Web Based Bicycle Trip Planning for Broward County, Florida

To promote the use of bicycle transportation mode in times of increasing urban traffic congestion, Broward County Metropolitan Planning Organization funded the development of a Web-based trip planner for cyclists. This presentation demonstrates the integration of the ArcGIS Server 9.3 environment with the ArcGIS JavaScript Extension for Google Maps API and the Google Local Search Control for Maps API. This allows the use of Google mashup GIS functionality, i.e., Google local search for selection of trip start, trip destination, and intermediate waypoints, and the integration of Google Maps base layers. The ArcGIS Network Analyst extension is used for the route search, where algorithms for fastest, safest, simplest, most scenic, and shortest routes are imbedded. This presentation also describes how attributes of the underlying network sources have been combined to facilitate the search for optimized routes.

Web-Based Training for Native American Tribes

The authors describe a project undertaken at the School of Hotel and Restaurant Management at Northern Arizona University in which the internet is used to present Native American tribes in Arizona with customer service training. It discusses why the project was instigated looks at its development and funding, and highlights the educational and technological challenges that had to be overcome. This is the second in a series of articles on the uses of the internet in educating non-university student constituencies interested in hospitality management.'

The effects of participation in an Internet -based project on the development of global knowledge, global mindedness, and global pedagogy among preservice social studies teachers

In order to prepare younger generations to live in a world characterized by interconnectedness, developing global and international perspectives for future teachers has been recommended by the National Council for the Social Studies and the National Council for the Accreditation of Teacher Education. The purpose of this study was to investigate the effects that participation in the International Communication and Negotiation Simulation (ICONS), an Internet-based communication project has on preservice social studies teachers' global knowledge, global mindedness, and global teaching strategies. ^ The study was conducted at a public university in South Florida. A combination of quantitative and qualitative approaches was employed. Two groups of preservice social studies teachers were chosen as participants: a control group composed of 14 preservice teachers who enrolled in a global education class in the summer semester of 1998 and an experimental group that included nine preservice teachers who took the same class in the fall semester of 1998. The summer class was conducted in a traditional format, which included lectures, classroom discussions, and student presentations. The fall class incorporated a five-week Internet-based communication project. The Global Mindedness Scale (Hett, 1993) and an adapted Test of Global Knowledge (ETS, 1981) were administered upon the completion of the class. ^ Contrasting case studies were utilized to investigate the impact of participation in the ICONS on the development of preservice teachers' global pedagogy. Four preservice teachers, two selected from each group were observed and interviewed to explore how they were infusing global perspectives into social studies curriculum and instruction during a 10-week student teaching internship in the spring semester of 1999. ^ This study had three major findings. First, preservice social studies teachers from the experimental group on average scored significantly higher than those from the control group on the global knowledge test. Second, no significant difference was found between the two groups in their mean scores on the Global Mindedness Scale. Third, all four selected preservice social studies teachers were infusing global perspectives into United States and world history curriculum and instruction during their student teaching internship. Using multiple resources was the common pedagogy. The two who participated in the ICONS were more aware of using the communication feature of the Internet and the web sites that reflect more international perspectives to facilitate teaching about the world. ^ Recommendations were made for further research and for preservice studies teacher education program development. ^

Web Based Bicycle Trip Planning for Broward County, Florida

To promote the use of bicycle transportation mode in times of increasing urban traffic congestion, Broward County Metropolitan Planning Organization funded the development of a Web-based trip planner for cyclists. This presentation demonstrates the integration of the ArcGIS Server 9.3 environment with the ArcGIS JavaScript Extension for Google Maps API and the Google Local Search Control for Maps API. This allows the use of Google mashup GIS functionality, i.e., Google local search for selection of trip start, trip destination, and intermediate waypoints, and the integration of Google Maps base layers. The ArcGIS Network Analyst extension is used for the route search, where algorithms for fastest, safest, simplest, most scenic, and shortest routes are imbedded. This presentation also describes how attributes of the underlying network sources have been combined to facilitate the search for optimized routes.

Dynamic data retrieval on the world wide web

Methods for accessing data on the Web have been the focus of active research over the past few years. In this thesis we propose a method for representing Web sites as data sources. We designed a Data Extractor data retrieval solution that allows us to define queries to Web sites and process resulting data sets. Data Extractor is being integrated into the MSemODB heterogeneous database management system. With its help database queries can be distributed over both local and Web data sources within MSemODB framework. Data Extractor treats Web sites as data sources, controlling query execution and data retrieval. It works as an intermediary between the applications and the sites. Data Extractor utilizes a two-fold "custom wrapper" approach for information retrieval. Wrappers for the majority of sites are easily built using a powerful and expressive scripting language, while complex cases are processed using Java-based wrappers that utilize specially designed library of data retrieval, parsing and Web access routines. In addition to wrapper development we thoroughly investigate issues associated with Web site selection, analysis and processing. Data Extractor is designed to act as a data retrieval server, as well as an embedded data retrieval solution. We also use it to create mobile agents that are shipped over the Internet to the client's computer to perform data retrieval on behalf of the user. This approach allows Data Extractor to distribute and scale well. This study confirms feasibility of building custom wrappers for Web sites. This approach provides accuracy of data retrieval, and power and flexibility in handling of complex cases.