Hola, soy Ricky Jonesy-Innit, jefe de Becci Boo Investments. La semana pasada nos despedimos de nuestro mejor operador de materias primas. Llevaba años trabajando con nosotros.
In data modelling and database design, keys play a fundamental role in uniquely identifying records and defining relationships between tables. One of the most widely used types of keys, especially in analytical systems and data warehouses, is the surrogate key.
A surrogate key is an artificial, system-generated identifier assigned to a record in a table. It is typically used as the primary key. It has no business meaning or semantic relationship to the real-world entity it represents. Common implementations include auto-incrementing integers or globally unique identifiers (GUIDs).
Surrogate keys exist purely to serve the needs of the database system: performance, stability, and simplicity.
A quiet disquiet has settled over the once-confident corridors of enterprise data. What was, not so long ago, regarded as a rigorous and rather specialised craft, data warehousing and business intelligence, now frequently presents itself in a more casual, even improvisational guise. A growing number of senior executives, technology directors and indeed practitioners themselves confess to a mounting discomfort with the quality, and at times the sheer quantity, of self-proclaimed experts who populate the field.
The origins of data warehousing are often pinned to the late 1980s, when the term “business data warehouse” first appeared in an influential IBM Systems Journal article by researchers Barry Devlin and Paul Murphy. I was based in Birmingham at that time, and I also wrote a similar foundational document on Information Centres for Sperry Univac.
Yet, as with many technological breakthroughs, the story is far richer and older than the conventional narrative suggests. The foundational components of what we now recognise as a data warehouse were quietly taking shape as early as the 1960s, driven by the need to organise, integrate, and analyse growing volumes of business information in an era of punch cards, magnetic tape, and the first mainframes.
CEOs are panicking. Again. They’re not worried about a recession. It’s not a hostile takeover. It’s not even the GDPR lurking in their inbox like a passive-aggressive ghost. They’re panicking because of AI. Yes, apparently there’s a talent gap. A yawning, gaping chasm of human inadequacy between what exists and what robots can do. Only the CEOs are brave. Some may even be desperate. They are the only ones who stare into it without blinking or vomiting on the nearest whiteboard.
When you have read this, if indeed you read it all, will I have failed to convey the essence of what I am trying to get at? Will a confusion of entropy win the battle? Will the wheel of fortune turn in my favour, or will I fail to connect and communicate effectively?
Clive:Yeah, well, you had to, didn’t you? You had to stand up for what you stood for, didn’t you? I mean, the only time I remember a similar occasion was, I was in, errm… I was at Spurs, Tottenham Hotspurs.
Derek:Yeah.
Clive:I was watching a game against Arsenal, and this bloke come up to me and said, “Hello”.