Microsoft SQL Server Research Articles

Lessons learned from developing a statewide research data repository to combat the opioid epidemic in Alabama.

Many states are continuing to struggle with opioids and other commonly abused drugs. Alabama, being the highest opioid prescription per-capita state since 2012, has pulled together state agencies, private companies, academia, and community organizations to form a data council and repository to provide unified insights and information to the public and partner stakeholders. The lessons learned in constructing this data environment are documented so that other states and organizations can benefit from the challenges and success that Alabama has experienced. The centralized data repository consists of almost a dozen data streams from public agencies and private companies. The data are transformed and linked within the repository to provide geo-temporal linkages between data sources. The data are stored in a secure multi-tiered environment in a Microsoft SQL Server database, de-identified, aggregated, and then published to a public web portal for open consumption. The public-facing website from the project successfully integrates multiple disparate data sources into a common platform for streamlined and cohesive data communications. Drug addiction cannot be easily quantified, viewed, or otherwise examined when only looking at a portion of society. By bringing together multiple data sources and linking them, a more clear picture of trends, influences, and metrics can be obtained. A statewide drug use data partnership between public and private entities is both possible as well as beneficial to all parties involved. Items like legal contracts can inhibit data sharing, but certain best practices can help scale and streamline multiple agreements.

Database Recovery Techniques in Microsoft SQL Server

Enformasyona dayalı büyük verilerin paylaşıldığı günümüzde verinin korunması, saklanması ve erişilmesi kritik öneme sahiptir. Korunan bir veri ihtiyaç duyulduğunda erişilebilir olmalıdır. Dijitalleşme ve dijital dönüşüm veri saklama ve depolama teknolojilerinde büyük değişimlere neden olmaktadır. Veri yedek alma araçlarının boyutları küçülürken kapasiteleri yükselmekte, daha uygun maliyette ve daha hızlı güvenilir teknolojilere doğru ilerlemektedir. Tüm bu olumlu gelişmelere rağmen verilerin saklandığı cihaz ve sistemler üzerinde bozulma problemleri yaşanmaktadır. Bunun sonucunda veri erişim sorunları oluşmaktadır. Bu sorun veriye dayalı işlemlerin gerçekleştiği bir kurumda iş süreçlerinin durması demektir. Çalışmada geçen her bir sürenin kuruma vereceği hasar oldukça büyüktür. Diğer taraftan bankacılık, eğitim, savunma, sağlık, sigorta, tarım, telekomünikasyon gibi sektörlerde veriler genellikle Microsoft SQL, My SQL, Postgre SQL ve Oracle benzeri ilişkisel veri tabanlarının biri veya birkaçı üzerinde tutulur. Bu veri tabanları veya sunucular üzerinde yaşanabilecek bir bozulma olayı karşısında verinin hangi teknik, süreç ve yöntemlerle nasıl kurtarılması konusunda yeni araştırmalara ihtiyaç vardır. Bu konu dijital veri altyapıların sürekliliğinin sağlanması bakımından kritik öneme sahiptir. Veri tabanı erişiminde yaşanabilecek ani bir kesinti karşısında hızlı bir çözüm üretilememesi durumunda iş sürekliliğinde ciddi sorunlara neden olur. Microsoft veri tabanı kullanımında karşılaşılan bozulma nedenleri, bunlara karşı alınabilecek önlemler, tutarlılık kontrolleri ve veri tabanı kurtarma yöntemleri araştırılmıştır. Büyük veri merkezlerinde kullanılan Microsoft SQL sunucusunda veri tabanı kurtarma senaryolarına dayalı teknik ve yöntemler incelenmiştir. Veri tabanında yaşanabilecek bir bozulma problemin en kısa sürede en az hasarla atlatabilmenin yöntemleri anlatılmış, VT kurtarma senaryoları üzerinden uygulama pratikleri çalışılmıştır. Bu çalışma aynı zamanda öğrenci, araştırmacı ve teknik çalışanlar için bir kılavuz niteliğindedir.

