The optimizer is one of the most complex parts of any data engine; it must ensure that the execution engine is performing at its best, so understanding how it works, is crucial.
This webinar deep dives into the various performance optimization techniques employed by Denodo’s Dynamic Query Optimizer and illustrates these techniques via a demonstration.
View this session to ensure that you achieve the maximum value from your data processing infrastructure:
Various components of query optimization engine
Different stages leveraged within the optimizer and the techniques applied.
When, how and why to use each option available in the query optimizer
Don’t miss the chance to discover Denodo’s Query Optimizer capabilities.
Join us for this next segment of “Under the Hood” that focuses on the database designer feature of HPE Vertica.
Learn how the schema designs created by Database Designer provide optimal query performance for your most challenging analytic workloads. Database Designer uses smart strategies to create efficient schema designs that can be deployed, changed and re-deployed by almost anyone, even those without advanced database knowledge.
On Monday, 5 December, Euroclear Bank Settlement went live on the Taskize platform. Taskize is a new service that will help the financial services industry make work flow by enabling clients, colleagues and counterparties to address manual interventions efficiently, intelligently and securely.
In this 30-minute webinar, Luigi Bearzatto, Euroclear, joins Taskize Limited's John O'Hara and Philip Slavin to provide more detail on Taskize, its features, and the Euroclear-related offer that can be made available to you.
Earlier this year, the open source community delivered the Stinger Initiative to improve speed, scale, and SQL semantics in Apache Hive. Now Stinger.next is underway to build on those initial successes.
Join this 30-minute webinar with Hortonworks co-founder Alan Gates and Hortonworks Hive product manager Raj Baines to discuss SQL queries in HDP 2.2: ACID transactions and the cost based optimizer. You will also hear about the road ahead for the Stinger.next initiative.
Owen O’Malley and Carter Shanklin host the second of our seven "Discover HDP 2.1" webinars. They discuss the Stinger Initiative and the improvements to Apache Hive that are included in HDP 2.1: faster queries with Hive on Tez, new SQL semantics, and more.Read more >
IBM has taken query tuning to a new level with IBM Data Studio. More detail is available than ever before. However, the tool does take some getting used to, especially for folks that are used to a green screen based query tuning experience. This presentation introduces you to IBM Data Studio and gets you started tuning queries.Read more >
Join Rodney Landrum, Consulting Services Manager at Ntirety, a division of HOSTING, as he demonstrates his favorite new features of the latest Microsoft SQL Server 2016 Service Pack 1.
During the webinar, Rodney will touch on the following:
• A demo of his favorite new features in SQL Server 2016 and SP1 including:
o Query Store
o Database Cloning
o Dynamic Data Masking
o Create or Alter
• A review of Enterprise features that are now available in standard edition
• New information in Dynamic Management Views and SQL Error Log that will make your DBAs job easier.
With the drastic drop in the cost of sequencing a single genome, many organizations across biotechnology, pharmaceuticals, biomedical research, and agriculture have begun to make use of genome sequencing. While the sequence of a single genome may provide insight about the individual who was sequenced, to derive maximal insight from the genomic data, the ultimate goal is to query across a cohort of many hundreds to thousands of individuals.
Join this webinar to learn how Databricks — powered by Apache Spark — enables queries across a database of genomics in interactive time and simplifies the application of machine learning models and statistical tests to genomics data across patients, to derive more insight into the biological processes driven by genomic alterations.
In this webinar, we will:
- Demonstrate how Databricks can rapidly query annotated variants across a cohort of 1,000 samples.
- Look at a case study using Databricks to improve the performance of running an expression quantitative trait loci (eQTL) test across samples from the GEUVADIS project.
- Show how we can parallelize conventional genomics tools using Databricks.
What does it take to meet the challenges of ever growing big, fast data and modern data sources? Join us on May 11 at 10AM PST to find out!
Zoomdata’s Senior Director of Product Marketing Ian Fyfe and CTO Ruhollah Farchtchi will present the new capabilities of Zoomdata 2.5 and how they enable speed-of-thought visual analytics on massive data stores. Ian and Ruhollah will discuss Zoomdata’s:
- New data sharpening algorithm for large and long-running queries
- Enhanced memory management for very large result sets
- Drill to detail at scale capability
- Delegated security access
A demo featuring Zoomdata’s performance on a 10-billion row data set will follow the discussion. Register today.
Part three in a five-part series, this webcast will be a demonstration of the integration of Hortonworks HDB and Apache Hadoop YARN. YARN provides the global resource management for HDB for cluster-level hardware efficiency, while the in-database resource queues and operators provide the database and query-level resource management for workload prioritization and query optimization. This webinar will focus on demonstrating the installation process as well as discuss the various YARN and HDB parameters and best practice settings.Read more >
Analysing big data quickly and efficiently requires a data warehouse optimised to handle and scale for large datasets. Amazon Redshift is a fast, petabyte-scale data warehouse that makes it simple and cost-effective to analyse big data for a fraction of the cost of traditional data warehouses. By following a few best practices, you can take advantage of Amazon Redshift’s columnar technology and parallel processing capabilities to minimize I/O and deliver high throughput and query performance. This webinar will cover techniques to load data efficiently, design optimal schemas and tune query and database performance.
• Get an inside look at Amazon Redshift's columnar technology and parallel processing capabilities
• Learn how to migrate from existing data warehouses, optimise schemas and load data efficiently
• Learn best practices for managing workload, tuning your queries and using Amazon Redshift's interleaved sorting features
Who Should Attend:
• Data Warehouse Developers, Big Data Architects, BI Managers and Data Engineers
Other sessions on the AWS Big Data Webinar Day - 28 September:
10:00 - 11:00 GMT | Getting Started with Big Data on AWS
Register » https://www.brighttalk.com/webcast/9019/221047?utm_campaign=Brighttalk
11:15 - 12:15 GMT | Architectural Patterns for Big Data on AWS
Register » https://www.brighttalk.com/webcast/9019/221063?utm_campaign=Brighttalk
12:30 - 13:30 GMT | Building Big Data Solutions with Amazon EMR and Amazon Redshift
Register » https://www.brighttalk.com/webcast/9019/221145?utm_campaign=Brighttalk
Join this webinar to learn:
1. What is Power BI?
a. More power to Business Inteligence
2. Why Power BI?
a. Which data sources we can connect and analyse with Power BI?
b. How to connect those data sources to Power BI?
c. What is the role of R as a data source?
d. How to visualise and Analyse?
i. Design skills
ii. Tips and tricks
iii. Analytics patterns
1. Custom visuals
2. R Custom visuals (Predictive Analytics)
4. What about Backend Management?
a. Excel / Azure SQL / Azure Storage or Other
b. Custom Tables / Columns / Measures
i. What / Why / How?
5. Power BI Updates
b. Power BI Community for queries and request/issues updates
i. How to use this?
The HSBC GIF Asia ex Japan Equity Smaller Companies fund has recently stopped accepting new money from investors after its AUM reached USD1.3 billion in April 2017. The fund has seen great interest from investors on the back of its strong performance over the past year. In the first three months of 2017, the fund returned 15.6% on a gross-of-fees basis, not only outperforming its own benchmark (+12.8%), but also 88% of its competitors in the universe.
In the first webcast of this quarterly update series, Elina Fung, lead manager of the fund, will share the latest strategy and positioning of the fund and explain how she implements the stock selection process in a noisy market. On this call, Elina will also answer questions from clients, so please free to email your queries to your local sales representative or you can also ask the questions live during the webcast.
As you are aware, Triton will soon be included in the Authorization list (Annex XIV) of REACh. In order to continue to supply this material, we need some detailed information from you. In anticipation of your questions, we are hosting a webinar to answer as many of these queries as we can.Read more >
Inbenta, a global leader in artificial intelligence, utilizes patented natural language processing technology to provide a highly accurate search solution for customer support, e-commerce and chatbots.
Inbenta's semantic search engine understands & delivers results based on the meaning behind customers’ search queries, not just the individual keywords, leading to improved customer satisfaction, lower support costs and stronger ROI. The result? Industry leading 90%+ self-service rates.
We will show you how Kudu makes it easier for you to perform both real-time monitoring and ad hoc analytic queries on the same set of data.Read more >
Every day we produce huge amounts of data of various types and purposes, however these data are not integrated. Data integration aims at combining data residing in different sources and providing users with a unified view of these data. The unified view enables answering queries and discovering insights which are not possible to obtain from individual sources. Data integration is significant in a variety of situations and of paramount importance for e-science especially for large-scale scientific questions such as global warming, invasive species spread, and resource depletion. This webinar will describe the motivation for semantic integration of data, its difficulties, the related requirements and tasks, the main approaches for integration, and then it will focus on case studies of marine data coming from the ongoing BlueBRIDGE project as well as from previous projects in the same area (the completed EU research infrastructure project iMarine). A process for constructing semantic warehouses of marine data will be introduced, a process that comprises various steps including ontology-engineering, schema mapping, entity matching, provenance management, and quality testing. Finally, the webinar will discuss the exploitation of such semantic warehouses, as well as future steps and open challenges.Read more >
Focused on business websites and corporate intranets, Inbenta is a global pioneer in a new class of enterprise semantic search technology that's aimed to dramatically improve the experience of online customers. By using the latest developments in natural language processing technologies and artificial intelligence, Inbenta has helped multiple companies drop incoming email queries and customer support calls because the customer easily finds what they are looking for on the company's website. Inbenta also specializes in self-service, e-commerce search, virtual assistants, chatbots, support ticketing and knowledge management.Read more >
Learn How to Store and Query Time Series Data in NoSQL and Other Use CasesRead more >
When you don’t have a solution for data, you fall back on slow, suboptimal tactics for accessing data, denying business users and decision makers access to the most accurate, up to date, and relevant information.
Learn how Talkdesk went from a chaotic world like the one above to being a company where people can easily explore data and quickly get a 360° view of every account. Using FiveTran and Looker, Talkdesk’s product manager was able to tie all their now-centralized data together to create a powerful and stable environment for data discovery.
From this webinar, you will learn:
• What a centralized data store can do for you and how you can achieve that
• Why you should be transforming your data at the time of query, not before you load it into your database
• How one man created a company-wide data platform in one month
Watch to understand how to take control of your data and use it to drive results.
GraphFrames bring the power of Apache Spark DataFrames to interactive analytics on graphs.
Expressive motif queries simplify pattern search in graphs, and DataFrame integration allows seamlessly mixing graph queries with Spark SQL and ML. By leveraging Catalyst and Tungsten, GraphFrames provide scalability and performance. Uniform language APIs expose the full functionality of GraphX to Java and Python users for the first time.
In this talk, the developers of the GraphFrames package will give an overview, a live demo, and a discussion of design decisions and future plans. This talk will be generally accessible, covering major improvements from GraphX and providing resources for getting started. A running example of analyzing flight delays will be used to explain the range of GraphFrame functionality: simple SQL and graph queries, motif finding, and powerful graph algorithms.
For experts, this talk will also include a few technical details on design decisions, the current implementation, and ongoing work on speed and performance optimizations.