Query optimization by using derivability in a data warehouse environment

Materialized summary tables and cached query results are frequently used for the optimization of aggregate queries in a data warehouse. Query rewriting techniques are incorporated into database systems to use those materialized views and thus avoid the access of the possibly huge raw data. A rewriting is only possible if the query is derivable from these views. Several approaches can be found in the literature to check the derivability and find query rewritings. The specific application scenario of a data warehouse with its multidimensional perspective allows the consideration of much more semantic information, e.g. structural dependencies within the dimension hierarchies and different characteristics of measures. The motivation of this article is to use this information to present conditions for derivability in a large number of relevant cases which go beyond previous approaches

Multiagent System for Image Mining

The overdone growth, wide availability, and demands for remote sensing databases combined with human limits to analyze such huge datasets lead to a need to investigate tools, techniques, methodologies, and theories capable of assisting humans at extracting knowledge. Image mining arises as a solution to extract implicit knowledge intelligently and semiautomatically or other patterns not explicitly stored in the huge image databases. However, spatial databases are among the ones with the fastest growth due to the volume of spatial information produced many times a day, demanding the investigation of other means for knowledge extraction. Multiagent systems are composed of multiple computing elements known as agents that interact to pursuit their goals. Agents have been used to explore information in the distributed, open, large, and heterogeneous platforms. Agent mining is a potential technology that studies ways of interaction and integration between data mining and agents. This area brought advances to the technologies involved such as theories, methodologies, and solutions to solve relevant issues more precisely, accurately and faster. AgentGeo is evidence of this, a multiagent system of satellite image mining that, promotes advances in the state of the art of agent mining, since it relevant functions to extract knowledge from spatial databases

The History, Present Condition, and Future of the Molluscan Fisheries of North and Central America and Europe: Volume 2, Pacific Coast and Supplemental Topics

Over 100 molluscan species are landed in Mexico. About 30% are harvested on the Pacific coast and 70% on the Atlantic coast. Clams, scallops, and squid predominate on the Pacific coast (abalone, limpets, and mussels are landed there exclusively). Conchs and oysters predominate on the Atlantic coast. In 1988, some 95,000 metric tons (t) of mollusks were landed, with a value of $33 million. Mollusks were used extensively in prehispanic Mexico as food, tools, and jewelry. Their use as food and jewelry continues. Except in the States of Baja California and Baja California Sur, where abalone, clams, and scallops provide fishermen with year-round employment, mollusk fishing is done part time. On both the Pacific and Atlantic coasts, many fishermen are nomads, harvesting mollusks wherever they find abundant stocks. Upon finding such beds, they build camps, begin harvesting, and continue until the mollusks become so scarce that it no longer pays to continue. They then look for productive beds in other areas and rebuild their camps. Fishermen harvest abalones, mussels, scallops, and clams by free-diving and using scuba and hooka. Landings of clams and cockles have been growing, and 22,000 t were landed in 1988. Fishermen harvest intertidal clams by hand at wading depths, finding them with their feet. In waters up to 5 m, they harvest them by free-diving. In deeper water, they use scuba and hooka. Many species of gastropods have commercial importance on both coasts. All species with a large detachable muscle are sold as scallops. On the Pacific coast, hatchery culture of oysters prevails. Oyster culture in Atlantic coast lagoons began in the 1950's, when beds were enhanced by spreading shells as cultch for spat. (PDF file contains 228 pages.

Aeronautical Engineering: A Continuing Bibliography With Indexes

This report lists reports, articles and other documents recently announced in the NASA STI Database. The coverage includes documents on the engineering and theoretical aspects of design, construction, evaluation, testing, operation, and performance of aircraft (including aircraft engines) and associated components, equipment, and systems. It also includes research and development in aerodynamics, aeronautics, and ground support equipment for aeronautical vehicles

Annual Report of the University, 1999-2000, Volumes 1-4

The Robert O. Anderson School and Graduate School of Management at The University of New Mexico Period of Report: July 1, 1999 to June 30, 2000 Submitted by Howard L. Smith, Dean The Anderson Schools of Management is divided into four distinct divisions- the Department of Accounting; the Department of Finance, International and Technology Management; the Department of Marketing, Information and Decision Sciences; and the Department of Organizational Studies. This structure provides an opportunity for The Anderson Schools to develop four distinct areas of excellence, proven by results reported here. I. Significant Developments During the Academic Year The Anderson Schools of Management • As a result of the multi-year gift from the Ford Motor Company, completed renovation of The Schools\u27 Advisement and Placement Center, as well as all student organization offices. • The Ford gift also provided for $100,000 to support faculty research, case studies and course development. • The Schools revised the MBA curriculum to meet the changing needs of professional, advanced business education. • The Schools updated computer laboratory facilities, with the addition of a 45-unit cluster for teaching and student work. • The faculty and staff of The Schools furthered outreach in economic development activities by participating directly as committee members and leaders in the cluster workgroups of the Next Generation Economy Initiative. • The faculty, staff and students of The Schools contributed to the development of the Ethics in Business Awards; particularly exciting was the fact that all nominee packages were developed by student teams from The Anderson Schools. • The Schools continue to generate more credit hours per faculty member than any other division of the UNM community. The Accounting Department • Preparation and presentation of a progress report to accrediting body, the AACSB. The Department of Finance, International and Technology Management • The Department continued to focus on expansion of the Management of Technology program as a strategic strength of The Schools. The Department of Marketing. Information and Decision Sciences • Generated 9022 credit hours, with a student enrollment of 3070. The Department of Organizational Studies • Coordinated the 9th UNM Universidad de Guanajuato (UG) Mexico Student Exchange

Conceptual design model for youth personal decision aid

Youth tend to face many areas of decision making with multiple choices. However, existing decision making tools are too complex and are not easily understood by the youth. Besides, complex and structured mathematical techniques are not preferred by the users as compared to direct and straightforward design model. Additionally, theoretical foundation for decision making is not adequately considered in designing and developing decision aid technologies. Therefore, there is a need in considering and including relevant multi-criteria technique, model and theory in the development of personal decision aids. The main aim for this study is to construct a conceptual design model for Youth Personal Decision Aid (YouthPDA). The following objectives are outlined to support the major aim: i) to identify relevant decision making criteria, techniques, and theoretical foundations for YouthPDA, ii) to construct a conceptual design model for YouthPDA using the identified decision making techniques, criteria, and theoretical foundation, iii) to validate the conceptual design model of YouthPDA through expert review, and iv) to measure the correlation between usefulness dimensions of YouthPDA via prototyping. Design research is chosen as the approach and three main phases are adopted which are Problem Identification, Solution Design, and Evaluation. YouthPDA is developed as a personalised decision aid for youth to help them choose their study and career paths. By integrating data from the youth personality traits and multiple intelligences, YouthPDA functions as a recommender system that works on rule-based reasoning. The usefulness of YouthPDA is measured in the evaluation phase. Findings from 189 respondents show that the proposed YouthPDA is useful for youth as their decision making tool. Accuracy, Decision Strategy, Satisfaction, Knowledge Acquisition and Overall Usefulness are the dimensions being measured and correlated to put forward the conclusion. The selected multi-criteria, techniques and theories embedded into the validated conceptual design model are the main contributions of this stud

Dusky Grouse Population Ecology and Thermal Landscape Ecology in the Great Basin Ecosystem

Dusky Grouse are a mountainous forest grouse found throughout the western, inland mountain ranges of the United States and Canada. While a few studies have looked at Dusky Grouse in the Rocky Mountain Ecosystem of their range, there have been no prior studies of the Dusky Grouse in the Great Basin Ecosystem aside from a brief survey by Zwickel and Bendell in 2004 in the Duck Creek Range of Nevada. With the available habitats differing in both species diversity and availability on the landscape between the two Ecosystems, I wanted to assess characteristics about the Dusky Grouse populations at the southwestern edge of their range in the Great Basin Ecosystem. Thus, I estimated the abundance of Dusky Grouse in the Schell Creek, Duck Creek, and Egan Ranges of White Pine County, Nevada, as well as created a monitoring protocol for continued monitoring of abundance in these areas. I estimated a density of 5 males/km2. I also assessed the seasonal habitat selection of Dusky Grouse in the White Pine County study areas during breeding, nesting, brooding, and over winter. Dusky Grouse used aspen, conifers, and mountain shrubland habitat types the most across the seasons. Finally, I determined the varying temperatures of the study area’s landscape during peak summer and identified possible thermal refuge, or areas that protect species from extreme heat, for an array of wildlife taxa on the landscape. Aspen and conifer stands offered the coolest thermal refuge during peak hours of the summer compared to mountain mahogany, pinyon-juniper, and mountain shrublands. This research is new for the Great Basin Ecosystem, as well as for Dusky Grouse literature as a whole

Yaquina Bay bibliography by date to 2023

Oregon's estuaries are important ecosystems for scientific study. Consequently, knowledge of what research has been conducted helps us identify benchmarks and plan new projects. A comprehensive bibliography of published research, technical reports, local documents, and data sets is one means of recording this knowledge. For these reasons, the Guin Library staff have compiled bibliographies on Netarts Bay, the Salmon River Estuary, Siletz Bay, Yaquina Bay, the Alsea River Basin, the Yachats River Estuary and the Umpqua River Basin.Yaquina Bay, located in Oregon's Lincoln County, has been extensively altered by jetties, dredging, landfills, roads and other human modifications. The Oregon estuary classification system designates Yaquina Bay as a Deep Draft Development estuary. It has been studied for decades, at times aggressively so. With renewed interest in Yaquina Bay as a research site, Oregon Sea Grant and the Environmental Protection Agency generously funded the beginning of this bibliography. The initial compilation was done by graduate student Heather Hiveley and the Guin Librarian, Janet Webster. Further citations were added by Susan Gilmont, under the direction of Janet Webster and Mary Markland. In addition to some attention to the area’s pre-history, the historical period covered extends from Theodore Talbot’s trip through the region in 1849 through June 2023. A web-based version of this bibliography is available at: https://guin.library.oregonstate.edu/oregon-estuaries. The web version offers keyword searching, including major concepts as well as species names and geographic referents