Teaching Application and Evaluation of Ideological and Political Courses Based on Multisource Data Fusion

Domestic education and scientific nature of realization automatic evaluation have become issues of concern. The integration of information technology in the teaching field of ideological and political theory courses in colleges and universities (hereinafter referred to as “ideological and political courses”) inevitably has an important impact on the teaching of traditional ideological and political courses. ASP.NET is the main interface technology of .NET. .NET is an environment that can provide support for building development and execution in multiple languages, and realizes the functions of language development, code compilation, building configuration, program operation, and object interaction. The system development tool is ASP.NET (Visual Studio 2013), the background database development tool is Microsoft SQL Server 2008, and the system development environment is Windows 7 ×64. The core of the system is multisource data fusion. Firstly, the data are preprocessed to extract useful information data to form data object fusion. Then, convert the code table into a transaction library. In view of the large amount of data to be mined and easily affect mining quality, the improved Apriori-P algorithm based on partitioning in association with rule technology is applied. This algorithm is used to generate frequent itemsets. According to the given minimum confidence, a data fusion rule is generated. Then, the fusion result is generated from the corresponding data report. Before data fusion, system administrators should select data sources from historical databases or existing evaluation databases. When querying rules, different users can log in to the system to query their own data content, students can query the teacher’s evaluation results, teachers can query their own evaluation results, and school administrators can view the data fusion results. After evaluating teachers through the campus network, all evaluation data can be integrated and analyzed, and the system automatically generates analysis results corresponding to users. The stability of the teaching evaluation system is better, and the system performance can reach 89% at 5,000 person-hours. The degree of integration between the form of informatization teaching and the teaching content of ideological and political courses, and the information literacy of teachers of ideological and political courses in colleges and universities need to be further improved. This research helps in scientific education. For the problems existing in the current research, starting from the three aspects of teaching concept, teaching mode, and teachers’ information literacy, it proposes corresponding effective ways to promote the deep integration of information technology and ideological and political teaching in colleges and universities.

Online employee performance management system

The “Online employee performance management system” aims to design a framework system for a working community. But, these projects of planning the various tasks whether they might be private or official, may lead to a problem if it is not maintained properly. The mailing process in companies may lead to loss of time management in searching for the required information and potentially cause information overload. Online Employee Performance Management System is a distributed application, created to keep up with the information and details of employees working in any association. It keeps up with the data about the individual task execution of their employees. The application is a set-up of utilizations created utilizing PHP. It is easy to comprehend and can be utilized by any individual who isn't even acquainted with an employee’s framework. It is easy to use and simply requests that the client follow bit-by-bit tasks by giving a few choices. It is quick and can perform numerous tasks for an organization or association. The project has been created utilizing the strong coding devices of HTML, CSS, and PHP at Front End and Microsoft SQL Server at Back End. The application is very easy to use.

MANAGEMENT INFORMATION SYSTEM DESIGN OF PRODUCTION AND SALES AT PT MANDIRI TEGUH INTI SEJAHTERA

The change of a period is marked by the development of technology at that time. The development of technology, especially information technology, is related to the increasingly sophisticated computer technology used throughout the world. This makes the role of computers is very important in all aspects of human life. PT Mandiri Teguh Inti Sejahtera is a company that runs a pile production business. Data processing is still done manually such as on calculation process in determining raw materials for production. Sometimes errors in calculation can lead in to errors in production as well. Technique of analyzing and designing system is Unified Modelling Language (UML), database design uses Microsoft SQL Server 2008 and the application is designed using Microsoft Visual Basic.Net 2010. The results is Information System Design of production and sales, it can help PT Mandiri Teguh Inti Sejahtera to produce more precise and accurate information in data processing and decision making processes that are more effective and efficient.

Implementasi Metode Double Exponential Smoothing pada Prediksi Jumlah Penjualan Kain Pantai

