[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 )

JSON, JSONP, BSON

Protocol Buffers

XML

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 )

Tools
  • 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

PROFINET GSD Files

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

Resources

Database Query Languages, Database Frameworks and Database Interfaces

.NET

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)

Hybernate

JDBC, JDO

LINQ for .NET 3.5 & .NET 4.0

Microsoft Power Query Formula ( 'M' Language )

Tools

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

ODBC

Oracle Berkeley DB

PL/SQL

SQL

  • 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

CORBA

Database APIs, for Database Access by Web Browsers

Java Message Service ( JMS )

SOAP

Appropriate OpenDirectory Directory Pages

 
en/databases02.html.txt · Last modified: 2017/12/11 17:53 (external edit) · []
Recent changes RSS feed Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki