SQL Built-In Functions And Stored Procedures

The pristine, the ruined, the ephemeral, and even the notional are the subject ofRobert Harbison's highly original and admittedly romantic contribution to the literature ofarchitecture. His fresh perc

The notion of function is an integral part of thinking in both biology and technology. Biological organisms and technical artifacts are both ascribed functionality; yet the concept of function is not

These who condemn the treatment of prisoners at Abu Ghraib and Guantanamo have blamed U.S. military procedures and abuses of executive powers. But in The Story of Cruel and Unusual, Colin Dayan argues

An integrated analysis of how financial frictions can be accounted for in macroeconomic models built to study monetary policy and macroprudential regulation.Since the global financial crisis, there ha

In September 2015, the United Nations General Assembly adopted the Sustainable Development Goals as part of the 2030 Agenda for Sustainable Development. The Sustainable Development Goals built on and

Kevin Lynch's books are the classic underpinnings of modern urban planning and design, yet they are only a part of his rich legacy of ideas about human purposes and values in built form. City Sense a

A comprehensive update of the leading algorithms text, with new material on matchings in bipartite graphs, online algorithms, machine learning, and other topics. Some books on algorithms are rigorous but incomplete; others cover masses of material but lack rigor. Introduction to Algorithms uniquely combines rigor and comprehensiveness. It covers a broad range of algorithms in depth, yet makes their design and analysis accessible to all levels of readers, with self-contained chapters and algorithms in pseudocode. Since the publication of the first edition, Introduction to Algorithms has become the leading algorithms text in universities worldwide as well as the standard reference for professionals. This fourth edition has been updated throughout. New for the fourth edition New chapters on matchings in bipartite graphs, online algorithms, and machine learningNew material on topics including solving recurrence equations, hash tables, potential functions, and suffix arrays140 new exerc

A comprehensive resource on what lockdown drills are, why they are necessary, and how best to conduct them.The first book to offer a comprehensive examination of lockdown drills in K–12 schools, Lockdown Drills balances research findings with practical applications and implications. Schildkraut and Nickerson, school safety experts with complementary backgrounds in criminology and school psychology, review the historical precedents for lockdown drills, distinguish school lockdowns from other emergency procedures (such as active shooter drills), explain why they are conducted, present evidence-based research on their effectiveness, and describe how to conduct them according to best practices. Proponents of lockdown drills as a life-saving necessity, the authors help to bring much-needed standardization to how these drills are studied and conducted. The authors present common arguments for and against the inclusion of lockdown drills in emergency preparedness efforts, balancing their disc

A textbook that uses a hands-on approach to teach principles of programming languages, with Java as the implementation language.This introductory textbook teaches the principles of programming languages by using an experiential learning style, in which students learn about language features by realizing those features in a pedagogical compiler. Students use Java―the most commonly used programming language in the first two years of the computer science curriculum―as the implementation language throughout. The book also discusses a range of emerging topics in programming languages missing from existing textbooks, including concurrency, Big Data, and event-driven programming. The goal is to prepare students to design, implement, analyze, and understand both domain-specific and general-purpose programming languages. The book first develops basic concepts in languages, including means of computation using primitive values, means of combination such as variable definition and functions, an

A comprehensive neurocognitive theory of dreaming based on the theories, methodologies, and findings of cognitive neuroscience and the psychological sciences.G. William Domhoff’s neurocognitive theory of dreaming is the only theory of dreaming that makes full use of the new neuroimaging findings on all forms of spontaneous thought and shows how well they explain the results of rigorous quantitative studies of dream content. Domhoff identifies five separate issues―neural substrates, cognitive processes, the psychological meaning of dream content, evolutionarily adaptive functions, and historically invented cultural uses―and then explores how they are intertwined. He also discusses the degree to which there is symbolism in dreams, the development of dreaming in children, and the relative frequency of emotions in the dreams of children and adults. During dreaming, the neural substrates that support waking sensory input, task-oriented thinking, and movement are relatively deactivated. Domh

A close reading of Wikipedia’s article on the Egyptian Revolution reveals the complexity inherent in establishing the facts of events as they occur and are relayed to audiences near and far.Wikipedia bills itself as an encyclopedia built on neutrality, authority, and crowd-sourced consensus. Platforms like Google and digital assistants like Siri distribute Wikipedia’s facts widely, further burnishing its veneer of impartiality. But as Heather Ford demonstrates in Writing the Revolution, the facts that appear on Wikipedia are often the result of protracted power struggles over how data are created and used, how history is written and by whom, and the very definition of facts in a digital age. In Writing the Revolution, Ford looks critically at how the Wikipedia article about the 2011 Egyptian Revolution evolved over the course of a decade, both shaping and being shaped by the Revolution as it happened. When data are published in real time, they are subject to an intense battle over thei

