Relevant bibliographies by topics / Microsoft SQL (Computer file) / Journal articles
To see the other types of publications on this topic, follow the link: Microsoft SQL (Computer file).

Journal articles on the topic 'Microsoft SQL (Computer file)'

Author: Grafiati
Published: 4 June 2021
Last updated: 13 February 2022

Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles

Select a source type:

Consult the top 50 journal articles for your research on the topic 'Microsoft SQL (Computer file).'

Next to every source in the list of references, there is an 'Add to bibliography' button. Press on it, and we will generate automatically the bibliographic reference to the chosen work in the citation style you need: APA, MLA, Harvard, Chicago, Vancouver, etc.

You can also download the full text of the academic publication as pdf and read online its abstract whenever available in the metadata.

Browse journal articles on a wide variety of disciplines and organise your bibliography correctly.

1

Yan, Hai Zhong. "Development Technology of Excel Data Server Application with DELPHI ADO + RemObjectcs Combined (Part 1: The Server Side)." Applied Mechanics and Materials 727-728 (January 2015): 959–64. http://dx.doi.org/10.4028/www.scientific.net/amm.727-728.959.

Full text
Abstract:
Microsoft office Excel is an important part of the Microsoft Office suite of software that can be processed, statistical analysis of various data, with its quick style and rich functionality has been generally welcomed, but with the database networking and sharing trends deepening, Excel application bottlenecks in stand-alone mode began to appear, and the network is the computer information technology in today's inevitable end, I imagine combining ADO technology developed by Delphi Excel data server in order to break this limitation, changes in non-network applications Excel mode.Excel Data Server is a set of services and client program, the server deployed on the server, the client is retrieved by the query language SQL, Excel data file can perform various operations and customer interface directly to form a Web-based application systems, customer service not only to support the application at both ends of the LAN, you can also support the application on the Internet. In this paper, Delphi7.0 support, using ADO and RemObjects SDK tools to develop an Excel data server. RemObjects referred to RO. RO version a lot, but it is recommended to use RemObjects Data Abstract 6.0.43.801, Delphi's experience in the development of it appear to be more stable, server-side and client-side data connections and programming efficiency, data manipulation more convenient.
APA, Harvard, Vancouver, ISO, and other styles
2

Lambert, Sherwood Lane, Jon Holladay, and Dawna M. Drum. "International AC: An Education Case on Continuous Monitoring SQL Server Data with ODBC-Linked Tables in Microsoft Access." Journal of Emerging Technologies in Accounting 13, no. 2 (September 1, 2016): 195–213. http://dx.doi.org/10.2308/jeta-51597.

Full text
Abstract:
ABSTRACT This education case teaches students Continuous Auditing/Continuous Monitoring (CA/CM) using Open Database Connectivity (ODBC) connections from students' Microsoft Access (Access) to tables in Microsoft SQL Server (SQL Server). First, the institution's database administrator (DBA) imports the student tables provided with the Teaching Notes into the institution's SQL Server with read-only access. In Access, students create ODBC connections to the SQL Server student tables. Then, students create Access queries using the ODBC-linked tables to monitor for anomalies. During a scheduled week, the DBA, in coordination with the faculty member, enters anomalies in the SQL Server student tables at random times, and students run their Access queries to identify the anomalies.
APA, Harvard, Vancouver, ISO, and other styles
3

Prasetyo, Kurniawan, and Suharyanto Suharyanto. "Rancang Bangun Sistem Informasi Koperasi Berbasis Web Pada Koperasi Ikitama Jakarta." Jurnal Teknik Komputer 5, no. 1 (February 20, 2019): 119–26. http://dx.doi.org/10.31294/jtk.v5i1.4967.

Full text
Abstract:
PT Indolife Pensiontama is a life insurance and pension fund corporation. IKITAMA Cooperation which is acronym of Indolife Pensiontama Employee Association Cooperation is a cooperation organization that having all permanent and active employees as members, in a routin activity IKITAMA Cooperative management manage daily transactions by manual using Microsoft Excel. If there is a new employee or not employed anymore then the record will be updated manually, and also there is no integration with existing human resource system, and all the data saved in Excel File without detail information. With all these problems so the author purpose to make a design and development of web-based cooperation information system. The design using object analytics oriented method by Unified Modeling Language (UML), C# .Net programming language with Microsoft Visual Studio 2012 as text editor and compiler and Microsoft SQL Server for the Database system. Keywords: Information System, Cooperation, IKITAMA.
APA, Harvard, Vancouver, ISO, and other styles
4

Aleksic, Slavica, Ivan Lukovic, Pavle Mogin, and Miro Govedarica. "A generator of SQL schema specifications." Computer Science and Information Systems 4, no. 2 (2007): 81–100. http://dx.doi.org/10.2298/csis0702081a.

Full text
Abstract:
IIS*Case is an integrated CASE tool that supports the automation and intelligent support of complex and highly formalized design and programming tasks in the development of an information system. IIS*Case, as a tool from the class of domain oriented design environments, generates relational database schemas in 3rd normal form with all relevant data constraints. SQL Generator is an IIS*Case tool that generates the implementation specification of a database schema according to ANSI SQL:2003 standard. The generator may also produce a database schema specification for Microsoft SQL Server or Oracle DBMSs. The paper describes SQL Generator's traits, considers aspects of its application, and shows its use in the implementation of a complex database constraint using procedural mechanisms of a particular relational DBMS. SQL Generator is implemented in Java and Oracle JDeveloper environment.
APA, Harvard, Vancouver, ISO, and other styles
5

Hanna, Margo. "Data‐mining algorithms in Oracle9i and Microsoft SQL Server." Campus-Wide Information Systems 21, no. 3 (July 2004): 132–38. http://dx.doi.org/10.1108/10650740410544036.

Full text
APA, Harvard, Vancouver, ISO, and other styles
6

Glen Ferguson, David. "Redefining File Slack in Microsoft® NTFS." Journal of Digital Forensic Practice 2, no. 3 (December 9, 2008): 140–56. http://dx.doi.org/10.1080/15567280802587965.

Full text
APA, Harvard, Vancouver, ISO, and other styles
7

Wei, Yi Bo. "Design and Implementation of Intelligent Community Information System Based on WSN Technology." Applied Mechanics and Materials 686 (October 2014): 407–11. http://dx.doi.org/10.4028/www.scientific.net/amm.686.407.

Full text
Abstract:
This paper studies the management of intelligent community network at present and technology development of internet of thing at home and abroad, in-depth analyze the existing residential property management system, and design the green energy-saving software platform based on Internet of things for intelligent community, the system platform takes Microsoft Visual Studio 2010 as the development tool, taking SQL Server2008 as the database development environment. In order to meet the normal property management function demand, from the actual demand of the intelligent community management, increase the equipment management, file transfer, public security and other functions in the system. The software meet to the actual needs of the information society in the property management system, has a certain practical application prospect.
APA, Harvard, Vancouver, ISO, and other styles
8

Ji, Xuechun, Maoxian Zhao, Mingyu Zhai, and Qingxi Wu. "Query Execution Optimization in Spark SQL." Scientific Programming 2020 (February 7, 2020): 1–12. http://dx.doi.org/10.1155/2020/6364752.

