PL/SQL Code Review Tool and Code Analysis

If you have trouble while doing PL/SQL Code Review, maintaining legacy applications, documenting old and unfamiliar code or digging into someone else’s code, you might be looking for a viable solution as a PL/SQL code formatter and analyzer.

Troubleshoot and manage PL SQL code is a difficult and time-consuming task, so you need an automated code review tool and quality control tool when implementing enterprise coding standards (e.g. code formatting, DB objects naming rules,…).

Continue reading PL/SQL Code Review Tool and Code Analysis

Share

Clear Reasons for Moving into the Cloud

Lojas Renner Business Case

One of the primary reasons companies implement the software-as-a-service (SaaS) model is to focus on
their business rather than on their IT.

Or, as Lojas Renner CIO Leandro Balbinot says, “We’ll leave the technology to our technology partners. ”
In deciding to move to the cloud, Balbinot says, the critical time for Lojas Renner came at the very beginning, “when we were deciding about the tool and the model and choosing a partner. I was familiar with Oracle Hyperion Planning and knew how useful it could be for Lojas Renner. ” So why use the cloud ?

Before a company decide moving into the cloud, it must map its business processes to the new software tools its IT partner will provide—a task Christopher Koch, associate vice president of research and thought leadership at IT Services Marketing Association, says can be “a nightmare”.

“At any company, there are all sorts of different databases and applications hiding behind the walls. Cleaning it all up and integrating the SaaS application with the non-SaaS applications it needs to talk to are significant challenges.” However, says Nicolas Simone, director of process and corporate projects at Lojas Renner, the company was not simply mapping its processes to enable the move to SaaS; the ultimate goal was to improve them. “We’re collecting workflows in all the stores, ” says Simone. “We’re working in all areas of the company—the stores, the suppliers, logistics, internal support, IT—to improve our business. ” Lojas Renner’s main implementation challenge this year was to “review all the processes to enable us to use the Oracle Hyperion tool best, ” says Balbinot. But the real difficulty, he says, came not with the tool but with change management. “You always have to deal with the Golden Age syndrome, ” Balbinot says. “That’s the idea that things were better before. But we brought examples of ROI (Return of Investment) from other companies to show how we could do better with the new model. It took some time, but in the end, most people supported what we implemented.”

Now, says Balbinot, for the first time, a majority of Lojas Renner transactions are accomplished through company- issued credit cards, leveraging Brazil’s transformation from a cash- to a credit- based economy and prompting the CIO to consider moving the company’s database offshore. “We’re looking to grow faster than we can with a local database. We ran some security tests, and we think our data could be safer in an Oracle center in the U.S. than in a dedicated center in Brazil. In practice, high service levels are achieved when you have the right experts and standard infrastructure when moving into the cloud.”

Share

How to Build Better Data Warehousing and Business Intelligence

The processing capacity of the Oracle Exadata Database Machine means fewer physical structures and better Data Warehousing and Business Intelligence.

ORACLE EXADATA DATABASE MACHINE
No, the Oracle Exadata Database Machine is not the infinite machine that will make integration, computation, and aggregation all on-demand functions. But the Oracle Exadata Database Machine helps us to start thinking about simplifying some of the processing and gyrations we have to do to build and deliver an efficient data warehouse solution. With Oracle Exadata, we can more quickly read the data we need to satisfy our queries. Without Oracle Exadata, we need to build separate structures—such as materialized views—in our data warehouses to boost performance. With Oracle Exadata, we don’t need to build as many physical structures, freeing up more time for using the data instead of processing it.

In general terms, there are two reasons for building additional data structures, or even databases, above an integrated data warehouse. The first is to make the data easier to consume by our end users and their reporting and analytic applications. To get better usability and to focus our analytic applications, we create a new subset of our data in snapshots or data marts to support a specific analytic or reporting application, and that subset is just another physical projection, or movement, of the same data. With Oracle Exadata, however, we create fewer physical projections and can create more logical projections of the data in our BI tool of choice in our integrated data warehouse for the same purpose.

Data Warehousing and Business Intelligence

Continue reading How to Build Better Data Warehousing and Business Intelligence

Share

Using MySQL for Business Intelligence (MySQL BI)

MySQL is particularly powerful when it comes to Web applications, but companies are putting the open source database to plenty of other uses as well. Take, for example, the Los Angeles, California-based global online ad sales firm Gorilla Nation Media.

Gorilla Nation relied on MySQL to power its advertising network business intelligence platform.

MySQL Business Intelligence

