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

New Certifications Demonstrate Continued Momentum for Oracle Public Cloud

Oracle Database News - Wed, 03/29/2017 - 13:00
Press Release New Certifications Demonstrate Continued Momentum for Oracle Public Cloud Cloud compliance certifications further validate Oracle Cloud in highly regulated sectors

Redwood Shores, Calif.—Mar 29, 2017

Oracle today announced it has achieved a series of compliance certifications and attestations for its Public Cloud offering, including certifications and attestations for ISO 27001, HIPAA, SOC1 and SOC2 for a number of core services. Administered by Schellman & Co., these certifications in industries such as healthcare help provide validation of Oracle’s offerings in areas including security, availability, processing integrity and privacy.

Oracle’s portfolio of Platform-as-a-Service (PaaS) and Infrastructure-as-a-Service (IaaS) solutions received Service Organization Control (SOC) attestations for the following key services: Database Public Cloud Service, Java Public Cloud Service, Database Backup Cloud Service, Exadata Cloud Service, Big Data Cloud Service, Big Data Preparation Service, Big Data Discovery, Application Builder Cloud Service, Storage Cloud Service, Dedicated Compute Cloud Service, and Public Compute Cloud Service. These SOC certifications confirm Oracle’s compliance with international service organization reporting standards. SOC reports are standards that help organizations establish trust and confidence in their service delivery processes by assessing whether service organizations are performing their duties appropriately in a controlled, stable and secured environment.

Oracle recently received a Health Insurance Portability and Accountability Act (HIPAA) attestation for its Oracle Fusion Suite of Software-as-a-Service (SaaS) applications‚ÄĒincluding Enterprise Resource Planning (ERP), Human Capital Management (HCM), and Customer Relationship Manager (CRM) Cloud Service‚ÄĒdemonstrating that its SaaS solutions meet the requirements established by the U.S. Department of Health and Human Services for organizations working in the healthcare industry. HIPAA attestations affirm the proper saving, accessing and sharing of individual medical and personal information, as well as compliance with national security standards to protect health data created, received, maintained or transmitted electronically.

Oracle recently received an International Standards Organization (ISO) 27001 certification demonstrating the proper management and security of assets such as financial information, intellectual property, employee details or information entrusted to an organization by third parties, for its Public Cloud SaaS suite of services in the core areas of Fusion ERP, HCM, CRM, Taleo Social, Taleo Business Edition, Service Cloud, Eloqua Marketing Cloud, BigMachines CPQ, and Field Service Cloud. 

‚ÄúOracle is continuously investing time and resources to meet our customers‚Äô strict requirements across highly regulated industries,‚ÄĚ said Erika Voss, Global Senior Director, Public Cloud Compliance, Risk and Privacy, Oracle. ‚ÄúThese new certifications not only validate the reliability and security features of the Oracle Cloud; they effectively make Oracle‚Äôs solutions available to thousands of new customers in the Healthcare and Public Sector industries.‚ÄĚ

Contact Info Scott Thornburg
Oracle
+1.415.816.8844
scott.thornburg@oracle.com About Oracle Cloud

Oracle Cloud is the industry‚Äôs broadest and most integrated public cloud, offering a complete range of services across SaaS, PaaS, and IaaS. It supports new cloud environments, existing ones, and hybrid, and all workloads, developers, and data. The Oracle Cloud delivers nearly 1,000 SaaS applications, and 50 enterprise-class PaaS and IaaS services to customers in more than 195 countries around the world supporting 55 billion transactions each day. For more information, please visit us at http://cloud.oracle.com.

About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Scott Thornburg

  • +1.415.816.8844

Follow Oracle Corporate

Categories: Database, Vendor

Build intelligent applications with help from Microsoft App Accelerate

Today‚Äôs exec is rudely awakened daily to ever-changing customer expectations. Last year‚Äôs huge investments were popular for a few months, but suddenly the ‚Äúnext big thing‚ÄĚ is turning attention‚ÄĒand attracting budgets‚ÄĒelsewhere. How do you stay competitive with data and security? How do you ensure your applications scale across cloud and mobile?

Microsoft unveiled a new program, Microsoft App Accelerate, that targets such issues for application creators and ISVs (independent software vendors). Whatever cutting-edge commercial solution your company delivers, the program will provide product and technical resources to help you plan, deploy, launch, and grow your applications.

Still imagining your application? Find strategic planning resources to help you determine what investments can make the most impact. Utilize e-books and analyst reports to assess the technical and data opportunities driving the market, financial tools to help you determine ROI, and real-world examples of other app innovators and the steps they took to succeed.

Beginning to build, test, and deploy? You can connect directly with engineers and design experts who’ll bring the skills to match your vision. You’ll even have access to exclusive offers to help jump-start your development cycles.

For example:

  • Technical guidance from expert engineers across Microsoft‚Äôs flagship cloud and data solutions, including Azure, SQL Server, and Power BI.
  • Access to design sessions and deployment programs, such as the Data Accelerator and Power BI Embedded Accelerator offers.
  • Testing and certification services to drive accelerated app innovation and deployment.

Ready to launch your application? Here’s where Microsoft’s enterprise scale and global reach really deliver. Distribution channels like AppSource and Azure Marketplace help you find your customers. Co-selling and co-marketing opportunities from Microsoft’s go-to-market (GTM) services extend your impact. In-depth resources on marketing and sales strategy help you keep momentum and repeat success.

Visit Microsoft App Accelerate to learn more; but if you’re ready to jump right in, register today.

Categories: Database

Oracle’s HCM World and Modern Finance Experience 2017 Deliver Foundation for Modern Business Success

Oracle Database News - Tue, 03/28/2017 - 13:00
Press Release Oracle’s HCM World and Modern Finance Experience 2017 Deliver Foundation for Modern Business Success Complementary events for HR and finance professionals showcase the building blocks, tools and strategies companies need to drive digital business transformation

Redwood Shores, Calif.—Mar 28, 2017

Helping businesses embrace modern best practices, Oracle today announced HCM World 2017 and Modern Finance Experience 2017, taking place in Boston, April 11-13. Organizations across every industry are examining how they can use technology to innovate and gain a competitive advantage, all while enhancing employee engagement and performance. HCM World and Modern Finance Experience will bring together leading visionaries and business professionals to share real-world examples and strategies for modernizing business with technology to fuel digital growth strategies, engage and retain top talent, and maximize organizational efficiency and effectiveness.

Taking place concurrently, HCM World is being held at the Boston Marriott Copley Place and Modern Finance Experience at The Westin Copley Place.

‚ÄúThe need for digital transformation is challenging today‚Äôs companies to look ahead and redefine how they operate. Forward-looking companies are exploring new and emerging technologies, such as machine learning, predictive analytics, big data, and the Internet of Things (IoT) to optimize business processes. They also are looking for new ways that the cloud and data analytics can help them stay ahead of their competitors,‚ÄĚ said Steve Miranda, executive vice president of applications development, Oracle. ‚ÄúThe HCM World and Modern Finance Experience events are designed to deliver the practical roadmap to help companies future proof their business systems, while showcasing examples of those who have successfully navigated the transition.‚ÄĚ

HCM World

HCM World is geared to provide HR professionals with the multi-faceted strategies they need to build and grow a modern, digital-based HR practice. More than 60 sessions throughout the three-day event are tailored to help elevate HR as a strategic partner in advancing business goals by:

  • Engaging employees with modern, customized, and easy-to-use systems and processes that help them be productive and happy at work.
  • Informing through predictive analytics to allow organizations to take action pro-actively and give HR the foresight to plan ahead.
  • Adapting and expanding an organization‚Äôs capabilities, both as a business and as a digital leader, by enabling the flexibility to personalize, brand, and extend the experience at every layer of the cloud in a secure and safe way.

To register for Oracle HCM World 2017, visit here and find more information on the event on the Oracle Modern HR in the Cloud blog, Facebook or Twitter.

Modern Finance Experience

The premier event for CFOs and finance professionals, Modern Finance Experience is designed to provide attendees with guidance on how to build a modern operating model for finance that supports digital business processes and new ways of working. Over 25 visionary keynotes and thought-leadership sessions, including an exclusive CFO Summit, during the three-day event will inspire, educate, and empower the finance function to assume a larger role in driving business success. Attendees will be able to:

  • Learn from hands-on sessions with practitioners and industry experts who will give finance leaders a roadmap to finance modernization and offer advice on how new technologies can reshape finance to be more predictive and extend their value across other business functions (such as HR).
  • Share how emerging technologies, such as big data analytics, artificial intelligence (AI), and machine learning, powered by the cloud, can optimize both the transactions and analytical capabilities required by finance to become more agile.
  • Craft high-impact strategies for improving the non-traditional finance skill sets now required of finance professionals to provide proactive guidance to the business.

Register for Modern Finance Experience 2017 here. For additional information on Oracle Cloud solutions for Finance, visit Oracle Enterprise Resource Planning (ERP) Cloud’s Facebook, and Twitter and Oracle Enterprise Performance Management (EPM) Cloud’s Facebook and Twitter or the Modern Finance Leader blog.

Contact Info Simon Jones
PR for Oracle
+1.415.856.5155
sjones@blancandotus.com About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Simon Jones

  • +1.415.856.5155

Follow Oracle Corporate

Categories: Database, Vendor

Data structures with Couchbase and .NET (video)

NorthScale Blog - Mon, 03/27/2017 - 19:47

In February, I wrote a blog about using data structures with .NET (and .NET Core): List, Queue, and Dictionary.

Now, I’ve created a video to show the same concepts in action.

How to use Couchbase Data Structures with .NET

The source code used in this video is available on GitHub. Note that the source code uses .NET Core, but this should work just the same in .NET.

Thanks for watching!

If you have any questions about Couchbase and .NET, please ask away in the Couchbase .NET Forums. Also check out the Couchbase Developer Portal for more information on the .NET SDK and Couchbase in general.

You can also contact me at Twitter @mgroves.

The post Data structures with Couchbase and .NET (video) appeared first on The Couchbase Blog.

Categories: Architecture, Database

Performance Enhancements to N1QL in the Couchbase 5.0 March Developer Build

NorthScale Blog - Mon, 03/27/2017 - 18:20

N1QL in Couchbase has come a long way since it was first introduced in Couchbase Server 4.0.  In Couchbase 5.0, things are taken to the next level in terms of performance.  In terms of the March 2017 Developer build of Couchbase 5.0, there are performance enhancements to N1QL in the flavor of index projection, enhancements to COUNT and DISTINCT, and the much requested ORDER BY, LIMIT, and OFFSET operators.

So what in specific was done to enhance all of these areas and how can we make use of the changes?

Let’s take index projection for example. ¬†When creating an index, you can create one with any number of properties. ¬†For example, take the following index:

CREATE INDEX idx ON default(type, firstname, lastname);

The above statement will create a covering index on the default Bucket for the type, firstname, and lastname properties of any given document.

Now let’s say we created the following N1QL query to retrieve a few documents with the¬†idx index we had created:

SELECT firstname
FROM default
WHERE type = 'person'

The above query would use the¬†idx index and return only the¬†firstname¬†property for every document that matches. ¬†The concept of querying this way is nothing new, however, what happens¬†behind the scenes has changed. ¬†You’ll notice that even though¬†our index has many keys, we’re only interested in a subset, or in this case two¬†keys.

So what is happening and why is this important?

In previous versions of Couchbase all keys of the index were taken into consideration regardless if only a subset were used.  As a result, more network, CPU, and memory were needed to accommodate what was happening.  Now this is not the case.

So how do you know index projection is happening?

Do an¬†EXPLAIN on the query that you’re running:

EXPLAIN SELECT firstname
FROM default
WHERE type = 'person'

In the results you should see something regarding index_projection that looks like the following:

...
"index_projection": {
    "entry_keys": [
        0,
        1
    ]
},
...

The entry_keys property will change based on your query.  For example, what if we add one WHERE condition like so?:

SELECT firstname
FROM default
WHERE type = 'person' AND lastname = 'Nic'

In the above scenario, we would get an EXPLAIN result that looks like the following:

...
"index_projection": {
    "entry_keys": [
        0,
        1,
        2
    ]
},
...

Now the above query wasn’t an index projection because we used all keys in our covering index.

Creating proper indexes paired with index projection can really help in overall performance and scaling your Couchbase Server cluster.

Index projection wasn’t the only performance enhancement made in the March 2017 build right? ¬†That is correct, there is more!

Let’s take the¬†COUNT(DISTINCT) operation for example. ¬†Now let’s use that operation in the following query:

EXPLAIN SELECT COUNT(DISTINCT type)
FROM default;

In the results you’ll notice that it is using¬†IndexCountDistinctScan2 and what it is doing is storing all¬†type in the index and processing the distinct values. ¬†While it happens in the indexer in Couchbase 5.0, it previously happened in the N1QL service in prior editions. ¬†By offloading¬†this operation in the indexer, we can experience significant performance gains.

Similarly, take the OFFSET, LIMIT, and ORDER BY operators that can be used in N1QL queries.  Take the following query for example:

EXPLAIN SELECT firstname
FROM default
WHERE type = 'person'
ORDER BY firstname
LIMIT 1
OFFSET 1;

You’ll notice that the¬†LIMIT, ORDER BY,¬†and¬†OFFSET operators will appear in the indexer. ¬†Prior to 5.0, the LIMIT operator appeared in the indexer, but now the others do as well. ¬†This is a huge win because in previous versions of Couchbase if you were to offset the results, N1QL would get all X number of results, and drop everything before the offset.

For more help with N1QL, check out the Couchbase Developer Portal which contains a ton of useful developer documentation.

The post Performance Enhancements to N1QL in the Couchbase 5.0 March Developer Build appeared first on The Couchbase Blog.

Categories: Architecture, Database

Get to know our Couchbase Community Meet ‚Äď Shivansh Srivastava

NorthScale Blog - Mon, 03/27/2017 - 10:23

