Journal articles: 'SQL Server (Computer program)'

1

Li, Xiao Bin, and De Rong Jiang. "Study on CAPP System Based on Rough Set Theory." Advanced Materials Research 219-220 (March 2011): 1060–63. http://dx.doi.org/10.4028/www.scientific.net/amr.219-220.1060.

Full text

Abstract:

As a significant technology of Computer Integrated Manufacturing System (CIMS), Computer Aided Process Planning (CAPP) is the bridge between Computer Aided Design (CAD) and Computer Aided Manufacturing (CAM). Meanwhile, it is a momentous foundation for building the overall information model of manufacturing of engineering product. By using of which along with the theory of rough set in rule reduction of expert system, the development of CAPP system framework is basis of .net platform, utilizing Visual Studio 2003 to design the system interface and associated structured query language (SQL) allow distributed data processing and data access, which is supported by SQL Server 2000. By designing and running the program, the method of designing is verified.

APA, Harvard, Vancouver, ISO, and other styles

2

Zhao, Mei Hong, and Jian Ping Ren. "The Research and Development of an Exam-Integrating System Based on .NET-Test Library." Applied Mechanics and Materials 135-136 (October 2011): 1077–80. http://dx.doi.org/10.4028/www.scientific.net/amm.135-136.1077.

Full text

Abstract:

In order to implement Exam-Integrating system with the function of auto generating papers, in this paper, we propose a program which processes the non-text information in the system such as complex formulas and graphics. The program takes model of reflection technology, with the use of ASP .NET technology and SQL Server 2005 database. The system completes both test library by hand and Exam-Integrating by specified parameters, and then generates the paper by automatically computer type setting.

APA, Harvard, Vancouver, ISO, and other styles

3

Andria, Andria, and Ridho Pamungkas. "Penetration Testing Database Menggunakan Metode SQL Injection Via SQLMap di Termux." Indonesian Journal of Applied Informatics 5, no. 1 (April 18, 2021): 1. http://dx.doi.org/10.20961/ijai.v5i1.40845.

Full text

Abstract:

Abstrak : Penetration testing (Pentesting) merupakan sebuah metode evaluasi terhadap keamanan pada suatu sistem dan jaringan komputer dengan melakukan suatu pengujian, salah satu metode pengujian yang dapat digunakan adalah SQL Injection. SQL Injection merupakan suatu teknik hacking dengan fokus pengujian pada database sebagai media penyimpanan data pada sistem. Tool yang digunakan pada penelitian ini ialah SQLMap yang merupakan tool open source yang dapat menganalisa, mendeteksi dan melakukan exploit (sebuah kode yang dapat menyerang keamanan sistem komputer secara spesifik) pada bug SQL Injection. Pengujian dilakukan menggunakan perangkat Smartphone bersistem operasi Android dengan program aplikasi Termux sebagai emulator terminal berbasis linux. Tujuan dari penelitian ini untuk pengujian keamanan database web server dan membantu pengelola atau admin situs web untuk dapat memeriksa adanya celah kerentanan database yang dapat dieskploitasi oleh peretas.____________________________Abstract :Penetration testing (Pentesting) is a method of evaluating the security of a computer system and network by conducting a test, one of the testing methods that can be used is SQL Injection . SQL Injection is a hacking technique that focuses on testing the database as a data storage medium on the system. The tool used in this study is SQLMap which is an open source tool that can analyze, detect and exploit (a code that can specifically attack computer system security) on the SQL Injection bug. Testing was carried out using a Smartphone device with the Android operating system with the Termux application program as a linux-based terminal emulator. The purpose of this research is to test the security of the web server database and help the website manager or admin to be able to check for any database vulnerabilities that can be exploited by hackers.

APA, Harvard, Vancouver, ISO, and other styles

4

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

5

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

6

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

7

Jalbani, Khuda Bux, Muhammad Yousaf, Muhammad Shahzad Sarfraz, Rozita Jamili Oskouei, Akhtar Hussain, and Zojan Memon. "Poor Coding Leads to DoS Attack and Security Issues in Web Applications for Sensors." Security and Communication Networks 2021 (May 19, 2021): 1–11. http://dx.doi.org/10.1155/2021/5523806.

Full text

Abstract:

As the SQL injection attack is still at the top of the list at Open Web Application Security Project (OWASP) for more than one decade, this type of attack created too many types of issues for a web application, sensors, or any similar type of applications, such as leakage of user private data and organization intellectual property, or may cause Distributed Denial of Service (DDoS) attacks. This paper focused on the poor coding or invalidated input field which is a big cause of services unavailability for web applications. Secondly, it focused on the selection of program created issues for the WebSocket connections between sensors and the webserver. The number of users is growing to use web applications and mobile apps. These web applications or mobile apps are used for different purposes such as tracking vehicles, banking services, online stores for shopping, taxi booking, logistics, education, monitoring user activities, collecting data, or sending any instructions to sensors, and social websites. Web applications are easy to develop with less time and at a low cost. Due to that, business community or individual service provider’s first choice is to have a website and mobile app. So everyone is trying to provide 24/7 services to its users without any downtime. But there are some critical issues of web application design and development. These problems are leading to too many security loopholes for web servers, web applications, and its user’s privacy. Because of poor coding and validation of input fields, these web applications are vulnerable to SQL Injection and other security problems. Instead of using the latest third-party frameworks, language for website development, and version database server, another factor to disturb the services of a web server may be the socket programming for sensors at the production level. These sensors are installed in vehicles to track or use them for booking mobile apps.

