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!


Arcor, ConAgra Foods, MOM Brands, and Procter & Gamble Recognized for Excellence

Oracle Database News - Thu, 12/18/2014 - 07:00
Arcor, ConAgra Foods, MOM Brands, and Procter & Gamble Recognized for Excellence Oracle announces winners of the fourth annual consumer goods industry excellence awards Redwood Shores, Calif. – December 18, 2014News Facts Oracle has awarded four consumer goods companies with Oracle Consumer Goods Industry Excellence Awards. The awards program recognizes consumer goods companies that use Oracle technology solutions and adopt industry best practices to help them drive innovation and grow their businesses. The Oracle Consumer Goods Industry Excellence Awards program recognizes achievement in four categories. This year’s winners include: Business Transformation in the Cloud Award: Arcor, Buenos Aries, Argentina Innovation Lifecycle Management Award: ConAgra Foods, Omaha, Nebraska Demand-Driven Operations Award: MOM Brands, Lakeville, Minnesota Retail and Consumer Insights Award: Procter & Gamble, Cincinnati, Ohio Supporting Quotes “The 2014 Oracle Consumer Goods Industry Excellence award winners demonstrate how innovative consumer goods companies are transforming their businesses and achieving results with modern industry solutions across the enterprise,” said Cassie Moren, senior director, Consumer Goods and Retail Solutions Marketing, Oracle. Supporting Resources Oracle Consumer Goods Industry Solutions Oracle Comprehensive Trade Management Solution Oracle Innovation Lifecycle Management Solution Procter & Gamble Big Data Case Study


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

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

Valerie Beaudett

Mary Tobin
O’Keeffe & Company

Categories: Database, Vendor

IBM Datacap 9.0 DDK custom actions

IBM - DB2 and Informix Articles - Thu, 12/18/2014 - 06:00
Actions are the building blocks of an IBM Datacap application. Here you can find the information to create your own actions to be used within an IBM Datacap application. When you cannot do an application function by using standard actions, you can write custom actions to fulfill your processing needs.
Categories: Database

IBM Datacap 9.0 DDK Datacap Desktop Custom Panels

IBM - DB2 and Informix Articles - Thu, 12/18/2014 - 06:00
User interaction with IBM Datacap can occur when physically scanning pages or when reviewing problems found while processing pages. Here, you can find the information to create your own panels to be used within an IBM Datacap application. Custom panels present alternative layouts and manipulation of fields and data.
Categories: Database

IBM Datacap 9.0 DDK sample applications

IBM - DB2 and Informix Articles - Thu, 12/18/2014 - 06:00
The DDK contains additional IBM Datacap 9.0 sample applications. These samples show various ways to capture and validate documents, providing examples of application structure and use of various actions that may be useful in your applications.
Categories: Database

PostgreSQL 9.4 Increases Flexibility, Scalability and Performance

PostgreSQL News - Thu, 12/18/2014 - 01:00

18 DECEMBER 2014: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.4, the latest version of the world's leading open source database system. This release adds many new features which enhance PostgreSQL's flexibility, scalability and performance for many different types of database users, including improvements to JSON support, replication and index performance.


With the new JSONB data type for PostgreSQL, users no longer have to choose between relational and non-relational data stores: they can have both at the same time. JSONB supports fast lookups and simple expression search queries using Generalized Inverted Indexes (GIN). Multiple new support functions enable users to extract and manipulate JSON data, with a performance which matches or surpasses the most popular document databases. With JSONB, table data can be easily integrated with document data for a fully integrated database environment.

"JSONB brings PostgreSQL to the JavaScript development community by allowing JSON data to be stored and queried natively. Node.js and other server-side JavaScript frameworks can benefit from the safety and robustness of PostgreSQL, while still storing data in the schema-less format that they prefer," said Matt Soldo, Product Manager, Heroku Postgres.


In 9.4, Logical Decoding supplies a new API for reading, filtering and manipulating the PostgreSQL replication stream. This interface is the foundation for new replication tools, such as Bi-Directional Replication, which supports the creation of multi-master PostgreSQL clusters. Other improvements in the replication system, such as replication slots and time-delayed replicas, improve management and utility of replica servers.

"The main reason behind our immediate adoption of PostgreSQL 9.4 in production is the new Logical Decoding feature," said Marco Favale, Cartographic Production Manager of Navionics. "The ability to write custom and flexible output plugins will allow us to transparently collect changes on selected tables and replicate changes where we like, by removing heavier - and more complex to manage - trigger based replication solutions."

"Zalando relies on the stability and performance of hundreds of PostgreSQL database servers to continuously serve millions of customers all around Europe," said Valentine Gogichashvili, Team Lead Database Operations at Zalando Technologies. "We are excited to run time-delayed standby servers which work out of the box, and will evaluate the new bi-directional replication tools as soon as they are released."


Version 9.4 also introduces multiple performance improvements which will allow users to get even more out of each PostgreSQL server. These include:

  • Improvements to GIN indexes, making them up to 50% smaller and up to 3X faster.
  • Concurrently updatable Materialized Views for faster, more up-to-date reporting.
  • Rapidly reload the database cache on restart using pg_prewarm.
  • Faster parallel writing to the PostgreSQL transaction log.
  • Support for Linux Huge Pages for servers with large memory.

"We will definitely benefit from concurrent refresh of materialised views, delayed standby servers (which will make our disaster recovery even more robust) as well as the usual performance improvements every new release carries on," added Marco Favale.

Links About PostgreSQL

PostgreSQL is the leading open source database system, with a global community of thousands of users and contributors and dozens of companies and organizations. The PostgreSQL Project builds on over 25 years of engineering, starting at the University of California, Berkeley, and has an unmatched pace of development today. PostgreSQL's mature feature set not only matches top proprietary database systems, but exceeds them in advanced database features, extensibility, security and stability. Learn more about PostgreSQL and participate in our community on our web page.

Categories: Database, Open Source


Oracle Database News - Wed, 12/17/2014 - 22:30

Oracle Corporation (NYSE: ORCL) today announced that fiscal 2015 Q2 Total Revenues were up 3% to $9.6 billion. Software and Cloud Revenues was up 5% to $7.3 billion. Cloud software-as-a-service (SaaS), platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) revenue was up 45% to $516 million. Hardware Systems revenues were up 1% to $1.3 billion. GAAP operating income was up 4% to $3.5 billion, and the GAAP operating margin was 37%. Non-GAAP operating income was up 3% to $4.4 billion, and the non-GAAP operating margin was 46%. GAAP net income was down 2% to $2.5 billion while non-GAAP net income was down 1% to $3.1 billion. GAAP earnings per share were $0.56, unchanged from last year, while non-GAAP earnings per share were up 1% at $0.69. GAAP operating cash flow on a trailing twelve-month basis was $15.3 billion.

Without the impact of the US dollar strengthening compared to foreign currencies, Oracle’s reported Q2 GAAP and non-GAAP earnings per share would have been up 5%; Q2 Total Revenues would have been up 7%; Software and Cloud revenues would have been up 8%; and Hardware Systems revenues would have been up 4%.

“We continue to deliver industry-leading operating margins and cash flow even after adding the thousands of specialized sales people and engineers necessary to accelerate the growth of our new cloud businesses,” said Oracle CEO, Safra Catz.

“Total Q2 new cloud bookings grew at a rate of more than 140%,” said Oracle CEO, Mark Hurd. “We now have over 600 ERP Fusion Cloud customers – that’s five-times more ERP customers than Workday.”

“By Q4 of this year we expect our new cloud bookings to exceed $250 million,” said Oracle Chairman and Chief Technology Officer Larry Ellison. “Next fiscal year our new cloud bookings will be well over the billion dollars mark."

The Board of Directors also declared a quarterly cash dividend of $0.12 per share of outstanding common stock. This dividend will be paid to stockholders of record as of the close of business on January 7, 2015, with a payment date of January 28, 2015.

Q2 Fiscal 2015 Earnings Conference Call and Webcast

Oracle will hold a conference call and webcast today to discuss these results at 2:00 p.m. Pacific. You may listen to the call by dialing (816) 287-5563, Passcode: 425392. To access the live webcast of this event, please visit the Oracle Investor Relations website at In addition, Oracle’s Q2 results and Fiscal 2015 financial tables are available on the Oracle Investor Relations website.

A replay of the conference call will also be available by dialing (855) 859-2056 or (404) 537-3406, Pass Code: 46975514.

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 or contact Investor Relations at or (650) 506-4073.

TrademarksOracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.“Safe Harbor" Statement

Statements in this press release relating to Oracle's future plans, expectations, beliefs, intentions and prospects, including statements regarding our cloud subscription run rate, the timing of the delivery of our 10,000th Engineered Systems unit, and our plans to increase our focus on the Cloud and become number one in SaaS and PaaS, are "forward-looking statements" and are subject to material risks and uncertainties. Many factors could affect our current expectations and our actual results, and could cause actual results to differ materially. We presently consider the following to be among the important factors that could cause actual results to differ materially from expectations: (1) Economic, political and market conditions, including the continued slow economic recovery in the U.S. and other parts of the world, can adversely affect our business, results of operations and financial condition, including our revenue growth and profitability, which in turn could adversely affect our stock price. (2) We may fail to achieve our financial forecasts due to such factors as delays or size reductions in transactions, fewer large transactions in a particular quarter, unanticipated fluctuations in currency exchange rates, delays in delivery of new products or releases or a decline in our renewal rates for support contracts. (3) Our cloud computing strategy, including our Oracle Cloud Software-as-a-Service, Platform-as-a-Service and Infrastructure-as-a-Service offerings, may not be successful. (4) If we are unable to develop new or sufficiently differentiated products and services, or to enhance and improve our products and support services in a timely manner or to position and/or price our products and services to meet market demand, customers may not buy new software licenses, cloud software subscriptions or hardware systems products or purchase or renew support contracts. (5) Our international sales and operations subject us to additional risks that can adversely affect our operating results, including risks relating to foreign currency gains and losses. (6) If the security measures for our software, hardware, services or Oracle Cloud offerings are compromised or if such offerings contain significant coding, manufacturing or configuration errors, we may experience reputational harm, legal claims and financial exposure. (7) We have an active acquisition program and our acquisitions may not be successful, may involve unanticipated costs or other integration issues or may disrupt our existing operations. A detailed discussion of these factors and other risks that affect our business is contained in our SEC filings, including our most recent reports on Form 10-K and Form 10-Q, particularly under the heading "Risk Factors." Copies of these filings are available online from the SEC or by contacting Oracle Corporation's Investor Relations Department at (650) 506-4073 or by clicking on SEC Filings on Oracle’s Investor Relations website at All information set forth in this press release is current as of June 19, 2014. Oracle undertakes no duty to update any statement in light of new information or future events.

Contact Info

Ken Bond
Oracle Investor Relations

Deborah Hellinger
Oracle Corporate Communications

Categories: Database, Vendor

Results are Beautiful: 4 Best Practices for Big Data in Healthcare

When you put big data to work, results can be beautiful. Especially when those results are as impactful as saving lives. Here are four best practice examples of how big data is being used in healthcare to improve, and often save, lives.

Aerocrine improves asthma care with near-real-time data

Millions of asthma sufferers worldwide depend on Aerocrine monitoring devices to diagnose and treat their disease effectively. But those devices are sensitive to small changes in ambient environment. That’s why Aerocrine is using a cloud analytics solution to boost reliability. Read more.

Virginia Tech advances DNA sequencing with cloud big data solution

DNA sequencing analysis is a form of life sciences research that has the potential to lead to a wide range of medical and pharmaceutical breakthroughs. However, this type of analysis requires supercomputing resources and Big Data storage that many researchers lack. Working through a grant provided by the National Science Foundation in partnership with Microsoft, a team of computer scientists at Virginia Tech addressed this challenge by developing an on-demand, cloud-computing model using the Windows Azure HDInsight Service. By moving to an on-demand cloud computing model, researchers will now have easier, more cost-effective access to DNA sequencing tools and resources, which could lead to even faster, more exciting advancements in medical research. Read more.

The Grameen Foundation expands global humanitarian efforts with cloud BI

Global nonprofit Grameen Foundation is dedicated to helping as many impoverished people as possible, which means continually improving the way Grameen works. To do so, it needed an ongoing sense of its programs’ performance. Grameen and Microsoft brought people and technology together to create a BI solution that helps program managers and financial staff: glean insights in minutes, not hours; expand services to more people; and make the best use of the foundation’s funding. Read more.

Ascribe transforms healthcare with faster access to information

Ascribe, a leading provider of IT solutions for the healthcare industry, wanted to help clinicians identify trends and improve services by supplying faster access to information. However, exploding volumes of structured and unstructured data hindered insight. To solve the problem, Ascribe designed a hybrid-cloud solution with built-in business intelligence (BI) tools based on Microsoft SQL Server 2012 and Windows Azure. Now, clinicians can respond faster with self-service BI tools. Read more.

Learn more about Microsoft’s big data solutions

Categories: Database

Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3

This blog post was authored by: Matt Usher, Senior PM on the Microsoft Analytics Platform System (APS) team

Microsoft is happy to announce the release of the Analytics Platform System (APS) Appliance Update (AU) 3. APS is Microsoft’s big data in a box appliance for serving the needs of relational data warehouses at massive scale. With this release, the APS appliance supports new scenarios for utilizing Power BI modeling, visualization, and collaboration tools over on premise data sets. In addition, this release extends the PolyBase to allow customers to utilize the HDFS infrastructure in Hadoop for ORC files and directory modeling to more easily integrate non-relational data into their data insights.

The AU3 release includes:

  • PolyBase recursive Directory Traversal and ORC file format support
  • Integrated Data Management Gateway enables query from Power BI to on premise APS
  • TSQL compatibility improvements to reduce migration friction from SQL Server SMP
  • Replatformed to Windows Server 2012 R2 and SQL Server 2014
PolyBase Directory Traversal and ORC File Support

PolyBase is an integrated technology that allows customers to utilize the skillset that they have developed in TSQL for querying and managing data in Hadoop platforms. With the AU3 release, the APS team has augmented this technology with the ability to define an external table that targets a directory structure as a whole. This new ability unlocks a whole new set of scenarios for customers to utilize their existing investments in Hadoop as well as APS to provide greater insight into all of the data collected within their data systems. In addition, AU3 introduces full support for the Optimized Row Column (ORC) file format – a common storage mechanism for files within Hadoop.

