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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...