OPTIMIZATION IN VERY LARGE DATABASES BY PARTITIONING TABLES
Article Sidebar
Open full text
Published:
Sep 30, 2020
Issue Vol. 10 No. 3 (2020)
Articles
-
THE DIAGNOSTIC OF TWO-PHASE SEPARATION PROCESS USING DIGITAL IMAGE SEGMENTATION ALGORITHMS
5-8
-
ANALYSES OF SKIN LESION AREAS AFTER THRESHOLDING
9-12
-
THE INFLUENCE OF THE PRINCIPAL COMPONENT ANALYSIS OF TEXTURE FEATURES ON THE CLASSIFICATION QUALITY OF SPONGE TISSUE IMAGES
13-16
-
SPATIAL PARAMETERS OF STATOGRAMS IN DIAGNOSING PATHOLOGIES OF THE HUMAN LOCOMOTOR SYSTEM
17-21
-
INFOCOMMUNICATION TECHNOLOGIES FOR ASSESSMENT AND PREDICTION OF ENVIRONMENT IMPACT ON HUMAN HEALTH
22-25
-
USING BRAIN-COMPUTER INTERFACE TECHNOLOGY AS A CONTROLLER IN VIDEO GAMES
26-31
-
PERFORMANCE COMPARISON OF MACHINE LEARNING ALGORITHMS FOR PREDICTIVE MAINTENANCE
32-35
-
SOLVING THE FAILING TRACK MARKER PROBLEM IN AUTOMATED GUIDED VEHICLE SYSTEMS – A CASE STUDY
36-43
-
BAPV SYSTEM MODELING FOR THE SINGLE-FAMILY HOUSE: A CASE STUDY
44-47
-
ANALYSIS OF HEAT TRANSFER IN BUILDING PARTITIONS WITH THE USE OF COMPUTATIONAL FLUID DYNAMICS TOOLS
48-51
-
SELECTED ASPECTS IN THE ANALYSIS OF THE COMBUSTION PROCESS USING WAVELET TRANSFORM
52-55
-
MANAGEMENT OF POWER IN ASPECTS OF ENERGY PRODUCTION PRICES FOR FUEL ENERGY GENERATORS
56-59
-
A REVIEW OF VOLTAGE CONTROL STRATEGIES FOR LOW-VOLTAGE NETWORKS WITH HIGH PENETRATION OF DISTRIBUTED GENERATION
60-65
-
DISASSEMBLABLE VACUUM CHAMBER AS AN INNOVATIVE TEST STAND DESIGNED FOR RESEARCH ON IMPROVING THE OPERATIONAL PARAMETERS OF POWER SWITCHING APPARATUS
66-69
-
ELECTROMAGNETIC COMPATIBILITY TESTING OF ELECTRIC VEHICLES AND THEIR CHARGERS
70-73
-
FREQUENCY MODULATION APPROACH BASED ON SPLIT-RING RESONATOR LOADED BY VARACTOR DIODE
74-77
-
INCREASING RADIATION RESISTANCE OF MEMORY DEVICES BASED ON AMORPHOUS SEMICONDUCTORS
78-81
-
TORQUE MEASURING CHANNELS: DYNAMIC AND STATIC METROLOGICAL CHARACTERISTICS
82-85
-
EXPERIMENTAL STUDY OF NATURAL GAS HUMIDITY CONTROL DEVICE
86-90
-
ELLIPTIC-CURVE CRYPTOGRAPHY (ECC) AND ARGON2 ALGORITHM IN PHP USING OPENSSL AND SODIUM LIBRARIES
91-94
-
OPTIMIZATION IN VERY LARGE DATABASES BY PARTITIONING TABLES
95-98
-
ANALISYS OF THE INFLUENCE OF GLUE JOINTS ON THE MEASUREMENT OF PHYSICAL PROPERTIES OF STRUCTURAL ELEMENTS USING FIBER BRAGG GRATING
99-102
Main Article Content
DOI
Authors
Abstract
Very large databases like data warehouse slow down over time. This is usually due to a large daily increase in the data in the individual tables, counted in millions of records per day. How do we make sure our queries do not slow down over time? Table partitioning comes in handy, and, when used correctly, can ensure the smooth operation of very large databases with billions of records, even after several years.
Keywords:
partitioning, data warehouse optimization, billions of records, AdventureWorksDW
Article Details
Bednarczuk, P. (2020). OPTIMIZATION IN VERY LARGE DATABASES BY PARTITIONING TABLES. Informatyka, Automatyka, Pomiary W Gospodarce I Ochronie Środowiska, 10(3), 95–98. https://doi.org/10.35784/iapgos.2056