In our latest interview for Get to Know Our Couchbase Community Champions, we meet Shivansh Srivastava from Delhi, India.

ShivanshSrivastava 181x300 1

Tell us about yourself and what you do in your daily role?

I consider myself to be a polyglot developer and a Scala, Spark, and Couchbase aficionado. I like to contribute to Open Source projects, and have contributed to projects like Apache iota, Apache Spark, Apache CarbonData, Couchbase-Spark-Connector, Akka, Alpakka, and many others. I’ve a keen interest in upcoming technologies like IoT, deep learning, etc. Currently, I’m employed as a Sr. Software Engineer at Chirpanywhere Inc, an IoT-based startup, where my main work is to manage many things from programming to designing the whole solution and deploying it. I’m also interested in building communities and am currently building my own community, Internity, to revolutionize the learning in colleges in India.

Where are you based and what do you like to do in your spare time?
I am currently based in Delhi, India. In my spare time I like to contribute to community building and help out others so they do not get stuck on the same problems I have experienced. Hence, I like to respond on Stackoverflow, write blogs, and learn from online courses (i.e., Coursera and edX, etc.). I also want to build a community offline, which is why I started the Internity initiative.

What made you choose Couchbase?
We’ve explored many options, but we chose Couchbase because of some pretty cool features like user-friendly UI, hence the cost of database management was reduced. It was in-memory, therefore, the reads were quite fast, and it has Couchbase Full Text Search (CBFT), which provides all the benefits of using a single database.

What one feature of Couchbase do you use and what should people know about it?

One feature is getting nearly ACID properties in a NoSQL database. Using the approach stated in Pro Couchbase Server by David Ostrovsky, Yaniv Rodenski, and Mohammed Haji, we formulated our solution and we were able to get nearly ACID properties in Couchbase. This book is a must-read.

What have you accomplished using Couchbase?

Earlier, I worked with a company related to the stock market and the data was semi-structured. With Couchbase, we were able to apply real-time N1QL queries to the data and integrate with Spark using the Spark-Couchbase Connector. And using Couchbase-Elastic river plugin to transfer data directly to ElasticSearch using the Couchbase UI is very user-friendly. There were many things we did not need to write code for that was managed by Couchbase itself, and the Couchbase UI has been very helpful in monitoring it as well.

If you could have three wishes for Couchbase what would they be?

My three wishes would be:

1. Increase the writing speed of the data which can be achieved in the near future.

2. Develop some compression algorithm like Pied Piper in Silicon Valley and inculcate into Couchbase to deal with the data volume.

3. To keep on increasing the open source activities to promote open source culture in other companies too.

What is your favorite book or author, and why?

My favourite book is Artificial Intelligence: A Modern Approach by Peter Norvig and Stuart J. Russell because of the ease with which they have explained such difficult topics. I also love to read biographies and autobiographies and am currently reading Playing It My Way, by Boria Majumdar and Sachin Tendulkar.

The post Get to know our Couchbase Community Meet – Shivansh Srivastava appeared first on The Couchbase Blog.

Categories: Architecture, Database

Setting A Logon Security Message In Oracle

Database Journal News - Mon, 03/27/2017 - 08:01

Many enterprises are requiring user notification of session monitoring at login, at both the server and database level. Read on to see how to enable this feature and provide custom text.

Categories: Database

ANN: Couchbase Lite Developer Build 003 (Obj C, Swift, .NET)

NorthScale Blog - Fri, 03/24/2017 - 19:57

I am very pleased that Couchbase Lite Developer Build 003 is now available for download for Objective C, Swift and ‚Äú.NET‚ÄĚ.

Database queries have changed significantly in this release. Couchbase Lite 2.0 uses semantics based on N1QL query language defined by Couchbase. This API will be familiar If you’ve used Core Data, or other query APIs based on SQL (like jOOQ).

The Query API will have two styles – builder and fluent, and the implementation chosen would depend on the development platform.

Objective C

For Objective-C, we’ve implemented a builder API.

The SQL Statement

‚ÄėSELECT * FROM type=’account’ AND owner=’John’ ORDER BY dealSize‚Äô

can be written with the builder API as follows:

CBLQuery *query =

[CBLQuery select: [CBLQuerySelect all]

            from: [CBLQueryDataSource database: database]

¬†¬†¬†¬†¬† ¬†¬†¬†¬†where: [[CBLQueryExpression property: @”type”] equalTo: @”account”] and:

¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† [CBLQueryExpression property: @”owner”] equalTo: @”Wayne”]]

¬†¬†¬†¬†¬†¬†¬†¬† orderBy: [CBLQueryOrderBy expression: [CBLQueryExpression property: @”dealSize”]]

];

The API Specification for Objective C is available here and the release notes are here.

Swift

We’ve implemented a fluent API with support for the following

  • CRUD operations
  • Document with property type accessors
  • Subdocument API
  • Blob data type
  • CouchbaseLiteSwift framework for the Swift API
  • Database and Document Change Notification

The API Specification for Swift is available here and the release notes are here.

.NET

The major changes in .NET are as follows –

  • We‚Äôve added the sub document API which allows you to access embedded JSON objects. This is a much cleaner and safer approach with type safe accessors and the thread safety rules.
  • Thread safety checking is optional now. When used, it will be rigorously enforced and fail quickly to indicate incorrect usage.
  • Plus, you get everything that was available in DB002 which is listed here. The key highlights being:
    • A new and simplified API to interact with Couchbase Lite. CRUD operations are available and each subsequent build will have API expansion and changes. More details are available here.
    • Blob data type support.
    • Database and Document Change Notifications.

We are working hard on creating samples for you but in the meanwhile you can check out the unit tests here to get started.

The API specification is available here and the release notes are available here.

The post ANN: Couchbase Lite Developer Build 003 (Obj C, Swift, .NET) appeared first on The Couchbase Blog.

Categories: Architecture, Database

Working with Arrays in Couchbase with N1QL ‚Äď Video Tutorial

NorthScale Blog - Fri, 03/24/2017 - 17:00

In a recent article, I wrote about flattening and querying arrays in Couchbase using N1QL. ¬†That article was inspired by a popular question in the Couchbase Forums. ¬†After publishing the article, I felt a write-up alone couldn’t do it justice so I decided to create a video tutorial that walked through a bunch of queries on array data.

The video can be seen below:

I encourage you to read the write-up as well as it will help you when learning about N1QL and the cool things you can do with it.

For more information on using N1QL or Couchbase in general, check out the Couchbase Developer Portal.

The post Working with Arrays in Couchbase with N1QL – Video Tutorial appeared first on The Couchbase Blog.

Categories: Architecture, Database

Codenvy, Eclipse Che, Docker, and Couchbase: Coding in the Cloud at Devoxx US

NorthScale Blog - Thu, 03/23/2017 - 23:07

This week Couchbase was at Devoxx US.  Devoxx is a hugely influential conference series, well known in Europe.  This was the first one to take place in the United States.

