In this article by Simon Greener and Siva Ravada, the authors of Applying and Extending Oracle Spatial, we provide a SQL schema and functions that facilitate the storage, update, and query of collections of spatial features in an Oracle database.
Oracle Spatial and Graph provides a SQL schema and functions that facilitate the storage, update, and query of collections of spatial features in an Oracle database. Oracle Spatial and Graph is the new name for the feature formerly known as Oracle Spatial. In this article, we refer to this feature as Oracle Spatial for the sake of simplicity. We also focus exclusively on spatial feature of Oracle Spatial and Graph in this article. Oracle Spatial mainly consists of the following:
- A schema (MDSYS derived from Multi-Dimensional System) that defines the storage, syntax, and semantics of the supported geometric (both vector and raster) data types
- A spatial indexing mechanism for faster querying and retrieval
- Operators, functions, and procedures for performing spatial analysis and query operations
- A persistent topology data model for working with data about nodes, edges, and faces in a topology
- A network data model for modeling and working with spatial networks
- A GeoRaster data type and associated functions that let you store, index, query, analyze, and deliver raster data
OpenGL for Embedded Systems (OpenGL ES) is a simplifed version of the popular OpenGL framework that has been developed to be much easier to learn and implement, eliminating the need for redundant functionality within the iOS graphics hardware. This framework has been optimized to take full advantage of hardware-accelerated mathematical operations, so that developers can get the best performance.
In this article by Steven Daniel, author of iOS 5 Essentials, we will be focusing on the new debugging features that come with the OpenGL ES debugger that enables developers to track down issues specifc to OpenGL ES in your code. Debugging with OpenGL ES
In this article, we will:
- Learn about the new workfow feature within Xcode 4
- Create a simple project to debug an OpenGL ES application
- Familiarize ourselves with the OpenGL ES 2.0 programmable pipeline
- Compile and link shaders into an OpenGL ES program
- Pass data from an application to shaders, using uniforms and attributes
- Detect OpenGL ES State information (view textures and shaders)
- Set and use breakpoints to catch OpenGL ES errors
- Set conditional OpenGL ES entry point breakpoints
- Break on frame boundaries
In this article by Ronald Rood, we consider the fact that when the jobs get more complicated, it gets harder to understand why something works differently than planned. This article gives the reader a fresh look at how to follow and debug Scheduler jobs in Oracle 11g.Read Debugging the Scheduler in Oracle 11g Databases in full
This article by Ben Lau, the author of Instant Sikuli Test Automation [Instant], will help you with the debugging of the Sikuli scripts. This article outlines two methods for debugging scripts:Read Debugging Sikuli scripts in full
This article by Ben Lau, the author of Instant Sikuli Test Automation [Instant], will help you with the debugging of the Sikuli scripts. This article outlines two methods for debugging scripts:
- Debugging by looking at the logs
- Debugging by recording videos of your test runs
Learning how to figure out why things are going wrong is one of the key aspects of developing software. We call it debugging. While dealing with REST services and clients, things can go wrong and it would help a great deal to know how to find out what is causing the problems.
In this article by Samisa Abeysinghe, we will look into the techniques such as message capturing and analyzing to get to know if things are going fine, and if not, what sort of problems are causing trouble.Read Debugging REST Web Services in full
Once your PL/SQL code has successfully compiled, it is important to review it to make sure it does what is required and that it performs well. You can consider a number of approaches when tuning and testing code. These approaches include:
- Debugging—run the code and add break points to stop and inspect areas of concern.
- SQL performance—use Explain Plan results to review the performance.
- PL/SQL performance—use the PL/SQL Hierarchical Profiler to identify bottlenecks.
- Unit testing—review edge cases and general function testing. Does the code do what you intended it to do?
In this article by Sue Harper, author of Oracle SQL Developer 2.1, we'll review the debugger. We will see how to debug PL/SQL packages, procedures, and functions.Read Debugging PL/SQL in Oracle SQL Developer 2.1 in full
In order to solve problems that arise in concurrently running threads in applications, we need new debugging techniques suitable for the new parallelism environments that occur in Visual C#. In this article by Gastón C. Hillar, we will learn many tricks and debugging procedures that will help us find solutions to multithreaded application problems and have a better understanding of the execution of parallel threads. In this article we will be performing the following exercises:
- Find out how to freeze some threads to stop concurrency and simplify the process for debugging one thread at a time
- Learn to set and control breakpoints with multithreaded applications
- Discover how to inspect values when multiple threads are accessing the variables that hold them
- Develop multithreaded applications that show partial results to help us in the debugging process
In this article by Nataraju Neeluru, we will learn how to debug a Java program using a simple command-line debugging tool called JDB. JDB is one of the several debuggers available for debugging Java programs. It comes as part of the Sun's JDK. JDB is used by a lot of people for debugging purposes, for the main reason that it is very simple to use, lightweight and being a command-line tool, is very fast. Those who are familiar with debugging C programs with gdb, will be more inclined to use JDB for debugging Java programs.
We will cover most of the commonly used and needed JDB commands for debugging Java programs. Nothing much is assumed to read this article, other than some familiarity with Java programming and general concepts of debugging like breakpoint, stepping through the code, examining variables, etc. Beginners may learn quite a few things here, and experts may revise their knowledge.Read Debugging Java Programs using JDB in full
Developing AJAX applications that involve complex client-side programming and communication with the server side raises the need for equally complex debugging tools and techniques.
Most of today’s AJAX frameworks, including the Microsoft AJAX Library, offer built-in capabilities for debugging and tracing.
In this article by Cristian Darie and Bogdan Brinzarea, we will learn about the capabilities built in the Microsoft AJAX Library, and we’ll also learn about third-party debugging and tracing tools.Read Debugging AJAX using Microsoft AJAX Library, Internet Explorer and Mozilla Firefox in full
Debatching data is the process of turning one huge pile of data into many small piles of data. There are multiple tools for debatching large bulk data loads including BizTalk Server and SQL Server Integration Services (SSIS). One can use such tools to break up large batches of data, manipulate it as needed, and send it on to its next reincarnation (for example, into an API, a relational database, or a text file). In this article by Mike Sexton, co-author of Applied Architecture Patterns on the Microsoft Platform, we will take a look at options for processing large data sets and explain how to take giant sets of data and insert them into databases for analysis.Read Debatching Bulk Data on Microsoft Platform in full
The previous part of the article focused on just a few modules, with an emphasis on date. We explored Date formats, Exposed filters fieldset and the Views Date Range Filter Module. We also had a chance to create some summary views. In this part by Marjorie Roswell, we shall create a Timeline, cover the Views Popup feature, create a Calendar and also make an iCal feed.Read Date and Calendar Module in Drupal 5: Part 2 in full
This is the first part of a two-part article series by Marjorie Roswell. All of the recipes in this article require CCK and the date field (also Views, and Views UI), so we won't take the space to list them in every ingredient list. In this two-part article, we create a wide variety of views, mostly from a single workshop content type. Several of the views implement style plug-ins, which appear as new options in the Views Type drop-down. If you are still working on the 1.x versions of Date, be sure to check out Recipe 44, Upgrade Date and Calendar Modules which will be discussed in the next part.Read Date and Calendar Module in Drupal 5: Part 1 in full
Round-trip engineering as applied to a database means reverse engineering (database to data model) and forward engineering (data model to database) back and forth.
In this article, Djoni Darmawikarta shows how to maintain an existing MySQL database using Power*Architect. Particularly, he shows by examples, how to reverse engineer an existing MySQL database, update the resulting data model, compare the updated model with the 'old' database, and implement the updates by forward-engineering them back to the database.Read Database/Data Model Round-Trip Engineering with MySQL in full
In this article by Alexander Makarov, author of Yii Application Development Cookbook - Second Edition, we will cover the following topics:
- Getting data from a database
- Defining and using multiple DB connections
- Using scopes to get models for different languages
- Processing model fields with AR event-like methods
- Applying markdown and HTML
- Highlighting code with Yii
- Automating timestamps
- Setting up an author automatically
- Implementing single table inheritance
- Using CDbCriteria
There are three main methods to work with databases in Yii: Active Record, query builder, and direct SQL queries through DAO. All three are different in terms of syntax, features, and performance.
In this article we will learn how to work with the database efficiently, when to use models and when not to, how to work with multiple databases, how to automatically preprocess Active Record fields, and how to use powerful database criteria.
In this article we will use the Sakila sample database Version 0.8, available at the official MySQL website: http://dev.mysql.com/doc/index-other.html.Read Database, Active Record, and Model Tricks in full
Having seen form validation in the previous article, we will now cover database interaction. Databases are the backbone behind any Web application. Without a database, you'd have nowhere to hold all of your data, and SQL queries can become long and cumbersome to type out. Thankfully, CodeIgniter gives us a brilliantly simple way to interact with our Database. The database library also makes changing between database types—from MySQL to Oracle, for example—easier, because it acts as a wrapper and provides many functions for us to use on the database.
In this article by Adam Griffiths, author of CodeIgniter 1.7 Professional Development, you will:
- Perform database queries with the database library
- Return query results using the database helper functions
- Create queries using the active record library
- Learn how to cache active record queries
- Modify database tables using database forge
In this article, by Martin Brampton author of PHP 5 CMS Framework Development, we will cover the following topics about databases in PHP 5 Content Management Systems:
- Database dependency
- The role of the database
- Level of database abstraction
- Ease of development
- Keeping up with change
- Database security
- Pragmatic error handling
In this article, by Shaun Mitchell, author of SDL Game Development, we will explore a new way to create our states and objects by removing the need to hardcode the creation of our objects at compile time. To do this we will parse through an external file, in our case an XML file, which lists all of the objects needed for our state. This will make our states generic as they can be completely different simply by loading up an alternate XML file. Taking PlayState as an example, when creating a new level we would need to create a new state with different objects and set up objects we want for that level. If we could instead load the objects from an external file, we could reuse the same PlayState and simply load the correct file depending on the current level we want. Keeping classes generic like this and loading external data to determine their state is called Data-driven Design .
In this article we will cover:
Loading XML files using the TinyXML library
Creating a Distributed Factory
Loading objects dynamically using the factory and an XML file
Parsing a state from an XML file
Fitting everything together into the framework
Packt are due to launch a new Enterprise brand, into which future Silverlight titles will be published. For more information on that launch, look here.
In this article by Frank LaVigne, author of Microsoft Silverlight 4 Business Application Development, we shall:
- Bind the data from a data object to Silverlight controls
- Validate data and display feedback to the user