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

CfP for PGConf Silicon Valley Closes June 15th

PostgreSQL News - Thu, 06/04/2015 - 01:00

Submit your talk on the PGConf Silicon Valley website now. 50 minute breakout and 3 hour tutorial sessions available. November 17-18, 2015 at the South San Francisco Convention Center.

Categories: Database, Open Source

CfP for PGConf Silicon Valley Closes June 15th

PostgreSQL News - Thu, 06/04/2015 - 01:00

Submit your talk on the PGConf Silicon Valley website now. 50 minute breakout and 3 hour tutorial sessions available. November 17-18, 2015 at the South San Francisco Convention Center.

Categories: Database, Open Source

PostgreSQL 9.4.3, 9.3.8, 9.2.12, 9.1.17 & 9.0.21 Released!

PostgreSQL News - Thu, 06/04/2015 - 01:00
2015-06-04 Update Release

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.4.3, 9.3.8, 9.2.12, 9.1.17 and 9.0.21. This release primarily fixes a startup failure problem created by the prior update release, and should be installed by all users who applied that release.

File Permissions Fix

The 2015-05-22 update release added an anti-corruption step which will fsync all files in the data directory on restart after a crash. This caused PostgreSQL to fail to start if it encountered any file permissions issues. The problem is now fixed. Find out more on the PostgreSQL wiki.

Other Fixes and Improvements

In addition to the above, a few other minor issues were patched in this release. These fixes include:

  • Have pg_get_functiondef() show the LEAKPROOF property
  • Make pushJsonbValue() function push jbvBinary type
  • Allow building with threaded Python on OpenBSD
Update Release Schedule

The PostgreSQL developers are currently working hard to fix a few known issues discovered in the past couple of weeks. As such, we expect to release another update once a solution for those issues is complete and tested. The PostgreSQL project apologizes for any inconvenience from the frequent releases. We are prioritizing getting important fixes to our users as soon as possible.

Updating

As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details.

Links:

Categories: Database, Open Source

PostgreSQL 9.4.3, 9.3.8, 9.2.12, 9.1.17 & 9.0.21 Released!

PostgreSQL News - Thu, 06/04/2015 - 01:00
2015-06-04 Update Release

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.4.3, 9.3.8, 9.2.12, 9.1.17 and 9.0.21. This release primarily fixes a startup failure problem created by the prior update release, and should be installed by all users who applied that release.

File Permissions Fix

The 2015-05-22 update release added an anti-corruption step which will fsync all files in the data directory on restart after a crash. This caused PostgreSQL to fail to start if it encountered any file permissions issues. The problem is now fixed. Find out more on the PostgreSQL wiki.

Other Fixes and Improvements

In addition to the above, a few other minor issues were patched in this release. These fixes include:

  • Have pg_get_functiondef() show the LEAKPROOF property
  • Make pushJsonbValue() function push jbvBinary type
  • Allow building with threaded Python on OpenBSD
Update Release Schedule

The PostgreSQL developers are currently working hard to fix a few known issues discovered in the past couple of weeks. As such, we expect to release another update once a solution for those issues is complete and tested. The PostgreSQL project apologizes for any inconvenience from the frequent releases. We are prioritizing getting important fixes to our users as soon as possible.

Updating

As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details.

Links:

Categories: Database, Open Source

Managing Vertica clusters in a SaaS environment, Part 1: Copying Vertica databases across the cluster

IBM - DB2 and Informix Articles - Wed, 06/03/2015 - 05:00
In the SaaS environment, data information and services are the key to customer success. HP Vertica is a critical database technology that assists customers to better manage their data in a cluster environment. This article illustrates the step-by-step approach for Vertica installation, configuration, and setup across the clusters. As a part of the setup, it is important to complete the installation and configuration and then to copy the database across the cluster. .
Categories: Database

Managing Vertica clusters in a SaaS environment, Part 2: Generating backup scripts for Vertica clusters

IBM - DB2 and Informix Articles - Wed, 06/03/2015 - 05:00
In the SaaS environment, data information and services are the key to customer success. HP Vertica is a critical database technology that assists customers to better manage their data in a cluster environment. This article illustrates the step-by-step approach for Vertica database backup across the clusters. To generate the Vertica backup script, a backup host with passwordless SSH enabled and the configuration file must be defined. The backup script is initiated by a cron job based on the backup strategy and the size of the Vertica database.
Categories: Database

Bi-Direction Replication, version 0.9.1 released

PostgreSQL News - Wed, 06/03/2015 - 01:00

June 01 2015

2ndQuadrant is pleased to announce the release of Bi-Direction Replication, version 0.9.1

This new version (0.9.1) is a maintenance release focused on stability and performance.

For a complete list of changes, see the "Release Notes" in "More information" below.

