BSI PD ISO/IEC TR 19075-8:2019
$215.11
Information technology database languages. SQL technical reports – Multi-dimensional arrays (SQL/MDA)
Published By | Publication Date | Number of Pages |
BSI | 2019 | 78 |
PDF Catalog
PDF Pages | PDF Title |
---|---|
2 | undefined |
5 | Contents |
7 | Tables |
8 | Figures |
9 | Foreword |
10 | Introduction |
11 | 1 Scope |
13 | 2 Normative references |
15 | 3 Terms and definitions |
17 | 4 Multidimensional Arrays (MDA) concepts 4.1 Concept 4.2 Why consider support for MDA in SQL? |
19 | 4.3 Array representations 4.4 Use cases for MDA support in SQL 4.4.1 The use cases 4.4.2 Array data ingestion and storage |
20 | 4.4.3 Integrated querying of array and relational data 4.4.4 Updating stored array data 4.4.5 Exporting arrays 4.5 Non-Use cases: Direct access to external array data |
21 | 5 SQL/MDA data model 5.1 Data model concepts 5.2 MD-array |
22 | 5.3 MD-array type definition 5.3.1 Type definition concepts 5.3.2 Element type |
23 | 5.3.3 MD-dimension 5.3.4 MD-axis names 5.3.5 MD-axis lower and upper limits |
24 | 5.3.6 Putting it all together |
26 | 5.4 MD-array creation 5.4.1 MD-array creation concepts |
27 | 5.4.2 Explicit element enumeration |
28 | 5.4.3 From SQL table query result |
29 | 5.4.4 Construction by implicit iteration |
30 | 5.4.5 Decoding a format-encoded array |
31 | 5.5 MD-array updating 5.5.1 MD-array updating introduction |
32 | 5.5.2 Updating MD-arrays of equal MD-dimension |
33 | 5.5.3 Updating MD-arrays of greater MD-dimension |
34 | 5.5.4 Updating a single element of an MD-array 5.6 Exporting MD-arrays 5.6.1 Encoding to a data format |
36 | 5.6.2 Converting to an SQL table |
39 | 6 SQL/MDA operations 6.1 Introduction to SQL/MDA operations 6.2 MD-extent probing operators |
41 | 6.3 MD-array element reference |
42 | 6.4 MD-extent modifying operations 6.4.1 Introduction to MDE-extent modifying operations 6.4.2 Subsetting |
44 | 6.4.3 Reshaping |
46 | 6.4.4 Shifting 6.4.5 MD-axis renaming |
47 | 6.5 MD-array deriving operators 6.5.1 Introduction to MD-array deriving operators 6.5.2 Scaling |
49 | 6.5.3 Concatenation 6.5.4 Induced operations |
56 | 6.5.5 Join MD-arrays on their coordinates |
57 | 6.6 MD-array aggregation 6.6.1 General aggregation expression |
58 | 6.6.2 Shorthand aggregation functions |
61 | 7 Remote sensing example 7.1 Introduction to remote sensing example 7.2 Data setup |
63 | 7.3 Band math 7.3.1 Introduction to band math 7.3.2 NDVI |
66 | 7.3.3 Band Swapping |
67 | 7.4 Histograms |
68 | 7.5 Change detection |
69 | 7.6 Extracting features |
70 | 7.7 Data search and filtering |