Writer ?

Interested in writing articles, reviews etc., but don't know where to publish it ?. Don't worry, software helper provides you the opportunity to publish your articles, reviews etc., in our Writer's Corner Section. If you contribute articles regularly to software helper, you will become one of the Official writers of softwareonlinehelper.blogspot.com Submit your articlesEmail me!
Photobucket If you're looking for more information within or out of this site, you can search Google . Google is the fastest and the most reliable search engine on the net today. Type in the Google search box below, the key words of the information you want like "free mobile software". Add google search box and other specific keywords to get a more relevant search engine results for the information, resources or ideas you are looking for.
Search here
Custom Search

Share This On

Tuesday, April 22, 2008

1.Real World Example

introduction to Adobe Photoshop

Part Three: Learn by Example
# Real World Example

Let's apply what we have learned. This sample requires the use of many of the tools that we have described.

Tools are not used in isolation. In the real world, tools take a back seat to the process.

Photoshop tools, channels, layers, effects, and used together as necessary to get the job done.

Real World Example

Phase I:

Phase II:
Phase III:
Phase IV:

Backboard A and B
Rainbow Face A and B
Logo Text A, B and C Visual Illusion and File Formats

Real World Example

Phase I-A: Backboard Preparations

  1. Preliminary
  2. Channels Palette
  3. Channels Option
  4. Gradient Fill Tool
  5. Gradient Tools Options
  6. Gradient List
  7. Apply Gradient Fill
  8. Change Options
1. Preliminary

The project started in Corel Draw 6. The structured drawing program was the ideal place to give birth to the rainbow paint palette shape.

Export the shape as a TIFF file, a selectable save bitmap file format in Corel Draw.

Import the TIFF file into Photoshop and Create an outside mask of the shape using the Magic Wand tool, as follows.

Set the Options to Tolerance value 4 and check to activate the Anti-aliased option.
Place the tip of the Magic Wand tool within the black shape and click. This will select the area outside the shape. Save the selection as a mask by choosing:

Selections > Save Selections > New

2. Channels Palette

Click on the Channels Tab. The new mask will appear at the bottom as #4. Scrolling down may be necessary to see it.

3. Channels Options

Double click on Channel #4 to activate the Channels Options requester to rename it.

Rename #4 to Full Size Mask and click OK.
The Channels Palette label will reflect the change.

4. Gradient Fill Tool

Click to activate it from the Photoshop Toolbox.

5. Gradient Tools Options

The Palette Tab will change automatically to show the Gradient Tools Option. The defaults are Normal, Opacity 100%, checks on Mask and Dither.

I set the Type to Linear and Gradient to Blue Arrow. Blue Arrow is a custom gradient that I saved to the gradient list.

6. Gradient List

Access the Gradient List by clicking on the down arrow at the end of the Gradient row. Photoshop provides many custom gradients. Set your gradient to Copper from the gradient drop down list.

7. Apply Gradient Fill

Click and drag from point A to point B with your gradient cursor point.

Upon release, the selection will be filled with Blue Arrow or the Copper gradient.

This JPG sample is scaled to 60%, reducing the file size for faster down-loading and layout considerations.

8. Change Options

Using a gradient from the list does not always provide the solution needed. Photoshop offers numerous ways to change image appearance. Some of them are as follows:

* Reapply the Gradient going from B to A.

* Use Gradient with different start and end points.

* Use a different gradient from the Gradient List.

* Change the gradient with Gradient Edit.

* Click on the Edit... button in the Gradient Tool Options Palette to display the Gradient Editor.

Wednesday, April 16, 2008

13.About The Text Tool

Photoshop Standard Text Dialog Box

PhotoTools™ Text Dialog Box

PhotoText is surrounded by an array of tools to add, manipulate and position text. The editing is done in text blocks of any size and number.

Color Picker
Use it to pick a color directly off the image. It also has a magnifier to zoom in to find that exact color.

The RGB read-out gives exact values. Switch back to the pointer and the RGB read-out changes to precise X and Y coordinate values.

Point Size

The height portion of a type face determines the point size. Ascenders, descenders, and width are not considered. So depending on these other factors, type can be taller, shorter, wider, or narrower.

* Helvetica 23 point Font

