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

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

China-Based Contract Research Organization Selects Oracle Cloud to Optimize Clinical Trial Data Management

Oracle Database News - Thu, 05/12/2016 - 18:25
Press Release China-Based Contract Research Organization Selects Oracle Cloud to Optimize Clinical Trial Data Management

Redwood Shores, Calif.—May 12, 2016

Fountain Medical Development (FMD), a full-service Contract Research Organization (CRO) headquartered in Beijing, China, and its US affiliate, FMD K&L, have adopted Oracle’s cloud-based clinical data management solutions, to increase operational efficiencies and speed time to market. The solutions deliver increased productivity to the company’s drug development process, reduce overall costs, improve communications with its sponsors, and advance clinical study quality and speed, worldwide.

FMD was able to retire its aging, antiquated, legacy system and migrate to a more cost-effective cloud-based environment with Oracle Health Sciences InForm and Oracle Siebel Clinical Trial Management System (CTMS). The new, unified, technology platform has enhanced capabilities in data management, study planning and design, trial operations, analytics, and patient engagement.

“We are committed to delivering innovative solutions to our sponsors. This is why FMD decided to work with Oracle,” said Dr. Henry Wu, CEO, Fountain Medical Development. “Oracle’s data management solutions will enable us to improve our data quality, advance our trial data management efficiencies, reduce costs, and gain a deeper understanding of our clinical trial data across FMD’s integrated enterprise globally.”

Fountain Medical Development is a leading CRO offering a full range of International Conference on Harmonization Good Clinical Practice (ICH GCP) compliant clinical research services for multinational clients conducting clinical research in China. As one of the fastest growing clinical CROs in East Asia and China, FMD has established 12 operational offices throughout China, Hong Kong, Taiwan, Japan, Korea, the United States, and Armenia, with a strong focus on data management and biostatistics.

By moving to Oracle Health Sciences InForm and Oracle Siebel CTMS), FMD will gain powerful analytics capabilities that will provide a faster and better understanding of its clinical trial data across its locations, saving the company time and effort.

“Clinical research is becoming more complex and holistic by the day, and contract researchers are challenged to provide more services than ever before. Oracle Health Sciences provides global contract research organizations, like FMD, with an integrated platform and advanced analytics tools to help CROs and their sponsors find the cures of tomorrow,” said Steve Rosenberg, senior vice president and general manager, Oracle Health Sciences.

FMD is a member of the Oracle CRO Advantage Program, an initiative that helps drive CRO success with Oracle Health Sciences products through training, sales and marketing support, and bi-directional communication on Oracle products and strategy.

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

Oracle SRVCTL Issue in 11.2.0.4

Database Journal News - Thu, 05/12/2016 - 08:01

When using Oracle 11.2.0.4 in a Grid configuration the srvctl utility can change the group on the Oracle executables, creating problems with locating the spfile and with disk access.

Categories: Database

PostgreSQL 9.6 Beta 1 Released

PostgreSQL News - Thu, 05/12/2016 - 01:00

The PostgreSQL Global Development Group announces today that the first beta release of PostgreSQL 9.6 is available for download. This release contains previews of all of the features which will be available in the final release of version 9.6, although some details will change before then. Users are encouraged to begin testing their applications against this latest release.

Major Features of 9.6

Version 9.6 includes significant changes and exciting enhancements including:

  • Parallel sequential scans, joins and aggregates
  • Support for consistent, read-scaling clusters through multiple synchronous standbys and "remote_apply" synchronous commit.
  • Full text search for phrases
  • postgres_fdw can now execute sorts, joins, UPDATEs and DELETEs on the remote server
  • Decreased autovacuum impact on big tables by avoiding "refreezing" old data.

In particular, parallel execution should bring a noticeable increase in performance to supported queries.

Help Test for Bugs

As with other major releases, the improvements in PostgreSQL include changes to large amounts of code. We count on you to test the altered version with your workloads and testing tools in order to find bugs and regressions before the release of PostgreSQL 9.6.0. In addition to testing that the new features work as documented, consider testing the following:

  • Do parallel queries actually improve performance for you?
  • Can you make parallel queries crash or lose data?
  • Do our code changes cause PostgreSQL to not function on your platform?
  • Does improved vacuum freezing safely reduce autovacuum of large tables?
  • Does phrase search return the results you expect?

Version 9.6 Beta 1 also makes changes to the binary backup API. Administrators should test version 9.6 with PostgreSQL backup tools, including pgBackRest, Barman, WAL-E, and other packaged and in-house software.

As this is a Beta, minor changes to database behaviors, feature details, and APIs are still possible. Your feedback and testing will help determine the final tweaks on the new features, so test soon. The quality of user testing helps determine when we can make a final release.