While I was there I had a chance to talk with a group from Codenvy.  Codenvy allows you to quickly set up development stacks based on Docker containers.  They have several standard environments.  You can add to the existing ones or roll your own by adding Docker images.

Codenvy hosts everything in the cloud, so you can collaborate directly with other developers.  This means you can have applications that run against full-featured backend systems available at the click of a button.

I’m interested in using Codenvy for blogging. ¬†I like the idea of building a sample and having a link to code a reader can try out directly. ¬†So, I sat down during a break in the conference and knocked out a simple Couchbase Lite Java app. ¬†Codenvy has adopted Eclipse Che, which gives you a full featured editor that runs in your browser. ¬†(You can use any IDE and sync, too, if you don’t want to use Che.) ¬†I built the app using Che. ¬†The whole process was pretty easy. ¬†I’m looking forward to trying this out further, ideally with a complete Couchbase Mobile stack setup, including Couchbase Server running in its own container.

The app has no UI. ¬†It just shows how to open a database and perform simple CRUD operations. ¬†I used a helper class I find convenient that also wraps Couchbase replication, although I didn’t use that aspect.

I’ve barely scratched the surface on the features Codenvy offers. ¬†For now, click on the badge below and try it out with the sample I wrote.

Postscript

You can find more resources on our developer portal and follow us on Twitter @CouchbaseDev.

You can post questions on our forums. And we actively participate on Stack Overflow.

Hit me up on Twitter with any questions, comments, topics you’d like to see, etc. @HodGreeley

 

The post Codenvy, Eclipse Che, Docker, and Couchbase: Coding in the Cloud at Devoxx US appeared first on The Couchbase Blog.

Categories: Architecture, Database

FakeIt Series 3 of 5: Lean Models through Definitions

NorthScale Blog - Thu, 03/23/2017 - 20:05

Aaron Benton is an experienced architect who specializes in creative solutions to develop innovative mobile applications. He has over 10 years experience in full stack development, including ColdFusion, SQL, NoSQL, JavaScript, HTML, and CSS. Aaron is currently an Applications Architect for Shop.com in Greensboro, North Carolina and is a Couchbase Community Champion.

Aaron Benton

FakeIt Series 3 of 5: Lean Models through Definitions

In our previous post FakeIt Series 2 of 5: Shared Data and Dependencies we saw how to create multi-model dependencies with FakeIt. Today we are going to look at how we can create the same, but smaller models by leveraging definitions.

Definitions are a way of creating reusable set(s) within your model. It allows you to define a set of properties / values one time, referencing them multiple times throughout your model. Definitions in a FakeIt model are very similar to how definitions are used in the Swagger / Open API Specification.

Users Model

We will start with our users.yaml model that we defined in our first post.

name: Users
type: object
key: _id
properties:
  _id:
    type: string
    description: The document id built by the prefix "user_" and the users id
    data:
      post_build: `user_${this.user_id}`
  doc_type:
    type: string
    description: The document type
    data:
      value: user
  user_id:
    type: integer
    description: An auto-incrementing number
    data:
      build: document_index
  first_name:
    type: string
    description: The users first name
    data:
      build: faker.name.firstName()
  last_name:
    type: string
    description: The users last name
    data:
      build: faker.name.lastName()
  username:
    type: string
    description: The username
    data:
      build: faker.internet.userName()
  password:
    type: string
    description: The users password
    data:
      build: faker.internet.password()
  email_address:
    type: string
    description: The users email address
    data:
      build: faker.internet.email()
  created_on:
    type: integer
    description: An epoch time of when the user was created
    data:
      build: new Date(faker.date.past()).getTime()

Lets say that we have a new requirement where we have to support a home and work address for each user. Based on this requirement, we have decided to create a top-level property named addresses that will contain nested properties of home and work.

{
   ...
   "addresses": {
       "home": {
           "address_1": "123 Broadway St",
           "address_2": "Apt. C",
           "locality": "Greensboro",
           "region": "NC",
           "postal_code": "27409",
           "country": "US"
       },
       "work": {
           "address_1": "321 Morningside Ave",
           "address_2": "",
           "locality": "Greensboro",
           "region": "NC",
           "postal_code": "27409",
           "country": "US"
       }
   }
}

Our users.yaml model will need to be updated to support these new address properties.

(For brevity the other properties have been left off of the model definition)

...
properties:
 ...
  addresses:
    type: object
    description: An object containing the home and work addresses for the user
    properties:
      home:
        type: object
        description: The users home address
        properties:
          address_1:
            type: string
            description: The address 1
            data:
              build: `${faker.address.streetAddress()} ${faker.address.streetSuffix()}`
          address_2:
            type: string
            description: The address 2
            data:
              build: chance.bool({ likelihood: 35 }) ? faker.address.secondaryAddress() : null
          locality:
            type: string
            description: The city / locality
            data:
              build: faker.address.city()
          region:
            type: string
            description: The region / state / province
            data:
              build: faker.address.stateAbbr()
          postal_code:
            type: string
            description: The zip code / postal code
            data:
              build: faker.address.zipCode()
          country:
            type: string
            description: The country code
            data:
              build: faker.address.countryCode()
      work:
        type: object
        description: The users home address
        properties:
          address_1:
            type: string
            description: The address 1
            data:
              build: `${faker.address.streetAddress()} ${faker.address.streetSuffix()}`
          address_2:
            type: string
            description: The address 2
            data:
              build: chance.bool({ likelihood: 35 }) ? faker.address.secondaryAddress() : null
          locality:
            type: string
            description: The city / locality
            data:
              build: faker.address.city()
          region:
            type: string
            description: The region / state / province
            data:
              build: faker.address.stateAbbr()
          postal_code:
            type: string
            description: The zip code / postal code
            data:
              build: faker.address.zipCode()
          country:
            type: string
            description: The country code
            data:
              build: faker.address.countryCode()

As you can see our home and work address properties contain the exact same nested properties. This duplication makes our model bigger and more verbose. Additionally, what happens if our address requirements need to change? We’d have to make two updates to keep the structure the same. This is where we can take advantage of definitions, by defining a single way to create an address and reference it.

(For brevity the other properties have been left off of the model definition)

...
properties:
 ...
  addresses:
    type: object
    description: An object containing the home and work addresses for the user
    properties:
      home:
        description: The users home address
        schema:
         $ref: '#/definitions/Address'
      work:
        description: The users work address
        schema:
         $ref: '#/definitions/Address'
definitions:
  Address:
    type: object
    properties:
      address_1:
        type: string
        description: The address 1
        data:
          build: `${faker.address.streetAddress()} ${faker.address.streetSuffix()}`
      address_2:
        type: string
        description: The address 2
        data:
          build: chance.bool({ likelihood: 35 }) ? faker.address.secondaryAddress() : null
      locality:
        type: string
        description: The city / locality
        data:
          build: faker.address.city()
      region:
        type: string
        description: The region / state / province
        data:
          build: faker.address.stateAbbr()
      postal_code:
        type: string
        description: The zip code / postal code
        data:
          build: faker.address.zipCode()
      country:
        type: string
        description: The country code
        data:
          build: faker.address.countryCode()

