Article Network

OpenX Advanced Reports

by Murat Yilmaz | March 2010 | Open Source

In this article series by Murat Yilmaz, author of OpenX Ad Server: Beginner's Guide, we will learn how to provide every tool to efficiently analyze the performance of websites, website zones, advertisers, campaigns, and banners. We will learn how we can get such statistics online. Then, we will investigate how we can export the data into a spreadsheet such as in Excel and analyze it with a real example.

Here, we shall learn:

  • How to view advertisers and campaign statistics
  • How to export data to Excel for further analysis
  • Types of advanced OpenX reports
  • How to retrieve advertising analysis reports using Excel

Read Reports and Statistics in OpenX Ad Server.

Read OpenX Advanced Reports in full

Optimizing Lighttpd

by Andre Bogus | July 2009 | Linux Servers Open Source

This article written by Andre Bogus will help us make Lighttpd work even faster. Before we start optimizing our Lighttpd installation, there are some things to consider such as where is Lighttpd going to run?

The most tested system with perhaps the most optimized backend is Linux. So if we need to squeeze every little request per second out of a server, it is a sure guess. In fact, apart from Linux, all systems except Windows are quite capable of delivering good performance.

Read Optimizing Lighttpd in full

Optimizing Performance

by Kristina Cutura | July 2013 | Cookbooks Enterprise Articles

This article by Kristina Cutura, author of Advertising on Google: The High Performance Cookbook, will provide tips on improving relevance, Quality Scores, and ROI. The most successful advertisers continuously refine and optimize their campaigns to keep them profitable. Your initial keywords and ads will need to be regularly updated, paused, and refined to stay on top of the latest trends in your market. Also, you'll need to adjust bids and other settings to keep on target with your goals such as a specific ad position or CPA.

Read Optimizing Performance in full

Optimizing Programs

by Rehan Zaidi | May 2013 | Cookbooks Enterprise Articles SAP

In this article by Rehan Zaidi author of SAP ABAP Advanced Cookbook, we will see recipes related to program optimization. We will look at:

  • Using transaction SAT to find problem areas

  • Creation of secondary indexes in database tables

  • Adding hints in SELECT clause

  • Secondary indexes for internal tables

  • Hashed table for single read access

  • Replacing for all entries construct with Ranges

An entire description of the topic constitutes a book by itself. However, we will see some useful and important techniques, as well as some new tools and concepts that are important for developers for program optimization. There are two main techniques—optimizing database statements, particularly SELECT statements and the optimizing ABAP code particularly internal table's access. We will see useful recipes related to both the optimization of database statements as well as internal tables.

We will start with some general rules necessary for optimization. We will start with a recipe showing the usage of transaction SAT for measuring performance of report programs. Then, we will see in detail the steps required in creating secondary indexes for database tables in order to boost performance of queries used in the concerned program. We will then see how hints may be used in programs within SELECT statements, so that a particular index may be used by the system. Finally, we will see how the FOR ALL ENTRIES construct may be replaced with ranges table. The usage of hashed internal tables as well as the new concept of secondary indexes for internal tables will be discussed in separate recipes.

For this article, I assume that the reader has basic knowledge of SELECT statements and database concepts and internal tables, as well as basic optimization techniques. For the better understanding of the information in this article, the reader should know which database would be used in his or her project and know some tricks specific to the database.

Before starting with the recipes, let us see some rules for program optimization:

  • Do not use asterisk (*) in SELECT statements. It means not to select unnecessary columns from database.

  • Do not use nested SELECT statements. Rather use subqueries or inner joins.

  • Create views when multiple tables' data is required.

  • Appropriate and complete WHERE clause conditions should be written.

  • Using FOR ALL ENTRIES within SELECT statements when multiple tables are involved. Also check that the FOR ALL ENTRIES tables are not empty. Otherwise, all records in the underlying table will be accessed that will drastically affect the performance.

  • Using Aggregate functions within SELECT clause such as AVG, MIN, MAX, COUNT(DISTINCT col), and COUNT(*) rather than calculating them yourselves in programs.

  • Avoiding SELECT or SELECT SINGLE within a loop.

  • Usage of hashed tables where a single record within the table is to be searched.

  • Usage of secondary index for internal tables.

For more examples of the previously discussed items, see the Tips and Tricks screen of transaction SAT. For doing so, you need to call transaction SAT. Then press the button on the toolbar. Using transaction

 

Read Optimizing Programs in full

Optimizing your MySQL Servers' performance using Indexes

by Daniel Schneller Udo Schwedt | June 2010 | MySQL Web Development

In this article series by Daniel Schneller and Udo Schwedt, authors of MySQL Admin Cookbook, we will cover:

  • Adding indexes to tables
  • Adding a fulltext index
  • Creating a normalized text search column
  • Removing indexes from tables
  • Estimating InnoDB index space requirements
  • Using prefix primary keys
  • Choosing InnoDB primary key columns
  • Speeding up searches for (sub)domains
  • Finding duplicate indexes
