Feed aggregator

Returning matching or highest row in a SELECT statement

Tom Kyte - Tue, 2016-09-20 03:26
I'm trying to retrieve only two rows when joining these two table. In table A: I have an ID and Date In table B: I have an ID and Timestamp. My select is retrieving 4 rows, however, I want to pick the timestamp from table B that matches the ...
Categories: DBA Blogs

What does "//" in jdbc connection string mean?

Tom Kyte - Tue, 2016-09-20 03:26
Hi AskTom team. I'm testing a jdbc connection to database in my java application. When I use the following form: <code>jdbc:oracle:thin:@myhost:1521/myservicename</code> everything's fine, my java application connects to the db. When I ...
Categories: DBA Blogs

sets of ORA-603/604/1000/6512/4088 errors

Tom Kyte - Tue, 2016-09-20 03:26
Hello All, The question here is how does Oracle handle cursoring with a trigger? Th emax cursor error is happening during execution of the following simple code: CREATE OR REPLACE TRIGGER TNT_OWNER.TRG_USC_ABI_MESSAGE_EMAIL AFTER INSERT OR U...
Categories: DBA Blogs

Move data from one table to other in PLSQL procedure

Tom Kyte - Tue, 2016-09-20 03:26
HI tom, i have one master table which has more record . i need to move that record into temp table while moving data if any error appear i need to save that row in error table. how to do this ?
Categories: DBA Blogs

Slow Full Table Scan on an IO sufficient machine

Tom Kyte - Tue, 2016-09-20 03:26
Hi Tom, I am spotting a performance bottleneck when performing Full Table Scan on all the tables. Take a small table example, SQL> SELECT COUNT(*) FROM schema.frozen_woappoint; COUNT(*) ---------- 1767373 SQL> select segment_name,...
Categories: DBA Blogs

DeadLock

Tom Kyte - Tue, 2016-09-20 03:26
hi , below insert query is causing deadlock.. insert into T_POLICY_GEN_CUST (UPDATE_TIME, INSURED_FLAG, PAYER_FLAG, INSERT_TIME, POLICY_ID, PARTY_ID) values (:1, :2, :3, :4, :5, :6) can you please give me some detailed information about why this...
Categories: DBA Blogs

Oracle Open World 2016 – Day 2

Yann Neuhaus - Tue, 2016-09-20 03:10

Day 2 is the first official day of the Oracle Open World (OOW) 2016. As a parallel event the Oak Table Network organized his Oak Table World (OTW) close to the Open World. I attended several sessions from OOW and OTW:

Jeremy Schneider: Ansible

Ansible is a very light software written in Python, which allows automation in deploying applications and managing systems. The main goal of the developer of Ansible Michael DeHaan was to make the process of deploying software and managing systems much simpler than it is with Puppet or Chef. Jeremy Schneider showed a demo on how easy it is to manage many systems with such an easy and still very effective tool, which uses ssh to connect to the servers and execute commands. It was impressive to see and I feel I have to check with my customer running on Redhat, if Ansible could not be an alternative to Puppet.

Frits Hoogland: Drilldown into logwriter mechanics

What happens when a user executes a “COMMIT;” ? Yes, we know that the logwriter is triggered to write the data to disk. But what happens in detail? By using the debugger dbg on Linux and setting break points in various modules, Frits could show in a very technical session what exactly happens when the foreground process runs in polling mode (i.e. instead of having the Log-Writer triggering the foreground process that the data is persistent on disk, the foreground process is polling SCN-information to detect that the data is on disk). See here.

Wei Hu, John Kanagaraj: High Availability and Sharding Deep Dive with Next-Generation Oracle Database

What is Sharding? According Oracle there is a need for World Scale applications to have a farm of independent databases. I.e. instead of 1 giant DB, the DB is partitioned into many smaller DBs (shards) running on different hosts. In contrast to RAC the data is not shared, i.e. every machine has its own disks (shared nothing hardware). So each shard stores a subset of the data. For performance reasons read-mostly data (e.g. a lookup table) is replicated between the shards. The applications have to be designed in a way that workload can be routed to a specific database in the farm. There is a choice of the sharding method: System managed (consistent hash), Composite (range-hash, list-hash) and User defined (range, list). Based on a sharding key (in the example below the CustId) the data is distributed among the shards:


CREATE SHARDED TABLE
...
PARTITION BY CONSISTENT HASH (CustId)
...;

In case a new shard is added, the data needs to be redistributed. That move of data is initiated automatically or manually (by the DBA). When it’s automated the system uses RMAN Incremental Backups and Transportable Tablespaces to redistribute the data.

Enhancements with Active Data Guard:

Improved Data Protection:

  • High speed DB compare (whole DB or individual data files) between Primary and Standby. Validates that primary and standby is physically the same, by doing a compare at the physical level.
  • RMAN validation and repair of blocks on standby that were invalidated by non-logged operations (e.g. direct path loads) on the primary.
  • Improved automatic block repair.

Active Data Guard enhancements:

  • During switchover/failover the read-only sessions remain connected and become read/write after the Active Data Guard becomes
  • Primary. That avoids a reconnect strorm after the switchover/failover.
  • In-memory DB now possible on Active Data Guard. The columns defined for In-Memory can be different on Primary and STandby.
  • Support of Diagnostic Pack (AWR), Tuning Pack and SQL Plan Analyzer on the Standby System.
  • Passwd file on standby is automatically updated.
  • Standby-first encryption: Can encrypt tablespaces on standby first, switchover and then encrypt on old primary, so that encryption can be enabled without much downtime.

 

Nigel Bayliss: Upgrading to Oracle 12c without Pain.

Nigel talked about new 12.2 Optimizer features. In 12cR1 the Optimizer adaptive features (adaptive plans and adaptive statistics with SQL Plan directives) were controlled by 1 parameter: OPTIMIZER_ADAPTIVE_FEATURES. In 12cR2 the adaptive plans and adaptive statistics have their own parameters: OPTIMIZER_ADAPTIVE_PLANS (default TRUE) and OPTIMIZER_ADAPTIVE STATISTICS (default FALSE). I.e. in 12cR2 adaptive plans are enabled by default. SQL Plan Directives will still be created, but are not used by default. So the new default settings are closer to the 11g behavior as SQL Plan Directives are not used.
For migrations to 12cR2 Nigel provided specific cook books to follow to avoid plan changes initially (use SQL Plan Baselines to fix e.g. 11g plans) and then evolve to 12c.

Juan Loaiza: Oracle Database In-Memory: What’s New and What’s Coming

New features are:

  • Faster In-Memory joins: Join Groups can be defined. They specify columns, which are frequently used to join tables. The columns share the compression dictionary. The join occurrs on dictionary values rather than data: CREATE INMEMORY JOIN GROUP V_name_jg (VEHICLES(NAME), SALES(NAME)); That should bring up to 2.3 times faster join processing.
  • Precomputed expressions (e.g. Price + Price * Tax) can be cached In-Memory as user defined virtual columns. I.e. using such an expression in the query can gain from In-Memory data access.
  • In-Memory on Active Data Guard (see above).
  • In-Memory columnar format can be used on Exadata Flash Cache.
  • Data lifecycle management of In-memory data. I.e. policeis can be defined to evict cold data from the In_memory Column Store.
  • On engineered systems the IM column data can be persisted on storage. After a restart the data can be loaded faster in memory.
 

Cet article Oracle Open World 2016 – Day 2 est apparu en premier sur Blog dbi services.

Oracle 12cR2 Long Identifiers

Yann Neuhaus - Tue, 2016-09-20 01:14

This morning during Gerald Venzl presentation of “What’s New for Developers in the Next Generation of Oracle Database” at Oracle Open World, one feature has been acclaimed by a full room: 12.2 show the end of identifiers limited to 30 characters.

12.1

We knew it would happen because in 12.1 all data dictionary views have 128 bytes length character strings:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
 
SQL> desc dba_objects
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(128)
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(128)

