SQL is a poor relational data model implementation
on
An Alternative to SQL?
·
· Score: 3, Informative
I don't think lottameez's problem was so much with the concept of a join but the semantics of SQL and how it implements the relational data model.
SQL was a language designed to allow relatively unskilled operators to be quickly trained for data entry using the language directly, and thus it was designed to be English-like, flexible, and forgiving.
SQL is only vaguely reminiscent of the true mathematics behind the relational data model. It continues to be used and expanded, despite its restrictions and shortcomings, because it is far and away more popular than any other database language.
The fundamental assumption of the relational model is that all data is represented as mathematical relations, or rather, a subset of the Cartesian product of n sets. Unlike SQL, in the mathematical model reasoning about such data is done in two-valued predicate logic (that is, without a null value), meaning there are two possible evaluations for each proposition: either true or false. The data is operated upon by means of a relational calculus and algebra.
The relational data model permits the designer to create a consistent logical model of the information to be stored. This logical model can be refined through a process of database normalization. A database built on the pure relational model would be entirely normalized. The access plans and other implementation and operation details are handled by the DBMS engine, and should not be reflected in the logical model. This contrasts with common practice for SQL DBMSs in which performance tuning often requires changes to the logical model.
OTP will always remain a viable means of private key cryptography. When you interleave signal with noise, the result will always have the properties of noise.
The solution is, in my opinion, to first move away from BitTorrent for content distribution. There are significantly more flexible, powerful, and elegant protocols ready to take its place such as PDTP which could be used for distribution of the actual RSS feed.
The next step would be some sort of UDP beaconing system, where clients periodically "ping" a beacon saying they want updates pushed to them, and the server will periodically "beacon" with the latest available content of a given type until a TTL expires, provided they don't receive a "ping" from the client before that.
There are numerous unconfirmed reports coming primarily from the nmap mailing list that SP2 has removed support for raw sockets. However the ping and tracert utilities, both of which use raw sockets, still seem to function correctly. Perhaps only signed executables can use the raw sockets interface?
Is EM not the most likely medium for wide-beam transmission? Lasers are completely ridiculous... it's a tight beam transmission taken to an extreme. We have no idea how other civilizations could be reaching out... perhaps they're using gravity waves, or perhaps they've discovered some sort of faster-than-light system of communications which they have been signaling other races with but we are too ignorant to perceive. In all likelyhood EM is the best way of reaching out to other civilizations, and while we may not be talking yet to any siginicant degree I can't argue with listening...
What are you doing that can't just as easily be accomplished with an XBox and wireless controller? It would seem to me that trying to use a computer is the fallacy of your approach. Having built two computer systems to attach to my projector and having significant frustration with both of them, I wholeheartedly recommend an XBox for what you are attempting to accomplish.
I think one of the great advantages of XBox Media Center is that it also doubles as an excellent shell/launcher (especially with its built-in FTP support) and replaces both applications like EvolutionX which was a dedicated launcher and the now defunct XBox Media Player. No other dedicated media device offers such integration between shell/player... on Windows they're two seperate applications which don't seem to integrate particularly well.
...the PowerPC core is really fast and really tiny (leaving lots of room on the chip for customization), and also because the PowerPC architecture is amenable to being coupled with more than one additional coprocessor. This explains its success in highly specialized environments like set-top boxes or the GameCube and Playstation2 video game consoles.
Correct me if I'm wrong, but isn't the PlayStation 2's EmotionEngine processor a proprietary MIPS-derived ISA?
"Apple has over the last year been quietly developing a digital-rights management software technology called Fairplay. What it does is allow you to do things that generally you're already allowed to do with CDs."
Admittedly a non-technical description.
I think it's far more likely that Apple simply bought ought this "VeriDisc" company. Going by their web site (now accessable via IP address only) they haven't done anything since 2001...
I'm highly suspect of anyone who claims that Apple "licensed" FairPlay from a company which now no longer seems to exist...
Slashdot Mirror
SQL was a language designed to allow relatively unskilled operators to be quickly trained for data entry using the language directly, and thus it was designed to be English-like, flexible, and forgiving.
SQL is only vaguely reminiscent of the true mathematics behind the relational data model. It continues to be used and expanded, despite its restrictions and shortcomings, because it is far and away more popular than any other database language.
The fundamental assumption of the relational model is that all data is represented as mathematical relations, or rather, a subset of the Cartesian product of n sets. Unlike SQL, in the mathematical model reasoning about such data is done in two-valued predicate logic (that is, without a null value), meaning there are two possible evaluations for each proposition: either true or false. The data is operated upon by means of a relational calculus and algebra.
The relational data model permits the designer to create a consistent logical model of the information to be stored. This logical model can be refined through a process of database normalization. A database built on the pure relational model would be entirely normalized. The access plans and other implementation and operation details are handled by the DBMS engine, and should not be reflected in the logical model. This contrasts with common practice for SQL DBMSs in which performance tuning often requires changes to the logical model.
I think you mean the speed of electrons. Electrons can't travel the speed of light (in a vacuum)
Sounds like something PDTP could solve...
I remember that story too! Fortunately I'm not the only one, and it appears you beat me to the punch :)
Haven't heard of Kazaa Lite Resurrection?
...is here!
OTP will always remain a viable means of private key cryptography. When you interleave signal with noise, the result will always have the properties of noise.
The next step would be some sort of UDP beaconing system, where clients periodically "ping" a beacon saying they want updates pushed to them, and the server will periodically "beacon" with the latest available content of a given type until a TTL expires, provided they don't receive a "ping" from the client before that.
There are numerous unconfirmed reports coming primarily from the nmap mailing list that SP2 has removed support for raw sockets. However the ping and tracert utilities, both of which use raw sockets, still seem to function correctly. Perhaps only signed executables can use the raw sockets interface?
Is EM not the most likely medium for wide-beam transmission? Lasers are completely ridiculous... it's a tight beam transmission taken to an extreme. We have no idea how other civilizations could be reaching out... perhaps they're using gravity waves, or perhaps they've discovered some sort of faster-than-light system of communications which they have been signaling other races with but we are too ignorant to perceive. In all likelyhood EM is the best way of reaching out to other civilizations, and while we may not be talking yet to any siginicant degree I can't argue with listening...
The GBA and the GBA SP had a kid!
PDTP usage surpasses BitTorrent...
PDTP usage outranks BitTorrent
Oh wait, you did...
Are you sure that wasn't performed with photons? I'm fairly certain this is the first time the characteristics of atoms have been transferred...
Anyone else think this name is reminiscent of Days of Future Passed, the album on which Nights in White Satin appeared?
What are you doing that can't just as easily be accomplished with an XBox and wireless controller? It would seem to me that trying to use a computer is the fallacy of your approach. Having built two computer systems to attach to my projector and having significant frustration with both of them, I wholeheartedly recommend an XBox for what you are attempting to accomplish.
Except it's in Japan, land of infinite bandwidth...
That's not to mention the fact that a $20 box buys you HDTV component video output as well
I think one of the great advantages of XBox Media Center is that it also doubles as an excellent shell/launcher (especially with its built-in FTP support) and replaces both applications like EvolutionX which was a dedicated launcher and the now defunct XBox Media Player. No other dedicated media device offers such integration between shell/player... on Windows they're two seperate applications which don't seem to integrate particularly well.
Speaking of which, the fish that seagull is holding looks a bit too happy for the situation he's in...
Seems like a dupe to me...
Apple bought VeriDisc. They didn't license FairPlay; they own it.
Correct me if I'm wrong, but isn't the PlayStation 2's EmotionEngine processor a proprietary MIPS-derived ISA?
According to Forbes, Apple developed it themselves:
Admittedly a non-technical description.
I think it's far more likely that Apple simply bought ought this "VeriDisc" company. Going by their web site (now accessable via IP address only) they haven't done anything since 2001...
I'm highly suspect of anyone who claims that Apple "licensed" FairPlay from a company which now no longer seems to exist...