Definitions are defined at the root of the model by specifying a definitions: property, then the name of the definition. Definitions are referenced by using $ref with the value being the path to the definition, for example #/definitions/Address. By using definitions we have saved almost 30 lines of code in our model and created a single place for how an Address is to be defined and generated within our Users model.

We can test the output of our updated Users model addresses using the following command:

fakeit console --count 1 models/users.yaml

blog3 example1

Now, lets say we have a requirement to store a Users main phone number, and then store optional additional phone numbers i.e. Home, Work, Mobile, Fax, etc. For this change we will use two new top-level properties: main_phone and additional_phones that is an array.

{
   ...
   "main_phone": {
       "phone_number": "7852322322",
       "extension": null
   },
   "additional_phones": [
       {
           "phone_number": "3368232032",
           "extension": "3233",
           "type": "Work"
       },
       {
           "phone_number": "4075922921",
           "extension": null,
           "type": "Mobile"
       }
   ]
}

While this may not be the most practical data model, or how I personally would have modeled this data we can use this example again to illustrate how we can take advantage of using definitions within our FakeIt model.

(For brevity the other properties have been left off of the model definition)

...
properties:
 ...
  main_phone:
    description: The users main phone number
    schema:
     $ref: '#/definitions/Phone'
    data:
      post_build: |
       delete this.main_phone.type
       return this.main_phone
  additional_phones:
    type: array
    description: The users additional phone numbers
    items:
     $ref: '#/definitions/Phone'
      data:
        min: 1
        max: 4
definitions:
  Phone:
    type: object
    properties:
      type:
        type: string
        description: The phone type
        data:
          build: faker.random.arrayElement([ 'Home', 'Work', 'Mobile', 'Other' ])
      phone_number:
        type: string
        description: The phone number
        data:
          build: faker.phone.phoneNumber().replace(/[^0-9]+/g, '')
      extension:
        type: string
        description: The phone extension
        data:
          build: chance.bool({ likelihood: 30 }) ? chance.integer({ min: 1000, max: 9999 }) : null

For this example we have created a Phone definition that contains 3 properties: type, phone_number and extension. You will notice that we have defined a post_build function on the main_phone property that removes the type attribute. This is illustrating how definitions can be used in conjunction with a build function to manipulate what is returned by the definition. The additional_phones property is an array of Phone definitions that will generate between 1 Р4 phones. We can test the output of our updated Users model phone numbers using the following command:

fakeit console --count 1 models/users.yaml

blog3 example2

Conclusion

Definitions allow you to streamline your FakeIt models by creating reusable sets of code for smaller more efficient models.

Up Next
  • FakeIt Series 4 of 5: Working with Existing Data
  • FakeIt Series 5 of 5: Rapid Mobile Development w/ Sync-Gateway
Previous

Couchbase Champion This post is part of the Couchbase Community Writing Program

The post FakeIt Series 3 of 5: Lean Models through Definitions appeared first on The Couchbase Blog.

Categories: Architecture, Database

Five reasons to run SQL Server 2016 on Windows Server 2016 ‚ÄĒ No. 1: Security

This is the first blog in a five-part series. Keep an eye out for upcoming posts, which will cover cutting costs and improving performance of storage, BI, and analytics; improving uptime and reliability; reaching data insights faster by running analytics at the point of creation; and maintaining a consistent data environment across on-premises, hybrid, and cloud environments.

Wall, ditch, moat, palisades, watch towers, guards, highly trained soldiers: Even 2,000 years ago, when the Romans built their defenses, they deployed multiple layers of protection to deter invaders and keep intruders out. Today, on the electronic front, IT environments demand no less than a strong, layered approach to ensuring that data assets are protected from attacks such as stolen administrator credentials, unauthorized access, and pass-the-hash exploits.

You can see how important security is by examining the cost of data breaches, which is growing rapidly and represents a significant risk to business, as Figure 1 illustrates. To address this, Microsoft’s $1 billion annual investment in security demonstrates the company’s longstanding and proven commitment to building security capabilities into both its applications and operating systems. This means you can take advantage of layered security and mitigate risk.

Figure 1: Growing cost of data breach [1]

figure-1

Consider SQL Server 2016 and Windows Server 2016, for example: Security is built into both. In fact, the National Institute of Standards and Technology (NIST) has shown SQL Server to consistently be the least vulnerable database.[2] Underpinning the built-in security you get with SQL Server, Windows Server 2016 adds new OS-level security capabilities to existing security functionality. As a result, if you use both SQL Server 2016 and Windows Server 2016 together, you get enterprise-scale security that meets the strictest organizational and industry standards for your infrastructure and your data.

Figure 2: Independent findings show unparalleled security

figure-2[3]

SQL Server 2016 security

When you modernize your data platform to SQL Server 2016, you get access to innovative advanced security features of the least vulnerable database.[4] Three key built-in features that keep unauthorized users from accessing SQL Server data are:

  • Always Encrypted enables encryption inside client applications without revealing encryption keys to SQL Server. It allows changes to encrypted data without the need to decrypt it first, as shown in Figure 3. The combination of Transparent Data Encryption and Always Encrypted ensures that data is encrypted both at rest and in motion. (To learn more, see ‚ÄúAlways Encrypted in SQL Server & Azure SQL Database.‚ÄĚ)

Figure 3: Always Encrypted protection

figure-3

Figure 4: Row-Level Security

figure-4

  • Dynamic Data Masking (DDM) lets you conceal your sensitive data or personally identifiable information (PII) such as customer phone number, bank information or Social Security number. DDM and RLS help developers build applications that require restricted direct access to certain data as a means of preventing users from seeing specific information. Figure 5 illustrates. (For deeper information, see ‚ÄúUse Dynamic Data Masking to obfuscate your sensitive data.‚ÄĚ)

Figure 5: Dynamic Data Masking

figure-5

To learn more about SQL Server 2016 security, you can visit the SQL Server data security webpage and read the security white paper.

Windows Server 2016 security

Just as SQL Server 2016 provides advanced security features that are not available in other data platforms, Windows Server 2016 includes built-in breach-resistance mechanisms to establish strong security layers to help thwart attacks.

The Windows Server 2016 operating system is a strategic layer in your infrastructure and serves as the foundation for your SQL Server data security. To prevent data exposure, you need the most advanced protection you can get. By modernizing both your server platform and your data platform together, you can be assured you’re doing your best to protect your business. The security functionality in Windows Server 2016 includes the following:

  • Device Guard helps lock down what runs on the server so that you are better protected from unauthorized software running on the same server as your SQL Server application.
  • Credential Guard to protect SQL Server admin credentials from being stolen by Pass-the-Hash and Pass-the-Ticket attacks. Using an entirely new isolated Local Security Authority (LSA) process, which is not accessible to the rest of the operating system, Credential Guard‚Äôs virtualization-based security isolates credential information to prevent interception of password hashes or Kerberos tickets.
  • Control Flow Guard and Windows Defender protect against known and unknown vulnerabilities that malware can otherwise exploit. Control Flow tightly restricts what application code can be executed ‚ÄĒ especially indirect call instructions. Lightweight security checks identify the set of functions in the application that are valid targets for indirect calls. When an application runs, it verifies that these indirect call targets are valid. Windows Defender works hand-in-hand with Device Guard and Control Flow Guard to prevent malicious code of any kind from being installed on your servers.

