Skip to content

Software Development News: .NET, Java, PHP, Ruby, Agile, Databases, SOA, JavaScript, Open Source

Methods & Tools

Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!

Database

Real-time predictive analytics in the cloud

Predictive analytics has greatly empowered organizations across industries. One of the key benefits of predictive analytics centers on the ability to shorten decision cycle times, which enables organizations to improve risk management, customer responsiveness, marketing, and supply chain. This is not a small feat given that the ever growing stream of data can be daunting, but when data is effectively captured and analyzed, organizations can gain a distinct and game-changing advantage.

How are financial services, life sciences, retail, technology, and manufacturing organizations increasingly perfecting the art and science of insights generation at scale from event streams and real-time data? Find out by attending our upcoming webinar: Real-time predictive analytics in the cloud.

During our live webinar Krishna R, Regional Head, Mu Sigma, and guest speakers Mike Gualtieri, Principal Analyst, Forrester Research, Inc. and Roger Barga, Group Program Manager, Microsoft will shed light on the rapid, seamless and cost-effective deployment of real-time predictive analytics on the cloud. 

Register for Real-time predictive analytics in the cloud – June, 25, 2014 9AM PST

Categories: Database

Integrate DB2 for z/OS with InfoSphere BigInsights, Part 1: Set up the InfoSphere BigInsights connector for DB2 for z/OS

IBM - DB2 and Informix Articles - Tue, 06/17/2014 - 05:00
Learn how to set up integration between IBM DB2 11 for z/OS and IBM InfoSphere BigInsights. Enable access to structured and non-structured data that is stored in the Hadoop Distributed File System and send the results back to DB2, where the data can be integrated with online transactional data. Using a scenario that is common to all DB2 for z/OS users, learn to create a big data solution that uses the user-defined functions JAQL_SUBMIT and HDFS_READ to run jobs on InfoSphere BigInsights and retrieve the results with SQL.
Categories: Database

Do You Really Need to Tune Big Data Applications?

Database Journal News - Mon, 06/16/2014 - 08:01

Big data applications are here to stay. The promise of this technology is the ability to quickly and easily analyze large amounts of data and derive from that analysis changes to customer-facing systems. Management believes that the analysis and subsequent changes will drive up customer satisfaction, market share and profits, hopefully at a reasonable cost.

Categories: Database

Database Monitoring Key to Reducing Security Breaches

Database Journal News - Fri, 06/13/2014 - 14:30

Only 48 percent of respondents to a recent survey indicated that they test or validate third-party software to ensure it's not vulnerable to SQL injection.

Categories: Database

"The Chain Gang", a Riveting Tale of Chained and Migrated Rows in Oracle

Database Journal News - Thu, 06/12/2014 - 08:01

Chained and migrated rows in an Oracle database can adversely affect I/O performance, especially Exadata.  Read on to discover how these rows are generated and what you may be able to do to correct the situation.

Categories: Database

Calculate storage capacity of indexes in DB2 for z/OS

IBM - DB2 and Informix Articles - Thu, 06/12/2014 - 05:00
With the drastic growth of data stored in IBM DB2 tables, index sizes are bound to increase. Most indexes are still uncompressed, so there's an urgent need to monitor indexes to avoid unforeseen outages related to index capacity. This article describes a process to calculate the capacity limit for various types of indexes. Once you know how to calculate the capacity of indexes in different situations, you can monitor their growth to avoid outages.
Categories: Database

Convert row-organized tables to column-organized tables in DB2 10.5 with BLU Acceleration

IBM - DB2 and Informix Articles - Thu, 06/12/2014 - 05:00
With IBM DB2 10.5 you can easily convert row-organized tables to column-organized tables by using command line utilities or IBM Optim Data Studio 4.1. This article introduces two approaches for table conversions: the db2convert command and the ADMIN_MOVE_TABLE stored procedure. We also describe a manual conversion. Learn the advantages and disadvantages of the different conversion approaches. Best practices are also discussed.
Categories: Database

SQL Server 2012 SP2 is now available!

Microsoft is pleased to announce the release of SQL Server 2012 Service Pack 2. The Service Pack is available for download on the Microsoft Download Center. As part of our continued commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2012 deployments.

SQL Server 2012 SP2 contains fixes to issues that have been reported through our customer feedback platforms and Hotfix solutions provided in SQL Server 2012 SP1 cumulative updates up to and including Cumulative Update 9.  Service Pack 2 also includes a handful of design change requests and fixes for issues that have been reported through Windows Error Reporting system.