APA, Harvard, Vancouver, ISO, and other styles

8

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

9

Riadi, Imam, Rusdy Umar, and Dora Bernadisman. "Analisis Forensik Database Menggunakan Metode Forensik Statis." JURNAL SISTEM INFORMASI BISNIS 9, no. 1 (May 3, 2019): 9. http://dx.doi.org/10.21456/vol9iss1pp9-17.

Full text

Abstract:

SIMDA (Regional Management Information System) is a system created by the BPKP (Financial and Development Supervisory Agency) to assist local governments in implementing regional financial management so that it complies with applicable, efficient, effective, transparent, accountable and auditable regulations. Management data is stored in the SIMDA database on a server connected to a computer network, it is possible that the database is always infiltrated and indicated by data manipulation by hackers. The purpose of this study is to monitor database activity and detect data manipulation done by hackers, then forensic processes are carried out using static forensic methods with stages, namely data collection, data checking, data analysis, and reporting so as to provide evidence and instructions to do analysis on the SIMDA Planning database. The results obtained using static forensic methods show that there has been manipulation or change in the budget ceiling of the activity that exceeds the program budget ceiling (mark-up in budget planning) carried out by hackers who enter through the SIMDA database. Output from forensic processes can prove manipulation data that is carried out by hackers can be detected using SQL Profiler and SQL Log Analyzer tools so that output can be used as digital evidence to assist law enforcement in revealing cybercrime crime cases and can be accounted for in court proceedings.

APA, Harvard, Vancouver, ISO, and other styles

10

Guo, Yuan, Yu Sun, and Kai Wu. "Research and development of monitoring system and data monitoring system and data acquisition of CNC machine tool in intelligent manufacturing." International Journal of Advanced Robotic Systems 17, no. 2 (March 1, 2020): 172988141989801. http://dx.doi.org/10.1177/1729881419898017.

Full text

Abstract:

Intelligent manufacturing as the development direction of the new generation manufacturing system has become a hot research topic. Computer numerical control (CNC) machine tools are the core manufacturing equipment in discrete manufacturing enterprises, collecting and monitoring the data is an important part of intelligent manufacturing workshops. It has a great significance to improve the production efficiency of enterprises and eliminate information islands. The purpose of this article is to solve the problems of data acquisition and monitoring of CNC machine tools in the manufacturing workshop of enterprises. This article uses FOCAS data acquisition method to research and develop the data acquisition and monitoring system of CNC machine tools in intelligent manufacturing workshop. The research results show that the equipment information model based on MTConnect protocol and FOCAS can solve the data acquisition and storage functions of CNC machine tools well. Using the object-oriented Petri net model, it can solve various uncertain factors in numerical control (NC) machining tasks and realize the monitoring function of CNC machining tasks in the workshop. Based on the NC program analysis, the calculation method of machining time in the NC program can determine the preventive maintenance cycle of the machine based on the machine fault information. Based on VS2013 development environment, Qt application framework and SQL Server 2012 database, the numerical control machine tool data acquisition and monitoring prototype system was developed, and the system was verified in the workshop to prove the effectiveness of the system.

APA, Harvard, Vancouver, ISO, and other styles

11

Fadeev, A. I., and S. Alhusseini. "Transit ridership survey by analysis validation of electronic pass tickets." Russian Automobile and Highway Industry Journal 18, no. 1 (March 30, 2021): 52–71. http://dx.doi.org/10.26518/2071-7296-2021-18-1-52-71.

Full text

Abstract:

Introduction. The methods used today for determining the demand on public transport come with a big waste of time, resources and a need for great effort. In this regard, a special perspective is to study the transit demand based on the collection, integration and analysis of large and diverse data, which were generated by various sources of human life: Urban computing, Big data, Internet of things.Materials and methods. This article presents a method for determining (restoring) the correspondence of transit passengers by means of intelligent analysis of validation operations data of electronic travel tickets (smart card, transport card, magnetic card, mobile phone or other electronic devices (electronic gadgets)), which are recorded in the automated transportation management system during validation.Results. The algorithm for calculating passenger correspondence is implemented in a computer program using the relational DBMS MS SQL Server. The effectiveness of the proposed algorithm was verified by calculating the passenger correspondence of public transport in the city of Krasnoyarsk (Russia).Discussion and conclusion. The described method for calculating passenger flows, based on analyzing the data of validation operations of electronic tickets and data from the transit dispatch control system, makes possible to determine the route and passengers correspondence and, to carry out an objective assessment of the demand for public transport and the technical and operational indicators of the transit system.

