Tag: Oracle

Feed: Planet big data. Author: James McCormick. The relentless march of digital transformation has not left the physical world untouched — particularly when it comes to understanding and engaging with customers. First, customers digitally connected to brands via PCs, then mobile devices, and now via a continuous tidal wave of emerging owned IoT devices (e.g., wearables, connected cars, etc.) and non-owned IoT devices (e.g., video, in-store tracking, etc.). Location is now critical to understanding the context of customer engagement in our rapidly digitizing physical world. A new type of location intelligence (LI) is needed beyond traditional map-, asset-, and operational-centric practices ... Read More

Feed: Planet MySQL; Author: Federico Razzoli; Federico Razzoli  | December 14, 2018 |  Posted In: MariaDB, MySQL PREVIOUS POSTAs mentioned in a previous post, I gave a talk at Percona Live Europe 2018 about system-versioned tables. This is a new MariaDB 10.3 feature, which consists of preserving old versions of a table rows. Each version has two timestamps that indicate the start (INSERT,UPDATE) of the validity of that version, and its end (DELETE, UPDATE). As a result, the user is able to query these tables as they appear at a point in the past, or how data evolved in a certain time ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; As announce on Oct 18, 2018 we would like to just remind about the Open Source Conference in Tokyo, Japan which will be hold tomorrow, December 14, 2018. Please come to hear the MySQL talk on "State of Dolphin" by Yoshiaki Yamasaki, the MySQL Senior Sales Consultant Asia Pacific and Japan region. During his talk the general product updates will be covered. You can also find our team at the MySQL booth in the expo area. We are looking forward to seeing and talking to you at this show! '); } else { ... Read More

Feed: AWS Big Data Blog. re:Invent 2018 is around the corner! This year, data and analytics tracks are bigger than ever.This blog post highlights the data and analytics sessions at re:Invent 2018. If you’re attending this year, you want to check out the sessions, workshops, chalk talks, and builder sessions that we have at the conference. As in previous years, you can find these events in various topic categories, such as Analytics, Deep Learning, AI Summit, Serverless, Architecture, and Databases. We have great sessions from Intuit, Nike, Intel, WuXi NextCODE, Warner Brothers, AutoDesk, NFL, SendGrid, McDonald, AirBnB, Hilton, Guardian Life, ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Occasionally a join using primary key columns in a query can be eliminated because of the data involved. If Oracle determines that all of the 'required' data is available in a single table, then the optimizer will rewrite the query to eliminate the 'unnecessary' join. Oracle has been doing this for years with the limitation that the primary keys involved were single-column keys. In versions 12.2 and later, multi-column primary keys can be used, however there are cases where the join elimination isn't complete depending upon table order in the FROM clause ... Read More

Feed: What's New. In addition, you will now get an Amazon RDS event notification when a new minor version upgrade is available for your database instance or database cluster. This is useful when you are managing a large number of database instances and would like to be notified when engine version upgrades are available. You can consume Amazon RDS event notifications through the Amazon Simple Notification Service (Amazon SNS) or Amazon CloudWatch Events. These enhancements are available for the MySQL, MariaDB, Oracle, PostgreSQL and SQL Server database instances in all AWS Regions ... Read More

Feed: All Oracle Press Releases. Oracle today announced the Oracle Cloud Native Framework, providing developers a cloud native solution that spans public cloud, on premises and hybrid cloud deployments. Capitalizing on Oracle Cloud Infrastructure and the recently announced Oracle Linux Cloud Native Environment, the Oracle Cloud Native Framework introduces a rich set of cloud native managed services and on-premises software. The Oracle Cloud Native Framework also introduces Oracle Functions, a new breakthrough serverless cloud service based on the open source Fn Project. As organizations move to the cloud, they are facing new and difficult challenges addressing cultural change and increased ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . December is a huge month for us in terms of accessibility. With this release, the entire product is completely accessible for both report consumption and report creation. We are also previewing one of the most asked for features related to Q&A, support for live connect! We also have lots of smaller improvements across the product, such as customizable tooltips for buttons and a larger DAX formula bar. Here’s the complete list of December updates: Reporting Analytics Modeling Custom visuals Data connectivity Data preparation Other For a summary of the ... Read More

Feed: Microsoft Azure Blog. Author: Christine Alford.   1-Day Big Data Cloud Migration Workshop: This one-day workshop from Hashmap is for business and technical leaders and key stakeholders, and it's held at the client's facility. Receive guidance and assistance in defining services and the overall solution.   2-Week Azure Assessment: Assess your current datacenter environment (up to 100 VMs) and receive optimization recommendations for a cloud migration. An Azure architect from Catapult Systems will review the results of an assessment tool and provide recommendations.   3 Day Cloud Adoption Workshop: Black Marble's on-site cloud adoption workshop is free-form and wide-ranging, ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; Probably all of us, MySQL users, DBAs and developers had seen error 1213 more than once, in one context or the other: mysql> select * from t1;ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction The first thing that comes to mind in this case is: "OK, we have InnoDB deadlock, let's check the details", followed by the SHOW ENGINE INNODB STATUS check, like this: mysql> show engine innodb statusG*************************** 1. row ***************************  Type: InnoDB  Name:Status:=====================================2018-12-08 17:41:11 0x7f2f8b8db700 INNODB MONITOR OUTPUT=====================================Per second averages calculated from the last 12 seconds-----------------BACKGROUND THREAD-----------------srv_master_thread ... Read More