A few customer-requested updates in Microsoft SQL Server 2012 SP2 are:

  • Enhanced informational messages about AlwaysOn availability groups.  Support for COPY_ONLY backups of an AlwaysOn secondary through DPM.
  • Support for local cube creation.  More Analysis Services and Reporting Services logging to improve troubleshooting.
  • Performance improvements for SQL Server Integration Services around SSIDB deadlock/cleanup.
  • Query planning enhancements and improved troubleshooting diagnostics for hash join/aggregate operator spills of data in tempdb and full text indexes.
  • Replication supportability and functionality enhancements.
  • Storage engine performance enhancements.

For more highlights of SQL Server 2012 SP2, please read here.

For information about upgrading to SQL Server 2012, see setup information here. To obtain SQL Server 2012 SP2 with its improved supportability please visit the links below:

SQL Server SQL Server 2012 SP2

SQL Server SQL Server 2012 SP2 Express

SQL Server SQL Server 2012 SP2 Feature Packs 

Categories: Database

Oracle Announces New, Highly Optimized x86 Servers

Oracle Database News - Wed, 06/11/2014 - 13:00
First and Only x86 Servers to Offer Elastic Computing are Ideal Platforms for Oracle Database, Large-Memory Applications and Virtualization /us/corporate/press/2216429 en
Categories: Database, Vendor

Oracle Launches In-Memory Option for 12C Database

Database Journal News - Wed, 06/11/2014 - 01:02

The 12C In-Memory Option is aimed at enabling ISV applications to accelerate performance by orders of magnitude for several use cases.

Categories: Database

Oracle Database In-Memory Powers the Real-Time Enterprise

Oracle Database News - Tue, 06/10/2014 - 19:59
Larry Ellison Unveils Breakthrough Technology, which Turns the Promise of Real-Time Business into a Reality /us/corporate/pressrelease/database-in-memory-061014 en
Categories: Database, Vendor

Oracle Database In-Memory Powers the Real-Time Enterprise

Oracle Database News - Tue, 06/10/2014 - 18:15
Oracle Database In-Memory Powers the Real-Time Enterprise -- Larry Ellison Unveils Breakthrough Technology, which Turns the Promise of Real-Time into a Reality /us/corporate/press/2215795 en
Categories: Database, Vendor

Oracle Database In-Memory Lets ISVs Easily Deliver Applications for the Real-Time Enterprise

Oracle Database News - Tue, 06/10/2014 - 18:12
Oracle Database In-Memory Offers Partner Applications Real-Time Analytics and Increased Transactional Performance; Oracle Database Ready Certification Includes Oracle Database In-Memory /us/corporate/press/2215799 en
Categories: Database, Vendor

Introduction to SQL Server in Microsoft Azure

Database Journal News - Mon, 06/09/2014 - 08:01

The convenience, competitive pricing, resiliency, and ease of maintenance of the SQL Database Platform as a Service (PaaS) offering hosted on the Microsoft Azure platform are partially offset by a lack of support for some of the features available in full-fledged editions of the SQL Server. Fortunately, these limitations can be eliminated by taking advantage of the Microsoft Azure Infrastructure as a Service (IaaS) capabilities and installing a SQL Server instance in an Azure-hosted virtual machine (VM).

Categories: Database

Announcing the preview of Apache HBase clusters inside Microsoft Azure HDInsight

On June 3, Microsoft announced an update to HDInsight to support Hadoop 2.4 for 100x faster queries.  Today, we are announcing the preview of Apache HBase clusters inside Microsoft Azure HDInsight.

HBase is a NoSQL (“not only Structured Query Language”) database component of the Apache Hadoop ecosystem. While relational database management systems (RDBMS) typically use rigid tabular schemas, NoSQL databases uses fluid techniques such as key-value, column, graph, or document. They are usually designed for elasticity over large datasets and are less rigorous when it comes to schema.

HBase is a columnar NoSQL database that was built to run on top of the Hadoop Distributed File System (HDFS). As a low-latency database, it can do OLTP capabilities like updates, inserts, and deletes of data in Hadoop. HBase will have a set of tables that contain rows and column families that you must predefine. However, it provides flexibility in that new columns can be added to the column families at any time.  This makes HBase have flexibility in the schema to adapt to changing requirements quickly.