As an example of this new capability, let’s examine a customer that is using APS to host inventory and Point of Sale (POS) data in an APS appliance while storing the web logs from their ecommerce site in a Hadoop path structure. With AU3, the customer can simply maintain a structure for their logs in Hadoop in a structure that is easy to construct such as year/month/date/server/log for simple storage and recovery within Hadoop that can then be exposed as a single table to analysts and data scientists for insights.

In this example, let’s assume that each of the Serverxx folders contains the log file for that server on that particular day. In order to surface the entire structure, we can construct an external table using the following definition:

	[Uri] NVARCHAR(256) NULL,
	[Server] NVARCHAR(256) NULL,
	[Referrer] NVARCHAR(256) NULL
	FILE_FORMAT = LogFileFormat,

By setting the LOCATION targeted at the //Logs/ folder, the external table will pull data from all folders and files within the directory structure. In this case, a simple select of the data will return data from only the last 10 entries regardless of the log file that contains the data:


The results are:

Note: PolyBase, like Hadoop, will not return results from hidden folders or any file that begins with an underscore (_) or period(.).

Integrated Data Management Gateway

With the integration of the Microsoft Data Management Gateway into APS, customers now have a scale-out compute gateway for Azure cloud services to more effectively query sophisticated sets of on-premises data.  Power BI users can leverage PolyBase in APS to perform more complicated mash-ups of results from on-premises unstructured data sets in Hadoop distributions. By exposing the data from the APS Appliance as an OData feed, Power BI is able to easily and quickly consume the data for display to end users.

For more details, please look for an upcoming blog post on the Integrated Data Management Gateway.

TSQL Compatibility improvements

The AU3 release incorporates a set of TSQL improvements targeted at richer language support to improve the types of queries and procedures that can be written for APS. For AU3, the primary focus was on implementing full error handling within TSQL to allow customers to port existing applications to APS with minimal code change and to introduce full error handling to existing APS customers. Released in AU3 are the following keywords and constructs for handling errors:

In addition to the error handling components, the AU3 release also includes support for the XACT_STATE scalar function that is used to indicate the current running transaction state of a user request.

Replatformed to Windows Server 2012 R2 and SQL Server 2014

The AU3 release also marks the upgrade of the core fabric of the APS appliance to Windows Server 2012 R2 and SQL Server 2014. With the upgrade to the latest versions of Microsoft’s flagship server operating system and core relational database engine, the APS appliance takes advantage of the improved networking, storage and query execution components of these products. For example, the APS appliance now utilizes a virtualized Active Directory infrastructure which helps to reduce cost and increase domain reliability within the appliance helping to make APS the price/performance leader in the big data appliance space.

APS on the Web

To learn more about the Microsoft Analytics Platform System, please visit us on the web at

Categories: Database

Six Benefits to Planning for SQL Server 2005 and Windows Server 2003 End of Support Now

As the end of 2014 nears, now is the perfect time to review IT infrastructure plans for the coming year.  If you haven’t made supportability a key initiative for 2015, there are some important dates that you should know about:

After the end of extended support security updates will no longer be available for these products.  Staying ahead of these support dates will help achieve regulatory compliance and mitigate potential future security risks. That means SQL Server 2005 users, especially those running databases on Windows Server 2003, should make upgrading the data platform an IT priority. 

Security isn’t the only reason to think about upgrading. Here are six benefits to upgrading and migrating your SQL Server 2005 databases before the end of extended support:

  1. Maintain compliance – It will become harder to prove compliance with the latest regulations such as the upcoming PCI DSS 3.0. Protect your data and stay on top of regulatory compliance and internal security audits by running an upgraded version of SQL Server.
  2. Achieve breakthrough performance – Per industry benchmarks, SQL Server 2014 delivers 13x performance gains relative to SQL Server 2005 and 5.5x performance gains over SQL Server 2008.  Customers using SQL Server 2014 can further accelerate mission critical applications with up to 30x transaction performance gains with our new in-memory OLTP engine and accelerate queries up to 100x with our in-memory columnstore. 
  3. Virtualize and consolidate with Windows Server – Scale up on-premises or scale-out via private cloud with Windows Server 2012 R2. Reduce costs by consolidating more database workloads on fewer servers, and increase agility using the same virtualization platform on-premises and in the cloud.
  4. Reduce TCO and increase availability with Microsoft AzureAzure Virtual Machines can help you reduce the total cost of ownership of deployment, management, and maintenance of your enterprise database applications. And, it’s easier than ever to upgrade your applications and achieve high availability in the cloud using pre-configured templates in Azure.
  5. Use our easy on-ramp to cloud for web applications – The new preview of Microsoft Azure SQL Database announced last week has enhanced compatibility with SQL Server that makes it easier than ever to migrate from SQL Server 2005 to Microsoft Azure SQL Database. Microsoft’s enterprise-strength cloud brings global scale and near zero maintenance to database-as-a-service, and enables you to scale out your application on demand.
  6. Get more from your data platform investments - Upgrading and migrating your databases doesn’t have to be painful or expensive. A Forrester Total Economic ImpactTM of Microsoft SQL Server study found a payback period of just 9.5 months for moving to SQL Server 2012 or 2014.