* Times New Roman 23 pt. Font

* Brush Script MT Italic 23 pt. Font
* Microsoft created Arial to replace the classic Helvetica.


Times New Roman 12 point font is considered a good default size for body copy. Notice that if Helvetica or Brush Script MT Italic 12 point fonts were used in place of the Times New Roman, the body copy area would change affecting the layout.

Many children, senior citizens, and adults with reading glasses prefer a larger type size than Times New Roman 12 points for their body copy.

* 12 points in a pica
* 6 picas in 1 inch

Kerning: Tracking or Character Spacing

Kerning is an aesthetic regard for the negative space between characters. Study the two kerned samples to the left. The difference is subtle.

I prefer the letter spacing of the lower sample but kerning is a personal judgment call. The only difference between them is the kerning pair "Ty".

Most computer fonts today are proportionally spaced, meaning they are pre-kerned. Custom kerning is very labor intensive and it is usually reserved for use on large display type. Courier is the infamous non-proportional type carried over to PC's from the typewriter.

Many DTP applications use the term "tracking" for kerning. Microsoft Word™ refers to kerning as "character spacing."

Unfortunate Discovery

When I began this tutorial, I was using PhotoTools™ 1.0. Extensis gave me an upgrade to PhotoTools™ 2.0 after I discovered a bug.

Unfortunately, it still has a critical flaw. It discounts the font's kerning pair information. This cripples the power of PhotoText. Extensis is working to correct the problem in future upgrades.

The PhotoText example given at the beginning of this Text section still gives a strong idea for how text might be handled in future Photoshop upgrades. I still recommend Extensis™ PhotoTools™ for their other power packed components:

* PhotoBevel
* PhotoEmbos
* PhotoGlow
* PhotoCastShadow
* PhotoButtons, and more.


The space between lines of type, measured base-to-base in points. A 14-point type has a standard leading of 18 points (120%). Leading is a term left over from the hot-metal typesetting days, in which strips of lead were inserted between lines of type.


A typeface can include many fonts. Helvetica is a typeface. A 16-point Helvetica is different from a 24-point Helvetica and from a 16-point Helvetica Italic. A font includes all of the type capitals and lowercase letters, numerics, and punctuation marks of one typeface in a specific point size.

Serif and Sans Serif Fonts
Serifs are the ornamental finishing strokes at the end of the main strokes, such as the "feet" at the bottom of the Times New Roman "F".

Sans is the French word for "without". It is a blend of Latin sine and absentia, in the absence of. It also has another name, Gothic. Compared to Gothic, Serif has more of a Romanesque presence. This sans serif example is Helvetica.


Left justified This is a text block. This a a left justified text block. This a left justified text block.

Center justified This is a text block. This is a center justified text block. This is a center justified text block.

Right justified This is a text block. This is a right justified text block. This is a right justified text block.

Fully justified type has all
its .lines . the .same . length
(unless they're . indented or
end of a paragraph.), ..pro-
ducing even left . and . right
margins.The word spacing
varies, .and hyphenation is
used as necessary.

Comment: As a graphic element, fully justified type looks great. Unfortunately, it is hard to read. The default ragged left justified setting works for most general purpose uses. Compare and make your own judgment.

This completes this section. The next section is the Real World Example. You might take a breather before moving on. The following section is fun but intense.

12.What Are Filters and Plug-ins

Photoshop Filters

Photoshop has plenty of powerful built-in Filters. Apply special visual effect to your images using Filters. Look at the long list in the drop down menu sample to the left.

A very effective way to learn Filters is to play with them. Start with a few that sound familiar to you.

Before you use any of the filters, create an image in your mind's eye of what you expect to see. This is important for building your skills and your mental reference library.

Reference Library

I have Zip disks labeled Graphics Library 1 and 2. They contain numerous sub-folders. One of the sub-folders is labeled Filters.

I suggest that you might do something similar. Save some of your key test images and related text files into that folder. Review these files periodically for insight, or their value will become meaningless.

Filter Tests

Start your testing and play by using the default settings or create your own starting points when necessary. Use the same filter and settings on several other images with differing range and characteristics such as:

* Color.
* Tone.
* Contrast.
* Sharpness.

