BI

No{Join,GroupBy}SQL – Analytic Views for BI

By Franck Pachot . Advocates of NoSQL can query their structures without having to read a data model first. And without writing long table join clauses. They store and query a hierarchical structure without the need to follow relationships,(…)

Oracle 12c – global partial index

By Franck Pachot . We have an incredible number of possibilities with Oracle. Yes, an index can be global (indexing many partitions without having to be partitioned itself on the same key) and partial (skipping some of the table(…)

Oracle 12c – reorg and split table with clustering

By Franck Pachot . In this series of small examples on recent features, I have imported in a previous post, the statistics of covid-19 per day and per countries. This is typical of data that(…)

Oracle 12c – peak detection with MATCH_RECOGNIZE

By Franck Pachot . This post is part of a series of small examples of recent features. I’m running this in the Oracle 20c preview in the Oracle Cloud. I’ll show a very basic example of “Row Pattern Recognition”(…)

Oracle 12c – pre-built join index

By Franck Pachot . This post is part of a series of small examples of recent features. I’m running this in the Oracle 20c preview in the Oracle Cloud. I have created a few tables in the(…)

Oracle 18c – select from a flat file

By Franck Pachot . This post is the first one from a series of small examples on recent Oracle features. My goal is to present them to people outside of Oracle and relational databases usage, maybe some NoSQL players.

Pass Summit – dbi visit day 4 (2)

Power BI 5 top custom visuals The development of Power BI itself is fast. But, the means to represent data is too. I mean there are constantly new Power BI custom visuals developed by the community and Microsoft. You(…)

Pass summit – dbi visit day 1

Designing Modern Data and Analytic Solution in Azure After having explained the pros and cons of Azure and the decision drivers for going to an Azure Architecture, some interesting messages were delivered like the decoupling of the storage(…)

Create constraints in your datawarehouse – why and how

By Franck Pachot . We still see some developers not declaring referential integrity constraints in datawarehouse databases because they think they don't need it (integrity of data has been validated by the ETL). Here is a small demo I did(…)

PostgreSQL as a central reporting hub? – Yes, of course

For every client we do projects for there usually are database systems from various vendors. In most places you at least find some Oracle and MS SQL Server databases. Probably somewhere there are even some MySQL/MariaDB or PostgreSQL instance running.