To learn more about the advanced layers of OS security, visit the Windows Server security webpage and read the white paper.

Thanks for reading our first blog in the series. For more info, check out this summary of five reasons to run SQL Server 2016 with Windows Server 2016.

Ready to give it a try? Here are some options to get started:

Windows Server Virtual Labs

Windows Server 2016 Free Evaluation

SQL Server 2016 Free Evaluation

SQL Server Virtual Labs

[1] ‚ÄúData Breach Costs Rising, Now $4 Million per Incident‚ÄĚ

[2] National Institute of Standards and Technology Comprehensive Vulnerability Database, update 2016

[3] National Institute of Standards and Technology Comprehensive Vulnerability Database, update 2016

[4] National Institute of Standards and Technology Comprehensive Vulnerability Database, update 2016

Categories: Database

TNDP Episode #16: The MEAN Stack for Application Development

NorthScale Blog - Thu, 03/23/2017 - 15:00

I am pleased to announce that the latest episode of The NoSQL Database Podcast titled, The Mean Stack for Application Development, has been published to all the popular podcasting networks.  In this episode I have special guest Jonathan Casarrubias from mean.expert come talk about the MongoDB, Express Framework, Angular, and Node.js (MEAN) development stack.

If you’re unfamiliar with the MEAN stack, it is a wildly popular development stack amongst JavaScript developers because all components in the stack have some relationship to JavaScript, making all the technologies play nice together.

This episode can be found on all the major podcast networks including iTunes and Pocket Casts, but if you’d prefer, you can listen to it below.

http://traffic.libsyn.com/nosql/TNDP_-_Episode_16_-_The_MEAN_Stack_for_Application_Development.mp3

If you’d like to follow up with Jonathan, you can find him on Twitter or via his website. ¬†If you’d like to learn about the previous podcast episode, find it here.

To learn more about Couchbase and what it has to offer, check out the documentation in the Couchbase Developer Portal.

The post TNDP Episode #16: The MEAN Stack for Application Development appeared first on The Couchbase Blog.

Categories: Architecture, Database

Can Automated Data Integration Set Data Scientists and Developers Free?

Database Journal News - Thu, 03/23/2017 - 08:01

Data integration often splits the data science community into two factions: those who automate and those who prefer manual coding. While automated tools are still sometimes viewed with suspicion by data ‘purists’ who favor SQL or other programming or scripting languages, even the most hardened coders can benefit from automated data integration systems.

Categories: Database

Importing Structures using Staging Tables and Microsoft SQL Server

IBM - DB2 and Informix Articles - Thu, 03/23/2017 - 05:00
Importing structures into Controller using Staging Tables and Microsoft SQL Server.
Categories: Database

Oracle Hotel 2025 and Oracle Restaurant 2025 Reports Audit Consumer Attitudes on Emerging Technologies and Their Impact on Future Hospitality Experiences

Oracle Database News - Wed, 03/22/2017 - 13:08
Press Release Oracle Hotel 2025 and Oracle Restaurant 2025 Reports Audit Consumer Attitudes on Emerging Technologies and Their Impact on Future Hospitality Experiences Oracle Hospitality Research Identifies the Future of IoT, Virtual Reality and Wearables in the Guest Experience

Oracle Industry Connect, Orlando, FL.—Mar 22, 2017

Today Oracle announced the findings of two research initiatives aimed at identifying consumer attitudes to new technologies and how their implementation will shape consumer behavior in the years to come. Insights from both the Oracle Hotel 2025 and Oracle Restaurant 2025 highlight that consumers are most willing to engage brands with new technology if they feel that they are in control of their experience and that hospitality operators should be wary of implementing automation without personal service.

‚ÄúGiven the heritage of service throughout the Hospitality industry, we‚Äôre not surprised that guests want a continued human connection with their food and beverage and hotel brands of choice, despite the emergence of new technologies,‚ÄĚ said Mike Webster, senior vice president and general manager Oracle Hospitality. ‚ÄúOur hotel and restaurant management platforms OPERA and Simphony will continue to be enabling investments given their ability to provide a singular view of how guests engage and interact.‚ÄĚ

The Hotel 2025 and Restaurant 2025 reports audited 250 restaurant operators, 150 hotel operators and 702 consumers in February 2017 on their reactions to technology’s role in the guest experience over the next 8 years.

Recognition and Personalization Will be a Driver for Future Technologies
  • 33 percent of restaurant and 72 percent of hotel operators say that guest recognition via facial biometrics will be in use within the next five years.
  • 31 percent of restaurant guests and 41 percent of hotel guests will be more likely to visit an establishment with greater frequency if they are recognized by a server or associate without having to give their name or show a loyalty card.
  • Both restaurant (49 percent) and hotel (62 percent) guests agree that having this recognition would improve their experience.
  • 28 percent of restaurant customers would visit more often and 45 percent said it would improve their experience if service was faster because they were recognized.
  • 42 percent of restaurant guests find suggestions based on health invasive and 68 percent find suggestions based on digital footprint invasive.
  • 47% of hotel guests agree that using artificial intelligence to suggest items based on past purchases would improve their experience.  72% of hotel operators agree that AI-based systems that leverage guest preferences and buying history to make targeted dining recommendations will be mainstream by 2025.
Consumers are Warming to Voice-Activated Experiences
  • 36 percent of restaurant guests say ordering through a virtual assistant would improve experience and 17 percent would visit more often, along with 50 percent and 33 percent of hotel guests respectively.
  • 59 percent of hotel guests believe controlling their room via a voice-activated device would enhance the guest experience and operators agree. Hotel operators polled indicated that managing room control and ambiance management (78 percent) via voice activation would be widespread by 2025. Hotel operators also believed that ordering room or hotel services (70 percent) via voice activation would be adopted by 2025.
  • Operators are keen on gathering customer feedback by voice; 61 percent of restaurant operators and 68 percent of hotels said this will be in use in the next 5 years.
Virtual Reality will Enhance the Booking and on-Property Experience in Hotels
  • Consumers also indicated that virtual reality tours of hotel properties (66 percent) and virtual reality lounges for entertainment (44 percent) would improve the guest experience.
  • Hotel operators also believe virtual reality technology will be widespread by 2025 with a variety of use cases: staff training (68 percent), guest entertainment on property (64 percent), and previewing meeting rooms (63 percent).
Robots Won’t be Replacing Hospitality Staff Anytime Soon
  • 50 percent of restaurant guests said being served by a robot would not improve the guest experience and 40 percent would visit less.
  • 37 percent of hotel guests said being served by a robot would not improve the guest experience and 22 percent would visit less.
  • 64 percent of restaurant and 58 percent of hotel operators say that the use of robots for cleaning is appealing.
Operators Begin To Consider Investment in Wearable Technology
  • 51 percent of restaurants and 63 percent of hotels say staff activity monitoring via wearable device will be in use in the next 5 years.
  • 59 percent of restaurants and 78 percent of hotels say that staff checking into work and onto workstations via wearable device will be in use in the next 5 years.
Contact Info Matt Torres
Oracle
415-595-1584
matt.torres@oracle.com Dan Brady
Burson-Marsteller
516-650-7354
dan.brady@bm.com About Oracle Hospitality

Oracle Hospitality brings 35 years of experience in providing technology solutions to food and beverage operators. We provide hardware, software, and services that allow our customers to deliver exceptional guest experiences while maximizing profitability. Our solutions include integrated point-of-sale, loyalty, reporting and analytics, inventory and labor management, all delivered from the cloud to lower IT cost and maximize business agility.

For more information about Oracle Hospitality, please visit www.oracle.com/hospitality.

About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Matt Torres

  • 415-595-1584

Dan Brady

  • 516-650-7354

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Retail 2025 Study Reveals Consumer Attitudes on Disruptive Technologies and Their Impact on Future Retail Experiences

Oracle Database News - Wed, 03/22/2017 - 13:08
Press Release Oracle Retail 2025 Study Reveals Consumer Attitudes on Disruptive Technologies and Their Impact on Future Retail Experiences Research Highlights Differing Sentiments on the Role of Automation, Drones, IoT, 3D Printing, Virtual Reality and Wearables in Customer Experience

Oracle Industry Connect, Orlando, FL.—Mar 22, 2017

Today Oracle announced the findings of new research that examines consumer attitudes to new technologies and how their implementation will shape consumer behavior in the years to come. Insights from the Oracle Retail 2025 study highlight that consumers are most willing to engage brands with new technology if they feel that they are in control of their experience.

“Consumers clearly indicated that they have a conservative appetite for retail techologies that requires deep personal data and make decisions on their behalf,” said Mike Webster, senior vice president and general manager at Oracle Retail and Oracle Hospitality. “This signals brands to focus on building a strong foundation to win trust. Warm attitudes toward utilizing virtual reality and receiving recommendations for custom-made accessories produced with 3D printing points to consumers’ willingness to adopt new technologies if they are in control of their experience.”

The Retail 2025 Report results provide a benchmark for where consumers are on the retail technology adoption lifecycle and the impact on retail in the next eight years. The Retail 2025 Report polled 709 consumers in February 2017.

Smart Gets Smarter

AI, VR and IoT present the opportunity to better anticipate consumers’ next purchase. However, establishing a strong foundation of trust is critical to success when rolling out new experiences to consumers. If brands over step the reaction can be visceral.

  • 64 percent of respondents liked the option of using virtual reality to navigate a personalized in-store experience and having a hand-picked wardrobe to try on in-store
  • 58 percent of consumers indicated a positive attitude toward the idea of having their grocer suggest a shopping list for their approval based on purchase history, social and environmental data
  • 54 percent of respondents indicated that having a grocer automatically charge and ship items based on purchase history, social and environmental data was invasive
Fast Gets Fierce

Velocity in fashion is critical and it will only get faster. 3D printing and drone deliver will accelerate the product design to consumer process from months, to days and eventually hours.

  • 67 percent of consumers like the option of near real-time delivery to their doorstep by drones
  • 64 percent of consumers responded favorably to the concept having a retailer suggest a custom-made accessory for them produced with 3D printing
  • 57 percent of consumers find apparel recommendations from robots based on their social media profile invasive
Personalization Gets Perfected

Consumers are wary about volunteering data necessary for personalization but still look for a tailored experience, reinforcing the need for stronger brand relationships. On the flipside; there is a clear difference in consumer expectation for retailers to make data available and customize information about components, origin and recalls to their specific buying patterns.

  • 54 percent of respondents viewed the concept of linking their wearable activity tracker to their pharmacy so they can suggest products to meet specific health and wellness needs as favorable
  • 78 percent favor the option of having detailed information about product components (e.g., cotton, spandex, etc) and their origin prior to purchase
  • 46 percent of respondents indicated that receiving real-time alerts on current product recalls, and time since last recall by a manufacturer, based on previous purchase history would improve their experience
Contact Info Matt Torres
Oracle
415-595-1584
matt.torres@oracle.com Dan Brady
Burson-Marsteller
516-650-7354
dan.brady@bm.com About Oracle Retail

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.

About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Matt Torres

  • 415-595-1584

Dan Brady

  • 516-650-7354

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Utilities Launches Smart Grid and IoT Device Management Solution in the Cloud

Oracle Database News - Wed, 03/22/2017 - 13:00
Press Release Oracle Utilities Launches Smart Grid and IoT Device Management Solution in the Cloud Oracle Utilities Operational Device Cloud Service is the Foundation for Next Generation Smart Grid and IoT Device Management

Oracle Industry Connect—Orlando, Fla.—Mar 22, 2017

Oracle today introduced Oracle Utilities Operational Device Cloud Service (ODCS), a new cloud offering that enables utilities to further automate the management of their grid assets and devices, at a total lower cost of ownership.

The utilities industry is going through tremendous transformation as a result of IoT and increasing distributed energy resources. The United States alone has more than 70 million smart meters installed [footnote] and utilities are increasingly deploying smart field sensors. As each smart device has its own unique requirements for maintenance, inspection, firmware upgrades and security, utilities are struggling to manage the lifecycle of these assets in a single, centralized way. In response to these challenges, Oracle has unveiled a cloud-based version of its Operational Device Management Solution that provides a scalable and future-proof way to manage IoT device operations.

Available as a new stand-alone cloud service, ODSC automates the management of smart grid and IoT devices. When combined with Oracle Utilities Work and Asset Management solution, it delivers a unified solution in the cloud to extend asset performance management to smart devices at a massive scale. This complete visibility of smart assets delivers detailed insights into each device‚Äôs location, characteristics, health, and firmware upgrade status. In addition, utilities can extend ODCS for customer‚ÄĒowned asset registration processes such as smart thermostats and solar PVs. Additionally, by leveraging the cloud, utilities can reduce their total cost of ownership.

‚ÄúWe‚Äôre in front of the dramatic shifts the utilities industry is experiencing, providing new technologies that meet the needs of our customers as they navigate this changing landscape,‚ÄĚ said Rodger Smith, general manager and senior vice president for Oracle Utilities. ‚ÄúWe‚Äôre committed to innovation, and to providing cloud solutions that make operational excellence a reality for electric, gas and water utilities worldwide.‚ÄĚ

The solution can be added to Oracle Utilities Work and Asset Cloud Service and Oracle Utilities Meter Data Analytics Cloud Service or used as a stand-alone solution depending on a utility’s requirements.

New Features in Oracle Utilities Operational Device Management Cloud Service:
  • Proactively adjust, update, and repair smart grid and IoT devices as needed
  • Enable significant cost savings by eliminating labor costs due to physical data collection with automated processes
  • Reduce total cost of ownership by using the most up to date IT infrastructure in the cloud and alleviating the need to continually maintain older systems
  • Find risks of device failures faster with increased visibility into the age and reliability of each device
  • Prepare for asset registration capabilities of customer-owned assets