Here are some additional resources to help with your upgrade or migration:

Categories: Database

Oracle Communications WebRTC Session Controller Extends WebRTC Functionality to Mobile Applications

Oracle Database News - Tue, 12/16/2014 - 14:00
Oracle Communications WebRTC Session Controller Extends WebRTC Functionality to Mobile ApplicationsCommunications service providers and enterprises can now offer WebRTC-based capabilities in native iOS or Android client applicationsREDWOOD SHORES, Calif. – Dec. 16, 2014News Summary

In response to the growing demand for real-time communications (RTC) anytime, anywhere, and from virtually any device, many communications service providers (CSPs) and enterprises are now offering browser-based WebRTC capabilities and services. The latest release of Oracle Communications WebRTC Session Controller provides the secure and reliable functionalities that users want—such as voice calling, video, and chat—within an iOS and Android client application for a seamless, device-independent customer experience.

News Facts Oracle today announced the release of Oracle Communications WebRTC Session Controller 7.1, which brings WebRTC support to native mobile iOS and Android applications for a seamless, cross-device customer experience. The new release also improves bandwidth utilization and cost savings by intelligently switching among anchored media, peer-2-peer (P2P) media, and P2P data depending on the CSP’s or enterprise’s network topology. Oracle Communications WebRTC Session Controller provides better connectivity into CSP and enterprise environments with restrictive firewalls by supporting advanced Network Address Translation traversal functionality. In addition, the new release enables secure and reliable RTC services by delivering GSMA’s Rich Communications Suite (RCS) capabilities through Oracle Communications WebRTC Session Controller APIs. This functionality allows CSPs to extend their RCS investments to devices that are WebRTC-capable.
Product Details The latest release of Oracle Communications WebRTC Session Controller offers support for: Integrating highly scalable media server platforms to offload complex, hardware-intensive media processing such as audio/video transcoding, recording, and conferencing Instant messaging through a Message Session Relay Protocol Gateway, allowing client applications to access a messaging server and eliminating the need to run a separate application Virtualization, enabling CSPs and enterprises to deploy solutions in a cloud environment free from hardware requirements Oracle Communications WebRTC Session Controller improves network integration with standard, off-the-shelf interfaces for policy and media servers. latest release provides a consistent user experience across applications and devices via a new flexible client registration management system that can efficiently handle WebRTC subscribers with multiple simultaneous sessions and identities across numerous devices.
Supporting Quotes “The demand for real-time communications from any device will only continue to grow, from within both web browsers and mobile apps,” said Dean Bubley, director of Disruptive Analysis. “Oracle’s integration of WebRTC-based communications with new and existing mobile clients aligns with this broad trend towards embedded voice and video.” “The latest release of Oracle Communications WebRTC Session Controller further demonstrates Oracle’s dedication to improving the mobile user experience. We are rapidly innovating to remove the road blocks to real-time communications from anywhere, at any time, and from any device,” said Bhaskar Gorti, senior vice president and general manager, Oracle Communications.
Supporting Resources 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.


Kaitlin McCready

Janice Clayton

Categories: Database, Vendor

Introduction to IBM Datacap Taskmaster Capture 8.1 Development Kit

IBM - DB2 and Informix Articles - Tue, 12/16/2014 - 06: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

Tuning guidelines and principles to enhance database performance in WebSphere Commerce

IBM - DB2 and Informix Articles - Tue, 12/16/2014 - 06:00
You can modify the default WebSphere Commerce data model to maintain optimal system performance during periods of high user connectivity, such as peak shopping events. A heavy workload, simulating a peak shopping event on the original data model, is run and analyzed. Based on that analysis, the data model is reconfigured to optimize database and application performance.
Categories: Database

Now Available: Updated SQL Server PHP and JDBC Drivers

As part of SQL Server’s ongoing interoperability program, we are pleased to announce the general availability of two SQL Server drivers: the Microsoft JDBC Driver for SQL Server and the SQL Server Driver for PHP are now available!

Both drivers provide that robust data access to Microsoft SQL Server and Microsoft Azure SQL Database. The JDBC Driver for SQL Server is a Java Database Connectivity (JDBC) type 4 driver supporting Java Development Kit (JDK) version 1.7. The PHP driver will allow developers who use the PHP scripting language version 5.5 to access Microsoft SQL Server and Microsoft Azure SQL Database, and to take advantage of new features implemented in ODBC 

You can download the JDBC driver here, and download the PHP driver hereWe invite you to explore the latest the Microsoft Data Platform has to offer via a trial evaluation of Microsoft SQL Server 2014, or by trying the new preview of Microsoft Azure SQL Database.