APA, Harvard, Vancouver, ISO, and other styles

12

Trofimova, Natalya, Evgenia Ermolaeva, and Ivan Trofimov. "Development of a Software Product for the Automation of Hazard Analysis and Critical Control Points in Food Production." Food Processing: Techniques and Technology 50, no. 1 (March 27, 2020): 167–75. http://dx.doi.org/10.21603/2074-9414-2020-1-167-175.

Full text

Abstract:

Introduction. The introduction of modern management methods in food enterprises is a response to the challenges of time and an institutionalized requirement. Statistical methods and information technologies can improve control in food safety management systems. Their combination provides maximum opportunities for leading food industry organizations. Study objects and methods. The research featured the market of ready-made high-tech solutions in process automation and existing management systems, including those based on the principles of Hazard Analysis and Critical Control Points (HACCP). The study revealed a need for a software product for HACCP in food production. Results and discussion. The paper describes a case of a meat processing plant and how the management controls the HACCP. The authors developed a universal software product that allows operators to enter information about violations and downtimes into the system. Using this product, team leaders and department heads can easily identify and eliminate the causes of hazards while controlling technological processes and receiving timely reports. Conclusion. The software was tested in a production workshop to identify the time specialists need respond to comments and solve problems. The obtained data showed a decrease in loss of time resources by 6.77% for operators and 2.4% for line managers. The highly adaptable program can be used by specialists who work with management systems for food enterprises of Kuzbass. The IBM PC-compatible software product (2.2 MB) makes it possible to work in various Microsoft Windows operating systems and use Microsoft SQL Server 2012 to store data. The computer program was successfully registered with the Federal Service for Intellectual Property (State Registration Certificate No. 2018665743 of 12/10/2018).

APA, Harvard, Vancouver, ISO, and other styles

13

Kundakçi, Burak, and Selçuk Nas. "Mapping Marine Traffic Density by Using AIS Data: An Application in the Northern Aegean Sea." Polish Maritime Research 25, no. 4 (December 1, 2018): 49–58. http://dx.doi.org/10.2478/pomr-2018-0131.

Full text

Abstract:

Abstract Automatic Identification System (AIS) data is used for monitoring the movements of vessels live movements through instant transmission of vessel information while, at the same time, historical AIS data is used for marine traffic analysis by researchers. There are several methods and computer programs developed for the analysis of marine traffic by the use of AIS data. Combining the intersection algorithm proposed by Antonio (1992) and distance calculation method, this study develops a method to analyse vessel distribution on a selected cross sectional line (SCS) in the Northern Aegean Sea. As a complementary to the new methods proposed, a desktop application is developed in C# programming language to visualize the vessel distribution on the SCS line. SQL server is used for AIS data storage and analysis. The study is conducted over 7-day AIS data, specifically 2.382.469 rows and 42.884.442 data in total, belonging to the Northern Aegean Sea marine traffic. As a result, the mapping of the movements of different types of vessels in the Northern Aegean Sea is effectively performed and Frequency-Distance, Draught-Distance, SOG-Distance, SOG-COG distributions on the SCS line are successfully analysed by the new method introduced.

APA, Harvard, Vancouver, ISO, and other styles

14

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

15

Hibbert, A. "Review: Advanced Transact-SQL for SQL Server 2000." Computer Bulletin 43, no. 5 (September 1, 2001): 30. http://dx.doi.org/10.1093/combul/43.5.30.

Full text

APA, Harvard, Vancouver, ISO, and other styles

16

Hibbert, A. "Review: Real World SQL-DMO for SQL Server." Computer Bulletin 45, no. 5 (September 1, 2003): 31. http://dx.doi.org/10.1093/combul/45.5.31-b.

Full text

APA, Harvard, Vancouver, ISO, and other styles

17

Yang, Guang. "The Realization of Math Score Query on the Wireless Internet." Advanced Materials Research 756-759 (September 2013): 1141–45. http://dx.doi.org/10.4028/www.scientific.net/amr.756-759.1141.

Full text

Abstract:

Wireless internet is gaining wide spread usage in teaching affairs, especially in score query system development. This paper explores how simple Math score query system can be developed for mobile devices and introduces general framework for designing such score query applications. Using the framework, based on Microsoft database software SQL Server 2000, T-SQL clause is employed to program one stored procedure for Math score query. The framework utilizes mobile phones simulator software, Nokia WAP Toolkit, which interacts with a server-side ASP (Active Server Pages) in conjunction with the associated SQL Server database. The design and implementation of the management information system are discussed in the paper, and test results are presented.

APA, Harvard, Vancouver, ISO, and other styles

18