Featured release notes

  • Rename 'bdr' reserved db to 'bdr_supervisordb', prevent users from connecting, and protect against drop

  • Bug fixes in bdr_init_copy handling of connection strings

  • Fixes for UNLOGGED tables in the command filter

  • Permit fast shutdown when replication is paused

  • Remove slots when parting a node

  • bdr.table_set_replication_sets no longer requires permit_unsafe_ddl_commands

More information

Bi-Directional Replication (BDR) is an asynchronous multi-master replication system for PostgreSQL, specifically designed to allow geographically distributed clusters. Supporting up to 48 nodes (and possibly more in future releases) BDR is a low overhead, low maintenance technology for distributed databases. For more information visit http://2ndquadrant.com/bdr

Categories: Database, Open Source

Assess the health of SQL Server deployments in Azure VM using Microsoft Operations Management Suite

Do you want to assess the health of your SQL Server deployments on Azure Virtual machines? 

Do you want to ensure that you have an optimal SQL Server configuration?

 

At Ignite 2015 we released a tool for this.  The Operations Management Suite (OMS) is a collection of IT management solutions powered by a modern cloud-based management platform that enables you to gain visibility on deployments across both cloud and on-premises.  It also helps you take control of your IT environment by remediating problems and orchestrating complex & repetitive operations through automation.

Included in OMS is the SQL Assessment which evaluates the configuration and assesses the health of your SQL Server deployments. It considers around 90 best practices defined by the SQL Server and Support Services teams. Based on these, it provides a prioritized list of recommendations tailored to your deployments.  

The recommendations are categorized across six Focus Areas. These areas allow you quickly understand the health of your deployments and easily take actions to enhance your SQL Server environments.

 

Are you ready to assess your SQL Server deployments in Azure Virtual Machine? 

To begin, setup your OMS workspace by following this step-by-step instructions.

Once the workspace is established, add the SQL Assessment to your workspace.  To start collecting configuration and telemetry data install the OMS Agent or the Systems Center Operations Manager Agent.

Data collection will start after the agents are installed. Keep in mind that the first assessment will be available a couple of hours later,  after the data is gathered and analyzed. At that point, you will see the data populated in the SQL Assessment tile.

 

Learn more about OMS here and try the Operations Management Suite today for free!

 

Categories: Database

Oracle Communications Advances the Cloud and IT in the Network with the Demonstration of Next-Generation Network as a Service

Oracle Database News - Tue, 06/02/2015 - 11:32
Press Release Oracle Communications Advances the Cloud and IT in the Network with the Demonstration of Next-Generation Network as a Service Catalyst project at TM Forum Live! The event will show communications service providers how they can enable their business customers to control and consume the network as needed, via an NFV-enabled infrastructure

TM FORUM LIVE! — Nice, France—Jun 2, 2015

Communications service providers (CSPs) know they must quickly transform from a static and network-device-centric service model to one that is dynamic and cloud-centric by leveraging advancements in software defined networking (SDN) and network function virtualization (NFV). This shift is especially critical for CSPs that provide services to business customers because setup and delivery can be highly manual and costly, and businesses can’t control how much or how little of the resulting network they use.Oracle Communications,in collaboration with InfoVista and Juniper Networks, will lead a Catalyst project at TM Forum Live!, “Zero-Touch Network as a Service: Agile, Assured, and Orchestrated with NFV,” that squarely addresses this challenge.

This Catalyst project—which will be showcased at the conference 1st-4th June 2015, in Nice, France, provides CSPs with a blueprint for simplifying and standardizing how they can deliver network services to business customers and give those customers direct control over how they consume those services. Using this on-demand network-as-a-service (NaaS) offering as an example, the Catalyst will show CSPs how to:

  • Implement such services while their underlying network evolves from physical to hybrid with the deployment of virtualized customer premises equipment (vCPE)
  • Create the agility in business processes and systems that can enable CSPs to realize the benefits of an increasingly dynamic network, powered by SDN and NFV technology adoption
  • Efficiently integrate the network with essential business processes, including customer relationship management and customer billing, to better monetize and manage such services throughout their lifecycle

With the Catalyst, Oracle Communications, in conjunction with the contributions of InfoVista and Juniper Networks, will demonstrate its expertise in orchestrating business and operational processes and virtualized network services.Champions for the Catalyst include the MEF,which represents more than 130 CSPs globally; Charter Communications’ business division, Spectrum Business; PCCW Global; and Axtel, and will show the Catalyst project’s business context and use case.

“The newly dynamic network, made possible by SDN and NFV, gives CSPs so many opportunities. But, they need the agility on the business operations side to take full advantage of it,” said Doug Suriano, senior vice president and general manager, Oracle Communications. “This Catalyst project is an example of how we are helping CSPs to converge IT and the network to close that gap—and apply it to CSPs’ critical B2B services opportunity.”

