scholarly journals MzS Tools: GIS Methods and Tools for Seismic Microzonation Mapping

Author(s):  
Giuseppe Cosentino ◽  
Francesco Pennica ◽  
Emanuele Tarquini ◽  
Giuseppe Cavuoto ◽  
Francesco Stigliano

MzSTools is a plugin for QGIS developed by the National Research Council (CNR) as part of the activities concerning the coordination of seismic microzonation studies in Italy. It train from the need to create a practical and easy-to-use tool to carry out seismic microzonation (SM) studies by producing standards compliant geographic database and maps, thus making them accurate, homogeneous and uniform for all municipalities in Italy. A geodatabase based on SQLite/SpatiaLite Relational Database Management System (RDBMS). It has been designed to collect and store data related to elements such as: geognostic surveys; bedrocks and cover terrains; superficial and buried geomorphological elements; tectonic-structural elements; elements of geological instability such as landslide zones, liquefaction zones and zones affected by active and capable faults; homogeneous microzones in seismic perspective, microzones characterized by a seismic amplification factor. The QGIS plugin provides tools such as data entry forms designed with Qt Designer; a QGIS project template with layers, symbol libraries and graphic styles; layouts for the SM Maps. MzSTools assembles in a single software environment a set of useful tools for those who work in. The plugin is open source, whose code hosted on the GitHub platform, and is published via the official QGIS plugins repository (https://plugins.qgis.org/plugins/MzSTools/).

Author(s):  
Francisco Alberto Calderon ◽  
Emilce Gisela Giolo ◽  
Carlos Daniel Frau ◽  
Marcelo Gerardo Jesús Guevara Rengel ◽  
Hernan Rodriguez ◽  
...  

Seismic microzonation of a city can be a difficult and expensive undertaking depending on the method used. In the last years, the HVSR method has been one of the most popular ways to define the natural frequency of the soil and seismic amplification factor in order to make quick microzonations due to that it is an expeditious and cheap method. This is very important in developing countries and poor countries. The fundamental reason to use this method is the fact that the amplification factor has well correlation with damage distribution. Additionally with the help of another methods it is possible obtain the structure of the superficial soil strata. In this chapter, an introduction with seismic microzonation, site effects concepts, microtremors, description of the HVSR method, advantages and disadvantages of this method, limitations and comparison with other methods, are presented. Finally, highlight of the importance of the method in order to identify site effects are displayed as examples and the incorporation of these data to Geographic Information Systems is also shown.


Author(s):  
Mohammad Subekti ◽  
Anthoni Tandiono ◽  
Fenky Tania ◽  
Hendro Wibowo A.

The purpose of this study is to develop an e-commerce that can distribute any information about the products of PD Cross Tech. The e-commerce is supported by dynamic DBMS and can be connected via database reseller server so that it can do information sharing. The distribution is performed using the Distributed Relational Database Management System (DRDBMS), supported by the File Transfer Protocol and Virtual Private Network. In other words the e-Commerce supports multiplatform database. Research methodologies used are analytical methods, design methods, and literature study. Results showed that PD Cross Tech needs a new e-Commerce that supports multiplatform database. With this e-Commerce, it is expected that similar computer equipment needs for many organization in Indonesia can be designed in the same way.


Author(s):  
Sonali Tidke

MongoDB is a NoSQL type of database management system which does not adhere to the commonly used relational database management model. MongoDB is used for horizontal scaling across a large number of servers which may have tens, hundreds or even thousands of servers. This horizontal scaling is performed using sharding. Sharding is a database partitioning technique which partitions large database into smaller parts which are easy to manage and faster to access. There are hundreds of NoSQL databases available in the market. But each NoSQL product is different in terms of features, implementations and behavior. NoSQL and RDBMS solve different set of problems and have different requirements. MongoDB has a powerful query language which extends SQL to JSON enabling developers to take benefit of power of SQL and flexibility of JSON. Along with support for select/from/where type of queries, MongoDB supports aggregation, sorting, joins as well as nested array and collections. To improve query performance, indexes and many more features are also available.


2021 ◽  
pp. 47-78
Author(s):  
Jagdish Chandra Patni ◽  
Hitesh Kumar Sharma ◽  
Ravi Tomar ◽  
Avita Katal

2017 ◽  
pp. 1-6
Author(s):  
Richard Mansour ◽  
Samip Master

Purpose Quality measurement and improvement is a focus of ASCO. In the era of electronic health records (EHRs), computerized order entry, and medication administration records, quality monitoring can be an automated process. The EHR data are usually stored within tables in a relational database management system. ASCO Quality Oncology Practice Initiative measure NHL78a (hepatitis B virus antigen test and hepatitis B core antibody test within 3 months before initiation of obinutuzumab, ofatumumab, or rituximab for patients with non-Hodgkin lymphoma) presents an opportunity for automation of a quality measure using existing data in the EHR. Methods We used a locally developed Structured Query Language (SQL) language procedure in the Microsoft SQL Query Manager to access the EPIC CLARITY database. Access to the relational database management system of the EHR permits rapid case identification (the denominator set) of the unique ID of all of the patients who have received one of the target medications (ie, obinutuzumab, ofatumumab, or rituximab). Then, we went through a six-step process to find the number of patients who passed or failed the quality measure. Results When the final SQL procedure executes, it takes < 5 seconds to see the result set for a 12-month period. The procedure can be changed to incorporate a desired date range. Once the SQL procedure is created, there is essentially no labor and low costs to run the procedure at specific time intervals. Conclusion Our method of quality measurement using EHRs is cost effective, fast, and precise, and can be reproduced at other centers.


Sign in / Sign up

Export Citation Format

Share Document