SAS Global Forum 2009 Data Integration
Uloženo v:
| Název: | SAS Global Forum 2009 Data Integration |
|---|---|
| Autoři: | How Leverage, Oracle Bulk-load Performance |
| Přispěvatelé: | The Pennsylvania State University CiteSeerX Archives |
| Zdroj: | http://support.sas.com/resources/papers/proceedings09/099-2009.pdf. |
| Sbírka: | CiteSeerX |
| Témata: | SQL*Loader |
| Popis: | Often times, we need to load a large volume of SAS ® data into an Oracle database. Bulk-load through the SAS/ACCESS ® interface would be the first choice in many cases, but there’s a cost associated with dumping SAS data to a text file to accommodate SQL*Loader. SAS V9 further boosts the bulk load by leveraging native Oracle features on load. However, it is crucial to understand how and when to use those functions in order to optimize load for performance. Inappropriate uses of those options may not produce a desired result. Instead, it might jeopardize your load. This paper is intended to explore some of these new features and to discuss the various situations that should be taken into consideration when applying those options in Oracle bulk load. Sample code will be presented to elaborate the benefits gained by appropriate uses of those options, including OR_PARTITION |
| Druh dokumentu: | text |
| Popis souboru: | application/pdf |
| Jazyk: | English |
| Relation: | http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.176.1345 |
| Dostupnost: | http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.176.1345 http://support.sas.com/resources/papers/proceedings09/099-2009.pdf |
| Rights: | Metadata may be used without restrictions as long as the oai identifier remains attached to it. |
| Přístupové číslo: | edsbas.DEECDD5C |
| Databáze: | BASE |
Nájsť tento článok vo Web of Science | Abstrakt: | Often times, we need to load a large volume of SAS ® data into an Oracle database. Bulk-load through the SAS/ACCESS ® interface would be the first choice in many cases, but there’s a cost associated with dumping SAS data to a text file to accommodate SQL*Loader. SAS V9 further boosts the bulk load by leveraging native Oracle features on load. However, it is crucial to understand how and when to use those functions in order to optimize load for performance. Inappropriate uses of those options may not produce a desired result. Instead, it might jeopardize your load. This paper is intended to explore some of these new features and to discuss the various situations that should be taken into consideration when applying those options in Oracle bulk load. Sample code will be presented to elaborate the benefits gained by appropriate uses of those options, including OR_PARTITION |
|---|