Feeds

* Posts by Destroy All Monsters

9984 posts • joined 3 Jun 2008

12 simple rules: How Ted Codd transformed the humble database

Destroy All Monsters
Silver badge
Windows

An interesting note found on a harddisk

In "The Genesis of a Database Computer - A conversation with Jack Shemer and Phil Neches of Teradata Corporation - IEEE Computer Nov. 1984":

This article gives the context of the The DBC/1012 system with two interface processors, four access module processors, and four Winchester disk units. When fully extended to 1024 processors operating in parallel, the system will be capable of storing a terabyte (trillion bytes) of data.

We read:

Shemer: Another factor [in building the database computer] was the relational data model - the fourth generation of database management software. People wanted it but could not afford it, nor was it practical. The reason was that it took a tremendous number of MIPS to deliver the functionality of a relational system. However, running the software on a mainframe practically relegated the big computer to the level of a personal computer. Consequently, the user environment has retained what I call the machine-friendly forerunners, namely the hierarchical and network database management systems that emerged in the 60's. These approaches were designed to process efficiently in single data stream machine environments, while the relational model admitted to parallel processing.

In the relational model, data is not explicitly ordered, since data items don't have pointers embedded in the data. Rather than traversing a family tree or hierarchy, you're dealing with rows and columns that represent the way most people like to view information. The relational system is synonymous with people-friendly; it's what people want, what the end user and the application programmer desire.

The big problem was to make the relational system cost- and performance-effective. The only way to do that was to provide a great many processing cycles at low cost.

...

Computer: It was an IBM scientist, E. F. Codd, who originally conceived the relational database model. What is IBM doing now?

Shemer: IBM has taken what I regard as a two-phased approach. On the one hand, it has IMS and DLl for the production environment. They use the hierarchical approach of the 60's, now almost 20 years old. IBM appears to be committed to that investment; it is telling users to keep IMS for high-volume applications. On the other hand, it has a new relational product called DB2 that is intended for the what-if query in the end-user environment. It is for the ultimate information user who may be a novice programmer or somebody not well versed in programming at all.

As I see it, IBM has effectively segmented the database world into two disjointed environments. It has essentially stated that the relational system it will deliver under DB2 is not efficient in accommodating production processing demands. In other words, keep IMS for account rendition, master file maintenance, etc., and use DB2 for what-if queries. It is a real dilemma for users. Moreover, this approach complicates matters. You already have an IMS database, let's say. To build a relational database, you have to have a utility program to extract information from the IMS master file. You now have two databases. What's more, they run on different machine environments, producing multiple versions of the truth. One file or the other is always out of date. Having two databases is a step backward, because one of the prime reasons for creating database management systems in the 60's was to allow multiple applications to have access to the same data. That data should have the same value at the same instant of time for both the production application environment and the what-if query environment.

1
1
Destroy All Monsters
Silver badge
Trollface

Re: Mainframe yes.. Website no.

a diabolically bad choice for Internet use

This is like saying internal combustion engines are a diabolically bad choice for automotive devices because then people will crash them, drive while being drunk or text their friends.

6
0
Destroy All Monsters
Silver badge
Holmes

Re: Relational ignored in 1976

Ok, in "Computer Data-Base (sic) Organization" by James Martin ("The most up-to-date and thorough guide to the techniques of data base organization"), 1975 by Prentice-Hall, ISBN 0-13-165506-X, (printed on excellent paper in black and pink) we read:

Part I (Logical Organization) Chapter 13: Relational Data Bases (pp 149-168)

"Data-base systems run the danger of becoming cumbersome, inflexible and problematic. The logical linkages tend to multiply as new applications are added and as users request that new forms of query be answerable with the data. A high level of complexity will build up in many data-base systems. Unless the designers have conceptual clarity they will weave a tangled web. It is possible to avoid the entanglements that build up in tree and plex structures, by a technique called normalization. Normalization techniques have been designed and advocated by E.F. Codd. ... The enthusiasts of normalization have a vocabulary of their own and a tendency to dress up a basically simple subject in confusing language. The table, like that in Fig. 5.3, is referred to as a relation. A data base constructed using relations is referred to as a relational data base."

There is also chapter 14: "Third Normal Form" ...

0
0
Destroy All Monsters
Silver badge
Trollface

Re: NoSQL

