Free Training
C Language   |   CSS   |   MainFrame   |   VBScript   |   PHP   |   XML   |   C++ Tutorials   |   Ajax   |   JavaScript   |   CSS3   |   UML   |   jQuery   |   Microsoft AJAX

Sponsored Links

Learn Oracle

Online Training

Career Series

 
 
Home Learn Oracle



 

Business Value What Really Matters It is very important to take a holistic view on what the benefits are for legacy modernization. There are of course cost savings in hard dollars that are associated with a large­ scale modernization. After all TCO ROI is often what drives most organizations. However we have seen an increasing amount of proof...
Add Comment

Here we look at strategies to modernization a set of data stores that are stored across disparate and heterogeneous sources. We often have problems with accessing and managing legacy data. There is an increase in cost to run batch jobs which generate reports 24 to 48 hours after they are needed. Further this legacy data often needs to be integrated...
Add Comment

Re-Hosting Based Modernization Evolving from the core re hosting approach and leveraging flexible rules driven automated conversion tools this approach goes beyond re hosting to a functionally equivalent application. Instead of a pure shift of COBOL code to a target system without any changes to the original code some of the automated tooling used...
Add Comment

Platform Migration This are a encompasses a few different approaches. They all share a common theme of low risk predictable migration to an open system platform with a high level of automation to manage this process. With platform migrations the focus is moving from one technology base to another as fast as possible and with as little change as...
Add Comment

SOA Integration Since SOA integration is the least invasive approach to legacy application modernization this technique allows legacy components to be used as part of an SOA infrastructure very quickly and with little risk. Further it is often the first step in the larger modernization process. In this method the source code remains mostly unchanged...
Add Comment

Application Portfolio Management APM APA is only a part of IT approach known as Application Portfolio Management. While APA analysis is critical for any modernization project APM provides guideposts on how to combine the APA results business assessment of the applications strategic value and future needs and IT infrastructure directions to come...
Add Comment

Deep Dive on Approaches There are five primary options for modernization and all are worthy of deep exploration. In the next section we will review each of these options at a high level. However this book is a deep technical dive on two approaches for Legacy Modernization namely SOA enablement and re­ architecture. These two options are selected...
Add Comment

A lot has been written on legacy modernization in the past few years. Most of the books analyst reports and white papers discuss at a high level why one should modernize and theorize and the different approaches to and possible outcomes of modernization. Instead of going into modernization theory we will quickly dive into the details of two very...
Add Comment

Breaking up XML into Relational Data While the preceding example shows how to construct an XML representation over relational data the example in this section illustrates how you can shred XML data back into relational data. This reverse operation can be useful if your application works with relational data rather than XML but the data which you...
Add Comment

Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2 you can take advantage of a full-featured native XQuery engine integrated with the database. With Oracle XQuery you can accomplish various tasks involved in developing PHP Oracle XML applications operating on any kind of data that can be expressed in XML. The following...
Add Comment

Taking Advantage of Standard Internet Protocols As mentioned Oracle XML DB provides native support for standard internet protocols such as HTTP S WebDAV and FTP. Continuing with the preceding sample you might for example upload another employee XML document into the XML repository with one of the above protocols say FTP. NOTE Starting...
Add Comment

Accessing Repository Resources with SQL In fact Oracle XML DB repository resources are stored in a set of database tables and indexes which can be accessed via SQL. You are not supposed to access those tables directly. Instead Oracle XML DB provides two public views RESOURCE_VIEW and PATH_VIEW through which you can access repository resources.For...
Add Comment

Using Oracle XML DB Repository Another variation on accessing and manipulating XML content stored in Oracle database is provided by Oracle XML DB repository which is an essential component of Oracle XML DB. NOTE Oracle XML DB repository also known as XML repository is a hierarchically organized repository seamlessly integrated with Oracle Database...
Add Comment

Performing DML Operations on XML Schema-Based XMLType Views Analyzing the underlying query of the empSch_v view discussed in the preceding section you may note that each attribute of the EMP_T object used in the select list maps to a certain column of a single table namely emps. What this means in practice is that the empSch_v view can be inherently...
Add Comment

Using XMLType Views Using XMLType Views XMLType views provide a convenient way to construct XML representations of relational data without physically migrating that data into XML. Once written an XMLType view may be used in various queries making them simpler and so increasing their readability. Turning back to the SELECT statement used in the SQLXMLQuery.php...
Add Comment

Retrieving XML DataTo retrieve XML data from an XMLType table you can use a SELECT SQL statement just as you would if you had to query a relational table. For example to select the employee with the id set to 100 from the employees XMLType table discussed in the preceding section you might issue the following query from SQL Plus when connected as...
Add Comment

Using XML Schemas The simplest way to create an XMLType storage structure in Oracle XML DB is by registering an appropriate XML schema against the database. As a part of the registration process Oracle automatically creates the storage for a particular set of XML documents based on the information provided by the schema. NOTE An XML schema can...
Add Comment

Using XMLType for Handling XML Data in the Database Being an object type XMLType can not only be used to store XML data in the database but also to operate on that data via its built-in methods. Regardless of the storage model you choose XMLType provides a set of XML-specific methods to operate on XMLType instances. The most commonly used methods...
Add Comment

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability. One of the most interesting things about Oracle XML DB is that it allows you to perform SQL operations on XML data as well as XML...
Add Comment

Performing XSLT Transformations inside the Database Now that you have the employees XSL stylesheet stored in the database and the xmlusr schema is permitted to access the hr.employees table you can create a script that will instruct the database to build an HTML page based on the data stored in hr.employees. The following listing contains the source...
Add Comment

 

Subscribe via RSS


Get Daily Updates via Subscribe to Exforsys Free Training via email


Get Latest Free Training Updates delivered directly to your Inbox...

Enter your email address:


 

Subscribe to Exforsys Free Training via RSS
 

 

Sponsored Links