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!


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
1.650.506.0806 Marcie Bradley
1.530.214.8068 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


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.


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.


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
+1 (212) 508-7935 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

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, like the ITA on Facebook or follow @ITAtennis on Twitter.


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

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

Identifying duplicates in your data using InfoSphere QualityStage

IBM - DB2 and Informix Articles - Thu, 05/21/2015 - 05:00
This article illustrates the steps required and best practices to find duplicates in data using IBM InfoSphere Information Server. Additionally, it will provide accelerators to standardize and find duplicates in names and addresses for India, Canada, Germany, and Japan.
Categories: Database

Oracle and the Community Celebrate 20 Years of Java

Oracle Database News - Wed, 05/20/2015 - 13:02
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 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


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

Categories: Database, Vendor

Big data needs a big cloud

Brian Mitchell, Microsoft Senior Business Program Manager, took the stage at Ignite two weeks ago to discuss Planning Your Big Data Architecture on Azure. “Big Data” requires big scale. Mitchell covered how this is accomplished through storage strategies, partitioning, fault tolerance, and the right architecture to scale to the extremes of big data. If you want to explore cloud-based big data apps, be sure to check it out.

Ignite covered the cloud in depth. Make sure to take a look at all the other on-demand presentations, demos, and more.

Categories: Database

Oracle Enables Mobile Content Delivery Innovation with Documaker Mobile

Oracle Database News - Tue, 05/19/2015 - 16:00
Press Release Oracle Enables Mobile Content Delivery Innovation with Documaker Mobile New Product Offering Enables Businesses to Produce Mobile Device Responsive Content from Documents Originally Developed for Print

Redwood Shores, Calif.—May 19, 2015

Oracle today introduced Oracle Documaker Mobile, a new product that enables businesses to produce the same content for print and for device-responsive mobile delivery. This new offering enables businesses to use content and business rules created for paper-style output in new device responsive documents designed for delivery to mobile devices.

Oracle Documaker Mobile enables businesses to deliver highly interactive documents that are searchable, easy to navigate, and responsive to mobile devices. Businesses have traditionally delivered complex documents to their customers using print delivery or electronic images of the same print formatted output. With this new solution, businesses can build on existing business rules for content selection, provide mobile context to existing paper-style content, while reusing and reformatting print page-styled content into mobile device responsive documents to meet growing consumer demands for anytime, anywhere access for information. Oracle Documaker Mobile leverages industry standards and industry standard tools outside of Documaker to create and style documents designed for mobile delivery.

“The proliferation of mobile options has crossed all generations from teenagers to octogenarians and the new hyper connected consumer is demanding 24/7 instant access to traditionally paper-based content. Financial services companies, insurance carriers, and healthcare payers all are looking to address the ever increasing demand for delivering content on any device,” said Srini Venkatasanthanam, vice president insurance products, Oracle Insurance. “Documaker Mobile addresses this need and much more to help companies that are currently struggling with delivering highly regulated content that is viewable and actionable across any device.”

Oracle Documaker Mobile leverages the new Oracle Documaker Enterprise Edition 12.4.0—an enterprise-class foundational component for content delivery—and enables digital output of insurance content such as explanation of benefits, quotes, rate comparisons, and contracts while adhering to open international industry standards. The Documaker user interface is now available in nine languages in addition to English: Dutch, German, French, Indonesian, Japanese, Polish, Portuguese, Simplified Chinese, and Spanish. Further, users can create the new Adobe XFA fill enabled PDFs to include field validation and formatting, expanding Oracle Documaker’s customer-centric omni-channel approach to comprehensive customer communication.

“At Allianz Life we needed an advanced and flexible solution for interactive correspondence and document distribution for our customers,” said Troy Hamlin, life vice president of IT application development, Allianz Life. “We selected Oracle Documaker Enterprise Edition for Documaker Interactive and Document Factory and are extremely pleased with the product’s architecture and performance.”

Contact Info Valerie Beaudett
+1.650.400.7833 Mary Tobin
O'Keefe & Company
+1.503.658.7396 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


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

Valerie Beaudett

  • +1.650.400.7833

Mary Tobin

  • +1.503.658.7396

Follow Oracle Corporate

Categories: Database, Vendor

DBA Workloads Change as Big Data Solutions Mature

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

Today, everyone realizes that in order to reach their full performance potential, Big Data applications require some tuning. The tuning isn't easy, it's not free, and responsibility for understanding requirements and implementing the appropriate tuning methodology falls squarely on the shoulders of the database administrator. Read on to learn more.

Categories: Database

SQL Server 2014 Service Pack 1 Now Available for Download

Today, we are pleased to announce the availability of SQL Server 2014 Service Pack 1 (SP1). The Service Pack is available for download on the Microsoft Download Center. This upgrade is available to all customers with existing SQL Server 2014 deployments.

