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

Problem Solving, Oracle-Style

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

Some problems can appear to be more difficult than they are.  Read on to see how changing how you think about a problem can open up new ways to solve it.

Categories: Database

MicroOLAP Database Designer meets PostgreSQL 9.4

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

The MicroOLAP team is proud to introduce Database Designer for PostgreSQL with full support for PosgreSQL 9.4, an comprehensive CASE tool with intuitive graphical interface allowing you to

  • build a clear and effective database structure visually,
  • see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects,
  • easily generate a physical database on a server,
  • modify it according to any changes you made to the diagram using fast ALTER statements,
  • import already existing diagram from a server,
  • export diagram to common graphic formats or as SQL script,
  • create detailed printings and reports.
This release introduces support for the latest v9.4 SQL grammar. Among other important features JSONB type support were added. Modify Engine allows creating indexes CONCURRENTLY. Several non critical bugs fixed. Download

You're welcome to download the Database Designer for PostgreSQL 1.10.3 right now at: http://microolap.com/products/database/postgresql-designer/download/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Full changelog:
  • [!] PostgreSQL 9.4 support added
  • [+] Allow creating indexes CONCURRENTLY using Modify script
  • [+] JSONB type support added
  • [*] Primary column removed from Column Manager
  • [*] Support for ENUM types improved in Column Manager
  • [*] uuid[] type added to editors
  • [-] "Quote Default Value option not saved in Column Manager" bug fixed
Categories: Database, Open Source

Oracle Names Jill Puleri as Senior Vice President and General Manager, Oracle Retail

Oracle Database News - Mon, 12/22/2014 - 22:27
Oracle Names Jill Puleri as Senior Vice President and General Manager, Oracle RetailSeasoned Retail Executive to Lead Oracle Retail Global Business UnitRedwood Shores, California – December 22, 2014News Summary

The pace of retail continues to accelerate through an increase of social and digital channels, the explosion of data, and the rise of customer expectations. Today’s retailers are faced with creating differentiated shopping experiences to remain competitive. Oracle is uniquely qualified to help retailers with its combination of integrated solutions. In order to help Oracle continue its leadership in this important sector, Jill Puleri will join as Senior Vice President and General Manager, Oracle Retail.

News Facts Oracle today announced the appointment of Jill Puleri as Senior Vice President and General Manager, Oracle Retail. Puleri will be responsible for leading the Oracle Retail Global Business Unit and report to Mike Webster, Oracle’s Senior Vice President and General Manager, Retail and Hospitality. Having held various leadership positions in sales, marketing and consulting, Puleri brings over 20 years of experience and deep domain expertise in the retail industry, most recently serving as the Worldwide Retail Industry Leader for IBM Global Business Services. Supporting Quotes Retail is committed to deliver high quality, mission-critical solutions to solve our customers' most important business initiatives,” said Mike Webster, Senior Vice President and General Manager, Oracle Retail and Hospitality. “Building the best team – deep in retail expertise – is how we deliver on our commitment. Jill is a proven leader, and her focus on customer success will strengthen our community.” joins Oracle at a pivotal time,” Webster added. “With the combination of Oracle and MICROS, we are well-positioned to offer solutions that will differentiate retailers in today’s competitive retail market. Jill is uniquely qualified to lead our business through this journey with our clients.”Supporting Resources Learn more about Oracle Retail Oracle Retail at the National Retail Federation Annual Conference Oracle Retail on Facebook, Twitter and YouTube Oracle Retail Blog  Oracle Commerce Anywhere BlogAbout 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.

Trademark

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

# # #

Contacts:

Greg Lunsford
Oracle
+1.650.506.6523
greg.lunsford@oracle.com

Mary Ellen Amodeo
Amodeo Associates
+1.612.963.5797
meamodeo@gmail.com

Categories: Database, Vendor

Data Science Perspectives: Q&A with Microsoft Data Scientists Val Fontama and Wee Hyong Tok

You can’t read the tech press without seeing news of exciting advancements or opportunities in data science and advanced analytics. We sat down with two of our own Microsoft Data Scientists to learn more about their role in the field, some of the real-world successes they’ve seen, and get their perspective on today’s opportunities in these evolving areas of data analytics.

If you want to learn more about predictive analytics in the cloud or hear more from Val and Wee Hyong, check out their new book, Predictive Analytics with Microsoft Azure Machine Learning: Build and Deploy Actionable Solutions in Minutes.

