Ergebnisse der SQL-Abfragen für die Beispiel-Datenbank

• Beispiel 1
  • Abfrage

    • SELECT title, page1, page2, year FROM Paper
         ORDER BY year DESC, title;

  • Ergebnis

    • title	page1	page2	year
      Implementing Thermodynamic Cyclic Processes Using the DLR Thermofluid Stream Library	3	10	2023
      Solving ARGESIM Benchmark CP2 ’Parallel and Distributed Simulation’ with Open MPI and Matlab PCT – Lattice Boltzmann Simulation	93	100	2023
      Implementing Standard Examples with NSA-DEVS	195	202	2022
      Regularization of the Logarithmic Mean for Robust Numerical Simulation	529	533	2022
      The DLR ThermoFluid Stream Library	3790	3810	2022
      NSA-DEVS: Combining Mealy behaviour and Causality	73	80	2021
      Aufgabenorientierte Multi-Robotersteuerungen auf Basis des SBC-Frameworks und DEVS	1	181	2020
      Beschleunigung eines Reinforcement-Learning-Algorithmus durch Parallelverarbeitung für Robotikanwendungen	49	52	2019
      Non-standard Queuing Policies: Definition of ARGESIM Benchmark C22	111	115	2019
      Implementing the Argesim C21 benchmark with Modelica components	197	202	2018
      A Modelica Library for MultiBond Graphs and its Application in 3D-Mechanics	1	156	2006
      The Modelica Multi-bond Graph Library	559	568	2006
      Parallel DEVS: A parallel, hierarchical, modular modeling formalism and its distributed simulator	55	68	1996

• Beispiel 2
  • Abfrage

    • SELECT title, page1, page2, year FROM Paper
         WHERE year >= 2020;

  • Ergebnis

    • title	page1	page2	year
      Solving ARGESIM Benchmark CP2 ’Parallel and Distributed Simulation’ with Open MPI and Matlab PCT – Lattice Boltzmann Simulation	93	100	2023
      Implementing Standard Examples with NSA-DEVS	195	202	2022
      The DLR ThermoFluid Stream Library	3790	3810	2022
      Regularization of the Logarithmic Mean for Robust Numerical Simulation	529	533	2022
      Implementing Thermodynamic Cyclic Processes Using the DLR Thermofluid Stream Library	3	10	2023
      Aufgabenorientierte Multi-Robotersteuerungen auf Basis des SBC-Frameworks und DEVS	1	181	2020
      NSA-DEVS: Combining Mealy behaviour and Causality	73	80	2021

• Beispiel 3
  • Abfrage

    • SELECT title, page1, page2, year FROM Paper
         WHERE title LIKE "%NSA-DEVS%";

  • Ergebnis

    • title	page1	page2	year
      Implementing Standard Examples with NSA-DEVS	195	202	2022
      NSA-DEVS: Combining Mealy behaviour and Causality	73	80	2021

• Beispiel 4
  • Abfrage

    • SELECT title, page2 - page1 + 1, year FROM Paper
         WHERE title LIKE "%NSA-DEVS%"
         ORDER BY year;

  • Ergebnis

    • title	page2 - page1 + 1	year
      NSA-DEVS: Combining Mealy behaviour and Causality	8	2021
      Implementing Standard Examples with NSA-DEVS	8	2022

• Beispiel 5
  • Abfrage

    • SELECT title, name FROM Paper NATURAL JOIN Publication;
      

  • Ergebnis

    • title	name
      Solving ARGESIM Benchmark CP2 ’Parallel and Distributed Simulation’ with Open MPI and Matlab PCT – Lattice Boltzmann Simulation	SNE Simulation Notes Europe
      Implementing Standard Examples with NSA-DEVS	SNE Simulation Notes Europe
      Implementing the Argesim C21 benchmark with Modelica components	7. Workshop der ASIM/GI-Fachgruppen STS/GMMS
      Non-standard Queuing Policies: Definition of ARGESIM Benchmark C22	SNE Simulation Notes Europe
      Beschleunigung eines Reinforcement-Learning-Algorithmus durch Parallelverarbeitung für Robotikanwendungen	8. Workshop der ASIM/GI-Fachgruppen STS/GMMS
      A Modelica Library for MultiBond Graphs and its Application in 3D-Mechanics	Master Thesis
      The DLR ThermoFluid Stream Library	Electronics
      Regularization of the Logarithmic Mean for Robust Numerical Simulation	IFAC-PapersOnLine
      Implementing Thermodynamic Cyclic Processes Using the DLR Thermofluid Stream Library	10. Workshop der ASIM/GI-Fachgruppen STS/GMMS/EDU
      The Modelica Multi-bond Graph Library	5th International Modelica Conference
      Aufgabenorientierte Multi-Robotersteuerungen auf Basis des SBC-Frameworks und DEVS	PhD Thesis
      Parallel DEVS: A parallel, hierarchical, modular modeling formalism and its distributed simulator	Transactions of the Society for Computer Simulation
      NSA-DEVS: Combining Mealy behaviour and Causality	SNE Simulation Notes Europe

