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

Oracle Validated Integration Partners Offer Healthcare Organizations Fast Time to Value

Oracle Database News - Wed, 02/25/2015 - 13:00
Oracle Validated Integration Partners Offer Healthcare Organizations Fast Time to ValueInnovative, prebuilt offerings available for Oracle enterprise healthcare analytics solutions

Redwood Shores, Calif. – February 25, 2015 - Healthcare organizations are increasingly focused on streamlining data to meet a multitude of challenges, from regulatory compliance and reimbursement management to delivering quality care to their patients across the care continuum. Oracle today announced it has expanded its Oracle Validated Integration program to include the Oracle Healthcare platform, starting with Oracle Enterprise Healthcare Analytics. This expansion of the Oracle Validated Integration program will help healthcare organizations identify innovative healthcare analytic applications more quickly and subsequently deploy these partner solutions with less risk so they can focus on their core objective—improving patient care.

Oracle Validated Integration, available through Oracle PartnerNetwork (OPN), provides partners with a path for building and promoting repeatable integrations with solutions that complement and extend Oracle Applications. Healthcare organizations will be able to use preintegrated partner solutions with Oracle Health Sciences Enterprise Healthcare Analytics to help reduce deployment risk, accelerate time to value for critical decision making, and drive operational and financial improvements with exceptional patient outcomes and experience. Using Oracle Enterprise Healthcare Analytics, a leading healthcare enterprise-class data management platform, healthcare providers can enhance data transparency and obtain insights that allow them to improve patient safety, care quality, cost efficiency, and overall enterprise performance.

“Partners achieving Oracle Validated Integration with Oracle Healthcare can help healthcare organizations deploy critical healthcare analytics solutions more quickly and with less risk—ultimately accelerating programs that improve organizational efficiency and enhance patient care,” said Steve Rosenberg, senior vice president and general manager, Oracle Health Sciences.

Oracle PartnerNetwork members Edgewater Ranzal, Grant Thornton, MedeAnalytics, and Perficient are among the initial partners participating in Oracle Validated Integration with Oracle Enterprise Healthcare Analytics. Perficient, Grant Thornton, and Edgewater Ranzal are delivering advanced healthcare cost accounting solutions preintegrated with Oracle Enterprise Healthcare Analytics. MedeAnalytics is delivering its Revenue Cycle solution with Oracle Enterprise Healthcare Analytics.

“Perficient is excited to be a plank owner in the Oracle Hyperion and Oracle Enterprise Healthcare Analytics integration effort. Our High-Performance Costing Expressway is the intersection of cost and quality of patient care,” said Emil Fernandez, vice president, Oracle National Business Unit, Perficient.

“Faced with new payment models and increased competition in the marketplace, large and small healthcare providers benefit from detailed insight into the costs associated with the care they deliver,” said Carl Yost, principal, Grant Thornton. “Grant Thornton’s Healthcare Costing Informatics (RxCI) solution, preintegrated with Oracle Enterprise Healthcare Analytics, allows healthcare providers to achieve actionable analytics quickly and in alignment with industry best practices. That insight allows them to make informed decisions that can increase their quality of care and positively impact operating results.”

“Edgewater Ranzal has chosen to preintegrate our Ranzal Healthcare Analytics (RHA) Costing solution with Oracle Enterprise Healthcare Analytics to provide healthcare providers advanced patient analytics,” said Mark Hite, healthcare practice director, Edgewater Ranzal. “The solution delivers the information necessary to support advanced costing down to the encounter level, including detailed attribution.”

“The combined solution of with Mede/Revenue Cycle provides customers with a single, integrated view of their organization’s financial data—enabling increased cash collections, reduction in bad debt, enhanced productivity, and actionable insight on enterprise business strategy,” said Melissa Ross, vice president of business development, MedeAnalytics.

With these preintegrated offerings, healthcare organizations can quickly deploy and derive value from a broad set of analytics applications that can help extend the Oracle Healthcare platform.

Additional Information

Join the Oracle Health Sciences community on Facebook and follow @OracleHealthSci on Twitter.

About Oracle Validated Integration

Oracle Validated Integration, available through the Oracle PartnerNetwork (OPN), gives customers confidence that the integration of complementary partner software products with Oracle Applications and specific Oracle Fusion Middleware solutions have been validated, and the products work together as designed. This can help customers reduce risk, improve system implementation cycles, and provide for smoother upgrades and simpler maintenance. Oracle Validated Integration applies a rigorous technical process to review partner integrations. Partners who have successfully completed the program are authorized to use the Oracle Validated Integration logo. For more information, please visit Oracle.com at oracle.com/us/partnerships/solutions/index.html.

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.

Trademarks

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

Contact Info

Samantha Thai
Oracle
+1.510.917.5564
samantha.thai@oracle.com

Mary Tobin
O’Keeffe & Company
+1.503.658.7396
mtobin@okco.com

Categories: Database, Vendor

My Oracle Cup Overflows

Database Journal News - Mon, 02/23/2015 - 09:01

Overflow data in an index-organized table is usually put in its own tablespace.  Sometimes it isn't; read on to see what overflow data is and how to change where it's located.

Categories: Database

Oracle Advances Vision for Enterprise Big Data

Oracle Database News - Thu, 02/19/2015 - 17:00
Press Release Oracle Advances Vision for Enterprise Big Data New technologies help integrate big data with enterprise computing, making big data insights a reality

Strata + Hadoop World, San Jose, Calif.—Feb 19, 2015

Oracle Big Data Discovery

Oracle Big Data Discovery offers tremendous speed at massive scale, streamlining Big Data analytics to unlock new value for everyone.

Oracle today unveiled new big data solutions that simplify information access and discovery, enabling customers to quickly turn data into business value. New offerings include Oracle Big Data Discovery, Oracle GoldenGate for Big Data, Oracle Big Data SQL 1.1 and Oracle NoSQL Database 3.2.5. These additions further Oracle's vision to enable Hadoop, NoSQL, and SQL technologies to work together and be deployed securely in any model—whether public cloud, private cloud or an on-premises infrastructure.

Generating value from big data requires the right tools to move and store data to effectively discover new insights. In order to operationalize those insights, new data must integrate securely with existing data, infrastructure, applications and processes. These Oracle solutions work seamlessly together to help companies exploit enterprise big data faster, at lower cost, and with less risk. They allow customers to securely reach across Hadoop, NoSQL and relational databases to easily and cost-effectively analyze massive and diverse data sets.

"One type of technology will no longer suffice in supporting all the analytics use cases. At the same time, data management and analysis as a series of unrelated projects results in an unmanageable IT quagmire and unnecessary risks," said Dan Vesset, vice president of Business Analytics Research, IDC. "IDC predicts that by 2017 unified data platform architecture will become the foundation of enterprise-wide big data and analytics strategy. The unification will occur across information management, analysis and search technology."

Oracle GoldenGate

Oracle GoldenGate for Big Data offers an extensible solution to support all major big data systems.

"Data is a new kind of capital and enterprises must invest their data capital strategically to create the best return," said Neil Mendelson, vice president of big data at Oracle. "Oracle gives customers an integrated platform that helps simplify access to all their data, discover new insights, predict outcomes in real time, and keep all their data governed and secure."

Oracle's new big data offerings are also designed to run seamlessly on the recently announced Oracle Big Data Appliance X5 and Oracle Exadata Database Machine X5. Together, these solutions deliver a complete, cost-effective platform to accessing, discovering, governing and securing big data.

Today's new big data innovations include:

  • Oracle Big Data Discovery, the "visual face of Hadoop" and an end-to-end product for finding, exploring, transforming, discovering and sharing big data insights. Big data assets become more accessible to a greater number of business analysts across the organization and help reduce risks and improve time to value for big data projects.
  • Oracle GoldenGate for Big Data, a Hadoop-based technology that allows customers to stream real-time data from heterogeneous transactional systems into big data systems, including targets such as Apache Hadoop, Apache Hive, Apache HBase and Apache Flume. It allows customers to enhance big data analytics initiatives by incorporating existing real-time architectures into big data solutions, while ensuring their big data reservoirs are up to date with production systems.
  • Oracle Big Data SQL 1.1, a technology that extends Oracle SQL to Hadoop and NoSQL, with all the security of the Oracle Database. It enables a single fast query, written in Oracle SQL, to transparently access data in Hadoop, NoSQL and Oracle Database. Oracle Big Data SQL 1.1 provides tighter integration between Hadoop and Oracle Database, while increasing query performance by up to 40 percent from previous versions.
  • Oracle NoSQL Database 3.2.5, an adaptable solution that allows developers to build high performance, next generation applications. The latest release provides predictable low latency, a RESTful API, and a Thrift-based C API, and is integrated with the Oracle Big Data platform. Building on Oracle Big Data SQL, Oracle NoSQL Database 3.2.5 also supports data definition language (DDL), making it even easier to use SQL to query NoSQL data.
Oracle Big Data Discovery Now Generally Available

Oracle Big Data Discovery leverages the power of Hadoop so that users can quickly and easily turn raw data into actionable business insight with a single product.

  • Find and explore big data as easily as shopping online: Oracle Big Data Discovery provides a compelling visual interface for finding and exploring raw data in Hadoop. It acts as a scratch pad for uncovering statistical correlations between data attributes and combinations to evaluate whether a data set has potential and is worthy of further investigation and resources. Users browse an interactive visual data catalog through familiar guided navigation and powerful search capabilities.
  • Transform and enrich data at scale: Raw data in Hadoop needs preparation before it's ready for analytics. Oracle Big Data Discovery reduces lengthy prep cycles and streamlines data wrangling through an intuitive and spreadsheet-like experience. Users can enhance data visually, without switching tools or writing code so that more time can be spent on analytics.
  • Discover and share to find new value: Discovery and analysis require different tools than those used for data preparation. Oracle Big Data Discovery enables users to seamlessly move from preparation to analysis, and share insights with a click. Users can collaborate on results, publish original data sets back to Hadoop, and leverage results in other tools such as Pig, Hive, and Python.
  • Unlock big data access for a wider group: Big data is usually in the hands of a few data scientists who are highly skilled, expensive and hard to find. Oracle Big Data Discovery makes big data simpler to manage and more accessible to a larger group, including analytics teams and business users. It also integrates with existing big data tools, making it easy for organizations to expand their big data teams to get the most from their human capital and data assets.
Contact Info Marcie Bradley
Oracle
+1.530.214.8068
marcie.bradley@oracle.com Seema Kalra
Oracle
+1.650.506.2925
seema.kalra@oracle.com 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 http://www.oracle.com.

Trademarks

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

Safe Harbor

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

Learn More Oracle Big Data Talk to a Press Contact

Marcie Bradley

  • +1.530.214.8068

Seema Kalra

  • +1.650.506.2925

Follow

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Launches Oracle Hospitality

Oracle Database News - Thu, 02/19/2015 - 14:02
Oracle Launches Oracle Hospitality Dedicated global business unit offers customers unparalleled expertise, scale, and innovation focused exclusively on the hospitality industry REDWOOD SHORES, CA. – February 19, 2015News Summary

Oracle, building on the strong foundation MICROS established serving the hotel and food and beverage industries, has launched Oracle Hospitality Global Business Unit to accelerate development of innovative cloud, mobile, and guest experience technology. With hundreds of thousands of systems already deployed in hotels, restaurants, cruise operations, and other venues on all seven continents, Oracle Hospitality extends MICROS’ commitment to providing fast, reliable service and solutions to customers both large and small.

News Facts The launch of Oracle Hospitality combines the deep domain expertise of MICROS, acquired by Oracle in 2014, with the power of Oracle’s scale and innovation, to help customers succeed in an environment that has been fundamentally changed by the rise of social, mobile, and cloud technologies. Oracle’s platform for the hospitality industry offers comprehensive and integrated software, modern cloud offerings, and hardware solutions for hotels, casinos, table and quick-service restaurants, sports and entertainment venues, and cruise operations from small independents to large global chains. Leveraging Oracle’s integrated technology stack and cloud portfolio, Oracle Hospitality brings unmatched technical breadth, depth, and scale combined with significant R&D and dedicated resources focused exclusively on serving the needs of the hospitality industry by helping them: Exceed guest expectations. Guests now expect the delivery of personalized experiences through the entire guest journey, both on and off property. By offering comprehensive, integrated systems that serve guests during every interaction, businesses can inspire loyalty, surpass guest expectations, and remain competitive in a rapidly evolving industry. Realize faster time to cloud. Oracle Hospitality’s comprehensive, scalable, and globally deployable cloud solutions enable the hospitality sector to accelerate its move to the cloud in response to fast-changing guest expectations. By eliminating the cost and complexity of managing on-premises applications, hospitality organizations can focus on their guests and their business, delivering a consistent experience across venues. Leverage mobile innovation. Mobile is a catalyst behind the radical changes and guest expectations in the hospitality industry. Oracle Hospitality delivers fully integrated mobile solutions that enable staff to conduct transactions and have informed engagement with guests anywhere onsite, not just from behind a counter. Simplify their IT architecture. Comprehensive integrated solutions take advantage of Oracle’s proven technology to help drive greater business benefits, speed time to value, and reduce total cost of ownership.Supporting Quotes “The launch of Oracle Hospitality builds on Oracle’s industries strategy of creating dedicated global business units that help our customers solve their most important business challenges, with a combination of best-of-breed technology and extensive industry-specific expertise and experience,” said Bob Weiler, executive vice president, Global Business Units, Oracle. “Oracle Hospitality delivers solutions that allow our hospitality customers to compete more effectively in a business landscape that has been wholly reshaped by disruptive technologies.” “By combining these two great brands we’re creating a portfolio that has never before been seen in the hospitality industry,” said Mike Webster, senior vice president and general manager, Oracle Retail and Hospitality. “We have assembled a strong team of industry veterans that wake up every day and focus on one thing and one thing only—how do we help our hospitality customers succeed in providing their guests a great experience.” Supporting Resources Oracle Hospitality Solutions Oracle Hospitality on Twitter Oracle Hospitality on Facebook Oracle Hospitality Blog Oracle Hospitality at Oracle Industry Connect: March 25 and 26, Washington DCAbout 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:

Katie Barron
Oracle
+1.202.904.1138
mailto:katie.barron@oracle.com

Angela Seutter

Amodeo Associates
+1.612.280.1493
mailto:seutter.angela@gmail.com

Categories: Database, Vendor

Getting Starting with Database Engine Tuning Advisor in SQL Server – Part 1

Database Journal News - Thu, 02/19/2015 - 09:01

There are different techniques to optimize the performance of SQL Server queries but wouldn’t it be great if we had some recommendations before we started planning or optimizing queries so that we didn’t have to start from the scratch every time? This is where you can use the Database Engine Tuning Advisor utility to get recommendations based on your workload.

Categories: Database

Microsoft Releases Azure HDInsight on Linux and Machine Learning GA at Strata Conference

Today at Strata + Hadoop World, Microsoft is announcing the public preview of Azure HDInsight running on Linux, the general availability of Storm on HDInsight, the general availability of Azure Machine Learning, and the availability of Informatica technology on Azure. These new services are part of our continued investment in a broad portfolio of solutions to unlock insights from data.

Head over to the announcement blogs to read more about these exciting developments:

Categories: Database

New Oracle and Forbes Insights Study Shows Companies Moving Toward Modern Customer Service

Oracle Database News - Wed, 02/18/2015 - 15:00
New Oracle and Forbes Insights Study Shows Companies Moving Toward Modern Customer Service Investments grow despite organizational barriers to adopting modern customer service strategy and best practices

Redwood Shores, Calif. – February 18, 2015 – Oracle today announced the results of a Forbes Insights study that examined the adoption of modern customer service best practices. Commissioned by Oracle, the study “Modern Customer Service: Are You Outpacing Your Executive Peers?” surveyed 415 customer service executives, from organizations representing 10 different industries. The study shows that while companies are investing in new technologies to realize the business benefits of modern customer service best practices, the majority of organizations (62 percent) still fail to grasp the full importance and impact customer service can have when it is an organization-wide strategic goal.

And although 88 percent of respondents believe they are making significant progress delivering modern customer service, the study identified a number of barriers that are preventing companies from leveraging customer service as a true organizational strategy, including limited definitions of customer service, poor knowledge management and customer visibility, and a reliance on traditional channels and metrics.

Despite the barriers to adopting customer service as an organizational strategy, companies are realizing the importance of investing in modern customer service technologies to deliver the best customer experiences when, where, and how customers want it. Popular areas slated for investment in 2015 include additional online customer service capabilities (55 percent), self-service technology (47 percent), mobile apps (52 percent), social media (43 percent) and knowledge management systems (51 percent).

“Consumers today are engaged and empowered like never before and want to get answers to their questions anytime, anywhere, and on any device,” said David Vap, group vice president, Oracle Applications. “The jump from good to excellent customer service is a fairly big one and involves consistent, personalized customer service in every interaction, across every channel. But it can have a huge business impact by helping organizations increase sales, strengthen relationships, and reduce costs.”

“Brands realize that customer service is a great opportunity, especially in this omni-channel environment, to begin a dialogue with consumers and to engage and interact with them in creative ways” said Frank Pettinato, senior vice president and general manager of Consumer Connexions, Telerx. “In the world of social media, we see two-way communication and, candidly, millennials are expecting that.”

Summary of Key Findings: Modern customer service is not yet considered a high-priority strategic goal: The study showed that the majority of organizations are not fully embracing a modern customer service mindset, with only 38 percent of respondents viewing modern customer service as a companywide priority. The role of customer service is still largely misunderstood: Many organizations still narrowly define customer service as a post-purchase function, with executives often not viewing customer service as a key agent for increasing sales (60 percent), retaining existing customers (47 percent), or enhancing their brand and marketing message (85 percent). Organizations are more comfortable with traditional customer service channels and traditional measures of success: Respondents indicated that they have a number of concerns about new customer service channels, including integrating them with existing systems (44 percent), cost (43 percent), implementation (39 percent), and technological limitations such as lack of support (36 percent). When evaluating customer service initiatives, respondents indicated there was a relatively low use of new measurement tools such as net promoter score (22 percent) and customer effort score (37 percent). Customer understanding is becoming a customer service priority: While only 35 percent of organizations surveyed currently leverage knowledge management systems, 51 percent plan to invest in knowledge management technology in the future, indicating they recognize its importance in delivering what the customer wants—consistent answers, delivered seamlessly. 2015 will be a year of modern customer service investment: Organizations plan to significantly increase investments in online customer service (55 percent), self-service technology (47 percent), social media (43 percent) and mobile apps (52 percent) as they strive to deliver a seamless omni-channel experience.

“Customer service is paramount to our organization because we are a monthly recurring revenue business,” said Denise Connors, vice president customer service, at Trupanion. “We know that to be successful we have to retain our customers. Our whole approach is around having a highly engaged customer base and keeping them happy.”

Oracle and Forbes Insights defined “modern customer service” as going beyond standardizing services across channels to achieve personalized customer engagement at every touchpoint.

Supporting Resources: Modern Customer Service: Are You Outpacing Your Executive Peers? Oracle Customer Experience Blog Oracle Service Cloud Oracle CRM Forbes Insights

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.

Trademarks

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

###

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

Data. Insights. Action. Listen. A TechNet Radio Discussion about the Upcoming PASS BA Conference

The PASS Business Analytics Conference 2015 is right around the corner!  Listen to some of our favorite Data and BI experts chat about this year’s event, April 20th – 22nd in Santa Clara, California.

Are you a key part of a team delivering business analytics and intelligence for your organization?   Are you finding BA/BI more a part of your day-today work life?  Find out why anyone trying to stay ahead of the analytics curve and position your data career for success should attend PASS Business Analytics Conference. 

Tune in to TechNet Radio to find out about the 60+ how-to sessions, practical case studies with hands-on workshops and expert panels. This is a can’t miss event!

Categories: Database

Another Look at Tuning Big Data Queries

Database Journal News - Mon, 02/16/2015 - 09:01

Most large organizations have implemented one or more big data applications. As more data accumulates internal users and analysts execute more reports and forecasts, which leads to additional queries and analysis, and more reporting. The cycle continues: data growth leads to better analysis, which generates more reporting. Eventually the big data application swells with so much data and querying that performance suffers. How to avoid this?

Categories: Database

Build a cloud storage application

IBM - DB2 and Informix Articles - Fri, 02/13/2015 - 06:00
Learn how to create a simple Node.js application that uses the IBM Object Storage service for Bluemix. The application shows how to obtain access tokens for a user, create a folder, and upload a document. In the application code, you also find code blocks to handle requests such as list folders of a user, list documents in a folder, delete a document, and other requests. Using what you learn in this tutorial, you can quickly and easily develop great applications using Object Storage.
Categories: Database

Oracle: MERGE 'Monkey-business'

Database Journal News - Thu, 02/12/2015 - 09:01

Odd errors can result in odd 'solutions', and Oracle has one for the MERGE statement.  Read on to see what it is and what it fixes.

Categories: Database

Automated Backup & Automated Patching Best Practices

We recently released the Automated Backup and Automated Patching features. These features automate the processes of backing up and patching your SQL Virtual Machine to provide an added level of convenience for your VMs. We’d like to outline some best practices for these features to ensure that you get the most out of these features.

Automated Backup Backup of Encryption Certificates and Data

When backup encryption is enabled, we strongly recommend that you ascertain whether the encryption certificate has been successfully created and uploaded to ensure restorability of your databases. You can do so by creating a database right away and checking the encryption certificates and data were backed up to the newly created container properly. This will show that everything was configured correctly and no anomalies took place.

If the certificate failed to upload for some reason, you can use the certificate manager to export the certificate and save it. You do not want to save it on the same VM, however, as this does not ensure you have access to the certificate when the VM is down. To know if the certificate was backed up properly after changing or creating the Automated Backup configuration, you can check the event logs in the VM (Figure 1), and if it failed you will see this error message:

Figure 1: Error Message Shown in Event Log in VM

If the certificates were backed up correctly, you will see this message in the Event Logs:

Figure 2: Successful Backup of Encryption Certificate in Event Logs

As a general practice, it is recommended to check on the health of your backups from time to time. In order to be able to restore your backups, you should do the following:

  1. Confirm that your encryption certificates have been backed up and you remember your password. If you do not do this, you will not be able to decrypt and restore your backups. If for some reason your certificates were not properly backed up, you can accomplish this manually by executing the following T-SQL query:

    BACKUP MASTER KEY TO FILE = <file_path> ENCRYPTION BY PASSWORD = <password>
    BACKUP CERTIFICATE [AutoBackup_Certificate] TO FILE = <file_path> WITH PRIVATE KEY (FILE = <file_path>, ENCRYPTION BY PASSWORD = <password>)

  2. Confirm that your backup files are uploaded with at least 1 full backup. Because mistakes happen, you should be sure you always have at least one full backup before deleting your VM, or in case your VM gets corrupted, so you know you can still access your data. You should make sure the backup in storage is safe and recoverable before deleting your VM’s data disks.
Disaster Recovery

It is recommended that you select a storage account in a different region for your backups to provide Disaster Recovery for your data. Putting your backups in another region is critical for scenarios when a datacenter goes down and you need uninterrupted access to your data. However, if you have more interest in a short recovery time, rather than disaster recovery, then it may be better to store your backups in the same region. This decision depends on your specific requirements.

Encryption Password

Be sure to use a strong password to protect your certificates. Have some method of ensuring that you remember the password when the time comes to decrypt and restore your backup.

 

Automated Patching Schedule

Be sure to schedule the Patching window during a time with low workload, but when the VM is still active. If you schedule during a window where the VM will be down, patching will not take place.

Windows Update compatibility boundaries

If you would like to manually install a specific update that you see in the Windows Update UI, you can do this with no interference to Automated Patching. However, keep in mind that turning Windows Update into automatic install mode will cause Automated Patching to be disabled. Despite this, all settings will persist, and you should manually re-enable Automated Patching to continue using it.

Azure only

Both Automated Backup and Automated Patching heavily rely on Azure VM Agent infrastructure. This means that there is no support for on-premises solution. If you plan to move your VM from Azure to any other environment, plan on uninstalling both SQL Server IaaS Agent and Azure VM Agent.

 

Try these features out for yourself at https://portal.azure.com.

If you haven’t already, start a free trial on SQL Server in Virtual Machines today.

Categories: Database

Join us at the PASS Business Analytics Conference this Year and Explore What’s New in Data Analysis

 Guest post by
Kasper de Jonge, Senior PM
Microsoft

It’s that exciting time of the year again, spring is in the air and conference season is starting up again. Usually one of the first conferences that I am really excited about is the PASS Business Analytics Conference. The PASS BAC is a great place where I love to go and meet peers in the field of data analytics and spend days talking about all the nerdy things that excite us from PivotTables to XIRR, DAX calculations and Tree maps. 

This year I am really excited and happy to talk about some great additions to the new Power BI designer (go here and try it out if you haven’t) and talk about what great features we are adding there around data modelling and analytics. In this demo packed session we will take a look at how the new Power BI designer can solve complex business problems with ease. This session will explore new functionality in the Power BI designer around complex relationships between tables and additions to the DAX language to support new types of business logic. I’ll be mainly demo's using real world examples to highlight these new features.

Check out the full session details here.

Looking forward to seeing you there!

Want to learn more about Microsoft business intelligence offerings? Check out the details here

Categories: Database

Oracle Communications Network Service Orchestration Solution Helps Communications Service Providers Accelerate and Optimize Service Deployments in Virtualized Network Environments

Oracle Database News - Tue, 02/10/2015 - 14:00
Oracle Communications Network Service Orchestration Solution Helps Communications Service Providers Accelerate and Optimize Service Deployments in Virtualized Network EnvironmentsNew solution supports service providers in their evolution toward network function virtualization with flexible hybrid network management and elastic scalabilityREDWOOD SHORES, Calif. – Feb. 10, 2015

Oracle today introduced the new Oracle Communications Network Service Orchestration Solution, which is designed to enable communications service providers (CSPs) to more quickly create new network services to respond to market demand. The solution can also help CSPs reduce service development and management costs as they introduce virtualized network capabilities—the beginning of a transformation to network function virtualization (NFV) that will simplify their networks and minimize dependence on expensive, inflexible proprietary hardware.


The solution is part of the Oracle Communications intelligent orchestration framework, a holistic approach that guides CSPs as they adopt NFV technology and helps them to maximize its benefits. Specifically, the framework gathers and analyzes network performance information, evaluates the network’s operation against predefined policies and business rules, and can trigger the appropriate action to automatically modify the behavior of services, network functions, and virtualized infrastructure.


“While network virtualization promises to streamline operations in the long run, the short-term effect actually may be an increase in complexity when configuring and managing hybrid networks. This will require sophisticated orchestration of network services, network functions, and underlying infrastructure enriched by analytics and triggered by policy rules. Such a holistic approach to orchestration, like the one outlined by Oracle, is critical for CSPs to deliver the anticipated business benefits from their NFV investments,” said Dimitris Mavrakis, principal analyst, Ovum.


Oracle Communications Network Service Orchestration Solution gives CSPs the ability to rapidly deploy and scale network services on demand across multiple virtual network functions (VNFs) in complex virtualized and hybrid network environments. CSPs can use this solution to:

Quickly respond to changes in service or market demand Compose and on-board new network service templates and associated business rules using a flexible, graphical design environment, and then validate that these network services are operational and manage how they are scaled Choose and control the selection of solution components in multivendor environments. The solution leverages open standards including RESTful (web service) application programming interfaces (APIs) for integration with other management and orchestration components, such as the previously released Oracle Communications Application Orchestrator or third-party VNF managers and virtualized infrastructure managers Seamlessly introduce virtual network infrastructure and then manage this infrastructure and network service fulfillment when deployed as an extension of Oracle Communications’ leading operations support systems (OSS) portfolio

“CSPs are taking the first steps toward network virtualization—something they know they must do to compete for the long-term. This is a journey, not just a moment in time, which is why we have outlined an end-to-end intelligent orchestration framework. Our approach will provide CSPs with the business and service agility required to make progress toward full NFV. With our new Oracle Communications Network Service Orchestration solution, we are continuing to deliver on our vision for NFV,” said Barry Hill, global head of NFV, Oracle Communications.


“NFV is complex, and CSPs have made it clear that to be successful, they need comprehensive orchestration. The new Oracle Communications Network Service Orchestration solution is a direct response to this need. It allows for dynamic network operation, enabling the transformation of the business—not just the network. With these developments and an expanding portfolio of virtualized network functions, endorsement of Open Stack, leading OSS solutions, and strong IT heritage, Oracle Communications is enabling service providers to fully embrace the NFV opportunity,” said Liam Maxwell, vice president of products, Oracle Communications.


Oracle Communications Network Service Orchestration Solution fulfills and extends the role of the NFV Orchestrator as defined by the European Telecommunications Standards Institute (ETSI) NFV Industry Standards Group, the primary standards body guiding NFV development. Because it has a semantic understanding of each network service, the Oracle Communications solution can calculate and apply configuration changes, including updates to the network topology or service context data—critical for orchestrating network services through their full lifecycle.


Oracle will showcase this solution as part of the “Intelligent NFV Management and Orchestration Solution” demonstration in Hall 3, Stand 3B20 at Mobile World Congress in Barcelona, March 2 – 5, 2015.


Additional Information

To learn more about Oracle Communications Network Service Orchestration Solution and other Oracle Communications solutions, please connect on Twitter @OracleComms and at Facebook.com/OracleCommunications.

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

Guarding Your Data against Cyber Attacks

Database Journal News - Mon, 02/09/2015 - 09:01

In this new era of heightened stakes comes an increased need for a comprehensive security strategy. Rob Gravelle takes a look at how cyber-threats have evolved and what you can do to thwart attackers.

Categories: Database

Actian and Attivio OEM Agreement Accelerates Big Data Business Value by Integrating Big Content

Actian Corporation (Ingres) Press Releases - Wed, 11/13/2013 - 14:03
Attivio AIE® integration into the Actian ParAccel Big Data Analytics Platform delivers unmatched performance and insights at fraction of big stack vendor cost

Newton, MA and Redwood City, CA – November 13, 2013 — Attivio, creator of the award-winning Active Intelligence Engine (AIE®) and Actian, a leader in next-generation big data analytics, today announced a strategic OEM agreement. The agreement gives Actian customers the power to integrate and correlate human-generated, unstructured content sources with their structured data analytics to dramatically increase the return on their information assets.

Actian’s ParAccel Big Data Analytics Platform accelerates analytic performance and enables rapid deployment of highly targeted analytics for critical initiatives including customer segmentation, fraud prevention, risk avoidance and digital marketing optimization. The addition of Attivio AIE’s ability to include Big Content sources – social media, blog posts, email, research documents, SEC filings, insurance reports, legal depositions, open-ended survey responses and more – completes the Big Data analytics picture to greatly improve its impact and value.

With its patented query-time JOIN technology, Attivio AIE delivers unrivaled access to information from internal and external human-created information, so customers can integrate, correlate, access and analyze all of their assets, regardless of format. As a result, business users gain new, real-time business insights that help build revenue, cut costs, increase competitiveness and manage risk — insights that might otherwise go undiscovered.

“Big Content has become a vital piece in the Big Data puzzle,” said David Schubmehl, Research Director, IDC. “The majority of enterprise information created today is human-generated, but legacy systems have traditionally required processing structured data and unstructured content separately. The addition of Attivio AIE to Actian ParAccel provides an extremely cost-effective option that delivers impressive performance and value.”

“Through this alliance with Attivio, our customers now have access to all internal and external sources of unstructured content, solidifying our leadership position in the Big Data space,” said Fred Gallagher, VP Strategic Business for Actian. “With Attivio, we are giving customers more options and making this technology accessible to companies who recognize the value of innovation that is simply not available from legacy big stack vendors who typically impose expensive, long-term contracts, inflexible technology and long deployment times.” “Actian ParAccel delivers high-performance analytics on massive amounts of data,” said Sid Probstein, CTO at Attivio. “Being able to access and analyze outside sources from social media to any and all types of human-created content provides a complete and detailed view of customers and their requirements. It advances the entire field of BI and analytics.”

For more information about the Actian alliance and the Attivio Partner Network, please contact partners@attivio.com.

About Attivio

Attivio’s unified information access platform, the Active Intelligence Engine® (AIE®), redefines the business impact of our customers’ information assets, so they can quickly seize opportunities, solve critical challenges and fulfill their strategic vision.

Attivio integrates and correlates disparate silos of structured data and unstructured content in ways never before possible. Offering both intuitive search capabilities and the power of SQL, AIE seamlessly integrates with existing BI and big data tools to reveal insight that matters, through the access method that best suits each user’s technical skills and priorities. Please visit us at www.attivio.com.

Attivio and Active Intelligence Engine are trademarks of Attivio, Inc. All other names are trademarks of their respective companies.

About Actian: Take Action on Big Data

Actian powers the action-driven enterprise in the Age of Data, delivering rapid time to analytic value with a modular approach that connects data assets behind the scenes, enables unconstrained analytics and scales almost without limits. The Actian DataCloud Integration and ParAccel Big Data Analytics Platforms help organizations leverage data assets for competitive advantage, delivering highly parallelized software that fully exploits modern chip, core and cluster infrastructures. Its scalable solutions deliver powerful business results for industry innovators. Actian serves tens of thousands of users worldwide and is headquartered in Redwood City, California. Stay connected with Actian Corporation on Facebook, Twitter and LinkedIn.

Actian, DataCloud, ParAccel, Action Apps, Ingres, RushAnalytics, Versant and Vectorwise are trademarks of Actian Corporation and its subsidiaries. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.

Categories: Database, Vendor

Actian to Present at the NASSCOM Product Conclave 2013

Actian Corporation (Ingres) Press Releases - Mon, 10/28/2013 - 19:00

Redwood City, Calif. – October 28, 2013 — – Steve Shine, CEO and President of Actian Corporation (“Actian”), a next-generation leader in big data analytics, will present during the NASSCOM® Product Conclave 2013 – The Community Meet-up of Doers Who Share! event, held Oct. 28-30 at Vivanta by Taj – Yeshwantpur in Bangalore, India.