but that’s only the dictionary metadata. Impossible to reach that limit:

SQL> create table "ThisIsAVeryLongNameThatIsAllowedInTwelveTwoC" as select * from dual;
create table "ThisIsAVeryLongNameThatIsAllowedInTwelveTwoC" as select * from dual
*
ERROR at line 1:
ORA-00972: identifier is too long

It is only annoying as the default column format do not fit in the screen:

SQL> select owner,object_name from dba_objects where object_type='TABLE';
 
OWNER
------------------------------------------------------------------------------------------------------------------------
OBJECT_NAME
------------------------------------------------------------------------------------------------------------------------

12.2

In 12.2 you can create longer identifiers:

SQL> create table "ThisIsAVeryLongNameThatIsAllowedInTwelveTwoC" as select * from dual;
Table created.
SQL> alter table "ThisIsAVeryLongNameThatIsAllowedInTwelveTwoC" add XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX number;
Table altered.

But be careful, the limit is in bytes – not in characters. If we have multibytes characters, the limit can be reached earlier:

SQL> alter table "ThisIsAVeryLongNameThatIsAllowedInTwelveTwoC" add X€XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX number;
alter table "ThisIsAVeryLongNameThatIsAllowedInTwelveTwoC" add X€XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX number
  *
ERROR at line 1:
ORA-00972: identifier is too long

So what?

The goal is not to abuse and put the longest names possible. But allowing more that 30 characters can be easier to match table names with Java class names for example.

Oracle 7

I wanted to show that those 30 characters limits was very old, so I ran a 7.3.3 oracle version that lies on my laptop and displayed the same describe of DBA_OBJECTS:
CaptureLongIdentifier
Identifiers were 30 characters there. But look at object name: those 128 bytes are there for more than 20 years!

 

Cet article Oracle 12cR2 Long Identifiers est apparu en premier sur Blog dbi services.

Oracle Open World 2016 – Day 1

Yann Neuhaus - Tue, 2016-09-20 00:29

Oracle Open World 2016 started on Sunday. The first day is always reserved for presentations provided by members of the various Oracle User Groups. However, the last part of the day is the first Keynote from Larry Elison. But let’s start by some of the sessions I visited Sunday:

Ludovica Caldara: Migrating to Oracle Databases 12c: 300 databases in 300 days.

Ludovica provided a presentation about the experience he gained during the migration project of 300 databases to 12c: Issues they faced and things to consider when migrating to 12c.
The main recommendations to avoid performance issues after the migration to 12c were related to SQL Plan Directives. I do not want to go into too much detail on the topic, but one issue Ludovica’s customer faced in terms of SQL Plan Directives was related to high CPU utilization at specific, fixed times when a system-job called the function DBMS_FEATURE_AWR. For details on this subject see here.
Other things to consider are the Oracle recommended patches from MOS-Note 2034610.1 (Things to Consider to Avoid Poor Performance or Wrong Results on 12.1.0.2).

Franck Pachot: Single-Tenant Oracle Database 12c: Multitenant Features for All Editions

In his excellent session Franck presented about some good reasons to go to Single-Tenant databases instead of running the deprecated Non-Container databases (i.e. the only way DBs could be run up to 11gR2 with 1 DB per Instance). Among other things the possibility to transport a database to another machine by un-plug and plug-in and 12.2.-security features were mentioned (use of the new lockdown profile, which can e.g. disable database options for a pluggable database).

Mauro Pagano: SQLd360: SQL Tuning Diagnostics Made Easy

Being very excited about the free software SQLd360 Mauro developed (see here), he enthusiastically presented the history of tuning single SQL-statements during the various phases of available tools and database features:

  • 1998, when not much data was available about the history of a SQL-statement
  • 2007, when SQLTXPLAIN became very popular
  • today with the availability of SQL_MONITOR and Active Session History

Bottomline is that SQLd360 should be the tool to use today to tune a single SQL-statement, because of various advantages compared to SQLT(XPLAIN) (took the following list from here):

  • not necessary to install something on the database
  • SQLd360 is 100% free software, while SQLT requires a My Oracle Support (MOS) account, and some consultants and third parties may struggle to obtain a valid login for MOS or would have to use their client’s credentials.
  • SQLd360 makes use of newer technologies including Google Charts, presenting the metadata in a very “Wow!” way, while SQLT focuses on HTML tables.
  • SQLd360 is 13X smaller in terms of lines of code, and it pretty much does the same job as SQLT
  • SQLd360 is much faster to execute than SQLT.

Sunday Keynote by Larry Ellison:

Remark: I do not talk about the Cloud here (almost all of the Keynote was news about Oracle’s Cloud), as I want to concentrate on what’s coming on the DB-side.

First info on Oracle DB 12c Release 2:

  • Multitenant
    Agility with on-line clones and on-line relocate
    4095 PDBs possible (255 in 12.1)
  • Sharding: A shared nothing architecture where databases on different nodes form a logical database.
    It provides elastic scalability with native sharding for global-scale applications.
  • In-Memory
    Column-Store on Active Dataguard
    Increased performance (up to 60x faster than 12.1)
 

Cet article Oracle Open World 2016 – Day 1 est apparu en premier sur Blog dbi services.

Slides Available - End-to-End Cloud: Oracle Java Cloud, Oracle Mobile Cloud Service, Oracle MAF, and Oracle JET [CON2388]

Andrejus Baranovski - Mon, 2016-09-19 17:03
I have completed my OOW'16 session [CON2388] today. For those of you who could not attend it, check slides online (I will post sample code later, read more about the session here):


Monday at OpenWorld and JavaOne

OTN TechBlog - Mon, 2016-09-19 15:12

Today marks the first day for the Java Hub starting at 9:30 am in the Hilton and day two of the OTN Lounge in Moscone South opening at 10 am.