The Catalyst also advances industry standards to help CSPs more easily deploy, operationalize, and monetize NaaS. Specifically, it demonstrates how the full lifecycle of zero-touch orchestration and assurance for NaaS, across an SDN- and NFV-enabled network, maps to TM Forum, MEF, and ETSI standards, bridging the work of these industry organizations.

“This Catalyst further advances the TM Forum and MEF UNITE program—it clearly demonstrates how standards from the TM Forum and MEF can align to enable a useful and very compelling use case with NaaS,” said Ken Dilbeck, vice president, Collaboration, TM Forum. “This project will offer tangible learnings for service providers globally as they look to enable more-dynamic network services over virtualized infrastructure, building on the best practices we’ve put in place that support CSPs’ agility goals in light of the shift toward an SDN- and NFV-based infrastructure.”

“To deliver the zero-touch NaaS value proposition, CSPs need an end-to-end, standards-aligned view of how all components fit together. To get to deployment quickly, many service providers are taking customized, siloed approaches to implementing NaaS for the vCPE use case to deliver enterprise-managed services via NFV,” stated Michael Howard, senior research director, Carrier Networks, IHS/Infonetics. “But, if you have a dynamic network that is combined with business and operations agility and automation, you can fundamentally change not just your network, but your business as well. I believe service providers will be interested in how this Catalyst project will help them envision how to get there, leveraging the combined IT and network expertise of Oracle and other contributors.”

Catalysts are proof-of-concept projects that bring together large and small companies to create innovative solutions for common communications challenges.

  Contact Info Kaitlin McCready
Oracle
+1.216.925.5972
kaitlin.mccready@oracle.com Lisa Fisher
O’Keeffe & Company
+1.703.883.9000, x156
lfisher@okco.com About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Kaitlin McCready

  • +1.216.925.5972

Lisa Fisher

  • +1.703.883.9000, x156

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Mast Mobile Implements a Pioneering Communications Platform and Billing Model with Oracle Communications Solution

Oracle Database News - Tue, 06/02/2015 - 11:06
Press Release Mast Mobile Implements a Pioneering Communications Platform and Billing Model with Oracle Communications Solution Oracle Communications Billing and Revenue Management enables the mobile communications start-up to rate and bill customers separately for personal and business usage

TM FORUM LIVE! — Nice, France —Jun 2, 2015

Today’s employees are mobile in and outside of the office—a challenge as companies try to integrate communications channels and tools, as well as social media, to help increase productivity while managing costs. That’s the problem that Mast Mobile solves. The two-year old technology company provides an end-to-end, mobile-first, unified communications platform that helps enterprises and their employees manage business and personal data on a single device. To deliver its platform, Mast Mobile deployed Oracle Communications Billing and Revenue Management in October 2014, enabling the start-up to define mobile policies for different groups of employees, automate split billing to distinguish between work and personal use, eliminate desk phones, and protect both company data and employee privacy.

“Mast Mobile enables a person to have multiple numbers on one device. And for that to work, we need to have a relationship with the individual, as well as with the company,” said David Messenger, cofounder and CEO, Mast Mobile. “Our billing and rating engine had to be exceptionally flexible to allow us to correctly bill both the business account and the individual account. Oracle Communications Billing and Revenue Management is flexible and scalable. As a start-up that regularly releases new product offerings, a dynamic billing and rating engine is a key part of our growth strategy.”

Oracle Communications Billing and Revenue Management provides a complete solution for managing revenue and supporting business processes that incorporate generation, capture, collection, and assurance of revenue. Mast Mobile uses the solution to:

  • Rate call and data session information as either a business or personal cost
  • Aggregate call and data session records and deliver them in an easy-to-understand, meaningful bill to both the business and end user
  • Quickly launch and bill for new services

“The communications, media, and cloud markets are undergoing significant transformations,” said Doug Suriano, senior vice president and general manager, Oracle Communications. “Both traditional service providers and industry newcomers like Mast Mobile are trying to deliver services to consumers and enterprises that oftentimes require a new kind of billing process—one that is fluid, allowing providers to rapidly introduce and modify product and service offerings. We’re proud that Oracle Communications Billing and Revenue Management delivers the level of flexibility and scalability that meets the needs of all kinds of service providers, from established telecommunications companies to technology start-ups.”

Mast Mobile also collaborated with Minacs, a Gold level member of Oracle PartnerNetwork (OPN), which provides the solution in a private cloud delivery model, simplifying Mast Mobile’s IT operations and enabling a shorter deployment time.

Contact Info Kaitlin McCready
Oracle
+1.216.925.5972
kaitlin.mccready@oracle.com Lisa Fisher
O’Keeffe & Company
+1.703.883.9000
lfisher@okco.com About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Kaitlin McCready

  • +1.216.925.5972

