Emerging Requirements and DBMS Technologies: When Is Relational the Right Choice?

Trends in Architecture and Design
4 April 11:00AM - 11:50AM @ Ballroom H

Experience level: 
50 minutes conference
Relational database technology first emerged at a time when most databases served batch-oriented back-end applications such as accounting and sales management. As time has passed, the relational database management system (RDBMS) has been expected to provide online transaction support and data warehouse management, driving client/server applications on RISC systems and PCs. Moving first to the Web, and then to the Cloud, the RDBMS has had to address issues of flexible scalability both in terms of performance and cost. The open source RDBMS technologies have been commonly applied to the Cloud space (private, public, and hybrid), but so-called "NoSQL" database technologies (document-based and key-value stores) are increasingly used here, especially for transaction processing and transitory data management. Lately, new application modes have emerged, including extreme transaction processing and real-time analytics are driving a need for speed and flexibility and creating fresh demand for memory-optimized database technology. How does one know which is the right database technology for the task at hand? What are the advantages and drawbacks of a schematic database (such as relational) versus a non-schematic database? How important is memory-optimized technology? ACID (atomicity, consistency, isolation, durability) properties? Dynamic schema flexibility? Normalization? Do I need memory-optimized technology, or is disk-optimized good enough? This session will discuss these and other issues, considering the emerging requirements for new database applications, the kinds of DBMS technology needed to address these requirements, and the place that MySQL and related technologies have in the overall landscape of database technologies for these applications. It will compare and contrast MySQL and related technologies with both proprietary relational products, and with non-relational alternatives. It will offer viewpoints regarding useful approaches to choosing the right technology, and will invite discussion and debate on these points.


Research Vice President, IDC
Carl Olofson performs research and analysis for IDC’s Database Management and Data Integration Software service within the Application Development and Deployment research group. Mr. Olofson’s research involves following sales and technical developments in the information and data management (IDM) markets, database management systems (DBMS) markets, data movement and replication software, data management software, metadata management software, and the vendors of related tools and software systems. Mr. Olofson also contributes overview and data integration research content to Integration and Deployment Software, which covers developments in software technologies that manage the overall integrated deployment of applications developed and maintained using application development and deployment software. Mr. Olofson also advises clients on market and technology directions as well as performing supply and demand-side primary research to size, forecast, and segment the database market. Mr. Olofson has been an analyst at IDC since 1997. Over that time, he has been among the first industry analysts to provide detailed discussions of horizontally and vertically scalable DBMS architectures, mobile DBMS technology, in-memory DBMS, extended relational DBMS, virtual DBMS, open source DBMS, NoSQL (including key-value stores and document-oriented DBMS), Big Data (including Hadoop), and NewSQL. In 2000, Mr. Olofson received IDC's highest award, the James Peacock Memorial Award for professional excellence in market research. Mr. Olofson has 35 years of experience in IT, including two years of application development consulting, 10 years of database and tools software development, four years of product consulting, and three years as a senior product manager. Prior to joining IDC, Mr. Olofson worked at Cayenne and Cadre, where he was involved with directing the management for ObjectTeam products, including an object-oriented CASE tool and a component construction and assembly tool. He was also responsible for product packaging, pricing, requirements analysis, sales force preparation, and product roll-out. Prior to that, Mr. Olofson managed customer relations and performed sales support for MSP in promoting its mainframe repository, METHODMANAGER. He also worked at LBMS, where he led a team of eight engineers working on a repository technology research program; and at Cullinet where he was responsible for the Cullinet CASE strategy. In addition, Mr. Olofson worked for eight years in project teams developing the IDMS, IDD, ADS/Online, and Online Mapping products. Mr. Olofson has been quoted in a variety of publications, including The New York Times, The Wall Street Journal, San Francisco Chronicle, Investor's Business Daily, San Jose Mercury-News, USA Today, Computerworld, Object Magazine, Software Magazine, and Application Development Trends. He has presented at numerous conferences, including each of the InterSystems Worldwide Developers' Conference (DevCon) from 2000 through 2004, 2002 OracleWorld, the 1999 XMLeadership Conference, 1999 Oracle OpenWorld, 1998 AITG (Advanced Information Technologies for Government) Conference, the 1997 Oracle Partners' Conference, the 4 Rs Conference, DAUG (Data Administration Users’ Group), IRMAC (Information Resource Management Association of Canada), and user conferences for Cullinet, MSP, INTERSOLV, and Cadre Technologies. Mr. Olofson also presented thought leadership information regarding CyberSmart Computing (later called services oriented architecture, or SOA), the data management implications of ebusiness, and enterprise information management strategies at a series of seminars sponsored by Hewlett-Packard and Oracle Corporation between January and May 2000. Mr. Olofson received a B.S. in communications from Boston University.