Also try out filters on various size images; value settings are influenced by image size. A larger image will require higher value settings.

Cheap Insurance

Always start with a duplicate image on a new layer. This will keep your reference image handy and unaltered. Relabel the Background Copy layer to something relevant.

I may label the layer GusBlur_5 if my major action on this layer is the use of the Filter Gaussian Blur set to the value 5.

Renaming A Layer

Double clicking on a layer opens the Layers Options dialog box where the layer can be easily relabeled.

Blur Of Choice

The plain Blur and Blur More have no controls. Use Gaussian Blur, it has controls and a real-time preview.

In Windows "..." after a menu selection indicate further options such as a dialog box or controls. The following options all launch control windows.

* Motion Blur...
* Radial Blur...
* Smart Blur...

Try these functions on your own. They will probably help solve some graphic conundrum in the near future.

Expectation and Predictability

Start with a mental image or some other measurable expectation. Play and experiment based on those expectations. Review the result in comparison to the original mental picture.

Play with the Filters as you would with a new lens or color films. Get to know their characteristics. After you gain an inner sense through trial and error, you can select the right tool and use it "just so" to give birth to your inner ideas.

Save and Review

Write down your expectations and insights. Write down the results and discoveries. Be sure to write down your conclusions gained from matching the mental image with the concreate results. Save the text file, along with the image files, to your reference library.


Review these files periodically for insight, or their value will become meaningless.

Anything That Works

For some people, this method may be a turn-off or a waste of time. Do whatever it takes to keep your inspiration cooking.

Plug-ins: Fun Just Got Turbo-charged

Photoshop, like most other professional tools, supports Plug-ins. This allows the use of Filters developed by other software developers.

Once installed, they appear at the bottom of the Filters drop down list as shown above. I use Kai's Power Tool 3.0 and Extensis Photo Tools because they work for my needs. There are many other Plug-ins such as:

* AlienSkin
* Andromeda
* Chromatica
* DigiEffects
* Factory
* Fastcore
* Digital Frontiers
* Picture Man Collection
* The Flux Collection
* Visual Manipulation
* And more...

Cautionary Note:

There is a tendency among many photographers to become overly fixated with the gear. They can end up with so much new unfamiliar gear that their reaction time becomes snail slow. Some have even given up on picture taking altogether because they are too tired of lugging their technical burdens.

Do not let your photograph or the message get lost behind fancy or cool tricks. I use Filters to create an effect that adds to the message. I also use Filters that logically combine effects to save me production time.

Go Next to the last part of this section, Text Tool

Sunday, April 13, 2008

Agile AVI Video Converter 1.9

Agile AVI Video Converter is the most popular video software for converting videos to AVI (AVI,DivX,Xvid).It provides an easy and completed way to convert video formats such as MPEG, MP4, WMV, Xvid, DivX, ASF, MOV, VOB, etc to AVI (AVI,DivX,Xvid) with the perfect output quality.Only 3 steps is essential for converting video to AVI (AVI,DivX,Xvid): Add files, select a profile and start.Besides, you do not need to worry about codecs because all audio/video codecs are build-in.Batch conversion function of Agile AVI Video Converter very useful and convenient to convert multiple files.Anyway, as a AVI (AVI,DivX,Xvid) converter, Agile AVI Video Converter is the best choice!

New features in the latest version:

# Newly upgraded! Support converting video to DivX AVI.
# The new Agile AVI Video Converter supports AVI,DivX,Xvid encoding/decoding.
# You can set the output AVI (AVI,DivX,Xvid) files overwrite or rename.
# The kernel codes have been re-designed to improve the output quality of videos.

Functions of AVI Video Converter:

# Convert video files to AVI compatible video formats.

# Support all popular video formats such as MPEG, MP4, WMV, Xvid, DivX, ASF, MOV, VOB, etc to AVI (AVI,DivX,Xvid).

# Support batch conversion.

Features of AVI Video Converter :

# Convert video files to AVI within a few seconds.

# Support almost all popular video formats such as MPEG, MP4, WMV, Xvid, DivX, ASF, MOV, VOB, etc.

# Convert video to AVI (AVI,DivX,Xvid).

# Support to set the start and end time to convert segment of videos.