Lisa Fisher

  • +1.703.883.9000

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server

Database Journal News - Mon, 06/01/2015 - 08:01

Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.

Categories: Database

Predictive analytics using IBM SPSS Modeler in DB2 for z/OS

IBM - DB2 and Informix Articles - Fri, 05/29/2015 - 05:00
This tutorial focuses on predictive analytics using IBM SPSS Modeler and data stored in DB2 for z/OS. We illustrate how to use the SPSS Modeler workbench to create predictive models with in-database mining, SQL push-back, and UDF scoring. We walk through the steps for integrating real-time scoring for DB2 for z/OS into an OLTP application. We also show what needs to be done in the DB2 server and the information an application developer needs to know to create an enterprise solution for in-database transactional scoring and batch scoring.
Categories: Database

SQL Server 2016 first public preview now available!

Three weeks ago at Microsoft Ignite, we announced SQL Server 2016, the next major release of Microsoft’s flagship database and analytics platform, as well key innovations in the release.  Today we are pleased to announce the first public Community Technology Preview (CTP2) for SQL Server 2016.  This public preview gives an early look into many of the capabilities in the release and allows early adopters to get engaged by testing the preview in their environments or via a virtual machine in Microsoft Azure. 

SQL Server 2016 provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Top capabilities for the release include: Always Encrypted - a new capability that protects data at rest and in motion, Stretch Database - new technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure, enhancements to our industry-leading in-memory technologies for real-time analytics on top of breakthrough transactional performance and new in-database analytics with R integration. 

Unique in this release of SQL Server, we are bringing capabilities to the cloud first in Microsoft Azure SQL Database such as Row-level security and Dynamic Data Masking and then bringing the capabilities, as well as the learnings from running these at hyper-scale in Microsoft Azure, back to SQL Server to deliver proven features at scale to our on-premises offering.  This means all our customers benefit from our investments and learnings in Azure. 

Key Capabilities in SQL Server 2016 CTP2

Always Encrypted

Always Encrypted, based on technology from Microsoft Research, protects data at rest and in motion. With Always Encrypted, SQL Server can perform operations on encrypted data and best of all, the encryption key resides with the application in the customers trusted environment. Encryption and decryption of data happens transparently inside the application which minimizes the changes that have to be made to existing applications.

Stretch Database

This new technology allows you to dynamically stretch your warm and cold transactional data to Microsoft Azure, so your operational data is always at hand, no matter the size, and you benefit from the low cost of Azure.  You can use Always Encrypted with Stretch Database to extend data in a more secure manner for greater peace of mind.

Real-time Operational Analytics & In-Memory OLTP

For In-Memory OLTP, which customers today are using for up to 30x faster transactions, you will now be able to apply this tuned transaction performance technology to a significantly greater number of applications and benefit from increased concurrency.  With these enhancements, we introduce the unique capability to use our in-memory columnstore delivering 100X faster queries on top of in-memory OLTP to provide real-time operational analytics while accelerating transaction performance.

Additional capabilities in SQL Server 2016 CTP2 include:

  • PolyBase – More easily manage relational and non-relational data with the simplicity of T-SQL.
  • AlwaysOn Enhancements – Achieve even higher availability and performance of your secondaries, with up to 3 synchronous replicas, DTC support and round-robin load balancing of the secondaries.
  • Row Level Security– Enables customers to control access to data based on the characteristics of the user. Security is implemented inside the database, requiring no modifications to the application.
  • Dynamic Data Masking – Supports real-time obfuscation of data so data requesters do not get access to unauthorized data.  Helps protect sensitive data even when it is not encrypted.
  • Native JSON support – Allows easy parsing and storing of JSON and exporting relational data to JSON.
  • Temporal Database support – Tracks historical data changes with temporal database support.
  • Query Data Store – Acts as a flight data recorder for a database, giving full history of query execution so DBAs can pinpoint expensive/regressed queries and tune query performance.
  • MDS enhancements – Offer enhanced server management capabilities for Master Data Services.
  • Enhanced hybrid backup to Azure – Enables faster backups to Microsoft Azure and faster restores to SQL Server in Azure Virtual Machines.  Also, you can stage backups on-premises prior to uploading to Azure.

Ongoing preview updates – Coming soon!

New with SQL Server 2016, customers will have the opportunity to receive more frequent updates to their preview to help accelerate internal development and test efforts.  Instead of waiting for CTP3, customers can choose to download periodic updates to CTP2 gaining access to new capabilities and features as soon as they are available for testing.  More details will be shared when the first preview update is available. 

Download SQL Server 2016 preview today!

Now that you have seen the many exciting capabilities included in SQL Server 2016 CTP2, be sure to download the preview or trial the preview using a virtual machine in Microsoft Azure and start evaluating the impact these new innovations can have for your business.  Also, be sure to share your feedback on the new SQL Server 2016 capabilities using Microsoft’s Connect tool