First, tell us about your roles at Microsoft?

 [Val] Principal Data Scientist in the Data and Decision Sciences Group (DDSG) at Microsoft

 [Wee Hyong] Senior Program Manager, Azure Data Factory team at Microsoft

 And how did you get here? What’s your background in data science?

[Val] I started in data science over 20 years ago when I did a PhD in Artificial Intelligence. I used Artificial Neural Networks to solve challenging engineering problems, such as the measurement of fluid velocities and heat transfer. After my PhD, I applied data mining in the environmental science and credit industry: I did a year’s post-doctoral fellowship before joining Equifax as a New Technology Consultant in their London office. There, I pioneered the application of data mining to risk assessment and marketing in the consumer credit industry. I hand coded over ten machine learning algorithms, including neural networks, genetic algorithms, and Bayesian belief networks in C++ and applied them to fraud detection, predicting risk of default, and customer segmentation.    

[Wee Hyong] I’ve worked on database systems for over 10 years, from academia to industry.  I joined Microsoft after I completed my PhD in Data Streaming Systems. When I started, I worked on shaping the SSIS server from concept to release in SQL Server 2012. I have been super passionate about data science before joining Microsoft. Prior to joining Microsoft, I wrote code on integrating association rule mining into a relational database management system, which allows users to combine association rule mining queries with SQL queries. I was a SQL Server Most Valuable Professional (MVP), where I was running data mining boot camps for IT professionals in Southeast Asia, and showed how to transform raw data into insights using data mining capabilities in Analysis Services.

What are the common challenges you see with people, companies, or other organizations who are building out their data science skills and practices?

[Val] The first challenge is finding the right talent. Many of the executives we talk to are keen to form their own data science teams but may not know where to start. First, they are not clear what skills to hire – should they hire PhDs in math, statistics, computer science or other? Should the data scientist also have strong programming skills? If so, in what programming languages? What domain knowledge is required? We have learned that data science is a team sport, because it spans so many disciplines including math, statistics, computer science, etc. Hence it is hard to find all the requisite skills in a single person. So you need to hire people with complementary skills across these disciplines to build a complete team.

The next challenge arises once there is a data science team in place – what’s the best way to organize this team? Should the team be centralized or decentralized? Where should it sit relative to the BI team? Should data scientists be part of the BI team or separate? In our experience at Microsoft, we recommend having a hybrid model with a centralized team of data scientists, plus additional data scientists embedded in the business units. Through the embedded data scientists, the team can build good domain knowledge in specific lines of business. In addition, the central team allows them to share knowledge and best practices easily. Our experience also shows that it is better to have the data science team separate from the BI team. The BI team can focus on descriptive and diagnostic analysis, while the data science team focuses on predictive and prescriptive analysis. Together they will span the full continuum of analytics.

The last major challenge I often hear about is the actual practice of deploying models in production. Once a model is built, it takes time and effort to deploy it in production. Today many organizations rewrite the models to run on their production environments. We’ve found success using Azure Machine Learning, as it simplifies this process significantly and allows you to deploy models to run as web services that can be invoked from any device.

[Wee Hyong] I also hear about challenges in identifying tools and resource to help build these data science skills. There are a significant number of online and printed resources that provide a wide spectrum of data science topics – from theoretical foundations for machine learning, to practical applications of machine learning. One of the challenges is trying to navigate amongst the sea of resources, and selecting the right resources that can be used to help them begin.

Another challenge I have seen often is identifying and figuring out the right set of tools that can be used to model the predictive analytics scenario. Once they have figured out the right set of tools to use, it is equally important for people/companies to be able to easily operationalize the predictive analytics solutions that they have built to create new value for their organization.

What is your favorite data science success story?

[Val] My two favorite projects are the predictive analytics projects for ThyssenKrupp and Pier 1 Imports. I’ll speak today about the Pier 1 project. Last spring my team worked with Pier 1 Imports and their partner, MAX451, to improve cross-selling and upselling with predictive analytics. We built models that predict the next logical product category once a customer makes a purchase. Based on Azure Machine Learning, this solution will lead to a much better experience for Pier 1 customers.

[Wee Hyong] One of my favorite data science success story is how OSIsoft collaborated with the Carnegie Mellon University (CMU) Center for Building Performance and Diagnostics to build an end-to-end solution that addresses several predictive analytics scenarios. With predictive analytics, they were able to solve many of their business challenges ranging from predicting energy consumption in different buildings to fault detection. The team was able to effectively operationalize the machine learning models that are built using Azure Machine Learning, which led to better energy utilization in the buildings at CMU.

