Category: The database

The database

CloudQuery v1.4.0 released | a new starting point of the whole stack data control platform

December 14, 2023

by Joanne Jackson

No Comments

New features in V1.4.0 include the Scheduling Center module, DTS (Database Tools Service) data export, visual query builder, and Hive data sources.

Read More

The database

Will Hadoop be replaced by Spark? Principle analysis of Hadoop ecological components

December 14, 2023

by Ellen Christensen

No Comments

Both Hadoop and Spark are mainstream big data frameworks. However, due to the advantages of Spark in terms of speed and ease of use, some...

Read More

The database

TDengine in the landing application of objects

December 14, 2023

by 崔志偉

No Comments

As an Internet e-commerce company, DeWo has many systems and scenes that need to do traffic monitoring and protection. Therefore, when we deeply customize the...

Read More

The database

The design of ITS113 database

December 14, 2023

by Miss Natalie Tucker

No Comments

Database Design -- Its113 Assignment -- Asset Management SystemThis assignment puts you in a hypothetical, but realistic, scenario where you work on databasedesign intended to...

Read More

The database

Hive+ SQOOP Shallow Learning Guide

December 14, 2023

by James Ball

No Comments

Business requirements: HDFS Hive Data Cleanup (ETL) is used to describe the process of extracting, transforming, and loading data from the source end to the...

Read More

The database

Agenda announced! 2021 MongoDB Chinese Community Hangzhou Conference

December 14, 2023

by Madison Cairns-Stevenson

No Comments

2021 MongoDB Chinese Community Hangzhou Technology Conference will be jointly held by MongoDB Chinese Community, MongoDB official, TapData and AliCloud. It will be held in...

Read More

The database

Data Stack Product Sharing: A Brief Analysis of Data Center How to Share Data via DataAPI

December 14, 2023

by Guy Jones-James

No Comments

The stack is a cloud-based, native, site-based PaaS for data, and we have an interesting open source project on GitHub and Gitee: FLINKX, FLINKX is...

Read More

The database

On the architect: roles, capabilities, and challenges

December 14, 2023

by Craig Jensen-Middleton

No Comments

Summary: Becoming an architect is probably one of the technical pursuits of many developers. So how do you understand architecture? What is the role and...

Read More

The database

How do I migrate data from SQLite to a PostgreSQL database

December 14, 2023

by Parinaaz Sheth

No Comments

SQLite is an excellent embedded database, often used in mobile terminal, internal or temporary database, embedded devices and the Internet of Things and other scenarios....

Read More

The database

“Eight Snake Spears” in the Information Security Circle of Border Defense

December 14, 2023

by Anthony Jackson

No Comments

When it comes to "Kingsoft Anti-Virus", everyone is familiar with it. It is a virus protection software in China, and one of the few anti-virus...

Read More

The database

ClickHouse Series – Chapter 4 – Index

December 14, 2023

by Chelsea Willis

No Comments

In Section 3, you learned that ClickHouse compresses data in blocks as it processes it and then writes it to a disk data file. This...

Read More

The database

Database trading backtest series two: multi-factor Alpha strategy backtest

December 14, 2023

by Chelsea Zimmerman

No Comments

This series of articles describes how to use Dolphindb in an elegant and efficient way to measure back trading strategies. This article will introduce a...

Read More

The database

Details on Nebula 2.0 performance testing and tuning of Nebula-Importer data import

December 14, 2023

by Paula Eglinton

No Comments

This is a hands-on post written by community user Fan Fan on how to perform Nebula performance testing and performance tuning for the data import...

Read More

The database

SQOOP migration process source code analysis

December 14, 2023

by Charlotte Fulton

No Comments

【 Abstract 】 SQOOP is a tool for efficiently transferring bulk data between Apache Hadoop and structured data stores (such as relational databases). This article...

Read More

The database

VMware business systems migrate to the cloud solution

December 14, 2023

by Saira Mahal

No Comments

Background Customers are migrating their business from their own virtualized data centers to UCloud and want to be able to switch from the old VMware...

Read More

The database

The machine could write SQL, and Curd Boys (Girls) didn’t panic

