Skip to content

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

Methods & Tools

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

Database

DB Doc 3 for PostgreSQL released

PostgreSQL News - Fri, 06/03/2016 - 01:00

Yohz Software announces the release of DB Doc 3.0 on June 3, 2016, and is available for immediate download.

DB Doc benefits:
  • Eliminate tedious and time-consuming manual documentation tasks
  • Satisfy audit requirements by keeping complete and timely documentation
  • Document a database in a couple of clicks
  • Create documents in HTML, CHM, and PDF formats
  • View inter-object and inter-database dependencies in your documents
  • Document layouts can be fully customizable to suit your requirements
  • Keep teams up to date by distributing documentation
  • Runs on Windows XP to Windows 10
  • Runs in Wine, so you can use DB Doc on your favorite Linux distribution
  • Supports PostgreSQL 8.3 to 9.5, without the need for any additional database drivers.

For more details about DB Doc, visit the product page here.

Categories: Database, Open Source

Oracle Statement

Oracle Database News - Thu, 06/02/2016 - 16:48
Press Release Oracle Statement

Redwood Shores, Calif.—Jun 2, 2016

“We are confident that all our cloud accounting is proper and correct. This former employee worked at Oracle for less than a year and did not work in the accounting group. She was terminated for poor performance and we intend to sue her for malicious prosecution.”
—Deborah Hellinger, Vice President, Corporate Communications, Oracle

Contact Info Deborah Hellinger
Oracle Corporate Communications
1.212.508.7935
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

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

Altering an Existing Table to Support Temporal Data

Database Journal News - Thu, 06/02/2016 - 08:01

If you are looking for a way to track the history of all the data changes to a table then SQL Server 2016 has you covered with the new temporal table support. With Temporal tables SQL Server is able to store all the older data records into in a history table while keeping the current records in the original table. Greg Larsen explores using the temporal table feature of SQL Server 2016 to create a history table for an existing SQL Server table.

Categories: Database

SQL Server 2016 is generally available today

This post was authored by Joseph Sirosh, Corporate Vice President, Data Group, Microsoft.

Today we announced the general availability of SQL Server 2016, the world’s fastest and most price-performant database for HTAP (Hybrid Transactional and Analytical Processing) with updateable, in-memory columnstores and advanced analytics through deep integration with R Services. Software applications can now deploy sophisticated analytics and machine learning models in the database resulting in 100x or more speedup in time to insight, compared to deployments of such models outside of the database.

A new platform for intelligent applications

The integration of advanced analytics into a transactional database is revolutionary. Today a majority of advanced analytic applications use a primitive approach of moving data from databases into the application tier to derive intelligence. This approach incurs high latency because of data movement, doesn’t scale as data volumes grow and burdens the application tier with the task of managing and maintaining analytical models. And deep analytics on real-time transactions are next to impossible without a lot of heavy lifting.

SQL Server 2016 simplifies analytics in the way databases simplified enterprise data management, by moving analytics close to where the data is managed instead of the other way around. It introduces a new paradigm where all joins, aggregations and machine learning are performed securely within the database itself without moving the data out, thereby enabling analytics on real-time transactions with great speed and parallelism. As a result, analytical applications can now be far simpler and need only query the database for analytic results. Updating machine learning models, deploying new models, and monitoring their performance can now be done in the database without recompiling and redeploying applications. Furthermore, the database can serve as a central server for the enterprise’s analytical models and multiple intelligent applications can leverage the same models. It is a profound simplification in how mission critical intelligent applications can be built and managed in the enterprise.

A good example of how our customers are benefiting from the new model comes from PROS Holdings, Inc., a revenue and profit realization company that helps B2B and B2C customers achieve their business goals through data science. PROS Holdings uses SQL Server 2016’s superior performance and built-in R Service to deliver advanced analytics more than 100x faster than before, resulting in higher profits for their customers. Royce Kallesen, senior director of science and research at PROS says, “Microsoft R’s parallelization and enhanced memory management on the server integrated with SQL Server provides dramatically faster results on a common platform with built-in security.”

Eliminating the need to move data out of the database for analytics dramatically reduces the latency for insights. For example, Microsoft Dynamics AX, a cloud-scale online ERP offering, gains real-time insights by using a non-clustered columnstore index on their transactional tables to reduce aggregation latency from hours to seconds.

SQL Server 2016 comes with several features and tools to support cross-platform analytics. Polybase allows you to run queries on external data in Hadoop or Azure blob storage. It can push computation to Hadoop where appropriate, so that your analytical application can join and integrate data from big data stores with the data in the relational store. Microsoft R Services, which is integrated with SQL Server also runs on multiple Hadoop distributions and is also integrated with Azure HDInsight + Spark, enabling both choice and standardization in developing analytics code. And finally, R Tools for Visual Studio allows the ease of use of the modern Visual Studio IDE for developing analytical code in R.

Benchmark leadership through efficient use of modern hardware

SQL Server 2016 has ground-breaking performance optimizations and efficiencies, leading to new levels of performance and scale. Modern servers can support a large number of cores with sophisticated vector instructions, can hold terabytes of memory, and provide very high I/O bandwidth with local flash storage. Optimizing for the concurrency and parallelism inherent within such servers can provide dramatic speedups at scale, and often outperform large distributed databases.

For example, Microsoft recently collaborated with Intel to demonstrate stunning performance on a massive 100TB data warehouse using just a single server with four Intel Xeon E7 processors and SQL Server 2016. The system was able to load a complex schema derived from TPC-H at 1.6TB/hour, and it took just 5.3 seconds to run a complex query (the minimum cost supplier query) on the entire 100TB database. The system also demonstrated incredible concurrent query performance, where running all queries concurrently took less time than running them back-to-back, as illustrated in the chart below. This is a feat of scale, performance and efficiency that no other database has achieved to date.

