Tags » Database

Lightning fast performance through the pf.lambda database

In the video below, I am inserting roughly 7160 items into the database, and the entire process takes roughly 1.5 seconds, which includes the JIT compilation of the Mono assemblies. 207 more words


Police have new missing person database - Fairfield, CT - Minuteman News Center

It was a mother’s nightmare.

Two years ago, in the middle of the night, an autistic teenager was found by the Town of Fairfield Police Department; barefoot, soaking wet, unable to communicate, and with no form of identification. 51 more words


Improving IN-MEMORY query with Attribute Clustering (IMCU pruning and compression ratio)

Attribute clustering is a new feature of oracle 12c for more info check http://docs.oracle.com/database/121/DWHSG/attcluster.htm#DWHSG9338.

I will focus here only on how attribute clustering can improve in-memory query.For a description of in-memory pruning please check my previous… 193 more words


The phosphorus.five database plugin

The phosphorus.data adapter, is a simple database plugin, based upon pf.lambda, and its expressions. This allows you to persist stuff to the disc as you see fit, in an integrated way, such that there’s no real difference between the database logic and/or… 306 more words


What is Big Data and Analytics ?

Today Big Data and Analytics are the words that are going around every where. Data is being poured over the internet in huge amount. Every day, we create 2.5 quintillion bytes of data — so much that 90% of the data in the world today has been created in the last two years alone. 132 more words

Data Analytics

Count each number of table rows

Count each number of table rows

Oracle ACE Laurent Schneider has a more elegant solution for counting tables, using dbms_xmlgen to store the row counts for multiple tables in a single SQL query list: 44 more words



What a great year of independant consulting. I’ve worked with some fabulous clients and colleagues and helped create greater clarity with customer engagement programs, greater collaboration between resource structures and ultimately improved performance value with agency partners.  128 more words