Contact Info Valerie Beaudett
Oracle Communications
+1 650-400-7833
valerie.beaudett@oracle.com Christina McDonald
Burson-Marsteller
+1 212.614.4221
christina.mcdonald@bm.com About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Valerie Beaudett

  • +1 650-400-7833

Christina McDonald

  • +1 212.614.4221

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Utilities Launches a New Asset Performance Management (APM) Solution in the Cloud

Oracle Database News - Wed, 03/22/2017 - 13:00
Press Release Oracle Utilities Launches a New Asset Performance Management (APM) Solution in the Cloud Oracle Utilities Work and Asset Cloud Service is the foundation that supports next generation APM

Oracle Industry Connect—Orlando, Fla.—Mar 22, 2017

Oracle today introduced Oracle Utilities Work and Asset Cloud Service, an innovation foundation for asset performance management. The new cloud offering enables utilities to make the necessary transition from reactive to proactive asset management strategies. Utilities can increase asset reliability by finding asset failures faster and performing predictive maintenance with integrated APM and analytics.

Asset reliability and performance is core to well-functioning electric, gas, and water utilities. An aging workforce, pressure from regulators, and scrutiny on cost reduction goals are driving the need to extend the life of existing assets. Distributed energy resources (DER) are adding layers of complexity that underpin a utility‚Äôs asset reliability. Market research indicates that enterprise asset management supported by analytics and performance monitoring is one of the top investment priorities for utilities today (see footnote).   Asset operations decision-makers are looking at advanced analytics to improve asset reliability and monitor their performance.

In response to these challenges, Oracle Utilities is taking a comprehensive approach to APM. Historically, work order management, reliability-centric maintenance, asset tracking, advanced analytics, mobile scheduling, and operational reporting have been siloed applications. Today marks an important step towards integrating these capabilities.

‚ÄúPredictive analytics are changing the game for utility asset maintenance. Extending the life of utility assets can avoid expensive capital projects and lower maintenance costs,‚ÄĚ said Kevin Prouty, Vice President, IDC Energy Insights. ‚ÄúWith the explosion of IoT devices and data around the corner, scalability of these systems will require IT infrastructure that can react and scale quickly. This makes utility asset maintenance applications even more prime for deployment in the cloud.‚ÄĚ

Oracle Utilities Work and Asset Management Cloud Service improves asset operations ability to predict risk of failures faster with out-of the-box APM analytics. The cloud deployment delivers immediate value by reducing total cost of ownership. With integrated analytics, utilities can operationalize insights by optimizing work and maintenance schedules in real time. Unlike stand-alone analytic solutions, integration of these analytics into established work order management systems is an accelerant to optimizing performance of assets.

‚ÄúWhen you combine deregulation, changing legislation and market uncertainty stemming from increasing distributed energy resources, it‚Äôs no surprise that utilities are looking for more ways to improve operations and cut costs,‚ÄĚ said Rodger Smith, general manager and senior vice president, Oracle Utilities. ‚ÄúOracle Utilities Work and Asset Management Cloud Service provides more detailed analytics and deep insights into asset age, health and performance. The cloud infrastructure also gives utilities the flexibility to scale up quickly as new assets are added to the infrastructure from rising IoT and distributed energy resources that are adding more sensors on the network.‚ÄĚ

New Features and Benefits Include:
  • Prevent risk of asset failures faster with out-of-the-box analytics to support repair-versus-replace decisions
  • Detect patterns of asset failure with predefined dashboards and charts to improve investment and capital planning
  • Reduce total cost of ownership by using the most up to date IT infrastructure in the cloud and alleviating needs to constantly maintain older systems
  • Optimize asset reliability programs including ISO 55000 to increase overall value of asset operations more quickly
    • Footnote: ‚ÄúThe Black & Veatch 2016 Strategic Directions: Smart City/Smart Utility‚ÄĚ Research
    • Oracle Utilities Work and Asset Management overview
    • Follow us on Twitter: @OracleUtilities
Contact Info Valerie Beaudett
Oracle Communications
+1 650-400-7833
valerie.beaudett@oracle.com Christina McDonald
Burson-Marsteller
+1 212.614.4221
christina.mcdonald@bm.com About Oracle

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

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Valerie Beaudett

  • +1 650-400-7833

Christina McDonald

  • +1 212.614.4221

Follow Oracle Corporate

Categories: Database, Vendor

Oracle Health Sciences Data Management Workbench Now Available in the Cloud

Oracle Database News - Wed, 03/22/2017 - 13:00
Press Release Oracle Health Sciences Data Management Workbench Now Available in the Cloud Speeds Clinical Discoveries and Reduces Research Costs

Oracle Industry Connect—Orlando, Fla.—Mar 22, 2017

Oracle Health Sciences today unveiled Oracle Health Sciences Data Management Workbench Cloud Service that promises to lower the cost and increase the traceability of clinical development by streamlining end to end clinical data flow across clinical R&D.

Planning and managing clinical trials has become more complex as additional data is being generated, collected and analyzed to demonstrate clinical efficacy, ensure successful regulatory approval and ultimately bring more therapies to market faster. Oracle Health Sciences Data Management Workbench Cloud Service enables pharmaceutical companies and contract research organizations to integrate, reconcile and analyze the growing variety and volume of clinical and healthcare data. By automating data flow and standardizing data for review, clinical researchers have near real time access to insights for clinical trial decision making‚ÄĒall at a dramatically lower total cost of ownership as a result of it being offered as a cloud service.

‚ÄúThe volume and complexity of data in healthcare and life sciences has increased on a massive scale as we capture more data from sources such as electronic health records, wearables and genomics. Clinical data managers and data scientists are now integrating more of this data into their clinical research and trials to improve the odds of more therapies making it to market and faster,‚ÄĚ said Steve Rosenberg, general manager, Oracle Health Sciences. ‚ÄúThe industry has been looking for a purpose-built data management solution that supports the clinical data flow from source to submission, with a lightweight, cloud-based solution, and Oracle‚Äôs new cloud-based data management platform is able to manage all of this new information while ensuring FDA data compliance‚ÄĒat a dramatically lower cost.‚ÄĚ

Oracle Data Management Workbench Cloud Service is pre-integrated with Oracle Health Sciences InForm, enabling two-way real time data flow. Additionally, it brings new levels of standardization, reusability and traceability among disparate clinical data sources by enabling clinical data managers to aggregate, clean and transform data into submission-ready deliverables more quickly than ever before. By using an integrated workflow, data discrepancies can be closed faster, reducing clinical review cycle times and increasing overall data quality.

Contact Info Valerie Beaudett
Oracle Communications
+1 650-400-7833
valerie.beaudett@oracle.com About Oracle

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

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

Talk to a Press Contact

Valerie Beaudett

  • +1 650-400-7833

Follow Oracle Corporate

Categories: Database, Vendor