Read Optimizing your MySQL Servers' performance using Indexes in full

Oracle 11g Streams: RULES (Part 1)

by Ann L. R. McKinnell | January 2010 | Oracle

In this article series by Ann L.R. McKinnell and Eric Yen, we will learn all about rules in Oracle 11g Streams. We will discuss the rule components, how to go about creating our own rules and rules based transformations. We will also highlight some of the most important things we need to know while working with rules.

Read Oracle 11g Streams: RULES (Part 1) in full

Oracle 11g Streams: RULES (Part 2)

by Ann L. R. McKinnell | January 2010 | Oracle

In this article series by Ann L.R. McKinnell and Eric Yen, we will learn all about rules in Oracle 11g Streams. We will discuss the rule components, how to go about creating our own rules and rules based transformations. We will also highlight some of the most important things we need to know while working with rules. Read Oracle 11g Streams: RULES (Part 1) here.

Read Oracle 11g Streams: RULES (Part 2) in full

Oracle ADF Essentials – Adding Business Logic

by Sten E. Vesterli | September 2013 | Enterprise Articles Oracle Web Development

In this article, by Sten Vesterli, the author of Developing Web Applications with Oracle ADF Essentials, we'll cover the following topics:

  • Adding logic to business components

  • Adding logic to the user interface

Read Oracle ADF Essentials – Adding Business Logic in full

Oracle APEX 4.2 reporting

by Vishal Pathak | September 2013 | Enterprise Articles Oracle

In this article by Vishal Pathak, the author of Oracle APEX 4.2 Reporting discusses about the entire book.

Oracle APEX 4.2 reporting is designed to bring the best of the reporting world for intermediate as well as advanced readers. The book is designed to expose the APEX developers to other reporting solutions, inform them about the strengths of each of these, and to enable them to use these technologies in APEX. The book also assists the designers who wish to use APEX with their existing heterogeneous enterprise so that their existing code is reused and their effort in building better business intelligence systems is minimized. Let me briefly walk you through the contents of the book to inform you about the newer dimension that this book adds to the reporting universe.

Read Oracle APEX 4.2 reporting in full

Oracle APEX Books

by | November 2010 | Enterprise Articles Oracle

A quick round-up of the latest Oracle APEX books published by Packt Enterprise

Click here for a quick overview of Packt's other Oracle Books

Read Oracle APEX Books in full

Oracle APEX Plug-ins

by Marcel Van Der Plas Michel Van Zoest | December 2010 | Enterprise Articles Oracle

Oracle Application Express 4.0 is a rapid web application development tool that works with the Oracle database. Using features like Plug-ins and Dynamic Actions, APEX helps you build applications with the latest techniques in AJAX and JavaScript.

In this article by Marcel van der Plas and Michel van Zoest, authors of the book Oracle APEX 4.0 Cookbook, we will cover:

  • Creating an item type plug-in
  • Creating a region type plug-in
  • Creating a dynamic action plug-in
  • Creating a process type plug-in
Read Oracle APEX Plug-ins in full

Oracle B2B Overview

by Alan Perlovsky Krishnaprem Bhatia Scott Haaland | September 2013 | Enterprise Articles Oracle

Built on top of the Oracle Fusion Middleware (OFM), and being a tangible part of Oracle SOA Suite, Oracle B2B technology plays an important role by providing a single platform for the support of multiple B2B standards. For those who have never heard about SOA Suite, SOA Suite in a nutshell is a collection of components such as Human Task, Mediator, BPEL process manager, and so on, united by a combination of consistent tooling, a single deployment and management model, end-to-end security, and unified metadata management. It allows creating/managing web services, and orchestrates them into composite applications using Software Component Architecture (SCA). SOA Suite is the OFM component that enables the easy assembly of multiple technologies. Throughout the article, B2B integration with SOA Suite and OFM will be kept in perspective.

In this article by Krishnaprem Bhatia, Scott Haaland, and Alan Perlovsky the author of Getting Started with Oracle SOA B2B Integration: A Hands-On Tutorial. We will use this article to build the groundwork for the reader's continued journey into Oracle B2B. In the article, we will learn about the following:

  • System requirements to install Oracle B2B
  • How to install a virtual image with SOA Suite components on your machine
  • How Oracle B2B and SOA Suite leverage Service Component Architecture
  • Oracle B2B architecture
Read Oracle B2B Overview in full

Oracle BI Publisher 11g: Learning the new XPT format

by Daniela Bozdoc | October 2011 | Oracle

Oracle BI Publisher is Oracle's reporting XML-based technology, which generates highly formatted data output using multiple data sources. BIP also offers different types of Layout Templates for designing a report.