For more highlights of the release, please read the Knowledge Base Article for Microsoft SQL Server 2014 SP1. To obtain SQL Server 2014 SP1 with its improved supportability, please visit the links below.


Categories: Database

Oracle Collaborates with Mirantis to Bring Database as a Service Powered by Oracle Multitenant to OpenStack-Based Private Clouds

Oracle Database News - Fri, 05/15/2015 - 19:36
Press Release Oracle Collaborates with Mirantis to Bring Database as a Service Powered by Oracle Multitenant to OpenStack-Based Private Clouds Fast, Easy Provisioning Helps Accelerate Private Cloud Deployments, Oracle Solaris Integration Allows OpenStack to Tap Into Software in Silicon

Redwood Shores, Calif.—May 15, 2015

Ahead of the OpenStack Summit in Vancouver, British Columbia, Oracle announced a collaboration with Mirantis to enable Oracle Solaris and Mirantis OpenStack users to accelerate application and database provisioning in private cloud environments via Murano, the application project in the OpenStack ecosystem. This effort brings Oracle Database 12c and Oracle Multitenant deployed on Oracle Solaris to Murano—the first Oracle cloud-ready products to be available in the catalog.

Oracle OpenStack for Oracle Solaris combines the advanced security, enterprise class reliability, and ease of administration of the Oracle Solaris operating system with the agility of OpenStack to create the premier, comprehensive cloud platform for running enterprise applications and Oracle Database.

Oracle Multitenant, introduced with Oracle Database 12c, allows multiple Pluggable Databases to be supported within a single Multitenant Container Database. Each Pluggable Database provides a secure, isolated environment in which to run applications. The consolidated Container Databases represent a single environment for a cloud provider to support, enabling tremendous economies of scale. In just a few clicks, cloud users and developers can:

  • Securely provision Pluggable Databases on Oracle Solaris from OpenStack
  • Allow applications to securely access new and existing Pluggable  Databases from within OpenStack
  • Enable OpenStack applications to take advantage of the advanced security, performance and efficiency of Software in Silicon technology built into Oracle’s upcoming systems based on SPARC M7 processors running Oracle Database 12c on Oracle Solaris.

“We are excited to announce our work with Mirantis to make it even simpler to combine the deep integration of Oracle Solaris, Oracle Database 12c and Oracle Multitenant with OpenStack. It lets customers take advantage of the security of Oracle Solaris and the power of Software in Silicon technology, built into Oracle’s upcoming SPARC M7 processor-based systems, in their private OpenStack clouds,” said Markus Flierl, vice president, Oracle Solaris.

“Oracle databases are critical for many enterprises,” said Mirantis CEO Adrian Ionel. “The integration between Oracle Database 12c, Oracle Solaris and Mirantis OpenStack in the upcoming Mirantis OpenStack 6.1 release will allow those customers to quickly deploy Oracle Database applications with a few clicks.”

The two companies will demonstrate the technology at the OpenStack Summit in Vancouver, BC, May 18-22 in booths P9 and P7. Availability is slated in Q2 CY 2015.

Oracle Solaris Vice President Markus Flierl will present at OpenStack Summit on Tuesday, May 19, from 2:50 p.m. to 3:30 p.m., discussing “Making OpenStack Secure and Compliant for the Enterprise.”

Additional Information

Join Oracle on LinkedIn and follow @Oracle on Twitter. To learn more about Oracle Solaris, please follow @ORCL_Solaris.

Contact Info Michelle Jenkins
+1.425.945.8306 Drew Smith
Blanc and Otus
+1.415.856.5127 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


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

Michelle Jenkins

  • +1.425.945.8306

Drew Smith

  • +1.415.856.5127

Follow Oracle Corporate

Categories: Database, Vendor

Bulk Exceptions in Oracle

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

When using BULK COLLECT it's possible to see all of the exceptions thrown for the bulk collection by coding the exception handler properly.  Read on to see how to implement such an exception handler.

Categories: Database

Oracle Extends Mobile Capabilities of the Oracle Marketing Cloud

Oracle Database News - Thu, 05/14/2015 - 00:45
Oracle Extends Mobile Capabilities of the Oracle Marketing Cloud Innovations for mobile marketing enhance customer experience and drive revenue by personalizing content, improving engagement and increasing conversion rates

Redwood Shores, Calif. — May 12, 2015 — To help marketers and advertisers improve revenue, conversions and engagement from mobile marketing, Oracle has introduced new mobile capabilities to the Oracle Marketing Cloud that enable marketers and advertisers to leverage valuable mobile insights to deliver relevant content and media to their audiences.

Mobile is increasingly becoming the channel of choice for consumers. According to The Digital Consumer Report 2014, by Nielsen, 87 percent of U.S. smartphone and tablet owners are using their mobile devices to buy products and services. Marketers can now use mobile-specific insights to deliver messages in context and improve cross-channel marketing effectiveness.