# All video encoders/decoders are build-in.

# Include usual video/audio output profiles.

# Support "Drag and Drop" fully.

# 3 steps is needed for conversion.

# 100% compatible for Windows98,ME,2000,NT,2003 Server and Windows Vista.

# Easy-to-use and user-friendly interface.

# Free technical support and upgrade.

# 30-days Money Back Guarantee.

How to convert video file to AVI video

Add the video or movie to Task list.
Select a output profile and output path.
Click Start button

Saturday, April 12, 2008

Entrepreneur's Online Starter Kit

Every piece of communication that you send out to potential clients should include your brand elements—your logo, contact information, and the visual elements that make you credible and your brand memorable. This package includes:

Entrepreneur's Logo Design

Our custom logo design package includes a unique, collaborative process with the following design steps:

* Development of a universal, timeless symbol and/or decorative graphic elements

* Specification of logo fonts, to reinforce corporate message while remaining legible in the logo when it's reduced in size

* Selection of colors for your logo, based on color psychology and theory, trends, and industry standards

* Consolidation of symbol and company name into a single logo unit

* Modification of symbol and font choice to match each other, creating a unified look overall

You also get:

* The final logo files in 10-14 file formats and in color, black and white and greyscale (if applicable), to fill all of your future graphic needs

* Sale to you of the full rights to the final logo, and the ability to copyright or trademark it as your own.

In this in-depth logo design process, you will receive a minimum of 10 concept sketches and up to 5 total rounds of design. You'll see many variations of the logo, and in the details of the logo, throughout this process. You will be able to revisit some of the steps throughout the process if the options presented aren't to your liking. The entire process takes 2-3 weeks (when you provide feedback for each round within 1 business day).

Stationery Set Design


* Business card
* Digital or Print Letterhead Design
* Envelope or Mailing Label

In the stationery system design process, you will first receive 3-5 initial sketches of the business card. Once the creative direction for the business card is chosen, 1-2 matching designs for each the remaining pieces will be created. Up to 2 rounds of revisions are included in this package.

The final deliverable will be a full set of files — PDF, EPS and Adobe Illustrator files. Printing is not included.

The design process for the Stationery Set typically takes approximately 1-2 weeks.


In this package, the website can be up to 5 pages in length. The design process includes:

* Company and Competitor Research. In this phase, we'll review the Website Design Questionnaire which will provide me with information about your company, target market and website goals. I'll also do research on your competitors — to make sure that the website that I develop for you is unique and stands out.

* Site Design. The graphic design of one of the pages of the website. In this phase, we will address the visual design of the navigation system, the structure of the navigation system (which links are to be included in the navigation), text styling, and creation of a graphic "frame". I deliver 3-5 initial designs in the first round. Up to 2 rounds of revisions are available in this phase.

* Site Template Coding:

o Web Image Production and Optimization, to ensure that the graphics on the site will be clear and quick-loading.

o Hand-coding of the website in HTML.

o 1 round of revision is available in this phase.

* Full Site Coding, consisting of:

o Web Image Production and Optimization, to ensure that the graphics on the site will be clear and quick-loading, for any additional images in the site.

o Hand-coding of the website in HTML.

o Basic Search Engine Optimization, consisting of taking the keywords you provide and embedding those in the HTML code.

o 1 round of revision is available in this phase.

* Testing of the website on both Macintosh and PC platforms, using major browsers — Internet Explorer, Firefox, Safari (Mac only) and Netscape (PC only).

* Launch of the site on the web. The site is FTP'd to your website host, and tested online.

* Basic Search Engine submission. Your site URL is submitted to Google and Yahoo.

Define Your Difference Branding Workbook

In order to design your business brand, you have to first know what makes you different, you have to first understand what your business is all about. You have to form a strong and unique foundation for your business brand.

This workbook will help you to do just that. It takes you through all of the questions to form your business's Brand Definition, so that you can figure out Who You Are, What You Do, Who You Can Best Help and What Makes You Different. Once you have those 4 elements clearly defined, creating a clear and effective business brand will be much easier.

Plan A Website That Works

A well-planned and well-done website can do more for your business than just, well, be a website. A website that's designed well can act as another employee in a small business, doing some of the tasks that keep your business successful.