Muslim, Much Aziz, and Nur Astri Retno. "Implementasi Cloud Computing Menggunakan Metode Pengembangan Sistem Agile." Scientific Journal of Informatics 1, no. 1 (May 31, 2015): 29–37. http://dx.doi.org/10.15294/sji.v1i1.3639.

Full text

Abstract:

Cloud computing merupakan sebuah teknologi yang menyediakan layanan terhadap sumber daya komputasi melalui sebuah jaringan. Sumber daya yang di sediakan di dalam cloud computing meliputi mesin, media penyimpanan data, sistem operasi dan program aplikasi. Fitur dari cloud computing dipercaya akan jauh lebih hemat dan memuaskan. Masalah yang muncul adalah bagaimana mengimplementasi Cloud Computing dengan menggunakan Windows Azure Pack dan bagaimana provisioning Windows Azure Pack SQL Database. Fokus pada penelitian ini adalah pada proses deploying dan provisioning SQL Database Server. Pengimplementasian cloud computing menggunakan metode pengembangan sistem agile dengan langkah-langkah meliputi perencanaan, implementasi, pengujian (test), dokumentasi, deployment dan pemeliharaan. Untuk menjalankan proses tersebut kebutuhan perangkat yang dipersiapkan meliputi perangkat keras seperti PC Server Cisco UCS C240 M3S2, Hardisk 8753 GB, 256 GB RAM, bandwith minimal 1 Mbps dan kebutuhan perangkat lunak meliputi Windows Server 2012 R2, VMM, Windows Azure Pack, IIS, SQL Server 2012 dan Web Patform Installer. Hasil dari implementasi cloud computing menggunakan metode pengembangan sistem agile adalah terbentuknya sebuah sistem cloud hosting provider dengan menggunakan Windows Azure Pack dan SQL Server 2012 sebagai sistem utama dan pengelolaan database menggunakan Microsoft SQL Server Management

APA, Harvard, Vancouver, ISO, and other styles

19

Han, Xiao Hong, Lei Wang, and Pei Jun Zhang. "Structured Scheme of Data Mining Based on SQL Server 2005." Advanced Materials Research 179-180 (January 2011): 646–50. http://dx.doi.org/10.4028/www.scientific.net/amr.179-180.646.

Full text

Abstract:

This paper highlights the data mining components of SQL Server 2005 and the building of data mining process, completes the creation, training, and the corresponding predictions of data mining model, implements the operation of data mining using data mining algorithms, so the application program, relationship database and data mining are seamless integrated. SQL Server 2005 provides data mining solution with a powerful design and development platform, without too much acquaintance with data mining techniques and data mining algorithms.

APA, Harvard, Vancouver, ISO, and other styles

20

Dalai, Asish Kumar, and Sanjay Kumar Jena. "Neutralizing SQL Injection Attack Using Server Side Code Modification in Web Applications." Security and Communication Networks 2017 (2017): 1–12. http://dx.doi.org/10.1155/2017/3825373.

Full text

Abstract:

Reports on web application security risks show that SQL injection is the top most vulnerability. The journey of static to dynamic web pages leads to the use of database in web applications. Due to the lack of secure coding techniques, SQL injection vulnerability prevails in a large set of web applications. A successful SQL injection attack imposes a serious threat to the database, web application, and the entire web server. In this article, the authors have proposed a novel method for prevention of SQL injection attack. The classification of SQL injection attacks has been done based on the methods used to exploit this vulnerability. The proposed method proves to be efficient in the context of its ability to prevent all types of SQL injection attacks. Some popular SQL injection attack tools and web application security datasets have been used to validate the model. The results obtained are promising with a high accuracy rate for detection of SQL injection attack.

APA, Harvard, Vancouver, ISO, and other styles

21

Frater, K. "Review: SQL Server: Common Problems, Tested Solutions." Computer Bulletin 44, no. 1 (January 1, 2002): 30. http://dx.doi.org/10.1093/combul/44.1.30-a.

Full text

APA, Harvard, Vancouver, ISO, and other styles

22

Choi, Hoyong, Sangjin Lee, and Doowon Jeong. "Forensic Recovery of SQL Server Database: Practical Approach." IEEE Access 9 (2021): 14564–75. http://dx.doi.org/10.1109/access.2021.3052505.

Full text

APA, Harvard, Vancouver, ISO, and other styles

23

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

24

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

25

Jiang, Wu Xue, Xuan Zi Hu, Wei Chun Gao, and Guang Zai Ye. "Reconstruction on Database Technology Module Based on University-Enterprise Cooperation for Polytechnic." Advanced Materials Research 926-930 (May 2014): 2366–69. http://dx.doi.org/10.4028/www.scientific.net/amr.926-930.2366.

Full text

Abstract:

Database technology is one of core technology modules of the computer, mainly including the query of the database, table and database table, safety management, daily management and data transmission, user view and other operation procedures, SQL Server procedure, functions, stored procedure, trigger and other design procedures. With the platform of SQL Server 2008, combined with the basic elements of the database technology, aiming at the demand to cultivate IT talents, relying on the enterprise’s demand on IT job skill, new database technology module architecture is developed in the paper. The structure can provide a good reference value to cultivate new vocational IT talents.

