MonetDB este o bază de date open source care a pionierat abordarea tehnologiei storalelor În acest training instruit, participanții vor învăța cum să folosească MonetDB și cum să obțină cea mai mare valoare din acesta Până la sfârșitul acestui curs, participanții vor putea: Înțelegeți MonetDB și caracteristicile acestuia Instalați și începeți cu MonetDB Explorați și efectuați diferite funcții și sarcini în MonetDB Accelerați livrarea proiectului prin maximizarea capacităților MonetDB Public Dezvoltatori Experți tehnici Formatul cursului Prelegere parte, discuții parțiale, exerciții și practici grele de manevră .
Machine Translated
Introduction
Overview of MonetDB
- About MonetDB
- MonetDB Features
Installing MonetDB
Getting Started with MonetDB
- Learning the MonetDB SQL Reference Manual
- Understanding the Lexical Structure
- Exploring Data Types
- Implementing Data Definitions
- Performing Data Manipulation
- Programming SQL
- Executing Transactions
- Exploring Runtime Features
- Understanding Language Bindings
- Running through the MonetDB SQL System Catalog
- Schema, Table and Columns
- Functions, Arguments, Types
- Objects, Keys, Indices, Sequences
- Triggers, Dependencies
- Users, Roles, Privileges, Sessions
- QueryLog Catalog, Calls, History, Queue
- Optimizer Pipelines
- Environment Variables
Setting Up a MonetDB Database
- Creating a Database Using the MonetDB Daemon
- Starting and Stopping a Database Using the MonetDB Daemon
- Loading and Querying Data
- Performing Basic Configurations on a MonetDB Server
Interacting with a MonetDB Server
- Setting Up a Connection in SQuirrel SQL to a MonetDB Server
- Creating Database Schema
- Loading Database Data
- Browsing the Database
- Executing Analytical Queries
- Executing Updating Queries
- Backing Up and Restoring a Database
Using MonetDB from within an Application
- Setting Up a Connection to a MonetDB Server in Java
- Setting Up a Connection to a MonetDB Server in Python
- Setting Up a Connection to a MonetDB Server in PHP
- Using JDBC to Access the Database
- Using ODBC to Access the Database
- Understanding Optimistic Transaction Management
Using Client Interfaces in MonetDB
Implementing User-Defined Functions in MonetDB
Performing Cluster Management in MonetDB
Partitioning the Data in MonetDB
Performing Distributed Query Processing in MonetDB through Remote Tables
Sampling a Database in MonetDB
Migrating a Database in MonetDB
Inserting Bulk Data into an SQL Table in MonetDB
Exporting Bulk Data in MonetDB
Working with MonetDB/SQL Optimizer Pipelines
Timing Query Execution in MonetDB
Obtaining the Storage Footprint of a Database Schema in MonetDB
Monitoring the System in MonetDB
Working with Table Statistics in MonetDB
Using MonetDB's Date and Time Functionalities
Performing Transaction Replication in MonetDB
Using Lazy Logical Replication in MonetDB
Summary and Conclusion
.jpg "european organization for nuclear research (cern)")
.jpg "american international group (aig)")
.jpg "european southern observatory (eso)")
.png "aeronautical radio, incorporated (arinc)")
