Data-driven Systems

Adatvezérelt rendszerek

A tantárgyleírás hatályossága

Hatályosság kezdete:

2026. March 21.

Hatályosság vége:

—

Subject name (Hungarian, English)

Adatvezérelt rendszerek

Data-driven Systems

Subject code

BMEVIAUAC01

Subject type

—

Training Level

—

Course types and hours (weekly/semester)

Course type	lecture	tutorial	laboratory
hours (weekly)	2	1	0
type (linked/independent)	—	derived course	—

Assessment type

vizsga

Credits

Subject coordinator

DR. Hideg Attila

position: adjunktus

contact: hideg.attila@vik.bme.hu

Responsible department

Automatizálási és Alkalmazott Informatikai Tanszék

https://www.aut.bme.hu

Faculty

Villamosmérnöki és Informatikai Kar

Subject website

https://www.aut.bme.hu/Course/VIAUAC01

Primary curriculum type

—

Direct prerequisites – Strong prerequisite

none

Direct prerequisites – Weak prerequisite

none

Direct prerequisites – Parallel prerequisite

none

Direct prerequisites – Milestone prerequisite

none

Direct prerequisites – Exclusion

none

Objectives

Programme

Week	Lecture content
1	Introduction, data-driven systems architektúrái (three-tier architecture).
2	Transactions in data base management systems; the Microsoft SQL Server platform.
3	Advanced SQL language, data base server-side programming (Microsoft SQL Server platform, T-SQL language, stored procedures and triggers).
4	Advanced SQL language, data base server-side programming (Microsoft SQL Server platform, T-SQL language, stored procedures and triggers).
5	NoSQL data bases, document storage in NoSQL data bases; MongoDB platform, simple operations in MongoDB.
6	Queries and their efficiency in Microsoft SQL Server SQL Server. Execution plans and query optimization.
7	Data dictionaries. Semi-structured data (XML, JSON) storage and handling.
8	Data access layer, object-relational mapping, design patterns in the data access layer (repository).
9	Object relational mapping frameworksin .NET, ADO.NET, Entity Framework and Linq to Entity Framework.
10	Object relation frameworks in Java: JPA and QueryDSL
11	Business logic in Java: JavaEE, Spring, SpringData
12	Business logic in .NET: ASP.NET Core platform, middleware services, Web API.
13	Business logic in .NET: ASP.NET Core platform, middleware services, Web API.
14	Implementing a modern web application: summary of the semester through an example.

During the seminars, held in computer laboratories, students will solve tasks in connection to the lectures:

Seminar	Seminar content
1	Transaction properties, platform specific behaviors in Microsoft SQL Server
2	Advanced SQL language and data base server-side programming of Microsoft SQL Server
3	Introduction to MongoDB: collections and basic queries.
4	Object-relational mapping: JPA, SpringData
5	Object-relational mapping: Entity Framework
6	Implementing three-tiered application backend using REST API
7	Implementing three-tiered application backend using REST API

The goal of this course if to teach students the most commonly used techniques in developing data-driven and backend systems. Students will learn various methods for implementing systems built on data bases, typical solutions and techniques in the data access and business logic layers. The course presents the usage of various data base management systems in complex software development scenarios, and details the processes and solutions used by modern data managing (backend) applications. Obtainable knowledge: By completing the course, students are familiarized with the most commonly used data base engines (Microsoft SQL Server and MongoDB), their structure and operation, writing efficient SQL queries, optimizing them, handling transactions, locks, the proper usage of isolation levels, and server side programming techniques (stored procedures, triggers). Various data access libraries are presented (including ADO.NET), as well as commonly used ORM frameworks (such as Entity Framework and JPA). The course presents serialization techniques of server-side objects (XML, JSON), and protocols for accessing such objects remotely (Web Service, REST), including the software environments (like ASP.NET Core Web API).

Learning outcomes

Ez a tantárgy a KKK rendeletben meghatározott, következő kompetenciák fejlesztését szolgálja:

Knowledge

No learning outcomes recorded.

Skills

No learning outcomes recorded.

Attitudes

No learning outcomes recorded.

Autonomy and responsibility

No learning outcomes recorded.

Oktatási módszertan

Lectures and seminars. The lectures may build upon material to process and learn at home.

Tanulástámogató anyagok

Online források

· ; Leonard; Lobel and Andrew Brust: Programming Microsoft SQL Server 2012, Microsoft Press,; ISBN: 978-0735658226; Grant; Fritchey: SQL Server Execution Plans, Simple Talk Publishing, 2012. Ebook: https://www.red-gate.com/products/dba/sql-monitor/entrypage/execution-plans; Kristina Chodorow: MongoDB: The Definitive; Guide: Powerful and Scalable Data Storage, O'Reilly Media, Second Edition. ISBN 978-1449344689.; Mark; J. Price: C# 7 and .NET Core: Modern Cross-Platform Development: Create; powerful cross-platform applications using C# 7, .NET Core, and Visual Studio; 2017 or Visual Studio Code. Packt Publishing, 2nd Edition. ISBN: 978-1787129559.; Dino; Esposito: Programming ASP.NET Core, Microsoft Press. ISBN; 978-1509304417.; Pollack, Oliver Gierke, Thomas Risberg, Jon Brisbin, Michael Hunger: Spring; Data: Modern Data Access for Enterprise Java. O'Reilly Media, 1st Edition.; ISBN-13: 978-1449323950.; Subbu; Allamaraju: RESTful Web Services Cookbook: Solutions for Improving Scalability; and Simplicity. Yahoo Press, 1st Edition. ISBN: 978-0596801687.

Recommended preliminary knowledge for completing the subject

Knowledge type competencies

(azon előzetes ismeretek összessége, amelyek megléte nem kötelező, de a tantárgy eredményes teljesítését nagyban elősegíti)

C# and SQL knowledge is required

Skill type competencies

(azon előzetes képességek és készségek összessége, amelyek megléte nem kötelező, de a tantárgy eredményes teljesítését nagyban elősegíti)

nincs

Recommended (non-compulsory) preliminary competencies

(azon ajánlott (nem kötelező) előzetesen megszerzendő kompetenciák összessége, amelyek jelentősen hozzájárulnak a tantárgy eredményes teljesítéséhez)

C# and SQL knowledge is required

General rules

Requirements: During the semester 1. One midterm exam 2. The seminars provide the opportunity to put the gained knowledge into practice. Students must be present at the seminars and work with the instructor. During the semester there are opportunities to complete optional homework assignments. By completing these optional homeworks extra points can be earned, that are added to the exam results. In order to receive signature for the course, students must: o must pass the midterm exam, and o the student must be present at the seminars as required by the Code of Study and Exams. In the exam period: Written exam. Final grade is calculated by summing the exam points and the extra points obtained during the semester. The final grade is: 0-40p fail, 41-55p pass, 56-70p satisfactory, 71-85p good, 86-100p very good. Additional possibilities: The mid-term test can be repeated once during the semester. There are no repeated seminars. However, absense from seminars is allowed with proof of a good reason, such as illness (with official record of it presented). Homeworks cannot be repeated. Exams may be repeated as the Code of Studies allows it.

Assessment methods

In-term assessments

No detailed assessments provided.

Weight of in-term assessments

No weights provided.

Exam-period assessments

No detailed assessments provided.

Weight of exam elements

No weights provided.

Grade calculation

No grade thresholds provided.

Attendance requirements

No attendance requirements provided.

Rules for retake and resubmission

Not provided.

Short description

Not provided.

Detailed description

Not provided.

Recommended courses

Recommended preliminary subjects: Software techniques, Databases

Workload to complete the subject

No workload breakdown provided.

Validity of subject requirements

Requirements valid from:

—

Requirements valid until:

—

Curriculum placement

No curriculum placements recorded for this subject version.