SQL Plus User’s Guide and Reference is intended for business and technical end users and system administrators who perform the following tasks: ¦ Enter, edit, store, retrieve, and run SQL commands and PL/SQL blocks ¦ Format, perform calculations on.Показать полностьюSQL Plus User’s Guide and Reference is intended for business and technical end users and system administrators who perform the following tasks: ¦ Enter, edit, store, retrieve, and run SQL commands and PL/SQL blocks ¦ Format, perform calculations on. store, print and create web output of query results ¦ List column definitions for any table ¦ Send messages to and accept responses from an end user ¦ Perform database administration To use this document, you need a basic understanding of the SQL database language. If you do not have any familiarity with this database tool, you should refer to the OracIe 9i SQL Reference. If you plan to use the PL/SQL database language in conjunction with SQL Plus, refer to the PL/SQL User s Guide and Reference for information on using PL/SQL.

iSQL Plus User’s Guide and Reference is intended for end users and system administrators who perform the following tasks: ¦ Enter, edit, run store, retrieve, and save SQL commands and PL/SQL blocks ¦ Calculate, store, and print query results. ¦ List column definitions for any table. ¦ Access and copy data between databases. ¦ Perform database administration. To use this document, you need a basic understanding of the SQL database language.Показать полностьюiSQL Plus User’s Guide and Reference is intended for end users and system administrators who perform the following tasks: ¦ Enter, edit, run store, retrieve, and save SQL commands and PL/SQL blocks ¦ Calculate, store, and print query results. ¦ List column definitions for any table. ¦ Access and copy data between databases. ¦ Perform database administration. To use this document, you need a basic understanding of the SQL database language. If you do not have any familiarity with this database tool, you should refer to the Oracle 9i SQL Reference. If you plan to use the PL/SQL database language in conjunction with SQL Plus, refer to the PL/SQL User’s Guide and Reference for information on using PL/SQL.

If you're responsible for deploying or administering SQL Server 2005, this book’s a gold mine. Straight from Microsoft, it delivers authoritative guidance on everything from planning to tuning, high availability to business intelligence. Microsoft SQL Server 2005 Administrator’s Companion offers immense value for DBAs working in any environment, including the most mission-critical.Показать полностьюIf you're responsible for deploying or administering SQL Server 2005, this book’s a gold mine. Straight from Microsoft, it delivers authoritative guidance on everything from planning to tuning, high availability to business intelligence. Microsoft SQL Server 2005 Administrator’s Companion offers immense value for DBAs working in any environment, including the most mission-critical. Upfront, it'll help you with capacity planning, then walk you through every facet of installation, upgrading, and network configuration. It covers all the core DBA fundamentals (creating databases, tables, views, indexes, backup/restore, memory allocation, data partitioning, and so forth). But it includes equally detailed coverage of integration, analysis, reporting, and notification services for business intelligence. And when it’s time to implement failover clustering and database mirroring, it'll help you there, too.

* Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all times * Focuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendix * Paul Wilton is a successful Wrox “Beginning” book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particular database product * SQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others

Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system that--until now--lacked comprehensive, easy-to-use documentation.Показать полностьюArguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system that--until now--lacked comprehensive, easy-to-use documentation. Practical PostgreSQL is a fast-paced guide that shows you how to get PostgreSQL installed, configured, and running. This comprehensive book delves into the many advanced features of the PostgreSQL Application Server, LXP, including the the use of SQL within PostgreSQL, and covers basic PostgreSQL database administration.

