background preloader

WashPost Databases

WashPost Databases

Big Data: A New Approach to Finding Info A breakthrough method to graphically represent knowledge enables software developers to easily build intelligent agents such as Apple's Siri and IBM Watson. Nov 16, 2011, San Diego, CA - Artificial intelligence vendor ai-one will unveil a new approach to graphically represent knowledge at the SuperData conference in San Diego on Wednesday. The discovery, named ai-Fingerprint, is a significant breakthrough because it allows computers to understand the meaning of language much like a person. Ondrej Florian, ai-one's VP of Core Technology invented ai-Fingerprints as a way to find information by comparing the differences, similarities and intersections of information on multiple websites. "The big idea is that we use artificial intelligence to identify clusters and show how each cluster relates to another," said Florian. The ai-Fingerprint is the collection of all the keywords and their associations identified by ai-one's Topic-Mapper tool.

Datasets on Datavisualization Wikileaks US Embassy Cables 29 Nov 2010 Datasets Infographic, Politics Wikileaks began on Sunday November 28th publishing 251,287 leaked United States embassy cables, the largest set of confidential documents ever to be released into the public domain. Here's how media outlets strive to make the data more accessible than its original form. Read more New Twitter Data from Infochimps 28 Apr 2010 Datasets Internet, Twitter Infochimps, the open marketplace for data, just released their updated Twitter Census dataset with over 1.6Billion Tweets. Searchable World Government Data 25 Jan 2010 Datasets Government, Politics Governments around the globe are opening up their data vaults – allowing people to check out the numbers for themselves. USA and China Leading in Carbon Emissions 09 Dec 2009 Datasets, Showcases BubbleChart, Environmental, Politics Simon Rogers from the Guardian Data Blog takes a look at the latest (2007) figures about carbon emissions per country. Google: Zeitgeist 2009

MySQL Database Articles & Tutorials - Database Journal In the Importing XML Data into MySQL Tables Using a Stored Procedure article, Rob Gravelle outlined some ways to work around MySQL's restrictions on stored procedures to import XML data into your MySQL database tables. Today's article covers how to use a Prepared Statement, including error handling and validation, as well as handling additional XML formats. In theory, it would seem that a stored procedure would be the perfect vehicle for importing XML data from a file, and yet, the LOAD XML INFILE statement cannot be run within a Stored Procedure. Fortunately, there is a way to get around this limitation. Ever since Oracle became the owner of MySQL when it acquired Sun Microsystems in 2010, improvements to the software haven’t been as forthcoming as one might hope. There are a lot of occasions for converting one data type to another in MySQL. Over time, applying the same rounding algorithm to many numbers can lead to a condition known as rounding bias. MySQL Archives

Media Map Shows Impact of Information (December 5, 2011) How do we know that media make a difference? We’ve looked at the numbers. The Media Map Project, a multi-faceted research collaboration between Internews and The World Bank Institute, has made 25 data sets which collectively touch on every country in the world and up to 30 years' worth of information available to the public for download and analysis. Visualizations on the site allow viewers to interact with and test the data in different ways. Correlation between economic performance (GDP) and freedom of expression / freedom of the press For example: Map the Numbers shows country-by-country scores for indices like the World Press Freedom Index, number of Internet Users per 100 people, and the Voice and Accountability Index. Additionally, all the data featured on the site is available for free download. "We're thrilled to be able to offer this data to the public," said Tara Susman-Peña, Director of Research for the Media Map Project at Internews.

Data Wrangler UPDATE: The Stanford/Berkeley Wrangler research project is complete, and the software is no longer actively supported. Instead, we have started a commercial venture, Trifacta. For the most recent version of the tool, see the free Trifacta Wrangler. Why wrangle? Ultimate Web Guide to SQL Database Language | Intuit QuickBase General Information SQL stands for Structured Query Language and is a computer language that is used to interact with and manage a database. It is the most widely used language used to manage databases. One thing that is important to note is that SQL is not a specific database system, there are many database systems that use SQL. The most commonly used is MySQL, however there are dozens of different systems, including Microsoft SQL, and Oracle as well as many lesser known systems. SQL tutorial from W3Schools SQL tutorials with a lot of help with query commands SQL tutorials from 1keydata SQL Course Installing SQL When installing SQL, it is important to first decide which database system you want to install. XAMPP for Windows/Linux/Mac WAMP for Windows How to build a LAMP server How to install LAMP on Ubuntu Creating a Database Creating a database with SQL is incredibly easy. SQL create database statement Using the create command Creating a Database Table Primary and Foreign Key PHP and SQL