Y2K Batik is an SME (Small and Medium Enterprise) engaged in batik. Y2K Batik produces and sells beach wear with various motifs. One of the important things in business is inventory of merchandise, inventory of merchandise is a factor in determining the success of a trading company to achieve its goals, because the goods sold affect the level of income to increase company profits. With these considerations, it is necessary to analyze the production of beach wear for the availability of merchandise in fulfilling customer orders. Based on the above background, the scope of the problem in this study is master data collection obtained from records of selling beach batik cloth periodically from time to time. By utilizing the existing data and applying certain methods, a sales forecasting prediction can be made using the Double exponential Smoothing method. From the results of calculations and testing of forecasting data on the Mandala Motif Beach Fabric variable with the most optimal value using = 0.9 of 2127 with an error value of 19.46% and an accuracy rate of 80.54% (Good). The Canting Motif Beach Wear variable with the most optimal value using = 0.9 of 3174 with an error value of 3.61% and an accuracy rate of 96.39% (Very Good). Double Exponential Smoothing is the most widely used method to determine the trend equation of the second smoothing data through a smoothing process. The programming language uses Microsoft Visual Studio 2013 and the DBMS uses Microsoft SQL Server 2012. The purpose of this research is to create a system that can simplify the process of analyzing the production of beach wear in order to meet the availability of goods ordered by customers.

REPRESENTATION OF COMFORT INDICATORS BY MEANS OF DFD-DIAGRAMS

A study was conducted using the Dataflow diagramming to describe the information flows of the subject area "Comfortable living in an apartment building", where the construction process is presented in the form of a decomposition diagram and construction of a context diagram of the 0th level. Therefore, the DFD chart includes the following indicators of comfort: 1. Factors of comfortable living in the neighborhood. 2. Factors of comfort of the house territory. 3. Factors of home comfort. 4. Factors of apartment comfort, as well as a description of external entities (expert, buyer, construction company) and their impact on all indicators of comfort. Next, we present and describe the input and output data streams in which information is determined and transmitted from the source (process, external entities) to the receiver (external entities, processes). After constructing the context diagram, we obtained a complex system, which is further presented in the form of a hierarchy of the context diagram of the 1st level and contains a set of four subsystems and is connected by data streams and form data warehouses (environment, fuzzy set, norm), which are the prototype of the future database. As a result of research of the DFD chart of the 1st level we received: 1. The main functions are defined. 2. Described objects. 3. The main data streams are defined. 3. Creating an information system using data warehouses. The following is the 2nd level of the DFD chart and we use it for a detailed description of the information system, which provides an opportunity to consider in more detail the work of the designed system "Comfort of the neighborhood", namely the detail of the lower level process. Accordingly, each process coexists with the top-level process and I use the structural process numbers. We detail the process of the DFD chart of the 1st level 1.2, which contains 2 processes: (processing pedestrian accessibility, 1.2.2 Processing noise level) and describes the hierarchy of input and output data streams into the system. Next, we move from data warehouses to building a database model, which we present in the form of such diagrams (conceptual model, data model and physical model). The first step is to build a conceptual design, which is described using a table called "Attributes of entities and the relationship of entities). The second stage is the creation of a data model based on the created "Connection of entities", and has the following external keys: (norm, fuzzy set, linguistic variable). Next, we present a physical model where Microsoft SQL Server was processed and the data types are specified accordingly.

PENGEMBANGAN SISTEM INFORMASI SIMPAN PINJAM PADA KOPERASI WREDATAMA KRAKATAU STEEL (KOPWEKAS)

The main activity of cooperatives is to carry out savings and loan transactions for cooperative members only. Every transaction carried out at the Wredatama Krakatau Steel Cooperative (Kopwekas) already uses a database-based application that only requires a few problems including data collection on deposits, credit data collection, and payment processing as well as arrears of cooperative members. It is necessary to develop a savings and loan information system. The methodology used in the design of this information system is the Waterfall Method. This system is designed using the concepts of UML (Unifield Modeling Language) and implemented using Microsoft SQL Server 2000 Database, and Visual Basic 6.0. The expected result of this research is the development of a savings and loan information system of kopwekas which includes processing of deposits, credit, payments and arrears of cooperative members. By using this information system, it is also hoped that the reporting process will be easier, faster with accurate data.
 Keywords: Information System, Savings and Loans, Waterfall, Cooperative

Assessment of SQL and NoSQL Systems to Store and Mine COVID-19 Data

COVID-19 has provoked enormous negative impacts on human lives and the world economy. In order to help in the fight against this pandemic, this study evaluates different databases’ systems and selects the most suitable for storing, handling, and mining COVID-19 data. We evaluate different SQL and NoSQL database systems using the following metrics: query runtime, memory used, CPU used, and storage size. The databases systems assessed were Microsoft SQL Server, MongoDB, and Cassandra. We also evaluate Data Mining algorithms, including Decision Trees, Random Forest, Naive Bayes, and Logistic Regression using Orange Data Mining software data classification tests. Classification tests were performed using cross-validation in a table with about 3 M records, including COVID-19 exams with patients’ symptoms. The Random Forest algorithm has obtained the best average accuracy, recall, precision, and F1 Score in the COVID-19 predictive model performed in the mining stage. In performance evaluation, MongoDB has presented the best results for almost all tests with a large data volume.

Development of a bacterial regulatory motif database

O b j e c t i v e s . The amount of data generated by modern methods of high-throughput sequencing is such that their analysis is performed mainly in automatic mode. In particular, the use of newly decoded genomic sequences is possible only after the annotation of functional elements of the genome, which, as a rule, is performed by automatic pipelines. Such annotation pipelines do a good job to identify the genes, but none of them annotate regulatory elements. Without these elements it is not possible to understand when and how genes can be expressed. Information on the regulatory elements of bacteria is collected in several specialized databases (RegulonDB, CollecTF, Prodoric2, etc.), however, only a part of this information can be used for annotation of regulatory elements, and only for a very limited range of bacteria. Previously, we proposed a clear formal criterion for applying regulatory information to any bacterial genome. Such a criterion is the CR tag, a sequence of amino acid residues of a transcriptional regulator that specifically contacts the nitrogenous bases of regulatory element in genomic DNA. The mathematical model of a regulatory element (motif) associated with a CR tag can be correctly applied to annotate similar elements in any genomes encoding a transcriptional regulator with an identical CR tag. The accumulation of motifs associated with CR tags raised the question of their ordered storage for the convenience of subsequent use in the annotation of genomic sequences. Since no one of well-known databases uses the concept of CR tags, a new database ought to be developed. Thus, the goal of this work is to create a database with information about bacterial transcription factors and DNA sequences recognized by them, suitable for annotation of regulatory sequences in bacterial genomes.M e t h o d s . Infological modeling of the subject area was carried out using the IDEF1X methodology. The database was developed using the Microsoft SQL Server DBMS. A cross-platform application for importing data into a database is written in C++ using Qt technology.Re s u l t s . As a result of the study of the subject area, a relational data model was developed and implemented in the Microsoft SQL Server DBMS, which allows holistic storage of information about accumulated transcription regulation motifs in bacteria, including information about the publications confirming their correctness. To automate the process of entering accumulated data, a cross-platform application was developed for importing structured data on transcription factors.Co n c l u s i o n . The main difference of the developed database is the use of CR-tag concept. Records of mathematical models of regulatory elements (motifs) in the database are associated with a CR tag and, therefore, can be correctly used to annotate similar elements in any genomes encoding a transcriptional regulator with an identical CR tag. The developed database will provide structured and holistic data storage, as well as their quick search when used in the pipeline for automatic annotation of regulatory elements in bacterial genomic sequences.

Data Warehouse Design for Big Data in Academia