As the foundation of our end-to-end data platform, with this release we continue to make it easier for customers to maximize their data dividends. With SQL Server 2016 you can capture, transform, and analyze any data, of any size, at any scale, in its native format —using the tools, languages and frameworks you know and want in a trusted environment on-premises and in the cloud.

To learn more about the release, visit the SQL Server 2016 preview page.  We look forward to hearing from you!

Categories: Database

Oracle Helps Customers Embrace the Digital Enterprise with Enhanced API Management Portfolio

Oracle Database News - Wed, 05/27/2015 - 13:00
Press Release Oracle Helps Customers Embrace the Digital Enterprise with Enhanced API Management Portfolio Helps Organizations Simplify API Delivery to Create New Growth Channels

Redwood Shores, Calif.—May 27, 2015

A key component in Oracle’s strategy to help organizations embrace the digital enterprise, Oracle today introduced its enhanced API Management portfolio with Oracle API Catalog and Oracle API Manager. This is part of Oracle’s vision to help customers address the changing digital business landscape by helping developers use APIs to build new applications and extend existing ones to reach new customers and new markets.

As mobile and the Internet of Things continue to digitize all kinds of products and services, APIs are an essential component in securely connecting applications with devices. Oracle’s comprehensive API Management portfolio, including Oracle API Gateway and Oracle API Catalog, helps streamline the process of finding, understanding, securing and using APIs. The newly released Oracle API Manager provides easy-to-use facilities for annotating and publishing REST and SOAP services as APIs to a developer portal where application developers can discover, test, register and subscribe to these APIs, as well as track API performance. It is available on-premises today and will soon be available as a component of Oracle’s rapidly expanding cloud services portfolio. Additionally, Oracle API Catalog simplifies the publication of API services that are developed in Oracle and other sources.

“The convergence of cloud, mobile, social, and big data is ushering in new digital business models,” said Amit Zavery, senior vice president of products at Oracle. “Oracle’s comprehensive API Management portfolio enables organizations to simplify the delivery of new API-based services, helping to increase adoption of their APIs, reach new customers, and capture new revenue opportunities.”

Oracle API Management has gained notable industry recognition, with Gartner, Inc. naming Oracle a Leader in its July 29, 2014 Magic Quadrant for On-Premises Application Suites, as well as Database Trends and Applications naming Oracle a winner in the “Best Cloud Integration Solution” category of its 2014 Readers’ Choice Awards.

Oracle API Management provides complete API lifecycle management, including the definition, creation, publishing, security, monitoring, and management of APIs, and is seamlessly integrated with private, public, and hybrid cloud solutions. The portfolio includes Oracle API Manager, Oracle API Catalog, Oracle API Gateway, and Oracle Service Bus

About the Magic Quadrant

Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

Contact Info Nicole Maloney
Oracle
1.650.506.0806
nicole.maloney@oracle.com Marcie Bradley
Oracle
1.530.214.8068
marcie.bradley@oracle.com About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Nicole Maloney

  • 1.650.506.0806

Marcie Bradley

  • 1.530.214.8068

Follow Oracle Corporate

Categories: Database, Vendor

Advisory on May 22 Update Release

PostgreSQL News - Tue, 05/26/2015 - 01:00

On May 22, 2015, the PostgreSQL Global Development Group released an update to all supported versions of PostgreSQL, including versions 9.4.2, 9.3.7, 9.2.11, 9.1.16, and 9.0.20. This update has a bug in fsync logic which will cause some users' PostgreSQL servers to refuse to restart after a crash, or after a restore from binary backup. Please read our FAQ on this issue before applying the update to your systems.

The PostgreSQL Project regrets the error. Another PostgreSQL update, with this issue corrected, will be released soon.

Categories: Database, Open Source

Stoptimizing Oracle

Database Journal News - Mon, 05/25/2015 - 08:01

According to Jonathan Lewis: "Stoptimisation - the art of optimization by not doing the things you don't need to do."  Read on to see what things you may be doing that you shouldn't be doing.

Categories: Database

PostgreSQL 9.4.2, 9.3.7, 9.2.11, 9.1.16, and 9.0.20 released!

PostgreSQL News - Fri, 05/22/2015 - 01:00

The PostgreSQL Global Development Group has released an update with multiple functionality and security fixes to all supported versions of the PostgreSQL database system, which includes minor versions 9.4.2, 9.3.7, 9.2.11, 9.1.16, and 9.0.20. The update contains a critical fix for a potential data corruption issue in PostgreSQL 9.3 and 9.4; users of those versions should update their servers at the next possible opportunity.

Please see the FAQ about a potential issue with this update for some users before applying it.

Data Corruption Fix

