• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Reader Feedback on Database Modernization Still Unknown Territory

    August 18, 2008 Hey, Ted

    I seem to have missed something on the DDS versus DDL topic, which Dan Burger wrote about in Database Modernization Still Unknown Territory. Explain why and how DDL is faster if they both run on the same box. The speed of the disk drives is the same. If there is some “super algorithm” for DDL, why can’t it be applied to DDS? Is there some design feature of DDS that just makes it slow compared to DDL, or is DDL really just something new just because IBM thought it was time for a change, kinda like the i versus AS/400 thing?

    –JH

    There is more to I/O than hardware. Input and output are governed by software. This is nothing new. Buffering has been around for years.

    I refer you to Chapter 2 of the Redbook Modernizing IBM eServer iSeries Application Data Access–a Roadmap Cornerstone. You will see from the diagrams that native I/O and the Classic Query Engine (CQE) are implemented above the Machine Interface, but the SQL Query Engine (SQE) is implemented below the MI. So, no, the performance is not the same.

    Could the “super algorithms” be applied to DDS? Of course some of them could, but IBM has chosen not to apply them to DDS. SQL is the strategy. SQL gets the development dollars.

    Did IBM change directions from DDS to SQL just for the sake of change? No, by no means. IBM realizes that SQL can do what people need to be done, and DDS cannot. And that is the reason I use SQL.

    –Ted

    RELATED STORIES

    Database Modernization Still Unknown Territory

    Resolution Moves Database Automation Forward

    Database Tool Maker Joins the System i Market



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: mtfh_rc, Volume 17, Number 32 -- August 18, 2008

    Sponsored by
    ARCAD Software

    Embrace VS Code for IBM i Development

    The IBM i development landscape is evolving with modern tools that enhance efficiency and collaboration. Ready to make the move to VS Code for IBM i?

    Join us for this webinar where we’ll showcase how VS Code can serve as a powerful editor for native IBM i code and explore the essential extensions that make it possible.

    In this session, you’ll discover:

    • How ARCAD’s integration with VS Code provides deep metadata insights, allowing developers to assess the impact of their changes upfront.
    • The role of Git in enabling seamless collaboration between developers using tools like SEU, RDi, and VS Code.
    • Powerful extensions for code quality, security, impact analysis, smart build, and automated RPG conversion to Free Form.
    • How non-IBM i developers can now contribute to IBM i projects without prior knowledge of its specifics, while ensuring full control over their changes.

    The future of IBM i development is here. Let ARCAD be your guide!

    Watch Now

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Admin Alert: Common Mistakes When Failing Over to a CBU looksoftware Unveils iPhone Client for i OS Apps

    Leave a Reply Cancel reply

TFH Volume: 17 Issue: 32

This Issue Sponsored By

    Table of Contents

    • PowerTech Acquired by Help/Systems, Private Equity Firm
    • JDA Ponies Up $346 Million to Buy i2 Technologies
    • SMBs Are Sensibly More Concerned with Biz than Tech
    • As I See It: Lessons from Robben Island
    • Big Blue Launches XIV Clustered Storage Arrays
    • Reader Feedback on Database Modernization Still Unknown Territory
    • Java vs. .NET: Someone’s Going to Get a Black Eye
    • Arrow and Avnet Say Their June Quarters Exceeded Expectations
    • Magic Software Boosts Sales and Profits in Q2
    • Kronos Says Business Is Still Growing, Profits More So

    Content archive

    • The Four Hundred
    • Four Hundred Stuff
    • Four Hundred Guru

    Recent Posts

    • Liam Allan Shares What’s Coming Next With Code For IBM i
    • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
    • VS Code Will Be The Heart Of The Modern IBM i Platform
    • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
    • IBM i PTF Guide, Volume 27, Number 25
    • Meet The Next Gen Of IBMers Helping To Build IBM i
    • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
    • Will Independent IBM i Clouds Survive PowerVS?
    • Now, IBM Is Jacking Up Hardware Maintenance Prices
    • IBM i PTF Guide, Volume 27, Number 24

    Subscribe

    To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

    Pages

    • About Us
    • Contact
    • Contributors
    • Four Hundred Monitor
    • IBM i PTF Guide
    • Media Kit
    • Subscribe

    Search

    Copyright © 2025 IT Jungle