Categories: Database

Oracle Service Cloud Achieves Federal Risk and Authorization Management Program Provisional Authority to Operate

Oracle Database News - Mon, 12/15/2014 - 12:56
Oracle Service Cloud Achieves Federal Risk and Authorization Management Program Provisional Authority to Operate Redwood Shores, Calif. – December 15, 2014 News Summary

Oracle Service Cloud—a software-as-a-service (SaaS) solution—has received a Federal Risk and Authorization Management Program (FedRAMP) moderate provisional Authority to Operate (p-ATO) from the Joint Authorization Board (JAB), comprised of the Chief Information Officers (CIOs) of the U.S. Department of Homeland Security (DHS), U.S. Department of Defense (DOD), and U.S. General Services Administration (GSA).

News Facts Oracle announced that Oracle Service Cloud—a software-as-a-service (SaaS) solution—has received a Federal Risk and Authorization Management Program (FedRAMP) moderate provisional Authority to Operate (p-ATO) from the Joint Authorization Board. The Oracle Service Cloud is Oracle’s premier Software as a Service (SaaS) solution providing the industry’s best in class customer service platform for enterprise customers. Oracle customers can deploy Oracle Service Cloud onto a robust, secure infrastructure hosting Oracle’s patented customer experience (CX) software applications in an environment accredited to FedRAMP-moderate specifications. Oracle Service Cloud has been granted a p-ATO by the FedRAMP’s Joint Authorization Board (JAB), the primary governance and decision-making body for the FedRAMP program. A JAB p-ATO provides a government wide view for security and stringent review by the JAB Technical Representatives from the DHS, DOD, and GSA. As a result, government customers can save time and money by leveraging Oracle’s JAB approval to grant their own authority to operate without having to go through a full certification and accreditation. The rigorous review of Oracle’s environment was completed by an accredited third-party organization at the FedRAMP moderate baseline level, for a SaaS offering using a community deployment model.Supporting Quotes is very excited to announce the Service Cloud p-ATO as we continue to work towards meeting our public sector customers’ demands for a highly secure, robust suite of cloud solutions built for government,”   Aaron Erickson, Director of Government Innovation, Public Sector North America, Oracle. Supporting Resources Oracle Government Cloud Oracle Service Cloud Oracle Public Sector on Facebook Oracle Public Sector on Twitter Oracle Public Sector on DiigoAbout 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

Katie Barron


Lacy Cooper
O’Keeffe & Company

Categories: Database, Vendor

Big Data Holiday Planning!

Database Journal News - Mon, 12/15/2014 - 09:01

Your big data repository won't simply add another twelve months of data over the next year. More data is coming, more categories of data will be created, and your analytical environment must expand to fit future needs. But size alone won't be your only problem. In the rush to accumulate a sufficient amount of valuable data and implement a business analytics environment that can produce usable results, several items may have been ignored, postponed, or simply forgotten. These missing details can make or break your company in the future.

Categories: Database

Microsoft Strengthens Data Platform with SQL Database and Big Data Appliance Updates, Adds New Java SDK for its NoSQL Service

By Tiffany Wissner, Senior Director, Data Platform

Making it easier for more of our customers to access our latest big data technologies, we are announcing updates to some of our flagship data platform products and services. These updates are part of our approach to make it easier for our customers to work with data of any type and size – using the tools, languages and frameworks they want – in a trusted environment, on-premises and in the cloud. 

Azure SQL Database

Announced last month and available today is a new version of Azure SQL Database that represents a major milestone for this database-as-a-service. With this preview, we are adding near-complete SQL Server engine compatibility, including support for larger databases with online indexing and parallel queries, improved T-SQL support with common language runtime and XML index, and monitoring and troubleshooting with extended events. Internal tests using over 600 million rows of data show query performance improvements up to 5x in the Premium tier of the new preview relative to today’s offering. Continuing on our journey to bring in-memory technologies to the cloud, when applying in-memory columnstore in the new preview, performance is also improved up to 100x.

“From a strategy perspective, these SQL Database service updates are our answer to migrating and working with large data types by leveraging features such as online index rebuild, and partitioning,” said Joe Testa, vice president of Systems Development at Weichert, one of the nation’s leading full-service real estate providers. “Simply put, the results so far have been fantastic—we’re seeing >2x better performance and the advanced features that were only previously available in SQL Server, now make it easier to work with our applications as we continue to migrate our mission-critical apps to Azure.”

These new preview capabilities are offered as part of service tiers introduced earlier this year, which deliver 99.99% availability, larger database sizes, restore and geo-replication capabilities, and predictable performance. When combined with our recently announced elastic scale technologies that scale out to thousands of databases for processing 10s of terabytes of OLTP data and new auditing capabilities, Azure SQL Database service is a clear choice for any cloud-based mission critical application.

Analytics Platform System