This workbook will walk you through all of the questions that you need to answer in order to create the best possible website.

Raise Your Ranking: The Small Business Guide to Getting Found on the Search Engines

Do you wish that your website would come up in Google?

Well, you can stop wishing for it to happen and start learning how to make your site rank really well with my newest product, Raise Your Ranking. This product consists of 5 interviews about the psychology of the Search Engines, and an eBook that walks you through the process from a tactical perspective. There's also a workbook that walks you through the process step-by-step.

Friday, April 11, 2008

CPU Monitor

Disclaimer: This download is for personal use (mobile phones) only. Kindly do not copy, modify, distribute or sell the whole or parts of this file without permission of the creator

Date Added :1 weeks 5 days 4 hours 35 minutes ago

WAP ID :To download this file directly to your mobile phone from WAP, enter 445029 @ http://wap.mobile9.com/

Download Credits
Required :1

File Type :sisx

Popularity :13543 downloads and 3 favourites

Filesize :39.61 KB

Tags : s60 v3 cpu monitor

Folder :Productivity

Mesa Info Booth 3.1

What's new in 3.1:
Due to the changes of data source, some widgets of perivous versions don't work any more. Please upgrade to this version.
What's new in 3.0:

1. Movie theater showtimes support U.K. and Canada now.

2. Search local events on mobile!

3. Real time U.S. flight status and airport status.

4. Tip Calculator.

5. Currency converter.

6. Cloth/shoe size converter.

7. Measurement converter.

8. Bug fixes.

What's new in 2.3:

1. News for Canada, Italy, Austria, and Switzerland.

2. Chinese, Japanese, and Slavic dictionaries.

3. Check weather by Yahoo location ID such as SNXX0006 (Singapore).

4. Check movie showtimes in your favorite local theaters (U.S. and Australia)!

5. Bug fixes.