Intel100TB_Concurrency

Industry standard database benchmarks further support SQL Server’s performance leadership. It is the only database that is simultaneously the leader in the industry standard transaction processing benchmark TPC-E, and the data warehouse benchmark TPC-H (non-clustered TPC-H 30TB, 10TB, 3TB, 1TB scale factors). For customers, this means incredible value compared to other databases, and the opportunity to consolidate both OLTP and Data Warehouse workloads into a simpler single system, with significant savings in total cost of ownership.

Large performance improvements from prior versions

Our focus for SQL Server 2016 was to deliver great value for our customers with dramatic improvements while keeping the price the same. Simply by upgrading to SQL 2016, many customer workloads experienced large performance gains. For example, the 3TB TPC-H benchmark on the same hardware demonstrated a forty-eight percent performance gain1.

Our customers and partners have realized great benefits by upgrading. Some examples:

RealtyTrac, a provider of housing data and analytics, used an Always-On availability group spanning on-premises and Microsoft Azure to provide high availability and disaster recovery for their data warehousing. By offloading queries to the secondary replicas, RealtyTrac achieved huge performance improvements: “We saw up to ten times speed improvement on some of the extraction processes. SQL Server 2016 in a hybrid-cloud environment with Azure really cuts through all the logistics of managing large data sets,” said Richard Sawicky, chief data officer, RealtyTrac.

Saxo Bank is one of the leading players in global online trading. SQL Server 2016 will enable the bank to use enhanced columnstore on a wider array of tables for even faster analysis. “Using clustered columnstore indexes created huge savings in storage, allowing us to use up to eighty percent less disk space for tables. With SQL Server 2016, we have seen queries running up to two times faster on top of the 10x query performance gains from adopting columnstore” said Francesco L’Erario, Data Warehouse Architect, Saxo Bank.

M-Files, a popular SaaS EIM vendor, has its most valuable data in the SQL Server database. “Real-time operational analytics in SQL Server 2016 lets us run the analytical queries from the same data source. We experienced an immediate 10x boost in our most critical queries, with virtually no impact on the operational workload. Now we have our ‘analytics database’ in the single data source, with ground-breaking performance, automatically updated by SQL Server within the same transaction boundaries as our operational workload. It’s an unbelievable advantage to us,” said Antti Nivala, CTO and founder of M-Files.

SQL Server 2016 features were first released in Microsoft Azure and stress-tested in real-world through over 1.7 million Azure SQL DB databases. It is battle-tested and dozens of our customers have already been running on-premises production workloads on SQL Server 2016 prior to its general availability, a strong testament to its maturity as a product.

Unmatched security record

Solid security is an essential requirement for any business application. Databases contain a significant portion of sensitive corporate data and intellectual property. If database security is compromised, the entire business is potentially at risk.

For six years running2, SQL Server has had the least vulnerabilities of any of the major database platforms, according to the statistics compiled independently by the National Institute of Standards and Technology (NIST), the government agency that monitors security vulnerabilities by technology, vendor, and product. Now SQL Server 2016  takes security capabilities even further: Always Encrypted helps protect data at rest and in memory, Transparent Data Encryption encrypts all user data now with low performance overhead, and Dynamic Data Masking (DDM) and Row Level Security (RLS) allow developers to build applications that restrict access and protect data.

For example, DocuSign helps organizations build entire approval workflows without a single sheet of paper or filing cabinet in sight, so security and reliability are critical, as they are with every business today. Using SQL Server 2016 for internal telemetry and monitoring, DocuSign monitors customer experiences across the globe to identify and address issues quickly. DocuSign customers rely on them for mission critical workflows and DocuSign relies on SQL Server for their entire business. “We’ve picked SQL Server for our platform, because of its performance and ability to manage all types of data. With the largest banks, insurers and other financial institutions counting on us, we need to deliver secure software for our environment. New features in SQL Server 2016 like Always Encrypted allow us to deliver on this promise,” says Eric Fleischman, chief architect and vice president of platforms.

Unmatched value proposition

SQL Server 2016 ships as a comprehensive data platform with everything built-in. The powerful database engine with in-memory capabilities also includes unique features such as JSON support for building modern apps, Stretch Database for reducing storage costs while keeping data available for querying in Azure, significantly faster Geospatial query support, Temporal Tables for traveling back in time and a Query Store for ensuring performance consistency. We bundle in powerful data integration capabilities with SQL Server Integration Services (SSIS), Data Quality Services (DQS) and Master Data Services (MDS). We provide world-leading data warehousing capabilities, closely integrated with advanced analytics and machine learning through R. We provide a world-leading Business Intelligence engine with Tabular and Multidimensional models. We deliver end-to-end mobile BI solution on any device and you can add on self-service Power BI for a fraction of the total cost. The table below shows a simple competitive comparison that highlights the value of the SQL Server package.

TCO

Today customers can deliver intelligent applications that are faster performing, more secure than Oracle, and at less than one-tenth of the total cost of using Oracle to run the same transactional, data warehouse, data integration, business intelligence and advanced analytics workloads3. With our ongoing promotion to help more customers adopt SQL Server 2016, customers currently running applications or workloads on a non-Microsoft paid commercial RDBMS platform can migrate their existing applications with free SQL Server licenses.