Cartographie de l’information : gadget ou outil d’entreprise ? » Les points de même couleur et proches représentent des individus ayant des similarités (lieu de travail, entreprise par exemple) et / ou partageant un ensemble contacts en commun. Alors que l’on parle souvent de surabondance de l’information et que l’on cherche des remèdes pour diminuer ou minimiser ce flux d’information, la cartographie peut être un premier élément de réponse. Sans résoudre le fond du problème – s’il en est vraiment un – la cartographie de l’information dispose de plusieurs atouts face à des stocks et des flux d’information qui sont de plus en plus importants. Tout d’abord, la cartographie de l’information structure l’information. Mais l’on pourrait dire que sur le fond, ces atouts sont plus liés à du calcul statistique (un des exemples est le text mining pour identifier les thèmes et termes saillants permettant de construire des cluster) ou à l’exploitation des méta données des objets observés, plus qu’à la cartographie elle-même.

Setting Data Free With Gapminder Last month Hans Rosling, the Swedish global health professor, statician and sword swallower released a desktop version of Gapminder World, his mesmerizing data visualization tool. Named one of Foreign Policy’s top 100 global thinkers in 2009, the information design visionary co-founded Gapminder.org with his son and daughter-in-law aiming to make the world’s most important trends accessible and digestible to global leaders, policy makers and the general public. The software they developed, Trendalyzer, (acquired by Google in 2007) translates static numbers into dynamic, interactive bubbles moving through time. Emily Cunningham is a research intern at ReadWriteWeb and a design and user experience intern at OpenMRS.org. What is Awesome Many of same things that make the Web-based version of Gapminder a great tool applies to the desktop version: Graphs are highly dynamic and yet easy to understand and create. Benefits specific to Gapminder Desktop include: What Needs Work In a word: social.

iOS 5 iPad Database Implementation using SQLite From Techotopia Whilst the preceding chapters of this book have looked at data storage within the context of iOS 5 iPad based applications, this coverage has been limited to using basic file and directory handling and object archiving. In many instances, by far the most effective data storage and retrieval strategy requires the use of some form of database management system. In order to address this need, the iOS 5 SDK includes everything necessary to integrate SQLite based databases into iPad applications. [edit] What is SQLite? SQLite is an embedded, relational database management system (RDBMS). SQLite is written in the C programming language and therefore using SQLite on the iPad involves direct calls to C functions and access to C data structures. [edit] Structured Query Language (SQL) Data is accessed in SQLite databases using a high level language known as Structured Query Language. [edit] Trying SQLite on MacOS X sqlite3 . sqlite> .tables contacts To insert records into the table:

Public Data Explorer Eurostat, Indicateurs démographiques Eurostat Indicateurs démographiques annuels. Ce jeu de données a été préparé par Google à partir de données téléchargées depuis le site d'Eurostat. Chômage en Europe (données mensuelles) données sur le chômage harmonisé pour les pays européens. Salaire minimum en Europe Salaire mensuel brut minimum en euros ou parités de pouvoir d'achat, données semi-annuelles. Dette publique en Europe Statistiques sur les finances publiques des pays européens. Transport routier en Europe Statistiques du transport routier pour les pays européens.

New York Times - Linked Open Data 15 Highly Useful MySQL Resources And Tutorials Today we are going to discuss about MySQL Database. Currently MySQL is the most popular Open Source, Robust and fast Database Server. This Database is written in C and C++ and most commonly used with PHP scripts to develop secure and dynamic server-side application. MySQL is powerful database product that works with all operating systems and support many of languages like PHP, PERL, C, C++ and JAVA also. Now a days, MySQL database is used by developers in a massive range and support for very large databases. MySQL also supports Stored-procedures, Triggers, cursors and also ACID compliance. The most powerful plus point of MySql Database, if you want to working with this server then there is no need to take license for using because its has Open Source nature. We always trying to provide some useful and high quality resources for our readers. 1) Official Home Of MySql 2) W3Schools.com 3) MySql Basics 4) Tutorialized.com 5) Tizag MySql Tutorials 6) Tutorialspoint.com 7) MySql Forge 9) Devshed.com

STATS - MDGs Indicators Datavisualization.ch Selected Tools

Related: