This week we provided training sessions Data Mapping, Common Metadata under Data Warehouse, IEEE, PhoneNet under Networking and Database Interaction under database.

Knowledge Base Latest Updates

Data Warehouse

What is Data Mapping
Data mapping is a very important aspect in data integration. In fact, it is the first step in the many complex tasks associated with data integration which include data transformation or data mediation between a data source and its destination; identification of relationships in data which is vital in analysis of data lineage; discovery of sensitive

What is Common Metadata
In simple but technical term, metadata is a data that describes another data. It can be any item describing an individual datum or a collection of multiple content items. Metadata is very useful in facilitating the use, management and understanding of data in a large data warehouse. Depending on the type of data and the context where the data is being

Networking

What is IEEE
IEEE, which stands for the Institute of Electrical and Electronics Engineers, is an international, non-profit, professional organization started in 1963 as the merging of two organizations, the Institute of Radio Engineers (IRE) and the American Institute of Electrical Engineers (AIEE), with the objective of advancing technology in electrical, electronics, communications, and computer engineering, and computer science.

What is PhoneNet
PhoneNet, developed by Farallon Computing (now known as Netopia), is an implementation of the AppleTalk physical layer. It made use of standard unshielded twisted-pair telephone wire, in the form of four-conductor patch cords, with 6 position modular connectors (same as used in the popular RJ11 telephone connectors). These modulators were connected

Database

Database Interaction
Database Interaction Overview Efficient interaction, efficient storage, and efficient processing are the three key properties of a successful database platform. In this article, we explore the first: efficient interaction. Interaction Category 1: Command Line Clients Many database platforms are shipped with a simple command line utility that allows

Ajax Articles

● Reverse Ajax Technique

● MarkItUp - Light and Data Friendly Application

● Mainsoft Enables ASP.Net for Linux OS

● JavaScript Timers for Ajax

● Speed up Ajax using JSMin in JavaScript

● Aptana Jaxer for a better Ajax Web Server

● Comet: The Next Stage for Ajax

Free Training

Why SQA
There are so many reasons why a company should consider SQA. It is all about business survival and SQA is just one of the many tools the company should effectively use. And just like a tool, it has to be effectively used to its maximum. If the tool is not used to its full extent, the tool will just be a financial burden to the company. SQA should also be utilized at the same way – to its full extent.

Moving All the XML Processing into the Database
In the preceding example, the database server performs only a part of the XML processing while the rest is still performed by the PHP engine. Specifically, the database server generates an employees XML document based on the records from the hr.employees table, and the PHP script then transforms that document with XSLT into HTML format with the PHP XSL extension functions.

Performing XML Processing inside the Database
When building XML-enabled applications on top of Oracle, there are many advantages to performing the XML processing inside the database when compared to performing it on the client. The key advantages to perform XML processing inside the database are as follows:

Transforming and Processing XML with XSLT
In the preceding example, you transform XML into HTML directly in your script, wrapping the data extracted from the XML document into appropriate HTML tags. Alternatively, you might perform an XSL (Extensible Stylesheet Language) transformation to get the same general results.

Querying a DOM Document with XPath
One way to access the DOM tree in a DOMDocument object is through an associated DOMXPath object. Identifying a specific node or nodes within the DOM tree of a DOMDocument object with this approach involves use of appropriate XPath expressions passed to the DOMXPath object as parameters.

Creating XML with the DOM PHP Extension
In fact, the PHP DOM extension is a set of classes that can be used to generate, access, and manipulate XML data. The DOM.php script defined in the following listing shows how to generate an XML document based on the result set retrieved from the database.

Processing XML in PHP/Oracle Applications
As mentioned, there are two alternatives when it comes to performing XML processing in your PHP/Oracle application. You can perform any required XML processing using either PHP’s XML extensions (or PEAR XML packages) or Oracle’s XML features.

PHP Oracle Web Development
Data processing, Security, Caching, XML, Web Services, and Ajax
The book is written by Yuli Vaseliev, a well known author of different web development and programming books. PHP Oracle Web Development: Data processing, Security, Caching, XML, Web Services, and Ajax is a good starting book for any web development professionals and enthusiasts. It covers the basics of web development using PHP and database management of Oracle including an installation guide for Oracle and PHP.