Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Online Transaction Processing in SQL Server 2008
- Microsoft SQL Server 2008 provides a database platform that is optimized for today's applications, and that can scale for any size of business. It drives cost-efficiencies by dramatically reducing downtime and enabling dynamic and proactive management that significantly reduces administrative overhead. Finally, SQL Server 2008 provides a highly secure platform...
- Tags: Microsoft SQL Server 2008, Microsoft SQL Server, OLTP, Microsoft Corp., Databases, Enterprise Software, Software, Data Management
- White papers 2008-01-01
- Performance and Scalability of a Large OLTP Workload With DB2 9 for System z on Linux
- This paper demonstrates data server scalability for DB2 9 running on IBM System z with Linux. It captures the best practices for deploying IBM DB2 9 for mission critical OnLine Transaction Processing OLTP workloads in their product environment. IBM System z technologies offer a rich set of platform-deployment features ranging...
- Tags: Linux, Performance, Scalability, OLTP, IBM DB2, IBM Corp., Databases, Enterprise Software, Software, Data Management
- White papers 2007-12-01
- HP-UX 11i TCP/IP Performance
- The HP-UX Networking Stack is especially engineered and tested for optimum performance in an enterprise mission-critical environment. HP-UX 11i v3 exhibits excellent performance on NFS server performance and in the TPC-C benchmark, a measurement of intensive online transaction processing OLTP in a database environment. This white paper is intended as...
- Tags: HP-UX, Hewlett-Packard Co., Performance, Environment, Oracle11i, OLTP, HP-UX Networking Stack, Performance Management, UNIX, Operating Systems, Databases, Servers, Networking, Human Resources, Workforce Management, Software, Enterprise Software, Data Management, Hardware
- White papers 2007-08-01
- OLTP Reference Configuration Guidelines for Microsoft SQL Server 2005 on HP Integrity Servers
- Systems such as large e-commerce websites that must respond to spikes in demand from large numbers of users and a high volume of transactions will also see improvement. With these applications, large amounts of memory are required to maintain connection context for every database object opened by a user. This...
- Tags: HP Integrity, Hewlett-Packard Co., Microsoft SQL Server, OLTP, Server, Microsoft Corp., Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management
- White papers 2007-08-01
- Credit Card Company Runs Its Business With 12-Terabyte Mission Critical BI Solution
- PREMIER Bankcard, LLC PREMIER one of the largest VISA and MasterCard credit providers in the United States, needed to enhance scalability and performance for its Business Intelligence BI data warehouse and OnLine Transaction Processing OLTP databases. The company enhanced its BI infrastructure by upgrading its 12-terabyte data warehouse to Microsoft...
- Tags: Credit Card, OLTP, Business Intelligence, Databases, Pricing, Tools & Techniques, Storage, Enterprise Software, Processors, Software, Data Management, Marketing, Management, Hardware, Semiconductors, Components
- Case studies 2007-07-01
- HP-UX 64-Bit NFS Performance With Netapp Storage Using an Oracle10g Database
- This paper provides the performance-tuning recommendations for running Oracle Databases over NFS on Network Appliance storage systems in an HP-UX 11i v2 environment. A series of tests using an OnLine Transaction Processing OLTP workload and an Oracle 10.2 database were run to determine how various tuning settings affected NFS performance.
- Tags: HP-UX, Network Appliance Inc., Network File System, Performance, OLTP, NetApp, Storage, Performance Management, Databases, Hardware, Human Resources, Workforce Management, Enterprise Software, Software, Data Management
- White papers 2007-03-01
- The Business Case for Database Partitioning
- Partitioning is a useful technique that allows a large objects within a database to be split up into smaller, more manageable chunks. Traditionally it's been data warehousing customers who have gotten the most benefit from partitioning, but increasingly customers with OnLine Transaction Processing OLTP workloads have been using it, as...
- Tags: Business Case, Data Warehouse, OLTP, Databases, Storage, Business Intelligence, Enterprise Software, Software, Data Management, Hardware
- White papers 2006-04-01
- Configuring IBM TotalStorage for Oracle OLTP Applications
- This paper offers a technique for achieving highly balanced I/O across the entire ESS or other IBM TotalStorage I/O subsystem - thereby optimizing overall I/O performance. This technique requires minimal knowledge of the specific applications to be deployed or their underlying I/O characteristics and virtually eliminates the need for manual...
- Tags: Oracle Corp., I/O, OLTP, IBM TotalStorage, IBM Corp.
- White papers 2005-07-07
- Desktop Batch Processing
- Today, online transaction processing applications can downsize from mainframes to microprocessors. Commodity database systems, operating systems, and hardware came of age in 1993 - they surpassed the online transaction processing performance of proprietary solutions. There are lingering doubts about downsizing batch transaction processing applications. The doubts center on the ability...
- Tags: Desktop, Hewlett-Packard Co., OLTP, Microprocessor, Databases, Semiconductors, Processors, Enterprise Software, Software, Data Management, Hardware, Components
- White papers 2005-07-07
- Optimizing searches in an OLTP database
- Find out why Arthur Fuller decided to throw 20 years of assumptions about data singularity out the window when he discovered the effectiveness of optimizing searches in an OLTP database. Based on his experiments, he notes that the performance effects of using this approach are profound. While eating dinner...
- Tags: OLTP, Databases, Arthur Fuller, database, join, data entry, SQL Server Newsletter, TechRepublic Inc., Trigger, Lookup, Data Singularity, Storage, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2005-06-13
- Optimizing searches in an OLTP database
- Performance and RedundancyLike so many things the approach to OLTP and the approach to data warehousing are simply 2 ends of a spectrum of implementaton choices which strive for optimum performance in terms of speed and disk consumption and maintainability.These discussions about 'questioning data singularity' always suprise me - it...
- Tags: balaraman.ramiya@..., Codd, data warehouse, database, disk, disk consumption, materialized view, OLTP, performance, software
- Discussion threads 2005-06-14
- Observations Using SMT on an Oracle 9i OLTP Workload
- Simultaneous Multithreading SMT is a hardware multithreading technology which enables the execution of multiple instructions from multiple code paths, or hardware threads, in a single CPU clock cycle. POWER5 is the first IBM PowerPC processor to implement this technology, and has the capability of using either one or two hardware...
- Tags: Oracle Corp., OLTP, Oracle9i, IBM POWER5, Multi-threading, IBM Corp., Processors, Databases, Semiconductors, Hardware, Components, Enterprise Software, Software, Data Management
- White papers 2004-11-18
- Performance Study of iSCSI in an OLTP-Based Oracle 9i RAC Database Environment With NetApp iSCSI Filers
- An increasing number of applications demand high-availability combined with online scalability and bounded response times. The growing fields of electronic commerce, world-wide business, and telecommunications all require databases that are highly available for all kinds of operations at any time. This makes continuous computing availability an operational necessity in today's...
- Tags: iSCSI, Network Appliance Inc., Oracle Corp., Performance, Environment, OLTP, Downtime, Oracle9i, NetApp, Storage, Storage Area Networks (SAN), Hardware
- White papers 2004-11-11
- Oracle Partitioning - A Must for Data Warehouse and OLTP Environments
- Oracle Partitioning will enhance the manageability, performance, and availability of a wide variety of applications, for Data Warehouse as well as OLTP environments. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of...
- Tags: Data Warehouse, Oracle Corp., OLTP, Oracle Partitioning, Business Intelligence, Databases, Storage, Enterprise Software, Software, Data Management, Hardware
- White papers 2004-11-01
- VERITAS Performance Brief - Remote Mirroring Using VxVM for Metropolitan Area Disaster Recovery
- The OLTP performance measurements taken over various distances illustrate that using VERITAS Volume Manager's mirroring feature, the performance degradation caused by remote mirroring is very acceptable in both single instance and Oracle RAC environments. This paper describes the performance of remote mirroring using VERITAS Volume Manager VxVM as measured by...
- Tags: Performance, VERITAS Software Corp., OLTP, Mirroring, Disaster Recovery, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- White papers 2004-05-13
- Use data cubes for efficient data warehousing in SQL Server 2000
- In the first part of this data warehousing series, I noted the structure of database storage for a data warehouse is very different from that of a conventional online transaction processing system OLTP. The reason? OLTPs have many users and typically handle distinct data objects in any given session, whereas...
- Tags: database, OLAP, data source, Scott Robinson, Microsoft SQL Server, Microsoft SQL Server 2000, data warehouse, OLTP
- Technical articles 2004-03-26
- Learn a new data modeling paradigm for data warehouse efficiency
- A database query in an online transaction processing OLTP system application is generally going to be one of a great many reads, pulling in a small amount of data: i.e., a single record, a single table entry, a lone object. A database query in an online analytical processing OLAP system...
- Tags: OLAP, Scott Robinson, database, data warehouse, modeling, OLTP
- Technical articles 2004-03-22
- Why you should add MDX to your SQL Server toolkit
- By Mike GunderloyEven if you can’t know everything about the hundreds of languages and thousands of tools that might come in handy on future projects, you can know enough to help you choose tools when you need them. Take the Multi-Dimensional Expression MDX language supported by Microsoft SQL Server Analysis...
- Tags: Data mining, Databases, Lark Group, Inc., server, OLAP, cube, MDX, database, OLTP, Microsoft SQL Server
- Technical articles 2003-07-21
- Data Warehouse Design Considerations
- Data warehousing is one of the more powerful tools available to support a business enterprise. Learn how to design and implement a data warehouse database with Microsoft SQL Server 2000. Data warehouses support business decisions by collecting, consolidating, and organizing data for reporting and analysis with tools...
- Tags: Data Warehouse, OLTP, Business Intelligence, Storage, Databases, Enterprise Software, Software, Data Management, Hardware
- White papers 2001-12-12
- Thinking dimensionally aids business intelligence design and use
- An efficient business intelligence system requires a different approach than the one you use for online transaction processing. In this article, Dan Pratte outlines the dimensional data model and its precise and flexible analysis of data.At first glance, it seems logical to look to your online transaction processing OLTP systems—those...
- Tags: Pricing, Tools & Techniques, Databases, Storage, business intelligence system, Dan Pratte, business intelligence, OLTP, data model, dimensional data model, dimensional model
- Technical articles 2001-04-16