APA, Harvard, Vancouver, ISO, and other styles

26

Wintolo, Hero, Nurcahyani Dewi Retnowati, and Andi Ahmad Iswar Ibrahim. "Layanan Cloud Computing untuk Mendukung Kinerja Administrasi Database Tanpa Menggunakan Perintah SQL." Jurnal ELTIKOM 4, no. 2 (October 22, 2020): 87–95. http://dx.doi.org/10.31961/eltikom.v4i2.174.

Full text

Abstract:

Penelitian ini memiliki tujuan untuk menyediakan layanan dalam bentuk aplikasi untuk melakukan kegiatan Database Manipulation Language (DML) yang diterapkan dalam bentuk cloud computing . Sebanyak tiga buah computer dimanfaatkan untuk memberikan layanan pemrosesan dan penyimpanan database tanpa menggunakan perintah yang ada pada Structure Query Language (SQL) dan satu buah computer digunakan sebagai server yang melayani pengguna untuk melakukan kegiatan DML tanpa menggunakan perintah SQL . Dengan menggunakan teknologi cloud pengelolaan database berbasis SQL yang biasanya menggunakan perintah berbasis command line dapat dilakukan dengan cara yang lebih mudah. Layanan yang diberikan oleh cloud untuk mengelola database berbasis SQL khususnya fungsi DML. Hasil dari implementasi layanan pada jaringan internet, Wireless lan, dan LAN dapat berjalan dengan baik dengan kasus pengujian fungsi pada ketiga media jaringan tersebut. Dengan demikian para pengguna yang sama sekali tidak mengerti bahasa SQL dapat menggunakan layanan ini dengan mudah untuk mengolah database SQL secara mandiri.

APA, Harvard, Vancouver, ISO, and other styles

27

Pan, Wu Min. "Method to Detect SQL Injection Attacks for Complex Network Environment." Advanced Materials Research 651 (January 2013): 841–45. http://dx.doi.org/10.4028/www.scientific.net/amr.651.841.

Full text

Abstract:

SQL injection has become a serious security risk among all the attacks against Web application. The SQL injection attack allows an attacker to access the underlying database unrestrictedly, and furthermore, retrieves the confidential information of the corporation and the network user. We found that most of the existing researches are able to detect most of the attacks, but they do not consider the complexity involved in using the defense system and the eventual cost of modification of the original program. For this reason, we conducts an in-depth research on SQL injection and defense: requires no modification of the web application code,and can be adapted to different usage scenarios,involving also different operating systems and server applications,and can be able to detect all the known injection points for the test application

APA, Harvard, Vancouver, ISO, and other styles

28

Yakub, Yakub, and Shirly Hermanto. "PERANCANGAN PROGRAM APLIKASI PEMBELIAN PADA PT INDO TAICHEN TEXTILE INDUSTRY." CommIT (Communication and Information Technology) Journal 4, no. 1 (May 31, 2010): 1. http://dx.doi.org/10.21512/commit.v4i1.529.

Full text

Abstract:

PT Indo Taichen Textile Industry is a company in the textile industry producing cloth. Activities and operations personnel administration, payroll systems, purchasing systems, and inventory systems are conducted manually. Problems begin to become fairly complex on the company’s purchasing system so that a software application is required. Purchasing system is made by Data Flow Diagram (DFD) as a model of the process or system and Entity Relation Diagram (ERD) as a data model. The purchasing application is programmed using the programming language Visual Basic 6.0 and SQL Server database.Keywords: data base, purchasing, system, information system

APA, Harvard, Vancouver, ISO, and other styles

29

Li, Gong Fa, Jian Yi Kong, Guo Zhang Jiang, and Liang Xi Xie. "Networked Manufacturing System Based on ASP and SQL Server." Advanced Materials Research 129-131 (August 2010): 74–78. http://dx.doi.org/10.4028/www.scientific.net/amr.129-131.74.

Full text

Abstract:

With the development and application of the Internet and Intranet, it shows that the response of the traditional manufacturing model to the information lags behind the change. Based on the computer technology, web technology and modern communication technology, the information flow of networked manufacturing system can be transferred timely among virtual alliance regardless of regions. So social manufacturing resource can be used fully. In order to share timely the information and optimize the social manufacturing resource about designing and producing car wheel hub, a solution to establishing networked manufacturing system of car wheel hub based on ASP and SQL Server was put forward. According to detailed analysis the process of design information transferring and the hub designing, a prototype networked manufacturing system of car wheel hub had been developed. It has very great practical value.

APA, Harvard, Vancouver, ISO, and other styles

30

