http://technorati.com/tag/OLTP Posts tagged with "OLTP" on Technorati Thu, 15 May 2008 19:49:51 -0700 Technorati v1.0 http://static.technorati.com/pix/logos/logo_sm.gif http://technorati.com/tag/OLTP support@technorati.com (Technorati Support) http://blogs.law.harvard.edu/tech/rss 60 OLTP http://www.pythian.com/blogs/1004/oracle-11g-result-cache-in-the-real-world http://www.pythian.com/blogs/1004/oracle-11g-result-cache-in-the-real-world Tue, 13 May 2008 12:46:13 -0700 Oracle 11G Result Cache in the Real World May 13th, 2008 - by Alex Fatkulin As some of you probably already noticed, there was a thread on AskTom discussing the scalability tests I did back in 2007. You are welcome to read the entire thread, but in a nutshell, Tom Kyte claimed that my tests did not reflect how one would use the result cache in the real world. What is “real world?” Of course, the important question is whether I tested a feature in a way it was never designed to be used, or w 2008-05-13 12:46:13 PDT http://technorati.com/search/www.pythian.com/blogs/1004/oracle-11g-result-cache-in-the-real-world 105 471 Pythian Group Blog http://venky-itjobs.blogspot.com/2008/05/liquidhub-sql-server-developer.html http://venky-itjobs.blogspot.com/2008/05/liquidhub-sql-server-developer.html Mon, 12 May 2008 11:10:38 -0700 Are you a passionate professional who enjoys working with similar people? If yes, you have the best opportunity in the technology world knocking your door. We're looking for consummate professionals... For more info on latest job openings and other career related information visit my site http://venky-itjobs.blogspot.com 2008-05-12 11:10:38 PDT http://technorati.com/search/venky-itjobs.blogspot.com/2008/05/liquidhub-sql-server-developer.html 8 20 http://biguru.wordpress.com/2008/05/07/thrive-or-survive-the-changing-rules-for-databases/ http://biguru.wordpress.com/2008/05/07/thrive-or-survive-the-changing-rules-for-databases/ Wed, 07 May 2008 02:59:04 -0700 Not since the late seventies, when Larry Ellison’s Relational Software Inc. (RSI) turned out the first commerically available RDBMS - Oracle, has there been such rapid changing of the rules (read disruption) in the database industry. With Web 2.0 pushing enterprise adoption, and the ensuing information explosion in the maze of audio, video, data and ever-growing data warehouses, it seems that the conventional relational database systems are growing tired. With estimates of unstructured data b 2008-05-07 02:59:04 PDT http://technorati.com/search/biguru.wordpress.com/2008/05/07/thrive-or-survive-the-changing-rules-for-databases/ 2 2 http://www.indianjobmela.com/2008/04/15/sql-server-database-developer-3-yrs-exp-urgent-openings/ http://www.indianjobmela.com/2008/04/15/sql-server-database-developer-3-yrs-exp-urgent-openings/ Tue, 15 Apr 2008 01:45:14 -0700 SQL Server Database Developer (3+ Yrs Exp) - Urgent Openings Posted on April 15th, 2008 in MSSQL JOBS by admin Experience:3 - 5 Years Location:Hyderabad / Secunderabad Education:UG - Any Graduate - Any Specialization PG - Any PG Course - Any Specialization Industry Type:IT-Software/ Software Services Functional Area:DBA, Datawarehousing Posted Date:15 Apr Job Description Are you a passionate professional who enjoys working with similar people?If yes, you have the best opportunity in the te 2008-04-15 01:45:14 PDT http://technorati.com/search/www.indianjobmela.com/2008/04/15/sql-server-database-developer-3-yrs-exp-urgent-openings/ 1 12 Indian Job Mela http://dbsystems.wordpress.com/2008/04/08/database-server-consolidation/ http://dbsystems.wordpress.com/2008/04/08/database-server-consolidation/ Tue, 08 Apr 2008 09:04:56 -0700 Database server consolidation April 8, 2008 by Admin A Nice article about database server consolidation The best bet is to start by completing a Server Consolidation Worksheet like the sheet provided by Microsoft to get a better idea of the consolidation opportunities. Microsoft has provided a SQL Server consolidation Worksheet to assist with the process of consolidating SQL Servers and it can be found at http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/sql2kcon.mspx#EAAA. I have 2008-04-08 09:04:56 PDT http://technorati.com/search/dbsystems.wordpress.com/2008/04/08/database-server-consolidation/ 0 0 http://sqldbpool.wordpress.com/2008/04/04/database-concepts-or-database-keywords/ http://sqldbpool.wordpress.com/2008/04/04/database-concepts-or-database-keywords/ Fri, 04 Apr 2008 07:59:05 -0700 Data Mart - A single star schema, i.e. dimensions and a fact table that stores data at the detail level. A Data Mart covers a specific area of the business: billing, inventory, transactions, claims, etc. Data Modeling - Performing analysis on the business processes and data to discover attributes of, and relationships between, data elements. An Entity Relationship Diagram (ERD) is the implementation of a data model. Another way to think of it is to discover the business rules of the data elem 2008-04-04 07:59:05 PDT http://technorati.com/search/sqldbpool.wordpress.com/2008/04/04/database-concepts-or-database-keywords/ 4 5 http://www.dbms2.com/2008/03/25/enterprisedb-unveils-the-postgres-plus-story/ http://www.dbms2.com/2008/03/25/enterprisedb-unveils-the-postgres-plus-story/ Tue, 25 Mar 2008 04:54:26 -0700 EnterpriseDB is making a series of moves and announcements. Highlights include: Renaming/repositioning the product as “Postgres Plus.” The free product is now Postgres Plus, while the version you pay EnterpriseDB for is now Postgres Plus Advanced Server. Repackaging the products, so that Postgres Plus Advanced Server is a strict superset of Postgres Plus. New features added to Postgres Plus Advanced Server. Features newly migrated from Advanced Server down to Postgres Plus. A strategic inv 2008-03-25 04:54:26 PDT http://technorati.com/search/www.dbms2.com/2008/03/25/enterprisedb-unveils-the-postgres-plus-story/ 63 130 http://www.dbms2.com/2008/03/24/enterprisedb-unveils-the-postgres-plus-story/ http://www.dbms2.com/2008/03/24/enterprisedb-unveils-the-postgres-plus-story/ Mon, 24 Mar 2008 04:54:26 -0700 Oops. Got my dates wrong. Post down until the embargo runs out. 2008-03-24 04:54:26 PDT http://technorati.com/search/www.dbms2.com/2008/03/24/enterprisedb-unveils-the-postgres-plus-story/ 63 130 http://itworldnews.ru/2008/03/19/programming/sovety-po-nastrojke-db2-dlya-oltp-prilozhenij/ http://itworldnews.ru/2008/03/19/programming/sovety-po-nastrojke-db2-dlya-oltp-prilozhenij/ Wed, 19 Mar 2008 04:20:19 -0700 В данной статье приведено несколько советов по настройке DB2, основанных на опыте выполнения тестов производительности Online Transaction Processing (OLTP) - TPC-C, TPC-W, Trade2 и др. На производительность приложения, работающего с базами данных, может влиять множество факторов. В данной статье внимание уделяется конфигурационным аспектам DB2 и не рассматриваются вопросы, связанные с планированием производительности, проектированием структуры базы данных или приложения за исключением некоторых 2008-03-19 04:20:19 PDT http://technorati.com/search/itworldnews.ru/2008/03/19/programming/sovety-po-nastrojke-db2-dlya-oltp-prilozhenij/ 1 1 Новости из мира IT http://www.dbms2.com/2008/03/14/the-core-challenges-of-oltp-are-changing/ http://www.dbms2.com/2008/03/14/the-core-challenges-of-oltp-are-changing/ Thu, 13 Mar 2008 21:57:48 -0700 I wrote a few weeks ago about the H-Store project, which rejects a variety of assumptions underlying traditional OLTP database design. One of these is long transactions over open database connections. The idea is that the most demanding OLTP applications run on the Web, where abandonment is common, and hence the only sensible option is to break things up into simple chunks. Ideally, a transaction shouldn’t consist of more information than is filled into a single form. If you really need to sto 2008-03-13 21:57:48 PDT http://technorati.com/search/www.dbms2.com/2008/03/14/the-core-challenges-of-oltp-are-changing/ 63 130 http://www.dbms2.com/2008/03/13/more-twitter-weirdness/ http://www.dbms2.com/2008/03/13/more-twitter-weirdness/ Thu, 13 Mar 2008 19:14:20 -0700 Twitter commonly has the problem of duplicate tweets. That is, if you post a message, it shows up twice. After a little while, the dupe disappears, but if you delete the dupe manually, the original is gone too. I presume what’s going on is that tweets are cached, the tweets are eventually batched to disk, and they don’t always get deleted from cache until some time after they’re persisted. If you happen to check the page of your recent tweets inbetween — boom, you get two hits. But what I don’ 2008-03-13 19:14:20 PDT http://technorati.com/search/www.dbms2.com/2008/03/13/more-twitter-weirdness/ 63 130 http://blogs.the451group.com/information_management/2008/03/04/is-h-store-the-future-of-database-management-systems/ http://blogs.the451group.com/information_management/2008/03/04/is-h-store-the-future-of-database-management-systems/ Tue, 04 Mar 2008 07:38:41 -0800 Given his past involvement in the creation of Ingres and Postgres (not to mention Vertica and StreamBase), when Michael Stonebraker starts talking about a new database research project, the world tends to sit up and listen. Such is the case with H-Store, a new approach to the OLTP database proposed by Stonebraker, along with Samuel Madden at MIT, Daniel Abadi at Yale, and Stan Zdonik at Brown, amongst others. Details of the H-Store project were presented (PDF) at the VLDB conference in Septem 2008-03-04 07:38:41 PST http://technorati.com/search/blogs.the451group.com/information_management/2008/03/04/is-h-store-the-future-of-database-management-systems/ 12 20 The 451 Take on information management — Too much information http://www.dbms2.com/2008/02/27/ebay-oltp-architecture/ http://www.dbms2.com/2008/02/27/ebay-oltp-architecture/ Wed, 27 Feb 2008 14:53:35 -0800 I’ve posted a couple times about eBay’s analytics side. As a companion, Don Burleson pointed me at a fascinating November, 2006 slide presentation outlining eBay’s transactional architecture and evolution. Highlights include: A whole lot of manual slicing of Oracle databases, so as not to exceed their capacity. A whole lot of careful design and ordering of transactions. Putting all the business logic in the application tier, with a custom O/R mapper. There’s lots of caching there, but very lit 2008-02-27 14:53:35 PST http://technorati.com/search/www.dbms2.com/2008/02/27/ebay-oltp-architecture/ 63 130 http://blogs.sun.com/ritu/entry/mysql_benchmark_us_t2_beats http://blogs.sun.com/ritu/entry/mysql_benchmark_us_t2_beats Mon, 25 Feb 2008 13:11:22 -0800 Recently we put together a consolidation benchmark to see how an open-source stack performs against the proprietary stack from Microsoft. Solaris, MySQL, and Sun Webserver running on the open-source UltraSPARC T2 processor were pitted against a Microsoft SW stack running on a 4-socket QC Xeon server. This benchmark highlights the continued trend to incorporate MySQL open-source databases and how it works under virtualization (Solaris Zones). The Sun SPARC Enterprise T5220 (1.4 Ghz UltraSPARC T 2008-02-25 13:11:22 PST http://technorati.com/search/blogs.sun.com/ritu/entry/mysql_benchmark_us_t2_beats 14 17 http://www.dbms2.com/2008/02/20/ibm-objectgrid-h-store/ http://www.dbms2.com/2008/02/20/ibm-objectgrid-h-store/ Wed, 20 Feb 2008 15:47:07 -0800 Billy Newport of IBM sees a lot of similarities between his app-server-based product ObjectGrid and H-Store. In both cases, constrained tree schemas are assumed, and OLTP performance goodness ensues. A couple of points I noted on a quick skim through his blog: He calls out RAM consumption as a challenge for this kind of architecture. He points out that it’s a big advantage to have data called and used in the same address space. Being based in RAM is obviously a huge part of the H-Store sche 2008-02-20 15:47:07 PST http://technorati.com/search/www.dbms2.com/2008/02/20/ibm-objectgrid-h-store/ 63 130 http://www.dbms2.com/2008/02/19/h-store-architecture/ http://www.dbms2.com/2008/02/19/h-store-architecture/ Tue, 19 Feb 2008 19:39:21 -0800 I wrote yesterday about the H-Store project, the latest from the team of researchers who also brought us C-Store and its commercialization Vertica. H-Store is designed to drastically improve efficiency in OLTP database processing, in two ways. First, it puts everything in RAM. Second, it tries to gain an additional order of magnitude on in-memory performance versus today’s DBMS designs by, for example, taking a very different approach to ensuring ACID compliance. Today I had the chance to talk 2008-02-19 19:39:21 PST http://technorati.com/search/www.dbms2.com/2008/02/19/h-store-architecture/ 63 130 http://www.databasecolumn.com/2008/02/responding-to-monash-2.html http://www.databasecolumn.com/2008/02/responding-to-monash-2.html Mon, 18 Feb 2008 11:07:17 -0800 As I did last week, I am using this post to respond to an article published by Curt Monash. You can read his full post, titled "Database management system choices - 4 categories of relational," here. In this post, I will discuss the issue I have with Curt's category characterization of DBMS systems. First, I see two categories of relational analytic/data warehouse databases, row stores and column stores. They have very different characteristics. I would not lump them together, as this post does 2008-02-18 11:07:17 PST http://technorati.com/search/www.databasecolumn.com/2008/02/responding-to-monash-2.html 133 219 The Database Column http://www.dbms2.com/2008/02/18/mike-stonebraker-calls-for-the-complete-destruction-of-the-old-dbms-order/ http://www.dbms2.com/2008/02/18/mike-stonebraker-calls-for-the-complete-destruction-of-the-old-dbms-order/ Sun, 17 Feb 2008 22:25:39 -0800 Last week, Dan Weinreb tipped me off to something very cool: Mike Stonebraker and a group of MIT/Brown/Yale colleagues are calling for a complete rewrite of OLTP DBMS. And they have a plan for how to do it, called H-Store, as per a paper and an associated slide presentation. On the system side, some of their most radical suggestions include: No disks or other persistent storage at all. No multi-threading. No locks. No redo logs (and perhaps not a lot of undo logs either). Their programmin 2008-02-17 22:25:39 PST http://technorati.com/search/www.dbms2.com/2008/02/18/mike-stonebraker-calls-for-the-complete-destruction-of-the-old-dbms-order/ 63 130 http://www.dbms2.com/2008/02/16/stonebraker-database-taxonomy/ http://www.dbms2.com/2008/02/16/stonebraker-database-taxonomy/ Sat, 16 Feb 2008 15:21:26 -0800 In a response to my recent five-part series on DBMS diversity, Mike Stonebraker has proposed his own taxonomy of data management technologies over on Vertica’s Database Column blog. OLTP DBMSs focused on fast, reliable transaction processing Analytic/Data Warehouse DBMSs focused on efficient load and ad-hoc query performance Science DBMSs — after all MatLab does not scale to disk-sized arrays RDF stores focused on efficiently storing semi-structured data in this format XML stores focused on 2008-02-16 15:21:26 PST http://technorati.com/search/www.dbms2.com/2008/02/16/stonebraker-database-taxonomy/ 63 130 http://www.dbms2.com/2008/02/15/mid-range-relational-database-management/ http://www.dbms2.com/2008/02/15/mid-range-relational-database-management/ Fri, 15 Feb 2008 11:38:06 -0800 This is the fourth of a five-part series on database management system choices. For the first post in the series, please click here. The other threat to the high-end relational DBMS vendors aims squarely at the heart of their business. It’s the mid-range relational database management systems, which are doing an ever-larger fraction of what their high-end cousins can. That said, different products do different things well. So if you’re not blindly paying up for the security of an all-things-to 2008-02-15 11:38:06 PST http://technorati.com/search/www.dbms2.com/2008/02/15/mid-range-relational-database-management/ 63 130