As we continue our OTN Lounge activities, the Community Cast is in full swing starting at 9 am and running throughout the day. Click here to see what you may have missed yesterday, including our OTN Women in Technology (#OTNWIT), and Oracle ACEs and technology experts sharing new Oracle technologies and innovation. We also have live streaming at JavaOne throughout the day.

The Community Kiosk will be open 10:30-5. Learn about the latest community platform updates and features with how to earn even more points. Or stop by our ACE Program Kiosk with the chance to learn more about how to become an ACE and how this can help you gain community recognition for sharing your knowledge and expertise.

Want to make a difference with a selfie? Stop by the OTN Lounge or Java Hub for your sticker, post a selfie with the sticker on Twitter or Instagram using the hashtag #DevelopersRule. For each post Oracle will donate $10 to Girls Who Code.

  • Click here to find out the activities for Middleware.

o Highlights include sessions/events for those interested in cloud, middleware, business intelligence, development tools, and beyond.

  • Visit the Systems blog for Monday’s sessions and Community Casts.
  • Learn more of the activities going on at the Java Hub.
Normal 0 false false false EN-US JA X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0in; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

Monday at Oracle OpenWorld 2016

WebCenter Team - Mon, 2016-09-19 11:47
Normal 0 false false false EN-US X-NONE X-NONE

Once you have picked up your badges and as you are thinking of which direction to head in, remember you have the https://sites.oracle.com/oowdx/ handy on your mobile browser to keep a pulse on what’s happening and where. The site is also handy in getting a good glimpse on what’s coming up next!

And just for you, here’s quick glance at some of the sessions you might be interested in today:

Monday, September 19, 2016

Content and Experience Management: Roadmap and Vision [CON7256]
David Le Strat, Senior Director, Oracle
11:00 a.m. | Moscone West 2014

Oracle Integrated Cloud—Strategy/Vision for Journey to Cloud Transformation [GEN1806]
Steve Daheb, Sr. Vice President, PaaS & IaaS Business Groups, Oracle
12:30 p.m. | Moscone South 103

Content Management in the Cloud: Strategy & Roadmap [CON7257]
Thyaga Vasudevan, Senior Director, Product Management, Oracle
Edi Piovezani, Diretor de Tecnologia, Omni Financeira
Daniel Martins, Programmer / Developer, Accurate Software Ltda
12:30 p.m. - 1:15 p.m. | Moscone West—2014

Digital Experience in the Cloud: Strategy & Roadmap [CON7258]
Igor Polyakov, Sr Principle Product Manager, Oracle
Mariam Tariq, Sr Director Product Management, Oracle
1:45 p.m. - 2:30 p.m. | Moscone West—3000

Create an Employee Portal Using Oracle Documents Cloud Service/Oracle Sites Cloud Service [HOL7607]
2:30 p.m. - 3:30 p.m. | Hotel Nikko—Nikko Ballroom II (3rd Floor)

Scaling Innovation with Oracle Cloud Platform for Middleware—Roadmap/Vision [GEN7006]
Inderjeet Singh, EVP, Fusion Middleware Development, Oracle
4:15 p.m. | Moscone South 103

Hope to see you at these sessions. We encourage you to tweet along with #OOW16 and #OracleDX hashtags. And, see your tweets on https://sites.oracle.com/oowdx/

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Calibri","sans-serif";}

Oracle Database 12.2 – PDBaaS

Yann Neuhaus - Mon, 2016-09-19 10:27

It’s official, Larry Ellison made the annoucement at first keynote and the database product team at oracle has released the version and the documentation publicly. Oracle Database Exadata Express Cloud Service is the ‘Cloud First’ environment for 12.2

Documentation

Documentation is there: Cloud > Platform > Data Management > Exadata Express
The 12.2 new features available in that ‘Cloud First’ are documented here

Cloud First

We knew it, 12.2 comes ‘Cloud First’ which means that you cannot download it but you can use it on a Cloud Service. This is in my opinion a very good idea. We will not upgrade all our databases to 12.2 so it’s beter to test it and cloud services are good for that.
However the way it is released is quite limited:

  • There is no free trial. You have to pay for the minimum service to test it (175$/month)
  • Features are very limited because the service is a PDB, not a full database
PDBaaS

This Oracle Database Exadata Express Cloud Service is a fully managed service, wich means that you are not the database administrator. Oracle manages the system, creates and administrate the database. You are a user.
Actually, when you create a service, a Pluggable Database is provisioned for you and you access only this PDB. It addition to that, for security reason, all features that may interact with the other PDBs or the system, are locked down. For example, you cannot use Data Pump because it writes files on the server. All limitations are documented here.
If you wonder how those limitations are implemented, it’s a new 12.2 multitenant feature called lockdown profiles, and resource manager that can isolate PDB memory. I presented that yesterday at Oracle Open World and there is more information about it in new book to come.

Options

Features are limited but you have most of options available: In-Memory, Data Mining, Advanced Compression and Hybrid Columnar Compression, Data Redaction, etc. And it’s an Exadata behind so you have SmartScan.

You can think of it as the ‘Schema as a Service’, but with a PDB instead of a schema.

You access to it only through SQL*Net (encrypted) and can move data to and from using SQLDeveloper.

Shapes

When you see ‘Exadata’, ‘In-Memory’, and all those options, you probably think about a service for very big database and high CPU resources. But it is not. This service is for evaluation of the 12.2, testing, developement, training on very small databases (few hundred of GB). And only one OCPU (which is an intel core with two threads). It’s hard to imagine more than one user on this. Maximum memory being 5GB it’s also hard to imagine In-Memory here.

So the goal is clearly to test feature, not to run workloads. You can go live with it only if your production is not critical at all (database is backed up daily).

Express

The ‘Express’ part is the simplicity. Prices are easy to calculate:

  • 175$/month for 20GB of storage and one OCPU. This is ‘X20′ service.
  • Next level is the ‘X50′ service at 750$/month, so x2.5 times the storage for x4.2 the price. Still one OCPU.
  • Highest level is ‘X50IM’ at 950$/month, which is the same but with larger memory.
Non-Metered

It is a non-metered service: whether you use it or not you pay per month. But don’t think you can do whatever you want within that month as the transfer of data is limited. You can transfer the volume of the database only a few times per month.

So what?

The utilization is simple: you don’t need a DBA. This is the main point: automation and fast provisioning.
Developers will love that. Giving them full options is a good marketing idea. Once the application is designed to use In-Memory, Compression, etc. theses options will be required for production as well.

Today, developers need more agility and are often slowed down by the operations. And that’s a major reason why they go to other products that they can install and use themselves easily: Postgres, Cassandra, MongoDB, etc. Oracle Database is to fat for that: look at the time you need to create a database, catalog, catproc, etc. A first answer was the Oracle XE edition which is easy to install anywhere. Now with this Express Cloud Service Oracle gives to possibility to provision a small database in minutes which requires no further administration.
Actually, this is the whole idea behind the multitenant architecture: consolidate all those system objects created by catalog/catprocg into a common location (CDB$ROOT) and have light PDBs with only user data.

Final remark. Currently 12.2 is available on on that service but there are no doubts that a full 12.2 will come within the next months.

 

Cet article Oracle Database 12.2 – PDBaaS est apparu en premier sur Blog dbi services.

SQL Server 2016: Dynamic Data Masking and database role

Yann Neuhaus - Mon, 2016-09-19 10:19

Last week, dbi services organized an event named “SQL Server 2016: what’s new?” in Lausanne, Basel and Zurich. I would take the opportunity to say again a big thank you to everyone which joined us.
During my session some questions concerning the new functionality Dynamic Data Masking were asked. In fact data are masked for some roles and not for some others.
Let’s try to clarify that.

I will use the same script I used during the event to initialize the database, create the table and fill-in my table with some rows:

-- Create database
USE MASTER
GO
CREATE DATABASE DDM_TEST
GO

-- Create the Confidential table
USE [DDM_TEST]
GO

CREATE TABLE [dbo].[Confidential](
[ID] [int] NULL,
[Name] [nvarchar](70)NULL,
[CreditCard] [varchar](16)NULL,
[Salary] [int] NULL,
[Email] [nvarchar](60)NULL
)ON [PRIMARY]

-- Insert some rows
INSERT INTO [dbo].[Confidential] VALUES ('1','Stephane','3546748598467584',113459,'sts@dbi-services.com')
INSERT INTO [dbo].[Confidential] VALUES ('2','David','3546746598450989',143576,'dab@dbi-services.com')
INSERT INTO [dbo].[Confidential] VALUES ('3','Nathan','3890098321457893',118900,'nac@dbi-services.com')
INSERT INTO [dbo].[Confidential] VALUES ('4','Olivier','3564890234785612',98000,'olt@dbi-services.com')
INSERT INTO [dbo].[Confidential] VALUES ('5','Alain','9897436900989342',85900,'ala@dbi-services.com')
INSERT INTO [dbo].[Confidential] VALUES ('6','Fabrice','9083234689021340',102345,'fad@dbi-services.com')

I will create some masks for confidential columns with the following script:

-- create data masking for confidential columns with masking functions
USE DDM_TEST
GO

ALTER Table Confidential
ALTER COLUMN Salary ADD MASKED WITH (FUNCTION = 'random(1, 150000)')
ALTER Table Confidential
ALTER COLUMN CreditCard ADD MASKED WITH (FUNCTION='partial(1,"XXXX",2)')
ALTER Table Confidential
ALTER COLUMN Email ADD MASKED WITH (FUNCTION='email()')

I create now a user and add him to db_datareader role:

-- Create a user named TestDemo and add this user to the db_datareader role
USE DDM_TEST
go
CREATE USER TestDemo WITHOUT LOGIN
USE [DDM_TEST]
GO
ALTER ROLE [db_datareader] ADD MEMBER [TestDemo]
GO

Let’s try to visualize the Confidential table with my user:

DDM_res1

Member of the db_datareader role are able to query the Confidential table but cannot see masked columns without masks.
Let’s try to add my user to the db_datawriter role and rerun my query:

DDM_res2

Same, and it’s normal as db_datawriter cannot change read possibility, but the user is now able to insert data in the Condifendial table like this for example:

DDM_res3

But, it cannot view in clear text data that it has inserted.
The only way to visualize data without masks is to be a member of the db_owner role:

DDM_res4

Conclusion is clear, in order to be able to view masked columns user has to be member of the db_owner role in the database containing the table.
Happy masking ;-)

 