What advice would you give to developers looking to grow their data science skills?
[Val] I would highly recommend learning multiple subjects: statistics, machine learning, and data visualization. Statistics is a critical skill for data scientists that offers a good grounding in correct data analysis and interpretation. With good statistical skills we learn best practices that help us avoid pitfalls and wrong interpretation of data. This is critical because it is too easy to unwittingly draw the wrong conclusions from data. Statistics provides the tools to avoid this. Machine learning is a critical data science skill that offers great techniques and algorithms for data pre-processing and modeling. And last, data visualization is a very important way to share the results of analysis. A good picture is worth a thousand words – the right chart can help to translate the results of complex modeling into your stakeholder’s language. So it is an important skill for a budding data scientist.

[Wee Hyong] Be obsessed with data, and acquire a good understanding of the problems that can be solved by the different algorithms in the data science toolbox. It is a good exercise to jumpstart by modeling a business problem in your organization where predictive analytics can help to create value. You might not get it right in the first try, but it’s OK. Keep iterating and figuring out how you can improve the quality of the model. Over time, you will see that these early experiences help build up your data science skills.

Besides your own book, what else are you reading to help sharpen your data science skills?

[Val] I am reading the following books:

  • Data Mining and Business Analytics with R by Johannes Ledolter
  • Data Mining: Practical Machine Learning Tools and Techniques, Third Edition (The Morgan Kaufmann Series in Data Management Systems) by Ian H. Witten, Eibe Frank, and Mark A. Hall
  • Predictive Analytics: The Power to Predict Who Will Click, Buy, Lie or Die by Eric Siegel

[Wee Hyong] I am reading the following books:

  • Super Crunchers: Why Thinking-By-Numbers Is the New Way to Be Smart by Ian Ayres
  • Competing on Analytics: The New Science of Winning by Thomas H. Davenport and Jeanne G. Harris.

Any closing thoughts?

[Val]  One of the things we share in the book is that, despite the current hype, data science is not new. In fact, the term data science has been around since 1960. That said, I believe we have many lessons and best practices to learn from other quantitative analytics professions, such as actuarial science. These include the value of peer reviews, the role of domain knowledge, etc. More on this later.

[Wee Hyong] One of the reasons that motivated us to write the book is we wanted to contribute back to the data science community, and have a good, concise data science resource that can help fellow data scientists get started with Azure Machine Learning. We hope you find it helpful. 

Categories: Database

PetRelocation Drives Customer Conversions and Enhances Brand Visibility with Oracle Marketing Cloud

Oracle Database News - Mon, 12/22/2014 - 17:00
PetRelocation Drives Customer Conversions and Enhances Brand Visibility with Oracle Marketing CloudOracle content marketing solution provides worldwide pet service with a single platform for planning, producing, and delivering relevant and engaging content across multiple channelsRedwood Shores, Calif. – December 22, 2014News Summary

To stand out in an increasingly digital world, enterprises need to create a constant stream of valuable content and deliver it to the right person at the right time through the right channel. Faced with this challenge, PetRelocation, a worldwide pet moving service, selected the Content Marketing component of Oracle Marketing Cloud. Since implementing Content Marketing, PetRelocation has been able to use a single platform to plan, produce, and deliver engaging and relevant information across multiple channels throughout the customer lifecycle. The successful program has helped PetRelocation boost customer conversion rates by 150 percent and increase brand visibility—direct benefits from online marketing efforts that now account for 70 percent of the company’s annual revenue. In addition, PetRelocation now ranks in the top three Google search results for more than 360 keywords.

News Facts To increase conversion rates and overall marketing effectiveness, PetRelocation, a worldwide pet moving service, deployed Oracle Marketing Cloud’s Content Marketing solution. As a fast-growing company, PetRelocation needed to replace its poorly structured manual processes with a flexible and scalable content marketing platform that could deliver highly engaging and relevant information to the right audience at the right time. With Oracle Marketing Cloud’s Content Marketing functionality, PetRelocation has been able to effectively attract and mobilize brand advocates by streamlining content generation and easily integrating user-generated content. By quickly and easily integrating user-generated content such as customer success stories and “ask the expert” questions, PetRelocation has been able to amplify its long tail organic search strategy. Oracle Marketing Cloud’s Content Marketing functionality also seamlessly integrated with PetRelocation’s marketing automation solution, ensuring content delivery to customers across multiple channels and at various stages of the customer journey. The new content marketing program has been a huge success. The company has boosted conversion rates by 150 percent and now ranks in the top three Google search results for more than 360 words. More than 70 percent of PetRelocation’s revenue is directly tied to its online marketing efforts, and the company won the “Content Is King” category at the Oracle Marketing Cloud 2014 Markie Awards.Supporting Quote “As a fast-growing, privately owned company, we needed to capture and share useful insights with our customers in a simple and efficient way,” said Rachel Truair, chief of staff, PetRelocation. “Oracle Marketing Cloud’s Content Marketing solution helped us turn customer Q&As and success stories into highly effective marketing content. This has not only helped us enhance the customer experience and streamline processes, but just as importantly, it has enabled us to accelerate conversions, mobilize our brand advocates, and grow revenue.”Supporting Resources Oracle Content Marketing Oracle Marketing Cloud Oracle Modern Marketing Blog Oracle Marketing Cloud Twitter Oracle Marketing Cloud LinkedIn 2014 Markie AwardsAbout 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.