Zhang, Haiyan. "A Flipped Classroom-Based Education System for College English Teaching." International Journal of Emerging Technologies in Learning (iJET) 14, no. 16 (August 29, 2019): 120. http://dx.doi.org/10.3991/ijet.v14i16.11152.

Full text

Abstract:

The flipped classroom (FC) is a novel teaching mode combining traditional class-room and computer network technology. This paper attempts to design a FC-based education system for college English teaching, which is critical to the quali-ty of English teaching in colleges. In our research, a college English education system is established based on SQL server and FC. The architecture and func-tional modules of the system were discussed in details. Specifically, the system architecture was created based on the browser/server (B/S) structure, the data management was realized by SQL server 2008, and the system functions were designed and achieved by JavaServer Pages (JSP). The proposed system was tested in an actual application. The results confirm that the system can meet the teaching demand, arouse the students’ interest in learning and improve the effect of English teaching.

APA, Harvard, Vancouver, ISO, and other styles

31

Gyorodi, Robert, Marius Iulian Pavel, Cornelia Gyorodi, and Doina Zmaranda. "Performance of OnPrem Versus Azure SQL Server: A Case Study." IEEE Access 7 (2019): 15894–902. http://dx.doi.org/10.1109/access.2019.2893333.

Full text

APA, Harvard, Vancouver, ISO, and other styles

32

Shao, Jingbo, Xiaoxiao Liu, Yingmei Li, and Jingyu Liu. "Database Performance Optimization for SQL Server Based on Hierarchical Queuing Network Model." International Journal of Database Theory and Application 8, no. 1 (February 28, 2015): 187–96. http://dx.doi.org/10.14257/ijdta.2015.8.1.19.

Full text

APA, Harvard, Vancouver, ISO, and other styles

33

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

34

Aleksic, Slavica, Sonja Ristic, Ivan Lukovic, and Milan Celikovic. "A design specification and a server implementation of the inverse referential integrity constraints." Computer Science and Information Systems 10, no. 1 (2013): 283–320. http://dx.doi.org/10.2298/csis111102003a.

Full text

Abstract:

The inverse referential integrity constraints (IRICs) are specialization of non-key-based inclusion dependencies (INDs). Keybased INDs (referential integrity constraints) may be fully enforced by most current relational database management systems (RDBMSs). On the contrary, non-key-based INDs are completely disregarded by actual RDBMSs, obliging the users to manage them via custom procedures and/or triggers. In this paper we present an approach to the automated implementation of IRICs integrated in the SQL Generator tool that we developed as a part of the IIS

APA, Harvard, Vancouver, ISO, and other styles

35

Liu, Xi Mei, Xiao Ting Tong, Heng Lv, and Xi Yang. "Study on Selvage Warp Coefficient Based on Silk Fabric Specifications Database." Advanced Materials Research 332-334 (September 2011): 643–46. http://dx.doi.org/10.4028/www.scientific.net/amr.332-334.643.

Full text

Abstract:

Silk fabric specifications database system was founded with Visual Basic.NET as operating language and SQL SERVER 2000 as management system. In the paper, we proposed the indicator of selvage warp coefficient, and quantified the relationship between inner warp density and selvage warp density. Then, discussed the regularity of selvage density of 12 species of fabrics by software program which can automatically select the information of the silk fabric from the database.The conclusion provided a theoretical basis for the development of new species silk fabric.

APA, Harvard, Vancouver, ISO, and other styles

36

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

37

Du, Qi Jun, and Ming Gui Zou. "The Design of Item Bank System of Computer Operating System." Advanced Materials Research 760-762 (September 2013): 2002–5. http://dx.doi.org/10.4028/www.scientific.net/amr.760-762.2002.

Full text

Abstract:

According to the requirements of modern education theory and technology, combined with the actual teaching conditions of Computer Operating System, an item bank system is designed and realized by adopting the VB 6.0 and SQL Server 2000. The system benefits for separating testing from teaching and settles the problem of randomness and unrepeatability caused by manual paper generation. In this paper, some key techniques, such as system function design, the database table design, making-up strategy, Word-paper making etc. are introduced, which have very strong universal property and operability.

APA, Harvard, Vancouver, ISO, and other styles

38

Qin, Li. "Design and Realization of Project-based Computer English Learning System." International Journal of Emerging Technologies in Learning (iJET) 12, no. 08 (August 1, 2017): 128. http://dx.doi.org/10.3991/ijet.v12i08.7147.

Full text

Abstract:

This paper describes the design principles and realization process of project-based computer English learning system. The subjective initiative of project-based learning is applied to English learning as a starting point, allowing full play to learner’s analytical, problem-solving and self-exploration ability. Combined with the computer database SQL Server and other related procedures, we established an English project-based learning system, investigated its user satisfaction and collected relevant statistics. This system plays a promotive role in providing guidance for English learning and lifting the informatization level of English teaching.

APA, Harvard, Vancouver, ISO, and other styles

39

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

40

