- 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"
Open Source CMS and OPAC, Timely SQL, A Bid Secret, Basic Research
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.
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.