In this article by Daniela Bozdoc, author of Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting, we will look at the XPT format, which is a new template option provided by BIP. It is designed in a totally BIP-integrated layout design interface. We will also see how to use this interface to design a complete report. utm_source=ms_oracleBI11g_abr1_1011&utm_medium=content&utm_campaign=mehreen" target="_blank">Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting, we will see how to use this interface to design a complete report.

Read Oracle BI Publisher 11g: Learning the new XPT format in full

Oracle BI Publisher 11g: Learning the new XPT format

by Daniela Bozdoc | October 2011 | Oracle

Oracle BI Publisher is Oracle's reporting XML-based technology, which generates highly formatted data output using multiple data sources. BIP also offers different types of Layout Templates for designing a report.

In this article by Daniela Bozdoc, author of Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting, we will look at the XPT format, which is a new template option provided by BIP. It is designed in a totally BIP-integrated layout design interface. We will also see how to use this interface to design a complete report.

Read Oracle BI Publisher 11g: Learning the new XPT format in full

Oracle BI Publisher 11g: Working with Multiple Data Sources

by Daniela Bozdoc | October 2011 | Oracle

Oracle BI Publisher is Oracle's reporting XML-based technology, which generates highly formatted data output using multiple data sources. The Data Model editor provides tools to build queries, define the data structure, and create formulae from different data sources.

In this article by Daniela Bozdoc, author of Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting, we'll look at how we can work with multiple data sources in the BIP.

Read Oracle BI Publisher 11g: Working with Multiple Data Sources in full

Oracle Books 2010 - 2011

by | December 2010 | Enterprise Articles Oracle

During 2010 Packt Publishing really excelled with its range of Oracle books - cementing our reputation as a leading publisher for Oracle Professionals.  Packt has produced a multitude of bestsellers - and not only did we exceed in terms of quantity, but in quality, with each book released receiving a plethora of positive reviews. In 2011 Packt hope to continue this success, with over 20 new book titles currently planned for publication in a range of subjects - to receive notifications for new Oracle books are published, simply sign-up to the Packt Enterprise Newsletter via your Packt Publishing Account. Books already outlined for publication in 2011 include:

Read Oracle Books 2010 - 2011 in full

Oracle Books from Packt

by | April 2011 | Beginner's Guides Cookbooks Enterprise Articles RAW Oracle

 

A quick round-up of the latest Oracle books published by Packt

Read Oracle Books from Packt in full

Oracle BPM Suite 11gR1: Creating a BPM Application

by Heidi Buelow Manas Deb Manoj Das Meera Srinivasan Prasen Palvankar | September 2010 | Enterprise Articles Oracle

The adoption of Business Process Management (BPM) is increasingly becoming one of the most popular approaches for boosting overall organizational excellence. Built on Oracle's SOA (Service Oriented Architecture) Suite infrastructure, BPM Suite 11g provides enhanced support for application integration services and business events, Web 2.0 and E2.0 style collaborations, and high scalability. It is a full-featured, enterprise-grade BPMS that has sufficient easy-to-use features to make it also suitable for small departmental quick-win projects.

In this article by Heidi Buelow, Manoj Das, Manas Deb, Prasen Palvankar and Meera Srinivasan, authors of the book Getting Started with Oracle BPM Suite 11gR1 - A Hands-On Tutorial, we will learn to create a BPM application.

Read Oracle BPM Suite 11gR1: Creating a BPM Application in full

Oracle Business Intelligence : Getting Business Information from Data

by Yuli Vasiliev | October 2010 | Enterprise Articles Oracle

In this article by Yuli Vasiliev, author of Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting, you'll look at the basic concepts behind Business Intelligence. Proceeding with the discussion on data and information, it then moves on to describe what business questions you might need to answer, and how to find those answers from the data available at your disposal.

Listed as short bullets, here are the main topics of the article:

  • Basic introduction to data, information, and Business Intelligence
  • Answering basic business questions
  • Answering probing analytical questions
  • Asking business questions using data access tool
  • Deriving information from existing data
  • Accessing transactional and dimensional data

 

Read Oracle Business Intelligence : Getting Business Information from Data in full

Oracle Business Intelligence: Drilling Data Up and Down

by Yuli Vasiliev | October 2010 | Enterprise Articles Oracle

In Oracle Discoverer, you can also use drilling to analyze data, getting a new angle on the data you're dealing with. There are several ways supported by Discoverer in which you can accomplish drilling. For example, you can drill data down to see more detailed information for a certain product. Or, on the contrary, you may need to view data at a higher level, drilling data up from products to categories. Another example is drilling to a related item, allowing you to add a related item that is not currently in the worksheet but can be found in a folder used by the worksheet.

This article by Yuli Vasiliev, author of Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting, will walk you through the simple steps required to drill data on Discoverer worksheets. With the help of many examples, this article will introduce you to the following:

  • Navigating a Discoverer worksheet data with drilling
  • Drilling up and down
  • Drilling to a related worksheet item
  • Drilling from a worksheet graph
Read Oracle Business Intelligence: Drilling Data Up and Down in full
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software