Databases Flexview Materialized View Implementation By Nikhilesh Flexview : Materialized view implementation Flexviews is basically materialized views implementation for MariaDB, MySQL and its forks. It consists of a SQL API that creates materialized views and refresh them. The advantage of Flexviews is that the materialized views can...
Databases With Clause in SQL By Nikhilesh With Clause in SQL The WITH query_name clause lets you assign a name to a subquery block. You can then reference the subquery block multiple places in the query by specifying the query name. You can specify this clause in...
Databases Backup and Restore MySQL DB Using mysqldump By Sayali Mahale mysqldump is a tool used to backup MySQL Database. It creates .sql file having DROP TABLE , CREATE TABLE , INSERT INTO TABLE sql Statements. To restore the database we have to execute the .sql file on destination database. Using...
Business Intelligence Staging DB in Data Warehousing – The WHYs and WHY NOTs By Shraddha Tambe Staging DB in Datawarehousing - The WHYs and WHY NOTs Whenever we talk about designing datawarehouses, staging database is one consideration we have to make. And it depends on many factors whether you choose to have one or not. I...
Databases Lateral Subqueries in Postgres By Nikhilesh Lateral subqueries in Postgres Postgres has feature to use value from preceding table using keyword lateral. This is used for cross-referencing. means Subqueries appearing in FROM can be preceded by the key word LATERAL. This allows them to reference columns...
Business Intelligence Beginners Guide to Understanding Cross Join By Sohail Beginners Guide to Understanding Cross Join In my previous Beginners Guide we talked about Types of joins i.e. Inner Join, Left and Right Join but today we will be talking about cross join which happens to be more interesting to...
Business Intelligence Why build a Data Warehouse? By Shraddha Tambe Often when we talk about implementing BI, the first thing we need to look at is how and where is the data? Is it scattered? Is it easy to report on? With this we often need to know if...
Business Intelligence Beginners Guide in Understanding Different Types of Joins By Sohail INNER JOINS When we decide that one table won't be enough for getting our desired output then we try to attach one more table to the existing table is known as JOINS. Now Inner Joins in other words is doing...
Databases Analytical Functions in MySQL By admin Analytic function syntax : Analytic_function(argument) OVER (PARTITION BY argument ORDER BY argument); Where argument : column name Analytic functions operate on subsets of rows, similar to aggregate functions in GROUP BY queries, but they do not reduce the number of rows returned by the query. Eg :Lets...
Databases Data Partitioning in MySQL By Sayali Mahale To increase the Query execution Performance in MySQL , we found the solution to do the data partitioning on the table. What is Data Partitioning? Partition enables you to distribute portions of individual tables across a file system according to...
Business Intelligence Crosstab in Jaspersoft By Sohail Beginner’s Guide to Crosstab in Business Intelligence Using Jaspersoft IReport What is Cross Tab? A Table is just of 2 Dimension but at times we do need our table to be represented in a 3 dimensional manner or in a...
Business Intelligence Mongo DB Aggregation – Part II – The Aggregation Framework By Shraddha Tambe Mongo DB Aggregation(Part 2) - The Aggregation Framework The Mongo DB aggregation framework or aggregation pipeline lets you define a data processing pipeline. It takes multiple documents in a collection, puts them through the multiple Stages we define and transforms...