This paper describes the process of design and construction of a data warehouse (“DW”) for an online learning platform using three prominent technologies, Microsoft SQL Server, MongoDB and Apache Hive. The three systems are evaluated for corpus construction and descriptive analytics. The case also demonstrates the value of evidence-centered design principles for data warehouse design that is sustainable enough to adapt to the demands of handling big data in a variety of contexts. Additionally, the paper addresses maintainability-performance tradeoff, storage considerations and accessibility of big data corpora. In this NSF-sponsored work, the data were processed, transformed, and stored in the three versions of a data warehouse in search for a better performing and more suitable platform. The data warehouse engines—a relational database, a No-SQL database, and a big data technology for parallel computations—were subjected to principled analysis. Design, construction and evaluation of a data warehouse were scrutinized to find improved ways of storing, organizing and extracting information. The work also examines building corpora, performing ad-hoc extractions, and ensuring confidentiality. It was found that Apache Hive demonstrated the best processing time followed by SQL Server and MongoDB. In the aspect of analytical queries, the SQL Server was a top performer followed by MongoDB and Hive. This paper also discusses a novel process for render students anonymity complying with Family Educational Rights and Privacy Act regulations. Five phases for DW design are recommended: 1) Establishing goals at the outset based on Evidence-Centered Design principles; 2) Recognizing the unique demands of student data and use; 3) Adopting a model that integrates cost with technical considerations; 4) Designing a comparative database and 5) Planning for a DW design that is sustainable. Recommendations for future research include attempting DW design in contexts involving larger data sets, more refined operations, and ensuring attention is paid to sustainability of operations.

Design and development of human resource management computer system for enterprise employees.

Client-Server (C/S) application is always used in the existing Human Resource Management System (HRMS) as the system architecture, which has the problems of complex maintenance and poor compatibility; and cannot use professional database and development system, making the system development difficult and the data security low. To solve the above problems, the overall demand is analyzed, as well as feasibility and key technologies of the enterprise HRMS system. Then a HRMS is designed and developed, based on the user’s key functional requirements and related technologies, which is reasonable and easy to maintain. The system is supported by Browser-Server (B/S) structure, with the current popular Java 2 Platform Enterprise Edition (J2EE) multi-level structure as the overall architecture. The mature Microsoft SQL Server 2008 introduced by Microsoft is used as the database platform. Combined with Model View Controller (MVC) design pattern, this system can be used by users without geographical restrictions and system maintenance. In this system, performance logic and business logic are separated, which makes it convenient for the development and maintenance of the system. The system mainly includes six modules: personnel management, organizational management, recruitment management, training management, salary management and system management, which integrates enterprise information and realizes the functions of easy access and easy query of information database. Its interface is simple, easy to understand, and easy to operate, with low investment, low cost, high safety, good performance and easy maintenance, which help to improve the work efficiency and modern management level of enterprises. In the end, the operation performance of the system is tested. The results show that the throughput of the main functional modules in the system is greater than 100 times/s when dealing with the business, and the success rate of event processing is greater than 99%. The average response time of the business end is less than 0.4 s, and the average response time of the terminal side is less than 0.5 s, which all meet the standards. System CPU occupancy rate can be basically controlled below 30%, and memory usage rate is below 30%. In summary, the system designed here has the basic functions but also to ensure good performance, suitable for enterprise personnel management, organizational management, recruitment management, training management and salary management. The design and development of this system aims to provide technical support for the service quality of enterprise human resource management business, to improve the overall efficiency, promote the pace of enterprise strategic development, and enhance the market competitiveness of enterprises.

Design of a Spatial Data Model for the Sustainability of Population Sheltering Processes in the Czech Republic