A manifesto calling for a new kind of architecture that confronts social and economic inequality and uneven urban growth.Spatializing Justice calls for architects and urban designers to do more than design buildings and physical systems. Architects should take a position against inequality and practice accordingly. With these thirty short, manifesto-like texts―building blocks for a new kind of architecture―Spatializing Justice offers a practical handbook for confronting social and economic inequality and uneven urban growth in architectural and planning practice, urging practitioners to adopt approaches that range from redefining infrastructure to retrofitting McMansions. These building blocks call for expanded modes of practice, through which architects can imagine new spatial procedures, political and economic strategies, and modalities of sociability. Challenging existing exclusionary policies can advance a more experimental architecture not bound by formal parameters. Architects mu

How engineered materials and machines powered by living biological cells can tackle technological challenges in medicine, agriculture, and global security.You are a biological machine whose movement is powered by skeletal muscle, just as a car is a machine whose movement is powered by an engine. If you can be built from the bottom up with biological materials, other machines can be as well. This is the conceptual starting point for biofabrication, the act of building with living cells--building with biology in the same way we build with synthetic materials. In this volume in the MIT Press Essential Knowledge series, Ritu Raman offers an accessible introduction to biofabrication, arguing that it can address some of our greatest technological challenges. After presenting the background information needed to understand the emergence and evolution of biofabrication and describing the fundamental technology that enables building with biology, Raman takes deep dives into four biofabrication

How to co-create―and why: the emergence of media co-creation as a concept and as a practice grounded in equity and justice.Co-creation is everywhere: It’s how the internet was built; it generated massive prehistoric rock carvings; it powered the development of vaccines for COVID-19 in record time. Co-creation offers alternatives to the idea of the solitary author privileged by top-down media. But co-creation is easy to miss, as individuals often take credit for―and profit from―collective forms of authorship, erasing whole cultures and narratives as they do so. Collective Wisdom offers the first guide to co-creation as a concept and as a practice, tracing co-creation in a media-making that ranges from collaborative journalism to human–AI partnerships. Why co-create―and why now? The many coauthors, drawing on a remarkable array of professional and personal experience, focus on the radical, sustained practices of co-creating media within communities and with social movements. They explore