Full text
Abstract:
Spark SQL is a big data processing tool for structured data query and analysis. However, due to the execution of Spark SQL, there are multiple times to write intermediate data to the disk, which reduces the execution efficiency of Spark SQL. Targeting on the existing issues, we design and implement an intermediate data cache layer between the underlying file system and the upper Spark core to reduce the cost of random disk I/O. By using the query pre-analysis module, we can dynamically adjust the capacity of cache layer for different queries. And the allocation module can allocate proper memory for each node in cluster. According to the sharing of the intermediate data in the Spark SQL workflow, this paper proposes a cost-based correlation merging algorithm, which can effectively reduce the cost of reading and writing redundant data. This paper develops the SSO (Spark SQL Optimizer) module and integrates it into the original Spark system to achieve the above functions. This paper compares the query performance with the existing Spark SQL by experiment data generated by TPC-H tool. The experimental results show that the SSO module can effectively improve the query efficiency, reduce the disk I/O cost and make full use of the cluster memory resources.
APA, Harvard, Vancouver, ISO, and other styles
9

Silalahi, Mesri. "PERBANDINGAN PERFORMANSI DATABASE MONGODB DAN MYSQL DALAM APLIKASI FILE MULTIMEDIA BERBASIS WEB." Computer Based Information System Journal 6, no. 1 (March 31, 2018): 63. http://dx.doi.org/10.33884/cbis.v6i1.574.

Full text
Abstract:
Database appeared and began to develop in line with the needs of processing and data storage to meet the information needs. Database is part of an important building block in an information system. In addition to a relational database (SQL), which stores structured datas in tables with defined schemes, there is a non-relational databases (NoSQL) with a dynamic scheme or unstructured. This study will compare the performance between NoSQL database (MongoDB) and SQL database (MySQL) for a web-based multimedia file storage application that stores files as BLOBs. Performance comparison is based on the speed of execution and the computer resources usage (CPU, memory, and virtual memory).
APA, Harvard, Vancouver, ISO, and other styles
10

Schuster, Andreas. "Introducing the Microsoft Vista event log file format." Digital Investigation 4 (September 2007): 65–72. http://dx.doi.org/10.1016/j.diin.2007.06.015.

Full text
APA, Harvard, Vancouver, ISO, and other styles
11

Menzies, D. "Review: 10 Projects You Can Do With Microsoft SQL Server 7." Computer Bulletin 43, no. 1 (January 1, 2001): 31. http://dx.doi.org/10.1093/combul/43.1.31-c.

Full text
APA, Harvard, Vancouver, ISO, and other styles
12

Blankley, Alan I. "Using SQL to Develop Database Query Proficiency: A Follow-Up Note to Borthick, Jones, and Kim (2001)." Journal of Information Systems 20, no. 1 (March 1, 2006): 117–37. http://dx.doi.org/10.2308/jis.2006.20.1.117.

Full text
Abstract:
In the Spring 2001 issue of Journal of Information Systems (JIS), Borthick et al. (2001) presented a case in which students were to query a Microsoft Access database in order to determine the mutual assurance concerning customer service for an automobile manufacturer and its local dealer network. I follow-up this case by presenting an additional teaching note to the case that develops query strategies and solutions for the case using Oracle and its SQL application, SQL-Plus.
APA, Harvard, Vancouver, ISO, and other styles
13

Jayanti, Sherly, and Ferdiyani Haris. "Sistem Informasi Penjualan Untuk Al-Farizi Computer Palangka Raya Dengan Zachman Framework." Jurnal Sains Komputer dan Teknologi Informasi 2, no. 1 (November 4, 2019): 46–50. http://dx.doi.org/10.33084/jsakti.v2i1.1174.

Full text
Abstract:
Perkembangan komputer sekarang ini sangat pesat dan digunakan diberbagai bidang kehidupan. Biasanya komputer digunakan untuk menghasilkan berbagai informasi penting guna meningkatkan kinerja dari organisasi, perusahaan atau lembaga agar pekerjaan yang dilakukan lebih efektif dan efisien hal ini disebabkan komputer melakukan proses informasi yang cepat. Untuk menjaga kelancaran, memantau dan juga mempermudah tugas pengelolaan data maka hal ini perlu dibuat sebuah sistem pengelolaan data pada Al-Farizi Computer Palangka Raya yang menyediakan perangkat keras komputer dan perangkat lunak untuk memenuhi kebutuhan pelanggan. Pengembangan arsitektur sistem informasi menggunakan Zachman Framework yang didukung dengan Microsoft SQL Server untuk database, interface dengan Microsoft Visual Basic, dan UML (Unified Modelling Language) untuk penggambaran model sistem informasi penjualan. Sistem informasi yang dihasilkan bisa memberikan informasi yang cepat dan akurat serta semakin membantu pelanggan mendapatkan yang tercocok dengan semakin cepat dan baik.
APA, Harvard, Vancouver, ISO, and other styles
14

Serik, Meruert, Meiramgul Mukhambetova, and Alibek Yeskermessuly. "Improving the Content of a Client-Server Technology Training Course: Set up and Collaborative Implementation of Local and Cloud-Based Remote Servers." International Journal of Emerging Technologies in Learning (iJET) 14, no. 21 (November 18, 2019): 191. http://dx.doi.org/10.3991/ijet.v14i21.10643.

Full text
Abstract:
The integration of software solutions in the content of the training courses as a result of the socio-economic demand has a positive effect on the improvement of training the students for future professional activities. However, the latest achievements of hardware and software are not included in the content of the high education in a timely manner. Therefore, in our research we set the task to improve the content of the training course on the client-server technology using modern software capabilities. The content of the article consists of the conceptual structure of the training course, settings and integration of local and public cloud-based servers, describes the approaches of its using in the learning process. Microsoft SQL Server 2016, Microsoft Azure SQL Database, ASP.NET MVC 5 Framework were used as teaching environments. Training course was held for the students in the specialty of Computer Science of L.N.Gumilyov Eurasian National University and Kh.Dosmukhamedov Atyrau State University in Kazakhstan.
APA, Harvard, Vancouver, ISO, and other styles
15

Ana, P., and PT Bukie. "Design and implementation of online examination administration system for universities." Global Journal of Mathematical Sciences 12, no. 1 (January 19, 2015): 39–51. http://dx.doi.org/10.4314/gjmas.v12i1.16.

Full text
Abstract:
Online examination system is a web-based examination system where examination is taken online i.e. through the internet or intranet using computer system. It is an effective solution for mass education evaluation. We have developed an online examination system based on a Browser/Server framework using Microsoft Visual Studio 2008 for the design, C# 3.5 for coding, and Microsoft SQL Server as database. ASP.NET is the preferred web technology. The system carries out the examination and auto-grading for multiple choice questions which is feed into the system.KEY WORDS: Online, Examination, System, Auto-grading, Web-based.
APA, Harvard, Vancouver, ISO, and other styles
16

Langraf, Vladimír, Kornélia Petrovičová, Stanislav David, Zuzana Krumpálová, Adrián Purkart, and Janka Schlarmannová. "Proposal of a Relational Database (SQL) for Zoological Research of Epigeic Synusion." MENDEL 27, no. 1 (June 21, 2021): 23–28. http://dx.doi.org/10.13164/mendel.2021.1.023.

Full text
Abstract:
In recent years, developments in the field of molecular biology and genetics have led to the increase in biological information stored in databases. The same increase in the volume of information occurred in the field of zoology, but the development of databases was not addressed in this area. We prepared a relational database and its diagram in the Microsoft SQL Server Management Studio (SSMS) database program. Our results represent experience with construction of a new database design for the zoology field with a focus on research of epigeic groups. The structure of the database will help with meta-analyzes with the objective to identify zoological and ecological relationships and responses to anthropic intervention.
APA, Harvard, Vancouver, ISO, and other styles
17