Beta Schedule

This is the first beta release of version 9.6. The PostgreSQL Project will release additional betas as required for testing, followed by one or more release candidates, until the final release in late 2016. For further information please see the Beta Testing page.

Links
Categories: Database, Open Source

PostgreSQL 9.6 Beta 1 Released

PostgreSQL News - Thu, 05/12/2016 - 01:00

The PostgreSQL Global Development Group announces today that the first beta release of PostgreSQL 9.6 is available for download. This release contains previews of all of the features which will be available in the final release of version 9.6, although some details will change before then. Users are encouraged to begin testing their applications against this latest release.

Major Features of 9.6

Version 9.6 includes significant changes and exciting enhancements including:

  • Parallel sequential scans, joins and aggregates
  • Support for consistent, read-scaling clusters through multiple synchronous standbys and "remote_apply" synchronous commit.
  • Full text search for phrases
  • postgres_fdw can now execute sorts, joins, UPDATEs and DELETEs on the remote server
  • Decreased autovacuum impact on big tables by avoiding "refreezing" old data.

In particular, parallel execution should bring a noticeable increase in performance to supported queries.

Help Test for Bugs

As with other major releases, the improvements in PostgreSQL include changes to large amounts of code. We count on you to test the altered version with your workloads and testing tools in order to find bugs and regressions before the release of PostgreSQL 9.6.0. In addition to testing that the new features work as documented, consider testing the following:

  • Do parallel queries actually improve performance for you?
  • Can you make parallel queries crash or lose data?
  • Do our code changes cause PostgreSQL to not function on your platform?
  • Does improved vacuum freezing safely reduce autovacuum of large tables?
  • Does phrase search return the results you expect?

Version 9.6 Beta 1 also makes changes to the binary backup API. Administrators should test version 9.6 with PostgreSQL backup tools, including pgBackRest, Barman, WAL-E, and other packaged and in-house software.

As this is a Beta, minor changes to database behaviors, feature details, and APIs are still possible. Your feedback and testing will help determine the final tweaks on the new features, so test soon. The quality of user testing helps determine when we can make a final release.

Beta Schedule

This is the first beta release of version 9.6. The PostgreSQL Project will release additional betas as required for testing, followed by one or more release candidates, until the final release in late 2016. For further information please see the Beta Testing page.

Links
Categories: Database, Open Source

Simplifying MySQL Database Design using a Graphical Data Modeling Tool

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

As in all aspects of database development and management, specialized software has emerged to make the process of proper database design much easier to accomplish. In today’s tutorial, Rob Gravelle shows you how to design, implement, maintain, and synchronize MySQL database schemas using the Navicat Data Modeler.

Categories: Database

Row Level Security Part 3 – Disabling Row Level Security for DBAs and Database Owners

Database Journal News - Thu, 05/05/2016 - 08:01

Row Level security is all about restricting database users from being able to view or update rows based on who they are and what roles they are in. But there are some users who you “might” not want to restrict access at the row level at all, like the database owner, or someone with sysadmin permissions. In this article Greg Larsen shows you how to disable RLS for database administrators (users in the sysadmin role) and database owners.

Categories: Database

A tour through tool improvements in SQL Server 2016

This post was authored by Ayo Olubeko, Program Manager, Data Developer Group.

Two practices drive successful modern applications today – a fast time to market, and a relentless focus on listening to customers and rapidly iterating on their feedback. This has driven numerous improvements in software development and management practices. In this post, I will chronicle how we’ve embraced these principles to supercharge management and development experiences using SQL Server tooling.

SQL Server 2016 delivers many SQL tools enhancements that converge on the same goal of increasing day-to-day productivity, while developing and managing SQL servers and databases on any platform. This post provides an overview of the improvements and I’ll also drop a few hints about what’s on the way. With SQL Server 2016:

  • It’s easier to access popular tools, such as SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT).
  • Monthly releases of new SQL tools make it easy to stay current with new features and fixes.
  • Day-to-day development is being simplified, starting with a new connection experience.
  • New SQL Server 2016 features have a fully guided manageability experience.
  • Automated build and deployment of SQL Server databases can improve your time to market and quality processes.
Finding and using the most popular SQL tools is easier than ever

We received insightful feedback from customers about how difficult it was to find and install tooling for SQL Server, so we’ve taken a few steps to ensure the experience in SQL Server 2016 is as easy as possible.

Free and simple to find and install SQL tools

SQL Server Management Suite

The SQL Server tools download page is the unified place to find and install all SQL Server-related tools. The latest version of SQL tools doesn’t just support SQL Server 2016, but it also supports all earlier versions of SQL Server, so there is no need to install SQL tools per SQL Server version. In addition, you don’t need a SQL Server license to install and use these SQL tools.

