- Scriblio — open source CMS and catalogue built on WordPress, with faceted search and browse. (via titine on Delicious)
- Useful Temporal Functions and Queries — SQL tricksies for those working with timeseries data. (via mbiddulph on Delicious)
- Optimal Starting Prices for Negotiations and Auctions –Mind Hacks discussion of a research paper on whether high or low initial prices lead to higher price outcomes in negotiations and online auctions. Many negotiation books recommend waiting for the other side to offer first. However, existing empirical research contradicts this conventional wisdom: The final outcome in single and multi-issue negotiations, both in the United States and Thailand, often depends on whether the buyer or the seller makes the first offer. Indeed, the final price tends to be higher when a seller (who wants a higher price and thus sets a high first offer) makes the first offer than when the buyer (who offers a low first offer to achieve a low final price) goes first.
- WiFi Science History — Australian scientist studies black holes in the 70s, has to develop a way of piecing together signals that have been distorted as they travel through space. Realizes, when he starts playing with networked computers in the late 80s, that this same technique would let you “cut the wires”. A decade later it emerged as a critical part of wireless networking. As Aaron Small says, it shows the value of basic research, where you don’t have immediate applications in mind and can’t show short-term deliverables or an application to a current high-value problem.
ENTRIES TAGGED "sql"
Four short links: 10 December 2009
Open Source CMS and OPAC, Timely SQL, A Bid Secret, Basic Research
Counting Unique Users in Real-time with Streaming Databases
As the web increasingly becomes real-time, marketers and publishers need analytic tools that can produce real-time reports. As an example, the basic task of calculating the number of unique users is typically done in batch mode (e.g. daily) and in many cases using a random sample from relevant log files. If unique user counts can be accurately computed in real-time, publishers and marketers can mount A/B tests or referral analysis to dynamically adjust their campaigns.
Four short links: 14 August 2009
EPub FTW, SQL Horror, Computer Vision Explained, and A Massive Dump of Twitter Stats
- Page2Pub — harvest wiki content and turn it into EPub and PDF. See also Sony dropping its proprietary format and moving to EPub. Open standards rock. (via oreillylabs on Twitter)
- SQL Pie Chart — an ASCII pie chart, drawn by SQL code. Horrifying and yet inspiring. Compare to PostgreSQL code to produce ASCII Mandelbrot set. (via jdub on Twitter and Simon Willison)
- How SudokuGrab Works — the computer vision techniques behind an iPhone app that solves Sudoku puzzles that you take a photo of. Well explained! These CV techniques are an essential part of the sensor web. (via blackbeltjones on Delicious)
- Twitter by the Numbers — massive dump of charts and stats on Twitter. I love that there’s a section devoted to social media marketers, the Internet’s head lice. (via Kevin Marks on Twitter)
Big Data: Technologies and Techniques for Large-Scale Data
Our belief that proficiency in managing and analyzing large amounts of data distinguishes market leading companies, led to a recent report designed to help users understand the different large-scale data management techniques. Our report on Big Data Technologies was the result of interviews with over thirty experts, including research scientists, (open-source) hackers, vendors, data analysts, and entrepreneurs. I recently sat down with my co-author, Roger Magoulas (Director of Research at O’Reilly), who agreed talk about our report and Big Data in general.
Radar 
Radar on 
Radar on 
Radar on 
Radar on 