Lou, Qi Ming, Jian Hong Sun, Hai Cheng Xu, and Jin Wei Fu. "Design and Implementation of a File Transfer System Based on .NET Remoting." Advanced Materials Research 424-425 (January 2012): 162–65. http://dx.doi.org/10.4028/www.scientific.net/amr.424-425.162.

Full text
Abstract:
NET Remoting is a way of communication between the processes in .NET frameworks. It can be used for communication between different applications based on CLR on different computers on the network, it can also be used for communication between different applications based on CLR on the same computer. Firstly, the working principles of .NET Remoting are discussed. Secondly, a basic structure model for file transfer system based on .NET Remoting is proposed. Finally, gives the implementation of a file transfer and management system using .NET Remoting and SQL Server, which is safe, efficient and practical
APA, Harvard, Vancouver, ISO, and other styles
18

Zhou, Yingbao. "A Multimedia Teaching System with Special Acoustic Effects in the Course of Aerobics." International Journal of Emerging Technologies in Learning (iJET) 11, no. 10 (October 27, 2016): 31. http://dx.doi.org/10.3991/ijet.v11i10.6266.

Full text
Abstract:
With the continuous advancement of multimedia technology, multimedia teaching has also posed higher requirements on multimedia playing capabilities. This essay presents the design program for a speaker which could be applied in multimedia classroom to achieve special acoustic effects based on use of the ASP.NET technology. The SQL Server 2005 database technology and Microsoft Visual Studio 2008 technology are combined in the design process. Compared with traditional multimedia speakers, the speak of this program is small, portable, and power-saving, may bring changeable lighting stage effects, could be easily connected to computers, and support playing files stored in U disk and SD card. After the entire program is practically utilized in teaching, it has been found that the system can meet acoustic demand of teachers and students, and improve teaching effectiveness.
APA, Harvard, Vancouver, ISO, and other styles
19

Taryanto, Ardi, and Lilis Nur Handayani. "PENGEMBANGAN SISTEM INFORMASI RETENSI REKAM MEDIS DI RUMAH SAKIT DUSTIRA CIMAHI." Jurnal E-Komtek (Elektro-Komputer-Teknik) 3, no. 2 (November 6, 2019): 62–70. http://dx.doi.org/10.37339/e-komtek.v3i2.131.

Full text
Abstract:
This study aimed to develop a medical record retention information system with a case study at Dustira Cimahi Hospital. The data collection techniques used were by observations and completed by literature study which had related with the problems. Software development methods was made using waterfull. From the research conducted, it was found several problems associated with the retention information system which has running, such as: the implementation of retention was done directly with sorting out medical record file without the computer, the absence of a retention schedule medical record file, there is no storage space inactive and off medical record file. Therefore it is necessary to develop a medical record retention information system in the form of an application implemented with the Microsoft Visual Basic.Net 2010 programming language and the Database Access System / DBMS Microsoft Access. So that this application is expected to help hospitals in overcoming file retention problems and data retention processing can be better in the future.
APA, Harvard, Vancouver, ISO, and other styles
20

Tukino, Tukino. "Pelatihan Microsoft Office 2010 pada Kelompok Kerja Kepala TK (K3TK) dan Gugus Paud Naga di Kota Batam sebagai Aplikasi dari Pembelajaran Komputer pada Anak Usia Dini." J-ABDIPAMAS (Jurnal Pengabdian Kepada Masyarakat) 2, no. 2 (October 31, 2018): 65. http://dx.doi.org/10.30734/j-abdipamas.v2i2.245.

Full text
Abstract:
ABSTRACTThe material provided in this guidance is divided into 3 groups, there are Microsoft Word, Microsoft PowerPoint and Microsoft Paint. Activities are carried out based on the division level of the ability/skill of each teacher. Teachers who have been adept grouped separately from the teacher who still lay on the computer so that the coaching is intensive. Teachers who still lay be guided and accompanied by the instructor ranging from the procedure turn on the computer, opening files, saving files, using the mouse, typing basic, introduction computer parts up on the procedure to turn off the computer. The methods applied in this activity is the Method of Presentation, Demonstration and Practice. The method of Presentation used for the introduction of software using Microsoft PowerPoint 2010. The results of this study are: First, the Training provided some of the materials associated with efforts to improve the quality of learning by giving knowledge about the use of the Program PowerPoint to create interactive games as learning media multimedia ICT-based attractive and interactive, Second, the Material presented can be accepted, digested, and understood the participant well, the Third, the Activity takes place smoothly, on time and as expected. Keywords: Microsoft Word, Microsoft PowerPoint, and Microsoft Paint. ABSTRAKMateri yang diberikan dalam pembinaan ini terbagi menjadi 3 kelompok, yaitu kelompok Microsoft Word, Microsoft PowerPoint dan Microsoft Paint. Kegiatan dilakukan berdasarkan pembagian tingkat kemampuan/skill masing - masing guru. Guru yang telah mahir dikelompokkan tersendiri dari guru yang masih awam tentang komputer supaya pembinaan lebih intensif. Guru yang masih awam dibimbing dan ditemani instruktur mulai dari prosedur menyalakan komputer, membuka file, menyimpan file, menggunakan mouse, mengetik dasar, pengenalan bagian-bagian komputer sampai pada prosedur mematikan komputer. Metode yang diterapkan dalam kegiatan ini adalah Metode Presentasi, Demonstrasi dan Praktik. Metode Presentasi digunakan untuk pengenalan software menggunakan Microsoft PowerPoint 2010. Hasil penelitian ini adalah: Pertama, Pelatihan memberikan beberapa materi yang terkait dengan upaya meningkatkan kualitas pembelajaran dengan pemberikan pengetahuan mengenai pemanfaatan Program PowerPoint untuk membuat game interaktif sebagai media pembelajaran multimedia berbasis TIK yang atraktif dan interaktif, Kedua, Materi yang disajikan dapat diterima, dicerna, dan dipahami peserta dengan baik, Ketiga, Kegiatan berlangsung lancar, tepat waktu dan sesuai dengan yang diharapkan. Kata Kunci: Microsoft Word, Microsoft PowerPoint, dan Microsoft Paint.
APA, Harvard, Vancouver, ISO, and other styles
21

Curotto, C. L. "Implementing Data Mining Algorithms in Microsoft SQL Server20065W.R. Howard Computer Science International, UK(Section Editor). Implementing Data Mining Algorithms in Microsoft SQL Server. Witpress, 2005. 160 pp., ISBN: 1‐84564‐037 3." Kybernetes 35, no. 7/8 (August 2006): 1301. http://dx.doi.org/10.1108/03684920610675328.

Full text
APA, Harvard, Vancouver, ISO, and other styles
22

Sukarata, Putu Gde, I. Gede Suputra Widharma, I. Made Purbhawa, and I. Gede Wahyu Antara Kurniawan. "OPTIMALISASI COMPUTER MEMORY USAGE MENGGUNAKAN METODE APLIKASI MICROSOFT BINDER." JURNAL INTEGRASI 11, no. 2 (October 17, 2019): 74–80. http://dx.doi.org/10.30871/ji.v11i2.1650.