During the Opportunities in Big Data session, which takes place Oct. 30 at 2:00-2:30 p.m. IST in the Aura room, Shine will discuss the various opportunities presented by big data, as well as new areas of innovation for startups trying to effect meaningful competitive differentiation through analytics on big data.

Actian has a strong presence in India, helping companies like Future Group, Mahindra Comviva and ManageEngine, a division of Zoho Corporation, harness the power of big data analytics to predict business trends, increase customer retention and gain a competitive advantage.

For more information on the NASSCOM Product Conclave 2013, please visit http://productconclave.nasscom.in/.

About Actian: Take Action on Big Data

Actian powers the action-driven enterprise in the Age of Data, delivering rapid time to analytic value with a modular approach that connects data assets behind the scenes, enables unconstrained analytics and scales almost without limits. The Actian DataCloud Integration and ParAccel Big Data Analytics Platforms help organizations leverage data assets for competitive advantage, delivering highly parallelized software that fully exploits modern chip, core and cluster infrastructures. Its scalable solutions deliver powerful business results for industry innovators. Actian serves tens of thousands of users worldwide and is headquartered in Redwood City, California. Stay connected with Actian Corporation on Facebook, Twitter and LinkedIn.

Actian, DataCloud, ParAccel, Action Apps, Ingres, RushAnalytics, Versant and Vectorwise are trademarks of Actian Corporation and its subsidiaries. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.

Categories: Database, Vendor

Actian Teams with Hortonworks to Deliver Reference Architecture that Addresses Most Vexing Hadoop Challenges for Enterprises

Actian Corporation (Ingres) Press Releases - Fri, 10/25/2013 - 03:51

Sand Hill research pinpoints Hadoop adoption hurdles at each phase of maturity cycle

Redwood City, Calif. – October 24, 2013 — Actian Corporation (“Actian”), a next-generation leader in big data analytics, has further integrated its ParAccel Big Data Analytics Platform on the Hortonworks Data Platform to address top Hadoop adoption hurdles of data extraction challenges, design-time friction and poor run-time performance.

The deep integration of Actian’s ParAccel Big Data Analytics Platform on the Hortonworks Data Platform enables high-performance analytics without constraints, simplifies the delivery of data services for entire ecosystems of users, and significantly lowers the total cost of ownership for the modern data platform. By utilizing the new Hortonworks/Actian reference architecture, users can experience quicker time to analytic value by:

  • Easily moving data to and from Hadoop: Users can easily extract data from Hadoop and enrich it seamlessly from within the ParAccel Platform.
  • Eliminating design-time friction: ParAccel Dataflow’s easy-to-use drag-and-drop development capabilities negate the need for complex MapReduce coding or parallel programming.
  • Improving performance: Actian is Hortonworks Data Platform 2.0 and YARN certified, giving users the ability to leverage ParAccel Dataflow for the enhanced performance of pipeline parallelism alongside their existing MapReduce jobs.

Sand Hill Group recently surveyed Hadoop users, primarily data architects and CIOs, to assess their level of maturity in Hadoop adoption and the top challenges they face. For 46.7 percent of respondents, the top challenge was knowledge and experience with the Hadoop platform, while 20.7 percent cited availability of Hadoop and Big Data skills and 6.7 percent struggled with the amount of technology development and engineering required to implement a Hadoop-based solution. Actian’s and Hortonworks’ joint reference architecture tackles these key challenges head-on.

“Hadoop is the clear winner for enterprises that seek to drive transformational, actionable business insights from their big data,” said Mike Hoskins, chief technology officer of Actian Corporation. “For all its power, Hadoop still presents significant barriers to enterprise-scale adoption. The combined Actian-Hortonworks solution overcomes challenges around MapReduce skills shortages, design-time friction and run-time performance to elevate Hadoop to true enterprise readiness. Actian has many global clients delivering groundbreaking big data projects. For nearly all of these, Hadoop is a central building block. The collaboration between Hortonworks and Actian provides a huge boost for performance, productivity and access to rich big data functionality, which helps increase adoption of Hadoop. For our mutual customers it boils down to faster time to value – in the end, that’s what really counts.”

“We have collaborated closely with Actian on the reference architecture for the ParAccel Big Data Analytics Platform and the Hortonworks Data Platform,” said Ari Zilka, chief technology officer of Hortonworks. “When used together, these products allow users to rapidly and effectively deploy high-performance Hadoop applications for scenarios ranging from archiving, ETL and operational applications to advanced analytics, including predictive analytics. By working together we are excited to help forward-thinking architects and CIOs successfully design and implement incredibly high-performing, hard-hitting big data applications with proven best practices, robust and secure architecture, and unmatched technology capabilities.”

“Design and implementation of next-generation big data integration processes can be a daunting leap for BI professionals who are used to classic ETL technology,” said Steve Miller, president and co-founder of OpenBI. “Actian’s approach – providing a visual data programming technology that executes natively in cluster – will increase productivity while opening up big data analytics programming to a much broader set of professionals.”

“Our research findings offer compelling insights into friction points on the march to harnessing Hadoop to unlock big data analytics value for the enterprise,” says M.R. Rangaswami, co-founder and managing director of Sand Hill Group. "With more than 35 percent of respondents indicating that the results of their Hadoop/Big Data initiatives were less than they expected, the market is ripe for more easy-to-use, easy-to-implement solutions on Hadoop such as Actian's analytics and ETL offerings.”

Hoskins and Zilka will jointly present at Strata + Hadoop World 2013 on Tuesday, October 29, 2013 at 1:45 p.m. EDT. In addition, both Actian and Hortonworks will provide hands-on demonstrations of the reference architecture at their Strata booths, #108 and #306, respectively.

