Introduction Working with customers over the past many years, the question of Data Architecture and Data Strategy has come up a lot. ‘What should my data strategy be?’ or ‘How do I go around creating a Data Strategy or a Data Architecture and what are some of the critical elements of a Data Architecture?’ Let me address some of those questions and the importance of having a well-defined Data Strategy and a Data Architecture. First and foremost, why do you […]
Learn more about
ETL processes include extracting data from a source dataset, transforming it in a particular way, and loading the resulting data into a target dataset. This is a very important process in terms of databases’ performance. Learn the ETL best practices on DB Best’s blog.
In less than 2 years DB Best professionals have written and posted over 100 technical articles on database migration and management related topics. These articles have gathered more than 20K views, thousands of likes and dozens of comments from various database management professionals from all over the world. In this post we would like to present a concise and informative review of our most rated articles:
Big Data – Extract-Transform-Load (ETL) 002 (click to download) My last blog (Extract-Transform-Load (ETL) Technologies – Part 1) discussed the purpose, function, and some of the inherent benefits of ETL technologies for moving data from source applications into target reporting and analytic environments. Hopefully from that discussion one can gain some general understanding of ETL; what it is, how it can be used, and why we would want to use it. Now let’s dive a bit deeper and discover who […]
Big Data – Extract-Transform-Load (ETL) 001 (click to download) *~:~* Happy New Year *~:~* My last blog (Column Oriented Database Technologies) discussed the differences between Row and Column oriented databases and some key players in this space. Concepts and technologies on Big Data have been discussed in previous blogs (Big Data & NoSQL Technologies & NoSQL .vs. Row .vs. Column). From these blogs one should surmise that deciding upon the best database technology (or DBMS vendor) really depends on schema complexities, […]