Full text
Abstract:
Perkembangan teknologi komputer sekarang ini sangat jauh berkembang dari tahun-tahun sebelumnya. Perkembangan ini terjadi di semua bidang kehidupan. Seperti dunia kedokteran, industri, pertanian dan yang lainnya. Teknologi juga sangat membantu berbagai pekerjaan manusia menjadi lebih mudah, cepat dan efisien. Teknologi komputer ini berupa perangkat keras dan perangkat lunak. Perangkat lunak yang digunakan dapat berupa sistem dan aplikasi. Untuk menjalankan sistem dan aplikasi ini memerlukan perangkat keras berupa ruang-ruang sebagai tempat menyimpan yang disebut dengan memory. Memory memiliki sifat sementara dan permanen. Besarnya ruang memory ini akan mempengaruhi sistem kerja komputer dan berjalannya aplikasi yang digunakan. Semakin banyak aplikasi yang digunakan, otomatis akan dapat memenuhi ruang memory yang ada. Aplikasi Microsoft Binder adalah salah satu fitur yang tidak terlalu banyak diketahui penggunaannya sebagai pengikat dokumen yang dihasilkan dari berbagai aplikasi. Microsoft Binder seperti klip pengikat dan menyimpan dokumen terkait secara bersamaan. Microsoft Binder memungkinkan kita menggabungkan berbagai file menjadi satu untuk memudahkan pengelolaan. Dalam hal ini penggunaan memory yang terpakai sudah tentu akan berkurang sehingga kerja komputer menjadi lebih optimal.
APA, Harvard, Vancouver, ISO, and other styles
23

Ardilla, Yunita, Shinta Pramesti, and Dwi Sunaryono. "Rancang Bangun Sistem Informasi Manajemen Proyek Departemen IT PT. Pertamina UPMS V Surabaya." JISKA (Jurnal Informatika Sunan Kalijaga) 5, no. 3 (November 10, 2020): 136. http://dx.doi.org/10.14421/jiska.2020.53-01.

Full text
Abstract:
Department of IT M&T PT. Pertamina UPMS V Surabaya has currently implemented a management guideline based on COBIT 5.0 to support the process of monitoring and scheduling projects that will be implemented or currently being worked on PT. Pertamina UPMS V Surabaya. But in the process of implementing management guidelines, the department of IT M&T has not maximized the implementation of the monitoring and scheduling because it does not yet have a project management information system application. So far employees from the department of IT M&T use the process of monitoring and scheduling projects manually, namely by making a report in the form of an excel file for each progress of the projects. Of course, this is considered inefficient and often encounters human errors. Therefore, a web-based project management information system application was made, the application was built using the C3 programming language and Microsoft SQL Server database. Based on observation, it was concluding that the features available in the project management information system application had been running well and were able to meet the needs of users.
APA, Harvard, Vancouver, ISO, and other styles
24

Aqilah Mohd Nahar, Nur Farah, Nurul Hidayah Ab Rahman, and Kamarudin Malik Mohammad. "E-Raser: File Shredder Application With Content Replacement by Using Random Words Function." JOIV : International Journal on Informatics Visualization 2, no. 4-2 (September 10, 2018): 313. http://dx.doi.org/10.30630/joiv.2.4-2.175.

Full text
Abstract:
Data shredding indicates a process of irreversible file destruction while file shredder is the program designed to render computer-based files unreadable by implementing overwriting method to destroy data in the content of a file. The addressable problem with existence of file recovery tools is it may lead to data leakage, exploitation or dissemination from an unauthorized person. Thus, this study proposed a file shredding application named E-Raser which replacing the content of the file using random words function algorithm. A file shredder application named E-Raser was developed to shred Microsoft Word documents with (.doc) or (.docx) format. The implemented algorithm replaced the original content of the files with uninformative words provided by the application. After rewriting phase is complete, shredding process take place to make the file unrecoverable. Object Oriented Software Development was used as the methodology to develop this application. As a result, E-Raser achieved the objectives to add, remove, rewrite, display and shred files. Also, E-Raser is significantly facilitates users to securely dispose their file, protect the confidentiality and privacy of the file’s content.
APA, Harvard, Vancouver, ISO, and other styles
25

Hanner, K., and R. Hörmanseder. "Managing Windows NT®file system permissions— A security tool to master the complexity of Microsoft Windows NT®file system permissions." Journal of Network and Computer Applications 22, no. 2 (April 1999): 119–31. http://dx.doi.org/10.1006/jnca.1999.0086.

Full text
APA, Harvard, Vancouver, ISO, and other styles
26

Han, Sugai, Ansheng Li, Hongchao Wang, Xiaoyun Gong, Liangwen Wang, Yixiang Huang, Yanming Li, and Wenliao Du. "A health management system for large vertical mill." International Journal of Distributed Sensor Networks 16, no. 3 (March 2020): 155014772091211. http://dx.doi.org/10.1177/1550147720912111.

Full text
Abstract:
The large vertical mill has complicated structure and tens of thousands of parts, which is a critical grinding equipment for slag and cinder. As large vertical mill always works in severe conditions, the on-line monitoring, timely fault diagnosis, and trend prediction are very important guarantees for the safe service and saving maintaining costs. To address this issue, the health management system for large vertical mill is developed. More specifically, in order to manage reservoirs of state-related running data, the intrinsic physic data, and diagnosis knowledge base, an entity-relationship-model-based database is first constructed. Based on the fault diagnosis reasoning of experts, the fault tree is developed and the fault diagnosis rules are derived. Especially, a hybrid condition prognosis method based on backtracking search optimization algorithm and neural network is developed, and in comparison with traditional back propagation neural network and ant colony neural network, the developed backtracking search optimization algorithm and neural network gets superior hybrid prediction performance in prediction accuracy and training efficiency. Finally, the health management system, including the functions of condition monitoring, fault diagnosis, and trend prediction for large vertical mill is implemented using Microsoft Visual Studio C # and Microsoft SQL Server.
APA, Harvard, Vancouver, ISO, and other styles
27

Wu, Bing, Xiang Wei Zou, Hai He Guan, Zhen Jiang Yu, and Zhi Guo Guo. "Study on Closed-Loop Coal Mine Hazard Information Management System Based on .NET." Advanced Materials Research 765-767 (September 2013): 945–49. http://dx.doi.org/10.4028/www.scientific.net/amr.765-767.945.

Full text
Abstract:
By studying the process of closed-loop coal mine safety hazard management personally, it has been found that the careless hazard information management mode which is used in a traditional way exists lots of defects on different levels. In order to manage the hazard information rapidly and accurately, a system based on B/S structure mode, which makes fully use of lots of computer technologies such as Microsoft .NET platform, SQL Server 2008, C# and so on, has been designed. It has been acknowledged that the system based on B/S structure mode can make it easy to maintain, meanwhile, has a good compatibility, superior data processing ability and a strong security.
APA, Harvard, Vancouver, ISO, and other styles
28

Lu, Ting Ting. "The Library Information Management System Analysis and Design." Applied Mechanics and Materials 599-601 (August 2014): 2198–201. http://dx.doi.org/10.4028/www.scientific.net/amm.599-601.2198.

Full text
Abstract:
according to the current situation of small and medium-sized library carried out feasibility analysis and the actual demand. The library's basic business processes are described. Combining with the knowledge of library and database technology to design each module. The system using the Windows XP/Windows 6.0 as system platform, using Visual basic 6.0 as a front-end application development tools, Microsoft SQL Server 2000 as the background database. Through to the small and medium-sized books management system management system requirements analysis, functional module division, database model analysis, designed the database structure and application. Due to the use of computer management, improved the traditional manual management way, improve the management level.
APA, Harvard, Vancouver, ISO, and other styles
29