Gorilla Nation, part of Evolve Media, provides integrated media and promotional programs to Fortune 500 brand advertisers, including clients such as Fox Television, Best Buy, and more. Its customers demand advanced business intelligence (BI) and targeting methods to reach the perfect online audience for their advertising or brand campaigns. Reaching more than 66 million unique visitors per month— as Gorilla Nation does— requires Websites and an infrastructure that can scale effectively and efficiently.

That’s why Gorilla Nation chose MySQL as the foundation of its BI platform. The organization has more than 500 servers running MySQL, 20 of which are replicated. Its sites get approximately a quarter-billion page views per month, and MySQL manages more than 1TB of data for Gorilla Nation while providing near-real-time traffic and advertising campaign performance information to Gorilla Nation’s publishers and advertisers. In addition, Gorilla Nation uses MySQL to capture all the clickstream data and transactions required for back-office accounting and billing functions.

“One of the great beauties of MySQL BI is that it’s backed by an amazing company like Oracle, which has deep pockets and basically wrote the book on databases, ” says Veronika Burnett, manager of database engineering at Gorilla Nation. “Also, unlike other open source databases, MySQLis highly scalable. That allows us to do things in our business that are absolutely critical, such as having the same database running on multiple physical servers in multiple geographic regions and having near-real-time replication. ”
Continue reading Using MySQL for Business Intelligence (MySQL BI)

Share

Data Integration Solutions with Enterprise Manager Ops Center 11g

Data integration (Wikipedia definition) involves combining data residing in different sources and providing users with a unified view of these data. This process becomes significant in a variety of situations, which include both commercial (when two similar companies need to merge their databases) and scientific (combining research results from different bioinformatics repositories, for example) domains.

Data Integration Solutions OracleIT executives looking for ways to simplify hardware management in virtualized, traditional, and cloud-based datacenter environments can benefit from the new Data Integration Solutions in Oracle Enterprise Manager Ops Center 11g, the industry’s first converged hardware management solution for Oracle’s Sun environments.
Continue reading Data Integration Solutions with Enterprise Manager Ops Center 11g

Share

Hardware Management with Oracle Enterprise Manager

Oracle Enterprise Manager Ops Center 11 g simplifies hardware management in Oracle’s Sun environments and reduces costs by as much as 90 percent.

Oracle has streamlined systems and virtualization management with the release of Oracle Enterprise Manager Ops Center llg, a solution for managing systems across traditional, virtualized, and cloud-based datacenter environments. Through a converged hardware management approach, the new release simplifies management tasks for all infrastructure assets. It delivers infrastructure and lifecycle management, as well as integrated support. And while Oracle Enterprise Manager Ops Center 11g works as a standalone console, when combined with Oracle Enterprise Manager 11g it delivers complete applications-to-disk management.

Oracle Enterprise Manager

Oracle Enterprise Manager Ops Center 11g gives organizations the capability to maximize the value of their investments in Oracle’s Sun systems by managing across Sun virtual machines, operating systems, firmware, servers, dusters, storage, and network fabrics. (Management of storage devices, network switches, and clusters is new in this release.) Oracle Enterprise Manager Ops Center 11g further simplifies IT operations by supporting management across heterogeneous operating system environments, including Oracle Solaris, Oracle Linux, Red Hat Linux, and SUSE Linux. It also manages Oracle’s engineered systems, Oracle Exadata and Oracle Exalogic Elastic Cloud. Continue reading Hardware Management with Oracle Enterprise Manager

Share

Exalogic Elastic Cloud Advances Datacenter Consolidation

Datacenter consolidation produces efficient, powerful, flexible, and cost-effective computing environments for enterprises in every industry, while delivering the highest quality of service for mission-critical applications. But the process of datacenter consolidation can seem an overwhelming, time-consuming, and costly undertaking. The new Oracle Exalogic Elastic Cloud is the industry’s first integrated cloud computing platform that combines hardware and software engineered by Oracle to work together for maximum performance and reliability. This offers customers a single enterprise cloud IT foundation and a scalable, fault-tolerant, and secure platform for datacenter consolidation.

Today, enterprise IT staff must provide next-generation cloud features while meeting ever-more-demanding performance and reliability requirements. Oracle Exalogic Elastic Cloud meets this challenge. The solution creates a network and virtualized computing environment to run all enterprise applications, featuring integrated and balanced storage and an optimized Java infrastructure designed for middle-tier applications such as Oracle WebLogic Server, Oracle SOA Suite, and Oracle WebCenter Suite.
Continue reading Exalogic Elastic Cloud Advances Datacenter Consolidation