As Microsoft’s “big data in a box” solution built with HP, Dell and Quanta, the Analytics Platform System is a data warehousing appliance that supports the ability to query across traditional relational data and data stored in a Hadoop region – either in the appliance or in a separate Hadoop cluster. This latest release includes a data management gateway that establishes a secure connection between on-premises data stored in the Analytics Platform System and Microsoft’s cloud business intelligence and advanced analytics services such as Power BI and Azure Machine Learning. This capability, coupled with PolyBase, a feature of the Analytics Platform System, allows for seamless integration of data stored in SQL Server with data stored in Hadoop. This now enables users of Power BI and Azure Machine Learning to gain insights from Analytics Platform System, whether on-premises or in the Azure cloud.

New Java, PHP and migration tools

Microsoft is also making available new tools and drivers that support greater interoperability with PHP and Java and make it easier for customers to migrate to and use our big data technologies.

Azure DocumentDB is our fully-managed NoSQL document database service with native support for JSON and JavaScript. DocumentDB already includes SDKs for popular languages, including Node.js, Python, .NET, and JavaScript – today we are adding a new Java SDK that will make DocumentDB easier to use within a Java development environment. The SDK provides easy-to-use methods to manage and query DocumentDB resources including collections, stored procedures and permissions. The Java SDK is also available on Github and welcomes community contributions.

Additionally, we are bolstering our SQL Server tools and drivers with updates to the Microsoft JDBC Driver for SQL Server the SQL Server Driver for PHP. Available early next week, these drivers will make it easier for our customers’ applications to access both SQL Server and Azure SQL Database.

For customers that are migrating their IBM DB2 workloads to SQL Server, we are also making available today the SQL Server Migration Assistant (SSMA) tool which automates all aspects of database migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce risk of database migration projects. SSMA 6.0 for IBM DB2 automates migrations from IBM DB2 databases to SQL Server and Azure SQL Database and is free to download and use. Support for IBM DB2 is in addition to earlier updates to SSMA 6.0 including migration support for larger Oracle databases.

Microsoft data platform

These new updates will enable more customers to use Microsoft’s data platform to build, extend and migrate more applications. Microsoft’s data platform includes all the building blocks customers need to capture and manage all of their data, transform and analyze that data for new insights, and provide tools which enable users across their organization to visualize data and make better business decisions. To learn more, go here

Categories: Database

Do You Really Need Oracle Optimizer_index_cost_adj Set?

Database Journal News - Thu, 12/11/2014 - 09:01

Performance is the watchword with a database and indexes can be a major part of that performance equation.  Oracle provides the optimizer_index_cost_adj parameter but do you REALLY need to set it differently than the default?  Read on to see what may happen when you do.

Categories: Database

Oracle Delivers Increased Session Capacity with New Acme Packet 4600 Midrange Session Border Controller Platform

Oracle Database News - Tue, 12/09/2014 - 14:00
Oracle Delivers Increased Session Capacity with New Acme Packet 4600 Midrange Session Border Controller PlatformNew system more than doubles the session capacity of previous-generation midrange solutions REDWOOD SHORES, Calif. – Dec. 9, 2014News Summary

The increasing demand for services and applications, such as Voice over LTE (VoLTE), Session Initiation Protocol (SIP) trunking, and Voice over IP (VoIP) interconnect, requires a session border controller capable of sophisticated mediation and management of IP multimedia traffic. Oracle’s Acme Packet 4600 midrange network platform delivers best-in-class performance and configuration capabilities with its tightly integrated encryption and transcoding in a single network module. This provides communications service providers (CSPs) with a cost-effective and scalable solution for delivering their next-generation services.

News Facts Oracle today announced the release of the Acme Packet 4600—the newest member of its market-leading session border controller (SBC) platform family. Acme Packet 4600 delivers a comprehensive and powerful range of network traffic controls for new, sophisticated communications services like VoLTE, Rich Communication Services (RCS), and high-definition video calling. The new network platform delivers two to four times the capacity of previous-generation midrange systems. It also offers the same software, high availability, and manageability inherent in the Acme Packet platform family, enabling CSPs to implement it without disruption while reducing capital and operational costs. With Acme Packet 4600’s unique combination of modularity and configuration flexibility, CSPs can seamlessly integrate new services and capabilities into their networks—all while continuing to operate within their current network infrastructure. The new solution is highly cost-effective, combining advanced capabilities such as encryption and transcoding, as well as 1 gigabit Ethernet (GbE) and 10 GbE interfaces, in a single network interface unit (NIU), significantly reducing rack space and energy consumption, driving cost savings. Oracle is a leader in the communications platform market, built upon the proven Acme Packet operating software. Acme Packet 4600 is designed to leverage this same technology, providing CSPs with the manageability and reliability they have come to expect from Oracle.
Product Details

Acme Packet 4600:

