Recent Articles Changed
Event Centric Thinking
What is a Stream? Also known as Pipe, Message Queue or Event Processing

Modified Monday 22-04 07:42

A stream is: a sequence of aninfinite cardinality (size) delivered atunknown time intervals. list Streams of data user activity on a website sensor readings from devices (IOT) order delivery A table is a stream of data manipulation...

Data System Architecture
What are SQL Statements?

Modified Monday 22-04 07:41

This article is statements in a SQL context. In SQL, there are 4 types of statements: Type Example DDL - Data Definition Language Data Dictionary manipulation (create, alter, ...) DML - Data Manipulation Language insert, update, ... QUERY -...

Data System Architecture
SQL - Query (SELECT)

Modified Monday 22-04 07:35

A query is a SQL statement that begins with the SELECT word. A stored query is called a view. The result of a query is stored in a result table, called the result-set. A query is itself a Relations - Cosette...

Data System Architecture
SQL - Data Definition / Data Dictionary Language (DDL)

Modified Monday 22-04 07:32

Data definition language (DDL) is a data manipulation statements that manages the data dictionary of a database. The three principal commands are: CREATE, ALTER, and DROP but you can also find: TRUNCATE to remove all records from a table,...

Counting Table
What is a Table in SQL?

Modified Monday 22-04 07:30

A table is: a SQL object with a relational data structure (ie a relation) that stores data queryrelation The name comes from the Abacuscounting table (abacus) that was found in the medieval counting houses. In the data model, tables may...

Event Centric Thinking
What is a Message in a Stream?

Modified Monday 22-04 07:14

This article talks a message in the context of a stream. A message is the atomic unit of data. A message in a stream is also known as: an event an object in motion a signal an item data emission, emits Event time = when it happentupl...

Map Of Internet 1973
What is a Message?

Modified Monday 22-04 07:12

A message is the common name given to the data unit in the higher end / applicative layer of the OSI model. As with every data unit, it's composed of: headers that define the metadata and a payload. HTTP Message Email Message stream message...

Jdbc Class Architecture
Jdbc - URL (and Driver Class)

Modified Saturday 13-04 11:56

JDBC is using URL to locate the database schema. Database URLs are strings that you specify for the value of the url property of the DataSource object. URL userNameuserPasswordencoded URL The java/sql/DriverManagergetConnection function gives the...


Recent Articles Created
How to create a date field in an HTML form? (at the month, day, hour and minute level)

Created Tuesday 09-04 09:35

This article shows you how to create a form control for date element at the: day second minute and month level The control are all input control with different type value. On a Year/Month/Day level, you use the date type. Example in Pure...

How to get and validate an email address with an HTML form?

Created Friday 05-04 07:25

This article shows you how to handle a email address into a form via an input element In HTML, they already have an email type in a input element. name is the name of the form variable. We choose email but it can be anything you want. Example:...

Examples of React Input Element with Class component

Created Saturday 23-03 06:10

This page keeps the example with class component for a input The react forms components input accept a value attribute that is used to implement a controlled component. A React form: written as a class component where the state is controlled...

Card Puncher Data Processing
What is a combobox?

Created Wednesday 20-03 09:23

A combobox is a combo of: an input and a listbox popup. In HTML, the built-in component is known as data list

Card Puncher Data Processing
What are Floating Lists (listbox popup)?

Created Wednesday 20-03 08:16

Floating lists are lists that are presented to the user in a overlay They are also known as listbox popup Type Focus after rendering Dropdown Element in the list Select Element in the list Autocompletion Search box, combobox or text area...

Card Puncher Data Processing
What is Autocompletion?

Created Wednesday 20-03 08:11

Autocompletion is a floating list that: presents to the user possible values that have been chosen from an input to complete or correct it Search autocompletion: when the user is typing a search term in a search box Entity autocompletion:...

React Typescript Children Override Error
How to define the React children type in Typescript?

Created Monday 18-03 10:27

This article will show you how to override/define the type of children of your react component to a specific type in your props. In this example, we have a layout component that expects only buttons as children to create a button bar. The base component...

Data System Architecture
What is a ligature?

Created Tuesday 05-03 01:36

A ligature is a font feature that allows the rendering of an icon glyph simply by using its textual name. A ligature maps a combination of basic characters to represent another character (code point). The replacement is done by the application (in...


Data all the way

Always keep one hand firmly on data, Amos liked to say.

Data is what set psychology apart from philosophy, and physics from metaphysics.

Amos Tversky (The undoing project)
Data Warehouse Subsystem

Data Warehouse Subsystems

Developing a data warehouse means assembling a lot of subsystems in order to create a whole and coherent data application.

Discovers the 34 Kimball Subsystems and drill down to discover them

Data Warehouse Subsystems

Card Puncher Data Processing

Data Processing

Data processing has changed a lot since 1940 :) and luckily, we are not using punch card anymore.

Stream processing is becoming the norm in data integration task while batch processing stays the king in data analysis.

Data Processing

ENIAC, 1946

The first fully electronic digital computer

Eniac 1946

Table Recursion Rectangle

Data Modeling

Data Modeling is the translation of process into the world of data. The process is tricky but not insurmountable.

Data Modeling

Snowflake
Dimensional Data Modeling

Dimensional Data Modeling permits you to model a (hyper)cube and analyse a process through different perspective. You define dimensions, measures and metrics.

Dimensional Data Modeling

Most programs process some input to produce some output; that’s pretty much the definition of computing.

Function Home

Function

A Function is the basic block of all reusable code component. It is also becoming the central component of any serverless architecture.

Function

Knowledge isn't free. You have to pay attention.

Computing Division at the Department of the Treasury, mid 1920s

Computing Division At The Dept Of The Treasur 1920

Remington Rand Univac

Medieval Counting Table

Table / Relation

The table format (known also as a relation) is the most important data structure used in data analysis. Did you know that its name originate from the medieval counting table ?

Table

Education isn't something you can finish.

Richard Feynman
Task Runner