A. Juozapavicius "Information Systems"

Catalog description:

Effective data-based solutions in an organization must be built on a solid strategic and organized framework, and modern information systems (IS) are to be designed primarily to serve this task. The integrating tools for IS nowadays are databases and Web interface. The course covers corresponding aspects of information management. It gives introduction to information systems, definitions, descriptions, concepts, trends and issues, classification of IS, information modeling, database planning, managing business rules, performance modelling, design and development methods, database models (conceptual, logical, physical ones), XML technology, information search and retrieval, IS integrity and quality.

The goals:

The fundamental methods for designing information systems in both theory and practice are studied, together with the methods for analyzing concepts of IS modeling and engineering methods. The students should learn important issues of information concepts, data base models, conceptual modelling, including advanced technologies like XML, Web databases, data access and indexing, life cycles of IS and databases. These fundamental methods will be learned also practically, by projects. Students model, design and implement a Web-based information system on a specific topic, covering all stages of IS development. The list of topics for IS (in Lithuanian language) are presented here.

The content:

  1. Introduction to information systems, definitions, descriptions, features
  2. IS types and classification
  3. Document retrieval systems, networks, "STN International" as an example
  4. IS planning, getting started, IS development methodology and organization
  5. Databases and their role in IS
  6. Web-based IS
  7. Information and enterprise data standarts, data management
  8. Information gathering and analysis
  9. Modelling business rules
  10. The conceptual modelling
  11. The logical and implementation modelling
  12. Performance modelling methods
  13. Performance design and development
  14. Structuring data: XML language, DTD, schemas, DOM, XPath, XMLQuery
  15. Physical database design and development
  16. IS physical implementation tools: pHP and MySQL
  17. IS integrity and quality
  18. Improvement of IS performance: user interface, indexing, testing, denormalization, concurrent processes

Textbooks and manuscripts:

  1. Introduction to information systems, issues of IS, classification of IS, management information systems, document retrieval systems (STN International as an example)
  2. Modeling the database: relational, hierarchical, and network models
  3. The semantic modelling of information system: E-R model and its design
  4. lifecycles of information system and database, modeling the database: object-oriented model, "object-oriented manifesto", object-oriented development in IS: analysis, design, implementation; object modelling, dynamic modelling, functional modelling;
  5. Multimedia information systems, multimedia databases, Dexter reference model.
  6. The description of XML: introduction, XML terminology, samples, XML reference
  7. The description of XML: main concepts of XML, scanners, namespaces, parsing, logical and physical structures
  8. The Data Type Description (DTD): basics, declarations, attribute types, conditional sections, examples
  9. The description of XML: schema, structures and parsers, Microsoft XML schema, specification, data, attributes, data types, W3C schema, XML resources, summary
  10. The description of XML: document object model (DOM), description, DOM and Javascript, Java components, resources, summary
  11. The description of XML: Simple API for XML - SAX, parsing, tree diagrams, examples, resources, summary
  12. The description of XML: document style transformations for XML - XSLT

References:

to the list of courses
to the CS II home page
to the Story of the Baroque in Lithuania