Course code 02 50 6217 00
Number of ECTS points 2
Course title in the language of instruction 
Mobilne systemy baz danych
Course title in Polish Mobilne systemy baz danych
Course title in English 
Mobile Database Systems
Language of instruction Polish
Type of classes
Lecture Tutorials Laboratory Project Seminar Other Total of teaching hours during semester
Contact hours 10 10 0 20
E-learning No No No No No No
Assessment criteria (weightage) 0.50 0.50 0.00
Unit running the course Instytut Mechatroniki i Systemów Informatycznych
Course coordinator dr inż. Maciej Kacperski
Course instructors dr inż. Maciej Kacperski
Prerequisites 
Databases, Java programming
Course learning outcomes
  1. Student is able to define types and principles of operation of mobile systems
  2. Student is able to explain the use of various database systems in mobile devices
  3. Student is able to describe and apply GPS satellite navigation systems as well as BlueTooth and WiFi wireless communication
  4. Student is able to design and create mobile applications using various database systems as well as embedded sensors and sensors
Programme learning outcomes
  1. Students knows and understands current trends of computer science and information technology.
  2. Student has deep knowledge and understanding of computer science fundamentals and advanced concepts, has some level of expertise in selected topics from various areas of computer science.
  3. Student is able to analyse a complex problem and propose innovative solutions, showing creativity in combining knowledge of computer science and other, problem-specific areas, being flexible enough to address even rapidly changing conditions.
  4. Student is able to design, implement and evaluate an IT system that fulfils imposed requirements, by selecting appropriate IT techniques and tools for this purpose, implementing or adapting those techniques and tools when needed.
  5. Student is able to combine computer science theories, specialized knowledge of various IT areas and research results in the process of working out a solution to a problem.
Programme content The problems of data processing in mobile devices will be presented. The solutions for collecting data in various formats and places from local databases to dedicated servers and cloud databases will be characterized. Wireless communication and data transmission systems will be discussed. The sensors and GPS systems embedded in mobile devices are presented. Application construction methods using the capabilities of mobile devices and various forms of data collection and synchronization will be presented. In particular, students will be able to design and create mobile applications using sensors and cloud databases
Assessment methods 
1, 2 test
3, 4 reports from exercises performed
Grading policies The final grade consists of: test result - 50% and assessment of reports - 50%. The final grade is the sum of points obtained, the condition of getting credit is getting at least 50% of each component.
Course content LECTURE Types and principles of operation of mobile systems. Architecture of GSM systems, digital signal transmission model, A / C and C / A converters, source encoders, communication channel encoders, types of modulation. PCM, DPCM, ADPCM, DM, LPC, CELP, VSELP source encoders. Communication channel models, redundant coding, detection and correction codes - BCH, ARQ technique, convolutional and block coder, error diffusion - interlaced - array and convolutional. Modulations - phases, frequencies and amplitudes, multiple access, narrowband and broadband systems - FDMA, TDMA, CDMA. Satellite data transmission and satellite navigation systems - GPS Application of databases in mobile systems, local databases, dedicated database systems, databases in the cloud. . SQL and NoSQL databases and their application in mobile devices Operating systems for mobile devices, Creating mobile applications using integrated programming environments LABORATORY Understanding and using existing development environments for mobile applications. Construction and creation of mobile applications using built-in sensors and sensors. Creating applications for mobile devices using data storage and synchronization for various types of databases with particular emphasis on distributed databases
Basic reference materials 
  1. Ramez Elmasri, Shamkant B. Navathe, Wprowadzenie do systemów baz danych. Wydanie VII. Helion 2019
  2. . Wesołowski, Systemy radiokomunikacji ruchomej, WKŁ, 2006
  3. M. Clark. Wireless Access Networks. Wiley, 2002
  4. W.Hołubowicz, P. Płóciennik. GSM cyfrowy system telefonii komórkowej. EFP, 1995
  5. Marcin Płonkowski, Android Studio. Tworzenie aplikacji mobilnych, Helion 2017
  6. Shane Conder, Lauren DarceyAndroid. Programowanie aplikacji na urządzenia przenośne. Wydanie II, Helion 2011
  7. Gail Rahn Frederick, Rajesh Lal, Projektowanie witryn internetowych dla urządzeń mobilnych, Helion 2010
  8. Jacek Matulewski, Bartosz Turowski, Programowanie aplikacji dla urządzeń mobilnych z systemem Windows Mobile, Helion 2010
Other reference materials 
  1. Leonard Lobel, Eric D. Boyd, Microsoft Azure SQL Database Krok po kroku, Helion 2014
  2. Guy Harrison, NoSQL, NewSQL i BigData. Bazy danych następnej generacji, Helion 2019
Average student workload outside classroom 
36
Comments
Updated on 2022-04-22 12:15:03
Archival course yes/no no