SSMS has a new one-click installer that makes it easy to install, whether you’re on a server in your data center or on your laptop at home. Additionally, the installer supports administrative installs for environments not connected to the Internet.

All your SQL tools for Visual Studio in one installer, for whichever version of SQL Server you use

SQL Server Data ToolsSQL Server Data Tools (SSDT) is the name for all your SQL tools installed into Visual Studio. With just one installation of SSDT in Visual Studio 2015, developers can easily integrate efforts to develop applications for SQL Server, Analysis Services, Reporting Services, Integration Services and any application in Visual Studio 2015 for SQL Server 2016 – or older versions as needed.

SSDT replaces/unifies older tools such as BIDS, SSDT-BI and the database-only SSDT, eliminating the confusion about which version of Visual Studio to use. From Visual Studio 2015 and up you’ll have a simple way to install all of the SQL tools you use every day.

Easy to stay current – new features and fixes every month

SQL Server Management StudioOne of the goals for SQL tools is to provide world-class support for your SQL estate wherever it may be. This could be comprised of SQL servers running on-premises or in the cloud, or some fantastic hybrid of both. We support it all. In order to enable world class coverage of this diverse estate, we have adopted a monthly release cadence for our SQL tools. This faster release cycle brings you additional value and improvements – whether it’s enabling functionality to take advantage of new Microsoft Azure cloud features, issuing a bug fix to address particularly painful errors, or even creating a new wizard/dialog to streamline management of your SQL Server.

These stand-alone SSMS releases include an update checker that informs you of newer SSMS releases when they become available. SSDT update notification continues to be fully integrated with Visual Studio’s notification system. You can keep up to date and learn more about the SSMS and SSDT releases at the SQL Server Release Services blog.

Day-to-day development is being simplified, starting with a new connection experience Connection DialogDiscover and seamlessly connect to your databases anywhere

No more need to memorize server and database names. With just a few clicks, the new connection experience in SQL Server Data Tools helps you automatically discover and connect to all your database assets using favorites, recent history or by simply browsing SQL servers and databases on your local PC, network and Azure. You can also pin databases you frequently connect so they’re always there when you need them. In addition, the new connection experience intelligently detects the type of connection you need, automatically configures default properties with sensible values and guides you through firewall settings for SQL Database and Data Warehouse.

Streamline connections to your Azure SQL databases in SSMS

The new firewall rule dialog in SSMS allows you to create an Azure database firewall rule within the context of connecting to your database. You don’t have to login to the Azure portal and create a firewall rule prior to connecting to your Azure SQL Database with SSMS. The firewall rule dialog auto-fills the IP address of your client machine and allows you to optionally whitelist an IP range to allow other connections to the database.

New Firewall Rule

Fully guided management experiences

SQL Server 2016 is packed with advanced, new features including Always Encrypted, Stretch Database, enhancements with In-Memory Table Optimization and new Basic Availability Groups for AlwaysOn — just to name a few. SSMS delivers highly intelligent, easy-to-click-through wizard interfaces that help you enable these new features and make your SQL Server and Database highly secure, highly available and faster in just a few minutes. There’s an easy learning curve, even though the technology that’s under the hood enabling your business is powerful and complex.

Always Encrypted Intro

Adopting DevOps processes with automated build and deployment of SQL Server databases

Features such as the Data-tier Application Framework (DACFx) technology and SSDT have helped make SQL Server the market leader of model-based database lifecycle management technology. DACFx and SSDT offer a comprehensive development experience by supporting all database objects in SQL Server 2016, so developers can develop a database in a declarative way using a database project.

Using Visual Studio 2015, version control and Team Foundation Server 2015 or Visual Studio Team Services in the cloud, developers can automate database lifecycle management and truly adopt a DevOps model for rapid application and database development and deployment.

What’s coming next in your SQL tools

In the months to come, you can look forward to continued enhancements in both SSMS and SSDT that focus on increasing the ease with which you develop and manage data in any SQL platform.

To this end, SSMS will feature performance enhancements and streamlined management and configuration experiences that build on the new capabilities provided by the Visual Studio 2015 shell. Similarly, SSDT will deliver performance improvements and feature support to help database developers handle schema changes more efficiently. Learn more about tooling improvements for SQL Server 2016 in the video below.

Improvements like these can’t happen in a vacuum. Your voice and input are absolutely essential to building the next generation of SQL tools. And the monthly release cycle for our SQL tools allows us to respond faster to the issues you bring to our attention. Please don’t forget to vote on Connect bugs or open suggestions for features you would like to see built.

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

Try SQL Server 2016 RC

Categories: Database