December 14, 2023

by Alexis Thompson

No Comments

Structured Query Language (SQL) is a special purpose programming Language, a database Query and programming Language, used for accessing data, querying, updating and managing relational...

Read More

The database

Oracle —- window function (3)

December 14, 2023

by David Batchelar

No Comments

Today I'll talk about how the line error function (lag,lead) uses the window function. {code... } Here is the full record of table "test_student_score". {code......

Read More

The database

When to delete? How to delete? 5 minutes to eat through the TDengine expired data automatic cleaning mechanism

December 14, 2023

by Anthony Thompson

No Comments

In the previous installment, we talked about how to use the proper configuration of vnodes to complete Tdengine data sharding (these secret parameters teach you...

Read More

The database

| DAS introduces the global Workload Optimization feature to automate SQL diagnostics

December 14, 2023

by Sarah Green

No Comments

Summary: DAS introduces the global Workload optimization function, which can detect database load changes in a timely manner, identify new SQL, SQL executing changes, and...

Read More

The database

Implementing custom Chinese full-text index in Neo4j

December 14, 2023

by Mohanlal Brar

No Comments

When it comes to the efficiency of database retrieval, the primary optimization approach is to start with the index, and then consider more complex means...

Read More

The database

The pit you stepped in when synchronizing data from AliDataax to MemfireDB

December 14, 2023

by John Wright

No Comments

During the construction of the data warehouse, some business systems used the Daemon database to store the original data. Now the data needs to be...

Read More

The database

Why is it getting easier to grab seckill when millions of people place orders at the same time?

December 14, 2023

by Jennifer Curtis

No Comments

Add the desired goods to the shopping cart, click the settlement, payment, product page sales +1, inventory -1, if only dozens of people order, the...

Read More

The database

Technology revelation | large stimulating behind, how to effectively assess computing resources and planning database?

December 14, 2023

by Ms. Holly Steele

No Comments

Introduction: After the verification of "Double 11", "618" and other Internet promotional activities, more and more Internet companies use irregular marketing activities to stimulate consumption...

Read More

The database

Hologres Reveals: Deep parsing and efficient distributed query engine

December 14, 2023

by Samarth Sant

No Comments

Hologres (Chinese name) interactive analysis is ali cloud from the research on the number of one-stop real-time warehouse, the cloud native system combines real-time service...

Read More

The database

Identify tablespace (non-extended) usage and automatically generate add data file scripts

December 14, 2023

by Katie Grant

No Comments

Identify tablespace (non-extended) usage >; =90%, with free space left. =100000M; Identify the \ or/before part of the data file name as the path to...

Read More

The database

[Teacher Zhao Qiang] Using MapReduce to calculate aggregation in MongoDB

December 13, 2023

by 王怡萱

No Comments

MapReduce can compute very complex aggregation logic and is very flexible. However, MapReduce is very slow and should not be used for real-time data analysis....

Read More

The database

Embrace ElasticSearch: Give TIDB a wing for full text search

December 13, 2023

by 王志偉

No Comments

About the author: Sun Xiaoguang, head of Zhihu Technology Platform, joined a team with Ning Xue (@inke), Menglong Huang (@pingcap), and Bo Feng (@Zhihu) to...

Read More

The database

What are libraries, tables, and super tables? How does it work? After 60, the uncle spares the cocoon to explain the data modeling of TDengine

December 13, 2023

by 李俊傑

No Comments

In a typical iot scenarios, generally speaking, there are a variety of different types of acquisition device, collect a variety of different physical quantities, the...

Read More

The database

Add a new glow! SmartBi was awarded the 2021 Smart Smart Award for Outstanding Solutions for Data Governance and Data Platform Innovation

December 13, 2023

by Edward Goddard

No Comments

Recently, under the guidance of the National Center for Science and Technology Assessment, Beijing Software and Information Service Industry Association, and Jinke Innovation Society jointly...

Read More

The database

Application practices for processing XML data

December 13, 2023

by 晏宇軒

No Comments

XML is the abbreviation of Extensible Markup Language, which can describe very complex data structures and is widely used for transferring and storing data. XML...

Read More