Murthy, Uday S. "An Analysis of the Effects of Continuous Monitoring Controls on e-Commerce System Performance." Journal of Information Systems 18, no. 2 (September 1, 2004): 29–47. http://dx.doi.org/10.2308/jis.2004.18.2.29.

Full text

Abstract:

This research investigates the effects on e-commerce system performance of alternative types of application controls that continually monitor transaction-processing activity. The three categories of controls examined were relatively simple controls involving calculations, more complicated controls requiring database lookups, and the most intensive controls involving the use of aggregate statistical functions. A test e-commerce platform comprising a sales order entry application was programmed using Active Server Pages (ASP) technology. The system, running on a Windows 2000 Server platform with the data in a SQL Server 2000 database, was stress-tested using Microsoft's web Application Stress tool. To gauge the performance of the system under low, medium, and high load conditions, various statistics were gathered including processor utilization, ASP requests per second, SQL Server transactions per second, ASP requests queued, and time to last byte of the main order processing script. Results revealed that calculation controls could easily be accommodated by the e-commerce system, regardless of system load. Lookup controls had a detrimental effect on system performance only when they were heavily used. Aggregate function controls had a dramatic negative impact on system performance. The results of this study are useful for both capacity planning and capacity management and provide support for both internal and external auditors requesting the inclusion of continuous monitoring controls in modern e-commerce systems.

APA, Harvard, Vancouver, ISO, and other styles

41

Qin, Guo Hua, Hua Yu Zhu, Hai Chao Ye, and Mei Dan Zhou. "Advanced Development Method of the Standard Fixel Library for Computer Aided Fixture Design." Advanced Materials Research 421 (December 2011): 373–76. http://dx.doi.org/10.4028/www.scientific.net/amr.421.373.

Full text

Abstract:

In order to efficiently design a fixture, it is necessary to establish a standard fixel library for CAFD system. Therefore, a SQL Server-based development technology is first employed to manage the parameterized fixel models. And then, in order to construct a fixel model, MFC is adopted to carry out the secondary development of Unigraph environment. Thus, arbitrary fixel can be dimension-drive designed according to a parameterized fixel model. The establishment of the fixel library can to a great extent reduce the trivial and repetitive tasks in the fixture design.

APA, Harvard, Vancouver, ISO, and other styles

42

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

43

Ren, Jian Ping, and Mei Hong Zhao. "The Research on Test Automation Based on the Window Application Software." Applied Mechanics and Materials 135-136 (October 2011): 1093–95. http://dx.doi.org/10.4028/www.scientific.net/amm.135-136.1093.

Full text

Abstract:

In order to implement software automated test on the application of .NET form class, in this paper, we propose a program that builds resources platforms for under test programs, just like software structure information store and common window widgets test case library. It takes white-box method for the test model, with the use of SQL Server databases. The program executes cover tests on those common interaction widgets easy to result in exceptions for Windows applications. At the same time, it gets attributes information of the window widgets. Then it achieves automatic generation of test cases, and imports them into Excel. Based on the related software information generated above, the program will complete the test automatically, and give the test analysis report to improve the efficiency of software testing.

APA, Harvard, Vancouver, ISO, and other styles

44

Cheng, Feng Min. "Design of Inverter Communication Network Query Engine." Advanced Materials Research 945-949 (June 2014): 2758–61. http://dx.doi.org/10.4028/www.scientific.net/amr.945-949.2758.

Full text

Abstract:

According to the communication mode between different series of inverter and different series of PLC, the database model of communication protocols and parameters is built; then query application software is developed for the establishment, modification and searching the inverter communication network configuration. It is built with VC++ as the foreground, SQL Server as the background database support. The main function modules include communication parameter management module, communication program information management module and information query module. Results show that it can quickly provide communication scheme between the commonly used inverter and PLC for the industrial site and technical personnel.

APA, Harvard, Vancouver, ISO, and other styles

45

Rostiani, Yeny, Indaryono Indaryono, and Ratna Furi Handayani. "Application Design For Office Stationary Inventory Management Based On Vb.Net At PT. Hunu Osias Padmada Eara Karawang." Dirgamaya: Jurnal Manajemen dan Sistem Informasi 1, no. 1 (June 15, 2021): 29–42. http://dx.doi.org/10.35969/dirgamaya.v1i1.22.

Full text

Abstract:

The availability of office stationery is very important to make the required work smooth. In order for ATK management to be handled properly, an application is needed to manage ATK inventory data using a technology-based information system so that it becomes a complete information system. The method used by the author in conducting this research is the Waterfall model system development method starting from the specification of user requirements, planning, modeling, and coding. The method of specification of user requirements includes interviews, observations, literature studies, and documentation studies. The planning method includes the tasks to be carried out including the risks that may occur and the work schedule. Modeling methods include the design of flow documents, DFD, data dictionary, and ERD. The coding includes a program designer with the VB.Net programming language with SQL Server 2008 database and application testing using black box testing, namely this test is intended to determine whether the functions, inputs and outputs of the software are in accordance with the required specifications. To simplify reporting and recording so that errors do not occur, it is necessary to design and implement a system that can facilitate inter-related functions within the company by using Microsoft Visual Studio 2010 (VB.Net) and Microsoft SQL Server 2008. With the implementation of this system, it is expected will be useful for the company in its operations in the future.

