Posts by AceRimmer
328 posts • joined Monday 15th June 2009 07:57 GMT
@acobley
If you were storing tweets you would want to break each tweet down before storing it:
A back of a fag packet design would give you:
1 table containing all @ mentions in the tweet
1 table containing all hashtags in the tweet
1 table containing all words in the tweet (with a position indicator)
other tables might store all sentences or recognized word combinations in the tweet of which "the register" might be one.The ETL feed would run against a master data table which itself could be populated from mined data from the previous million or more tweets
Storing the data in this way would mean that it could be properly indexed in the RDBMS and avoid the use of the dreaded '%the register%' comparison which would kill query performance.
@Kubla Cant
In an RDBMS system the level of at which the data is deemed to be atomic is determined by the database design. Each column holds one piece of information.
If the system using the database needs to be concerned with the individual characters in a string then a string is no longer atomic and storing that data as a string is breaking a fundamental RDBMS rule.
To put it another way, you wouldn't store comma separated values in a database column, you would split those values out into proper columns or rows depending upon the structure of the data. The exception to this would be if the database or the systems that used it were designed to not care what was in the string or care that it was comma separated values; it is just a string to be stored, read and reproduced as is.
This is also why database designers HATE free text fields, they always end up being abused and used as data stores for non-atomic data as a short cut for changing the database and/or user interface
(I think the DOB was a typo that got past the editor)
Re: Why?
A thousand apologies in advance to the commentard grammar nazis for using "your" in place of "You are"
Re: Why?
Your thinking of unlocking from carrier restrictions. i.e. which SIM cards will work inyour phone.
This unlocking removes the OS level restrictions of what the user is allowed to do/install on their phone.
Re: Hackers these days...
Given how long its been around, I'd have thought that l33tspeak would be out of fashion with teenagers by now
Re: Order posts by postdate
and is preferably tapatalk compatible
Re: How many creatures do humans kill each year to feed cats ?
"This is because when salmon are in abundance the bear will eat just the most nutritious parts, such as the head, and leave the rest for scavengers. This behaviour does not show "greed" as you seem to think, it is simply the most efficient strategy for the bear in times of abundance. When salmon are fewer they will eat the entire thing."
The bears don't leave the fish for the scavengers, they just leave the fish. Scavengers happen to pick them up afterwards but this is of no concern of the bears
At a fundamental level greed is energy efficiency. Grab what you can now whilst its easy and to hell with every one else.
Re: Where are we?
"WTF is a BluRay Monday?"
Its a High Definition Monday, which seems like a waste, I'd rather have a High Definition Saturday and Sunday
Re: How many creatures do humans kill each year to feed cats ?
"I have much respect for animals, they are not motivated by greed."
All animals will consume as much as they can, in the wild there are usually limiting factors outside of their control.
Re: Surface - if you buy one and then jump through hoops to work around its failings
My 64GB iPad is full, excuse me whilst I go and copy its entire contents to a brand new 128GB iPad
The story exists to counteract the large number of tech articles which have appeared over the last 24 hours praising apples bold move and saying that the android tablet manufacturers will be shitting themselves:
http://www.forbes.com/sites/ewanspence/2013/01/29/apples-128gb-ipad-just-gave-every-android-tablet-manufacturer-a-headache/
http://www.technologyreview.com/view/510506/with-a-128gb-model-ipad-throws-down-to-surface/
At what point
is it cheaper and simpler to build a jet engine rather than build a simulation of one?
Re: I admit
Not really
unless
1. People in the future start walking round with their arses hanging out (could happen!)
or
2. The grannie ends up old and bitter about life and the tattoo is a reminder of something unpleasant.
But having made that comment I assume you don't have tattoos.
Re: One of these is false
Re: I'm no expert, but...
I'm pretty sure that the masses already own iPhones
Re: Kids taught to use Windows, which is inferior proprietary software
Last time I checked, the "computer" on a Raspberry Pi was encased in a square of plastic about the size of a postage stamp and completely hidden from view. Not that I would be able to see how it works without a decent microscope anyway!
Re: Battleship?
Now you've told me that, I've gone from indifferent to actually wanting to watch it
Thanks!
Re: Should be free
The pupils probably are entitiled to a MS Office license to use at home, Microsoft licenses for students means that the licenses which the schools buy for use in the school can (under the right circumstances) also be extended to the students using the software outside of the school too
Check out student licencing here:
http://www.microsoft.com/uk/education/schools/software-licensing/types-of-educational-licence/SESP-agreement/default.aspx
Re: Surely...
More of a language fail than a sarcasm fail, I think he meant something along the lines of:
Even instant coffee is better than no coffee.
which would be analogous to :
Even bad sex is better than no sex
Which, as a dedicated coffee drinker, I can definitely agree with.
Re: No sunglasses needed
Needs more alliteration:
I guess you could say that "The ho's blows came to blows between bros".
Re: Docking Station...
Thumbs down for stating a fact...
is that because you disagree with the USB3.0 port replicators?
or
was I wrong?
or
Did I deliver the message in a less than pleasing manner?
Re: Docking Station...
It has USB 3.0 so you can use a port replicater stuffed into one of the two USB 3.0 ports
Most manufacturers seem to be going this way, rather than the propriety docking stations.
I really hope
That isn't a pube stuck to the keyboard in the in photo
Juicy
I just got a home signal box from Three, it took only 3 phone calls in the end, 1 to technical support and then 2 calls with the 2nd line network support.
Currently got two £35pm phone contracts with Three and a mifi dongle which probably helps!
I am about to cancel one of the contracts anyway as its passed it's minimum term and no longer needed but decided to wait until after the home signal has been delivered and proved its worth before doing so.
Re: Satnavs - The curse of modern driving
To be fair, she sounds like the type of driver who, if not setting the sat nav will be doing her nails or something equally stupid at the same time as driving.
Re: What are they thinking/smoking?
Sounds like a PadFone
Environmental Campaigners
Once these bad boys are landing at Heathrow and the third runway is deemed unecessary the enviro-nutters should be satisified
Re: To date? No complaints. My completed systems work.
Then I bet you don't do SAP; everything I hear about them usually has references to the word clusterfuck.
Surprised you can hear that over the constant Kerching noises
Re: @Stacy: (was: Whatever. It's SOLSTICE! Celebrate!)
"Seasons are a construct "
Really? Try looking outside once in a while and pay attention to what nature is telling you
Re: Brazil a 'developing country' ?
Developing in that the economy hasn't fully matured yet.
Bit like a baby elephant, just because its fucking big doesn't stop it being a baby!
Re: Just cool.
you could be that dad
Posted in Do users have enough power?
Useful comparison
Power for users is like protesting for plebs.
Give them just enough leeway to make them think they have freedom but make sure your security forces can cope with anyone that tries to push it too far
Re: Apple=Bastards
"Speaking of which, no need to drag lefties into it."
is "Secondary Hand Browsing" PC enough for ya?
Paris, for whom the term was invented
Re: Maybe ElReg could hire these guys to make the videos work on The Register's site
Apart from the new wave of web hipsters, who uses Vimeo anyway?
Re: I've said it before and I'll say it again....
I can't recall any? Feel free to provide examples.
Ahem:
http://www.guardian.co.uk/uk/2006/aug/16/military.immigrationpolicy
Re: Hear, hear!
still remembered at least partly as "that guy who committed suicide after being sent down for being gay".
I don't think that being pardoned will change that, except for:
"that guy who committed suicide after being sent down for being gay and was pardoned some 58 years after his death"
Posted in The best smartphones for Christmas
Re: I don't want a big smart-phone!
Then don't buy a big smart-phone!
Re: New Tax Rules
Subtly different and wide open to companies setting whatever price they like for "intellectual rights" hence the current state of affairs.
Transfer pricing is supposed to be governed by the arms length pricing principle but that's generally ignored
Re: Good ol' Google
as far as I know Google doesn't drive, need education, swim, go for long walks in the park or go shopping
Bin collections and emergency services are covered by business rates which Google will be paying already
Re: What are people whining about?
Changing the law internationally will also mean other countries losing out on tax they are already getting. I don't think that any country would want to change their tax law to help another country get more tax
Re: New Tax Rules
Their, they're; yule be home soon mr Grammar Nazi
New Tax Rules
They just need to tax transactions between a company and it's overseas counterparts (and other linked companies) when dealing in intangible assets (trademarks, logo's etc...)
For physical items, any transactions above the accepted market value should be taxed. e.g. if coffee is generally £1 per kilo and Starbucks NL was selling coffee to Starbucks UK at £3 per kilo then tax would be due on the £2 difference.
Re: Just shoot the lawyers
Done and Done
You did mean ALL lawyers right?
Hiding Replies
One thing I have noticed is how replies to the first post can result in the second post being shoved further down the page or sometimes even onto page 2.
Given that most of these long reply chains are of little real value and just offer entertainment as either a troll gets lambasted or a couple of commentards slug it out, could all replies except the first 3 or 4 be hidden unless requested.
There is an example of it in action here:
http://menmedia.co.uk/manchestereveningnews/news/s/1595915_census-2011-manchester-revealed-as-capital-of-single-people-with-no-religious-faith#comments
Re: 2.55 MBPS??
Thats NOT the average internet speed. Its the average speed for watching netflix movies
The users could be doing other browsing at the same time and the netflix service might top out at about 2.5-2.6mbs anyway.
The importance in the figures is the difference between the ISP's when using the netflix service/