Cet article SQL Server 2016: Dynamic Data Masking and database role est apparu en premier sur Blog dbi services.

Analysing Social Media Data for the Lightyear Foundation - Part 2

Rittman Mead Consulting - Mon, 2016-09-19 09:57

In my last post, I described the basics around connecting to social media data sources using Python. This is in aid of collating information for the Lightyear Foundation, a charity specialising in science education in the UK and Ghana. In this blog, I will demonstrate how to use those integrations to record data into a PostgreSQL database. I've chosen this database in so as to keep everything free and open source.

One of the downsides with some of the publicly available APIs is that they only store a certain amount of history. These makes analysing long term trends a bit more difficult. By recording the data periodically, in an ETL-like fashion, we can circumvent this. Given the vast amount of data available for social media it would not be appropriate to store all of the data in a relational database. Instead, we can store summary statistics for long term trend analysis.

All of the code used in this blog is on this public Git repository. You are welcome to download this and poke around as you follow the blog. Note that there is configuration in config.ini and a keys/google-api.json file required in order to get these working yourself.

Database Integration

The Python module psycopg2 was used to execute transactions against the PostgreSQL database with Python. The script lyf/psql.sql contains a host of functions I wrote to perform useful database and ETL actions.

  • psql.truncate : Truncates a table.
  • psql.insert : Inserts a single row to a table.
  • psql.upsert : Updates a row to a table if a matching key is found, else inserts the row.
  • psql.update : Updates values in a table based on matching keys.
  • psql.delete : Deletes rows from a table based on a WHERE clause.
  • psql.lookup : Updates columns based on a lookup to another table. Useful for assigning foreign keys from natural keys.
  • psql.load_csv : Loads data from a CSV file into a table, mapping header names in the file to columns in the table.
  • psql.query : Executes a SQL statement and returns the data.
Google Analytics

For Google Analytics (GA), there is availability of many dimensions and metrics but I have chosen merely a useful subset to put into a star schema.

Dimensions

For efficiency, I wrote a method to dynamically load dimension tables from a tsv file.

table    ga_dims columns keys  
d_ga_source    "ga:sourceMedium,ga:source,ga:medium,ga:socialNetwork"  "source_medium,source,medium,social_network"    "source_medium"  
d_ga_platform    "ga:operatingSystem,ga:deviceCategory,ga:operatingSystemVersion"    "os,device_category,os_version" "os,device_category,os_version"  
d_ga_geo    "ga:continent,ga:subContinent,ga:country,ga:countryIsoCode,ga:region,ga:cityId,ga:city" "continent,sub_continent,country,country_code,region,city_id,city"  "city_id"  
d_ga_page    "ga:pageTitle"  "page_title"    "page_title"  

The column table refers to the table name in the PostgreSQL schema, which are created manually before executing the script. ga_dims is a comma separated list of GA dimension codes. Note that this is an upper limit of 7 dimensions allowed for a GA API query. columns is another list of equal length describing the mapping to the columns in the database table. Finally keys is a comma separated list of which columns are unique natural keys for the database table. This is so the script can perform updates as well as inserts.

This input file is parsed by load_ga_dims.py which executes a Google API query for each dimension and upserts the records into the database. Essentially, the ETL for this process is defined quite simply by the TSV file and can be changed with relative ease. It doesn't have the scope, flexibility or scale as ODI or Informatica, but for a quick, free version it will suffice.

Fact

The fact table is much simpler to load as we just need to execute a single GA query which specifies only the dimension natural keys and the metrics. The script load_ga_fact.py will go and fetch the dimension warehouse key (always integer) as well as any metrics specified in the file. I've opted for:

  • Sessions
  • Bounces
  • Bounce Rate
  • Average Session Duration
  • Session Duration
  • Page Views
  • Time on Page

Finally there is an integer date ID and some denormalised attributes: Longitude and Latitude. With Google its easy to retrieve a "full load" as the API allows querying of history as well as incremental loads which filtered for today's date. Below is an example query returning the total session time and number of sessions by continent for Jan 2016:

select  
    dt.year_month, 
    geo.continent, 
    sum(session_duration) as total_time, 
    sum(ga.sessions) as sessions
from  
    f_ga_daily ga
    inner join d_ga_geo geo on geo.geo_id = ga.geo_id
    inner join d_date dt on dt.date_id = ga.date_id
where dt.yyyymm = 201601  
group by dt.year_month, geo.continent  
order by dt.year_month;  

Sessions by Continent

Facebook

The extract I wrote for Facebook was much simpler, using date as the sole dimension. If required, dimension tables could be created for posts and videos or other similar data, but in this case we just want to look at trends over time. The measures selected are:

  • Total Likes
  • Total Posts
  • Total Videos
  • Total Video Likes
  • New Posts
  • New Videos
  • Impressions
  • Reach
  • Engaged Users
  • New Likes
  • New Unlikes
  • Video Views
  • Page Views
  • Post Likes

There's no way of extracting history data from Facebook's API, so we need to load data regularly using f_facebook_daily.py. Below is a time series query of likes and reach for a few days:

select  
    dt.date, 
    sum(total_likes) total_likes,
    sum(new_likes) likes, 
    sum(engaged_users) engaged_users,
    sum(reach) reach from
f_facebook_daily fb inner join d_date dt on dt.date_id = fb.date_id  
group by date  
order by 1;  

Time Series - Facebook

Twitter

The Twitter API is not as rich as the Google or Facebook APIs and is limited to only 15 queries an hour. For my ETL scripts this shouldn't matter, but once again no history is available. The script for this load is f_twitter_daily.py. The measures we've got are:

  • Total Followers
  • Total Following
  • Total Tweets
  • Followers
  • Following
  • Tweets
select  
    dt.date, 
    sum(total_followers) total_followers,
    sum(total_following) total_following, 
    sum(total_tweets) total_tweets,
    sum(tweets) tweets from
f_twitter_daily tw inner join d_date dt on dt.date_id = tw.date_id  
group by date  
order by 1;  

Time Series - Twitter

YouTube

The data for videos and views over time are stored in a flatten fact table. Given the small number of attributes for videos and the lack of interconnectivity with the other information, I just denormalised on them onto the fact table. For measures we have:

  • Total Views
  • Views
  • Total Likes
  • Likes
  • Total Dislikes
  • Dislikes

Once again this is loaded incrementally, storing records for each video for each day. The incremental loading script is f_youtube_daily.py. The below query shows how many views the videos got by month:

select  
    dt.year_month,
    sum(yt.views) views
from  
    f_youtube_daily yt
    inner join d_date dt on dt.date_id = yt.date_id
group by dt.year_month  
order by 1, 2;  

Video Views By Month

MailChimp

The MailChimp API allows extraction of information about subscriber lists and campaigns. f_mc_lists_daily.py will load in today's fact data as well as updating the subscriber list dimension. The measures include:

  • Members
  • Unsubscribed
  • Cleaned
  • Total Members
  • Total Unsubscribed
  • Total Cleaned
  • Total Campaigns
  • Open Rate
  • Average Subscribe Rate

Below is an example query showing a snapshot of the subscriber list data as of 9th September 2016.

select  
    dt.date,
    ml.name,
    sum(mc.total_members) total_members,
    sum(mc.total_campaigns) total_compaigns,
    avg(mc.open_rate) open_rate
from  
    f_mc_lists_daily mc
    inner join d_date dt on dt.date_id = mc.date_id
    inner join d_mc_lists ml on ml.list_id = mc.list_id