###

Danielle Cormier-Smith
Oracle

+1.610.766.3463
danielle.cormier@oracle.com

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

Categories: Database, Vendor

Oracle Buys Datalogix

Oracle Database News - Mon, 12/22/2014 - 14:05
Oracle Buys DatalogixCreates the World’s Most Valuable Data Cloud to Maximize the Power of Digital MarketingRedwood Shores, Calif. – December 22, 2014
News Facts Oracle today announced that it has signed an agreement to acquire Datalogix, the industry-recognized leader at connecting offline consumer spending to digital marketing that helps marketers increase the effectiveness and measurability of their advertising. Datalogix aggregates and provides insights on over $2 trillion in consumer spending from 1,500 data partners across 110 million households to provide purchase-based targeting and drive more sales. Over 650 customers, including 82 of the top 100 US advertisers such as Ford and Kraft, as well as 7 of the top 8 digital media publishers such as Facebook and Twitter use Datalogix to enhance their media. Oracle and Datalogix’s Data as a Service cloud solutions will provide marketers and publishers with the richest understanding of consumers across both digital and traditional channels based on what they do, what they say, and what they buy. This will enable leading brands to personalize and measure every customer interaction and maximize the value of their digital marketing. The combination fundamentally transforms marketing automation from executing campaigns to being able to correctly identify consumers, target them accurately with digital campaigns, allow marketers to measure which campaigns and channels are effective, and optimize how they reach consumers and spend their campaign resources. The addition of Datalogix represents a further extension of Oracle’s Public Cloud strategy to combine IaaS, PaaS, SaaS and Data as a Service on a common cloud and to transform SaaS business applications and processes by integrating data within these applications. More information can be found at http://www.oracle.com/datalogix.Supporting Quotes “The addition of Datalogix to the Oracle Data Cloud will provide data-driven marketers the most valuable targeting and measurement solution available,” said Omar Tawakol, Group Vice President and General Manager of Oracle Data Cloud. “Oracle will now deliver comprehensive consumer profiles based on connected identities that will power personalization across digital, mobile, offline and TV.” “Datalogix’s mission is to help the leading consumer marketers connect digital media to the offline world, where over 93% of consumer spending occurs,” said Eric Roza, CEO, Datalogix. “We are thrilled to join Oracle and extend the value Oracle Data Cloud brings to marketers and publishers.”Supporting Resources About Oracle and Datalogix General Presentation Customer and Partner Letter FAQAbout 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

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

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

  

Oracle is currently reviewing the existing Datalogix product roadmap and will be providing guidance to customers in accordance with Oracle's standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle's review of Datalogix’s product roadmap are at the sole discretion of Oracle. All product roadmap information, whether communicated by Datalogix or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. It is intended for information purposes only, and may not be incorporated into any contract.

Cautionary Statement Regarding Forward-Looking Statements
This document contains certain forward-looking statements about Oracle and Datalogix, including statements that involve risks and uncertainties concerning Oracle's proposed acquisition of Datalogix, 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 Datalogix, 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 may deteriorate and/or Oracle or Datalogix 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 Datalogix. 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 Datalogix is under any duty to update any of the information in this document.

Categories: Database, Vendor

Importance of Statistics and How It Works in SQL Server – Part 1

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

SQL Server Query Optimizer uses statistical information to estimate the cardinality in a query result. This enables the SQL Server Query Optimizer to create a high-quality query execution plan. Read on to learn how to use statistics and why it’s needed.

Categories: Database

Bucardo 5.3.0 released

PostgreSQL News - Mon, 12/22/2014 - 01:00