This article is focused on the creation of a data model of an information system to support the processes of population sheltering (PoS). PoS processes have undergone significant changes in the Czech Republic. The PoS system was transformed for the use of improvised shelters. For sustainable PoS, it is necessary to standardize the approach of crisis management staff. Key research hypotheses: the data model must respect the methodological framework of planning and implementation of the PoS, especially when used for the design and implementation of the improvised shelters; the standardization of residential buildings can be used to facilitate and streamline the sustainable process of planning of the PoS; the unified data model of the PoS can be considered suitable for standardization and development in the field of sustainable planning and implementation of the PoS. Softwares such as SW QGIS desktop 2.6.0, OpenStreetMap (OSM) spatial database, ESRI shapefile format, and S-JTSK/Krovak East North 5514 coordinate system were used for the verification of the spatial data model, and ASP.NET MVC 4.7.2 Microsoft SQL Server Express 2019, jQuery 3.3.1, Bootstrap 3.4.1, Kendo UI 2019.1.220, and virtual Windows Server 2016 were used for the implementation of the physical data model. The physical data model substantiates the benefits.

Securing Relational Databases against Security Vulnerabilities: A Case of Microsoft SQL Server and PostgreSQL

This study evaluates mechanisms to secure relational databases against security vulnerabilities and utilized PostgreSQL and Microsoft SQL Server due to data breach incidences reported across the world. Emulation experiments with documentary review were employed to collect necessary study data. Identification of security features and vulnerabilities that are found to affect the data tier of the web applications were examined. The findings from the study have shown that Microsoft SQL Server is more security feature-rich in terms of Confidentiality, Integrity, and Availability compared to PostgreSQL and Microsoft SQL Server is more resilient to security attacks in its default behavior compared to PostgreSQL.

Applied aspects of data mining for decision support at the regional health system

The article presents the results of research of Data Mining methods with Microsoft SQL Server. Microsoft Clustering algorithm was used for improving the effectiveness of medical prevention and treatment in a cohort of patients with arterial hypertension. There are rationales for monitoring of cardiovascular risk and desire to correct the risk with Data Mining at medical decision support systems. Authors used medical and sociological monitoring data from regional clinical hospital. The segmentation of arterial hypertension patients was performed using Microsoft Clustering algorithm. As a result, a quantitative assessment of the population profile for patients with arterial hypertension was obtained. The authors presented diagrams and profiles of clusters. They were compared. The developed approach is applied for decision support at regional health information management system for reduce of cardiovascular risk.

Control model of parallel functioning production modules as fuzzy Petri nets

The article presents the results of research of Data Mining methods with Microsoft SQL Server. Microsoft Clustering algorithm was used for improving the effectiveness of medical prevention and treatment in a cohort of patients with arterial hypertension. There are rationales for monitoring of cardiovascular risk and desire to correct the risk with Data Mining at medical decision support systems. Authors used medical and sociological monitoring data from regional clinical hospital. The segmentation of arterial hypertension patients was performed using Microsoft Clustering algorithm. As a result, a quantitative assessment of the population profile for patients with arterial hypertension was obtained. The authors presented diagrams and profiles of clusters. They were compared. The developed approach is applied for decision support at regional health information management system for reduce of cardiovascular risk.

A scenario-based coupled SWAT-MODFLOW decision support system for advanced water resource management

Abstract Models provide invaluable visions to decision-makers for basin-scale management of water resources. However, decision-makers have difficulties in directly using these complex models. Water managers are primarily interested in user-friendly features allowing an integration of their judgments into the decision-making process, rather than applying detailed theories and methodologies. This knowledge gap between technical simulation models and policy-makers highlights the urgent need for developing an integrated water resource management decision support system (IWRM-DSS). This paper describes the main aspects of a new IWRM-DSS in which Microsoft Visual Studio under the C# language was employed to integrate the Microsoft SQL server as a database and ArcGIS Engine DLLs for pre/postdata processing for the SWAT and MODFLOW models. Two particular ‘module’ and ‘presentation’ shells are specifically designed for decision-makers to create four different scenarios, namely, ‘climatic’, ‘recharge’, ‘discharge’, and ‘coupled’ and to analyze the results. Decision-makers, without any detailed modeling knowledge and computer skills, can access the data and run models to test different management scenarios in an attractive graphical user interface. The IWRM-DSS, which was applied for the Neishaboor watershed, Iran, reveals that mean annual potential evapotranspiration increased to 8.2%, while runoff and recharge rates are reduced to 35 and 63%, which led to a decline of 13.5 m in mean groundwater level for the 13-year projected period.