Both industry analysts and customers recognize the breadth and depth of Microsoft’s capabilities in data, intelligence and the cloud. Microsoft is the only company recognized as a leader across data platforms and cloud by Gartner in both vision and execution in database, business intelligence, advanced analytics, data warehouse, cloud infrastructure and cloud application platforms, and the furthest in vision and ability to execute within the Leaders Quadrant  in the Gartner Magic Quadrant for Operational DBMS.

GartnerMQ_ODBMS
Gartner Magic Quadrant for Operational Database Management Systems, October 20154

The quickest way to experience the magic of SQL Server 2016 is to create a test environment using an Azure SQL VM. You can also experience the full features through the free developer edition (you will be prompted to sign in to Visual Studio Dev Essentials before you can download SQL Server 2016 Developer Edition). Visit the SQL Server 2016 webpage to gain insights about new features and download the SQL Server 2016 e-book.

With new capabilities for analytics, record-breaking performance, in-memory processing, unmatched security and an unbeatable value proposition, SQL Server 2016 is the best data platform available to gather and manage data, apply analytics that generate deep insights, and translate those insights into mission critical production. Adopt it today to transform your business with data driven intelligence.

–Joseph

 

1Comparison of TPC-H 3TB benchmark created using SQL Server 2016 (http://www.tpc.org/3322) to TPC-H 3 TB benchmark created using SQL Server 2014 (http://www.tpc.org/3315) on the same Cisco UCS C460 M4 Server

2National Institute of Standards and Technology, National Vulnerability Database statistics as of 2/1/2016, https://nvd.nist.gov/

3http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf 

4The above graphic was published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner document is available upon request. 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. 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.

Categories: Database

What's new in IBM Security Guardium V10

IBM - DB2 and Informix Articles - Wed, 06/01/2016 - 05:00
In Version 10, IBM Security Guardium takes a major step forward with intelligence and automation to safeguard data, enterprise-readiness features, and increased breadth of data sources, including file systems. This article provides an in-depth technical review of all new and changed capabilities including database activity monitoring, vulnerability assessment, and file activity monitoring. This article, originally published in September 2015, was updated to include enhancements for the updates in Version 10.1 (delivered in June 2016).
Categories: Database

Bring business insights to more people with SQL Server 2016 mobile reports

This post was authored by Chris Finlan, Sr. Program Manager, SQL Server.

In today’s competitive business environment, organizations invest in business intelligence (BI) capabilities to drive the business forward.

Improving customer satisfaction is the top reason for investing in business insights, closely followed by making better business decisions and gaining a competitive advantage. Now, if customer satisfaction is the top reason, wouldn’t it make sense to deliver business insights to all the employees in an organization – particularly those who interact directly with customers? These people are by no means limited to sales, accounting, services and support roles. Unfortunately, the reality is that insights are most often stuck at the executive level. According to Forrester Research, while 71% of business owners and C-level executives have access to insights and can apply them to operational processes and actions in a timely manner, only 44% of individual workers can do so. On top of that, only about 1/3rd of the data that organizations capture is used for business insights. This includes both structured and unstructured data. (Source: Forrester – Maximize your chances of business intelligence success in a customer-centric world, (Sept. 2015): What you need to go from data-rich to insights-driven (Feb. 2016): The Forrester Wave™: Agile Business Intelligence Platforms, Q3 2015 (Sep. 2015)).

The question then is: How can you deliver business insights to more people working within your organization?

Based on an IDC U.S. Mobile Forecast, 70% of US workers are mobile, which includes both office and non-office based mobile workers. In the coming years, this number is only expected to increase, as are the number of mobile devices being used (IDC U.S. Mobile Worker Forecast, 2015-2020 May 2015 #256194). Consequently, companies need to ensure that business insights can be delivered to employees across mobile platforms – be they Windows, Android or iOS. With mobile BI you can bring insights to more people at the necessary speed to help increase customer satisfaction.

Why mobile BI

Figure 1: Infographic – Why mobile BI.

But the shift to the mobile user experience brings its own set of challenges – the way a user interacts with his or her PC is far different from how one interacts with his or her phone. Having reports that are optimized for a mobile experience means that a different set of design principles must be applied. Traditionally, reports that have been built and designed for PC screens won’t translate well, if at all, to the experience one expects on a mobile phone or tablet. Our phones are the devices we pick up multiple times each day, quickly switching between apps and checking in while commuting to work or in-between meetings. The mobile BI experience needs to match that type of user interaction, by having the information available in an easily consumable way that’s designed for touch vs. a keyboard and mouse.

Let’s take a look at how SQL Server 2016 and its built-in mobile reporting capabilities can help.

To meet our customer needs, SQL Server 2016 Reporting Services has introduced a new report type called mobile reports. Built on the Datazen technology that Microsoft acquired in 2015, these reports address the need for responsive-layout reports that adapt to different screen shapes, sizes and orientations. Mobile reports dynamically adjust the content depending on whether you’re using a phone, tablet or PC, and even as you rotate your device. You can create mobile reports using the SQL Server Mobile Report Publisher app and you can view them using either your browser or the Power BI mobile app (available now for Windows Phone, iOS and Android devices).

The SQL Server Mobile Report Publisher also offers a design-first approach that allows the major consumers of mobile reports to work collaboratively with the report designer and provide feedback around the report, using sample data that adjusts “on the fly” to simulate the experience they have with the finished report. Once they’ve settled on the exact report design they’d like, the report publisher can hook up live data to the elements from their report server and publish the final product to the server. This completely eliminates the lengthy back and forth that frequently happens as part of the development process, and isn’t factored in when estimating the overall cost of a vendor’s solution.

In addition to mobile reports, key performance indicators (KPIs) have also been added as a new item in Reporting Services. These are a great way to monitor your important metrics and trends at a glance, either at your desk or while brushing your teeth! In addition, the ability to favorite your mobile reports and KPIs allows you to easily access the items most important to you both online or offline, thanks to built-in, offline sync capabilities in the Power BI mobile apps for favorited reports. This helps ensure users’ access to their most important data, no matter where they may be.

End-to-end mobile BI capabilities in SQL Server 2016 Reporting Services

Figure 2: End-to-end mobile BI capabilities in SQL Server 2016 Reporting Services

With the introduction of mobile reports in SQL Server 2016 Reporting Services, you can benefit from the proven scalability of Reporting Services, share data sources and data sets across all reports (paginated and mobile), manage permissions based on Active Directory groups, use a single modern web portal to access KPIs and all reports (including the ability to set favorites), and use the Power BI mobile apps to consume mobile reports in a consistent and secured manner.

To get started, try SQL Server 2016, the SQL Server Mobile Report Publisher, the Power BI Mobile Apps for iOS,  Android and Windows, along with the new mobile experience in Reporting Services today.

To learn more, please visit the Reporting Services team blog, join the conversation on Twitter (#SSRS), or check out the following technical deep dive videos: Design Mobile Reports and Access reports in modern browsers and mobile reports.

See the other posts in the SQL Server 2016 blogging series.

Try SQL Server 2016 RC

Categories: Database

Mutating Table Error In Oracle: Why It Happens And What You Can Do About It

Database Journal News - Tue, 05/31/2016 - 08:01

There are a lot of 'explanations' offered for the ORA-04091 error; read on to find out what is really going on and  how to address the situation.

Categories: Database

dbMigration .NET v3 released

PostgreSQL News - Tue, 05/24/2016 - 01:00

I am happy to announce the new major release of dbMigration .NET v3. It is a simple, easy and intuitive multiple database migration and sync tool, With it you can easily migrate schema and data between different databases without complicated procedures. Supported databases: PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, dBase, FoxPro, Text, Excel, ODBC, OleDB...etc.

Free, All-In-One, Portable, and Single executable file.

Major New features from version 2.4 to 3.1:

  • Compatible with PostgreSQL 8.4 ~ 9.5+
  • Delimited text files support (CSV/TXT)
  • Ability to Add custom columns
  • Ability to Manage Indexes
  • Ability to Create Table Schema Only
  • Ability to Generate the command-line to Clipboard
  • Added Batch Mode Settings
  • Added Custom Mapping Types
  • Massive performance improvements
  • Improved Data Synchronization
  • Improved Automatic Mapping Types
  • Improved Command-Line
  • ...and more
The new version is immediately available for download.
Categories: Database, Open Source

Getting Started with the Query Store Feature in SQL Server 2016 – Part 1

Database Journal News - Mon, 05/23/2016 - 08:01

Arshad Ali discusses SQL Server 2016 Query Store and how it greatly simplifies the performance troubleshooting process.

Categories: Database

Barman 1.6.1 released

PostgreSQL News - Mon, 05/23/2016 - 01:00

23 May 2016: 2ndQuadrant is proud to announce the release of Barman version 1.6.1, a Backup and Recovery Manager for PostgreSQL.

This minor release introduces support for '--peek' option for 'get-wal' command which allows users to implement parallel remote restore commands on standby servers and during recovery.

Through the new 'replication-status' command, Barman becomes a very practical tool for monitoring streaming replication status of every managed server.

A few important improvements have been added to the 'check' command, which should make installation and initial configuration easier. Another step in this direction is the 'switch-xlog' command, a new feature also included in this release.

Minor bugs have also been fixed, including support for 'archive_mode=always' for PostgreSQL 9.5, as well as 'FAILED' backups preventing new one from being taken.

Many thanks for funding towards the development of this release go to Jobrapido (www.jobrapido.com), Navionics (www.navionics.com), and Subito.it (www.subito.it).

However, for a complete list of changes, see the "Release Notes" section below.

Links Release notes
  • Add '--peek' option to 'get-wal' command to discover existing WAL files from the Barman's archive

  • Add 'replication-status' command for monitoring the status of any streaming replication clients connected to the PostgreSQL server. The '--target' option allows users to limit the request to only hot standby servers or WAL streaming clients

  • Add the 'switch-xlog' command to request a switch of a WAL file to the PostgreSQL server. Through the '--force' it issues a 'CHECKPOINT' beforehand

  • Add 'streaming_archiver_name' option, which sets a proper 'application_name' to 'pg_receivexlog' when 'streaming_archiver' is enabled (only for PostgreSQL 9.3 and above)

  • Check for superuser privileges with PostgreSQL's standard connections (#30)

  • Check the WAL archive is never empty

  • Check for 'backup_label' on the master when server is down

  • Improve barman-wal-restore contrib script

  • Bug fixes:

    • Treat the "failed backups" check as non-fatal
    • Rename '-x' option for get-wal as '-z'
    • Add archive_mode=always support for PostgreSQL 9.5 (#32)
    • Properly close PostgreSQL connections when necessary
    • Fix receive-wal for pg_receive_xlog version 9.2
Download About

Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase. Barman's most requested features include backup catalogues, incremental backup, retention policies, remote backup and recovery, archiving and compression of WAL files and backups. Barman is distributed under GNU GPL 3.

Categories: Database, Open Source

Barman 1.6.1 released

PostgreSQL News - Mon, 05/23/2016 - 01:00

23 May 2016: 2ndQuadrant is proud to announce the release of Barman version 1.6.1, a Backup and Recovery Manager for PostgreSQL.

This minor release introduces support for '--peek' option for 'get-wal' command which allows users to implement parallel remote restore commands on standby servers and during recovery.

Through the new 'replication-status' command, Barman becomes a very practical tool for monitoring streaming replication status of every managed server.

A few important improvements have been added to the 'check' command, which should make installation and initial configuration easier. Another step in this direction is the 'switch-xlog' command, a new feature also included in this release.

Minor bugs have also been fixed, including support for 'archive_mode=always' for PostgreSQL 9.5, as well as 'FAILED' backups preventing new one from being taken.

Many thanks for funding towards the development of this release go to Jobrapido (www.jobrapido.com), Navionics (www.navionics.com), and Subito.it (www.subito.it).

However, for a complete list of changes, see the "Release Notes" section below.

Links Release notes
  • Add '--peek' option to 'get-wal' command to discover existing WAL files from the Barman's archive

  • Add 'replication-status' command for monitoring the status of any streaming replication clients connected to the PostgreSQL server. The '--target' option allows users to limit the request to only hot standby servers or WAL streaming clients

  • Add the 'switch-xlog' command to request a switch of a WAL file to the PostgreSQL server. Through the '--force' it issues a 'CHECKPOINT' beforehand

  • Add 'streaming_archiver_name' option, which sets a proper 'application_name' to 'pg_receivexlog' when 'streaming_archiver' is enabled (only for PostgreSQL 9.3 and above)

  • Check for superuser privileges with PostgreSQL's standard connections (#30)

  • Check the WAL archive is never empty

  • Check for 'backup_label' on the master when server is down

  • Improve barman-wal-restore contrib script

  • Bug fixes:

    • Treat the "failed backups" check as non-fatal
    • Rename '-x' option for get-wal as '-z'
    • Add archive_mode=always support for PostgreSQL 9.5 (#32)
    • Properly close PostgreSQL connections when necessary
    • Fix receive-wal for pg_receive_xlog version 9.2
Download About

Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase. Barman's most requested features include backup catalogues, incremental backup, retention policies, remote backup and recovery, archiving and compression of WAL files and backups. Barman is distributed under GNU GPL 3.

Categories: Database, Open Source

Call for Papers - PostgreSQL Conference Europe 2016

PostgreSQL News - Wed, 05/18/2016 - 01:00

PostgreSQL Conference Europe 2016 will be held on November 1-4 in the Radisson Blu Hotel Olümpia, in Tallin, Estonia. It will cover topics for PostgreSQL users, developers and contributors, as well as decision and policy makers. For more information about the conference, please see the website at http://2016.pgconf.eu/.

We are now accepting proposals for talks in English.

Each session will last 45 minutes, and may be on any topic related to PostgreSQL. Suggested topic areas include:

  • Developing applications for PostgreSQL
  • Administering large scale PostgreSQL installations
  • Case studies and/or success stories of PostgreSQL deployments
  • PostgreSQL tools and utilities
  • PostgreSQL hacking
  • Community & user groups
  • Tuning the server
  • Migrating from other systems
  • Scaling/replication
  • Benchmarking & hardware
  • PostgreSQL related products

Of course, we're happy to receive proposals for talks on other PostgreSQL related topics as well.

We may also have a limited number of longer, 90-minute, slots available. Please indicate clearly in your submission if you wish to make a 90-minute talk.

Finally, there will be a session of five minute lightning talks. A separate call for proposals will be made for them further on.

The submission deadline is August 7th. Selected speakers will be notified before August 24th, 2016.

Please submit your proposals by going to http://2016.pgconf.eu/callforpapers/ and following the instructions there.

The proposals will be considered by committee who will produce a schedule to be published nearer the conference date.

All selected speakers will get free entry to the conference (excluding training sessions). We do not in general cover travel and accommodations for speakers, but may be able to do that in limited cases. If you require assistance with funding to be able to attend, please make a note of this in the submission notes field.

We are also looking for sponsors. PostgreSQL Conference Europe is a perfect opportunity for companies to reach out to users and developers of PostgreSQL, or to just give back to the community. Our sponsorship program covers a wide range of levels, from entry level to big scale. More informations on http://2016.pgconf.eu/becomesponsor/.

We look forward to hearing from you, and seeing you in Tallin in November!

Categories: Database, Open Source

Call for Papers - PostgreSQL Conference Europe 2016

PostgreSQL News - Wed, 05/18/2016 - 01:00

PostgreSQL Conference Europe 2016 will be held on November 1-4 in the Radisson Blu Hotel Olümpia, in Tallin, Estonia. It will cover topics for PostgreSQL users, developers and contributors, as well as decision and policy makers. For more information about the conference, please see the website at http://2016.pgconf.eu/.

We are now accepting proposals for talks in English.

Each session will last 45 minutes, and may be on any topic related to PostgreSQL. Suggested topic areas include:

  • Developing applications for PostgreSQL
  • Administering large scale PostgreSQL installations
  • Case studies and/or success stories of PostgreSQL deployments
  • PostgreSQL tools and utilities
  • PostgreSQL hacking
  • Community & user groups
  • Tuning the server
  • Migrating from other systems
  • Scaling/replication
  • Benchmarking & hardware
  • PostgreSQL related products

Of course, we're happy to receive proposals for talks on other PostgreSQL related topics as well.

We may also have a limited number of longer, 90-minute, slots available. Please indicate clearly in your submission if you wish to make a 90-minute talk.

Finally, there will be a session of five minute lightning talks. A separate call for proposals will be made for them further on.

The submission deadline is August 7th. Selected speakers will be notified before August 24th, 2016.

Please submit your proposals by going to http://2016.pgconf.eu/callforpapers/ and following the instructions there.

The proposals will be considered by committee who will produce a schedule to be published nearer the conference date.

All selected speakers will get free entry to the conference (excluding training sessions). We do not in general cover travel and accommodations for speakers, but may be able to do that in limited cases. If you require assistance with funding to be able to attend, please make a note of this in the submission notes field.

We are also looking for sponsors. PostgreSQL Conference Europe is a perfect opportunity for companies to reach out to users and developers of PostgreSQL, or to just give back to the community. Our sponsorship program covers a wide range of levels, from entry level to big scale. More informations on http://2016.pgconf.eu/becomesponsor/.

We look forward to hearing from you, and seeing you in Tallin in November!

Categories: Database, Open Source

The End of Big Data

Database Journal News - Mon, 05/16/2016 - 08:01

What is next for big data? Some experts claim that data "volumes, velocity, variety and veracity" will only increase over time, requiring more data storage, faster machines and more sophisticated analysis tools. However, this is short-sighted, and does not take into account how data degrades over time. Analysis of historical data will always be with us, but generation of the most useful analyses will be done with data we already have. To adapt, most organizations must grow and mature their analytical environments. Here are the steps they must take to prepare for the transition.

Categories: Database

Oracle and Benefit Management LLC to Help Ease the Complexity of Bundled Payments Amidst Healthcare Reform

Oracle Database News - Fri, 05/13/2016 - 20:30
Press Release Oracle and Benefit Management LLC to Help Ease the Complexity of Bundled Payments Amidst Healthcare Reform Oracle and Benefit Management LLC Enable Healthcare Payors and Providers to Shift from Retrospective Payments to Prospective Bundled Payments

Redwood Shores, Calif.—May 13, 2016

Oracle today announced that Benefit Management LLC, a progressive health Third Party Administrator (TPA) and joint venture of NueHealth, has selected Oracle Health Insurance Value Based Payment Cloud Service to deliver a cloud-based prospective bundled payments system for healthcare payors and providers.

While the goal of healthcare reform has been to decrease costs and improve patient outcomes, it has healthcare payors and providers grappling with how to master the complexity of bundled payment models—specifically the shift from retrospective payments (paying for healthcare services after they are completed) to prospective payments (at the time the service is requested and agreement on a flat fee). 

Benefit Management LLC will harness the power of Oracle Health Insurance Value Based Payments Cloud Service to help payors seamlessly maneuver and scale complex bundled payments, and help ensure timely and accurate payment to providers as they move to a prospective bundled payments model.

“The transition to value-based payments is one of the biggest challenges facing payors and providers today,” said Chad Somers, CEO of Benefit Management. “It is imperative that all aspects of value-based payments be considered before making this change. Never before has combining the clinical outcomes with payment been so important. Oracle Health Insurance Value Based Payment Cloud Service will allow us to revolutionize bundled payments by processing payment at the time service is rendered instead of months later.”

The combination of Benefit Management’s services, backed by 20 years of success with a diverse client base of self-funded employers, and Oracle’s offering will allow Benefit Management customers to:

  • Easily navigate the transition to prospective bundled payments
  • Reduce the provider risk making it easier for providers to participate
  • Decrease the total cost of bundled procedures
  • Increase the quality of care for bundled procedures

“The Oracle insurance cloud solution can also be leveraged by Benefit Management’s self-funded employers,” Somers said. “Value-based programs, especially when you’re talking about bundles, are of tremendous benefit to self-funded employers, and the capability to manage and adjudicate claims based on those kinds of value-based contracts will be something employers can take advantage of to great effect.”

“Oracle Health Insurance Value Based Payment Cloud Service provides the technology platform to administer many different non fee-for-service arrangements in a single solution,” said Srini Venkatasanthanam, Vice President for Oracle Insurance. “Oracle’s health insurance solution enables organizations such as Benefit Management to reduce time-to-market and significantly lower overall cost of ownership. We look forward to enabling Benefit Management to deliver an innovative prospective bundling offering to the market.”

To learn more about Oracle’s Value Based Payment Component and the opportunities it will provide to provider, payors and employers, visit Benefit Management online at www.BenefitManagementLLC.com

  Contact Info Valerie Beaudett
Oracle
+1.650.400.7833
valerie.beaudett@oracle.com About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

About Benefit Management LLC

Benefit Management provides customized, high-quality health benefits administration programs to partially self-insured companies and association plans nationwide, and also delivers value-based administration solutions to providers and payors. The company, founded in 1995, has long been regarded as one of the Midwest’s leading third party administrators, with a reputation for flexibility, innovative services and outstanding customer service. Benefit Management is headquartered in Great Bend, Kan., with offices in Wichita, Kansas City and St. Louis, and administers insured lives in all 50 states.

About NueHealth

NueHealth is building a nationwide system of clinically integrated provider networks that puts healthcare into the hands of consumers. With a vast network of purpose-driven surgical centers and hospitals, NueHealth connects providers directly to consumers and aids them in delivering value-based payment options and improved outcomes. To deliver this improved value, NueHealth leverages proprietary technologies, online platforms, bundled payments and targeted programs and services. NueHealth gives providers and payors the tools and resources to stay ahead of healthcare’s continued evolution, while giving employers, insurance companies and patients access to a simplified model and affordable, high-quality, streamlined care.

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Valerie Beaudett

  • +1.650.400.7833

Follow Oracle Corporate

Categories: Database, Vendor

Healthcare Organizations Turn to Oracle ERP Cloud for Industry’s Most Complete, Modern, and Proven Solution

Oracle Database News - Fri, 05/13/2016 - 13:00
Press Release Healthcare Organizations Turn to Oracle ERP Cloud for Industry’s Most Complete, Modern, and Proven Solution Oracle expands portfolio of healthcare customers with Adventist Health, Family Health, Presbyterian Medical Services, and Southern New Hampshire Health

Redwood Shores, Calif.—May 13, 2016

Oracle today announced that an increasing number of hospitals and healthcare systems worldwide are choosing Oracle Enterprise Resource Planning (ERP) Cloud to help increase productivity, lower costs, and improve controls. Adventist Health, Family Health, Presbyterian Medical Services, and Southern New Hampshire Health are just a few of the more than 1,800 organizations that have recently turned to Oracle ERP Cloud for a collaborative, efficient, and intuitive back-office hub with rich financial and operational capabilities to help reduce costs and modernize business practices to gain insight and productivity.

Healthcare organizations are under increasing pressure from regulatory agencies, consumers, employers, and governing boards to drive cost efficiency while maintaining quality patient care. Today’s healthcare systems are slow and expensive to maintain, especially when integrating a merged or acquired company. By standardizing on Oracle Modern Best Practice for Healthcare using embedded analytics, contextual social collaboration, and mobile technologies, healthcare organizations can achieve economies of scale faster to lower costs and access the innovative technologies to stay ahead of industry changes.

“Presbyterian Medical Services was looking for a complete cloud ERP solution that would help us drive efficiencies while maintaining quality patient care in a diverse, complex industry," said Chad Morris, senior ERP systems analyst, Presbyterian Medical Services. "In just 14 weeks, we were able to go live on Oracle ERP Cloud implementing a wide range of efficiencies with our 90+ locations across New Mexico. We are now in the process of going live on Oracle HCM Cloud."

“Hospitals and healthcare systems are contending with increased financial pressures resulting from rising costs coupled with reduced collections, an influx of data, and changing patient interactions due to high-deductible healthcare plans,” said Rod Johnson, senior vice president, Oracle. “We are committed to delivering innovative cloud solutions that help these healthcare organizations thrive and gain competitive advantage amid shifting industry conditions. Oracle ERP Cloud increases operational efficiencies and identifies growth areas to help healthcare organizations cost-effectively meet these challenges across their complex organizations and workforces.”

Built on a secure and scalable architecture, Oracle ERP Cloud provides customers with flexible alternatives via full or modular adoption, seamless integration across clouds, on-premise and third party applications, standardized best practices and rapid implementation templates, as well as extensive support for global companies in a wide variety of industries, including healthcare. Oracle ERP Cloud delivers complete ERP capabilities across financials, procurement, and project portfolio management, as well as Enterprise Performance Management (EPM), Governance Risk and Compliance (GRC) and Supply Chain Management (SCM). The portfolio includes deep global and industry-specific capabilities and is fully integrated with Oracle Human Capital Management (HCM) and Customer Relationship Management (CRM) solutions.

Contact Info Nicole Maloney
Oracle
1.650.506.0806
nicole.maloney@oracle.com About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

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

Follow Oracle Corporate

Categories: Database, Vendor

South Korean Therapeutic Cancer Vaccine Company Improves Drug Safety Processes with Oracle Cloud Solution

Oracle Database News - Fri, 05/13/2016 - 08:24
Press Release South Korean Therapeutic Cancer Vaccine Company Improves Drug Safety Processes with Oracle Cloud Solution GemVax & KAEL Group optimizes clinical development processes with Oracle Argus Cloud

Redwood Shores, Calif.—May 13, 2016

Patient safety is critical when pharmaceutical organizations develop new drug therapies and treatments. At the same, these pharmaceutical companies face pressures to deliver timely products to market and minimize costs. Oracle Health Sciences today announced that GemVax & KAEL Group, a novel therapeutic cancer vaccine company in South Korea, is using Oracle Argus Cloud to make faster, more informed drug safety decisions, while reducing the costs of outsourcing its business to a contract resource organization.

With the domestic launch of a new oncology drug and the upcoming global NDA approval for the drug, GemVax wanted to set up an in-house database to manage and have more control over both its new and existing cases. Previously, GemVax’s pharmacovigilance processes were managed through a global contract resource organization.

Oracle Argus Cloud enables GemVAX to improve its pharmacovigilance efficiency and effectiveness, while reducing the overall cost to manage its system in-house. It will also allow GemVax to create new insight into its safety data collection and case processing, and users can quickly drill down into case details.

“We are committed to developing new cancer therapies that harness the selective power of the immune system that seek out and destroy tumor cells,” said Michelle Kim, GemVax. “We rely on technologies like Oracle Argus Cloud to help ensure that we are making safety decisions, reduce risk and help ensure global compliance, so that we can focus on delivering therapies that will improve the quality of life of patients.”

Contact Info Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

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

  • +1.510.917.5564

Follow Oracle Corporate

Categories: Database, Vendor

PostgreSQL 9.5.3, 9.4.8, 9.3.13, 9.2.17 and 9.1.22 Released!

PostgreSQL News - Fri, 05/13/2016 - 01:00
2016-05-12 Cumulative Bug Fix Release

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.3, 9.4.8, 9.3.13, 9.2.17 and 9.1.22. This release fixes a number of issues reported by users over the last two months. Most database administrators should plan to upgrade at the next available downtime, unless they have been affected directly by the fixed issues.

Bug Fixes and Improvements

This update fixes several problems which caused downtime for users, including:

  • Clearing the OpenSSL error queue before OpenSSL calls, preventing errors in SSL connections, particularly when using the Python, Ruby or PHP OpenSSL wrappers
  • Fixed the "failed to build N-way joins" planner error
  • Fixed incorrect handling of equivalence in multilevel nestloop query plans, which could emit rows which didn't match the WHERE clause.
  • Prevented two memory leaks with using GIN indexes, including a potential index corruption risk.

The release also includes many other bug fixes for reported issues, many of which affect all supported versions:

  • Fix corner-case parser failures occurring when operator_precedence_warning is turned on
  • Prevent possible misbehavior of TH, th, and Y,YYY format codes in to_timestamp()
  • Correct dumping of VIEWs and RULEs which use ANY (array) in a subselect
  • Disallow newlines in ALTER SYSTEM parameter values
  • Avoid possible misbehavior after failing to remove a tablespace symlink
  • Fix crash in logical decoding on alignment-picky platforms
  • Avoid repeated requests for feedback from receiver while shutting down walsender
  • Multiple fixes for pg_upgrade
  • Support building with Visual Studio 2015

This update also contains tzdata release 2016d, with updates for Russia, Venezuela, Kirov, and Tomsk.

Updating

All PostgreSQL update releases are cumulative. 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 one or more update releases may need to run additional, post-update steps; please see the release notes for earlier versions for details.

Links:

Categories: Database, Open Source

PostgreSQL 9.5.3, 9.4.8, 9.3.13, 9.2.17 and 9.1.22 Released!

PostgreSQL News - Fri, 05/13/2016 - 01:00
2016-05-12 Cumulative Bug Fix Release

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.3, 9.4.8, 9.3.13, 9.2.17 and 9.1.22. This release fixes a number of issues reported by users over the last two months. Most database administrators should plan to upgrade at the next available downtime, unless they have been affected directly by the fixed issues.

Bug Fixes and Improvements

This update fixes several problems which caused downtime for users, including:

  • Clearing the OpenSSL error queue before OpenSSL calls, preventing errors in SSL connections, particularly when using the Python, Ruby or PHP OpenSSL wrappers
  • Fixed the "failed to build N-way joins" planner error
  • Fixed incorrect handling of equivalence in multilevel nestloop query plans, which could emit rows which didn't match the WHERE clause.
  • Prevented two memory leaks with using GIN indexes, including a potential index corruption risk.

The release also includes many other bug fixes for reported issues, many of which affect all supported versions:

  • Fix corner-case parser failures occurring when operator_precedence_warning is turned on
  • Prevent possible misbehavior of TH, th, and Y,YYY format codes in to_timestamp()
  • Correct dumping of VIEWs and RULEs which use ANY (array) in a subselect
  • Disallow newlines in ALTER SYSTEM parameter values
  • Avoid possible misbehavior after failing to remove a tablespace symlink
  • Fix crash in logical decoding on alignment-picky platforms
  • Avoid repeated requests for feedback from receiver while shutting down walsender
  • Multiple fixes for pg_upgrade
  • Support building with Visual Studio 2015

This update also contains tzdata release 2016d, with updates for Russia, Venezuela, Kirov, and Tomsk.

Updating

All PostgreSQL update releases are cumulative. 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 one or more update releases may need to run additional, post-update steps; please see the release notes for earlier versions for details.

Links:

Categories: Database, Open Source

Simbec-Orion Group Streamlines its Clinical Trial Management Processes with Oracle’s eClinical Cloud Suite

Oracle Database News - Thu, 05/12/2016 - 18:25
Press Release Simbec-Orion Group Streamlines its Clinical Trial Management Processes with Oracle’s eClinical Cloud Suite

Redwood Shores, Calif.—May 12, 2016

As more pharmaceutical companies outsource their clinical trials to contract research organizations (CROs), CROs are challenged to complete the clinical research in a more efficient and timely manner. Oracle Health Sciences today announced that Simbec-Orion Group Limited, a full service, international, boutique CRO, has adopted Oracle’s suite of eClinical cloud solutions to simplify the management of its customer’s clinical studies.

Oracle’s life sciences-specific solutions, combined with its broader product and service offering, are used by thousands of pharma, biopharma, and academic research centers worldwide to redesign clinical R&D processes, advance drug therapies, and optimize care delivery to improve the health, well-being, and lives of people globally.

Simbec-Orion Group selected cloud-based Oracle Health Sciences InForm, Siebel Oracle's Siebel Clinical Trial Management System, and Oracle Health Sciences IRT to supplement its clinical development processes, streamline data capture, and speed up trial timelines as Simbec-Orion expands its international, full-service, business offerings.

“We reviewed a wide range of providers to ensure, that as a world-class CRO, we were working with the best–in-class systems”, said Ronald Openshaw, CEO, Simbec-Orion. “We chose to partner with Oracle, the market leader in eClinical solutions, as we wanted to rely upon an excellent, secure, robust, and state-of-the-art service that will meet current and foreseeable, future, market needs.  We believe the scalability will drive efficiency in our work practices as we grow, especially in the light of increasingly complex clinical trials.”

“Oracle shares Simbec-Orion’s commitment to helping pharma and biotechnology companies deliver high-quality therapies to the patients we serve,” said Steve Rosenberg, senior vice president and general manager, Oracle Health Sciences. “ We look forward to working with Simbec-Orion as it further expands and enhances its clinical development services powered by our innovative technology.”

In 2014 through the merger of the two independent CROs, Simbec Research and Orion Clinical, Simbec-Orion Group was created as an international boutique CRO. Simbec-Orion Group now offers a full spectrum of drug development services from first-in-human Phase I clinical studies, through to pivotal Phase III studies and Phase IV post marketing studies. Starting in January 2016, unless the client expresses different requirements, new studies across the Simbec-Orion Group will use Oracle’s eClinical suite.

Contact Info Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

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

  • +1.510.917.5564

Follow Oracle Corporate

Categories: Database, Vendor