Mesa Info Booth (http://lightower.org) delivers weather, all kinds of news, stock quotes/company headlines/market news, dictionaries of various languages, movie information and theater showtimes, sports information and scores, tip calculator, local events, flight/airport status, currency converter,measurement converter,clothing size converter games, RSS reader, podcast/videocast and more to your sexy cell phone.

RSS Reader - supporting image, podcast, and video! JSR-135 is required for podcast and videocast.

Weather - Up-to-date weather and forecasts for thousands locations worldwide.

News - All kinds of news with (optional) photos for U.S., U.K., Canada, Australia, France, Italy, Germany, Austria, Switzerland, and China.

Stock - Stock quote, charts of various styles, technical indicators, company headlines, industry news, and market news.

Dictionary - Online dictionary supporting English, Chinese, Japanese, Russian, Arabic, and much more!

Entertainment - Theater showtimes and movie information (opening in this week, coming soon, top box office).

Sports - Various Sports news and NBA, NFL, NHL, and MLB teams news and scores.

Tip Calculator - Calculator tip, total and split per person.

Local Events - Search various local events in your area.

Flight/Airport status - check real time flight status.

Currency Converter - Convert currency based on latest exchange rates.

Measurement Converter - Convert between various measurement units (area, length, distance, pressure, temperature, volume, weight, etc.) Great for travel!

Clothing size converter - transfer clothing sizes for different countries.

Tetris - The No. 1 popular video game!

Gobang - also called Gomoku, Go-moku, or Connect Five. A traditional oriental strategy board game.

Bubblet - A clone of award-winning Windows Mobile game.

Blackjack - Play the No. 1 casino card game on your cell phone.

Disclaimer: This download is for personal use (mobile phones) only. Kindly do not copy, modify, distribute or sell the whole or parts of this file without permission of the creator.

Wednesday, April 2, 2008

Why XQuery?


XQuery is a powerful, concise, and highly optimized language that is designed for processing XML data — that is, it can process any data that can be expressed as XML. XQuery allows applications to query relational data together with structured data, such as native XML. Traditionally, enterprise applications have relied on SQL queries to retrieve and update data in relational databases, but given the continuing rise in prominence of XML, this is already changing. Even before the W3C XQuery specification reaches Recommendation status, XQuery is grabbing the attention of many developers, CTOs, and development managers.

This article provides information on XQuery's background, its benefits, and its pivotal role in data integration. Next, it provides an overview of XQuery's syntax and shows examples of what an XQuery query looks like. Finally, we describe how you can implement XQuery and mention some caveats to be aware of in XQuery 1.0.

XQuery: Its History

XQuery originally evolved from another XML query language named Quilt. To understand the origin of XQuery, we asked Jonathan Robie, the XML Program Manager at DataDirect Technologies and XQuery specification co-author, to explain what triggered the effort to create a language that could query XML. Jonathan provided the following response:

"Back in 1998, those of us who had bought into the XML vision assumed that many kinds of information would be exchanged or stored as XML, and that this would involve massive amounts of data. We also realized that a query language that was based purely on the structure of XML could be used for anything that XML could represent. Even better, the semi-structured community taught us that the data did not need to be physically represented as XML, as long as we knew an XML representation and were willing to write some middleware. For instance, an XML query
could think of relational data as XML data, and middleware could translate the query to SQL, turning results
into XML for the XML query. So, we already had a universal representation for data, XML, and we wanted a universal query language for this data. By May 2000, we had developed Quilt, the predecessor of XQuery."

Unlike extensions to the SQL language that give some provision to work with XML, XQuery is designed as a separate language optimized to work with XML data. Now that we've established XQuery as a powerful XML processor, let's take a look at why its arrival is so important.

XQuery's Role in Data Integration

XML is now considered the de facto standard for exchanging data. The rapid growth of XML and increase of hierarchical messages present a fresh set of challenges, particularly to developers who have historically built their business processes around databases. Because relational database systems are well-established and reliable, they are unlikely to disappear any time soon. The growth of XML is forcing modern business applications to function seamlessly with both relational and XML data.

XQuery levels the data integration playing field by providing a single interface that lets developers access multiple data sources under a unifying data model. Products such as DataDirect XQuery™ from DataDirect Technologies deliver Java components that allow the developer to present and exchange relational data as XML and to process relational and XML data together.

Before XQuery, integration of relational and XML data forced architects and developers to choose from one of the following complex strategies:

* Shredding (de-composing XML into relational tables) XML data into individual relational database table columns. This process "flattens" the built-in data hierarchy and often loses internal relationships. The original XML document itself also is lost, although it can, in some cases, be reproduced from the shredded data.
* Storing the XML data as unstructured data in a relational database using the Clob data type. Clob columns can store an XML document in its entirety, preserving both the document and its internal relationships.
* Storing the XML data as a structured XML document in a relational database. This option provides a tightly coupled relationship between XML and relational data within the context of a relational database system. However, support for the co-existence of structured XML and relational data in today's relational database systems varies considerably, which makes it difficult to implement a portable and consistent data integration strategy.

Because XQuery is about seamless data integration, the middle-tier is the logical sweet spot for developers and architects to establish the solution to their most complex data integration challenges.

XQuery: Anatomy

We've introduced XQuery, described its objectives, and explored how it will play a critical role in tackling complex data integration challenges. Now, let's look at some of the details of XQuery, starting with an overview of the data model that XQuery uses.

XQuery Data Model

XQuery uses an XML data model that can represent XML documents, sequences, or atomic typed values (such as integers or strings). For example, an XML document is represented as a tree of nodes, including a document node, element nodes, attribute nodes, comment nodes, and text nodes. Both the input and the output of any query are represented in this data model.

XQuery Data Types

The primitive data types in XQuery are the same as the data types for XML Schema. They include floating point numbers, Booleans, strings, dates, and many other data types you've encountered in other languages. In addition, XQuery allows you to extend these types using a variety of methods, providing maximum flexibility to the developer.

XQuery Expressions, Operators, and Functions

We will now present an overview of the functional language components of XQuery. For the purposes of this overview, we're using the sample data from the XQuery Use cases.

Path Expressions

All path expressions are based on the same syntax as XPath 2.0. XPath has long been the established standard for specifying paths in an XML document.

This example searches the books.xml document and returns every chapter node's title child value.


Element Constructors

Using simple constructs, you can create a new XML structure for an XQuery result.

This example, used in conjunction with a more complete XQuery expression, generates a new element for each value for title.


FLWOR Expressions

The FLWOR expression, pronounced "flower," is the most powerful of XQuery expressions and is, in many ways, similar to SELECT-FROM-WHERE used in SQL. Most XQuery queries are built around the FLWOR expression. The name FLWOR is an acronym, representing the first letter of the clauses that can occur in a FLWOR expression: FOR, LET, WHERE, ORDER BY, and RETURN.

In this example, we perform a simple search that returns all books published by Addison-Wesley after 1991, inclusive of each book year and title.

for $b in doc("http://bstore1.example.com/bib.xml")/bib/book
where $b/publisher = "Addison-Wesley" and $b/@year > 1991



In this example, the FLWOR expression consists of the following clauses:

* The FOR clause binds the $b variable to a sequence of book title values.
* The WHERE clause specifies conditions that filter the book values to only those books published by Addison-Wesley after 1991.
* The RETURN clause builds the result of the FLWOR expression based on the conditions specified in the WHERE clause and using the structure specified in the RETURN clause. In this case, the result looks like this:

Operators and Functions

As you would expect, XQuery provides a similar range of operators and functions that you have encountered in other languages. In addition, XQuery provides functions that allow queries to leverage the XML document structure.

In this example, we use the function min() to determine the minimum price for each book. We generate the element, with the book title as its attribute.

let $doc := doc("prices.xml")
for $t in distinct-values($doc//book/title)
let $p := $doc//book[title = $t]/price



There is much more to XQuery including conditional and quantified expressions that allow you to compose more powerful queries to fully leverage the potential of XQuery. We provide more information about these in the XQuery Basics Primer.

Using XQuery with Your Java Applications

Having gained an understanding of XQuery and what a basic XQuery query looks like, we now look at implementations that allow you to use XQuery with your applications today.

The XQuery API for Java (XQJ) is the standard Java API for using XQuery with Java applications. XQJ functions much like the JDBC API by channeling your XQuery query to the data source and returning the XML result so that it can be used by any Java application. We explore more on how this works in the XQJ Primer.

Middle-tier components such as DataDirect XQuery™ are built on XQJ and allow any Java application to perform XQuery queries on XML or relational data, or a combination of the two. Information about other implementations can be found on the W3C XQuery Web page.

XQuery Gotchas

XQuery is quickly approaching the final approval of the W3C standard organization. All the signs point to a Recommendation status in the not too distant future. There are, however, some caveats to be aware of in the XQuery 1.0 release:

* Full-text search is not part of XQuery 1.0, although it is possible that it may be considered in future drafts. A full-text search can be thought of as similar to a typical Google keyword search. You can find additional details here:


* Updates are not included as part of XQuery 1.0, but work has already begun on defining the XQuery update drafts. Again, the XQuery working group is working to determine whether updates will be included in a subsequent version of XQuery. More details can be found here.


The official W3C XQuery Recommendation is almost done! Significant interest in using XQuery for data integration is gathering steam, signaling a healthy adoption of the technology when it does reach Recommendation status. To learn more about XQuery, our XQuery Basics and XQJ Primers provide the basics you need to succeed with XQuery, and ultimately, your data integration challenges. Our XQuery Tutorial and XQJ Tutorial also provide more in-depth knowledge about these technologies.

Link Exchange With Me

If you want to link exchange with me, add my blog into your site and drop me a comment. I will do the same immediately. Happy Exchange :)
Add to Google
PhotobucketPhotobucketNew, unique and user-friendly software solutionsFind the software you're looking for,the most comprehensive source for free-to-try software downloads.Free Internet marketing resources, web site development tutorials, ecommerce strategies & software solutions. Shopping cart reviews & affiliate marketing guides & articles, plus search engine marketing resources & tools. Submit Your Site To The Web's Top 50 Search Engines for Free!ExactSeek - Relevant Search Blog Search: The Source for Blogsfree search engine website submission top optimization Software Top Blogs Technology blogs Software blog directory Fantasy blogs Back Link Site Website Traffic Tracker Subscribe in a reader

Add to Google Reader or Homepage

Add to Plusmo

Subscribe in Bloglines

Add to My AOL

Add to Webwag

Technorati Profile Add to Technorati Favorites

© Make money online | Watch online free videos