Pro Oracle Spatial for Oracle Database 11g


Book Description

Now available in paperback— Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Databases built–in feature set for working with location–based data. A great deal of the information used in business today is associated with location in some way, and analysis of that data is becoming ever more important in today's mobile and highly connected world. In Pro Oracle Spatial for Oracle Database 11g, authors Ravi Kothuri and Albert Godfrind address: The special nature of spatial data and its role in professional and consumer applications Issues in spatial data management such as modeling, storing, accessing, and analyzing spatial data The Oracle Spatial solution and the integration of spatial data into enterprise databases How spatial information is used to understand business and support decisions, to manage customer relations, and to better serve private and corporate users When you read Pro Oracle Spatial for Oracle Database 11g, you’re learning from the very best. Ravi Kothuri is a key member of Oracle’s Spatial development team. Albert Godfrind consults widely with Oracle clients on the implementation of Oracle Spatial, develops training courses, and presents frequently at conferences. Together they have crafted a technically sound and authoritative fountain of information on working with spatial data in the Oracle database.




Pro ODP.NET for Oracle Database 11g


Book Description

This book is a comprehensive and easy-to-understand guide for using the Oracle Data Provider (ODP) version 11g on the .NET Framework. It also outlines the core GoF (Gang of Four) design patterns and coding techniques employed to build and deploy high-impact mission-critical applications using advanced Oracle database features through the ODP.NET provider. The book details the features of the ODP.NET provider in two main sections: “Basic,” covering the basics and mechanisms for data access via ODP.NET; and “Advanced,’ covering advanced Oracle features such as globalization, savepoints, distributed transactions and how to call them via ODP.NET, advanced queueing (AQ), and promotable transactions. It takes you from the ground up through different implementation scenarios via a rich collection of C# code samples. It outlines database security and performance optimization tricks and techniques on ODP.NET that conform to best practices and adaptable design. Different GoF design patterns are highlighted for different types of ODP.NET usage scenarios with consideration of performance and security. It provides a comprehensive guide to the synergistic integration of Oracle and Microsoft technologies such as the Oracle Developer Tools for Visual Studio (11.1.0.7.10). It also details how programmers can make use of ODT to streamline the creation of robust ODP.NET applications from within the Visual Studio environment.




Pro Oracle Database 11g RAC on Linux


Book Description

Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters in a Linux environment. Real Application Clusters, commonly abbreviated as RAC, is Oracle’s industry-leading architecture for scalable and fault-tolerant databases. RAC allows you to scale up and down by simply adding and subtracting inexpensive Linux servers. Redundancy provided by those multiple, inexpensive servers is the basis for the failover and other fault-tolerance features that RAC provides. Written by authors well-known for their talent with RAC, Pro Oracle Database 11g RAC on Linux gives you a rock-solid and technically flawless foundation on which to build your RAC-management skills. Authors Julian Dyke and Steve Shaw share their hard-won experience in building RAC clusters, showing you how to build for success using the very latest Oracle technologies, such as Automatic Storage Management (ASM) and Oracle Clusterware. You’ll learn to troubleshoot performance and other problems. You’ll even learn how to correctly deploy RAC in a virtual-machine environment based upon Oracle VM, which is the only virtualization solution supported by Oracle Corporation. RAC is a complex and powerful technology. It demands expertise in its deployment. You can’t just “wing it” in creating a RAC solution. Julian and Steve have earned the right to term themselves expert—in Pro Oracle Database 11g RAC on Linux, they offer a rigorous and technically-correct treatment of RAC that helps you build a solid foundation of expertise and achieve success. Rigorous and technically accurate content Complete coverage of RAC, from planning to implementation to rollout to ongoing maintenance and troubleshooting Up-to-date with the very latest RAC features




Oracle Core: Essential Internals for DBAs and Developers


Book Description

Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting—no more, no less. Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data. Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book. Provides proven content from a world-renowned performance and troubleshooting expert Emphasizes the significance of internals knowledge to rapid identification of database performance problems Covers the core essentials and does not waste your time with esoterica




