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

Barman 1.3.3 released

PostgreSQL News - Thu, 08/21/2014 - 01:00

21 August 2014: 2ndQuadrant is proud to announce the release of version 1.3.3 of Barman, Backup and Recovery Manager for PostgreSQL.

This major release improves robustness of both backup procedures and their monitoring, by introducing:

  • the so-called "smelly backup" control, allowing DBAs to detect possible problems in scheduling of periodical backups, by receiving complaints by "barman check" when the latest available backup for a server is older than a specified timeframe
  • management of retry attempts for base backup copy (for both "barman backup" and "barman recover" commands), making the operation more resilient to temporary issues such as network connection drops

Performance issues have been fixed in relation to remote recovery over existing directories (incremental recovery), by invoking checksum control only when strictly necessary.

Usability has been enhanced through better exception handling, output and logging messages. PostgreSQL 8.3 is also now supported.

The following major bugs have been fixed:

  • Copies "recovery.conf" during remote "barman recover" (#43)
  • Correctly detect pre/post archive hook scripts (#41)

Minor bugs have also been fixed.

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

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

Links

Release notes

  • Added "last_backup_max_age", a new global/server option that allows administrators to set the max age of the last backup in a catalogue, making it easier to detect any issues with periodical backup execution
  • Improved robustness of "barman backup" by introducing two global/server options: "basebackup_retry_times" and "basebackup_retry_sleep". These options allow an administrator to specify, respectively, the number of attempts for a copy operation after a failure, and the number of seconds of wait before retrying
  • Improved the recovery process via rsync on an existing directory (incremental recovery), by splitting the previous rsync call into several ones - invoking checksum control only when necessary
  • Added support for PostgreSQL 8.3
  • Minor changes:
    • Support for comma separated list values configuration options
    • Improved backup durability by calling fsync() on backup and WAL files during "barman backup" and "barman cron"
    • Improved Nagios output for "barman check --nagios"
    • Display compression ratio for WALs in "barman show-backup"
    • Correctly handled keyboard interruption (CTRL-C) while performing barman backup
    • Improved error messages of failures regarding the stop of a backup
    • Wider coverage of unit tests
  • Bug fixes:
    • Copies "recovery.conf" on the remote server during "barman recover" (#43)
    • Correctly detect pre/post archive hook scripts (#41)

Download

About Barman

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, 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

Oracle Enhances Oracle Social Cloud with Next-Generation User Experience

Oracle Database News - Wed, 08/20/2014 - 13:00
Oracle Enhances Oracle Social Cloud with Next-Generation User Experience Social Station creates advanced, customizable experiences that facilitates productivity and social business resultsRedwood Shores, Calif. – August 20, 2014 News Summary

Today’s enterprise must meet the technology standards of today’s consumer. According to a recent IDG Enterprise report, enterprises that invest in consumerized, easy-to-use technologies experience a 56 percent increase in employee productivity and a 46 percent increase in customer satisfaction. In order to deliver that simple and intuitive experience across even the most advanced social management capabilities, Oracle today introduced Social Station, an innovative new workspace within Oracle Social Cloud’s Social Relationship Management (SRM) platform. With Social Station, users benefit from a personalized and intuitive user experience that helps increase both the productivity and performance of social business practices.

News Facts Oracle today introduced Social Station, an innovative new workspace within Oracle Social Cloud’s Social Relationship Management (SRM) platform that helps organizations socially enable the way they do business. With an advanced yet intuitive user interface, Social Station delivers a compelling user experience that improves productivity and helps users more easily deliver on social objectives. To help users quickly and easily build out and configure their social workspaces, Social Station provides drag-and-drop capabilities that allow users to personalize their workspace with different social modules. With a new Custom Analytics module that mixes and matches more than 120 metrics with thousands of customizable reporting options, users can customize their view of social data and access constantly refreshed updates that support real-time understanding. One-click sharing capabilities and annotation functionality within the new Custom Analytics module also drives productivity by improving sharing and collaboration across teams, departments, and executives. Multiview layout capabilities further allows visibility into social insights by offering users the flexibility to monitor conversations by network, stream, metric, graph type, date range, and relative time period. Social Station also includes an Enhanced Calendar module that provides a clear visual representation of content, posts, networks, and views, helping users easily and efficiently understand information and toggle between various functions and views. To support different user personas and social business needs, Oracle plans to continue building out Social Station with additional modules, including content curation, influencer engagement, and command center creation. Supporting Quote “Consumers today have high expectations of technology applications’ capabilities and usability, and those expectations don’t stop when they enter their workplaces,” said Meg Bear, group vice president, Oracle Social Cloud, Oracle. “We constantly evolve our products to give our customers a competitive edge, and Social Station delivers a dynamic UX that drives productivity and social business results. By making it easier than ever to understand, report, and share social insights across the enterprise, we are enabling our customers to move at the speed of social to align and impact business metrics and strategy.”Supporting Resources Learn More About Oracle Cloud Oracle Social Cloud Oracle Social Spotlight Blog Follow Oracle Social on Twitter Oracle OpenWorld 2014 http://oracle-downloads.com/OracleSocial/ About Oracle

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

Trademarks

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

###

Contact Info

Chaundera Wolfe
Oracle
+1.650.506.9857
chaundera.wolfe@oracle.com

Simon Jones
Blanc & Otus
+1.415.856.5155
sjones@blancandotus.com

Categories: Database, Vendor

Build a data mining app using Java, Weka, and the Analytics Warehouse service

IBM - DB2 and Informix Articles - Wed, 08/20/2014 - 05:00
The Analytics Warehouse (formerly BLU Acceleration) service provides data warehousing and analytics as a service on IBM Bluemix. Developers can develop and deploy a heavy-duty analytic application using blazing-fast IBM BLU database technology offered in the cloud. Learn how to develop a data mining application using the Weka statistical analysis tool and leveraging the IBM BLU columnar database.
Categories: Database

Build a data mining app using Java, Weka, and the Analytics Warehouse service

IBM - DB2 and Informix Articles - Wed, 08/20/2014 - 05:00
The Analytics Warehouse (formerly BLU Acceleration) service provides data warehousing and analytics as a service on IBM Bluemix. Developers can develop and deploy a heavy-duty analytic application using blazing-fast IBM BLU database technology offered in the cloud. Learn how to develop a data mining application using the Weka statistical analysis tool and leveraging the IBM BLU columnar database.
Categories: Database

Build a cache application in the cloud with Bluemix cache services

IBM - DB2 and Informix Articles - Tue, 08/19/2014 - 05:00
This tutorial talks about building caching applications on top of the IBM Cloud environment. The execution time recorded demonstrates the speed of accessing the caching service.
Categories: Database

Introducing POWA ! A new PostgreSQL Workload Analyzer

PostgreSQL News - Tue, 08/19/2014 - 01:00

DALIBO is proud to present the first release of POWA, a brand new performance tool for PostgreSQL.

Realtime traffic analysis and dynamic graphs

POWA is a workload analyzer that gives a clear view of the current activity of your PostgreSQL servers with a query runtime graph and a block hit/read graph along with a chart of time consuming request over the specified time period.

If you zoom anywhere in one of the graphs, the chart will adjust and show you which queries were running at that time. If you click on a specific query, you will get additional graphs such as read/write time, number of rows affected, local and shared hit, etc.

A bunch of PL functions are also available to access and manage the stats.

Extending pg_stat_statements

Basically PoWA is a PostgreSQL extension designed to historize information given by the pg_stat_statements extension. It provides SQL SRF to gather useful information on a specified time interval.

This first release is ready for production but of course we will continue to improve it. Please install it (or test our demo site) and let's us know what you think of it. Right now what we need most is feedback and new ideas, especially to improve the user experience and the graphic interface...

PoWA is available under the PostgreSQL license. The main code is a PostgreSQL extension written in C and SQL. The user interface is based on Perl and Mojolicious. Obviously the stats are stored in a PostgreSQL database :-)

For the complete list of changes, please checkout the release note on https://github.com/dalibo/powa/blob/master/CHANGELOG.md

Credits

DALIBO would like to thank all the developers who contributed to this release, especially : Marc Cousin for the original idea and Julien Rouhaud for the hard work on the GUI.

POWA is an open project available under the PostgreSQL License. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools or directly to powa@dalibo.com

Links :

About POWA :

PoWA is PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graph to help monitor and tune your PostgreSQL servers. It is similar to Oracle AWR or SQL Server MDW.

Code & Demo at http://dalibo.github.io/powa/

About DALIBO :

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

Check out DALIBO's open source projects at http://dalibo.github.io

http://www.dalibo.com

Categories: Database, Open Source

Big Data Technologists Transition to Customer-Facing Roles

Database Journal News - Mon, 08/18/2014 - 08:01

Big data applications do not need the same infrastructure support teams as do more common applications. As the enterprise embraces big data, management assumes that staff sizes will decrease. What should be done with those unneeded technologists? One answer: convert them into technology consultants that collaborate and coordinate with the lines of business. In other words, give them customer-facing roles.

Categories: Database

DBD::Pg 3.4.0 released

PostgreSQL News - Mon, 08/18/2014 - 01:00

Version 3.4.0 of DBD::Pg, the Perl driver for Postgres, has been released: http://search.cpan.org/dist/DBD-Pg/

This version greatly enhanced the table_info() and column_info() methods.

Categories: Database, Open Source

Court Finds Rimini Street Engaged in "Massive Theft" of Oracle's Intellectual Property, and Once Again Rules That Rimini Street Infringed Oracle's Copyrights

Oracle Database News - Thu, 08/14/2014 - 23:22
Court Finds Rimini Street Engaged in "Massive Theft" of Oracle's Intellectual Property, and Once Again Rules That Rimini Street Infringed Oracle's CopyrightsREDWOOD SHORES, Calif. – August 14, 2014News Facts


On August 14, 2014, the U.S. District Court in Las Vegas entered an order granting Oracle's motion for partial summary judgment in its case against Rimini Street, Inc. and its CEO, Seth Ravin.

Oracle moved for summary judgment on Rimini's counterclaims for defamation and unfair competition.  In those counterclaims, Rimini challenged Oracle's public statements that Rimini had engaged in massive theft of Oracle's intellectual property.  The Court dismissed those counterclaims finding that Oracle's statements "that Rimini had engaged in 'massive theft' of Oracle's intellectual property are true."  (Opinion at 29, emphasis added)  The Court explained that "It is undisputed that Rimini engaged in theft of Oracle's intellectual property. . . ."  (Opinion at 29, emphasis added.)

The Court also found that Rimini Street infringed Oracle's copyrights.  In February, the Court found that Rimini Street infringed Oracle's PeopleSoft copyrights and that Oracle had proved prima facie copyright infringement as to its JD Edwards and Siebel copyrights.  Today, the Court ruled that Rimini Street also infringed Oracle Database copyrights.   The Court found that Rimini Street had downloaded 25 copies of Oracle's Database software and possessed over 200 copies of this software even though Rimini's downloading, possession, and use of this software all was unlicensed.

The Court ordered the parties to submit a pre-trial order within sixty days. 

"The Court's ruling today, like the Court's ruling in February, is an important vindication of Oracle's intellectual property rights," said Oracle attorney Geoff Howard.  "After today's ruling, Rimini can no longer deny that it engaged in ‘massive theft’ of Oracle's intellectual property.  We look forward to holding Rimini Street and Seth Ravin accountable at trial for the damages caused by their misconduct."


About Oracle

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

Trademarks

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

Contact Info

Deborah Hellinger
Oracle Corporate Communications
+1.212.508.7935
deborah.hellinger@oracle.com

 
Categories: Database, Vendor

Oracle: Getting The Starting Date Of A Week Using Week Number

Database Journal News - Thu, 08/14/2014 - 08:01

Week numbering schemes are interesting and getting the starting date based on that number is even more so. Read on to see what schemes there are and if you can, indeed, get the starting date you expect.

Categories: Database

Generate reports remotely and offline with InfoSphere Optim Performance Manager command-line utility

IBM - DB2 and Informix Articles - Thu, 08/14/2014 - 05:00
You can use predefined report features in the InfoSphere Optim Performance Manager for DB2 for Linux, UNIX and Windows web console to generate reports in HTML, PDF, PPT, and XLS formats. In this tutorial, learn how to extend these features with the command-line utility (CLU). With the CLU, you can generate reports in offline and batch mode without logging on to the web console, schedule reports to run at periodic intervals, and send reports as attachments to team members.
Categories: Database

Oracle E-Business Suite 12.2.4 Helps Organizations Further Optimize Business Processes, Reduce Costs, and Respond to Changing Market Conditions

Oracle Database News - Wed, 08/13/2014 - 13:00
Oracle E-Business Suite 12.2.4 Helps Organizations Further Optimize Business Processes, Reduce Costs, and Respond to Changing Market ConditionsRelease includes customer-driven enhancements across virtually all functional areas and new cloud integrationsREDWOOD SHORES, Calif. – August 13, 2014News Summary

Today’s global business environment is complex and constantly changing. To help organizations navigate this continuously shifting landscape and stay competitive, Oracle has released Oracle E-Business Suite 12.2.4. This latest release provides an updated user experience, significant customer-driven enhancements across the applications suite, and more integrations to Oracle Cloud Solutions. With the powerful new capabilities, organizations can manage that complexity while focusing on more strategic business issues and processes.

News Facts To help organizations manage the complexities of global business environments and gain a competitive edge, Oracle today announced the general availability of Oracle E-Business Suite 12.2.4. With modern user experience updates, significant customer-driven enhancements, and more integrations to Oracle Cloud Solutions, Oracle E-Business Suite 12.2.4 enables organizations to further optimize business processes, reduce costs, and respond quickly to changing market conditions. Organizations already on Oracle E-Business Suite 12.2 can use online patching to easily gain the latest functionality.Enhancements Drive Increased Business Value

    .

Oracle E-Business Suite 12.2.4 helps organizations further optimize business processes, reduce costs, and respond quickly to changing market conditions by introducing enhancements in the following enterprise resource planning (ERP) areas: Oracle Financials: Faster approval cycles from parallel approval of invoices. A single mass allocation formula is used to generate allocation journals for all ledgers in a ledger set. Integration with Oracle Revenue Management Cloud allows users to leverage the revenue compliance and recognition benefits of that product. Oracle Projects: Enhancements in Oracle Project Contracts and Oracle Project Billing allow US federal contractors to improve cash flow, increase transparency and audit, and automate billing. Oracle Purchasing: Web ADI–enabled spreadsheet creation and modification of purchase order lines, schedules, and distributions improves buyer productivity when dealing with large orders. Oracle iProcurement: A streamlined single-step checkout flow allows employees to quickly complete shopping activities and start the requisition approval process. Oracle Procurement Contracts: Improved buyer efficiency from auditing of contract documents by reviewing details of policy deviations and net clause additions. Oracle Services Procurement: Enhanced capabilities provide buyers with greater flexibility to support a broad range of complex order scenarios. Oracle Channel Revenue Management: Improved volume offer capabilities and a streamlined user interface enable users to quickly adapt to changing business conditions. To further help organizations transform supply chains from a functional necessity to a competitive advantage, the latest release of Oracle E-Business Suite includes the following supply chain management (SCM) enhancements: Oracle Order Management: A new HTML user interface provides improved usability, greater flexibility, and a more modern user experience. Oracle Yard Management: A new solution enables manufacturing, distribution, and asset-intensive organizations to manage and track the flow of trailers and their contents into, within, and out of the yards of distribution centers, production campuses, transportation terminals, and other facilities. Oracle Manufacturing: Significant usability improvements in the Oracle Manufacturing Execution System (MES) help improve operator productivity by simplifying time entry and quality collection. New capabilities to manage the auto-dekit (disassembly) of serialized products supports customer returns and internal reuse of component parts. Oracle Enterprise Asset Management: Enhancements to support linear assets in industries, such as oil and gas, utilities, and public sector, help improve productivity and retire costly integrations and custom code. Oracle Service: Enhanced spare parts planner’s dashboard provides rich user interaction to improve planner productivity. Oracle Value Chain Planning: Numerous enhancements across multiple products include deeper industry functionality, such as minimum remaining shelf-life enhancements for the pharmaceutical and consumer goods industries, multistage production synchronization for process industries, and integration between Oracle Service Parts Planning and Oracle Enterprise Asset Management for asset-intensive industries. New promotions planning analytics in Oracle Advanced Planning Command Center improve business insight. To help organizations further modernize Human Capital Management (HCM) practices, the latest release of Oracle E-Business Suite includes: Oracle Payroll: Payroll dashboard provides at-a-glance readiness checks, validation, and analytical views of the entire payroll cycle to help payroll administrators gain valuable insight into payroll processes, avoid costly errors, and improve productivity. Oracle Self-Service Human Resources: Transaction dashboard helps employees and managers monitor the approval progress of self-service transactions, and review transaction details at any point after final approval. Oracle Learning Management: Enhanced user interface simplifies the learner’s ability to search the training catalog, engage in learning activities, and share experiences with fellow learners. To enable improved user productivity across the applications, the latest release of Oracle E-Business Suite incorporates these current UI design trends: Optimizations for touch screen tablets, including larger buttons and support for touch gestures. Support for users to hide/show table columns and save changes as a user personalization. A simplified home page with colorful icons allows users to easily access favorite functions, and a streamlined universal global header provides easy access to common functions from any page. More fine-grained proxy access gives users greater control over delegating their Oracle E-Business Suite authority to other users.Supporting Quote “Organizations today need to provide the workforce with a more modern user interface, and address business challenges with greater automation and efficiency,” said Cliff Godwin, senior vice president, Oracle Applications Development. “With Oracle E-Business Suite 12.2.4, Oracle continues to modernize the user interface and deliver new customer-driven capabilities across the applications, while reducing the costs of owning and running Oracle E-Business Suite.” Supporting Resources Oracle E-Business Suite Oracle E-Business Suite YouTube ChannelAbout Oracle

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

Trademarks

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

###

Karen Hartquist
Oracle
+1.650.506.3552
karen.hartquist@oracle.com

Simon Jones
Blanc & Otus
+1.415.856.5155
sjones@blancandotus.com

Categories: Database, Vendor

Expiration Date of Tender Offer for MICROS Systems, Inc. Shares Extended to September 2, 2014

Oracle Database News - Wed, 08/13/2014 - 09:01
Expiration Date of Tender Offer for MICROS Systems, Inc. Shares Extended to September 2, 2014REDWOOD SHORES, Calif. – August 13, 2014

Oracle Corporation (NYSE: ORCL) announced today that, in accordance with the terms of its merger agreement with MICROS Systems, Inc. (Nasdaq: MCRS), Rocket Acquisition Corporation, a subsidiary of OC Acquisition LLC, a subsidiary of Oracle Corporation, has extended its all-cash tender offer for $68.00 per share for all of the issued and outstanding shares of common stock, par value of $0.025 per share (the “Shares”), of MICROS Systems, Inc. to 12:00 Midnight, New York City time, at the end of September 2, 2014, unless further extended. The tender offer was previously set to expire at 12:00 Midnight, New York City time, at the end of August 15, 2014. The extension is being made in light of the fact that the European Commission has indicated that the provisional deadline for concluding its review of the transaction under the EC Merger Regulation is August 29, 2014, and the other terms of the merger agreement, including the conditions to the tender offer. Except for the extension of the tender offer, all other terms and conditions of the tender offer remain unchanged.

American Stock Transfer & Trust Company LLC, the depositary for the tender offer, has indicated that as of 12:00 Midnight, New York City time, at the end of August 12, 2014, approximately 74,936,802 Shares were issued and outstanding, and 20,068,591 Shares have been tendered into and not properly withdrawn from the tender offer (including 205,669 Shares tendered pursuant to the guaranteed delivery procedures set forth in the Offer to Purchase).


About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE: ORCL), visit 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.


This document is for informational purposes only and may not be incorporated into a contract or agreement.

Contact Info

Ken Bond
Oracle Investor Relations
+1.650.607.0349
ken.bond@oracle.com

Deborah Hellinger
Oracle Corporate Communications
+1.212.508.7935
deborah.hellinger@oracle.com

Additional Information

This communication does not constitute an offer to buy or solicitation of an offer to sell any securities. This communication is for informational purposes only. The tender offer is not being made to, nor will tenders be accepted from, or on behalf of, holders of shares in any jurisdiction in which the making of the tender offer or the acceptance thereof would not comply with the laws of that jurisdiction. The tender offer is being made pursuant to a tender offer statement on Schedule TO (including the Offer to Purchase, a related Letter of Transmittal and other offer materials) filed by Rocket Acquisition Corporation with the U.S. Securities and Exchange Commission (“SEC”) on July 3, 2014, as amended from time to time. In addition, on July 3, 2014, MICROS Systems, Inc. filed a Solicitation/Recommendation statement on Schedule 14D-9 with the SEC related to the tender offer. Stockholders of MICROS Systems, Inc. are urged to read these documents, all amendments thereto and other documents filed with the SEC carefully in their entirety because they contain important information about the tender offer. The tender offer statement and certain other offer documents, along with the Solicitation/Recommendation statement, will be made available to all stockholders of MICROS Systems, Inc. at no expense to them. These documents are available at no charge through the web site maintained by the SEC at http://www.sec.gov. The Offer to Purchase, related Letter of Transmittal, the Solicitation/Recommendation statement and other offering documents may also be obtained for free by contacting the Information Agent for the tender offer, Innisfree, M&A Incorporated, toll-free at 888-750-5834.

Cautionary Statement Regarding Forward-Looking Statements

This document contains certain forward-looking statements about Oracle and MICROS Systems, Inc., including statements that involve risks and uncertainties concerning Oracle's proposed acquisition of MICROS Systems, Inc., anticipated customer benefits and general business outlook. When used in this document, the words "anticipates", “can", “will”, "look forward to", "expected" and similar expressions and any other statements that are not historical facts are intended to identify those assertions as forward-looking statements. Any such statement may be influenced by a variety of factors, many of which are beyond the control of Oracle or MICROS Systems, Inc., that could cause actual outcomes and results to be materially different from those projected, described, expressed or implied in this document due to a number of risks and uncertainties. Potential risks and uncertainties include, among others, the possibility that the transaction will not close or that the closing may be delayed, the anticipated synergies of the combined companies may not be achieved after closing, the combined operations may not be successfully integrated in a timely manner, if at all, general economic conditions in regions in which either company does business, and the possibility that Oracle or MICROS Systems, Inc. may be adversely affected by other economic, business, and/or competitive factors. Accordingly, no assurances can be given that any of the events anticipated by the forward-looking statements will transpire or occur, or if any of them do so, what impact they will have on the results of operations or financial condition of Oracle or MICROS Systems, Inc. You are cautioned to not place undue reliance on forward-looking statements, which speak only as of the date of this document. Neither Oracle nor MICROS Systems, Inc. is under any duty to update any of the information in this document.

In addition, please refer to the documents that Oracle and MICROS Systems, Inc., respectively, file with the U.S. Securities and Exchange Commission (the “SEC”) on Forms 10-K, 10-Q and 8-K. These filings identify and address other important factors that could cause Oracle's and MICROS Systems, Inc’s respective operational and other results to differ materially from those contained in the forward-looking statements set forth in this document. You are cautioned to not place undue reliance on forward-looking statements, which speak only as of the date of this document. Neither Oracle nor MICROS Systems, Inc. is under any duty to update any of the information in this document.

Categories: Database, Vendor

Remove and reintegrate an auxiliary standby in an HADR setup

IBM - DB2 and Informix Articles - Wed, 08/13/2014 - 05:00
Starting with IBM DB2 10.1, the High Availability Disaster Recovery (HADR) feature supports multiple standbys. With multiple standbys, you can have your data in more than two sites for improved data protection with a single technology. This article provides detailed steps for removing and reintegrating the auxiliary standby in a multiple standby HADR setup.
Categories: Database

Jumping through Hadoop: Stream Big Data video on a mobile app by integrating IBM Worklight with IBM InfoSphere BigInsights on IBM Bluemix

IBM - DB2 and Informix Articles - Wed, 08/13/2014 - 05:00
This article explains how you can integrate video data streaming with a mobile application. In doing so, it also highlights some of the business problems addressed and opportunities available by using several cutting-edge technologies: IBM InfoSphere BigInsights on IBM Bluemix and IBM Worklight. This is an example of a compelling trend that demands cloud service integration of big data to mobile devices for video streaming.
Categories: Database

A brief comparative perspective on SQL access for Hadoop

IBM - DB2 and Informix Articles - Tue, 08/12/2014 - 05:00
Although Hadoop is often thought of as the one-size-fits-all solution for big data processing problems, the project is limited in its ability to manage large-scale graph processing, stream processing, and scalable processing of structured data. Learn about Big SQL, a massively parallel processing SQL engine that is optimized for processing large-scale structured data. See how it compares to other systems that were recently introduced to improve the efficiency of the Hadoop framework for processing large-scale structured data.
Categories: Database

A brief comparative perspective on SQL access for Hadoop

IBM - DB2 and Informix Articles - Tue, 08/12/2014 - 05:00
Although Hadoop is often thought of as the one-size-fits-all solution for big data processing problems, the project is limited in its ability to manage large-scale graph processing, stream processing, and scalable processing of structured data. Learn about Big SQL, a massively parallel processing SQL engine that is optimized for processing large-scale structured data. See how it compares to other systems that were recently introduced to improve the efficiency of the Hadoop framework for processing large-scale structured data.
Categories: Database

pgBadger 6.0 is out!

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

DALIBO is proud to announce the release of pgBadger 6.0.

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

This new major release fixes several issues and adds some new features:

  • Automatic cleanup of binary files in incremental mode.
  • Automatic handling of retention with a maximum number of weeks to keep reports.
  • Incremental mode improvement by allowing the use of multiprocessing with multiple log file.
  • Now reports the query latency percentiles on the general activity table (percentiles are 90, 95, 99).
  • A new output format: JSON. This format is good for sharing data with other tools.
  • Using the --anonymize option pgBadger will anonymize all literal values in the queries.
  • Add a click-to-select button in front of each query that allow to just use Ctrl+C to copy it on clipboard.
  • Several space usage improvement in incremental mode, the -X option allow the use of external CSS and Javascript files.
  • A new pgBadger logo

 

Warning: the behavior of pgBadger in incremental mode has changed. It will now always cleanup the output directory of all the obsolete binary file. If you were using those files to build your own reports, you can prevent pgBadger to remove them by using the --noclean option. Note that if you use the retention feature, all those files in obsolete directories will be removed too.

For the complete list of changes, please checkout the release note on https://github.com/dalibo/pgbadger/blob/master/ChangeLog

Links & Credits

DALIBO would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially Herve Werner, Julien Rouhaud, Josh Berkus, CZAirwolf, Bruno Almeida, Marc Cousin, Thomas Reiss, Rodolphe Quiedeville, Himanchali, Guilhem Rambal, Shanzhang Lan, Xavier Millies-Lacroix, Kong Man, wmorancfi, flopma and birkosan.

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

Links :

About pgBadger :

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

Docs, Download & Demo at http://dalibo.github.io/pgbadger/

About DALIBO :

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

Check out DALIBO's open source projects at http://dalibo.github.io

Categories: Database, Open Source

MySQL Numeric Overflow Gotcha

Database Journal News - Mon, 08/11/2014 - 08:01

Rob Gravelle highlights a gotcha related to MySQL's overflow handling of numeric values that are outside the permissible range of the column data type.

Categories: Database

Oracle Customers Secure Critical Encryption Keys with Oracle Key Vault

Oracle Database News - Thu, 08/07/2014 - 13:00
Oracle Customers Secure Critical Encryption Keys with Oracle Key Vault New solution enables centralized management of Oracle Database encryption master keys, Oracle wallet files, Java KeyStores, and moreRedwood Shores, Calif. – August 7, 2014 News Summary

Encryption is widely recognized as the gold standard for protecting data privacy, but encryption is only as strong as its key management. Critical credential files such as Oracle wallet files, Java KeyStores, Secure Shell (SSH) key files, and Secure Sockets Layer (SSL) certificate files are often widely distributed across servers and server clusters that use error-prone synchronization and backup mechanisms. As organizations increasingly encrypt data at rest and on the network, securely managing all the encryption keys and credential files in the data center has become a major challenge.

At the same time, organizations also need to comply with stringent regulatory requirements for managing keys and certificates. Many global regulations and industry standards call for audits demonstrating that keys are routinely rotated, properly destroyed, and accessed solely by authorized entities.

To address the need for robust key management, Oracle today introduced Oracle Key Vault, a software appliance designed to securely manage encryption keys and credential files in the enterprise data center.

News Facts Oracle Key Vault, the latest addition to the Oracle Database security portfolio, provides secure, centralized management of encryption keys and credential files in the data center, including Oracle wallet files, Java KeyStores, Kerberos keytab files, SSH key files, and SSL certificate files. Optimized for the Oracle technology stack, including Oracle Database and Oracle Fusion Middleware, Oracle Key Vault can be deployed seamlessly in existing environments. Built for x86-64 hardware, the fully integrated software appliance uses Oracle Linux and Oracle Database technology for security, availability, and scalability. Oracle Key Vault is the industry’s most modern solution for managing keys and metadata. Features include the following: Easy archival and recovery. The new solution archives Oracle wallet files, Java KeyStores, and other credential files in a master repository, supporting fast, easy file sharing and recovery. Centralized management. Oracle Key Vault’s browser-based management console offers point-and-click administration, simplified server enrollment, and audit reports. Streamlined sharing. Organizations can securely share Oracle wallet files—standards-based encrypted files that securely store keys and related metadata used by components of the Oracle stack—across database clusters or disaster recovery environments. The product works seamlessly with Oracle Real Application Clusters, Oracle Active Data Guard, and Oracle GoldenGate. Flexibility. In Oracle Database environments using Oracle Advanced Security with Transparent Data Encryption (TDE), Oracle Key Vault manages TDE keys over a direct network connection as an alternative to a local Oracle wallet. Standards Compliance. Based on the OASIS Key Management Interoperability Protocol (KMIP), Oracle Key Vault can manage keys from KMIP-compliant clients.Supporting Quotes “Oracle Advanced Security with Transparent Data Encryption has played an important role in protecting the sensitive data stored in our Oracle databases. However as the need to encrypt data increases, both within the Oracle Database and beyond, encryption key management becomes a challenge,” said Brad Peiffer, director of IT data management services at Educational Testing Service. “We are looking forward to the new Oracle Key Vault solution that will allow us to centrally manage our Oracle wallet files, encryption keys, and certificates. Oracle Key Vault can simplify operations and help us improve our security posture and regulatory compliance.” “Encryption is no longer optional for managing enterprise data. It has become an essential element of end-to-end data protection,” said Carl Olofson, IDC research vice president, Application Development and Deployment. “As enterprises implement encryption in their middleware, database, and operating systems, key management becomes increasingly complex and difficult. Enterprises need a means of sensibly and securely managing those keys. Oracle has developed Oracle Key Vault to give customers the advantage of a standards-based solution, optimized for the Oracle technology stack, for centralized management of their encryption keys.” “As regulations worldwide increasingly call for more data to be encrypted, organizations need a centralized solution to securely manage all the encryption keys and credential files in their data centers,” said Vipin Samar, vice president, database security product development at Oracle. “Oracle Key Vault is a modern, standards-based product that allows organizations to reduce the overhead of regulatory compliance with a solution that protects Oracle Database encryption master keys, Oracle wallet files, Java KeyStores, and other credential files.” Supporting Resources Oracle Key Vault Oracle Database Security Register for the Oracle Key Vault live webcast on Thursday, August 21, at 10 a.m. PT. Join Oracle live events featuring “Introduction to Oracle Key Vault” in a city near you. Connect with Oracle Database via Blog, Facebook, and Twitter About Oracle

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

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

Teri Whitaker
Oracle
+1.650.506.9914
teri.whitaker@oracle.com

Neil Desai
Blanc & Otus
+1.415.856.5150
ndesai@blancandotus.com

Categories: Database, Vendor