Sofadeve Services Ltd
  • About
    • The Company
    • The People
    • How we work
    • Privacy Policy
    • Terms & Conditions
  • Services
    • Overview
    • Database Development
    • Web Hosting
    • Project Management
    • Business Systems & Process Analysis
    • IT Consultancy
  • Projects
    • GwenBeauty
    • PGS
    • German Konsulate
    • Puzzlemania
    • ttt
    • MalteKoeditz
    • Siedlungsheim Langenhorn Hamburg
    • Sofadeve
    • Products
  • Blog
  • Contact
  • Login
Select Page

The ETL from Hell – Diagnosing Batch System Performance Issues

by wp_sd | May 1, 2019 | Data Management, ETL

by Nigel Rivett Too often, the batch systems that underlie a lot of database processing just grow without conscious design. When runs start to extend beyond their allotted time, and tuning no longer solves the problem, it is often discovered that batches are run in...
Data Transformation and Linear Algebra

Data Transformation and Linear Algebra

by wp_sd | Jan 16, 2019 | Data Management, Database, Design, ETL, Mathematics

The problem of data transformation is solved in numerous ways with different levels of smartness and in different flavors. ETL (extract – transform – load) processes is a buzz word strongly related to this topic. Basically the requirement is to get a...

Loading half a billion rows into MySQL

by wp_sd | Nov 10, 2018 | Data Management, Database, ETL, MySQL

Interesting post on the derwiki blog … Especially the commenting is quite entertaining! Amazing how ignorance produces patronizing statements (-> Morg). See belwo the top of teh post … Background We have a legacy system in our production environment that...

What’s Up

My Tweets
  • Facebook
  • X

Designed by Elegant Themes | Powered by WordPress