• Beispiel 6
  • Abfrage

    • SELECT title, name AS journal
         FROM Paper NATURAL JOIN Publication
         ORDER BY journal;

  • Ergebnis

    • title	journal
      Implementing Thermodynamic Cyclic Processes Using the DLR Thermofluid Stream Library	10. Workshop der ASIM/GI-Fachgruppen STS/GMMS/EDU
      The Modelica Multi-bond Graph Library	5th International Modelica Conference
      Implementing the Argesim C21 benchmark with Modelica components	7. Workshop der ASIM/GI-Fachgruppen STS/GMMS
      Beschleunigung eines Reinforcement-Learning-Algorithmus durch Parallelverarbeitung für Robotikanwendungen	8. Workshop der ASIM/GI-Fachgruppen STS/GMMS
      The DLR ThermoFluid Stream Library	Electronics
      Regularization of the Logarithmic Mean for Robust Numerical Simulation	IFAC-PapersOnLine
      A Modelica Library for MultiBond Graphs and its Application in 3D-Mechanics	Master Thesis
      Aufgabenorientierte Multi-Robotersteuerungen auf Basis des SBC-Frameworks und DEVS	PhD Thesis
      Solving ARGESIM Benchmark CP2 ’Parallel and Distributed Simulation’ with Open MPI and Matlab PCT – Lattice Boltzmann Simulation	SNE Simulation Notes Europe
      Implementing Standard Examples with NSA-DEVS	SNE Simulation Notes Europe
      Non-standard Queuing Policies: Definition of ARGESIM Benchmark C22	SNE Simulation Notes Europe
      NSA-DEVS: Combining Mealy behaviour and Causality	SNE Simulation Notes Europe
      Parallel DEVS: A parallel, hierarchical, modular modeling formalism and its distributed simulator	Transactions of the Society for Computer Simulation

• Beispiel 7
  • Abfrage

    • SELECT COUNT(*) as count, SUM(page2-page1+1) as totalPages, year FROM Paper
           GROUP BY year ORDER BY year;

  • Ergebnis

    • count	totalPages	year
      1	14	1996
      2	166	2006
      1	6	2018
      2	9	2019
      1	181	2020
      1	8	2021
      3	34	2022
      2	16	2023

• Beispiel 8
  • Abfrage

    • SELECT name as journal, COUNT(*) as count
         FROM Paper NATURAL JOIN Publication
         GROUP BY journal
         ORDER BY count DESC;

  • Ergebnis

    • journal	count
      SNE Simulation Notes Europe	4
      7. Workshop der ASIM/GI-Fachgruppen STS/GMMS	1
      8. Workshop der ASIM/GI-Fachgruppen STS/GMMS	1
      Master Thesis	1
      Electronics	1
      IFAC-PapersOnLine	1
      10. Workshop der ASIM/GI-Fachgruppen STS/GMMS/EDU	1
      5th International Modelica Conference	1
      PhD Thesis	1
      Transactions of the Society for Computer Simulation	1

• Beispiel 9
  • Abfrage

    • SELECT name AS publication , SUM(page2-page1+1) AS totalPages
         FROM Paper NATURAL JOIN Publication
         GROUP BY publication
         ORDER BY totalPages DESC;
      

  • Ergebnis

    • publication	totalPages
      PhD Thesis	181
      Master Thesis	156
      SNE Simulation Notes Europe	29
      Electronics	21
      Transactions of the Society for Computer Simulation	14
      5th International Modelica Conference	10
      10. Workshop der ASIM/GI-Fachgruppen STS/GMMS/EDU	8
      7. Workshop der ASIM/GI-Fachgruppen STS/GMMS	6
      IFAC-PapersOnLine	5
      8. Workshop der ASIM/GI-Fachgruppen STS/GMMS	4