Yang, Xiao Qiang, Hai Song Chen, Jin Xing Shen, and Huan Liang Li. "Portable Fault Diagnostic System Based on Network and PDA." Applied Mechanics and Materials 333-335 (July 2013): 1731–35. http://dx.doi.org/10.4028/www.scientific.net/amm.333-335.1731.

Full text
Abstract:
In order to solve the problem of field fault detection for engineering vehicle, we introduce a new networked portable fault diagnostic system based on PDA. The architecture of the system is presented. The system consists of dual-tier architecture. The first tier server is based on the related technical database of engineering vehicles, and the second tier one is the technical information database downloaded from the manufactures technical resources with PDA as the terminal for maintenance technician. The system function includes information query, user interaction, data downloading and uploading as well as network communication. The software platform is composed of Microsoft SQL Server Compact (SQL CE) database, application software on PDA and computer. Meanwhile the hardware platform is mainly composed of desktop PC or dedicated server, PDA mounted with cradle, data acquisition card as well as PCMCIA network adapter and so on. Both wireless communication and USB interface are adopted in the system. It has been used in many military units. The application demonstrates that the PDA-based networked fault diagnosis system of vehicles is beneficial to data query, fault elimination and repair capability of engineering vehicles.
APA, Harvard, Vancouver, ISO, and other styles
30

Azizah, Nur, Vinsensius Yalasena Adi Nugroho, and Edi Siswanto. "Rancang Bangun Sistem Aplikasi Packaging Labeling Berbasis Web." Journal CERITA 6, no. 2 (August 24, 2020): 162–68. http://dx.doi.org/10.33050/cerita.v6i2.1141.

Full text
Abstract:
The development of technology in the computer-based digital era is currently considered to be developing very rapidly. PT.Pratama Abadi Industri a company engaged in the manufacture of shoes with a fairly well-known brand in Indonesia. In carrying out the packaging labeling data reporting, it still uses office-based applications namely Microsoft Word and Microsoft Excel, which results in suboptimal performance results. Then a web-based packing labeling application system was built. In determining research and research design requires a method to see the development of the design and research, the methods applied include the SDLC method in the form of a waterfall, where a website system that has been designed with PHP Framework Codeigniter as a programming language and SQL as database storage. To design a packaging labeling application system using the Unified Modeling Language (UML) as a modeling tool consisting of Use Case Diagrams, Sequence Diagrams, and Activity Diagrams. The results of the web-based packaging application system are expected to provide solutions to the problems encountered
APA, Harvard, Vancouver, ISO, and other styles
31

Eladawi, A. E., E. S. Gadelmawla, I. M. Elewa, and A. A. Abdel-Shafy. "An application of computer vision for programming computer numerical control machines." Proceedings of the Institution of Mechanical Engineers, Part B: Journal of Engineering Manufacture 217, no. 9 (September 1, 2003): 1315–24. http://dx.doi.org/10.1243/095440503322420241.

Full text
Abstract:
Generation of the part programs, or tool paths, for products to be manufactured by computer numerical control (CNC) machines is very important. Many methods have been used to produce part programs, ranging from manual calculations to computer aided design/ manufacturing (CAD/CAM) systems. This work introduces a new technique for generating the part programs of existing products using the latest technology of computer vision. The proposed vision system is applicable for two-dimensional vertical milling CNC machines and is calibrated to produce both metric and imperial dimensions. Two steps are used to generate the part program. In the first step, the vision system is used to capture an image for the product to be manufactured. In the second step, the image is processed and analysed by software specially written for this purpose. The software CNCVision is fully written (in lab) using Microsoft Visual C++ 6.0. It is ready to run on any Windows environment. The CNCVision software processes the captured images and applies computer vision techniques to extract the product dimensions, then generates a suitable part program. All required information for the part program is calculated automatically, such as G-codes, X and Y coordinates of start-points and end-points, radii of arcs and circles and direction of arcs (clockwise or counterclockwise). The generated part program can be displayed on screen, saved to a file or sent to MS Word or MS Excel. In addition, the engineering drawing of the product can be displayed on screen or sent to AutoCAD as a drawing file.
APA, Harvard, Vancouver, ISO, and other styles
32

Kocakoç, Ipek Deveci, and Sabri Erdem. "Business Intelligence Applications in Retail Business: OLAP, Data Mining & Reporting Services." Journal of Information & Knowledge Management 09, no. 02 (June 2010): 171–81. http://dx.doi.org/10.1142/s0219649210002541.

Full text
Abstract:
As a result of today's competitive business environment, companies have been trying to improve the utilization of funds effectively in their budgets for information technology investments. These companies retrieve more information with the same set of resources by means of business intelligence methods. According to Rubin (Chabrow, 2004) IT budgets are not simply declining or levelling off, rather, companies are shifting from a pure cost-cut mode to a model that emphasises agility and efficiency. Tremendous daily growth of the company data requires more funds and investment for establishing the technologies and infrastructure necessary for gathering fast and crucial information that supports the decision making process. This necessity gave birth to various business intelligence methods, which mainly aim to process mass amount of collected data from their existing application, and represent it in a way with which companies can apply to their daily competitive decisions. This application primarily concerns the implementation of business intelligence for a retail business company. The aim is to implement built-in business intelligence solutions of the Microsoft SQL Server that holds the commercial information of the company for the past three years. The customer company has already been using Microsoft products. The key items used for analyzing data are sales, momentary inventory and logistics information. The application can be grouped in five main areas: Building the data warehouse, constructing OLAP cubes, applying data mining algorithms on OLAP cubes, representing the results in reports with reporting services, and implementation.
APA, Harvard, Vancouver, ISO, and other styles
33

Jewo, Andrew. "Computer Aided Analysis of Rotating Equipment Availability in Petrochemical Carbon Black Plant." European Journal of Engineering Research and Science 3, no. 12 (December 17, 2018): 50–55. http://dx.doi.org/10.24018/ejers.2018.3.12.996.

Full text
Abstract:
High availability of industrial plant could only be achieved by adopting best global maintenance practices (computer software). In this research work, a software module was developed using programming tools such as Visual Basic (V.B) 6.0, Structured Query Language (SQL) and Microsoft Access. Operational data were collected from Warri Refinery and Petrochemical Company and was input into the developed software to analyze the plant availability. The performance test results obtained by the software for a five year period (2009-2013) showed that the software developed is consistently close to 100% accuracy. The output result indicates that the plant availability in 2009 is 9.59%; 2010 is 5.75%; 2011 is 7.12%; 2012 is 1.64% and 2013 is 6.30%. This highly fluctuating and low availability of raw material, inadequate maintenance strategies, aging plant and equipment, lack of spare parts stock for preventive and corrective maintenance for emergency, lack of standby (backup) equipment and utility constraints. It was observed that the aforementioned reasons invariably resulted to constant failure of plant availability could greatly be improved by adopting best global maintenance practices which include the deployment of appropriate software tools.
APA, Harvard, Vancouver, ISO, and other styles
34

Al-aqbi, Ali Talib Qasim, Rana Riad K. Al-Taie, and Sarmad K. Ibrahim. "Design and Implementation of Online Examination System based on MSVS and SQL for University Students in Iraq." Webology 18, no. 1 (April 29, 2021): 416–30. http://dx.doi.org/10.14704/web/v18i1/web18098.

