🔥🔥 Don’t Miss Out on Our End of Autumn Sale. If you have any questions, feel free to click the bottom right corner to contact our customer service..

Concat us[email protected]
Shopping Cart

No products in the cart.

🔍
BS ISO/IEC 19075-8:2021

BS ISO/IEC 19075-8:2021

$215.11

Information technology. Guidance for the use of database language SQL – Multidimensional arrays

Published By Publication Date Number of Pages
BSI 2021 72
PDF Format Searchable Printable Preview Now
Guaranteed Safe Checkout
Category:

If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7.
Email:[email protected]

This document describes the definition and use of multidimensional arrays in SQL. Multidimensional arrays represent a core underlying structure of manifold science and engineering data. It is generally recognized today, therefore, that arrays have an essential role in Big Data and should become an integral part of the overall data type orchestration in information systems. This document discusses the syntax and semantics of operations on the MD-array data type defined in ISO/IEC 9075-15.

PDF Catalog

PDF Pages PDF Title
2 undefined
5 Contents
7 Tables
8 Figures
9 Foreword
11 Introduction
13 1 Scope
14 2 Normative references
15 3 Terms and definitions
16 4 Multidimensional arrays (MDA) concepts
4.1 Context of multidimensional arrays
4.2 Concept
4.3 Why consider support for MDA in SQL?
18 4.4 Array representations
4.5 Use cases for MDA support in SQL
4.5.1 The use cases
4.5.2 Array data ingestion and storage
19 4.5.3 Integrated querying of array and relational data
4.5.4 Updating stored array data
4.5.5 Exporting arrays
4.6 Non-Use cases: Direct access to external array data
20 5 SQL/MDA data model
5.1 Data model concepts
5.2 MD-array
21 5.3 MD-array type definition
5.3.1 Type definition concepts
5.3.2 Element type
22 5.3.3 MD-dimension
5.3.4 MD-axis names
5.3.5 MD-axis lower and upper limits
23 5.3.6 Putting it all together
25 5.4 MD-array creation
5.4.1 MD-array creation concepts
26 5.4.2 Explicit element enumeration
27 5.4.3 From SQL table query result
28 5.4.4 Construction by implicit iteration
29 5.4.5 Decoding a format-encoded array
30 5.5 MD-array updating
5.5.1 MD-array updating introduction
31 5.5.2 Updating MD-arrays of equal MD-dimension
32 5.5.3 Updating MD-arrays of greater MD-dimension
33 5.5.4 Updating a single element of an MD-array
5.6 Exporting MD-arrays
5.6.1 Encoding to a data format
35 5.6.2 Converting to an SQL table
37 6 SQL/MDA operations
6.1 Introduction to SQL/MDA operations
6.2 MD-extent probing operators
39 6.3 MD-array element reference
40 6.4 MD-extent modifying operations
6.4.1 Introduction to MDE-extent modifying operations
6.4.2 Subsetting
42 6.4.3 Reshaping
44 6.4.4 Shifting
6.4.5 MD-axis renaming
45 6.5 MD-array deriving operators
6.5.1 Introduction to MD-array deriving operators
6.5.2 Scaling
47 6.5.3 Concatenation
6.5.4 Induced operations
54 6.5.5 Join MD-arrays on their coordinates
55 6.6 MD-array aggregation
6.6.1 General aggregation expression
56 6.6.2 Shorthand aggregation functions
58 7 Remote sensing example
7.1 Introduction to remote sensing example
7.2 Data setup
60 7.3 Band math
7.3.1 Introduction to band math
7.3.2 NDVI
63 7.3.3 Band Swapping
64 7.4 Histograms
65 7.5 Change detection
66 7.6 Extracting features
67 7.7 Data search and filtering

Related products

BS ISO/IEC 19075-8:2021
$215.11