where date = '2016-09-09'  
group by dt.date, ml.name  
order by 1, 2;  

Subscriber List Snapshot

Summary

Now we've got all these different facts, we can write BI style summary queries to compare all of the data, or provide regular reports. This is a query across multiple fact tables conforming on the date dimension. It shows summary statistics for each fact per month.

with  
ga as  
(
    select dt.year_month, sum(ga.sessions) as sessions, avg(ga.avg_session_duration) as avg_session_duration
    from
        f_ga_daily ga
        inner join d_date dt on dt.date_id = ga.date_id
    where dt.year = 2016
    group by dt.year_month
    order by 1
),
fb as  
(
    select dt.year_month, last(total_likes) as total_likes, sum(fb.reach) as reach
    from
        f_facebook_daily fb
        inner join d_date dt on dt.date_id = fb.date_id
    where dt.year = 2016
    group by dt.year_month
    order by 1
),
tw as  
(
    select dt.year_month, last(total_followers) as total_followers
    from f_twitter_daily tw
    inner join d_date dt on dt.date_id = tw.date_id
    where dt.year = 2016
    group by dt.year_month
    order by 1
),
yt as  
(
    select dt.year_month, sum(views) as views, last(total_views) as total_views
    from
        f_youtube_daily yt
        inner join d_date dt on dt.date_id = yt.date_id
    where dt.year = 2016
    group by dt.year_month
    order by 1
)    
select  
ga.year_month, ga.sessions as web_views, ga.avg_session_duration as avg_web_view_dur, fb.reach as fb_reach,  
fb.total_likes as fb_likes, tw.total_followers as twitter_followers, yt.total_views as total_yt_views, yt.views as yt_views  
from  
ga  
    inner join fb on ga.year_month = fb.year_month
    inner join tw on ga.year_month = tw.year_month
    inner join yt on ga.year_month = yt.year_month;

Summary

So there we have it, a open-sourced ETL package for a handful of social media sites that will track history. The final tables can be used as a source for any reporting tools you want, and the data can all be tied together by date. This is particularly useful for showing summary trends over time. However, I don't store even a fraction of the amount of data that we can get in real time from the APIs. The next blog entry will show how to use open source technologies to visualise this data as well as the real time information.

Categories: BI & Warehousing

#OOW16 #OPN Cloud Managed Service Provider Program

As #OOW16 is currently in progress with a lot of new things and announcements still coming up, Oracle Partner Network yesterday announced the new Oracle Cloud Managed Service Provider (MSP) Program,...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Oracle Transforms the Cloud Infrastructure Market

Oracle Press Releases - Mon, 2016-09-19 07:10
Press Release
Oracle Transforms the Cloud Infrastructure Market New Cloud services deliver unparalleled choice, performance and flexibility

Oracle OpenWorld, San Francisco, Calif.—Sep 19, 2016

Oracle today introduced the broadest array of Infrastructure-as-a-Service (IaaS) offerings in the industry, which include bare metal cloud servers that are 11.5X faster and 20 percent cheaper than the fastest solution offered by the competition. The new additions to the Oracle Cloud Platform enable customers to get the best of both multi-tenant and single-tenant environments and include Oracle Bare Metal Cloud Services, Oracle Ravello Cloud Service, Oracle Container Cloud Service and enhancements to existing Oracle Cloud services.

While the business benefits of the public cloud are increasingly clear, organizations face a myriad of performance, security and management concerns that mean they can’t simply abandon all of their existing IT practices and move all workloads to a multi-tenant cloud world. The latest enhancements to Oracle’s IaaS portfolio help organizations address this challenge by providing the ability to harness the benefits of Cloud while retaining many of the benefits provided by a corporate data center.

Oracle Bare Metal Cloud Services are a high-scale public cloud offering and include bare metal cloud servers in a fully virtualized network environment. The innovative new services deliver high performance database-as-service, network block storage, object storage and VPN connectivity. In addition, Oracle Bare Metal Cloud Services provide a secure, private and high-performance software defined Virtual Cloud Network (VCN) that allows customers to treat Oracle Bare Metal Cloud Services as a secure and elastic extension of their on-premise network. Additionally, Oracle Bare Metal Cloud Services maximize network throughput by providing direct connectivity between compute and storage nodes.

The regional deployment of Oracle Bare Metal Cloud Services consists of three completely fault-independent availability domains, enabling customers to build high availability, high durability applications in the Cloud. Oracle Bare Metal Cloud Services seamlessly interoperates with existing Oracle Cloud Platform offerings, helping customers build mission critical applications that take full advantage of available services on the Oracle Cloud.

Built on the foundation of the most modern datacenter, network and server infrastructure, the Oracle Bare Metal Services are designed with a fundamentally differentiated approach to Cloud platform development that gives customers choice and flexibility on their journey to the Cloud. This included ultra-dense compute servers that provide the industry’s best performance for enterprise workloads as well as the highest IOPS and the highest bandwidth storage servers available anywhere in public cloud offerings. As a result, Oracle customers can achieve 10X the throughput and IOPS of the best offering on competing Clouds, at a lower price. In addition to high performance, by not having software run on the compute hosts, Oracle is able to reduce potential points and deliver the best possible security available in Cloud.

Further extending the Oracle Cloud Platform, Oracle also announced Oracle Ravello Cloud Service, the general availability of Oracle Container Cloud Service and several significant enhancements to existing Oracle IaaS offerings.  

Oracle Ravello Cloud Service is the first cloud service in the industry that enables organizations to take enterprise VMware and Kernel-based Virtual Machine (KVM) workloads and run them in the public cloud without any changes. With Oracle Ravello Cloud Service, customers can run VMware natively on public cloud without requiring VM conversion, application reconfiguration or networking changes. It is also the only service in the industry that allows enterprises to have full L2 and L3 networking flexibility in the public cloud.

Oracle Container Cloud Service provides organizations with a Docker-compatible way to deploy application stacks with a single click. Registry integration capabilities, enterprise-grade application orchestration, and application scheduling and service scaling capabilities make the Oracle Container Cloud Service a uniquely compelling option for cloud developers.

Oracle has also introduced Oracle FastConnect – Standard and Partner editions – to help customers reliably and securely connect their datacenter to the Cloud. With the addition of Oracle FastConnect, Oracle now offers some of the broadest connectivity and peering options available in the industry, including IPsec VPN for easy setup, MPLS to connect to existing enterprise networks and Fast Connect for quick peering.

Oracle Cloud Platform offerings now also support Oracle MySQL Cloud Service, Oracle Big Data Cloud Service and Oracle Event Hub Cloud Service in addition to unparalleled support for Oracle’s existing Platform-as-a-Service offerings.

“As more and more enterprises leverage the Cloud, they want a simple, seamless way to migrate their large and complex IT infrastructures to the Cloud, and to use the security and management controls that their IT teams already know,” said Thomas Kurian, president of product development, Oracle. “The latest additions to the Oracle Cloud Platform enable organizations to seamlessly connect their existing resources to the Oracle Cloud using Virtual Cloud Network (VCN) and select from a wide variety of compute services including bare metal, virtual machines and engineered systems as if it were a part of their own datacenter.”

“We have been very impressed by how easy it is to use Oracle’s Bare Metal Cloud Services. The DataStax Enterprise clusters we’ve deployed are running blazingly fast, with sub-micro second latency, and these are key business drivers for us,” says Ben Lackey, lead partner at DataStax. “Additionally, the multiple availability domains per region, allows us to bring our mission critical, high availability workloads to Oracle’s Bare Metal Cloud.”

“We are excited about the results we are seeing with Oracle’s Bare Metal Cloud, with regard to the architecture, performance and scalability,” said Patrick Sullivan, managing partner and Oracle global technology lead at Accenture. "This enhances our clients’ ability to accelerate their journey to the Cloud.”

For more information, please visit us at http://cloud.oracle.com.

Contact Info
Alex Shapiro
Oracle
+1.650.607.1591
alex.shapiro@oracle.com
About Oracle

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

About Oracle OpenWorld

Oracle OpenWorld, the industry’s most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,200 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. Oracle OpenWorld 2016 is being held September 18 – September 22 at Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

About JavaOne

The JavaOne conference brings together Java experts and enthusiasts for an extraordinary week of learning and networking focused entirely on all things Java. With more than 440 sessions covering topics that span the breadth of the Java universe, keynotes from foremost Java visionaries, tutorials, and expert-led hands-on learning opportunities, JavaOne is the world's most important event for the Java community. Join the JavaOne discussion on Twitter.

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Alex Shapiro

  • +1.650.607.1591

Oracle Unveils Unmatched Cloud Platform Based on #1 Database and #1 Middleware to Accelerate Move of Enterprise IT to the Cloud

Oracle Press Releases - Mon, 2016-09-19 07:08
Press Release
Oracle Unveils Unmatched Cloud Platform Based on #1 Database and #1 Middleware to Accelerate Move of Enterprise IT to the Cloud New Database-as-a-Service and Platform-as-a-Service offerings make it easier to move, secure and optimize workloads, development and data in the cloud

Fully compatible from entry-level to the largest critical database workloads

Oracle OpenWorld, San Francisco, Calif.—Sep 19, 2016

Oracle today announced a series of major innovations across the Oracle Cloud Platform that are designed to give organizations the confidence they need to run their most critical applications in the Cloud. At the heart of Oracle’s Platform-as-a-Service (PaaS) is Oracle’s new Database-as-a-Service (DBaaS) based on Oracle Database 12c Release 2. Oracle’s new database is being made available in the Cloud first, providing businesses of all sizes with access to the world’s fastest, most scalable and reliable database technology in a cost-effective and flexible Cloud environment.

For nearly 40 years, more than 300,000 customers have trusted Oracle database technology to run database applications. Today, Oracle is bringing that speed, scale and reliability to the Cloud with a new DBaaS offering. Oracle Database 12c Release 2 is fully compatible from entry-level to the largest database workloads and enables businesses to take advantage of on-premise-grade capabilities to run database development, small to mid-sized business and departmental applications, as well as enterprise applications in the Cloud.

Oracle today also unveiled new enhancements and Oracle Cloud Platform offerings including comprehensive tools for all application development models. This includes simplified migration and extension of enterprise workloads in the Cloud, tools for Cloud native, and low-code development. PaaS enhancements unveiled today also include nineteen new Cloud services including: Container Cloud Service, Oracle Identity Cloud Service, Oracle Internet of Things Cloud Service, Big Data Cloud Services and Oracle Analytics Cloud Services.

Today’s announcements by Oracle come at a time when many organizations have found themselves wanting to leverage the cost and simplicity of the Cloud but have yet to make the move. Concerns about security, scale and complexity, uncertain migration paths, fragmented toolsets, and inconsistent user experiences have left many businesses sitting on the sidelines in search of a Cloud offering with the on-premise-grade capabilities enterprise IT requires. With today’s announcements, Oracle is delivering the end-to-end capabilities enterprises need to take full advantage of the Cloud.

“Oracle Cloud Platform enables developers, IT, and line of business leaders to easily leverage the Cloud for any workload,” said Thomas Kurian, president of Oracle product development. “Oracle Cloud Platform offers an integrated offering across IaaS, PaaS, and SaaS, because that’s what the enterprise customer demands. Oracle makes it easy to run our open standards based Platform as a Service in the public cloud with high performance and availability.”

Next Generation Database-as-a-Service

Today’s release of Oracle’s world’s number one database, Oracle Database 12c Release 2, coming first in the Cloud, marks a new era of magnitude and innovation for the enterprise. Building on its unique multi-tenant architecture and in-memory technology, Oracle’s flagship database is poised to exceed today’s requirements and future-proof enterprise against the exponential data sprawl of tomorrow with faster analytics workloads and unrivalled support for database magnitudes up to hundreds of terabytes.

Oracle Database will also help reinvent productivity for DevOps while bolstering security by enabling rapid setup and teardown of new databases as well as advanced configuration to combine the world-class performance of Oracle Exadata engineered systems with Oracle’s unique pluggable database technology. This next-generation standard of performance is now available as an entry-level solution for small to medium sized databases in production, development and testing—starting at just $175 per month with Oracle Exadata Express Cloud Service.

For enterprises to build on top of the world’s number one database, Oracle today released a range of new PaaS services that make it easier to develop, move, manage and connect in the Cloud.

New Approaches for Cloud Application Developers

With Oracle PaaS, developers have more choice than ever to develop on-premise or in the Cloud, using a variety of languages and services. Oracle’s Application Container Cloud Service now includes support for PHP, along with Node.js and Java. Applications composed from multiple PaaS services can be created, scaled and managed as a single unit with the new Oracle Cloud Stack Manager. In addition, enterprises can migrate Java EE apps to the Cloud automatically using Oracle AppToCloud while adding capabilities like active standby and increasing cluster size as the application is moved to the Cloud. Anyone can author complete applications from a browser without coding skills, using the Oracle Application Builder Cloud Service low-code development platform to extend services with pre-populated Oracle Software-as-a-Service APIs or custom services from a common REST API catalog.

Oracle Developer Cloud Service also makes collaboration between developers easier by integrating with popular collaboration tools like Slack, Hipchat, Hashicorp's Packer and Terraform and including agile management features for managing sprints, tasks and backlogs.

Oracle Mobile Cloud Service now provides actionable insights and engagement across multi-channels and micro locations to improve the customer experience. It also provides an intelligent and contextual Chatbots experience across multiple messaging channels like Facebook Messenger, Slack, Kik and others.

Proactive Cloud Security with Identity and Analytics

Oracle Identity Cloud Service is a new Cloud-native security and identity platform that quickly integrates with Cloud applications using open standards and allows user identities to be managed across Cloud and on-premise deployments.

Security is further enhanced with the new Oracle Security Monitoring and Analytics Cloud Service in the new Oracle Management Cloud that uses machine learning to help identify threats and provide early warnings. Oracle Management Cloud is the first fully integrated tool to manage the lifecycle of enterprise applications. It uses machine learning to monitor and analyze end-to-end operational data across heterogeneous environments, detect anomalies and help ensure performance and compliance.

Simplifying Application and Data Integration across Multiple Clouds and On-Premise

Developers can use Oracle API Platform Cloud Service to create, secure and manage their APIs with zero code and pre-built analytics charts, while being able to run the API gateway within the Oracle Cloud, on-premise or on third party clouds. Zero-code orchestration for Cloud to on-premise integration is also now available with Oracle Integration Cloud Service which includes more than fifty pre-built adapters for apps including Ariba, Concur, LinkedIn, Salesforce, Slack, Twilio, Twitter and more.

Oracle’s Data Integration Cloud Service offers streaming replication and extract, transform and load capabilities for a variety of use cases including data migration and to support data warehouse style workloads that move data across PaaS, including Oracle Database as a service, Oracle Big Data Cloud Service, and even non-Oracle DBaaS. Oracle Data Integration Cloud includes a unified design environment for developing MapReduce transformations, transforming structured data and developing Hive-based transformations, all in a single utility. Oracle delivers an industry first in its ability to replicate data in near real-time or in batches from on-premise to the Cloud or from one Cloud to another.

Using Oracle Internet of Things Cloud Service, customers can deploy out-of-the-box IoT applications such as Asset Monitoring, Production Monitoring, Fleet Monitoring or Connected Worker. The IoT Cloud service delivers simplified connectivity through device virtualization, streaming and predictive analytics. This combines in-motion data collected from devices, at-rest contextual data residing in the ERP and CRM applications and pre-existing integrations with business applications like Oracle Service Cloud, Oracle E-Business Suite, Oracle’s JD Edwards and Oracle’s PeopleSoft.

Big Data and Analytics Unleashed in the Cloud

Oracle Big Data Cloud Services adds many new services and capabilities including support for Apache Hadoop, Apache Spark, Apache Kafka, and NoSQL technology. Oracle Big Data Cloud Service Compute Edition is a fully managed, elastic service, providing a platform for big data management and analytics. Oracle Event Hub Cloud Service is a fully managed, elastic service that supports the loading, processing and analysis of streaming data and the development and deployment of streaming applications. Oracle DataFlow ML Cloud Service supports streaming and batch data movement and transformations, with machine learning recommendations for mapping, profiling, and enriching big data. Oracle NoSQL Database Cloud Service delivers predictable high performance for the most demanding NoSQL applications. Finally, Oracle Big Data SQL Cloud Service offers one fast SQL query on all big data stored in Hadoop, multiple NoSQL databases and Oracle Database.

Oracle Analytics Cloud lets enterprise empower anyone to ask any question of any data using any device, in the Cloud, on-premise, or both. This includes Oracle Essbase Cloud Service, a new Cloud solution that enables enterprises to transform unreliable spreadsheet-based processes into streamlined collaborative models in minutes. Adding to rich visualization and self-service discovery capabilities, Oracle Data Visualization Cloud Service now interprets data to automatically create smart insights and make business more productive. It includes smart data connectors to more than 40 sources, self-service data preparation and packaged analytic applications for sales, marketing, human resources and finance.

Contact Info
Alex Shapiro
Oracle
+1.650.607.1591
alex.shapiro@oracle.com
About Oracle

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

About Oracle OpenWorld

Oracle OpenWorld, the industry’s most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,200 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. Oracle OpenWorld 2016 is being held September 18 – September 22 at Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

About JavaOne

The JavaOne conference brings together Java experts and enthusiasts for an extraordinary week of learning and networking focused entirely on all things Java. With more than 440 sessions covering topics that span the breadth of the Java universe, keynotes from foremost Java visionaries, tutorials, and expert-led hands-on learning opportunities, JavaOne is the world's most important event for the Java community. Join the JavaOne discussion on Twitter.

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Alex Shapiro

  • +1.650.607.1591

Oracle Unveils Its Next Generation Cloud Strategy: Intelligent Applications

Oracle Press Releases - Mon, 2016-09-19 07:06
Press Release
Oracle Unveils Its Next Generation Cloud Strategy: Intelligent Applications Oracle adds to its industry leading Cloud portfolio with new SaaS Cloud services and enhancements

Oracle OpenWorld, San Francisco, Calif.—Sep 19, 2016

Building on its position as the industry’s leading Cloud Applications provider, Oracle today unveiled its strategy for next generation Software as a Service (SaaS) Cloud offerings that blend third-party data with real-time analytics and behavioral inputs to create Cloud Applications that adapt and learn. The result: intelligent Cloud Applications that automatically offer individualized recommended actions and streamline the tasks of business users such as human resource or finance professionals. 

Called Adaptive Intelligent Applications, these next generation Cloud offerings are based on the insights contained within Oracle’s Data Cloud, which is a collection of more than 5+ billion consumer and business profiles, with over 45,000 attributes. When activated, these new Adaptive Intelligent Applications use Oracle’s web-scale data and apply advanced data science to learn and ingest data about an organization’s users and their behaviors to deliver targeted information to customers and employees. The insights from these deep analytics build a knowledge base that helps improve business results across organizations.

R “Ray” Wang, principal analyst at Constellation Research said: “There is a huge opportunity to monetize digital business through machine learning applications and analytics, and Oracle’s large corpus of data, strong expertise in data science, massive compute power, industry and domain expertise, and breadth of application solutions make it well-suited to be a leader in the quickly growing space.”

“A company’s data is its most valuable weapon. To remain competitive today, companies must access their information in real time to intelligently forecast and grow,” said Steve Miranda, Oracle’s executive vice president of applications development. “Oracle Adaptive Intelligent Applications leverage anonymized information from our extensive Data Cloud to optimize existing Cloud Application functionality. When this is combined with a company’s own data, we are able to provide unparalleled customized insights to help enhance business performance.

Oracle Adaptive Intelligent Applications have direct benefits for functional business units, providing them with actionable business and customer insights to make more informed decisions:

  • Finance professionals can nimbly negotiate best supplier terms, while optimizing cash flow needs and balancing costs—especially during critical financial events such as the end of a quarter or for a high volume of payables.
  • Human Resources recruiters can automatically identify best-fit candidates in the shortest time and HR managers can create job descriptions that will help candidates more efficiently find the best and most well-suited positions.
  • Marketing and Commerce managers can drive higher conversion rates, lift, repeat purchases, and ultimately, revenue, with smart, contextual offers and recommended actions for individual consumers.
  • Supply Chain managers can automatically find the best options to distribute goods around the world, while optimizing costs and price for both the buyers and the transporters to provide the best value freight and transportation options for enterprise shippers.

“Within the foreseeable future, every enterprise application will be a smart application that intuitively learns from interactions with an enterprise’s data. Oracle’s new Adaptive Intelligent solutions take this value proposition a step further. They are set apart from others by allowing the intelligent applications to learn from billions of anonymized consumer and business profiles available from Oracle.” said Dave Schubmehl, research director of cognitive systems and content analytics for IDC. 

Building on its industry-leading suite of Cloud Applications, Oracle further expanded its SaaS portfolio with additional new Cloud Applications and enhancements that span sales, marketing, finance, human resources, and other areas of business. Some of the new offerings include: 

  • Oracle Engagement Cloud, part of Oracle’s Customer Experience Cloud portfolio, is a new offering, which combines Oracle’s sales and service capabilities in one, providing a unique combination of sales automation, service request management, knowledge management, and customer self-service. Oracle Engagement Cloud enables organizations’ employees to deliver both sales and customer services from a single screen, powering a one-stop customer experience. Oracle Engagement Cloud helps improve customer satisfaction and loyalty, while increasing up-sell opportunities, particularly for organizations providing high-touch and high value customer engagements, such as wealth managers, enterprise sales reps, or managers who need access to service request in industries such as financial services, high tech and industrial manufacturing, consumer goods, and communications.
  • Oracle Financial Consolidation and Close (FCCS) Cloud, part of Oracle’s Enterprise Performance Management Cloud portfolio, enables Chief Financial Officers at organizations of all sizes to minimize risk, provide transparency, and ensure accurate results of the close. Able to rapidly deploy in weeks, Oracle FCCS provides CFOs the operational agility they need to effectively communicate their financial results to internal and external stakeholders, to quickly consolidate the operating results of an acquired business to help ensure compliance, and to scale globally without a need to re-implement core financial processes or systems.
  • Oracle Revenue Management Cloud, part of Oracle Enterprise Resource Planning (ERP) Cloud, increases visibility into the status and value of contracts, delivers compliant revenue recognition, and creates configurable and auditable revenue entries. The solution allows companies to adhere to the ASC 606/IFRS 15 core principles, accelerating the transition to the new accounting standards. Oracle ERP Cloud’s new enhancements deliver new support to Chief Financial Officers (CFOs) and their organizations with revenue recognition standards and multi-period accounting capabilities. Driving efficiencies and controls, Oracle ERP Cloud also enables organizations to scale globally with multi-language, multi-GAAP, multi-currency, and localization extensions that can transform finance organizations. As the most complete, modern, and proven ERP Cloud solution, Oracle ERP Cloud’s rapidly expanding customer base includes strong momentum in the public sector and with state and local governments.
  • Oracle Student Cloud’s new Oracle CX for Higher Education uses Oracle’s intuitive mobile technology to help recruiters boost their pipeline by targeting and qualifying best-fit prospects via social, email, and SMS CRM capabilities. Oracle Student Recruiting Cloud’s embedded analytics also help improve forecasting and monitor and optimize recruiters’ performance in their territories. Student Management Cloud is Oracle’s first application of student information systems (SIS) in the Cloud. It provides a student management roadmap and the foundation for nontraditional university functionality in a comprehensive, next-generation SIS that supports changing academic models by managing flexible academic structures, personalized learning, just-in-time intelligence, and BYOD access.
  • Oracle Human Capital Management Cloud’s latest release provides healthcare solutions to manage complex labor rules and contractual terms that enable customers to define eligibility rules for core Human Resources and criteria for benefits, absence, time, and labor and payroll. Oracle also helps provide an added layer of auditing, which can be easily managed in the Cloud. Additional global and industry extensions for higher education, retail, manufacturing, public sector, and professional services, also make it easier for multinational organizations to deploy and configure the solutions with expanded localizations for 99 countries.
  • Oracle Internet of Things Cloud collects data and conducts analysis in real time. Line of business users, such as Manufacturing Plant Managers, can monitor real-time quality control, get early insights into predictive maintenance needs, improve worker and equipment safety, and optimize yield through Oracle’s IoT Cloud Applications.
  • Oracle Supply Chain Management Cloud updates enable increased flexibility, reduced costs, and improved performance and visibility across the business. This comprehensive foundation allows forward-thinking organizations to optimize their global supply chains from ideation to design, to order capture, to manufacturing and planning, to shipping and logistics. Leverages the additional insights available through capabilities such as the Internet of Things and Oracle Data Cloud, Oracle offers the Intelligent Supply Chain.
Contact Info
Joann Wardrip
Oracle
+1.415.867.6018
joann.wardrip@oracle.com
About Oracle

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

About Oracle OpenWorld

Oracle OpenWorld, the industry’s most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,200 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. Oracle OpenWorld 2016 is being held September 18 – September 22 at Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

About JavaOne

The JavaOne conference brings together Java experts and enthusiasts for an extraordinary week of learning and networking focused entirely on all things Java. With more than 440 sessions covering topics that span the breadth of the Java universe, keynotes from foremost Java visionaries, tutorials, and expert-led hands-on learning opportunities, JavaOne is the world's most important event for the Java community. Join the JavaOne discussion on Twitter.

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Joann Wardrip

  • +1.415.867.6018

Oracle Announces the Industry’s Most Comprehensive Offering for Analytics in the Cloud

Oracle Press Releases - Mon, 2016-09-19 07:04
Press Release
Oracle Announces the Industry’s Most Comprehensive Offering for Analytics in the Cloud Oracle Analytics Cloud is a comprehensive set of capabilities spanning packaged content, expert models, and data services as well as platform, applications and infrastructure

Oracle OpenWorld, San Francisco, Calif.—Sep 19, 2016

Oracle today announced a number of innovations in analytics that give organizations a unified and complete suite of Cloud services to unlock value from their data. The new Oracle Cloud services enable businesses to fundamentally transform the way they generate insights from people, algorithms, processes and machines and deliver them to their users with intuitive visualizations, creative narratives and predictive outcomes using expert models and adaptive learning.

The industry's only end-to-end solution for business analytics, Oracle Analytics Cloud includes a high performance analytic processing infrastructure at scale; a broad suite of tools for data preparation, discovery, visualization and collaboration; a pre-packaged suite of domain-specific machine learning models; packaged best-practice analytic key performance indicators (KPIs) to run your business; and large scale, curated public data sets all designed for analytics.

“Public Cloud deployments of business analytics software are still in relatively early stages of adoption. However, the market for Cloud deployments are expected to grow at a rate 5x greater than on-premises and other deployment methods. Oracle Analytics Cloud embraces the emerging hybrid data management and analytics architecture, delivers self-service data access and analysis, and will embed cognitive/AI functionality. These capabilities make the company well positioned to take advantage of this market opportunity.” Dan Vesset, group vice president, Analytics and Information Management at IDC.  

Oracle is the only company that unifies all these components of a modern analytics foundation including:

High Performance Infrastructure for Analytics at Scale

Oracle provides a complete set of very high-performance, elastically scalable infrastructure services designed for analytics processing on data of various types, shapes, and speeds:

  • Infrastructure: hyper-efficient compute, block and object storage infrastructure in the Cloud provides the best performance and scalability for analytic processing.
  • Elastic Analytics Platform: elastic Hadoop, Spark, and data streaming using Kafka allows customers to create elastic clusters to process data with MapReduce and Spark.
  • Flexible Data Storage: includes high-performance Object Storage, HDFS, Oracle Database and key-value/NoSQL engines.
  • Smart Options for Data Ingestion: includes streaming for high speed real-time and event data, and high-volume data replication across varied sources.
Powerful Capabilities for Data Preparation, Discovery, Visualization, and Collaboration

Built on the high-performance analytics infrastructure, Oracle provides a complete suite of tools to enable anyone in the company to derive insights and share them: 

  • Data preparation to ingest, profile and cleanse data using a variety of algorithms.
  • Data flow allows data stewards to prepare, transform and aggregate data and then run machine-learning models at scale.
  • Data discovery makes it easy for subject matter experts to collaborate with data science teams, blending intelligent analysis at scale, machine learning, and statistical modeling.
  • Data visualization empowers anyone to visualize any data and glean insight on any device, on premises and in the cloud.
  • Data collaboration offers everyone proactive conversational content and drives ongoing interaction around smart insights.
  • Data-driven interfaces enable application developers to extend, customize and embed rich analytic experiences in their application flow.
Packaged Analytics and Machine Learning Models

Extending intelligence across the enterprise requires knowing the right metrics to measure and getting the guidance to understand those metrics in every aspect of the business. Unlike other vendors who provide platforms without data or expertise, or only offer artificial intelligence as the solution, Oracle delivers data, intelligence and expertise together. This includes hundreds of person years of analytical expertise tailored to multiple industries and business functions, embedded in core applications and extensible via a cloud-based analytics platform:

  • 8,000+ best practice KPIs for roles across a variety of functions including sales, marketing, service, finance, human resources and supply chain.
  • Optimized solutions with pre-built analytics for the largest portfolio of industry specific solutions including Communications, Construction and Engineering, Education, Financial Services, Health Sciences, Hospitality, Manufacturing, Retail and Utilities.
  • Smart Applications that adapt based on packaged machine learning and artificial intelligence algorithms to provide intelligent predictions and recommendations.
  • Domain-specific applications for industries such as asset monitoring, production monitoring of manufacturing and supply chain systems, fleet management and connected workers.
  • A collaborative Oracle Cloud community for users to share analytics and expertise by exchanging data models, machine learning solutions, and algorithms.
Packaged Curated Data Sets to drive Analytics

To drive more effective marketing, selling, e-commerce and customer service, Oracle also offers packaged and highly curated data sets to drive more effective business processes and more targeted analytics.

  • Oracle Data Cloud: the world’s largest data marketplace intelligently aggregates and normalizes data across more than 5 billion global consumer profiles, with over 45,000 different dimensions from 1,500 providers. This unique data marketplace gives enterprises deep insight into their customers and prospects and can be activated through a suite of adaptive intelligent applications powered by deep learning models that operate at web-scale to learn about users and their behaviors.

“Competition in the cloud is changing,” said Thomas Kurian, president of product development at Oracle. “Inexpensive computing and storage are important, but the real game changer is creating business value through better insight. Only Oracle ties all the data, technologies, and expertise together to deliver that value for our customers. It’s that simple.”

Contact Info
Simon Jones
Oracle PR
+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.

About Oracle OpenWorld

Oracle OpenWorld, the industry’s most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,200 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. Oracle OpenWorld 2016 is being held September 18 – September 22 at Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

About JavaOne

The JavaOne conference brings together Java experts and enthusiasts for an extraordinary week of learning and networking focused entirely on all things Java. With more than 440 sessions covering topics that span the breadth of the Java universe, keynotes from foremost Java visionaries, tutorials, and expert-led hands-on learning opportunities, JavaOne is the world's most important event for the Java community. Join the JavaOne discussion on Twitter.

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Simon Jones

  • +1.415.856.5155

Pages

Subscribe to Oracle FAQ aggregator