For users of PostgreSQL versions 9.3 or 9.4, this release fixes a problem where the database will fail to protect against "multixact wraparound", resulting in data corruption or loss. Users with a high transaction rate (1 million or more per hour) in a database with many foreign keys are especially vulnerable. We strongly urge all users of 9.4 and 9.3 to update their installations in the next few days.

Users of versions 9.2 and earlier are not affected by this issue.

Security Fixes

This update fixes three security vulnerabilities reported in PostgreSQL over the past few months. None of these issues are seen as particularly urgent. However, users should examine them in case their installations are vulnerable:

  • CVE-2015-3165 Double "free" after authentication timeout.
  • CVE-2015-3166 Unanticipated errors from the standard library.
  • CVE-2015-3167 pgcrypto has multiple error messages for decryption with an incorrect key.

Additionally, we are recommending that all users who use Kerberos, GSSAPI, or SSPI authentication set include_realm to 1 in pg_hba.conf, which will become the default in future versions.

More information about these issues, as well as older patched issues, is available on the PostgreSQL Security Page.

Other Fixes and Improvements

A new, non-default version of the citext extension fixes its previously undocumented regexp_matches() functions to align with the ordinary text version of those functions. The fixed version has a different return type than the old version, so users of CIText should test their applications before updating the function by running "ALTER EXTENSION citext UPDATE".

In addition to the above, more than 50 reported issues have been fixed in this cumulative update release. Most of the issues named affect all supported versions. These fixes include:

  • Render infinite dates and timestamps as infinity when converting to json
  • Fix json/jsonb's populate_record() and to_record()
  • Fix incorrect checking of deferred exclusion constraints
  • Improve planning of star-schema-style queries
  • Fix three issues with planning joins
  • Ensure correct locking with security barrier views
  • Fix deadlock at startup when max_prepared_transactions is too small
  • Recursively fsync() the data directory after a crash
  • Fix autovacuum launcher's possible failure to shut down
  • Cope with unexpected signals in LockBufferForCleanup()
  • Fix crash when doing COPY IN to a table with check constraints
  • Avoid waiting for synchronous replication of read-only transactions
  • Fix two issues with hash indexes
  • Prevent memory leaks in GIN index vacuum
  • Fix two issues with background workers
  • Several fixes to Logical Decoding replication
  • Fix several minor issues with pg_dump and pg_upgrade

This release includes an update to tzdata release 2015d, with updates to Egypt, Mongolia, and Palestine, plus historical changes in Canada and Chile.

9.0 EOL Soon

Version 9.0 will become End-Of-Life in September 2015. This means that this update is likely to be the next-to-last update for that version. Users of PostgreSQL 9.0 should start planning to upgrade to a more current version before then. See our versioning policy for more information about EOL dates.

Updating

As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details.

Links:

Categories: Database, Open Source

ITA Secures Partnership With Oracle

Oracle Database News - Thu, 05/21/2015 - 17:52
Press Release ITA Secures Partnership With Oracle Fall national singles and doubles championship to be added as part of partnership

Redwood Shores, Calif.—May 21, 2015

The ITA is delighted to announce an exciting new partnership with Oracle, in which Oracle will serve as the title sponsor for three major programs as part of the Oracle Collegiate Tennis Tour, administered by the ITA.

This special sponsorship agreement is highlighted by the inaugural Oracle/ITA Masters, hosted by Malibu Racquet Club from Sept. 18-20, 2015. The Oracle/ITA Collegiate Tennis Rankings and Oracle/ITA Outing & Awards Luncheon are also integral parts of the Oracle Collegiate Tennis Tour.

“We are thrilled to be a part of the Oracle Collegiate Tennis Tour and to be supporting these rising tennis stars,” said Oracle CEO Mark Hurd. “This program is just one of the many ways Oracle is supporting college students and universities nationwide. Our partnership with the ITA gives us another opportunity to invest in college students who are key to Oracle’s future.”

“Partnering with Oracle, given its extraordinary resources and worldwide recognition, will be transformative for the ITA and college tennis in general,” executive director David A Benjamin said. “Oracle already has a major presence in the tennis world and we are thrilled with its growing commitment to the college game.”

The top returning collegiate tennis stars will now have the opportunity to earn a trip to scenic Malibu with the addition of the Oracle/ITA Masters to the fall calendar. The tournament will feature 16 elite men’s and women’s singles players, along with eight of the most outstanding men’s and women’s doubles teams, with consolation action for each of the four events. Selections will be primarily based on the year-end Oracle/ITA Collegiate Tennis Rankings, with the USTA/ITA National Indoor Intercollegiate singles and doubles champions and NCAA singles and doubles champions also earning automatic bids if they are returning to school in the fall.

