[hemmerling] Data Processing 2/5 - Descriptions of Data, Data Transfer and Data Protocols

Database Design Modeling Languages

Data Formats, Database Formats

Data Format Description Language ( DFDL )

Hierarchical Data Format ( HDF )


Protocol Buffers


Free XML Editors

Simple API for XML ( SAX )

XML Parsers in Java

XML Parsers in C/C++

XML Parsers for Python

XML Publishing Framework

Darwin Information Typing Architecture ( DITA )

  • The OpenSource software DITA Open Toolkit - “The DITA Open Toolkit, or DITA-OT for short, is a set of Java-based, open-source tools that provide processing for DITA maps and topic content”.
The Standard

DocBook XML


XML Parsers for checking existing PROFINET GSD Files
Suggested Tools to generate PROFINET GSD Files


Database Query Languages, Database Frameworks and Database Interfaces


Database Access by .NET

  • ADO.NET.
  • DataReader, DataAdapter, (typisierte) DataSets.
    • Data Access / Persistence Layer.
  • Repository, Data Mapper, Active Record etc.
    • ObjectSpaces, EntLib, Entity Fx, LINQ to SQL.
  • Object-Relational Mapping ( ORM ).

Object-Relational Mapping (ORM ) for .NET

  • NHibernate.
  • SubSonic.
  • Castle.ActiveRecord.
  • Telerik OpenAccess.
  • LightSpeed.
  • LINQ to SQL [.NET 3.5].
  • ADO.NET Entity Framework [.NET 3.5 SP1].

Micro ORMs

ADO.NET & ADO.NET Entity Framework (EF)



LINQ for .NET 3.5 & .NET 4.0

Microsoft Power Query Formula ( 'M' Language )


Resources for Tools which user the 'M' Language

Resources for 'M'

MultiDimensional eXpressions ( MDX ), Data Analysis Expressions ( DAX ), Tabular Model Scripting Language ( TMSL ), Tabular Object Model ( TOM )

The legacy MultiDimensional eXpressions ( MDX ) of SQL Server

The current Data Analysis Expressions ( DAX ) of SQL Server 2008 R2

The current "Tabular Model Scripting Language ( TMSL ) / Tabular Object Model ( TOM ) of SQL Server 2017


Oracle Berkeley DB



  • I was told by experts about SQL naming conventions:
    1. Oracle SQL Server: SQL commands and table names are not case sensitive. Internally, they are converted to uppercase, if they are not included in quotation marks.
    2. Postgres is also not case sensitive, but converts all SQL keywords to lowercase.
    3. Oracle MySQL Server is case sensitive or not, depending on th operating system, database engine and settings.

Transact SQL ( TSQL )

XML, SQL and ODBC Support for C++

Data Transfer Protocols, Webservices Protocols


Database APIs, for Database Access by Web Browsers

Java Message Service ( JMS )


Appropriate OpenDirectory Directory Pages

en/databases02.html.txt · Last modified: 2018/02/14 19:55 (external edit) · []
Recent changes RSS feed Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki