Tag: SQL

Feed: MariaDB Knowledge Base Article Feed. Author: . 저장 프로시저는 CALL문에 의해 호출되는 루틴입니다. 입력 매개변수, 출력 매개변수 혹은 입력이면서 동시에 출력인 매개변수를 가질 수 있습니다 저장 프로시저 생성 다음은 저장 프로시저 작동을 확인하는 스켈레톤 예제입니다: DELIMITER // CREATE PROCEDURE Reset_animal_count() MODIFIES SQL DATA UPDATE animal_count SET animals = 0; // DELIMITER ; 우선, 프로시저 정의 내에 기존의 구분기호인 세미콜론이 포함되기 때문에 구분기호(delimiter)를 변경합니다. 프로시저는 Reset_animal_count로 명명되었고, MODIFIES SQL DATA는 프로시저가 일종의 쓰기 동작을 수행하고 데이터를 변경할 것이라는 것을 알려줍니다.(MODIFIES SQL DATA는 단순 정보 제공용으로, 쿼리 동작에 실제로 영향을 미치지 않습니다.) 마지막으로 실제 SQL문인 UPDATE문이 위치합니다. SELECT * FROM animal_count; ... Read More

Feed: Planet PostgreSQL. Development on Citus first started around a decade ago and once a year we release a major new Citus open source version. We wanted to make number 10 something special, but I could not have imagined how truly spectacular this release would become. Citus 10 extends Postgres (12 and 13) with many new superpowers: Columnar storage for Postgres: Compress your PostgreSQL and Citus tables to reduce storage cost and speed up your analytical queries. Sharding on a single Citus node: Make your single-node Postgres server ready to scale out by sharding tables locally using Citus. Shard rebalancer ... Read More

Feed: Planet MySQL; Author: Alena Subotina; Most modern websites and applications ground on data collection, storage, and analysis. Databases take an active part in building the entire Web environment. That’s why it is crucial to ensure correct data retrieval from databases and appropriate ways of data manipulation. To modify your data properly, you will need to execute SQL queries. The current article will focus on the MySQL UPDATE statement and its use. The essence and role of MySQL UPDATE statement  Very often, we need to update a field in MySQL and alter the data stored in tables. We can do ... Read More

Feed: AWS Big Data Blog. Amazon DynamoDB helps you capture high-velocity data such as clickstream data to form customized user profiles and online order transaction data to develop customer order fulfillment applications, improve customer satisfaction, and get insights into sales revenue to create a promotional offer for the customer. It’s essential to store these data points in a centralized data lake, which can be transformed, analyzed, and combined with diverse organizational datasets to derive meaningful insights and make predictions. A popular use case in order management is receiving, tracking, and fulfilling customer orders. The order management process begins when an ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . SQL*Plus and PL/SQL have been at odds for years -- cases abound where how a task is performed using SQL*Plus differs from how that same or similar task is completed in PL/SQL. Additionally there are data types available in PL/SQL that have been unavailable in SQL*Plus. Oracle version 21c provides a way to use some of the PL/SQL data types in SQL*Plus type definitions, with the caveat that the PL/SQL types will not be persistent. What does this mean and how does one go about using this new-found treasure trove of types? ... Read More

Feed: James Serra's Blog. Author: James Serra. Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and AI related announcements: Azure Arc enabled machine learning (preview): Build models on-premises, in multi-cloud, and at the edge with Azure Arc. It does this by deploying Azure Machine Learning to a Kubernetes cluster that resides on-prem or in another cloud. More infoAzure Migrate new features: Discover and assess your SQL servers and their databases for migration to Azure from within the Azure Migrate portal, get target ... Read More

Feed: Microsoft Azure Blog. Author: Jeremy Winter. In response to the global health and macroeconomic crisis that began last year, customers have been accelerating their digital transformation efforts at an unprecedented pace to help bolster organizational resilience. They have depended on the cloud to not only help maintain business continuity throughout the recovery but also reimagine their mission for long-term growth. Customers like Albertsons Companies, Actavo, H&R Block, and Additiv have shared how migrating to the cloud with Microsoft Azure allowed them to stay resilient: "Within the space of a week, we were able to tick a box that said, 'If lockdown ... Read More

Feed: Planet PostgreSQL. 1. Overview PostgreSQL supports many System Information Functions, such as Session Information Functions, Access Privilege Inquiry Functions, Schema Visibility Inquiry Functions, System Catalog Information Functions, Transaction ID and Snapshot Information Functions, etc. However, you may want build some special functions and integrate them into the PostgreSQL. This blog is going to walk through the steps about how to build your own System Information Functions into PostgreSQL. 2. Analyze the requirement Since there are so many functions built-in PostgreSQL already, you should perform some research and analysis before you decide to create a new one. In this blog, ... Read More

Feed: Recent Announcements. Driving Digital Transformation with Sitecore is an AWS Solutions Consulting Offer delivered via a consulting engagement from Slalom, an AWS DevOps Competency and AWS Digital Experience Competency Partner. With the Driving Digital Transformation with Sitecore consulting offer, Slalom leverages Sitecore’s combination of content management, commerce, and customer insights to design and create a complete, customer-centric strategy and solution. Customers that request this consulting offer will participate in an engagement that delivers a customized Sitecore configuration and deployment as well as customer experience strategy, training, and support. Driving Digital Transformation with Sitecore is based on the Sitecore XP ... Read More

Feed: Matillion. Author: Julie Polito; Today marks the one-year anniversary of general availability for Matillion Data Loader. It’s been exciting to watch the growth of our first SaaS product and its adoption by Matillion customers. You’ve moved more than 350 billion rows of data for free! We’ve come a long way in a year and are excited for what’s coming this year. More on that in future blog posts. In the time since we first announced Matillion Data Loader, the pipeline business has grown and changed as well. To be frank, the data pipeline category has become commoditized. Connecting to a ... Read More