Data Infrastructure - IT Library : ZDNet Asia

White Papers

Case Studies

Vendor Webcast

Show all content

Title Date Added Company

Better Hashing in SAS 9.2 2008-03-11 SAS Institute

The DATA step hash object is one of the most versatile new features of Base SAS programming. Since its introduction in SAS 9, the paper has numerous accounts from users where the hash object has drastically reduced data processing time for complex data join operations. Based on feedback, the paper has further enhanced the hash object. For SAS 9.2, the paper introduces the ability to store duplicate keys in a hash object and have added a find frequency counter. This paper leverages the duplicate key capability to implement true SQL-like joins as well as partial-key look-ups. In addition, the paper explores uses for the find frequency counter. Go beyond SAS 9.1 and see why hashing in SAS 9.2 improves how one processes data.

Tags: Programming Languages, Database Management

Managing Large Data With SAS SPD Server 2008-03-10 SAS Institute

This paper provides the concepts behind demonstrations of how one can enhance query performance when one uses the SAS SPD Server to manage large data tables. This paper does not cover the main concepts for Dynamic Clusters or Parallel Join. This paper focuses on managing data within standard SAS Scalable Performance Data Server (SPD Server) tables, and therefore Dynamic Cluster tables, to enhance data querying. There are three common types of queries for which data within a table can be optimized: ordered processing, subsetting, and a hybrid of ordered processing and subsetting.

Tags: Application Servers, Parallel Processing

Small Improvements Causing Substantial Savings - Forecasting Intermittent Demand Data Using SAS Forecast Server 2008-03-10 SAS Institute

Businesses require accurate forecasts of time series data that is not continuous. Often, time series data is intermittent (discontinuous or interrupted). Intermittent time series data points are mostly zero (the base value), with occasional departures from the base value. Intermittent time series are common in business and economic data. For example, at progressively lower levels of data disaggregation (larger frequency, smaller geography, or both), the time series data is often intermittent. The most commonly used forecasting techniques are continuous time series methods such as Exponential Smoothing Methods (ESM). Continuous methods are meant to forecast the future values with respect to future time periods.

Tags: Data Mining - Analysis

Directory Deployment Planning Checklist 2008-03-05 Isode

When planning a directory deployment, there are a lot of things to take into account. This paper has been written to help those planning a directory deployment, and in particular Isode partners working on directory deployments for their customers and prospects. As the specifics of the approach taken will depend on the deployment requirements this paper does not attempt to be prescriptive, there are no "Right answers". Instead, a series of questions that (may) need to be asked are listed.

MSDN Webcast: 24 Hours of SQL Server 2008: Reach Your Data With SQL Server 2008 (Level 100) 2008-03-05 Microsoft Tips

The presenter of this webcast looks at how Container Overseas Shipping Operation (Contoso) LTD can increase methods of accessing data without the need for complex connections and filters on firewalls. The presenter concentrates on Service Broker and ADO.NET Data Services in this webcast.

Tags: Application Servers, Database Management

Veritas NetBackup 6.5: Unlocking the Power of Disk 2008-03-04 Symantec

The release of NetBackup 6.5 includes many new features and several new enterprise disk options - that improve the speed, management and cost of disk-based backup and recovery. This webcast will highlight these new options: Flexible Disk Option, Open Storage Option, Continuous Data Protection and show how these new options allow customers to choose between appliance-based and heterogeneous storage-based approaches to disk-based backup. The presenter will uncover the architecture behind these new disk features and show how they help to take advantage of disk-based technologies for backup.

Tags: Storage Management, Data Recovery - Security

Blade servers: Data centre power and cooling issues 2008-03-03 IBM

IT managers need to reduce power consumption in IT infrastructure. Blades servers which provide a more efficient form of computing than traditional servers could provide an answer.
Read this white paper to see how technology leaders can reduce power consumption through blades, and what type of power and cooling efficiencies they provide.

Tags: Server Consolidation

Kraft Group Case Study 2008-03-03 amerivault

The Kraft Group is a diverse, family-operated holding company with interests in forest products, paper and packaging, sports and entertainment, real estate development, and private equity investing. With the independent operating units, offsite protection of data was an indefinite, manual process that the company sought to change. The company wanted to improve reliability of data backup and recovery with one standardized solution for the Kraft family of businesses. AmeriVault's online backup service was chosen.

Tags: Storage Management, Data Recovery - Security

On BULK COLLECT 2008-03-01 Oracle

The most important thing to remember when one learns about and start to take advantage of features such as BULK COLLECT is that there is no free lunch. There is almost always a trade-off to be made somewhere. The tradeoff with BULK COLLECT, like so many other performance-enhancing features, is "Run faster but consume more memory." Specifically, memory for collections is stored in the Program Global Area (PGA), not the System Global Area (SGA). SGA memory is shared by all sessions connected to Oracle Database, but PGA memory is allocated for each session.

Declarative Data Filtering 2008-03-01 Oracle

In Oracle JDeveloper, one can specify easy-to-understand names for the columns defined in the SQL query encapsulated by a view object. For example, the Managers view object in the starter workspace queries the EMP table. Although the query includes the JOB column, the corresponding view object attribute is named CompanyRole. Previous versions of Oracle JDeveloper made it possible to manually enter custom WHERE and ORDER BY clauses in a view object query, and they included an "Expert mode" that gave full control over the entire SQL statement. Although these modes are both still supported, they require one to remember the names of the underlying database columns - a tedious requirement if one is not intimately familiar with the schema.