This preview announcement will enable customers to run HBase as a managed cluster in the cloud (as an integrated feature of Azure HDInsight). The HBase clusters are configured to store data directly in Azure Blob storage. This will enable use cases like:

  • Building interactive websites that work with large datasets stored in Azure Blobs
  • Building services that store sensor and telemetry data from millions of end points in Azure Blobs (which can then be analyzed using HDInsight (Hadoop)

To learn more about HBase, we invite you to read the following resources:

To learn more about Azure HDInsight and Hadoop, we invite you to the following resources:

Categories: Database

How Safe is Cloud Storage?

Database Journal News - Thu, 06/05/2014 - 15:24

As more and more companies look to the cloud for their data storage needs, the same questions are being asked over and over again: if a security breech were to occur, who would be responsible and how much of a guarantee could the provider give us that our data would be safe from prying eyes.

Categories: Database

DB2 10.1 fundamentals certification exam 610 prep, Part 2: DB2 security

IBM - DB2 and Informix Articles - Thu, 06/05/2014 - 05:00
This tutorial introduces authentication, authorization, privileges, and roles as they relate to IBM DB2 10.1. It also introduces granular access control and trusted contexts. This is the second in a series of six tutorials designed to help you prepare for the DB2 10.1 Fundamentals certification exam (610). It is assumed that you already have basic knowledge of database concepts and operating system security.
Categories: Database

Admin4 V2.1.4 featuring PostgreSQL module released

PostgreSQL News - Thu, 06/05/2014 - 01:00

The new Admin4 release is the first to contain a greatly enhanced PostgreSQL module. It includes:

  • Object browser with Favourites
  • Query tool with Snippets, sql text fragments stored for frequent usage
  • Data tool for table data modification, with Presets to remember frequently used data retrieval filters.

Favourites, Snippets and Presets are stored centrally in the database, making them available for roaming usage. Your day-to-day code snippets, standard filters and frequently used objects are right there no matter which workstation you're using to maintain the database.

Download it here from sourceforge, it's free (Apache2 licensed). Contributors/testers for this fresh project are welcome!

Categories: Database, Open Source

Postgres Open 2014 Early Bird Tickets and Tutorials on Sale!

PostgreSQL News - Thu, 06/05/2014 - 01:00

The 2014 Postgres Open Program Committee is pleased to announce the opening of Early Bird Tickets and Tutorial Registration sales.

Early Bird Tickets: Book early through July 6, 2014 to save $200 on your registration! Postgres Open has received such strong support from our community sponsors that we’re retaining our ticket prices from 2013 - no increase this year.

Conference Tutorials: We’ve brought in some new presenters and topics this year for our tutorial sessions held Wednesday, September 17th.

  • Adv. SQL + Functions - Joe Conway, Stephen Frost
  • Intro to PostGIS Core and Popular Add-ons - Regina Obe, Leo Hsu (a 2 part/full day session)
  • Writing and Using Extensions - Dimitri Fontaine

In addition, Heroku is offering a free platform tutorial covering dynos and their environment, buildpacks, deployment, releases, HTTP routing, add-ons, and of course Postgres.

Early Bird Tickets and All Tutorials can be purchased here: https://postgresopen.org/2014/tickets/

The CfP has been extended through Sunday June 8th: We’ve received some impressive submissions thus far, however a few of you have asked for some extra time, as such we’re giving you until this Sunday June 8. https://postgresopen.org/2014/callforpapers/

We look forward updating you in the coming weeks and with more speaker info and the presentations schedule for Postgres Open 2014!

Categories: Database, Open Source

Microsoft releases HDInsight for Hadoop 2.4 And Gains 100x Performance Increase

Yesterday, at the Hadoop Summit, Microsoft announced that Azure HDInsight now supports Hadoop 2.4.  This is the next release of our 100 percent Apache Hadoop-based distribution for Microsoft Azure. In conjunction with Hortonworks recent release of HDP 2.1 as a Hadoop on Windows offering and Analytics Platform System as a Hadoop and data warehousing appliance, this release of Azure continues our strategy of making Hadoop accessible to everybody with Hadoop in the cloud.

This release of HDInsight is important because it has the latest benefits of Apache Hadoop 2.4 which provides order magnitude (up to 100x) performance improvements to query response times and continues to leverage the benefits of YARN (upgrading to the future “Data Operating System For Hadoop 2.0”). Finally, we are also providing an easy-to-use web interface that gives users of HDInsight a friendly experience. You can create queries with a graphical user interface to issue Hive queries.

The 100x improvements to query response times is due to the Stinger initiative where Microsoft in collaboration with Hortonworks and the open source software community (OSS) have brought some of the technological breakthroughs of SQL Server to Hadoop. We are excited to see Microsoft-led contributions bring generational improvements to Hadoop.

Since the Azure HDInsight’s release on October, 2013, we have seen tremendous momentum of customers deploying Hadoop in the cloud. Beth Israel Deaconess Medical Center, a teaching hospital for Harvard Medical School is using HDInsight to process large amounts of unstructured log data and to maintain their stringent requirements of data retention (that can be as long as 30 years). Virginia Polytechnic Institute is using the power of HDInsight to analyze massive amounts of DNA sequencing data.  More of these examples can be read on CIO magazine  who recently highlighted several HDInsight customer stories.

With Hortonworks HDP 2.1 For Windows, Microsoft Analytics Platform System, Microsoft Azure, Microsoft customers have an unprecedented number of options to deploy Hadoop on-premise, in the cloud or hybrid.  We invite you to learn more through the following resources:

Categories: Database