Full text
Abstract:
The transfer of knowledge and skills is a process that is closely linked to the measurement of its usefulness. It's hard to imagine teaching without considering the results and evaluation of students. At the same time, the current education system is based on a longstanding traditional paradigm. The aim of this article is to propose a new digital review system based on Microsoft visual studio (MSVS); it is the only one of its kind in terms of application versatility and also features professional interfaces for the interactive display of questions and answers. In our school, we have systematically assessed this program to determine the system performance of teaching staff and students, the findings of this study demonstrate the assumption that students were prepared for this type of knowledge; the evaluation result of the propose exam system outperforms conventional system about approximately 80%.
APA, Harvard, Vancouver, ISO, and other styles
35

Fan, Yue Bin. "Study on the Realization of Music Education and Teaching Management System of Universities." Advanced Materials Research 926-930 (May 2014): 4618–21. http://dx.doi.org/10.4028/www.scientific.net/amr.926-930.4618.

Full text
Abstract:
Aiming at developing a music education and teaching management system for universities, the user’s need for this system is analyzed in this study. The system’s development process has always been object-oriented analysis and design analysis of needs, combined with extensive application of computer technology, the various features of object-oriented design, and ultimately a university music education tailored to teaching management system. The system uses J2EE architecture, using tomcat as a server, using Microsoft launched the SQL Server database as a background support. The Struts MVC architecture design is used to ensure good maintenance of the system with the same time enhances data processing capabilities. data with the view of the separation technology is used to keep good expansion of the system and promote the maintenance for the system.
APA, Harvard, Vancouver, ISO, and other styles
36

Wang, Feng Wei, Zhi Hong Xing, and Chen Liu. "Research on ASP.NET-Based Task Management Platform." Advanced Materials Research 989-994 (July 2014): 4654–56. http://dx.doi.org/10.4028/www.scientific.net/amr.989-994.4654.

Full text
Abstract:
With constantly expansion of companies, more and more woks on communication become the managers’ top issue. It is urgent to use computer technology to improve work efficiency and achieve of information sharing as much as possible. The managers need a platform to keep their information updated real-time, statistics tasks information at any necessary times, and the staff also need platform to record the task process, make schedule to alarm. Therefore, ASP.NET-based task management information system is designed and implemented. The system is developed with Visual Studio 2005 and SQL Server 2005, including task management module, file management module, schedule management module and background management module. With running in practical, it is proved that the system improved working efficiency greatly and implemented work information sharing effectively..
APA, Harvard, Vancouver, ISO, and other styles
37

Yan, Jinpei, Yong Qi, and Qifan Rao. "Detecting Malware with an Ensemble Method Based on Deep Neural Network." Security and Communication Networks 2018 (2018): 1–16. http://dx.doi.org/10.1155/2018/7247095.

Full text
Abstract:
Malware detection plays a crucial role in computer security. Recent researches mainly use machine learning based methods heavily relying on domain knowledge for manually extracting malicious features. In this paper, we propose MalNet, a novel malware detection method that learns features automatically from the raw data. Concretely, we first generate a grayscale image from malware file, meanwhile extracting its opcode sequences with the decompilation tool IDA. Then MalNet uses CNN and LSTM networks to learn from grayscale image and opcode sequence, respectively, and takes a stacking ensemble for malware classification. We perform experiments on more than 40,000 samples including 20,650 benign files collected from online software providers and 21,736 malwares provided by Microsoft. The evaluation result shows that MalNet achieves 99.88% validation accuracy for malware detection. In addition, we also take malware family classification experiment on 9 malware families to compare MalNet with other related works, in which MalNet outperforms most of related works with 99.36% detection accuracy and achieves a considerable speed-up on detecting efficiency comparing with two state-of-the-art results on Microsoft malware dataset.
APA, Harvard, Vancouver, ISO, and other styles
38

Dadashzadeh, Mohammad, and Sara Dadashzadeh. "The Match: A Case Study In Algorithm Analysis Of The National Resident Matching Program." Journal of Business Case Studies (JBCS) 11, no. 4 (October 5, 2015): 141–50. http://dx.doi.org/10.19030/jbcs.v11i4.9443.

Full text
Abstract:
There are rare opportunities when solving an easily-understood problem can bring together application of skills taught in diverse courses in a Computer Science (CS) or Management Information Systems (MIS) program. This paper presents such an opportunity in the typical database management systems course taught at the junior or senior level. Specifically, we describe the case study of solving the classical Hospitals/Residents problem in Microsoft Access. The solution, based on classical Gale-Shapely algorithm for the Stable Marriage problem, offers pedagogical opportunities in data modeling, algorithm and data structure considerations for program development, Visual Basic for Applications (VBA) and embedded SQL (Structured Query Language) programming, and empirical analysis of running time complexity of algorithms that work remarkably well in teaching students the value of each tool in the toolset they take away from required courses as a part of their undergraduate education in CS or MIS.
APA, Harvard, Vancouver, ISO, and other styles
39

Adhima, Fauzan, and Fathiah Fathiah. "TRAFFIC COUNTING STUDI KASUS DI JALAN TEUKU NYAK ARIEF." JOURNAL OF INFORMATICS AND COMPUTER SCIENCE 4, no. 2 (December 6, 2019): 75. http://dx.doi.org/10.33143/jics.vol5.iss1.510.

Full text
Abstract:
Banda Aceh merupakan salah satu kota wisata yang sebagian besar penduduknya bertumpu pada mode transportasi untuk keperluan sehari-hari dari mulai sepeda, sepeda motor, mobil dan angkutan umum. Pertumbuhan populasi penduduk kota Banda aceh meningkat dari tahun ke tahun menyebabkan ketidak seimbangan antara jumlah transportasi yang ada di jalan raya dengan kapasitas ruas jalan yang tersedia. Hal ini menyebabkan berbagai masalah lalu lintas Sehingga diperlukan kegiatan Monitoring arus lalu lintas pada jalan tertentu untuk mengetahui kelancaran arus lalu lintas. maka dari itu munculah ide untuk merancang sebuah sistem traffic counting yang dapat menghitung jumlah arus lalu lintas kendaran Sebagai pedoman untuk dijadikan informasi arus lalu lintas. Sistem ini dibuat dengan menggunakan Microsoft Visual Studio,dan Open Source Computer Vision. Hasil dari pengujian sistem ini dengan menggunakan file video yang sudah direkam pada jalan Teuku Nyak Arief Banda Aceh. Program ini secara keseluruhan menunjukkan keberhasilan lebih dari 80%. Dengan sistem ini diharapkan dapat memudahkan untuk menghitung jumlah kendaraan pada jalan tersebut. Kata Kunci : Jumlah Kendaraan, Arus Lalu Lintas, Microsoft Visual Studio dan Open Source Computer Vision
APA, Harvard, Vancouver, ISO, and other styles
40

KANG, HYO SIM, and YOUNG SOO KANG. "PREPARATION OF WATER-BASED INDIUM TIN OXIDE SOL SOLUTION FOR NEAR-IR REFLECTIVE FILM." International Journal of Nanoscience 05, no. 02n03 (April 2006): 345–50. http://dx.doi.org/10.1142/s0219581x06004450.