An illustrated guide to the amazingly multifarious sex lives of animals, from elephants and bonobos to butterflies and bedbugs.There may be nothing unnatural in nature, but nature still encompasses much that seems fantastically strange―the amazingly multifarious sex lives of animals, for example. Sexus Animalis tells us everything we never dreamed we wanted to know about the reproductive systems, genital organs, and sexual practices of animals, from elephants (who masturbate with their trunks) to fruit flies (who produce spermatozoa twenty times their size). In the animal kingdom we find heterosexual, lesbian, gay, and bisexual behavior, as well as monogamy, polygamy, and polyandry, not to mention fellatio and many varieties of erections and orgasms. Emmanuelle Pouydebat, a natural history researcher, tells us about gutter penises, double penises, detachable penises, and corkscrew-shaped penises, as well as vaginas built for storage and clitorises with thorns. (Perhaps unsurprisingly

When designing a world trading system for the twenty-first century, “Keep calm and carry on” beats “Move fast and break things.”Global trade is in trouble. Climate change, digital trade, offshoring, the rise of emerging markets led by China: Can the World Trade Organization (WTO), built for trade in the twentieth century, meet the challenges of the twenty-first? The answer is yes, Robert Staiger tells us, arguing that adapting the WTO to the changed economic environment would serve the world better than a radical reset.Governed by the WTO, on the principles of the General Agreement on Tariffs and Trade (GATT), global trade rules traditionally focus on “shallow integration”―with an emphasis on reducing tariffs and trade impediments at the border―rather than “deep integration,” or direct negotiations over behind-the-border measures. Staiger charts the economic environment that gave rise to the former approach, explains when and why it worked, and surveys the changing landscape for global

A mixed-race Harvard medical student stumbles upon a hidden Ethiopian city, the inhabitants of which possess both advanced technologies and mystical powers.Long before Marvel Comics gave us Wakanda, a high-tech African country that has never been colonized, this 1903 novel gave readers Reuel Brigg ―a mixed-race Harvard medical student, passing as white, who stumbles upon Telassar. In this long-hidden Ethiopian city, the wise, peaceful inhabitants of which possess both advanced technologies and mystical powers, Reuel discovers the incredible secret of his own birth. Now, he must decide whether to return to the life he’s built, and the woman he loves, back in America―or play a role in helping Telassar take its rightful place on the world stage. Considered one of the earliest articulations of Black internationalism, Of One Blood takes as its theme the notion that race is a social construct perpetuated by racists. Minister Faust is best known as author of The Coyote Kings of the Space-Age

How sound leaves a fundamental imprint on who we are.Making sense of sound is one of the hardest jobs we ask our brains to do. In Of Sound Mind, Nina Kraus examines the partnership of sound and brain, showing for the first time that the processing of sound drives many of the brain's core functions. Our hearing is always on--we can't close our ears the way we close our eyes--and yet we can ignore sounds that are unimportant. We don't just hear; we engage with sounds. Kraus explores what goes on in our brains when we hear a word--or a chord, or a meow, or a screech.Our hearing brain, Kraus tells us, is vast. It interacts with what we know, with our emotions, with how we think, with our movements, and with our other senses. Auditory neurons make calculations at one-thousandth of a second; hearing is the speediest of our senses. Sound plays an unrecognized role in both healthy and hurting brains. Kraus explores the power of music for healing as well as the destructive power of noise on the

A new vision of the brain as a fully integrated, networked organ.Popular neuroscience accounts often focus on specific mind-brain aspects like addiction, cognition, or memory, but The Entangled Brain tackles a much bigger question: What kind of object is the brain? Neuroscientist Luiz Pessoa describes the brain as a highly networked, interconnected system that cannot be neatly decomposed into a set of independent parts. One can’t point to the brain and say, “This is where emotion happens” (or any other mental faculty). Pessoa argues that only by understanding how large-scale neural circuits combine multiple and diverse signals can we truly appreciate how the brain supports the mind.Presenting the brain as an integrated organ and drawing on neuroscience, computation, mathematics, systems theory, and evolution, The Entangled Brain explains how brain functions result from cross-cutting brain processing, not the function of segregated areas. Parts of the brain work in a coordinated fashion

This first book-length analysis of Amazon’s Kindle explores the platform’s technological, bibliographical, and social impact on publishing.Four Shades of Gray offers the first book-length analysis of Amazon’s Kindle and its impact on publishing. Simon Rowberry recounts how Amazon built the infrastructure for a new generation of digital publications, then considers the consequences of having a single company control the direction of the publishing industry. Exploring the platform from the perspectives of technology, texts, and uses, he shows how the Kindle challenges traditional notions of platforms as discrete entities. He argues that Amazon’s influence extends beyond “disruptive technology” to embed itself in all aspects of the publishing trade; yet despite industry pushback, he says, the Kindle has had a positive influence on publishing. Rowberry documents the first decade of the Kindle with case studies of Kindle Popular Highlights, an account of the digitization of books publishe

Intended for use in advanced undergraduate and beginning graduate courses, this text presents a wide survey of methodological procedures and theoretical positions.

Traditional visual design expresses information in fixed forms, such as print or film, so the message can be stored or distributed. With interactive media and continuously updated information, communi

Regression and classification methods based on similarity of the input to stored examples have not been widely used in applications involving very large sets of high-dimensional data. Recent advances

Democracy is not in steady state, and democratizations are open-ended processes; they depend on structures and functions in systemic contexts that idiosyncratically evolve in tone, tenor, direction,

The thalamus plays a critical role in perceptual processing, but many questions remain about what thalamic activities contribute to sensory and motor functions. In this book, two pioneers in research

An analysis of current findings on mortgage-lending discrimination and suggestions for new procedures to improve its detection. In 2000, homeownership in the United States stood at an all-time high

An analysis of current findings on mortgage-lending discrimination and suggestions for new procedures to improve its detection. In 2000, homeownership in the United States stood at an all-time high

The effectiveness of market discipline -- the strong built-in incentives thatencourage banks and financial systems to operate soundly and efficiently -- commands much attentiontoday, particularly in l

This text offers a presentation of the mathematics required to tackle problems in economic analysis. After a review of the fundamentals of sets, numbers, and functions, it covers limits and continuit

Partnerships between the public and private sectors to fulfill public functions areon the increase at every level of government. In the United States and Canada they currently operatein most policy ar

Event-Cities 4 is the latest in the Event- Cities series from Bernard Tschumi, documenting recent built and theoretical projects in the context of his evolving views on architecture, urbanism, and des

Previously uncollected essays of an architect whose love of people, buildings, and nature was reflected in the places he built.

In Built upon Love Perez-Gomez uncovers the relationship between love and architecture in order to find the points of contact between poetics and ethics—between the architect's wish to design a

First built in Europe and grandly imported to the United States in the mid-nineteenthcentury, the classic multiway boulevard has been in decline for many years, victim of a narrowlyfocused approach to

The Swiss engineer Robert Maillart (1872-1940) built bridges and industrial buildings of startling originality. His innovative use of concrete, especially in the design of thin arch structures, and hi

In America today we see rampant development, unsustainable resource exploitation, andcommodification ruin both natural and built landscapes, disconnecting us from our surroundings andthreatening our f

In America today we see rampant development, unsustainable resource exploitation, andcommodification ruin both natural and built landscapes, disconnecting us from our surroundings andthreatening our f

In recent decades, governments have built up substantial public debt, which is oftenaccompanied by a growing public sector and fiscal policies that neglect long-term considerations.The contributors to

All working architects leave behind a string of monuments to themselves in the form of buildings they have designed and built. But what about the "final place" an archite