OCP: Oracle Database 11g Administrator Certified Professional Study Guide


Book Description

This updated study guide for the latest release of the most popular database software in the world—Oracle Database 11g— reviews using the RMAN recovery catalog, handling Flashback technology, managing memory and resources, automating tasks, diagnosing the database, and much more. Plus, more than 100 pages of workbook exercises help prepare you to take the 1Z0-053 exam. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.




3D Geo-Information Sciences


Book Description

In recent years 3D geo-information has become an important research area due to the increased complexity of tasks in many geo-scientific applications, such as sustainable urban planning and development, civil engineering, risk and disaster management and environmental monitoring. Moreover, a paradigm of cross-application merging and integrating of 3D data is observed. The problems and challenges facing today’s 3D software, generally application-oriented, focus almost exclusively on 3D data transportability issues – the ability to use data originally developed in one modelling/visualisation system in other and vice versa. Tools for elaborated 3D analysis, simulation and prediction are either missing or, when available, dedicated to specific tasks. In order to respond to this increased demand, a new type of system has to be developed. A fully developed 3D geo-information system should be able to manage 3D geometry and topology, to integrate 3D geometry and thematic information, to analyze both spatial and topological relationships, and to present the data in a suitable form. In addition to the simple geometry types like point line and polygon, a large variety of parametric representations, freeform curves and surfaces or sweep shapes have to be supported. Approaches for seamless conversion between 3D raster and 3D vector representations should be available, they should allow analysis of a representation most suitable for a specific application.




Oracle to DB2 Conversion Guide: Compatibility Made Easy


Book Description

This IBM® Redbooks® publication describes IBM DB2® SQL compatibility features. The latest version of DB2 includes extensive native support for the PL/SQL procedural language, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQLPlus, and more. These features can help with developing applications that run on both DB2 and Oracle and can help simplify the process of moving from Oracle to DB2. In addition, IBM now provides tools to simplify the enablement process, such as the highly scalable IBM Data Movement Tool for moving schema and data into DB2, and an Editor and Profiler for PL/SQL provided by the IBM Data Studio tool suite. This Oracle to DB2 migration guide describes new technology, preferred practices for moving to DB2, and common scenarios that can help you as you move from Oracle to DB2. This book is intended for IT architects and developers who are converting from Oracle to DB2. DB2 compatibility with Oracle is provided through native support. The new capabilities in DB2 that provide compatibility are implemented at the lowest and most intimate levels of the database kernel, as though they were originally engineered for DB2. means that the DB2 implementation is done without the aid of an emulation layer. This intimacy leads to the scalable implementation that DB2 offers, providing identical performance between DB2 compatibility features and DB2 other language elements. For example, DB2 runs SQL PL at the same performance as PL/SQL implementations of the same function.




Pro Oracle Fusion Applications


Book Description

Pro Oracle Fusion Applications is your one-stop source for help with installing Oracle’s Fusion Applications suite in your on-premise environment. It also aids in the monitoring and ongoing administration of your Fusion environment. Author Tushar Thakker is widely known for his writings and expertise on Oracle Fusion Applications, and now he brings his accumulated wisdom to you in the form of this convenient handbook. Provisioning an Oracle Fusion Applications infrastructure is a daunting task. You’ll have to plan a suitable topology and install the required database, an enterprise-wide identity management solution, and the applications themselves—all while working with a wide variety of people who may not always be accustomed to working together. Pro Oracle Fusion Applications provides a path to success that you won’t want to be without. Beyond installation, Pro Oracle Fusion Applications provides excellent guidance on managing, monitoring, diagnostics, and troubleshooting your environment. The book also covers patching, a mundane but essential task that must be done regularly to keep your installation protected and running smoothly. The comprehensive and wide-ranging coverage makes Pro Oracle Fusion Applications an important book for anyone with responsibility for installation and ongoing management of an Oracle Fusion Applications installation.




Valuepack


Book Description




Oracle Exadata Survival Guide


Book Description

Describes what Exadata is and its available configurations for such features as smart scans, storage indexes, hybrid columnar compression, and Smart Flash Cache.