The work proposes a conception of setup and use of teacher’s or lecturer’s workspace using common software and hardware products. The research object is a system built by using operating system capabilities in conjunction with office suite and public cloud service, as a foundation for teacher’s digital workspace. Research is made on how to set up, scale, and operate such a system, by studying the experience of national and foreign scientists and teachers, and using our own experience in educational processes, and working with operating systems and cloud services. As a result, we got a system which is easy to set up, learn, and apply by teachers without significant experience working remote education systems, and could be used for initial learning of remote education principles. It could be used as an initial step before migrating to specialized remote education systems. In the future, the system itself could be improved by adding additional objects into the system and a higher integration level between objects and external subjects.
The work proposes a conception of setup and use of teacher’s or lecturer’s workspace using common software and hardware products. The research object is a system built by using operating system capabilities in conjunction with office suite and public cloud service, as a foundation for teacher’s digital workspace. Research is made on how to set up, scale, and operate such a system, by studying the experience of national and foreign scientists and teachers, and using our own experience in educational processes, and working with operating systems and cloud services. As a result, we got a system which is easy to set up, learn, and apply by teachers without significant experience working remote education systems, and could be used for initial learning of remote education principles. It could be used as an initial step before migrating to specialized remote education systems. In the future, the system itself could be improved by adding additional objects into the system and a higher integration level between objects and external subjects.
Relational database management systems and the SQL language itself do not have any built-in mechanisms for storing and managing hierarchical structures. There are several different ways to represent trees in relational databases. This paper considers the method of modeling hierarchical data structures in the form of Adjacency Lists and Closure Tables. For each method, there are examples of writing queries to solve typical problems encountered when working with tree structures: finding all descendant leaves, all descendants and ancestors of a given leaf, moving a leaf to another ancestor leaf, and deleting leaves with all its descendants. The possibility of using recursive queries when displaying the entire tree in the Adjacency List model is considered. If the depth of the tree is not known, or it is not known at what level the specified element is, the query can not be built by standard means of the SELECT statement, then you need to create a recursive procedure, or write a recursive query. In order to avoid recursion when outputting the whole tree, all nodes of the subtree, and finding the path from a certain place to the root, the modeling of hierarchical data structures is performed in the form of a connection table (Closure Table). This complicates the process of adding a new leaf and moving the leaf to another ancestor leaf. In this case, to simplify the writing of queries, it is suggested to create triggers that will build or rebuild the links. Given the fact that sometimes there is a need to preserve dependent, in particular hierarchical structures in a relational database, you need to be able to plow the model of preservation of such data. The choice of method for solving a specific problem is influenced by the speed of basic operations with trees. Exploring different options for organizing SQL tree structures will allow you to understand and choose the best way to build such a structure in a relational database for a specific task. All SQL queries in this paper were created and tested for Oracle relational databases.
The paper analyzes the causes and ways of solving the problem of free space lack on the system partition during the OS Windows exploitation. The peculiarities of the system partition organization during the installation of common Microsoft operating systems are analyzed. The main system file objects, paths to them, their purpose and role in the use of system partition space and in the functioning of the operating system are considered. Represented the list of paths to the files of the folders that occupy the largest volumes on the system partition. Thees folders correct cleaning or configuring may save a lot of space on the system partition. The main tools of the operating system for the cleaning methods implementation are considered: command line interpretator, PowerShell environment, system registry editing tools, and system library function calling tools. Particular attention is paid to batch files as the simplest and most effective means of implementing automated use of system utilities, taking into account the peculiarities of the command line interpreter. One of the ways to manipulate objects with commands is to use the PowerShell environment. This environment is able not to process commands, but to generate streams of objects related to this command and form their processed representation using both command and graphical interface. Described the logical and physical structure of the registry as one of the tools for managing Windows settings. Was made the comparative analysis of some software products, such as the system console utility for servicing deployment and management images, as well as a number of free software. It has generated the list of functions used for the system partition optimization and cleaning from excessive data. Based on the generated list, the efficiency of using the considered software tools for cleaning the system partition is analyzed.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.
hi@scite.ai
10624 S. Eastern Ave., Ste. A-614
Henderson, NV 89052, USA
Copyright © 2024 scite LLC. All rights reserved.
Made with 💙 for researchers
Part of the Research Solutions Family.