About: Possibilities of Storing Arrays and Their Performance Testing in the Most Common DBMS

Facets (new session)
Description
Metadata
Settings
- owl:sameAs
- Inference Rule:

About: Possibilities of Storing Arrays and Their Performance Testing in the Most Common DBMS Goto Sponge NotDistinct Permalink

An Entity of Type : http://linked.opendata.cz/ontology/domain/vavai/Vysledek, within Data Space : linked.opendata.cz associated with source document(s)

Attributes	Values
rdf:type	skos:Concept http://linked.opendata.cz/ontology/domain/vavai/Vysledek
Description	This study is designed to suggest the possibilities of storing arrays in the most common Database management systems (DBMS). An array data type is a common part of most programming languages and is very suitable for example for processing discrete values of signal and time series measure. The offer of DBMS is very large in these days and the best solution to store arrays may not be obvious. This article discuss the possibilities of storing arrays in open-source DBMS (MySQL, PostgreSQL), even in commercial MS SQL. These basic approaches were tested – storing an array in an appropriate array data type (available only in PostgreSQL), storing an array as a string (or serialized string), storing array values to separate columns in a table and storing values into rows. Performed tests are evaluated and discussed in conclusion and also pros and cons of each approach are discussed in the frame of specific application. This study is designed to suggest the possibilities of storing arrays in the most common Database management systems (DBMS). An array data type is a common part of most programming languages and is very suitable for example for processing discrete values of signal and time series measure. The offer of DBMS is very large in these days and the best solution to store arrays may not be obvious. This article discuss the possibilities of storing arrays in open-source DBMS (MySQL, PostgreSQL), even in commercial MS SQL. These basic approaches were tested – storing an array in an appropriate array data type (available only in PostgreSQL), storing an array as a string (or serialized string), storing array values to separate columns in a table and storing values into rows. Performed tests are evaluated and discussed in conclusion and also pros and cons of each approach are discussed in the frame of specific application. (en)
Title	Possibilities of Storing Arrays and Their Performance Testing in the Most Common DBMS Possibilities of Storing Arrays and Their Performance Testing in the Most Common DBMS (en)
skos:prefLabel	Possibilities of Storing Arrays and Their Performance Testing in the Most Common DBMS Possibilities of Storing Arrays and Their Performance Testing in the Most Common DBMS (en)
skos:notation	RIV/70883521:28140/11:43866591!RIV12-MSM-28140___
http://linked.open...avai/riv/aktivita	S
http://linked.open...avai/riv/aktivity	S
http://linked.open...vai/riv/dodaniDat	2012
http://linked.open...aciTvurceVysledku	Žouželková, Iveta Vala, Radek
http://linked.open.../riv/druhVysledku	O - Ostatní výsledky nezařaditelné do žádného z výše uvedených druhů výsledku
http://linked.open...iv/duvernostUdaju	S - Úplné a pravdivé údaje nepodléhající ochraně podle zvláštních právních předpisů
http://linked.open...titaPredkladatele	Univerzita Tomáše Bati ve Zlíně / Fakulta aplikované informatiky
http://linked.open...dnocenehoVysledku	221775
http://linked.open...ai/riv/idVysledku	RIV/70883521:28140/11:43866591
http://linked.open...riv/jazykVysledku	eng - angličtina
http://linked.open.../riv/klicovaSlova	DBMS, My SQL, Microsoft SQL Server, PostgreSQL, Arrays, Testing, Database (en)
http://linked.open.../riv/klicoveSlovo	Testing Database PostgreSQL Arrays DBMS Microsoft SQL Server My SQL
http://linked.open...ontrolniKodProRIV	[0FAF4932D764]
http://linked.open...in/vavai/riv/obor	IN
http://linked.open...ichTvurcuVysledku	2 (xsd:int)
http://linked.open...cetTvurcuVysledku	2 (xsd:int)
http://linked.open...UplatneniVysledku	2011
http://linked.open...iv/tvurceVysledku	Vala, Radek Žouželková, Iveta
http://localhost/t...ganizacniJednotka	28140

Faceted Search & Find service v1.16.118 as of Jun 21 2024

Alternative Linked Data Documents: ODE Content Formats:

RDF

ODATA

Microdata

About

OpenLink Virtuoso version 07.20.3240 as of Jun 21 2024, on Linux (x86_64-pc-linux-gnu), Single-Server Edition (126 GB total memory, 58 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software