Full text
Abstract:
Indium tin oxide (ITO) nanoparticles with In/Sn = 9:1 (at.%) were synthesized by chemical coprecipitation method in an aqueous solution. The coprecipitate prepared at room temperature showed the crystal structure of indium oxide in X-ray diffraction when it was annealed at the temperature above 300°C under air atmosphere. Reduction process was accomplished to improve the electrical property of ITO powder and it changed powder color from yellow to dark green. Green ITO powder with particle sizes in the range of 15–30 nm was well dispersed by an addition of polyvinylpyrrolidone in an aqueous solution. The dispersibility of ITO sol solution was detected with ζ-potential analyzer. Near-IR reflective film was prepared by spin coating method using ITO sol solution. Transmission electron microsopy (TEM) and energy dispersive X-ray spectrometer (EDS) were used to characterize morphology and composition of ITO nanoparticles. Near-IR (NIR) spectrometer was used to determine reflectance on the surface of ITO film in the NIR-radiation region.
APA, Harvard, Vancouver, ISO, and other styles
41

Jasinski, P. J., H. P. Meinzer, C. O. Köhler, and B. Sandblad. "An Approach to Integrate Collections of Images and Relational Databases." Methods of Information in Medicine 27, no. 04 (October 1988): 177–83. http://dx.doi.org/10.1055/s-0038-1635533.

Full text
Abstract:
SummaryThe structure of computer-processed images is described. This is the basis for presenting a method to integrate traditional database concepts and images which represent a certain class of nonformatted, heterogeneous information. The method presented consists of a special, surrogate Image data type and a design of Image Directory, which associates formatted data, raw digital images stored conceptually in the form of a file of variable length, bit string records, and look-up tables. Beside individual and aggregate-oriented retrieval, some tools supporting more sophisticated analyses of images are also suggested. In order to make the description of solutions clear and truly methodological, a basic notion of the relational database technology and a de facto standard query language (SQL) have been applied. The method presented can be used to build various medical applications where images and/or graphics constitute an important fraction of information.
APA, Harvard, Vancouver, ISO, and other styles
42

Larbi, Peter Ako. "Advancing Microsoft Excel’s Potential for Teaching Digital Image Processing and Analysis." Applied Engineering in Agriculture 34, no. 2 (2018): 263–76. http://dx.doi.org/10.13031/aea.12221.

Full text
Abstract:
Abstract. Microsoft Excel is not considered a typical software for digital image processing and analysis. However, based on its large data handling and graphing capabilities, as well as its widespread usage, it presents a good opportunity for use as a tool for teaching image data processing or use in demonstrations requiring little training. It also lends itself well as a potentially useful research tool that can benefit a wide range of users including those with little or no computer programming knowledge. This article demonstrates a new method which can be adopted for teaching concepts of image processing and analysis, consisting of systematic procedures for implementing typical operations in Excel. Categories of operations demonstrated using this method include image preprocessing, image enhancement, image classification, analysis of change over time, and image data fusion. Examples of outputs resulting from using this new method are discussed in the article. The success of this proposed method is hinged on the availability of the required image data, based on which a simple graphical user interface (GUI) application was developed in MATLAB. That application, RGBExcel or the later RGB2X, extracts RGB image data from image files of any format and file size, and exports to Excel for processing. Deployed as standalone applications, both versions can be installed on a 64-bit windows computer and run without MATLAB. Keywords: Color images, Multispectral imagery, Remote sensing, RGB image data, RGB2X, RGBExcel.
APA, Harvard, Vancouver, ISO, and other styles
43

Melyanti*, Rika, and Muhammad Giatman. "Online Determination of Credit Score (PAK) Application Functional Teachers." International Journal of Management and Humanities 5, no. 7 (March 30, 2021): 89–93. http://dx.doi.org/10.35940/ijmh.f1238.035721.

Full text
Abstract:
Determination of Teacher Credit Numbers (PAK) is proposed by the teacher, which are evaluated and evaluated by the Assessment Team. Calculation of credit numbers in PAK still uses manual methods using Microsoft Excel for inputting and Microsoft results as reports, errors in input such as typos and risk of accidental deletion of data still occur frequently. The DUPAK report that will be input into the PAK system is also still waiting for the Assessment Team to send the file to the Pelalawan Regency Education Office so that it takes more time to complete the functional teacher promotion report. To overcome this problem, the credit score calculation process is fast and accurate. A new web-based system, which includes all the elements that are valued by credit numbers. In the old system procedure and the new system it is not much different, the fundamental difference between the new system uses a web-based computer technology in data management that can shorten the data entry process and can overcome the obstacles of the old system.
APA, Harvard, Vancouver, ISO, and other styles
44

Ünal, İlker, Önder Kabaş, and Salih Sözer. "Real-Time Electrical Resistivity Measurement and Mapping Platform of the Soils with an Autonomous Robot for Precision Farming Applications." Sensors 20, no. 1 (January 1, 2020): 251. http://dx.doi.org/10.3390/s20010251.

Full text
Abstract:
Soil electrical resistivity (ER) is an important indicator to indirectly determine soil physical and chemical properties such as moisture, salinity, porosity, organic matter level, bulk density, and soil texture. In this study, real-time ER measurement system has been developed with the help of an autonomous robot. The aim of this study is to provide rapid measurement of the ER in large areas using the Wenner four-probe measurement method for precision farming applications. The ER measurement platform consists of the Wenner probes, a y-axis shifter driven by a DC motor through a gear reducer, all installed on a steel-frame that mount to an autonomous robot. An embedded industrial computer and differential global positioning system (DGPS) were used to assist in real-time measuring, recording, mapping, and displaying the ER and the robot position during the field operation. The data acquisition software was codded in Microsoft Visual Basic.NET. Field experiments were carried out in a 1.2 ha farmland soil. ER and DGPS values were stored in Microsoft SQL Server 2005 database, an ordinary Kriging interpolation technique by ArcGIS was used and the average ER values were mapped for the soil depth between 0 and 50 cm. As a result, ER values were observed to be between 30.757 and 70.732 ohm-m. In conclusion, the experimental results showed that the designed system works quite well in the field and the ER measurement platform is a practical tool for providing real-time soil ER measurements.
APA, Harvard, Vancouver, ISO, and other styles
45

Sianturi, Fricles Ariwisanto. "ANALISA PENGARUH LOG TRANSAKSI PADA SISTEM KOMPUTER MENGGUNAKAN ALGORITMA RECOVERY BERBASIS LOG." Journal Of Computer Networks, Architecture and High Performance Computing 1, no. 1 (December 18, 2018): 6–9. http://dx.doi.org/10.47709/cnapc.v1i1.2.

Full text
Abstract:
This study aims to melakukakan analysis of the effect of the transaction log on a computer based system either on a single system tired, and two tiered through simulated transactions bank system with technology client / server to get a log of transactions on the database system Microsoft Windows SQL Server 2008 R2 management studio a data base. Methods or algorithms are used to analyze the transaction log on the system used is a log-based recovery algorithm.The results based on the analysis, showed that the use of query local database and query the database using sotere procedure to get the transaction log for troubleshooting transactions on the database system via a user interface is built to help job database administrator (DBA), much more good compared with conventional systems. Based on the experiments that the log of transactions to be controlled, in-undo, Re-do, or Rolled-Back, even deleted if no longer required automatically to maintain the scalability of computer users in the future, by setting the growth of a standard database from 10% to > 32%, and the establishment of a maintenance schedule to ensure that the reserve database is always available and up to date.
APA, Harvard, Vancouver, ISO, and other styles
46

Chang, Bao-Rong, Hsiu-Fen Tsai, Yun-Che Tsai, Chin-Fu Kuo, and Chi-Chung Chen. "Integration and optimization of multiple big data processing platforms." Engineering Computations 33, no. 6 (August 1, 2016): 1680–704. http://dx.doi.org/10.1108/ec-08-2015-0247.

