| Title | Date Added | Company | |
|---|---|---|---|
![]() |
Managing ETL Processes | 2008-08-30 | Association for Computing Machinery |
| ETL tools allow the definition of sometimes complex processes to extract, transform, and load heterogeneous data into a data warehouse or to perform other data migration tasks. In larger organizations many ETL processes of different data integration projects are accumulated. Such processes can encompass common sub-processes, shared data sources and targets, and same or similar operations. However, there is no common method or approach to systematically manage such ETL processes. The paper proposes the high-level management of such processes as a generic approach to enable their flexible re-use, optimization, and rapid development. To this end the paper introduces a set of basic operators on ETL processes, such as merge or invert, and motivate their use in several scenarios.
Tags: Data Tools |
|||
![]() |
State of the Semantic Web: Know Where to Look | 2008-08-27 | JupiterMedia |
| There is no question that the web is an unprecedented success. It is the single most adventurous and useful platform for information exchange ever conceived and built. The architectural choices that went into its design have lent it scalability, flexibility, and the ability to grow into new business models, application-level technologies, and varied uses. Currently, the web is designed for use by people; and not by software. Visitors to a site such as Amazon - that provides book and movie ratings, information about available used copies, related products, and so forth - can easily parse the content visually. It is much more difficult for software to act on a visitor's behalf, because the information is tied up in the presentation structure.
Tags: Internet and Web |
|||
![]() |
Know Your Callers - Whitepaper | 2008-08-27 | Cadence Data Soft |
| Communication is backbone of one's day to day lives. News paper, flyer, telephone, cellular phones, emails, SMS etc. are all part of this backbone. The most recent enhancements to all of these are using "Targeted" approach. The author want to receive right information at right time and Targeted approach is a step towards that, however there is long way to go before this technology matures to strike a balance between the privacy and information that people are willing to make public, explicitly or implied. Biggest challenge is posed by the fact that the privacy requirements of every individual is going to be different and will be dynamic in nature, so one size is never going to fit all.
Tags: Data Tools |
|||
![]() |
Medical Electronics Heart Pump Monitor | 2008-07-18 | |
| Orchid Technologies' second generation heart pump monitor is designed for critical care of artificial heart pump recipients. Real-time data capture, analysis, and display of multi-channel ECG patient data is required to provide doctors with critical patient status. Embedded x86 performance in a highly integrated, low power package is achieved with AMD's SC3200 processor. The GEODE; a powerful personal computer on a chip, brings a wealth of existing x86 software to bear, easing end-user GUI application development.
Tags: Data Tools, Server Hardware |
|||
![]() |
Building ETL Processes for Business Intelligence Solutions Built on Microsoft SQL Server | 2008-07-10 | CA (Computer Associates) |
| One can create the greatest data warehouse in the world, but if can't put data into it, it is completely useless. Designing and building solid ETL processes is critical to the success of data warehouse. If one takes time and design a flexible ETL process one will find that life becomes much easier later when one acquires a new data source. While not as flashy, ETL is just as important as the other aspects of Business Intelligence solution, if want a good BI solution, then need to take the time to develop a good ETL process.
Tags: Data Infrastructure, Data Tools |
|||
![]() |
KAPTIVE - Knowledge Acquisition, Propagation & Transfer Initiative | 2008-07-08 | |
| InterGlobe Technologies (IGT) believes that a strong knowledge acquisition & transfer approach is the essential for successfully understanding their client's requirements and converting those requirements into a successful outsourcing model, thus leading to a stable and mature IT operation closely aligned with the customer's business goals. The authors approach has evolved from years of practice, and continues to be refined further with each and every engagement. KAPTIVE allows IGT to thoroughly understand and agree on the client's business and technical needs, as well as the scope and expectations of the engagement.
Tags: Data Tools |
|||
![]() |
Volkswagen Servicos Financeiros Modernizes Data Warehouse and Reduces Report-Generation Time | 2008-07-01 | Oracle |
| Volkswagen Servicos Financeiros wanted to build a data warehouse for risk and customer-buying-behavior analysis as well as regional trends tracking and provide managers with better quality data analysis in order to improve decision making Make information available in real time. The challenge was to improve process management and services. Volkswagen Servicos Financeiros worked with Oracle Partner Discover Technology to implement Oracle Database Enterprise Edition and other infrastructure software to improve the transactional environment and built a data warehouse with Oracle Warehouse Builder Data Quality and Oracle Warehouse Builder ETL to apply new levels of intelligence to the business.
Tags: Data Infrastructure, Data Tools |
|||
![]() |
Integrated Intelligence Drives Performance for Crown Prosecution Service | 2008-07-01 | Oracle |
| Crown Prosecution Service (CPS) wanted to collate and analyze case load, payroll, and performance data from multiple sources to optimize budget allocation and workforce planning across the CPS's 42 geographical areas. The challenge was to streamline compiling of annual reports to the treasury, attorney general, and parliament and gain rapid access to up-to-date statistics to respond to government inquiries. CPS built a CPS Corporate Information System (CIS) to measure prosecution success ratios against costs incurred for magistrate and crown courts using Oracle's business intelligence tools and used CIS to extract data from financial, manpower, and payroll systems to analyze the comparative performance of each geographic area and provide a single near real-time overview.
Tags: Data Tools |
|||
![]() |
Betting on the Dice: Giving Customers What They Want With the Help of Analytics | 2008-07-01 | SAS Institute |
| Established in 1980, Resorts World Berhad (RWB) is one of the largest listed companies in Malaysia with a market capitalization of about MYR 21.87 billion (US$6.28 billion). The challenge was to obtain timely, relevant and consolidated information to gain new customer insights in order to create better marketing campaigns and optimize their resources. RWB deployed SAS Enterprise BI Server, SAS Enterprise Miner and SAS Data Integration/ETL.
Tags: Data Tools, Data Tools |
|||
![]() |
LEO Pharma Adopts Electronic Data Capture to Streamline Clinical Trials and Regulatory Review | 2008-07-01 | Oracle |
| It takes a period of time for LEO Pharma to get access to the data with paper forms. The forms have to be picked up and shipped back to the company; and the data needs to be keyed into the clinical data management system. LEO Pharma designs and manages its clinical trials using Oracle Clinical, an application the company installed in 2002. The move helped increase productivity and data quality, but the company still faced delays getting data into the system in the first place - in large part because LEO still used paper Case Report Forms (CRFs) to record data at each trial site. To minimize such delays, the company recently moved to Oracle's site-based Electronic Data Capture (EDC) system - Oracle Remote Data Capture (RDC) Onsite.
Tags: Data Tools |
The Roots for a Greener World
Discover Hitachi's Environmental Vision 2025 and featured Eco-Products
The Desktop Virtualization Revolution is here!
Find our more with Citrix Simplicity is Power
Master in Organisational Leadership
Part-time masters program from Monash University. Find out more.
Lack of visibility into network issues and performance?
Find out today. Download SolarWinds FREE 30-Day Trial Software here.
IT Salary & Skills Report 2009
Join activeTechPros for free access to the report