About Actian: Take Action on Big Data
Actian powers the action-driven enterprise in the Age of Data, delivering rapid time to analytic value with a modular approach that connects data assets behind the scenes, enables unconstrained analytics and scales almost without limits. The Actian DataCloud integration and ParAccel Big Data Analytics Platforms help organizations leverage data assets for competitive advantage, delivering highly parallelized software that fully exploits modern chip, core and cluster infrastructures. Actian serves tens of thousands of users worldwide and is headquartered in Redwood City, Calif. with offices in Austin, New York, London, Paris, Frankfurt, Amsterdam, New Delhi and Melbourne. Stay connected with Actian Corporation on Facebook, Twitter and LinkedIn.

Actian, Actian DataCloud, ParAccel, Action Apps, Ingres, Versant and Vectorwise are trademarks of Actian Corporation and its subsidiaries. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.

# # #

Categories: Database, Vendor

Actian Appoints New CMO and SVP of Business Development to Accelerate the Transformation of the Big Data Marketplace

Actian Corporation (Ingres) Press Releases - Thu, 10/24/2013 - 19:00

Ashish Gupta, Former Microsoft and Vidyo executive, is poised to redefine the data analytics marketplace by creating new opportunities not addressed by aging stack players

Redwood City, Calif. – October 24, 2013 — – Actian Corporation (“Actian”), a next-generation leader in big data analytics and cloud integration, has appointed Ashish Gupta as chief marketing officer and senior vice president of business development.

“We have very systematically evolved our business so that we have a very powerful engine for the market’s transition to the Age of Data,” said Steve Shine, chief executive officer of Actian Corporation. “Ashish Gupta brings the go-to-market experience to ensure that we build our base in big data analytics and cloud integration. More importantly, he has the strategic vision to work with the team to entirely redefine these markets as we leapfrog legacy stack players.”

Gupta brings a passion and track record for challenging established companies saddled with legacy approaches, often caught in the Innovator’s Dilemma, by exploiting disruptive technologies and creative marketing strategies to rapidly scale the new entrant’s business and open new markets not addressed by incumbents. He joins Actian from Vidyo, a video conferencing provider, where he served as chief marketing officer and senior vice president of corporate development. Under his leadership, Vidyo experienced significant growth, formed key strategic partnerships and built a leading brand in the industry – challenging the leaders of a 30-year-old industry. Prior to Vidyo, Gupta held various executive roles within the Microsoft Office Division where he led marketing, sales and business development teams for Microsoft’s Unified Communications Group, competing with established PBX vendors to create a leadership position for Microsoft Lync in the communications and collaboration market. Gupta has also served in executive roles at Alcatel/Genesys Telecommunications, Deloitte Consulting, Covad and Hewlett-Packard.

“Severe market disruption happens when innovative technologies materially shift an industry’s fulcrum to create new business approaches and markets,” said Gupta. “Actian’s portfolio has proven to be such a force in the industry by enabling next-generation analytical solutions and invisible integration for thousands of customers that use data to create sustainable competitive advantage. I welcome the opportunity to contribute to the company’s fast growth and market leadership.”

About Actian: Take Action on Big Data

Actian powers the action-driven enterprise in the Age of Data, delivering rapid time to analytic value with a modular approach that connects data assets behind the scenes, enables unconstrained analytics and scales almost without limits. The Actian DataCloud Integration and ParAccel Big Data Analytics Platforms help organizations leverage data assets for competitive advantage, delivering highly parallelized software that fully exploits modern chip, core and cluster infrastructures. Its scalable solutions deliver powerful business results for industry innovators. Actian serves tens of thousands of users worldwide and is headquartered in Redwood City, California. Stay connected with Actian Corporation on Facebook, Twitter and LinkedIn.

Actian, DataCloud, ParAccel, Action Apps, Ingres, RushAnalytics, Versant and Vectorwise are trademarks of Actian Corporation and its subsidiaries. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.

Categories: Database, Vendor

Actian to Present at the 10th Annual East Coast Technology Growth Conference

Actian Corporation (Ingres) Press Releases - Tue, 10/15/2013 - 02:41

Redwood City, Calif. – October 14, 2013 — – John Santaferraro, vice president of solutions and product marketing at Actian Corporation(“Actian”), a next-generation leader in big data analytics, will present during the AGC Partners 10th Annual East Coast Technology Growth Conference at the Westin Copley Place in Boston on Tuesday, October 15, 2013.

During the event, Santaferraro will participate in a panel focused on Big Data Analytics moderated by Jeff Kelly, Principal Research Coordinator of the Wikibon Project. Santaferraro and fellow panelists Kathy McGroddy, VP of Business Development of IBM; Louis Brun, Senior VP of Product Strategy of Guavus; Jit Saxena, Chairman of Netezza and Anthony Deighton, CTO of QlikView will discuss why traditional data management and business analytics tools and technologies are straining under the weight of big data. They will shed light on challenges organizations face when deriving value from their data and share new approaches in helping enterprises gain actionable insights through next-generation big data analytics.

Visit actian.com to learn more about Actian’s next-generation approach of enabling organizations to predict the future, prescribe the next best action, prevent damage to their business and discover hidden risks and opportunities through use of the ParAccel Big Data Analytics Platform.

About Actian: Take Action on Big Data

Actian powers the action-driven enterprise in the Age of Data, delivering rapid time to analytic value with a modular approach that connects data assets behind the scenes, enables unconstrained analytics and scales almost without limits. The Actian DataCloud Integration and ParAccel Big Data Analytics Platforms help organizations leverage data assets for competitive advantage, delivering highly parallelized software that fully exploits modern chip, core and cluster infrastructures. Its scalable solutions deliver powerful business results for industry innovators. Actian serves tens of thousands of users worldwide and is headquartered in Redwood City, California. Stay connected with Actian Corporation on Facebook, Twitter and LinkedIn.

Actian, DataCloud, ParAccel, Action Apps, Ingres, RushAnalytics, Versant and Vectorwise are trademarks of Actian Corporation and its subsidiaries. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.

Categories: Database, Vendor