Supports up to 80,000 signaled sessions and up to 32,000 simultaneous anchored media sessions Provides IP security capacity of up to 500,000 security associations with IP Multimedia Subsystem Authentication and Key Agreement Integrates transcoding, encryption, and quality of service (QoS) measurements in a single NIU Offers carrier-grade high-availability and network equipment-building system compliance in a 1 rack-unit form factor Manages increasing numbers of protocols and compression technologies at interconnect borders
Supporting Quotes “The increased deployment of services like VoLTE, HD video calling, and RCS have become strong drivers for service provider SBCs,” said Diane Myers, principal analyst, Infonetics Research. “Acme Packet 4600 gives service providers an effective way to expand their network capacity and increase their service offerings.” “Acme Packet 4600 provides a unique combination of modularity and configuration flexibility and enables CSPs to continue operating their current network infrastructure without disruption, while seamlessly integrating new services and capabilities,” said Bhaskar Gorti, senior vice president and general manager, Oracle Communications. “SBCs of this size and type will help both small and large service providers improve quality of experience and reliability, enhance security in new services, and comply with growing government regulations designed to protect consumer interests.”
Supporting Resources Oracle Communications Acme Packet 3820 Acme Packet 4600 Acme Packet 6000 Series Oracle Communications Session Border Controller Oracle Communications Session Router Connect with Oracle Communications on Diigo, Facebook, LinkedIn, Twitter, and YouTube
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.


Kaitlin McCready

Janice Clayton

Categories: Database, Vendor

FOSDEM PGDay 2015 and Devroom - Schedule posted and registration open

PostgreSQL News - Tue, 12/09/2014 - 01:00

We have finished the schedule for FOSDEM PGDay and the PostgreSQL Devroom at FOSDEM 2015 - our apologies for the delay in processing!

You will find a number of great talks both on PostgreSQL usage and development from great speakers. And of course, it will as usual feature the Hallway Track, where you can network with fellow PostgreSQL users!

We have also opened registration. Number of seats are limited, and as we sold out last year, we recommend that you make your reservation as soon as possible. Registration is €50 for all attendees for the PGDay on Friday. No registration is necessary if you only want to attend the Devroom at FOSDEM on Saturday.

Finally, we'd like to remind you that our rate with the conference hotel (Marriott Brussels) will expire on Dec 15th. Therefore, we recommend that you book your accommodations as soon as possible!

We hope to see you in Brussels in January!

Categories: Database, Open Source

Best of 2014: Top 10 Data Exposed Channel 9 Videos for Data Devs

Have you been watching Data Exposed over on Channel 9? If you’re a data developer, Data Exposed is a great place to learn more about what you can do with data: relational and non-relational, on-premises and in the cloud, big and small.

On the show, Scott Klein and his guests demonstrate features, discuss the latest news, and share their love for data technology – from SQL Server, to Azure HDInsight, and more!

We rounded up the year’s top 10 most-watched videos from Data Exposed. Check them out below – we hope you learn something new!

  • Introducing Azure Data Factory: Learn about Azure Data Factory, a new service for data developers and IT pros to easily transform raw data into trusted data assets for their organization at scale.
  • Introduction to Azure DocumentDB: Get an introduction to Azure DocumentDB, a NoSQL document database-as-a-service that provides rich querying, transactional processing over schema free data, and query processing and transaction semantics that are common to relational database systems.
  • Introduction to Azure Search: Learn about Azure Search, a new fully-managed, full-text search service in Microsoft Azure which provides powerful and sophisticated search capabilities to your applications.
  • Azure SQL Database Elastic Scale: Learn about Azure SQL Database Elastic Scale, .NET client libraries and Azure cloud service packages that provide the ability to easily develop, scale, and manage the stateful data tiers of your SQL Server applications.
  • Hadoop Meets the Cloud: Scenarios for HDInsight: Explore real-life customer scenarios for big data in the cloud, and gain some ideas of how you can use Hadoop in your environment to solve some of the big data challenges many people face today.
  • Azure Stream Analytics: See the capabilities of Azure Stream Analytics and how it helps make working with mass volumes of data more manageable.
  • The Top Reasons People Call Bob Ward: Scott Klein is joined by Bob Ward, Principle Escalation Engineer for SQL Server, to talk about the top two reasons why people want to talk to Bob Ward and the rest of his SQL Server Services and Support team.
  • SQL Server 2014 In-Memory OLTP Logging: Learn about In-Memory OLTP, a memory-optimized and OLTP-optimized database engine integrated into SQL Server. See how transactions and logging work on memory-optimized-tables, and how a system can recover in-memory data in case of a system failure.
  • Insights into Azure SQL Database: Get a candid and insightful behind-the-scenes look at Azure SQL Database, the new service tiers, and the process around determining the right set of capabilities at each tier.
  • Using SQL Server Integration Services to Control the Power of Azure HDInsight: Join Scott and several members of the #sqlfamily to talk about how to control cloud from on-premises SQL Server.

Interested in taking your learning to the next level? Try SQL Server or Microsoft Azure now.

Categories: Database