Trey Waltke, General Manager of the Malibu Racquet Club and former standout for California men’s tennis, knows the quality of elite college tennis, but has an even deeper appreciation for the passion exhibited by the student-athletes.

“I’m most excited about people seeing great college tennis,” Waltke said. “College tennis is the best example in all of tennis of the competitive spirit, even more so than the pros. It’s fierce, and we’d like to showcase that at our club. It will be so beneficial to have the energy of college tennis players at the club. We’ve been looking for a vehicle like this for some time now. It’s infectious to watch great tennis.”

The Oracle/ITA Collegiate Tennis Rankings will track the top men's and women's teams, singles and doubles players in NCAA Divisions I, II, III, NAIA, Junior Colleges and California Junior Colleges. In addition, the ITA will be distributing attractive Oracle/ITA ranking certificates to all teams and individuals who achieve a final national ranking.

The Oracle/ITA Outing & Awards Luncheon will honor members of the ITA Collegiate All-Star Team and ITA/Arthur Ashe, Jr. Sportsmanship & Leadership National Award winners at the historic West Side Tennis Club in Forest Hills, NY. The Oracle/ITA Outing & Awards Luncheon will take place on August 28, 2015. Former New York City Mayor David Dinkins will personally present the honorees with their awards.

The ITA Collegiate All-Star team features the nation's top-ranked men's and women's players from the year-end Oracle/ITA Collegiate Tennis Rankings in all collegiate divisions, as well as winners of the USTA/ITA National Indoor Intercollegiate Championships and NCAA Division I Singles and Doubles Championships.

The ITA/Arthur Ashe, Jr. Sportsmanship & Leadership Award recognizes a player’s tennis accomplishments, sportsmanship, leadership, character, scholastic achievements, extracurricular endeavors and overall excellence on and off the court.

“We are very pleased to be returning to the West Side Tennis Club for the Oracle/ITA Outing & Awards Luncheon for the first time since 2005,” Benjamin said. “These honorees serve as wonderful representatives of not only college tennis, but higher education in general.”

Contact Info Deborah Hellinger
Oracle
+1 (212) 508-7935
deborah.hellinger@oracle.com About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit http://www.oracle.com.

About the ITA

The Intercollegiate Tennis Association (ITA) is the governing body of college tennis, overseeing men's and women's varsity tennis at NCAA Divisions I, II and III, NAIA and Junior/Community College. The ITA administers a comprehensive awards and rankings program for men’s and women’s varsity players, coaches and teams in all divisions, providing recognition for their accomplishments on and off the court. For more information on the ITA, visit the ITA website at www.itatennis.com, like the ITA on Facebook or follow @ITAtennis on Twitter.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation.

Talk to a Press Contact

Deborah Hellinger

  • +1 (212) 508-7935

Follow Oracle Corporate

Categories: Database, Vendor

Oracle and the Community Celebrate 20 Years of Java

Oracle Database News - Thu, 05/21/2015 - 10:46
Oracle and the Community Celebrate 20 Years of Java Look Ahead to How Java Will Continue to Transform the Way We Work and Live

Redwood Shores, Calif. – May 20, 2015: Oracle, users and the development community worldwide are celebrating 20 years of Java. Today, Java serves as the critical backbone of software that touches both our work and personal lives. From innovations in enterprise big data, cloud, social, mobile and the Internet of Things, to connected cars, smartphones and video games, Java continues to help developers push the boundaries in technology innovation.

“Java has grown and evolved to become one of the most important and dependable technologies in our industry today. Those who have chosen Java have been rewarded many times over with increases in performance, scalability, reliability, compatibility, and functionality,” said Georges Saab, vice president of development, Java Platform Group at Oracle. “The Java ecosystem offers outstanding libraries, frameworks, and resources to help programmers from novice to expert alike. The development of Java itself occurs in the transparent OpenJDK community. With the considerable investment from Oracle and others in the community, we look forward to the next 20 years of Java’s evolution and growth.”

“Fujitsu recognized the utility of Java in IT systems as soon as it first became available, and even now we are working to promote its applications. Java is used across industries in Japan owing to it being so highly compatible and offering such excellent productivity,” said Yasushi Fujii, vice president, Application Management Middleware Division, Fujitsu Limited. “In future ICT, mobile and cloud technologies will deepen the relationships between people and between individuals and companies, helping to create a society that is ever more Human Centric in nature. We expect that Java’s continuing evolution will lead to further ICT development and a changing society, and look forward to working with the Java community to develop Java technologies.”

"IBM is celebrating Java's 20th anniversary as one of the most important industry led programming platforms spanning mobile, client and enterprise software platforms. IBM began its commitment to Java at its inception over two decades ago, and has seen the Java ecosystem and developer community bring unsurpassed value to the investments our clients have made in their Java based solutions,” said Harish Grama, vice president, Middleware Products, IBM Systems. “IBM looks forward to the next 20 years of growth and innovation in the Java ecosystem including Mobile, Cloud, Analytics and Internet of Things."  