Full text
Abstract:
Purpose – The purpose of this paper is to integrate and optimize a multiple big data processing platform with the features of high performance, high availability and high scalability in big data environment. Design/methodology/approach – First, the integration of Apache Hive, Cloudera Impala and BDAS Shark make the platform support SQL-like query. Next, users can access a single interface and select the best performance of big data warehouse platform automatically by the proposed optimizer. Finally, the distributed memory storage system Memcached incorporated into the distributed file system, Apache HDFS, is employed for fast caching query results. Therefore, if users query the same SQL command, the same result responds rapidly from the cache system instead of suffering the repeated searches in a big data warehouse and taking a longer time to retrieve. Findings – As a result the proposed approach significantly improves the overall performance and dramatically reduces the search time as querying a database, especially applying for the high-repeatable SQL commands under multi-user mode. Research limitations/implications – Currently, Shark’s latest stable version 0.9.1 does not support the latest versions of Spark and Hive. In addition, this series of software only supports Oracle JDK7. Using Oracle JDK8 or Open JDK will cause serious errors, and some software will be unable to run. Practical implications – The problem with this system is that some blocks are missing when too many blocks are stored in one result (about 100,000 records). Another problem is that the sequential writing into In-memory cache wastes time. Originality/value – When the remaining memory capacity is 2 GB or less on each server, Impala and Shark will have a lot of page swapping, causing extremely low performance. When the data scale is larger, it may cause the JVM I/O exception and make the program crash. However, when the remaining memory capacity is sufficient, Shark is faster than Hive and Impala. Impala’s consumption of memory resources is between those of Shark and Hive. This amount of remaining memory is sufficient for Impala’s maximum performance. In this study, each server allocates 20 GB of memory for cluster computing and sets the amount of remaining memory as Level 1: 3 percent (0.6 GB), Level 2: 15 percent (3 GB) and Level 3: 75 percent (15 GB) as the critical points. The program automatically selects Hive when memory is less than 15 percent, Impala at 15 to 75 percent and Shark at more than 75 percent.
APA, Harvard, Vancouver, ISO, and other styles
47

Fong, Joseph, Qing Li, and Shi-Ming Huang. "Universal Data Warehousing Based on a Meta-Data Modeling Approach." International Journal of Cooperative Information Systems 12, no. 03 (September 2003): 325–63. http://dx.doi.org/10.1142/s0218843003000772.

Full text
Abstract:
Data warehouse contains vast amount of data to support complex queries of various Decision Support Systems (DSSs). It needs to store materialized views of data, which must be available consistently and instantaneously. Using a frame metadata model, this paper presents an architecture of a universal data warehousing with different data models. The frame metadata model represents the metadata of a data warehouse, which structures an application domain into classes, and integrates schemas of heterogeneous databases by capturing their semantics. A star schema is derived from user requirements based on the integrated schema, catalogued in the metadata, which stores the schema of relational database (RDB) and object-oriented database (OODB). Data materialization between RDB and OODB is achieved by unloading source database into sequential file and reloading into target database, through which an object relational view can be defined so as to allow the users to obtain the same warehouse view in different data models simultaneously. We describe our procedures of building the relational view of star schema by multidimensional SQL query, and the object oriented view of the data warehouse by Online Analytical Processing (OLAP) through method call, derived from the integrated schema. To validate our work, an application prototype system has been developed in a product sales data warehousing domain based on this approach.
APA, Harvard, Vancouver, ISO, and other styles
48

Haghish, E. F. "Markdoc: Literate Programming in Stata." Stata Journal: Promoting communications on statistics and Stata 16, no. 4 (December 2016): 964–88. http://dx.doi.org/10.1177/1536867x1601600409.

Full text
Abstract:
Rigorous documentation of the analysis plan, procedure, and computer codes enhances the comprehensibility and transparency of data analysis. Documentation is particularly critical when the codes and data are meant to be publicly shared and examined by the scientific community to evaluate the analysis or adapt the results. The popular approach for documenting computer codes is known as literate programming, which requires preparing a trilingual script file that includes a programming language for running the data analysis, a human language for documentation, and a markup language for typesetting the document. In this article, I introduce markdoc, a software package for interactive literate programming and generating dynamic-analysis documents in Stata. markdoc recognizes Mark-down, LATEX, and HTML markup languages and can export documents in several formats, such as PDF, Microsoft Office .docx, OpenOffice and LibreOffice .odt, LATEX, HTML, ePub, and Markdown.
APA, Harvard, Vancouver, ISO, and other styles
49

Qtaish, Amjad, and Mohammad T. Alshammari. "A Narrative Review of Storing and Querying XML Documents Using Relational Database." Journal of Information & Knowledge Management 18, no. 04 (December 2019): 1950048. http://dx.doi.org/10.1142/s0219649219500485.

Full text
Abstract:
Extensible Markup Language (XML) has become a common language for data interchange and data representation in the Web. The evolution of the big data environment and the large volume of data which is being represented by XML on the Web increase the challenges in effectively managing such data in terms of storing and querying. Numerous solutions have been introduced to store and query XML data, including the file systems, Object-Oriented Database (OODB), Native XML Database (NXD), and Relational Database (RDB). Previous research attempts indicate that RDB is the most powerful technology for managing XML data to date. Because of the structure variations of XML and RDB, the need to map XML data to an RDB scheme is increased. This growth has prompted numerous researchers and database vendors to propose different approaches to map XML documents to an RDB, translating different types of XPath queries to SQL queries and returning the results to an XML format. This paper aims to comprehensively review most cited and latest mapping approaches and database vendors that use RDB solution to store and query XML documents, in a narrative manner. The advantages and the drawbacks of each approach is discussed, particularly in terms of storing and querying. The paper also provides some insight into managing XML documents using RDB solution in terms of storing and querying and contributes to the XML community.
APA, Harvard, Vancouver, ISO, and other styles
50

Wicaksono, Diaz, Kodrat Iman Satoto, and Rinta Kridalukmana. "Aplikasi Manajemen Praktikum Laboratorium Software Engineering Sistem Komputer Universitas Diponegoro." Jurnal Teknologi dan Sistem Komputer 2, no. 2 (April 30, 2014): 143–48. http://dx.doi.org/10.14710/jtsiskom.2.2.2014.143-148.

Full text
Abstract:
Lab activities are activities that are routinely performed by college students, lab activities shall be carried out as part of the lectures. In practice, there is no doubt often occur int the organization of costraints associated with the lab, such as information dissemination, creation of assessment list and data is not centralized. One of the lab activities is performed in the Laboratory of Computer System Software Engineering Diponegoro University. The labs require a lab managementapplications in order to improve work efficiency and improve the smooth operation of the lab. Practical Application Management consist of client and a blogapplications, created using Visual C# for client, ASP.NET for the blog and with the .NET Framework technology also Microsoft SQL Server databases. Development method was performed using the waterfall method, whereas in application design using UML modeling. The expected result from design of this application is to create an application that consist of client and blog application to managedata from many lab activities in a university lab, such as processing data from various laboratory practitioner, creation of assessment list and dissemination of information about the lab activities.
APA, Harvard, Vancouver, ISO, and other styles
You might also be interested in the bibliographies on the topic 'Microsoft SQL (Computer file)' for other source types:
Dissertations / Theses Books
We offer discounts on all premium plans for authors whose works are included in thematic literature selections. Contact us to get a unique promo code!

To the bibliography