Share

Oracle Cloud Resource Model API

Oracle has released the Oracle Cloud Resource Model Application Programming Interface (Oracle Cloud API) for managing cloud computing infrastructures. Oracle has also contributed the Oracle Cloud Elemental Resource Model API, a subset of the Oracle Cloud API, to the Distributed Management Task Force (DMTF) for consideration in DMTF’s proposed infrastructure-as-a- service (IaaS) cloud API standard.

The Oracle Cloud API follows the representational state transfer (REST) architecture style and uses HTTP methods to interact with resources to achieve provisioning, associating, modifying, and retiring of entities. As a full resource model, the Oracle Cloud API also includes composite entities to facilitate system deployments and management, including assemblies, deployment, and seal- ability groups.

By leveraging virtualization, clustering, and dynamic provisioning across all layers of the stack, the Oracle Cloud API lets users easily and efficiently manage their cloud-based resources to deliver better business agility and flexibility, high utilization, and reduced costs.

The Oracle Cloud Elemental Resource Model API encompasses the common elements that make up a cloud by specifying machines, storage volumes, and networks. The specification submitted to the DMTF describes how a machine can be provisioned from an image; how a volume can be attached to a machine; and how a machine can connect to a network.
“Enterprises are continuing to look to cloud computing to extend the value of their IT investments and better service users, ” says the vice president of product strategy and business development at Oracle. “With the Oracle Cloud API, Oracle is further enabling customers and partners to build and manage cloud environments — based on an open, application-aware IaaS platform— to improve service levels and the overall end-user experience.
Continue reading Oracle Cloud Resource Model API

Share

Oracle Hosting Services (Cloud API) for Cloud Computing

Oracle is strengthening its commitment to offering complete, open, and integrated hosting services cloud computing with the new Oracle Cloud Resource Model Application Programming Interface (Oracle Cloud API) for managing cloud computing infrastructures. It has also submitted the Oracle Cloud Elemental Resource Model API, a subset of the Oracle Cloud API, to the Distributed Management Task Force to be considered in a proposed infrastructure-as-a-service (IaaS) cloud API standard and to help speed the development of cloud-related standards.

Oracle Hosting Services

The Oracle Cloud Elemental Resource Model API targets machines, storage volumes, and networks, all common elements that make up a cloud hosting service. The API specifies how a machine can be provisioned from an image, how a volume can be linked to a machine, and how a machine can be connected to a network and will encourage open standardization in the industry.
Continue reading Oracle Hosting Services (Cloud API) for Cloud Computing

Share

Real-Time Supply Chain

Over the past two decades, supply chain organizations have become much more responsive to customer demand. This evolution was largely achieved by eliminating inefficiencies, integrating processes, and manufacturing products only after receipt of an order. But globalization, outsourcing, complex sourcing relationships, and a volatile economic climate have limited the competitive advantage of simply automating the supply chain. It’s not enough.

Today’s supply chain needs to sense and respond to changes in real time and use information to drive intelligent decision-making. This requires tight alignment between planning and execution, decision-making, and collaboration.
But progress is limited by poor integration, a lack of supplier orchestration, limited visibility into demand, and poor data quality.

Fortunately, solutions exist to deal with each of these issues. Operational planning processes involve evaluating demand and manufacturing capacity and developing plans and schedules to meet that demand. But existing process is largely hierarchical, serial, and static. Most companies separate planning from supply chain execution—but tighter alignment is necessary as timescales compress. Sales and operations planning (S&OP) is the primary integration point between planning and execution. As such, S&OP is in a perfect position to align the objectives of finance, sales, marketing, and operations departments. Most companies lack the tools to support S&OP, but deploying optimization tools and increasing the frequency of S&OP activity can improve performance.

Planning can also be improved by electronically populating tools with more-granular business data—including market, cus- tomer, and product information—to more accurately reflect the complexity of the marketplace.

Supply chain visibility has become increasingly complex as companies outsource manufacturing and form complex and strategic supplier relationships. Collaborative planning and process orchestration capabilities have not evolved to keep pace. Supply chain organizations must eliminate this latency to orchestrate activities across organizational boundaries. Collaboration tools and intelligent alerts can electronically share plans and schedules, track supplier commitments, and deal with exceptions. Using a service-oriented architecture (SOA), companies can develop reusable, device- independent collaboration services to address these needs. Standards-based communication protocols can then be used to bridge system gaps with suppliers.
Continue reading Real-Time Supply Chain

Share