For twenty years, van der Lans' Introduction to SQL has been the definitive SQL tutorial for database professionals everywhere, regardless of experience or platform.Показать полностьюFor twenty years, van der Lans' Introduction to SQL has been the definitive SQL tutorial for database professionals everywhere, regardless of experience or platform. Now van der Lans has systematically updated this classic guide to reflect the latest SQL standards and the newest versions of today’s leading RDBMSs: Oracle, Microsoft SQL Server, DB2, and MySQL. Using case study examples and hands-on exercises, van der Lans illuminates every key SQL concept, technique, and statement. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why SQL works as it doesand how to get the most out of it. You'll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you're a programmer or DBA, a student or veteran, this book will take you from “apprentice” to true SQL master. Writing queries and updating data: all you need to know about SELECT Working with joins, functions, and subqueries Creating database objects: tables, indexes, views, and more Specifying keys and other integrity constraints Using indexes to improve efficiency Enforcing security via passwords and privileges Building stored procedures and triggers Developing with embedded SQL and ODBC Working with transactions, including rollbacks, savepoints, isolation levels, and more Optimizing performance by reformulating SQL statements Using object-relational features: subtables, references, sets, and user-defined data types Reference section: SQL statement definitions and SQL function lists

"ПОНИМАНИЕ SQL"— это полный учебник по программированию на Структурированном Языке Запросов, написанный специально для тех, кто будет использовать SQL в процессе работы.Показать полностью"ПОНИМАНИЕ SQL"— это полный учебник по программированию на Структурированном Языке Запросов, написанный специально для тех, кто будет использовать SQL в процессе работы. Даже если это ваш первый опыт с компьютерами или управлением базами данных, книга "ПОНИМАНИЕ SQL" очень быстро научит вас свободно работать с реальной SQL, использованию простых запросов, а также снабдит вас ясными понятиями об автоматизированном управлении базой данных. Книга даст вам краткое, удобное в чтении введение в реляционные базы данных. Предоставит вам обучающие программы, чтобы, овладевая командами SQL шаг за шагом, помочь вам узнать, как извлекать и обрабатывать информацию, содержащуюся в таблицах данных, т.е.: * выбирать информацию, с которой вы хотите работать * добавлять, удалять, и модифицировать информацию в таблице данных * использовать и-или, верно/неверно и другие условия для обнуления определенной информации * использовать специальные функции SQL для суммирования ваших данных.

Данная книга является справочником по SQL стандарта ANSI SQL2003 и реализациям этого стандарта на наиболее распространенных платформах: Microsoft SQL Server, DB2 Universal Database версии 8.0 от компании ШМ для Linux, Unix и Windows, Sybase Adaptive Server версии 12.5, Oracle Database 10g и двух продуктов с открытым исходным кодом -MySQL версии 4 и PostgreSQL версии 7. Книга является настольным практическим справочником для администраторов и разработчиков баз данных, а также разработчиков прикладного программного обеспечения.

На фоне прочих СУБД, распространяемых с открытыми текстами, PostgreSQL выделяется своей надежностью и богатством возможностей. В книге рассматриваются практические аспекты установки и сопровождения сервера БД на базе PostgreSQL.Показать полностьюНа фоне прочих СУБД, распространяемых с открытыми текстами, PostgreSQL выделяется своей надежностью и богатством возможностей. В книге рассматриваются практические аспекты установки и сопровождения сервера БД на базе PostgreSQL. Основное внимание уделяется таким стандартным операциям, как архивация и восстановление баз данных, управление учетными записями пользователей, создание новых баз данных, запуск и остановка сервера и т. д. Отдельная часть книги посвящена нетривиальным темам, специфическим для PostgreSQL, в том числе работе с базами данных в языке Java и построению web-сайтов на основе данных PostgreSQL. Книга предназначена для системных администраторов, занимающихся техническим сопровождением серверов БД, но ее материал также представляет интерес для широкого круга читателей, желающих поближе познакомиться с PostgreSQL.