APA, Harvard, Vancouver, ISO, and other styles

46

Muhardi, Muhardi. "Sistem E-Inventory Menggunakan Bahasa Pemograman Visual Basic.NET." INTECOMS: Journal of Information Technology and Computer Science 2, no. 1 (May 21, 2019): 10–16. http://dx.doi.org/10.31539/intecoms.v2i1.678.

Full text

Abstract:

Universal Computer is a business entity in Pekanbaru engaged in the assembly and sale of computers and equipment that do not have a system that integrates well between sales, purchases, and inventory. The recording process is still manual by using the ledger so that the resulting data is less effective and efficient. In addition, the Universal Computer Shop has a weakness in reporting sales, purchases, and inventory that the level of accuracy is still lacking. Entities such as Universal Computer Store will be very good if they have a good information system so that the management of sales, purchases, and inventory in the business will be better. This information system is based on desktop using visual basic programming language .Net and SQL Server 2008 database and information system design that used is Data Flow Diagram (DFD) and ER diagram for business process to be designed. Information systems are provided for Universal Computer Stores to provide convenience to system users, especially employees, suppliers, customers, inventory, goods, and sales, purchasing, sales, inventory, employees, suppliers and customers. It can be concluded that this application is able to assist the Universal Computer Shop in handling the problem of recording purchases, sales, management, inventory, employees, suppliers, customers making reports on purchases, sales, inventory, employees, suppliers, and customers. Keywords: Purchase, Sales, Inventory, Visual Basic. Net, SQL Server 2008

APA, Harvard, Vancouver, ISO, and other styles

47

He, Shi Jun, Yu Zhang, and Yuan Yu. "Application of ArcGIS/MATLAB/ SQL Server/ VC++ Mixed Programming in Solar Energy Engineering." Advanced Materials Research 171-172 (December 2010): 323–28. http://dx.doi.org/10.4028/www.scientific.net/amr.171-172.323.

Full text

Abstract:

Computer implementation of the models in solar energy engineering is very important. This paper summarized the models and realized them by ArcGIS/MATLAB/ SQL Server/ VC++ mixed programming. The experimental results show that it is feasible to apply mixed programming in solar energy engineering. The storage and management of solar energy data are of good performance. The implementation brings convenience for the solar energy reasonably utilization. Further, it puts forward a new direction for solar energy data analysis and calculation.

APA, Harvard, Vancouver, ISO, and other styles

48

Lou, Qi Ming, Ying Fang Li, and Hong Wei Zhang. "Design and Implementation of an Intelligent Billing Algorithm for Open Computer Room Management System." Applied Mechanics and Materials 336-338 (July 2013): 1953–56. http://dx.doi.org/10.4028/www.scientific.net/amm.336-338.1953.

Full text

Abstract:

Computer room is an important infrastructure of information technology on education for colleges, how to balance the load, calculate fees flexibly, improve resource utilization, service for the teachers and students better is an urgent problem.Firstly, the development trends of computer room management systems are discussed in the paper. Secondly, gives a data model of open computer room management system, which in order to balance the load and improve the utilization efficiency etc. of computer rooms. Finally, gives the intelligent billing algorithm according to the designed data model, and then implemented the algorithm using stored procedure with SQL Server 2005.

APA, Harvard, Vancouver, ISO, and other styles

49

Chen, Bin. "Maintenance and Repair Management and Optimization of Aircraft Base on Working Hour Standard." Applied Mechanics and Materials 511-512 (February 2014): 783–86. http://dx.doi.org/10.4028/www.scientific.net/amm.511-512.783.

Full text

Abstract:

Aircraft scheduled maintenance with their preciseness, complexity, has the characteristics of the planning, for high requirement of man-hour management. Man-hour maintenance standards data is the most important in production management of the quantization standard, which is the key to reasonable use of human resources, keep the maintenance quality, improve the production efficiency and reduce cost. According to production management system of scheduled maintenance the application requirements, business processes of production analyzed; Maintenance of production man-hour foundation database system structure, knowledge acquisition, and data warehouse etc are discussed; SQL server 2008 building database and C# language develop core program, for aircraft scheduled maintenance to offer an effective management mode.

APA, Harvard, Vancouver, ISO, and other styles

50

Sherstuk, Y. "Solutions on oil refinery information storage construction on the basis of MS SQL server." Expert Systems with Applications 26, no. 1 (January 2004): 73–79. http://dx.doi.org/10.1016/s0957-4174(03)00108-8.

Full text

APA, Harvard, Vancouver, ISO, and other styles

Journal articles on the topic 'SQL Server (Computer program)'

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