by wp_sd | Nov 6, 2019 | Database, MySQL
MySQL provides support for thirteen different storage engines which act as varying table type handlers. Most people who use MySQL on a regular basis already know about the two most common storage engines, MyISAM and InnoDB. Most of the time, the default storage engine...
by wp_sd | Mar 17, 2019 | Database, SQL
Now that we just get used to SQL, lets go to NoSQL. Have a look at this prominent introduction … good for perspective . Introduction to NoSQL by Martin Fowler So, nothing lost …
by wp_sd | Jan 20, 2019 | Data Management, Database, Design, Mathematics, MySQL, Programming
Great chapter from the unmissable book by Peter Brawley and Arthur Fuller … http://www.artfulsoftware.com/ … Thank you boys! Most non-trivial data is hierarchical. Customers have orders, which have line items, which refer to products, which have prices....
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...
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...
by wp_sd | Oct 4, 2018 | Data Management, Database
And here is another TED talk. This time we are listening to wonderful Mr. Kenneth Cukier ……. Self-driving cars were just the start. What’s the future of big data-driven technology and design? In a thrilling science talk, Kenneth Cukier looks at...
