oltp

ZDNet Resources

• sort by:
• Relevance
• Date
• Popularity

OLTP Best Practices for HP MSA2000 With Microsoft SQL Server 2008

This paper shows how to best implement the consolidation of an existing multi-server database environment into a single, easy-to-manage, and scalable instance of SQL Server 2008 based server. The consolidation is accomplished by using the HP StorageWorks MSA2000 array, the Simple SAN Connection Kit, and HP ProLiant servers. The resulting...

Tags: Hewlett-Packard Co., Microsoft SQL Server, OLTP, Microsoft Corp., Microsoft SQL Server 2008, Application Performance Management, Databases, Servers, Enterprise Software, Software, Data Management, Hardware

White papers 2009-05-01

Best Practices for Deploying SSDs in an Oracle OLTP Environment Using Dell EqualLogic Storage

This white paper demonstrates the benefit of SSD arrays with real-world applications; Dell Labs tested the capabilities of SSDs using an Online Transaction Processing OLTP workload. The database was implemented in a tiered storage model that includes the latest Dell EqualLogic PS6000 arrays with SAS HDD and SSD drives. This...

Tags: Dell Computer Corp., Oracle Corp., Environment, Storage, OLTP, Dell EqualLogic, Best Practice, SSD, Application Performance Management, Databases, Enterprise Software, Software, Data Management

White papers 2009-04-01

OLTP Performance Comparison: Solid-State Drives Vs. Hard Disk Drives

Intel Corporation Intel commissioned Principled Technologies PT to compare performance and power for online transaction processing OLTP of two types of disk drives: Intel X25-E Extreme SATA Solid-State Drives (SSD5), standard 15K RPM SAS Hard Disk Drives (HDD5). The paper focused on a single usage scenario: that of a user...

Tags: Hard Drive, Disk, Disk Drive, OLTP, Intel Corp., Principled Technologies, Application Performance Management, Databases, Enterprise Software, Software, Data Management

White papers 2009-01-01

Business Intelligence Solution for a Leading Travel Company

As a part of the company's commitment to providing great customer service, the client deployed an Online Transaction Processing OLTP database hosted on earlier versions of Microsoft SQL Server. It faced the following business challenges: inconsistent information about a customer, sales & marketing team not having the right information at...

Tags: Business Intelligence, OLTP, BLUE STAR INFOTECH, Sales Strategy, Databases, Sales, Enterprise Software, Software, Data Management

Case studies 2008-06-11

H-Store: Complete destruction of the old DBMS order?

Guest Post: Curt Monash reports from the front lines of a database revolution. Mike Stonebraker created much of the database management industry. Now he wants to blow it up. Via a project called H-Store [pdf file], he proposes to manage high-end OLTP databases entirely in...

Tags: Disk, DBMS, Brown University, OLTP, RAM, H-Store, I-Store, H-Store Team, Databases, Storage, Enterprise Software, Software, Data Management, Hardware, Curt Monash

Blog posts 2008-02-20

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

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 File System, Performance, OLTP, NetApp, Performance Management, Storage, Databases, Human Resources, Workforce Management, Hardware, Enterprise Software, Software, Data Management

White papers 2007-03-01

Shared nothing coming to open source

Shared nothing coming to open sourceGood to see open source trying to catch up.Hope they make it...Not ExactlyThe point of the story is commercial products being built on top of open source.In time I expect those commercial products will themselves be open sourced, when additional, newer, better products are built...

Tags: Databases, Business intelligence, Tools & Techniques, Storage, Data Warehousing System, Shared-nothing, GreenPlum, open source, Continuent, OLTP

Discussion threads 2006-02-27

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, 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, Oracle Corp., Performance, Environment, OLTP, Oracle9i, NetApp, Storage Area Networks (SAN), Storage, Ip storage, 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

Winter Corp. publishes the largest databases

The Winter TopTen Program identifies the world's leading database implementations based on database size, most rows/records and highest workload achieved. The program recognizes the database practitioners whose accomplishments are advancing the boundaries of database size and power. It also documents the products, platforms and architectures that are operating successfully at...

Tags: decision support system, database

Blog posts 2003-12-11

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

The Decision-Driven Warehouse - Attention Warehouse Shoppers: The Output is in the Decision

Today's Decision Support System DSS market place has about as many definitions of warehouse as vendors: Centralized warehouse, operational data store, distributed warehouse, virtual warehouse, data mart, replicated online transaction processing OLTP data. If you are currently undertaking a Data Warehousing project, you are faced with trying to select...

Tags: Data Warehouse, OLTP, Thomson Corp., Databases, Data Mining, Business Intelligence, Storage, Tools & Techniques, Enterprise Software, Software, Data Management, Hardware, Management

White papers

Additional Resources

MySQL Workbench OSS 5.2.8b1 (Mac)

MySQL Workbench enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases. It includes everything a data modeler needs for creating complex ER models, and also delivers key features for performing difficult change management and documentation...

Tags: Apple Macintosh, MySQL, Database Design, OSS, MySQL Workbench, Databases, Open Source, Enterprise Software, Software, Data Management

Software downloads 2009-11-18

Oracle's Q1: "We grew faster than SAP"

Oracle Corp., which is facing a delay of its acquisition of Sun Microsystems, today reported first quarter non-GAAP earnings of $1.5 billion, or 30 cents per share, a three-percent increase over the year-ago quarter. Revenue for the quarter was $5.1 billion, a 7 percent drop from last year. Wall Street...

Tags: Acquisition, Oracle Corp., Sun Microsystems Inc., SAP AG, Earnings, Mergers & Acquisitions, Financial Accounting, GAAP, Corporate Law, Databases, Investment, Finance, Business Operations, Enterprise Software, Software, Data Management, Sam Diaz

Blog posts 2009-09-16