Tags: Application Development

Jump to 1 2 3 4 5 6 7 8 9 [10]

Title	Date Added	Company
Better Hashing in SAS 9.2	2008-03-11	SAS Institute
The DATA step hash object is one of the most versatile new features of Base SAS programming. Since its introduction in SAS 9, the paper has numerous accounts from users where the hash object has drastically reduced data processing time for complex data join operations. Based on feedback, the paper has further enhanced the hash object. For SAS 9.2, the paper introduces the ability to store duplicate keys in a hash object and have added a find frequency counter. This paper leverages the duplicate key capability to implement true SQL-like joins as well as partial-key look-ups. In addition, the paper explores uses for the find frequency counter. Go beyond SAS 9.1 and see why hashing in SAS 9.2 improves how one processes data. Tags: Programming Languages, Database Management
Managing Large Data With SAS SPD Server	2008-03-10	SAS Institute
This paper provides the concepts behind demonstrations of how one can enhance query performance when one uses the SAS SPD Server to manage large data tables. This paper does not cover the main concepts for Dynamic Clusters or Parallel Join. This paper focuses on managing data within standard SAS Scalable Performance Data Server (SPD Server) tables, and therefore Dynamic Cluster tables, to enhance data querying. There are three common types of queries for which data within a table can be optimized: ordered processing, subsetting, and a hybrid of ordered processing and subsetting. Tags: Application Servers, Parallel Processing
Small Improvements Causing Substantial Savings - Forecasting Intermittent Demand Data Using SAS Forecast Server	2008-03-10	SAS Institute
Businesses require accurate forecasts of time series data that is not continuous. Often, time series data is intermittent (discontinuous or interrupted). Intermittent time series data points are mostly zero (the base value), with occasional departures from the base value. Intermittent time series are common in business and economic data. For example, at progressively lower levels of data disaggregation (larger frequency, smaller geography, or both), the time series data is often intermittent. The most commonly used forecasting techniques are continuous time series methods such as Exponential Smoothing Methods (ESM). Continuous methods are meant to forecast the future values with respect to future time periods. Tags: Data Mining - Analysis
Directory Deployment Planning Checklist	2008-03-05	Isode
When planning a directory deployment, there are a lot of things to take into account. This paper has been written to help those planning a directory deployment, and in particular Isode partners working on directory deployments for their customers and prospects. As the specifics of the approach taken will depend on the deployment requirements this paper does not attempt to be prescriptive, there are no "Right answers". Instead, a series of questions that (may) need to be asked are listed.
MSDN Webcast: 24 Hours of SQL Server 2008: Reach Your Data With SQL Server 2008 (Level 100)	2008-03-05	Microsoft Tips
The presenter of this webcast looks at how Container Overseas Shipping Operation (Contoso) LTD can increase methods of accessing data without the need for complex connections and filters on firewalls. The presenter concentrates on Service Broker and ADO.NET Data Services in this webcast. Tags: Application Servers, Database Management
Veritas NetBackup 6.5: Unlocking the Power of Disk	2008-03-04	Symantec
The release of NetBackup 6.5 includes many new features and several new enterprise disk options - that improve the speed, management and cost of disk-based backup and recovery. This webcast will highlight these new options: Flexible Disk Option, Open Storage Option, Continuous Data Protection and show how these new options allow customers to choose between appliance-based and heterogeneous storage-based approaches to disk-based backup. The presenter will uncover the architecture behind these new disk features and show how they help to take advantage of disk-based technologies for backup. Tags: Storage Management, Data Recovery - Security
Blade servers: Data centre power and cooling issues	2008-03-03	IBM
IT managers need to reduce power consumption in IT infrastructure. Blades servers which provide a more efficient form of computing than traditional servers could provide an answer. Read this white paper to see how technology leaders can reduce power consumption through blades, and what type of power and cooling efficiencies they provide. Tags: Server Consolidation
Kraft Group Case Study	2008-03-03	amerivault
The Kraft Group is a diverse, family-operated holding company with interests in forest products, paper and packaging, sports and entertainment, real estate development, and private equity investing. With the independent operating units, offsite protection of data was an indefinite, manual process that the company sought to change. The company wanted to improve reliability of data backup and recovery with one standardized solution for the Kraft family of businesses. AmeriVault's online backup service was chosen. Tags: Storage Management, Data Recovery - Security
On BULK COLLECT	2008-03-01	Oracle
The most important thing to remember when one learns about and start to take advantage of features such as BULK COLLECT is that there is no free lunch. There is almost always a trade-off to be made somewhere. The tradeoff with BULK COLLECT, like so many other performance-enhancing features, is "Run faster but consume more memory." Specifically, memory for collections is stored in the Program Global Area (PGA), not the System Global Area (SGA). SGA memory is shared by all sessions connected to Oracle Database, but PGA memory is allocated for each session.
Declarative Data Filtering	2008-03-01	Oracle
In Oracle JDeveloper, one can specify easy-to-understand names for the columns defined in the SQL query encapsulated by a view object. For example, the Managers view object in the starter workspace queries the EMP table. Although the query includes the JOB column, the corresponding view object attribute is named CompanyRole. Previous versions of Oracle JDeveloper made it possible to manually enter custom WHERE and ORDER BY clauses in a view object query, and they included an "Expert mode" that gave full control over the entire SQL statement. Although these modes are both still supported, they require one to remember the names of the underlying database columns - a tedious requirement if one is not intimately familiar with the schema. Tags: Application Development