Distributed Computing: Fundamentals, Simulations, and Advanced Topics. Provides a solid introduction to the mathematical foundations and theory of distributed computing.Показать полностьюDistributed Computing: Fundamentals, Simulations, and Advanced Topics. Provides a solid introduction to the mathematical foundations and theory of distributed computing. It introduces the reader to the fundamental issues underlying the design of distributed systems i.e. communication, coordination, synchronization and uncertainty. By adopting a unifying approach to cover key elements of the theory of distributed computing, the book emphasizes the similarities between different models and explains inherent discrepancies. It is unique in presenting up-to-date results in a precise, and detailed, yet accessible manner. The emphasis is on fundamental ideas rather than optimizations and it exposes the similarities solutions to seemingly diverse problems.

Few Web services require as much computation per request as search engines. On average, a single query on Google reads hundreds of megabytes of data and consumes tens of billions of CPU cycles.Показать полностьюFew Web services require as much computation per request as search engines. On average, a single query on Google reads hundreds of megabytes of data and consumes tens of billions of CPU cycles. Supporting a peak request stream of thousands of queries per second requires an infrastructure comparable in size to that of the largest supercomputer installations. Combining more than 15,000 commodity-class PCs with fault-tolerant software creates a solution that is more cost-effective than a comparable system built out of a smaller number of high-end servers. Here we present the architecture of the Google cluster, and discuss the most important factors that influence its design: energy efficiency and price-performance ratio. Energy efficiency is key at our scale of operation, as power consumption and cooling issues become significant operational factors, taxing the limits of available data center power densities. Our application affords easy parallelization: Different queries can run on different processors, and the overall index is partitioned so that a single query can use multiple processors. Consequently, peak processor performance is less important than its price/performance. As such, Google is an example of a throughput-oriented workload, and should benefit from processor architectures that offer more on-chip parallelism, such as simultaneous multithreading or on-chip multiprocessors.

Grid computing is applying the resources of many computers in a network to a single problem at the same time Grid computing appears to be a promising trend for three reasons: (1) Its ability to make more cost-effective use of a given amount of computer resources, (2) As a way to solve problems that can't be approached without an enormous amount of computing power (3) Because it suggests that the resources of many computers can be cooperatively and perhaps synergistically harnessed and managed as a collaboration toward a common objective.Показать полностьюGrid computing is applying the resources of many computers in a network to a single problem at the same time Grid computing appears to be a promising trend for three reasons: (1) Its ability to make more cost-effective use of a given amount of computer resources, (2) As a way to solve problems that can't be approached without an enormous amount of computing power (3) Because it suggests that the resources of many computers can be cooperatively and perhaps synergistically harnessed and managed as a collaboration toward a common objective. A number of corporations, professional groups, university consortiums, and other groups have developed or are developing frameworks and software for managing grid computing projects. The European Community (EU) is sponsoring a project for a grid for high-energy physics, earth observation, and biology applications. In the United States, the National Technology Grid is prototyping a computational grid for infrastructure and an access grid for people. Sun Microsystems offers Grid Engine software. Described as a distributed resource management tool, Grid Engine allows engineers at companies like Sony and Synopsys to pool the computer cycles on up to 80 workstations at a time. “the Grid” is a very hot topic generating broad interest from research and industry (e.g. IBM, Platform, Avaki, Entropia, Sun, HP) Grid architecture enables very popular e-Science projects like the Genome project which demand global interaction and networking In recent surveys over 500f Chief Information Officers are expected to use Grid technology this year Grid Computing: Features contributions from the major players in the field Covers all aspects of grid technology from motivation to applications Provides an extensive state-of-the-art guide in grid computing This is essential reading for researchers in Computing and Engineering, physicists, statisticians, engineers and mathematicians and IT policy makers.

This book is meant to be a resource for anyone involved in the design, production, overseeing, or troubleshooting of a site that employs server load balancing (SLB).Показать полностьюThis book is meant to be a resource for anyone involved in the design, production, overseeing, or troubleshooting of a site that employs server load balancing (SLB). Managers and other high-level people can use this book to improve their understanding of the overall technology. Engineers and site architects can use this book to give insight into their designs and implementations of SLB. Technicians can use this book to help configure and troubleshoot SLB implementations, as well as other in-the-trenches work.

