• 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
    Fresche Solutions

    Executive Report for IT Leaders

    Why Smart Modernization Is the Path to Successful IBM i Digital Transformation

    Download this report to get answers these key questions:

    • What is driving digital transformation?
    • Where are organizations going wrong with respect to modernization?
    • What is the best / most efficient / smartest way forward?

    Get the Report »

    _________________________________________________________________

    About Fresche Solutions

    Fresche is the leading provider of digital transformation enablement, application modernization and optimization solutions for companies that rely on IBM i Power Systems. Through the power of automated tools and experienced professionals, Fresche delivers smart solutions that bring our clients the best, boldest ideas to fuel transformation and better manage their business and IT. Our low-risk, phased approach is giving companies new ability to digitally innovate and improve operational processes while leveraging IT assets so clients can take advantage of digital solutions including web, mobile, cloud and AI.

    We can help you with:

    • Developing your IT strategy
    • Building an IBM i roadmap
    • Transforming your RPG and CA 2E (Synon) code to modern languages
    • Addressing developing shortages
    • Quickly onboarding new IT staff
    • Increasing developer productivity
    • Integrating with other systems
    • Extending your ERP
    • Understanding your applications
    • Deploying modern interfaces
    • Improving business agility
    • Starting your digital transformation journey

    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

    • Query Supervisor Gives Database Engineers New Power
    • IBM Unveils New and Improved IBM i Services
    • 3 Takeaways from the 2021 PowerTech Security Report
    • Four Hundred Monitor, April 14
    • IBM i PTF Guide, Volume 23, Number 15
    • Big Blue Unveils Spring 2021 IBM i Technology Refreshes
    • Thoroughly Modern: Innovative And Realistic Approaches To IBM i Modernization
    • Guru: Web Services, DATA-INTO and DATA-GEN, Part 2
    • Back To The Future With A New IBM i Logo
    • IBM i PTF Guide, Volume 23, Number 14

    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 © 2021 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.