Performance testing on Transparent Data Encryption for SQL Server's reliability and efficiency

Data security is being one of the most crucial aspects to be focused on system development. However, using such a feature to enhance the security of data might affect the system's performance. This study aims to observe how substantial Transparent Data Encryption as a solution for data security on Microsoft SQL Server will affect the database management system's performance. Each of the system performance is conducted with stress and load test. This paper concentrates on the upsides of using Transparent Data Encryption over standard database by finding how significant performance degradation has occurred in terms of Reliability and Efficiency.

Effective framework to tackle urban unemployment by e-government: an IoT solution for smart/metro cities in developing nation

PurposeWith the advancement in technology, the day-to-day life of people has gone through an immense transformation. The use of smart devices for day-to-day life is greater than before, and people are moving towards smart work rather than doing hard work. In this paper, a novel framework is proposed named Online Service Provider in Metro City (OSPMC) for IoT. The purpose of this study is to provide a theoretical framework for the E-Government in order to sustain or minimize the unemployment rate.Design/methodology/approachThe utilization of the Web in the upcoming years would create further opportunities for smart work. Internet of Things (IoT) plays an essential part in a system of multiple networks that aims to connect all things in the world that are capable of being connected through the internet. OSPMC framework can be developed on ASP.NET through (visual C#) 3.0 and Microsoft SQL Server with frontend and backend languages, respectively, under a web-based environment built on .Net platform. This lucrative facility is available mainly for the people living in the smart city.FindingsRural people are coming to smart cities in search of jobs, better education and a healthy lifestyle. India is also coping up with the modern world. The Government of India has taken an initiative for the making of 100 smart cities where the residents are relied upon to use Information and Communication Technology with the assistance of web.Social implicationsOSPMC promises to eliminate multiple evils like social injustice, crime, unemployment, tax fraud and would promote women empowerment. Also, provide opportunities to start-ups in order to grow and enhance their skill work.Originality/valueThe objective of OSPMC can be found useful for opening new job opportunities for urban/rural people while also encouraging people to learn skill work. For smart cities’ success in developing nations, it is important to recognize the elements influencing it. The motivation behind OSPMC is to identify those variables influencing the successful usage of allowing IoT in the smart cities by E-Government of India and to use IoT to help urban smart cities.

SISTEM INFORMASI PENCATATAN DATA INVENTARIS BERBASIS MULTIUSER (STUDI KASUS PADA RSUD AMBARAWA

The Regional General Hospital (RSUD) Ambarawa is one of the Public Service Agency Region(BLUD) belongs to Semarang Regency which is engaged in public health services. Ambarawa Hospital islocated at Jalan Kartini No. 101 Ambarawa. During this inventory data processing pengolahan At theRegional General Hospital (RSUD) Ambarawa it is still processed manually, some problems what oftenarises is not knowing the value of depreciation of goods each month, has not applied database system andlow inventory data security system.The author uses 3 research methods for data collection in this study, namely observation, interviewsand literature study. The observation method used by the author is by carry out direct practice on theproblems that occur. Interviews were conducted by the author on the employees concerned, while in theliterature study the author looks for related literature with research and used as a theoretical basis. From theanalysis and research results, it can be seen that the solution to the above problems is by create an InventoryData Recording Information System that uses a programming languageMicrosoft Visual Basic 6.0 and Microsoft SQL Server 2000 database processing system. Theprocedure will be made consisting of 5 main parts, namely the inventory item data collection, room datacollection, transactions for placement of inventory items, transactions for mutation of inventory items anddepreciation of the line method straight. This system is expected to increase the effectiveness of inventorydata processing in hospitalsRegional General Hospital (RSUD) Ambarawa.