Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Walk away from old-fashioned and cumbersome query approaches and answer your business intelligence questions through simple and powerful queries built on common table expressions (CTEs) and window functions. These new features in MariaDB and MySQL help you to write queries without having to wade through a quagmire of brittle self-joins and other crazy techniques from the past. Your queries will generate correct results, be more readable and less brittle in the face of unexpected data, and you’ll be able to adapt them quickly in the face of changing business requirements. MariaDB and MySQL Common Table Expressions and Window Functions Revealed introduces and explains CTEs and window functions, newly available in MariaDB 10.2 and MySQL 8.0, and helps you understand why and how every MariaDB and MySQL database programmer should learn and apply these features in their daily work. CTEs and especially window functions enable easy solutions to many query challenges that in prior releases have been difficult and sometimes impossible to surmount. Mastering these features opens the door to query solutions that are more robust, execute faster, and are easier to maintain over time than prior solutions using older techniques. The book: Takes you step-by-step through the workings of common table expressions and window functions Provides easy-to-follow examples of the new syntax Helps you answer business questions faster and easier than ever What You'll Learn: Answer business questions using simple queries that don’t break in the face of unexpected data Avoid writing queries that are a difficult-to-maintain quagmire of self-joins and nested subqueries Recognize situations that call for window functions, and learn when to use these features Reduce the need for performance-robbing self-joins Simplify and speed the execution of analytical queries Create queries that finish in seconds instead of hours.

Information systems --- MySQL --- database management --- Database management. --- Database Management. --- MySQL (Electronic resource) --- MariaDB.

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

There have been many changes in the field of coagulation during the past decade. New concepts of epidemiology of risk factors for thrombosis now help clinicians predict who is more likely to form clots after surgery, or after being placed on oral contraceptives. New anticoagulants have the potential to redefine how patients with atrial fibrillation and venous thrombosis are managed. There are new forms of recombinant clotting factors which have changed our approach to hypofibrinogenemia and von Willebrand’s disease. Newer antiplatelet agents are available and their use in patients receiving cardiac stents has mushroomed. The management of thrombosis in the setting of pregnancy has changed over the past decade, as well as the way clinicians approach women with multiple miscarriages. An entire new class of compounds, the thrombopoietins, are available to treat individuals with immune thrombocytopenic purpura (ITP). The Coagulation Consult covers major topics of interest to hematologists who are asked to consult on individuals with coagulation related diseases, and encompasses the field’s most recent developments. This “case-directed” book describes state-of-the-art approaches to patients with bleeding and clotting disorders, as well as laboratory tests for coagulation. Chapters include different vignettes, focus on typical clinical consult questions, and lay out specific types of treatment. Practicing clinicians being confronted with a coagulation consult, students, residents, fellows and attending physicians will find this unique text an invaluable resource for some of the newer areas of coagulation science, therapy and pharmacology.

Oncology. Neoplasms --- Pathological haematology --- Human medicine --- farmacologie --- zwangerschap --- geneeskunde --- oncologie --- hematologie --- miskraam

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

The prerequisite to investigating the underlying causes behind mass extinction is a profound understanding of the evolutionary history of both living and dead species. It is especially important to appreciate the significance of such studies in extinct organisms; especially in organisms that were abundant in a certain geologic era, but have subsequently dwindled or become extinct. Such studies should help to accurately evaluate patterns of evolution in extinct species lineages and help predict the same in its modern analogs. The book includes cutting edge research in evolutionary biology that should serve as a starting point for conservation.

Nature protection --- Biogeography --- Evolution. Phylogeny --- Biology --- Invertebrates --- invertebraten --- biogeografie --- biologie --- Europees recht --- evolutieleer --- natuurbescherming --- milieubescherming

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

This book provides an up-to-date review of the biology of myxozoans, which represent a divergent clade of endoparasitic cnidarians. Myxozoans are of fundamental interest in understanding how early diverging metazoans have adopted parasitic lifestyles, and are also of considerable economic and ecological concern as endoparasites of fish. Synthesizing recent research, the chapters explore issues such as myxozoan origins; evolutionary trends and diversification; development and life cycles; interactions with hosts; immunology; disease ecology; the impacts of climate change on disease; risk assessment; emerging diseases; and disease mitigation. This comprehensive work will appeal to a wide readership, from invertebrate zoologists, evolutionary biologists and developmental biologists to ecologists and parasitologists. It will also be of great practical interest to fisheries and conservation biologists. The identification of key areas for future research will appeal to scientists at all levels.

Evolution. Phylogeny --- General embryology. Developmental biology --- General parasitology --- Hydrobiology --- General ecology and biosociology --- Invertebrates --- Water supply. Water treatment. Water pollution --- invertebraten --- aquacultuur --- parasitologie --- embryologie (geneeskunde) --- ecologie --- Europees recht --- waterbeheer --- Invertebrates. --- Evolutionary biology. --- Parasitology. --- Developmental biology. --- Aquatic ecology . --- Evolutionary Biology. --- Developmental Biology. --- Freshwater & Marine Ecology.

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Comprising of ­18 sub-ethnic groups the indigenous communities, or better known as the Orang Asli, located in the Peninsular Malaysia, is a unique community in terms of their culture, lifestyle, and heritage. The life of the Orang Asli, popularly referred to as the Forest People, is highly intertwined with forest resources which makes the community a great source of information and traditional knowledge, particularly in the use of medicinal plants. This book covers three important issues to explain and gain insights into the sustainability of the Orang Asli: Social and demographics Sustainability of resource use Governance, administration and management The book presents research to help bridge the gaps and provides a baseline reference for further research regarding the sustainability of the Orang Asli. This book is intended for researchers and graduate students to help gain an understanding of the Orang Asli. By highlighting the plight of Orang Asli the authors hope that this community will be recognised and become a part of society. More research is required to help the 178,197 Orang Asli achieve the sustainable development goals for their community in the Peninsular Malaysia.

Ethnology. Cultural anthropology --- General ecology and biosociology --- Environmental protection. Environmental technology --- biodiversiteit --- etnologie --- milieubeleid --- antropologie