“The mobile-first consumer presents a huge opportunity for marketers to leverage insights to drive meaningful and personalized conversations with prospects and customers,” said Steve Krause, group vice president, Product Management, for Oracle Marketing Cloud. “Oracle is creating a holistic view of mobile interactions that help marketers orchestrate personalized customer experiences and drive revenue across any channel, including email, SMS, display, social and web.”

To enable brands and advertisers to better target prospects and customers with relevant advertising on their mobile devices, the Oracle Marketing Cloud also includes enhancements to its mobile Data Management Platform (DMP). Powered by the Oracle ID Graph, it allows marketers to connect identities across disparate mobile devices to one person. Marketers can use the DMP to build sophisticated audience segments across owned and third-party data and push that data into hundreds of pre-integrated paid media channels across display, search and paid social. The mobile DMP can be utilized by marketers and advertisers in all industries.

To improve engagement and customer retention for consumer marketers, the Oracle Marketing Cloud released the following capabilities:

Advanced Insights: Premium link tracking enables embedding of branded short URLs in SMS messages for deep insights into how well campaigns perform by monitoring SMS click-through rates and conversions. Engaging Mobile Content: Delivers rich Multimedia Messaging Service (MMS) messages to mobile devices as part of a cross-channel orchestration strategy. MMS can drive deeper engagement by delivering mobile coupons and promotions that include color and images. Effective Notifications: A push notification sent to Android devices where the notification itself includes an image such as a coupon, encourages users to open the notification and further engage with the marketer’s app. Oracle’s recently released push campaign manager lets marketers design, configure and manage all push campaigns for even greater personalization, with all customer data tied back to a contact profile table. Seamless Mobile Integration: Brings customers back to a mobile app by embedding mobile deep links in push and email messages. When customers click on the links, offers are opened directly inside the mobile app, creating a more seamless mobile experience. Simple Mobile Campaign Management: Equipped with out-of-the-box templates to support various SMS use cases and easy-to-use frameworks for building two-way customer interactions, including acquisition, awareness, intent, purchase and engagement, and loyalty. Responsive Engagement Tools: New SMS Keyword Listeners allow organizations to listen and respond as customers’ text in keywords that trigger orchestrated responses. Chaining these inbound and outbound messages together to enable discovery about their customers and automate responses.

To meet the demands of the mobile workforce, Oracle Marketing Cloud also introduces new mobile capabilities for business-to-business (B2B) marketers:

Real-time Sales Enablement: Let sales executives use their mobile device to access customer profile and digital body language information such as web, email and social activity. This puts rich contact data literally in the hands of an on-the-go sales rep, wherever the rep is. Personalized push notifications: Improve campaign reach and effectiveness with personalized push notifications. A marketer can simply embed push notifications right into the campaign workflow when defining a cross-channel customer journey. Enhanced Responsive Design: Show how an email or landing page will scale across devices, including a mobile or tablet experience. Track Engagement: Trackable links in either SMS or Push messages orchestrated within campaigns better measure engagement with content. Extend Mobile Functionality through Oracle AppCloud: Include mobile vendors of choice for SMS and MMS messaging within the campaign canvas to send images, manage short and long codes, and send QR codes to customers. Additional Information Learn more about Oracle Marketing Cloud and Oracle Marketing Cloud Cross-Channel Marketing solutions by following us on Twitter and Facebook and reading our Modern Marketing blog. Learn more about Oracle Marketing Cloud’s Data Management Platform and the Oracle ID Graph.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


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


Contact Info


Diana Wong
+1. 650.506.2757

Simon Jones

Blanc & Otus

Categories: Database, Vendor

Oracle Utilities Work and Asset Management 2.1 Empowers Enterprises to Address Business Challenges

Oracle Database News - Wed, 05/13/2015 - 13:10
Press Release Oracle Utilities Work and Asset Management 2.1 Empowers Enterprises to Address Business Challenges Upgraded Oracle solution helps utilities optimize the asset lifecycle, reduce risk, and improve investment planning

Redwood Shores, Calif.—May 13, 2015