Bucardo, a multiple source, multiple target replication system, has released version 5.3.0. The 'makedelta' system has been improved, and allows setting of makedelta at the database level. Bucardo can be downloaded from the Bucardo wiki

Categories: Database, Open Source

Database .NET 14.0 released

PostgreSQL News - Fri, 12/19/2014 - 01:00

I am happy to announce the new major release of Database .NET 14.0, an innovative, powerful and intuitive multiple database management tool, With it you can Browse objects, Design tables, Edit rows, Export data and Run queries with a consistent interface.

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

Major New features from version 12.7 to 14.0:

  • Compatible with PostgreSQL 9.4
  • Compatible with Microsoft Windows 10
  • Updated to Npgsql.dll 2.2.3
  • Additional Features for all users (Autocomplete/Query Builder/SQL Profiler/Database Diagram/Cell and Form Editor)
  • Added Binding Procedure and Function parameters
  • Added Binding SQL variables
  • Added (De)Compression and (De)Encoding strings
  • Added [ADV] Advanced Browsing Options
  • Added [ADV] Advanced Edit Options
  • Added [ADV] Advanced Search Options
  • Added Column Properties
  • Added Exporting and Displaying Hexadecimal string
  • Added Restoring last object location
  • And more...
The new version is immediately available for download.
Categories: Database, Open Source

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

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

 

About Oracle

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

Valerie Beaudett
Oracle
+1.650.400.7833
Valerie.beaudett@oracle.com

Mary Tobin
O’Keeffe & Company
+1.503.658.7396

mtobin@okco.com

Categories: Database, Vendor

IBM Datacap 9.0 DDK custom actions

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

IBM Datacap 9.0 DDK Datacap Desktop Custom Panels

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

IBM Datacap 9.0 DDK sample applications

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

PostgreSQL 9.4 Increases Flexibility, Scalability and Performance

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

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

Flexibility

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

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

Scalability

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

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

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

Performance

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

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

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

Links About PostgreSQL

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

Categories: Database, Open Source

SAAS, PAAS AND IAAS CLOUD REVENUE UP 45% to $516 MILLION

Oracle Database News - Wed, 12/17/2014 - 22:30
SAAS, PAAS AND IAAS CLOUD REVENUE UP 45% to $516 MILLIONSOFTWARE AND CLOUD REVENUE UP 5% TO $7.3 BILLIONREDWOOD SHORES, Calif. – December 17, 2014

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

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

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

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

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

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

Q2 Fiscal 2015 Earnings Conference Call and Webcast

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

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


About Oracle

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE: ORCL), visit www.oracle.com or contact Investor Relations at investor_us@oracle.com or (650) 506-4073.

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

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

Contact Info

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

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

Categories: Database, Vendor

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

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

Aerocrine improves asthma care with near-real-time data

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

Virginia Tech advances DNA sequencing with cloud big data solution

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

The Grameen Foundation expands global humanitarian efforts with cloud BI

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

Ascribe transforms healthcare with faster access to information

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

Learn more about Microsoft’s big data solutions

Categories: Database

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

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

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

The AU3 release includes:

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

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

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

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

CREATE EXTERNAL TABLE [dbo].[WebLogs]
(
	[Date] DATETIME NULL,
	[Uri] NVARCHAR(256) NULL,
	[Server] NVARCHAR(256) NULL,
	[Referrer] NVARCHAR(256) NULL
)
WITH
(
	LOCATION='//Logs/',
	DATA_SOURCE = Azure_DS,
	FILE_FORMAT = LogFileFormat,
	REJECT_TYPE = VALUE,
	REJECT_VALUE = 100
);

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

SELECT TOP 5
	*
FROM
	[dbo].[WebLogs]
ORDER BY
	[Date]

The results are:

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

Integrated Data Management Gateway

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

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

TSQL Compatibility improvements

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

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

Replatformed to Windows Server 2012 R2 and SQL Server 2014

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

APS on the Web

To learn more about the Microsoft Analytics Platform System, please visit us on the web at http://www.microsoft.com/aps

Categories: Database

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

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

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

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

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

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

Categories: Database

Oracle Communications WebRTC Session Controller Extends WebRTC Functionality to Mobile Applications

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

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

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

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

Trademark

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

Contacts:

Kaitlin McCready
Oracle
+1.216.925.5972
kaitlin.mccready@oracle.com

Janice Clayton
O’Keeffe
+1.443.759.8151
jclayton@okco.com

Categories: Database, Vendor

Introduction to IBM Datacap Taskmaster Capture 8.1 Development Kit

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