This book builds on the important work done at the Center for Research on Parallel Computation and within the academic community for over a decade. It is a definitive text on parallel Computing and should be a key reference for students, researchers and practitioners in the field.Показать полностьюThis book builds on the important work done at the Center for Research on Parallel Computation and within the academic community for over a decade. It is a definitive text on parallel Computing and should be a key reference for students, researchers and practitioners in the field. The Sourcebook for Parallel Computing gives a thorough introduction to parallel applications, software technologies, enabling technologies, and algorithms. I highly recommend this great book to anyone interested in a comprehensive and thoughtful treatment of the most important issues in parallel computing. The Features and Benefits of this book includes...but not limited to 1) Providing a solid background in parallel computing technologies 2) Examining the technologies available and teaches students and practitioners how to select and apply them 3) Presenting case studies in a range of application areas including Chemistry, Image Processing, Data Mining, Ocean Modeling and Earthquake and 4) Considering the future development of parallel computing technologies and the kinds of applications they will support. Worth buying this book, your money is invested!

Computer architecture deals with the physical configuration, logical structure, formats, protocols, and operational sequences for processing data, controlling the configuration, and controlling the operations over a computer.Показать полностьюComputer architecture deals with the physical configuration, logical structure, formats, protocols, and operational sequences for processing data, controlling the configuration, and controlling the operations over a computer. It also encompasses word lengths, instruction codes, and the interrelationships among the main parts of a computer or group of computers. This two-volume set offers a comprehensive coverage of the field of computer organization and architecture.

Increasingly, parallel processing is being seen as the only cost-effective method for the fast solution of computationally large and data-intensive problems.Показать полностьюIncreasingly, parallel processing is being seen as the only cost-effective method for the fast solution of computationally large and data-intensive problems. The emergence of inexpensive parallel computers such as commodity desktop multiprocessors and clusters of workstations or PCs has made such parallel methods generally applicable, as have software standards for portable parallel programming. This sets the stage for substantial growth in parallel software. Data-intensive applications such as transaction processing and information retrieval, data mining and analysis and multimedia services have provided a new challenge for the modern generation of parallel platforms. Emerging areas such as computational biology and nanotechnology have implications for algorithms and systems development, while changes in architectures, programming models and applications have implications for how parallel platforms are made available to users in the form of grid-based services. This book takes into account these new developments as well as covering the more traditional problems addressed by parallel computers.Where possible it employs an architecture-independent view of the underlying platforms and designs algorithms for an abstract model. Message Passing Interface (MPI), POSIX threads and OpenMP have been selected as programming models and the evolving application mix of parallel computing is reflected in various examples throughout the book.

This how-to guide provides step-by-step instructions for building a Beowulf-type computer, including the physical elements that make up a clustered PC, the software required, and insights on how to organize the code to exploit parallelism.

The primary focus of this book is the rapidly evolving software technology for supporting the development, execution, management, and experimentation with parallel and distributed computing environments.Показать полностьюThe primary focus of this book is the rapidly evolving software technology for supporting the development, execution, management, and experimentation with parallel and distributed computing environments. The design, development, and utilization of parallel and distributed computing environments that can efficiently support a wide range of scientific and engineering applications remains a challenging research problem due to the complexity and varying requirements of the applications, heterogeneity of the computing systems and their networks, asynchronous complex interactions among the system and application components, and the heterogeneity of the software tools and environments.

This text provides an overview of the evolution of parallel computer architectures in relation to the development of parallel programming models and tools, presents the mpC parallel programming language, and spotlights advanced mpC applications.

We are currently entering ah era of developed parallelism. Parallelism provides the high performance needed in science and engineering, the responsiveness required in real-time control, the fault-tolerance necessary for high reliability systems, etc. These capabilities become available for use in an increasing number of applications but offer new challenges to the system designer and programmer.