Oracle Utilities announced the availability of Oracle Utilities Work and Asset Management 2.1 to help electric, gas, and water utilities better leverage assets and their data for mission-critical activities including investment planning, enterprise business management, and risk reduction. This new release puts Oracle Utilities Work and Asset Management 2.1 on the same technology framework as Oracle’s other utility-specific applications, offering a modern, unified asset management solution that makes it easier for businesses to address customer service and operational challenges.   As data continues to cross organizational silos and influence how consumers make energy choices, Oracle Utilities Work and Asset Management 2.1 offers utilities a new, proactive way to increase their capacity for enterprise process management and customer service. The upgraded solution provides an embedded analytics feature that helps utilities automate data-based tasks and continually improve work planning and scheduling to get more done with fewer resources. As well, the interface can be personalized based on job role to help accelerate productivity.   “Work and asset management is now a strategic and data-heavy endeavor with the ability to directly affect business and community health, and utilities need to be able to treat it as such,” said Rodger Smith, senior vice president and general manager, Oracle Utilities. “Oracle recognizes this need, and we are addressing it with Oracle Utilities Work and Asset Management 2.1, which is one of the most significant investments in work and asset management for the utilities industry in the past decade.”   As a single system for centralizing and sharing data for every asset, Oracle Utilities Work and Asset Management 2.1 helps utilities make better decisions about where and when to invest capital and human resources, reduce costs by extending the value of existing investments, and ensure that best practices are applied at work while also addressing regulatory requirements and customer expectations for service, safety, and the environment. For example, a vice president of operations who needs to understand where to invest in the grid can now have all necessary data centralized in an easy-to-view and easy-to-understand format and be able to determine how capital should be spent.   Oracle Utilities Work and Asset Management 2.1 also helps utilities better identify and reduce risk for workers and the community through a suite of real-time analytics that prevent failure, monitor conditions, and determine optimized maintenance strategies. For example, the upgraded solution includes condition-based scoring to better manage risk and uses the new interface to provide easier visibility. With this type of scoring, utilities can consider multiple variables to determine health on an asset-specific basis. They can also continually update the score to reflect any changes to conditions, such as maintenance being performed. Through storage and recall of the asset health score, utilities can now understand risk in real time all the time, improving the effectiveness of repair-or-replace decisions.   Because it is built using the most-advanced protocols and application development tools, the solution is easy to enhance without having to customize or compromise upgradability. In addition, its integration with Oracle’s enterprise layer of utility solutions enables customers with multiple Oracle Utilities products to more readily share information across applications to streamline operations. They can also use the same skill set to manage multiple Oracle systems, reducing the cost and resources required to support business processes.   “By getting Oracle Utilities Work and Asset Management on the same technology platform as Oracle’s other utility applications, the company is highlighting the strategic value of work and asset management through this product investment,” said Marcus Torchia, research manager, IDC. “The solution is well positioned to compete globally by helping utilities deal with critical business challenges such as using data to improve risk management and extracting more value from sensor-based assets that make up an increasingly large part of utility infrastructure.”   Contact Info Samantha Thai
510.917.5564 Mary Tobin
O'Keeffe & Company
503.658.7396 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


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

Samantha Thai

  • 510.917.5564

Mary Tobin

  • 503.658.7396



Follow Oracle Corporate

Categories: Database, Vendor

Introduction to IBM Datacap Taskmaster Capture 8.1 Development Kit

IBM - DB2 and Informix Articles - Tue, 05/12/2015 - 05:00
Learn about the cross-industry and industry specific sample applications and tools available in the IBM Datacap Taskmaster Capture Development Kit (DDK), and find links to each of the components.
Categories: Database

pgBadger 7.0 released !

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

Paris, France - Mai 11th, 2014

DALIBO is proud to announce the release of pgBadger 7.0.

pgBadger is a PostgreSQL performance analyzer, built for speed with fully detailed reports based on your PostgreSQL log files.

New reports and support for

This major release adds more useful reports and features. One of the longest feature request have been also implemented, support to auto_explain extension. EXPLAIN plan will be added together with top slowest queries when available in log files. Thanks to the kind authorization of depesz, a link to automatically open directly the explain plan on is also available.

List of other new reports in this release:

  • Events (panic, fatal, error and warning) distribution per 5 minutes.
  • Per application details (total duration and times executed) for each query reported in Top Queries. The details are visible from a button called "App(s) involved".
  • Cumulated queries durations per user.

Three new reports to help identifying queries cancelled on secondaries clusters:

  • Number of cancelled queries (graph)
  • Queries generating the most cancellation (N)
  • Queries most cancelled.

For the complete list of changes, please checkout the release note on

Links & Credits

DALIBO would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially Mael Rimbault, Thomas Reiss, Korriliam, rlowe and Antti Koivisto.

pgBadger is an open project. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools or directly on our mailing list.

Links :

About pgBadger :

pgBagder is a new generation log analyzer for PostgreSQL, created by Gilles Darold (also author of ora2pg, the powerful migration tool). pgBadger is a fast and easy tool to analyze your SQL traffic and create HTML5 reports with dynamics graphs. pgBadger is the perfect tool to understand the behavior of your PostgreSQL servers and identify which SQL queries need to be optimized.

Docs, Download & Demo at

About DALIBO :

DALIBO is the leading PostgreSQL company in France, providing support, trainings and consulting to its customers since 2005. The company contributes to the PostgreSQL community in various ways, including : code, articles, translations, free conferences and workshops

Check out DALIBO's open source projects at

Categories: Database, Open Source