Skip to main content
View Cart

Books in Physical sciences and engineering

  • Joe Celko's SQL for Smarties

    Advanced SQL Programming
    • 5th Edition
    • Joe Celko
    • English
    SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance.New to the fifth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO-11179 rules with the same experience-based teaching style that made the previous editions the classics they are today. You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth.SQL for Smarties explains some of the principles of SQL programming as well as the code. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products. You’ll learn about computed columns and the DEFERRABLE options in constraints. An overview of the bi-temporal model is new to this edition and there is a longer discussion about descriptive statistic aggregate functions. The book finishes with an overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions.

  • Software Engineering, COINS III

    Proceedings of the Third Symposium on Computer and Information Sciences Held in Miami Beach, Florida, December, 1969
    • 1st Edition
    • Julius T. Tou
    • English
    Software Engineering: COINS III, Volume 2 contains the proceedings of the Third Symposium on Computer and Information Sciences held in Miami Beach, Florida, in December 1969. The symposium provided a forum for reviewing major advances in software engineering, with emphasis on information retrieval, pattern processing, and computer networks. Comprised of 16 chapters, this volume begins with a discussion on computer-assisted documentation of working binary computer programs with unknown documentation. The reader is then introduced to quality control in the publishing process and theoretical foundations for information retrieval; logical aspects of question-answering by computer; and intermediate languages for automatic language processing. Subsequent chapters focus on syntactic pattern recognition; grammatical inference techniques in pattern analysis; linguistic analysis of waveforms; and a software engineering approach to the space information system of the future. An efficient program for real-time assignment of jobs in a hybrid computer network is also described. This monograph is intended for scientists, engineers, and educators in the fields of computer science and information science.

  • Progress in Aeronautical Sciences

    • 1st Edition
    • Volume 9
    • D. Küchemann + 2 more
    • English
    Progress in Aeronautical Sciences, Volume 9 presents the vibrational characteristics of certain aircraft. This book supplements the comprehensive account of matrix methods of structural analysis. Organized into five chapters, this volume begins with an overview of the different schemes of the numerical method of characteristics for calculating three-dimensional steady supersonic gas flow about bodies moving at incidence. This text then examines the flow of a perfect gas and provides the generalization for the case of equilibrium and non-equilibrium flow of real gas. Other chapters consider the various aspects of the aerodynamic design of aircraft and discuss the application of modern computer methods to fluid mechanics. This book discusses as well the prospects for further development of the existing types and for the establishment of the as yet hypothetical types of aircraft. The final chapter shows how the evolution of the aerodynamic shape leads to a complete spectrum of major types of aircraft. This book is a valuable resource for engineers.

  • Progress in Aeronautical Sciences

    • 1st Edition
    • Volume 3
    • Antonio Ferri + 2 more
    • English
    Progress in Aeronautical Sciences, Volume 3 provides information pertinent to the fundamental aspects of aerodynamics. This book covers a variety of topics related to the field of aerodynamics, including turbulence research, atmospheric velocity, hypersonic research, swept wing design, and ducted propellers. Organized into four chapters, this volume begins with an overview of the aerodynamics of swept-winged aircraft. This text then surveys the state of knowledge regarding the aerodynamics of ducted propellers. Other chapters consider hypersonic facilities and provide the reader with a balanced review of the bewildering multiplicity of means for experimenting with hypersonic flows. This book discusses as well the simulation of hypersonic flight conditions. The final chapter deals with gust research and reviews some of the activities and studies of atmospheric turbulence by both the meteorologists and engineers in an effort to correlate, collect, and summarize these results. This book is a valuable resource for design and aeronautical engineers.

  • Nonsteady Flame Propagation

    AGARDograph
    • 1st Edition
    • Volume 75
    • George H. Markstein
    • English
    Nonsteady Flame Propagation provides information pertinent to flame propagation in gaseous media. This book focuses on linearized treatments and the comparison of their results with experimental observations. Organized into nine chapters, this book begins with an overview of the challenge of nonlinear problems and examines the essentially nonlinear character of the flame phenomena, which has been artificially suppressed in analyses by the use of linearized perturbation treatments. This text then summarizes the development regarding rocket-shaped burners. Other chapters consider the advantages as well as the limitations of linearized analyses. This book discusses as well a general treatment of the discontinuous-flame-... model and summarizes the results of studies of burner that use secondary air. The final chapter deals with re-examining the possibilities of using pulsating combustion in propulsion or in other applications. This book is a valuable resource for chemical engineers, chemists, scientists, and research workers.

  • Advances in Space Science and Technology

    • 1st Edition
    • Volume 8
    • Frederick I. Ordway
    • English
    Advances in Space Science and Technology, Volume 8 presents the possibility that what is recognized as lunar cratering was caused by endogenous, volcanic activity rather than by the more widely accepted meteoritic impact mechanism. This book provides an introduction to the technology of rocketry. Organized into four chapters, this volume begins with an overview of lunar volcanism and the interpretation of the widespread phenomenon of cratering. This text then provides a comprehensive examination of one of the major components of the solid propellant rocket. Other chapters consider the many problems associated with design, construction, and testing of motor cases of the solid propellant rocket. This book presents as well a thorough examination of interplanetary mission planning covering such vital elements as the process of mission decision making based on model theory. The final chapter deals with the exploration of the planet Mars. This book is a valuable resource for geoscientists, astronomers, and geologists.

  • Advances in Space Science and Technology

    • 1st Edition
    • Volume 3
    • Frederick I. Ordway
    • English
    Advances in Space Science and Technology, Volume 3 presents the development in space science and space technology. This book considers the engineering problems applicable to the attainment of astronautical objectives and examines a critical aspect of manned space flight. Organized into eight chapters, this volume begins with an overview of the role of geology in lunar exploration programs. This text then discusses the preliminary considerations of Venus as an astronautical objective. Other chapters consider a schematic representation of the positions of the Sun, Earth, Mars, and Venus at the approximate times of closest approach of the latter two planets to Earth. This book demonstrates as well that a fuller understanding of each individual body will contribute much to an over-all understanding of the nature and history of the Solar System itself. The final chapter deals with the phenomenon of weightlessness associated with orbital flight. This book is a valuable resource for astronomers, scientists, and engineers.

  • A Correlation Study of Methods of Matrix Structural Analysis

    Report to the 14th Meeting, Structures and Materials Panel Advisory Group for Aeronautical Research and Development, NATO, Paris, France, July 6, 1962
    • 1st Edition
    • Volume 69
    • Richard H. Gallagher
    • English
    A Correlation Study of Methods of Matrix Structural Analysis describes the results of a survey and review of airframe matrix structural analysis. The book also explains concepts of force and displacement, as well as the techniques for determining the force-displacement properties of discrete elements employed in analytical idealizations of structures. The text investigates the results of extensive analyses of multiweb low aspect ratio wings, using past evaluative studies and idealizations contained in reports of the AGARD Structures and Materials Panel. The techniques describe in the Panel and other techniques in matrix structural analysis lead to identical formulations of the governing equations. The differences between various references with respect to idealization are independent of the formulation of the governing equations. The solutions to governing equations are precise solutions for the postulated discrete element system. The book also describes a recommended computer program development using whichever is more appropriate between a force approach or displacement approach to matrix structural analysis. The text is valuable for researchers in structural analysis, aeronautics, applied mechanics, and investigators of aircraft engineering.

  • Advances in Cell Culture

    • 1st Edition
    • Volume 2
    • Karl Maramorosch
    • English
    Advances in Cell Culture, Volume 2 is a compendium of critical reviews in the field of cell culture. The chapters in the book are prepared by recognized authorities in their specialized fields. The text deals with all the aspects of cell culture, which includes the growth of individual cells or cell populations, the growth of small fragments of explanted tissue, the growth of organs, and the growth of obligate parasites in cell culture systems. This volume provides reviews of important aspects of in vitro cultivation and presents the increasing understanding of the wide ramifications of in vitro techniques. The book also focuses on specific topics in cell culture such as cellular senescence in vitro; introduction and expression of foreign DNA sequences in mammalian cells; media for insect cell cultures; agricultural applications of in vitro plant cultivation; and fish cell culture. A short biographical note devoted to Ross G. Harrison, whose insight and pioneering work led to the foundation of animal cell culture is likewise included. Cell biologists and researchers who use in vitro techniques will find the book highly informative and insightful.

  • Advances in Space Science and Technology

    • 1st Edition
    • Volume 4
    • Frederick I. Ordway
    • English
    Advances in Space Science and Technology, Volume 4 provides information pertinent to the fundamental aspects of basic and applied astronautics. This book deals with one of the more practical aspects of artificial satellites, measurement of the Doppler effect. Organized into six chapters, this volume begins with an overview of the Doppler effect of Earth-circling satellites. This text then explores the possibility of the existence of intelligent beings other than man. Other chapters consider the historical development of multistage rockets and space carrier vehicles and explain the concepts and approaches to manned orbital flight. This book discusses as well the problems of bringing spacecraft safely through planetary atmospheres and onto the surface. The final chapter deals with radioactive elements as energy sources for spacecraft propulsion in orbital transfer and for travel between the worlds of the Solar System. This book is a valuable resource for biologists, astronomers, chemists, geologists, and geochemists.

Related subjects