|
| |
| | DBMS - April 1998 - Parallel Processing for OLTP |
 | | To scale an OLTP application of this type with a shared-nothing database, the lookup table must be partitioned in the same way as the transaction table to allow lookups to be performed without having to access data stored on another node. | | | OLTP systems are almost always changing, so database backups must be taken regularly to reduce recovering time if a serious error occurs. | | | An important OLTP enhancement that DB2 Universal Database and Informix have implemented is the ability to eliminate the "coordinator process/worker process" architecture if the optimizer knows that the target row is located on the same instance as the application connection. |
|
http://www.dbmsmag.com/9804d15.html
(3277 words)
|
|
| |
| | DBMS - July 1998 - Benchmarking OLTP Systems |
| | One of the first benchmarks to measure the performance of a machine for use in an OLTP environment was the TPC-A benchmark. | | | This is not to say that DSS benchmarks do not stress systems, but at very high user loads OLTP environments stress every component of the operating environment, including the network, I/O subsystem, operating system, and the stability of the database software. | | | There are several industry-standard benchmarks that you can use to evaluate the OLTP performance of a particular system. |
|
http://www.dbmsmag.com/9807d15.html
(3323 words)
|
|
| |
| | DB2 Tuning Tips for OLTP Applications |
| | For this reason, new OLTP software uses client/server processing and brokering software that allows transactions to run on different computer platforms in a network. | | | In this situation, the application will wait for a lock (if one is not available at the time of the request) until either the lock is granted or until a deadlock occurs. | | | There should be at least 5 to 10 disks per CPU for a moderate workload, and 20 disks for a high-I/O OLTP workload. |
|
http://www7b.boulder.ibm.com/dmdd/library/techarticle/anshum/0107anshum.html
(7586 words)
|
|
| |
| | OLTP - Wikipedia, the free encyclopedia |
| | In large applications, efficient OLTP may depend on sophisticated transaction management software (such as CICS) and/or database optimization tactics to facilitate the processing of large numbers of concurrent updates to an OLTP-oriented database. | | | For even more demanding decentralized database systems, OLTP brokering programs can distribute transaction processing among multiple computers on a network. | | | OLTP (Online Transaction Processing) is a form of transaction processing conducted via computer network. |
|
http://en.wikipedia.org/wiki/OLTP
(156 words)
|
|
| |
| | Complex Processing (OLCP), Analytical Processing (OLAP), and Transactions (OLTP) |
| | A system optimized for OLTP will support a high volume of users running short-lived queries. | | | One reason to differentiate between OLTP, and systems that support data warehousing and OLAP, is to assist in the proper selection of hardware and software. | | | They don't forecast much growth in the OLTP market, but they do expect significant growth in the number of OLAP and onlien complex processing (OLCP) users. |
|
http://ourworld.compuserve.com/homepages/Ken_North/complex.htm
(2124 words)
|
|
| |
| | The OLTP ASEM Expands Coverage of Intel Server Vendors |
| | Unisys was evaluated on the basis of its Cellular Multiprocessing (CMP) technology, which supports configurations of up to 32 Intel processors. | | | In many cases, enterprises are also looking to evaluate Intel server vendors — this evaluation may be in addition to an overall platform study, or a separate study. | | | Figure 1 shows the vendors included in the OLTP Intel unweighted rankings section of this model revision. |
|
http://www.gartner.com/reprints/unisys/95896.html
(868 words)
|
|
| |
| | Gartner OLTP numbers rank winners in server arena The Register |
| | What the latest OLTP platform study shows is that, at least as far as technologies are concerned, the venerable IBM mainframe is still the system to beat - but the high-end Unix servers are catching up. | | | Gartner has been publishing this short OLTP platform evaluation report internally since 1999 and uses it as an adjunct to its famous magic quadrant visual rankings, which the company uses to compare the technologies that it tracks. | | | Gartner also notes that Unix servers from Sun Microsystems Inc and Fujitsu Siemens are compared using Solaris 8 rather than the more advanced Solaris 9 because Solaris 9's portfolio of applications is still immature and, even though Solaris 9 has lots of advanced features, these have not been tested widely in the field as yet. |
|
http://www.theregister.co.uk/content/53/27763.html
(1034 words)
|
|
| |
| | SurfWax: News, Reviews and Articles On OLTP |
| | The Top Ten program shows the largest databases for OLTP and DSS (Decision Support Systems) for both Windows and UNIX platforms (it nominally has an "all" category as well, but effectively this is the same as the UNIX grouping). | | | Telecoms are a classic example of that, where there are certain environments where those systems have been built and they'll continue to be supported and maintained for a long period of time. | | | And by 2006, Weiss predicts that Linux "will meet the performance requirements of 80 percent to 90 percent of single OLTP online transaction processing application requirements." And its competition for this gold standard of data-center computing won't be Windows; it's Unix. |
|
http://databases.surfwax.com/files/OLTP.html
(3187 words)
|
|
| |
| | Tik-76.115 Final report - OLTP |
| | The purpose of project OLTP was to produce a software business simulator game to be used as a course assignment for a software business course (T-76.640) at Helsinki University of Technology. | | | The need for this kind of simulator was obvious because the available business simulators are not suited to modeling software business specifically. |
|
http://www.soberit.hut.fi/T-76.115/01-02/palautukset/groups/OLTP/lu/finalreport.html
(3548 words)
|
|
| |
| | Re: OLTP transactions [Fri, 23 Jul 1999] |
| | Like any OLTP environment, it's important to tightly manage your environment >if you have any hope of providing predictable response times. | | | Some Teradata customers have used the user priorities in prior version to better allocate the resources of the system to OLTP activity. | | | With the introduction of V2R3, the prioritization mechanism (Priority Scheduler) appears to be greatly enhanced, allowing for the creation of performance groups, assigned priority weightings, etc. Based on the documentation, it appears the this feature could help partition the eradata >environment and dedicate resources to particular system activity, like OLTP. |
|
http://www.teradataforum.com/teradata/19990723_160107.htm
(131 words)
|
|
| |
| | IBM Redbooks DB2 UDB ESE V8 non-DPF Performance Guide for High Performance OLTP and BI |
| | We provide an overview of the architecture of a DB2 UDB V8 non-DPF environment from a performance perspective, and describe key performance drivers in OLTP, BI, and mixed workload environments. | | | This IBM Redbook provides detailed information on implementing high performance OLTP and BI applications in DB2 UDB ESE V8 environments involving AIX and Windows 2000 platforms. | | | Finally, we discuss some of the commonly encountered problems faced by a DBA when managing a DB2 environment, and describe techniques for problem diagnosis using typical problem scenarios. |
|
http://publib-b.boulder.ibm.com/redbooks.nsf/RedbookAbstracts/sg246432.html
(658 words)
|
|
| |
| | TPC-C |
| | The TPC-C benchmark continues to be a popular yardstick for comparing OLTP performance on various hardware and software configurations. | | | TPC-C is more complex than previous OLTP benchmarks such as TPC-A because of its multiple transaction types, more complex database and overall execution structure. | | | The TPC-C has continued to evolve its benchmarks to remain as representative of current practice as possible. |
|
http://www.tpc.org/tpcc
(477 words)
|
|
| |
| | Linux 2.6 Performance Test Using OSDL-DBT-2 on SAPDB and STP |
| | There are positives and negatives to this approach: it is a good thing for OLTP workloads (characterized by random updates of one tuple) and probably not as good for DSS workloads (which often needs to scan the table data and might prefer to have table data organized sequentially on disk). | | | A table in SAPDB is really a clustered index, that is, a primary key B-tree index with the table data in the leaf nodes of the index. | | | The cached version becomes mostly cached after a warm up period, while the non-cached version does not. |
|
http://developer.osdl.org/maryedie/STUDY1203/Study_DBT2_SAPDB.html
(3083 words)
|
|
| |
| | OLTP vs OLAP |
| | Operational data; OLTPs are the original source of the data | | | Consolidation data; OLAP data comes from the various OLTP databases | | | Typically denormalized with fewer tables; use of star and/or snowflake schemas |
|
http://members.tripod.com/atars/cj/sqloltpolap.html
(172 words)
|
|
| |
| | Administrative Data Reporting Environments at U-M MAIS University of Michigan |
| | Copy of OLTP for all data areas except Development (DAC System). | | | In addition to these environments, all of the human resources data and student data stored in HEProd are accessible on the Web through Wolverine Access. | | | Provides access to report data outside of OLTP, to optimize processing performance in OLTP. |
|
http://www.mais.umich.edu/reporting/environments.html
(307 words)
|
|
| |
| | OLTP access |
| | If I move the OLTP database (SQL Server 2000) onto the machine running the OLAP it works fine. | | | Access can use ODBC to link to tables in the OLTP so how come the OLAP is so frail? | | | > If I move the OLTP database (SQL Server 2000) onto the machine running the > OLAP it works fine. |
|
http://www.webservertalk.com/message961275.html
(705 words)
|
|
| |
| | Creating an Oracle Database |
| | Descriptions of the types of databases created by DBCA (OLTP, Warehousing, and Multipurpose) are presented in "Identifying Your Database Environment". | | | Oracle Database Configuration Assistant guides you in the creation of a database fully customized to match the environment (OLTP, Warehousing, or Multipurpose) and database configuration mode (dedicated server or multi-threaded server) you select. | | | Review these selections and identify the database that best matches your database requirements and database creation expertise: |
|
http://www.usd.edu/oracle/doc/server.817/a76956/create.htm
(5337 words)
|
|
| |
| | Branch Behavior of a Commercial OLTP Workload on Intel IA32 Processors |
| | Branch Behavior of a Commercial OLTP Workload on Intel IA32 Processors | | | Based on further analysis, we propose and evaluate an enhanced return address predictor, which reduces return address mispredictions in ODB by 40%. | | | "Branch Behavior of a Commercial OLTP Workload on Intel IA32 Processors," iccd, p. |
|
http://csdl.computer.org/comp/proceedings/iccd/2002/1700/00/17000242abs.htm
(256 words)
|
|
| |
| | Choosing a database for use in an OLTP environment |
| | Choosing a database for use in an OLTP environment | | | IBM Rational: Integrated development tools help you and your team create better software, faster. | | | What parameters should a project team use to decide which database to use in an OLTP environment? |
|
http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci976676,00.html
(500 words)
|
|
| |
| | 2 OLTP and Query-Intensive Applications |
| | Most DBMSs are optimized for the OLTP usage. | | | Such systems in typical case execute big number of queries, yet each of them is relatively simple. | | | DBMSs were at first used mostly for on-line transactional processing (OLTP) applications. |
|
http://homepages.cwi.nl/~marcin/thesis/node6.html
(159 words)
|
|
| |
| | OLTP Jobs, Average Salary & Contractor Rates for Online Transaction Processing (OLTP) Skills |
| | Jobs citing OLTP are compared to all those in the category of Database & Business Intelligence. | | | This section looks at the demand for OLTP knowledge and experience with a comparison to our Database & Business Intelligence category. | | | The process whereby day-to-day transactional data is held in a repository that contains the operational data for the business. |
|
http://www.itjobswatch.co.uk/skills_and_rates/oltp.do
(351 words)
|
|
| |
| | Tech Report: TR-90.8: Guardian 90: A Distributed |
| | Guardian 90: A Distributed Operating System Optimized Simultaneously for High-Performance OLTP, Parallelized Batch/Query and Mixed Workloads |
|
http://www.hpl.external.hp.com/techreports/tandem/TR-90.8.html
(16 words)
|
|
| |
| | TDAN Reiter Service Level Analysis |
| | Service level and SQL monitoring systems based upon a network sniffer architecture supports these business requirements with ZERO performance impact, no middleware, no client agents, a straight forward installation and a low ongoing cost of operation. | | | Additional information is available on ZERO impact end-user service level and SQL monitoring at www.sqlpower.com. | | | Mr Randall Reiter is the President of Sql Power Tools Inc. Sql Power Tools, Inc. is an industry leader in ZERO impact end-user service level, SQL performance, top N SQL, and data usage analysis products for eCommerce, DSS and OLTP database environments. |
|
http://www.tdan.com/sponsored002.htm
(795 words)
|
|
| |
| | IBM's DB2 makes its mark with improved OLTP performance - Computerworld |
| | Earlier versions of DB2 for MVS 4.2 ``don't handle big enough tables'' and can't run 7 days by 24 hours,'' said Michael Siegal, president of Life Cycle Consulting, Inc., a data warehousing consultancy in Torrance, Calif. ``From what IBM says, the new version can handle really big databases up to 1T byte per table. | | | One user at the annual DB2 user group conference in Dallas last week said the new version of the relational database management system comes close to if not even with the robust OLTP performance of its venerable predecessor, IBM's IMS hierarchical database. | | | Keep up on technology news and trends with our free e-mail newsletters! |
|
http://www.computerworld.com/news/1996/story/0,11280,5785,00.html
(1062 words)
|
|
| |
| | 9 Gateway Configuration Using SNA Communication Protocol |
| | The procedure for verifying your OLTP configuration varies, depending on which OLTP you are using and depending upon which platform the OLTP is running on. | | | Refer to "Implementing Commit-Confirm (SNA Only)" in the Oracle Procedural Gateway for APPC User's Guide for detailed information about commit-confirm. | | | Both of these subroutines are written in 370 assembler to eliminate any inter-language interface complexities and compiler dependencies. |
|
http://oracledocs.shu.ac.uk/local/personalOracleInstallation/w2k-10g/gateways.101/b13694/ch9.htm
(4609 words)
|
|
| |
| | transaction processing definition of transaction processing in computing dictionary - by the Free Online Dictionary, ... |
| | Also called "online transaction processing" (OLTP), the OLTP market is a demanding one, often requiring 24x7 operation and the most reliable computers and networks. | | | A manual example of transaction processing would be that every time you purchased an item, you added the amount paid to a running total. | | | At any given moment, someone may need an inventory balance, an account balance or the total current value of a financial portfolio. |
|
http://computing-dictionary.thefreedictionary.com/transaction+processing
(219 words)
|
|
| |
| | Focal Point Software, Inc. Focal Point Software, Inc. - OLTP and DCE Monitoring and Management - Quick Contact, ... |
| | Focal Point Software, Inc. Focal Point Software, Inc. - OLTP and DCE Monitoring and Management - Quick Contact, Profile, and Connnection Page in BizWiz - Focal Point Software, Inc. - OLTP and DCE Monitoring and Management | | | Focal Point Software Inc. provides the InfoWatch/TP and InfoWatch/SYS programs to monitor and manage TUXEDO, Encina, and DCE. | | | Focal Point Software, Inc. - OLTP and DCE Monitoring and Management |
|
http://www.bizwiz.com/quickprofilepages/fo/focalpointsoftware.htm
(228 words)
|
|
| |
| | Software Solutions Catalog, Software Lösungen / Software Katalog von Fujitsu Siemens Computers |
| | ADABAS, BS2000, Datenbank, Datenbank-Management, Datenbankwerkzeug, DBMS, DBMS/OLTP, Legacy-Applikationen/-Datenbanken, Linux, NATURAL, OLTP, Solaris, SPARC64 | | | BI (Business Intelligence), Data Warehouse, Datamart, DBMS/OLTP, Decision Support, OLAP, OLTP | | | High-performance database engine featuring portability, small footprint, source code, and royalty-free distribution. |
|
http://solutions.fujitsu-siemens.com/software-catalog/main_search.php?id=100000698&lang=de&platform=all&search_id=60&intern=
(366 words)
|
|
| |
| | SAP Query: Assignment to a User Group (SAP Library - Customer Content in the OLTP System) |
| | A query is automatically generated by the system. | | | If you want to extract your data from an InfoSet, the InfoSet must be assigned to a user group before the DataSource can be generated. | | | SAP Query: Assignment to a User Group (SAP Library - Customer Content in the OLTP System) |
|
http://help.sap.com/saphelp_nw04/helpdata/en/10/1c8c3e94243446e10000000a114084/content.htm
(217 words)
|
|
| |
| | DATA MANAGEMENT STRATEGIES - Data modeling — from OLTP to dimensional |
| | The first step is to determine the data that is purely operation in nature. | | | There should be some discussion on whether these flags are used to create new data, but for the most part, you want to dump the purely operational data. | | | So using our OLTP schema in Figure 1, Figure 2 is what would happen after purely operational data is removed. |
|
http://www.itworld.com/nl/db_mgr/05122004
(413 words)
|
|
| |
| | HP Press Release: Hewlett-Packard Earns No. 1 Unix Server Spot in Server Evaluation Model by Leading Industry Analyst ... |
| | Gartner's report evaluated the industry's top server vendors on three distinct categories: Technology, Business Practice and Market Momentum. | | | Additional information on Gartner's OLTP and Data Warehousing Server Evaluation Models is available through Gartner, Inc. directly. | | | For the second time running, HP's (NYSE:HPQ) flagship high-end UNIX® server, HP Superdome, is the top overall UNIX server in the OLTP Server Evaluation Model report published last week by independent analyst firm Gartner, Inc. |
|
http://www.hp.com/hpinfo/newsroom/press/2002/021021a.html
(555 words)
|
|
| |
| | 11/19/97 - SUN DEMONSTRATES CONSOLIDATION OF MAJOR APPLICATIONS ON SINGLE SMP SERVER WITHOUT COMPROMISING PERFORMANCE |
| | Industry-Standard OLTP and Decision Support Benchmarks Run Simultaneously on Sun Enterprise 6000 Server and IBM DB2 Universal Database Software | | | While the platform supported up to 13,500 online transaction processing users in steady state, the system was able to process decision support queries for five users. | | | This workload is representative of a standard mission-critical OLTP server consolidated with one or more sizeable data marts during peak load. |
|
http://www.sun.com/smi/Press/sunflash/9711/sunflash.971119.3.html
(878 words)
|
|
| |
| | Baldwin Hackett & Meeks, Inc. Baldwin Hackett & Meeks, Inc. - OLTP Software Services and Products - Quick Contact, ... |
| | Baldwin Hackett & Meeks, Inc., headquartered in Omaha, Nebraska, is a professional software services organization specializing in the development of large-scale, high-availability, on-line processing networks using fault tolerant computer platforms. | | | Baldwin Hackett & Meeks, Inc. - OLTP Software Services and Products | | | Baldwin Hackett & Meeks, Inc. Baldwin Hackett & Meeks, Inc. - OLTP Software Services and Products - Quick Contact, Profile, and Connnection Page in BizWiz - Baldwin Hackett & Meeks, Inc. - OLTP Software Services and Products |
|
http://www.bizwiz.com/quickprofilepages/ba/baldwinhackettmeeks.htm
(244 words)
|
|
| |
| | Business Wire : HP Launches New Middleware-Engineering Initiative to Help Users Deploy Distributed OLTP; Initiative ... |
| | HP Launches New Middleware-Engineering Initiative to Help Users Deploy Distributed OLTP; Initiative Targets Mainframe OLTP Users; Includes HP Encina 9000 1.1 and CICS for HP 9000 1.3. | | | It helps customers implement distributed OLTP according to their unique business requirements. | | | Business Wire : HP Launches New Middleware-Engineering Initiative to Help Users Deploy Distributed OLTP; Initiative Targets Mainframe OLTP Users; Includes HP Encina 9000 1.1 and CICS for HP 9000 1.3. |
|
http://static.elibrary.com/b/businesswire/january301995/hplaunchesnewmiddlewareengineeringinitiativetohelp/index.html
(276 words)
|
|
| |
| | OLTP Book Marks |
| | * Search * Table of Contents * Open OLTP News | | | The following are sources of OLTP information, but you may have to pay. | | | The name seems to be in and out of favour and it has not always been know as `Brixton'. |
|
http://www.zois.co.uk/bm.html
(341 words)
|
|
| |
| | Improving OLTP Data Quality Using Data Warehouse Mechanisms - Jarke, Quix, Blees, Lehmann, Michalk, Stierl ... |
| | Improving OLTP Data Quality Using Data Warehouse Mechanisms. | | | Improving OLTP Data Quality Using Data Warehouse Mechanisms (1999) | | | Improving OLTP Data Quality Using Data Warehouse Mechanisms - Jarke, Quix, Blees, Lehmann, Michalk, Stierl (ResearchIndex) |
|
http://citeseer.lcs.mit.edu/jarke99improving.html
(394 words)
|
|
| |
| | oltp : Definition from the Online Dictionary at Datasegment.com |
| | 2 definitions found oltp - Free On-line Dictionary of Computing (19 Sep 2003) : OLTP On-Line Transaction Processing oltp - V.E.R.A. -- Virtual Entity of Relevant Acronyms (December 2003) : OLTP OnLine Transaction Processing | | | oltp : Definition from the Online Dictionary at Datasegment.com |
|
http://onlinedictionary.datasegment.com/word/oltp
(43 words)
|
|
| |
| | OLTP vs Reporting Database vs OLAP Database |
| | The one database for Reporting Purposes, when it is independent like you have it might be called an ODS (Operational Data Store). | | | The data in these databases is generally for a shorter specific period (like quarterly for instance.) The OLAP database is intended for aggregated reporting, across longer historical periods. | | | > -1 Database for OLTP -> at Server A > -1 Database for Reporting Purposes -> at Server B > -1 Database for OLAP -> at Server B > |
|
http://www.webservertalk.com/message1035309.html
(396 words)
|
|
| |
| | RE: Block Size for OLTP |
| | I have a 8k block size for the 9.2 OLTP database. | | | Also having small block size reduce the lock contention for the block. | | | For OLTP better have small db_block_size, but for DSS large |
|
http://www.lazydba.com/oracle/0__87208.html
(101 words)
|
|
| |
| | OLTP & OLAP same instance |
| | if hardware-resources (cpu/memory/io-bandwith) allow to do OLTP and OLAP (each with short heavy-usage-peaks, but on average low resource consumption) on the same machine, which one is better: to have one oracle-instance for both, or set up two separate instances on the same database server (9i on solaris)? | | | I'm just looking for rules of thumb; which are the most important factors to consider? | | | Home -> Community -> Usenet -> c.d.o.server -> OLTP and OLAP same instance |
|
http://www.orafaq.com/usenet/comp.databases.oracle.server/2003/08/08/0734.htm
(110 words)
|
|
| |
| | Blogshares: An OLTP horror show Computerworld Blogs |
| | So it's hard to find examples of really bad OLTP issues to rubberneck at. | | | When an OLTP-oriented web site doesn't work, it generally goes away; there's not a lot of point in staying online if you can't keep track of products, money, whatever. |
|
http://www.computerworld.com/blogs/node/863
(699 words)
|
|
| |
| | IBM UDB: OLTP Performance slows over time |
| | I have a reasonably small (for now at least) OLTP DB on UDB 7.2. | | | Users of the web application complain that responses become slow after a while, this usually happens after a few days of solid uptime. |
|
http://www.experts-exchange.com/Databases/IBM_UDB/Q_20707832.html
(263 words)
|
|
|
