Open Data provides social and economic benefit for governments and citizens. Mobile applications are an enabler for Open Data to reach a broad range of citizens. This book will provide an overview of both Open Data and mobile technologies. The book will also profile organizations that are active in advocating Open Data and provide the reader with a glimpse of how they can get involved within their own levels of government and join the growing interest toward becoming a Public Developer. It...

The implementation of stored procedures in MySQL 5.0 a hugemilestone -- one that is expected to lead to widespread enterprise adoption ofthe already extremely popular MySQL database. If you are serious aboutbuilding the web-based database applications of the future, you need toget up to speed quickly on how stored procedures work -- and how tobuild them the right way. This book, destined to be the bible of storedprocedure development, is a resource that no real MySQL programmer canafford t...

A fully updated, integrated self-study system for the Oracle Database SQL ExamThis thoroughly revised Oracle Press guide offers 100% coverage of all objectives on the latest version of the Oracle Database SQL Exam. Ideal both as a study guide and on-the-job reference, OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) features detailed explanations, examples, practice questions, and chapter summaries. “Certification Objectives,” “Exam Watch,” and “On the Jo...

Need to move a relational database application to Hadoop? This comprehensive guide introduces you to Apache Hive, Hadoop’s data warehouse infrastructure. You’ll quickly learn how to use Hive’s SQL dialect—HiveQL—to summarize, query, and analyze large datasets stored in Hadoop’s distributed filesystem.This example-driven guide shows you how to set up and configure Hive in your environment, provides a detailed overview of Hadoop and MapReduce, and demonstrates how Hive works within t...

Hadoop: The Definitive Guide helps you harness the power of your data. Ideal for processing large datasets, the Apache Hadoop framework is an open source implementation of the MapReduce algorithm on which Google built its empire. This comprehensive resource demonstrates how to use Hadoop to build reliable, scalable, distributed systems: programmers will find details for analyzing large datasets, and administrators will learn how to set up and run Hadoop clusters.Complete w...

This practical guide leads you through numerous aspects of working with PostgreSQL. Step by step examples allow you to easily set up and extend PostgreSQL. "PostgreSQL Server Programming" is for moderate to advanced PostgreSQL database professionals. To get the best understanding of this book, you should have general experience in writing SQL, a basic idea of query tuning, and some coding experience in a language of your choice.

Microsoft SQL Server provides many features for data manipulation. Now you can access SQL Server from Node.js application. This book helps you how to get started with Node.js and SQL Server. It covers how to prepare your development environment.***TOC***Preparing Development Environment1.1 SQL Server Driver for Node.js1.2 System Requirements1.3 Installing and Configuring1.3.1 Operating System1.3.2 Microsoft Windows SDK1.3.2.1 ...

In recent years, companies and government agencies have come to realize that the data they use represent a significant corporate resource, whose cost calls for management every bit as rigorous as the management of human resources, money, and capital equipment. With this realization has come recognition of the importance to integrate the data that has traditionally only been available from disparate sources.An important component of this integration is the management of the “metadat...

Pro Apache Hadoop, Second Edition brings you up to speed on Hadoop – the framework of big data. Revised to cover Hadoop 2.0, the book covers the very latest developments such as YARN (aka MapReduce 2.0), new HDFS high-availability features, and increased scalability in the form of HDFS Federations. All the old content has been revised too, giving the latest on the ins and outs of MapReduce, cluster design, the Hadoop Distributed File System, and more.This book covers every...

This book provides alternative approach to build PHP application with Windows/Linux platform and MongoDB database. It describes how to work with PHP and MongoDB and illustrates their use with code examples. The following is highlight topics in book:* Setup Development Environment* Hello World - PHP and MongoDB* MongoDB Authentication* Manipulating Database* CRUD Collection Operations* Working with Identity, Date and Time* Finding and Queryi...

This book helps you to get started how to build PHP programs which access PostgreSQL server. The following is highlight topics* Setting up Development Environment* Hello World - PHP and PostgreSQL* CRUD Operations* Working with Image and Blob Data* Transaction* Stored Procedures

How do you take your data analysis skills beyond Excel to the next level? By learning just enough Python to get stuff done. This hands-on guide shows non-programmers like you how to process information that’s initially too messy or difficult to access. You don't need to know a thing about the Python programming language to get started.Through various step-by-step exercises, you’ll learn how to acquire, clean, analyze, and present data efficiently. You’ll also discover how to automa...