Ni SQL?

NI NI NI!

0
0
Destroy All Monsters
Silver badge
Big Brother

Re: reminds me of the Soviet propaganda tracts I had to study at university

But Soviet database are always CORRECT by order of the party

2
0
Destroy All Monsters
Silver badge

1) Gavin, you got a typo: "Turning Award"

2) Hands up who recognized the cover of the december 1972 issue of Communications of the ACM

1
0
Destroy All Monsters
Silver badge
Holmes

Re: There's much to be said on sql

The main thing to be said about SQL is that persons interested in learning about relational databases could do worse than check out Tutorial D.

2
0

Green German gov battles to keep fossil powerplants running

Destroy All Monsters
Silver badge
Holmes

Re: What they want to do is make money, and they will.

Why are "market manipulations" and "capped retail electricity prices" seen as separate items in that paragraph?

3
0
Destroy All Monsters
Silver badge
Holmes

Dragooned by Greenery

In truth, the recurrent panic spasms about "nucular energy" that can be reliably detected in Germany, Austria and Luxembourg are an interesting sociological phenomenon; what are are the historical reasons for them?

5
1

Intel to put pedal to metal in 14nm Atom upgrade

Destroy All Monsters
Silver badge

Fab 42

From Jimbo's emporium of knollij: On February 18, 2011, Intel announced that it will construct a new $5 billion fab in Arizona, designed to manufacture chips using 14 nm manufacturing processes and leading-edge 300 mm wafers. The new lab will be named Fab 42, and construction will start in the middle of 2011. Intel billed the new facility as "the most advanced, high-volume manufacturing facility in the world," and said it would come on line in 2013.

1
0

Apple co-founder Steve Wozniak disses Ashton Kutcher's Steve Jobs

Destroy All Monsters
Silver badge

Re: From out of that room came the future.

Nice Guy Wozzie sure should fit in.

0
0
Destroy All Monsters
Silver badge
Pint

Re: From out of that room came the future.

"Nobody really knows what happened in the rooms."

Apple Reservoir Dogs?

1
0

British spooks seize tech from Snowden journo's boyfriend at airport

Destroy All Monsters
Silver badge
Facepalm

Ve haf ways of making you vulvill our interrest!

In fact, however, it seems more likely that the spooks were primarily interested in any information they may be able to harvest from Miranda's gadgetry

Hey sure, I'm interested in ${CELEBS}'s vagoo. Doesn't mean I get to finger it.

0
0

Fooling the AppStore one code-chunk at a time

Destroy All Monsters
Silver badge
Holmes

The Halting Problem in different guises.

Correct. Thus, basically, the tests CANNOT catch malicious apps (except the most feeble ones). They can catch badly written apps though.

1
1
Destroy All Monsters
Silver badge
Paris Hilton

Re: Duh!

Errr... wrong thread?

0
0

IT now 10 percent of world's electricity consumption, report finds

Destroy All Monsters
Silver badge
Facepalm

Re: I wonder

That's because you confuse climate and weather.

And seriously, do you really believe you have found the one-liner killer argument against an army of PhDs who came up with the stuff you are saying there in the first place? Similar delusions can be found in religious cults...

1
1
Destroy All Monsters
Silver badge
Big Brother

Ban, tax, fine. Index, regulate, stimulate. Fight, impose, control.

ban

Always these statist cuss words.

2
1
Destroy All Monsters
Silver badge
Big Brother

Re: Only half the equation

If the paper price won't hold you back, the ink cartridge price will.

And we didn't even need a "paper sin tax" for that.

1
1
Destroy All Monsters
Silver badge

Switch on, brown out, peace green.

Can I get my CANDUs now?

How about NOW?

NOW?

No...

4
0
Destroy All Monsters
Silver badge
Holmes

Re: Is that all?

Don't enumerate your devices, just take a look at your smart meter and tell us what it says.

1
1

An afternoon with Phil Plait, the Bad Astronomer

Destroy All Monsters
Silver badge
Holmes

I don't know whether it was a Time Life book about "Spaceflight" (and another about "Energy") or the movie 2001 that did it. The books were mysterious because they had impressive illustrations - but I couldn't decipher the text. The movie was mysterious because they had impressive footage - but I couldn't decipher anything.

2001 was definitely responsible for the interest in IT.

Did I mention that Scott Aaronson's "Quantum Computing since Democritus" is out in book form?

1
0

SQUEEEEE! Microsoft goes retro with pay-by-squawk NFC tech

Destroy All Monsters
Silver badge

Re: "it works by having the *receiving* device transmit pseudorandom noise "

> parsing failure

Your real-world navigational capabilities need upgrading.

> But surely no one would be that stupid?

Yeah, key exchange exists for a reason, you know?

0
0
Destroy All Monsters
Silver badge
Holmes

Re: Got to hand it to Microsoft Research

I look for the inevitable downvotes from idiots who say "modems are prior art" because they don't understand the first thing about how patents are supposed to work or what they're for

Have a hearty downvote for:

1) Being whiney

2) Taking the psychological cop-out of calling others idiots before things even start

3) Thinking you are so superior on your gouty high horse

It's not hard to understand how patents are "supposed" to work (ha ha!) and what they are for. It's just very non-evident that they bring anything to the table except retard development of whole branches of industry for the benefit of a few - mainly lawyers and rent-seekers.

2
0

Card-cloning crooks use 3D printers to make ever-better skimmers

Destroy All Monsters
Silver badge
Trollface

Re: I worked with someone who discovered a skimming device.

Ok, so he would get out his phone, THEN two guys get out of a car and beat him up. Great.

He should have knifed the mofos. Deeply. Eleganty. While laughing hysterically.

It would look good on surveillance camera.

Ah, hold on. This is the UK, knives are considered weapons of mass destruction. Oh well.

1
1
Destroy All Monsters
Silver badge

The Halting Problem must already have been solved. Why didn't I hear of it?

0
0

Apple big-screen TV rumor zombie RISES FROM THE DEAD

Destroy All Monsters
Silver badge
Holmes

Re: Well, they are predictable

> Let's hope it's something other than a large, flat, black rectangular panel

My first thought was "it will be white, not black"

Then it occurred to me that Apple might make it black - if it looked like the monolith from 2001.

With content projected on its four visible surfaces.

From inside.

Suitable obeisance would have to paid by the unwashed masses if this was ever delivered to the living room.

You could probably download "Also Sprach Zarathustra" from iTunes for free as a gimmick.

0
0

Google goes dark for 2 minutes, kills 40% of world's net traffic

Destroy All Monsters
Silver badge

Re: Who the hell cares?

Jake, chill the hell out. This isn't the Waldorf & Stadler show.

7
1
Destroy All Monsters
Silver badge

It must be the changing alpha constant

Let's see whether Google rolls out one of those special occassion "Google" logos for this next year.

3
0

Court throws out Icahn's demand to stall Dell shareholder vote

Destroy All Monsters
Silver badge
Headmaster

Re: Cryptonomicon called.

Cryptonomicon NEVER gets old.

0
0

Microsoft warns of post-April zero day hack bonanza on Windows XP

Destroy All Monsters
Silver badge
Trollface

Nice OS you have there... shame if something happened to it...

I'm not sure if this is Bad Ballmer Steve's "The Operation", in which he promises to beat people up if they pay him the protection money, or whether it already is "The Other Operation", in which he promises not to beat people up if they don't pay him the protection money.

(This is of course a Flying Circus reference)

3
0

AREA 51 - THE TRUTH by the CIA: Official dossier blows lid off US secrets

Destroy All Monsters
Silver badge
Holmes

Re: @ Code Monkey

> If you want credible witnesses don't include people who lie for a living.

A peremtory statement if there ever was one. It also defeats itself.

2
0
Destroy All Monsters
Silver badge
Big Brother

Re: Astonishingly lovely but just a little bit threatening to look at.

> Still just an amazing demonstration of what the Advanced Projects Division could do with a small team of clueful engineers.

And infinite money. Mainly infinite money.

Industrial policy, wealth transfer, hidden taxation of the bonobos.

Sure you get a sleek looking craft out of it for a "Cold War" that was more fearmongering to biggen the brass than anything else. But still... it's like the mafia boss gives you a little duck after having collected the protection money.

0
0
Destroy All Monsters
Silver badge
Big Brother

Secrecy is good

Especially when you are a government fucking over the governees and disregarding any Elf and Safety because YOU CAN.

0
0
Destroy All Monsters
Silver badge
Alien

In truth, Area 51 has not much to do with UFO lore. It was tacked on much later. One could as well talk about Black Oil, Däniken, the Bermuda Triangle, Gurus calling the Endtimes and other commercial ideas.

0
1

Facebook's flush Sheryl Sandberg savaged over UNPAID intern advert

Destroy All Monsters
Silver badge

Retarded. Where is the problem, again?

Sounds like some people feel that someone is being forced to work no dosh.

I don't see that.

Not all.

> Unpaid work, be it internships for young women or volunteer positions for older moms, is exploitive.

Oh noes, we can't have that!

Here is the idea though: If you are unskilled, working unpaid *can* be a plus. This concept goes right over the head of the social studies students.

1
25

YouTube Wars: Microsoft cries foul as Windows Phone app pulled again

Destroy All Monsters
Silver badge
Holmes

Re: Some toy throwing going on here.

> IP law has provisions to allow reverse engineering

I don't think there are "laws" as such, but there were lengthy lawsuits creating precedence that you may (generally) not prohibit the reverse engineering of APIs (exceptions apply, please consult your lawyer etc)

0
0
Destroy All Monsters
Silver badge
Trollface

Cute!

Sounds like the kids of the post-MS era are now finding their way to the Reg Forums.

17
1

Open Rights Group revives 'unavailable for legal reasons' HTTP error code plan

Destroy All Monsters
Silver badge

Re: Nice idea, could do with tweaking

it's uncanny!

0
0

Telefonica and Arqiva set to mop up BILLIONS in smart meter cash

Destroy All Monsters
Silver badge
Headmaster

Mr. Moon-Watcher, I presume?

Your really need to work on using the indefinite articles like "a"...

0
0

NASA: Earth II may be hiding in unexamined data from injured Kepler

Destroy All Monsters
Silver badge
Trollface

"American parts; russian parts - all made in Taiwan."

Before exploring the galaxy one step at a time... one should maybe start by not getting the gyroscopes from the company "recommended" by Senator XY.

4
2

Apple files 'Bonk to Gift' near field communication patent application

Destroy All Monsters
Silver badge
Facepalm

Apple, a well-known grifter, not a gifter.

Next up: A patent on interactive web-based wedding gift lists managed on mobile devices.

The should be high monetary damages for even submitting such shite to the patent office.

8
0

PC market hits the ropes, but Lenovo's still standing

Destroy All Monsters
Silver badge
Headmaster

Re: Where did people get the idea that only Lenovo offer Win7?

Why would you want to "prove that a dislike is rational"? Nobody has got to prove anything. Are you implying that disliking Windows 8 is non-politically correct, racist, possibly antisemitic?

Dislike of Windows 8: There ought to be a law against it!

1
0

GitHub code repository rocked by 'very large DDoS' attack

Destroy All Monsters
Silver badge
Facepalm

Pretty bad trolling, or a guy who doesn't understand that github is not git or Linux.

16
0
Destroy All Monsters
Silver badge
Flame

... beset on all sides by the inequities of the selfish and the tyranny of evil men.

DDoS attacks are frequently used by hackers as a way of probing vulnerabilities in a site

Some probe. "probing" is more like "flattening" in this case.

I want the dox of those guys. And a shotgun.

3
0

'Database failure ate my data' – Salesforce customer

Destroy All Monsters
Silver badge
Holmes

Re: WTF!?

It would either cost millions, or it would save millions, depending on how the weatherwane of the casino was turning.

"PHEW---WE HAD DOWNTIME!"

We need an icon with a crazy monkey.

2
0
Destroy All Monsters
Silver badge
Childcatcher

Re: What do you mean...?

The cloud is based on Larry's stuff...

2
0

OWN GOAL! 100s of websites blocked after UK Premier League drops ball

Destroy All Monsters
Silver badge
Headmaster

Re: Are you watching Cameron

I never watch Cameron!

10
0

Possessed baby monitor shouts obscenities at Texas tot

Destroy All Monsters
Silver badge

Re: Huh?

> [a-z]{2}[0-9]{4}.myfoscam.org

Should at least be [some md5 hash].myfoscam.org

LE DESPAIR!

1
0
Destroy All Monsters
Silver badge
Headmaster

Patent, not Copyright.

A Copyright about something along those lines is held by the estate of Aldous Huxley.

4
0