Evolution of the World’s #1 Programming Language

Introduced in 1995, Java is the programming language of choice for 9 million developers and today powers 7 billion devices. Improving road and air safety, collecting information from the world’s oceans for science applications, increasing grain crop quality and quantifying to help feed the hungry, simulating the human brain and musculoskeletal system, and gaming are some of the intriguing projects worldwide that use the Java technology.

Enterprise developers can choose from an ecosystem of 30 Java EE 6 and Java EE 7 compatible implementations from 12 vendors. Additionally, more than 125 million Java-based media devices have been deployed and over 10 billion Java Cards have been shipped since Java’s introduction.

For a full timeline of key developments and milestone’s in Java’s 20-Year history, please visit here.

“Programming languages don’t always live a long life, and those that do, don’t always enjoy a healthy one,” said Al Hilwa, IDC program director for Application Development Research. “But Java has stood the test of time and the test of the vast range of applications using it, from large enterprise systems to small device games.”

Under the stewardship of Oracle, two major platform releases including Java 7 and Java 8 have been delivered, with Java 9 slated for 2016. The Java Community Process (JCP) is more open and transparent than ever before, and serves as an integral element of community participation in the ongoing evolution of the technology. The OpenJDK Community, the place to collaborate on an open-source implementation of the Java Platform, Standard Edition, is continuously attracting new contributors to its already broad base of participation.

In March 2014, Oracle announced availability of Java SE 8 after receiving final approval in the Java Community process. This release, which included the largest upgrade to the Java programming model since the platform was introduced in 1995, was developed collaboratively in the OpenJDK Community. Soon after, in April 2014, the Java Platform, Micro Edition 8 (Java ME 8) and the related releases of Oracle's Java Embedded products were also made available after final approval in the Java Community Process. With a consistent Java 8 platform across embedded devices, desktops, data centers and the cloud, customers can deploy applications faster; process and analyze in-flight data; and act on events as quickly as they occur.

Ushering in the Next Era of Java

Oracle and the Java community are now focused on delivering new innovations in Java 9. The key planned feature of this release is Project Jigsaw, which aims to modularize the platform in order to make it scalable to a wider range of devices, make it easier for developers to construct and maintain libraries and large applications, and improve security, maintainability, and performance. Other features slated for Java 9 include the Java Shell, an interactive tool for evaluating snippets of Java code; a new HTTP client API to support HTTP/2 and Web Sockets; a port to the ARM AArch64 architecture on Linux; and a variety of updates to existing APIs along with some significant performance improvements.

“Java directly or indirectly touches just about every human on this planet. It is the glue that allows mobile health and banking in remote areas of the world, entertains millions with games such as Minecraft, and drives the economic engine of our global markets,” said Martijn Verburg, co-leader of Java User Group, London. “It is extremely important that this platform be managed by a leader who understands Java's importance to the world, and Oracle does an excellent job in collaborating with a hugely diverse community of users, developers, open source projects and larger enterprises. I look forward to seeing what the next generation of engineers will come up with next. Using Java, the possibilities seem endless.”

To commemorate 20 years of Java, Oracle Certification is offering 20 percent discount on all Java certification exams. The offer available globally is now open through December 31, 2015. Candidates must provide promotional code Java20 at the time of registration. For details, visit here.

Visit the Duke’s Choice Award winners to see the remarkable work being done today by the Java community.

Supporting Resources Java 20 year timeline Share your message on 20 years of Java with the community Press Releases: Java 8 and Java 7 ForbesBrandVoice: 20 years of Java innovation Videos: Java Life and Java is what Java Does Learn more about JavaOne conference in Brazil, June 23-25 Whitepaper: Java and IoT: The Intelligent Platform for the Connected Vehicle Mark Reinhold, Chief Architect of the Java Platform Group at Oracle speaks to Java magazine in a feature story around 20 years of Java, May/June 2015 issue: Subscribe for your free copy today at oracle.com/javamagazine. Learn more about Java certification Java Source Blog Mark Reinhold's Blog Follow the conversation on Twitter #Java20 and I Love Java on FacebookAbout Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Contact Info

Seema Kalra
Oracle
+1.650.506.2925  
seema.kalra@oracle.com

Categories: Database, Vendor

Converting Comma Separated Value to Rows and Vice Versa in SQL Server

Database Journal News - Thu, 05/21/2015 - 08:01

Often while reporting you will encounter a situation where you will have comma separated values in a single column but you want to report them in rows. In other cases you might have values in multiple rows and want them to be a single value separated by comma or some other character. Arshad Ali demonstrates how to write queries in SQL Server to handle these scenarios quickly.

Categories: Database