• 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

    [Webinar Series] Demystifying DevOps on the IBM i

    Join us for this 3-Part Roundtable Webinar Series, where ARCAD experts will demystify the move to Git and an automated process with options that work for everyone!

    This Series will be an engaging discussion on key DevOps topics as Git, Builds, Automation and much more.

    Part 2: Branching & Building (Thursday, February 9th, at 12:00PM ET / 9:00AM PT)

    During this 2nd session, we will discuss Feature/Release and Branch Management and building the branches with tools like Bob and ARCAD.

    Part 3: DevOps – Automated Workflow (Thursday, February 23rd, at 12:00PM ET / 9:00AM PT)

    During this 3rd session, we will discuss what can be automated in the IBM i DevOps process starting from the build to other steps in your workflow.  We’ll discuss pipeline tools like Jenkins and the new automation features of Git packages.

    Register 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

    • Power Systems Did Indeed Grow Revenues Last Year
    • The IBM Power Trap: Three Mistakes That Leave You Stuck
    • Big Blue Decrees Its 2023 IBM Champions
    • As I See It: The Good, the Bad, And The Mistaken
    • IBM i PTF Guide, Volume 25, Number 5
    • N2i Gains Traction Among IBM i Newbies
    • Realizing The Promise Of Cross Platform Development With VS Code
    • 2023 IBM i Predictions, Part 3
    • Four Hundred Monitor, January 25
    • Join The 2023 IBM i Marketplace Survey Webinar Tomorrow

    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 © 2022 IT Jungle

    loading Cancel
    Post was not sent - check your email addresses!
    Email check failed, please try again
    Sorry, your blog cannot share posts by email.