Щоб переглянути інші типи публікацій з цієї теми, перейдіть за посиланням: Microsoft SQL Server.

Статті в журналах з теми "Microsoft SQL Server"

Оформте джерело за APA, MLA, Chicago, Harvard та іншими стилями

Оберіть тип джерела:

Ознайомтеся з топ-50 статей у журналах для дослідження на тему "Microsoft SQL Server".

Біля кожної праці в переліку літератури доступна кнопка «Додати до бібліографії». Скористайтеся нею – і ми автоматично оформимо бібліографічне посилання на обрану працю в потрібному вам стилі цитування: APA, MLA, «Гарвард», «Чикаго», «Ванкувер» тощо.

Також ви можете завантажити повний текст наукової публікації у форматі «.pdf» та прочитати онлайн анотацію до роботи, якщо відповідні параметри наявні в метаданих.

Переглядайте статті в журналах для різних дисциплін та оформлюйте правильно вашу бібліографію.

1

Setiyadi, Didik, Henderi Henderi, and Rita Wahyuni Arifin. "Implementasi Import dan Export Database dengan Menggunakan SQL Server 2008." INFORMATICS FOR EDUCATORS AND PROFESSIONAL : Journal of Informatics 5, no. 1 (December 28, 2020): 1. http://dx.doi.org/10.51211/itbi.v5i1.1413.

Повний текст джерела
Анотація:
Abstrak: Import data adalah proses mengambil data dari database lain misalkan Microsoft Access kedalam SQL Server 2008, bisa juga Microsoft Excel yang telah kira miliki dilakukan import data kedalam SQL Server 2008. Pada import dari Microsoft Access bisa kita ambil seluruh table dan datanya atau sebagian saja yang diimport, demikian juga kalo kita akan melakukan import dari Microsoft Excel. Jika kita melakukan import dari Microsoft Access, maka primary key akan hilang dan demikian juga untuk tipe data akan berubah menyesuaikan dengan tipe data yang ada di SQL Server 2008, demikan juga jika melakukan import dari Microsoft Excel. Sedangkan pada proses export data adalah proses mengeluarkan data dari database yang ada di SQL Server 2008 kedalam database lain misalkan Microsoft Access atau bisa juga ke Microsoft Excel. Pada export data dari SQL Server 2008 ke Microsoft Access bisa kita ambil seluruh table dan datanya atau sebagian saja yang, demikian juga kalo kita akan melakukan export ke Microsoft Excel. Pada penulisan ini akan dibahas tentang bagaimana melakukan export dan import data dengan menggunakan SQL Server 2008. Langkah awal yang dilakukan adalah dengan mengambil studi kasus database Jadwal Mengajar Microsoft Access yang telah terbentuk relationshipnya beserta isi datanya. Selanjutnya bagaimana melakukan proses import database tersebut ke SQL Server 2008, membuat primary key, relasi sampai terbentuk diagram dengan menggunakan DBMS SQL Server 2008. Berdasarkan database yang telah terbentuk diagramnya tersebut akan kita lakukan export ke dalam Microsoft Excel. Kata Kunci: Export, Import, Relasi, Diagram, Relationship, Sql Server 2008, Jadwal Mengajar Abstract: Importing data is the process of retrieving data from other databases, for example, Microsoft Access into SQL Server 2008, Microsoft Excel, which is thought to have, is imported data into SQL Server 2008. On import from Microsoft Access, we can retrieve all tables and data or only part of it is imported , Likewise, if we are going to import from Microsoft Excel. If we import from Microsoft Access, the primary key will be lost and the data type will change according to the data type in SQL Server 2008, as well as importing from Microsoft Excel. Meanwhile, the data export process is the process of removing data from an existing database in SQL Server 2008 into another database, for example Microsoft Access or Microsoft Excel. In exporting data from SQL Server 2008 to Microsoft Access, we can take the entire table and the data or only part of it, so if we are going to export to Microsoft Excel. In this paper will discuss about how to export and import data using SQL Server 2008. The first step is to take a case study of the Microsoft Access Teaching Schedule database that has formed a relationship and its data contents. Furthermore, how to import the database into SQL Server 2008, create primary keys, relationships to form diagrams using the SQL Server 2008 DBMS. Based on the database that has formed the diagrams, we will export it into Microsoft Excel. Keywords: Export, Import, Relation, Diagram, Relationship, Sql Server 2008, Teaching Schedule
Стилі APA, Harvard, Vancouver, ISO та ін.
2

Guo, Hongfei, Dan Jones, Jennifer Beckmann, and Praveen Seshadri. "Declarative management in Microsoft SQL server." Proceedings of the VLDB Endowment 2, no. 2 (August 2009): 1294–305. http://dx.doi.org/10.14778/1687553.1687555.

Повний текст джерела
Стилі APA, Harvard, Vancouver, ISO та ін.
3

Wehde, Ed. "Microsoft to beef up SQL Server security." Network Security 2000, no. 2 (February 2000): 4. http://dx.doi.org/10.1016/s1353-4858(00)87651-5.

Повний текст джерела
Стилі APA, Harvard, Vancouver, ISO та ін.
4

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.

Повний текст джерела
Анотація:
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 та ін.
5

Chaudhuri, Surajit, and Vivek Narasayya. "Microsoft index turning wizard for SQL Server 7.0." ACM SIGMOD Record 27, no. 2 (June 1998): 553–54. http://dx.doi.org/10.1145/276305.276378.

Повний текст джерела
Стилі APA, Harvard, Vancouver, ISO та ін.
6

Shin, Jiho. "Comparison of Remaining Data According to Deletion Events on Microsoft SQL Server." Journal of the Korea Institute of Information Security and Cryptology 27, no. 2 (April 30, 2017): 223–32. http://dx.doi.org/10.13089/jkiisc.2017.27.2.223.

Повний текст джерела
Стилі APA, Harvard, Vancouver, ISO та ін.
7

Wang, Dong Yun. "Advanced Studying on Microsoft SQL Server 2008 Data Mining." Applied Mechanics and Materials 20-23 (January 2010): 748–52. http://dx.doi.org/10.4028/www.scientific.net/amm.20-23.748.

Повний текст джерела
Анотація:
Data mining application used by an enterprise is a powerful tool to help and guide your decision making to keep your products and services competitive. This paper introduces the relate contents for data mining and gives out an overview of typical data mining problems and the tools and models that are available in SQL Server 2008 for solving these problems.
Стилі APA, Harvard, Vancouver, ISO та ін.
8

Kazemitabar, Seyed Jalal, Ugur Demiryurek, Mohamed Ali, Afsin Akdogan, and Cyrus Shahabi. "Geospatial stream query processing using Microsoft SQL Server StreamInsight." Proceedings of the VLDB Endowment 3, no. 1-2 (September 2010): 1537–40. http://dx.doi.org/10.14778/1920841.1921032.

Повний текст джерела
Стилі APA, Harvard, Vancouver, ISO та ін.
9

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.

Повний текст джерела
Стилі APA, Harvard, Vancouver, ISO та ін.
10

ŽOUŽELKOVÁ, Iveta. "MICROSOFT SQL SERVER 2008 - BUSINESS INTELLIGENCE DEVELOPMENT AND MAINTENANCE TRAINING KIT." Journal of Technology and Information 4, no. 1 (April 1, 2012): 81–82. http://dx.doi.org/10.5507/jtie.2012.015.

Повний текст джерела
Стилі APA, Harvard, Vancouver, ISO та ін.
11

Nguyen, An Bao, Lam Nhut Nguyen, and Vi Thi Thuy Ha. "APPLIED DATA WAREHOUSE AND DATA VISUALIZATION IN AQUACULTURE DATA MANAGEMENT IN TRA VINH PROVINCE." Scientific Journal of Tra Vinh University 1, no. 28 (December 1, 2017): 64–73. http://dx.doi.org/10.35382/18594816.1.28.2017.47.

Повний текст джерела
Анотація:
This paper introduces an information system developed to maintain data management and reporting on aquaculture in Tra Vinh province. A data warehouse was also built for data analysis and visualization in order to produce general reports and charts that help the managers in decision making. The proposed system was built using .NET technology, Microsoft SQL Server 2014 DBMS, Microsoft SQL Analysis Services and OLAP features of Microsoft Excel 2013
Стилі APA, Harvard, Vancouver, ISO та ін.
12

Hodun, Dominika, and Maria Skublewska-Paszkowska. "OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES." Informatics Control Measurement in Economy and Environment Protection 7, no. 3 (September 30, 2017): 29–32. http://dx.doi.org/10.5604/01.3001.0010.5210.

Повний текст джерела
Анотація:
The article presents a discussion of the optimisation methods involving the modification of query syntax on the example of the use of indexes that served for the application of the methods in practice, and the presentation and analysis of the test results and their comparison. All the queries were made in a Microsoft SQL Server Management Studio 2014 environment, using the AdventureWorksDW2012 test database provided by Microsoft. The object of the research were SELECT queries, which consequently returned the desired set of output data.
Стилі APA, Harvard, Vancouver, ISO та ін.
13

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.

Повний текст джерела
Анотація:
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 та ін.
14

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.

Повний текст джерела
Анотація:
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 та ін.
15

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.

Повний текст джерела
Анотація:
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 та ін.
16

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.

Повний текст джерела
Стилі APA, Harvard, Vancouver, ISO та ін.
17

Chen, Zhimin, Vivek Narasayya, and Surajit Chaudhuri. "Fast foreign-key detection in Microsoft SQL server PowerPivot for Excel." Proceedings of the VLDB Endowment 7, no. 13 (August 2014): 1417–28. http://dx.doi.org/10.14778/2733004.2733014.

Повний текст джерела
Стилі APA, Harvard, Vancouver, ISO та ін.
18

Agrawal, Sanjay, Surajit Chaudhuri, and Vivek Narasayya. "Materialized view and index selection tool for Microsoft SQL server 2000." ACM SIGMOD Record 30, no. 2 (June 2001): 608. http://dx.doi.org/10.1145/376284.375769.

Повний текст джерела
Стилі APA, Harvard, Vancouver, ISO та ін.
19

Li, Zhi Zhong, Shi Chun Yang, and Zi Tao Liu. "Development of Electric Vehicle Remote Monitoring System's Server and Client Application." Applied Mechanics and Materials 535 (February 2014): 26–31. http://dx.doi.org/10.4028/www.scientific.net/amm.535.26.

Повний текст джерела
Анотація:
This paper analyzed the practical needs of remote monitoring of electric vehicle and illustrates the overall architecture of a remote monitoring system, and further developed a remote monitoring system of the Server and client application with the ASP.NET and Microsoft SQL Server database language, basically can meet the electric cars remote monitoring of the Server and client needs.
Стилі APA, Harvard, Vancouver, ISO та ін.
20

Tambunan, Leonard, and Karolina Talia Sela. "PERANCANGAN SISTEM INFORMASI PENDATAAN PEMAKAIAN BAHAN BAKAR KENDARAAN PADA PT.DAHEPA DAMAI PRATAMA DENGAN MENGGUNAKAN BAHASA PEMROGRAMAN VISUAL BASIC.NET DAN DATABASE SQL SERVER." JSR : Jaringan Sistem Informasi Robotik 2, no. 2 (December 3, 2018): 130–36. http://dx.doi.org/10.58486/jsr.v2i2.38.

Повний текст джерела
Анотація:
PT. Dahepa Damai Pratama is a company who working construction engineering & transportation services. In the process of processing Data collection of vehicles Fuel Consumption is still using Microsoft Excel applications, Microsoft Word in terms of recording or inputting data so it takes a long time in performing their duties and responsibilities respectively This research carry out to develop data processing Data collection of vehicles Fuel Consumption system and make it easier. PT. Dahepa Damai Pratama need a new data processing information system by utilizing the computer system who support the application system Visual Basic and SQL Server. With this Visual Basic programming and SQL Server Database in Data collection of vehicles Fuel Consumption can help to entry data and reported
Стилі APA, Harvard, Vancouver, ISO та ін.
21

Góźdź, Rafał, and Maria Skublewska-Paszkowska. "Analiza możliwości zarządzania bazą danych przechowywaną w chmurze." Journal of Computer Sciences Institute 2 (December 30, 2016): 127–32. http://dx.doi.org/10.35784/jcsi.128.

Повний текст джерела
Анотація:
W artykule przedstawiono porównawczą analizę wydajnościową wybranych systemów baz danych. Porównano czasy wykonania zapytań SQL przez przygotowane bazy danych działające w usłudze chmurowej. Przygotowana baza danych Northwind działająca na SQL Server została przeniesiona na systemy Oracle i PostgreSQL, a następnie trzy wymienione bazy zostały umieszczone w chmurze Microsoft Azure. Proces badawczy został podzielony na trzy etapy. W pierwszej kolejności analizie podlegają zapytania typu Select. W drugim etapie analiza skupia się na kwestii wydajności zapytań SQL DDL, a końcowy etap opisuje analizę zapytań SQL DML.
Стилі APA, Harvard, Vancouver, ISO та ін.
22

Billy Sabella, Heldalina Heldalina, Karima Zam Zam, and Veri Julianto. "PROGRAM APLIKASI PENGELOLAAN KAS MENGGUNAKAN MICROSOFT VISUAL BASIC 2015 PADA MASJID AL JIHAD BANJARMASIN." TEKNIMEDIA: Teknologi Informasi dan Multimedia 2, no. 2 (January 3, 2022): 76–82. http://dx.doi.org/10.46764/teknimedia.v2i2.46.

Повний текст джерела
Анотація:
Research purposes. This study aims to determine the proper cash management at Al Jihad Mosque, and to produce a computer-based Cash Management Application Program using Microsoft Visual Basic 2015 as the Front End, and Sql Server 2014 as a back end at the Al Jihad Mosque in Banjarmasin. Theoretical thinking framework. In this study the theoretical framework is analyzing the cash management that runs on the Al Jihad Mosque in Banjarmasin, by analyzing the information needed by management, related functions, accounting documents and records used, and flowcharts. The application program that was developed in the first step was carried out with relations between tables, designing interfaces, and designing outputs. Research result. The results of this study concluded that all cash records are semi-computerized. However, the author recommends using Microsoft Visual Basic 2015 as a Front End, and Sql Server 2014 as a back end so that it can help Al Jihad Mosque to record cash receipts and disbursements quickly and precisely.
Стилі APA, Harvard, Vancouver, ISO та ін.
23

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.

Повний текст джерела
Анотація:
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 та ін.
24

Chavali, LN, Lal Hmingliana, Brindha Senthil Kumar, and P. Lakshmi Narayana. "An Approach to Fine Tuning Database Performance in Application Software." Science & Technology Journal 9, no. 1 (January 1, 2021): 10–13. http://dx.doi.org/10.22232/stj.2021.09.01.02.

Повний текст джерела
Анотація:
Database tuning is crucial step to enhance the performance of the application software. There are many tools available in Microsoft to evaluate the performance of the stored procedures and identify them. This paper presents a comparative performance of actual and tuned sample stored procedures in SQL Server 2008 R2 of Application software (Microsoft). The results showed there is a marginal gain in the efficiency after the database tuning.
Стилі APA, Harvard, Vancouver, ISO та ін.
25

Jayinudin, J. "Perancangan Sistem Informasi Akuntansi Pajak Bumi Dan Bangunan (PBB) Pada Kantor Kecamatan Cileunyi Bandung Dengan Menggunakan Microsoft Visual Basic 6.0 Dan Microsoft SQL Server 2000 Berbasis Client Server." is The Best [Accounting Information System & Information Technology Business Enterprise] 2, no. 2 (December 23, 2017): 288–300. http://dx.doi.org/10.34010/aisthebest.v2i2.1825.

Повний текст джерела
Анотація:
Conditions that occur in the calculation of land tax and building in the Cileunyi District Office already using is based on Law No. 12 of 1994, but in performing procedures tax such as making tax monthly and annual reports are still using Microsoft Office Excel 2007. To the problems, then writer take the title: "Perancangan Sistem Informasi Akuntansi Pajak Bumi dan Bangunan (PBB) Pada Kantor Kecamatan Cileunyi Bandung Dengan Menggunakan Microsoft Visual Basic 6.0 Dan Microsoft SQL Server 2000 Berbasis Client Server". The research used is basic research, the data used is qualitative data and quantitative data, the type of research design used is research design with primary data and secondary data, method of research used is exploratory research and descriptive, data collection techniques used is research field that consists of an interview and observation and research library.
Стилі APA, Harvard, Vancouver, ISO та ін.
26

Yao, Shuang Liang, and Shuang Tong Wang. "The Research of the Second Class Credit in the Credit System." Advanced Materials Research 989-994 (July 2014): 5209–12. http://dx.doi.org/10.4028/www.scientific.net/amr.989-994.5209.

Повний текст джерела
Анотація:
In order to solve the problem of the second class credit reporting in manual states, we use the system flow diagrams and case diagrams to analysis the needs of users, and use ER diagrams to introduce the SQL database。This article designs the system of the second class credit reporting based on the campus network. The system uses C # as the development language, SQL Server database as a background and Microsoft Visual Studio 2010 as the development environment, with high security and stability.
Стилі APA, Harvard, Vancouver, ISO та ін.
27

Widjiyati, Nur. "Penerapan Algoritma Greedy pada Query RDBMS Microsoft SQL Server sebagai Sistem Rekomendasi Pembelian Makanan Pokok." Smart Comp: Jurnalnya Orang Pintar Komputer 11, no. 2 (April 20, 2022): 124–30. http://dx.doi.org/10.30591/smartcomp.v11i2.3507.

Повний текст джерела
Анотація:
Makanan pokok atau sembako adalah salah satu kebutuhan utama masyarakat Indonesia, yang mana pada sembako meliputi barang sehari – hari yang digunakan masyarakat Indonesia, contohnya : beras, gila pasir, garam dan lain – lain. Dewasa kini, telah banyak terdapat transaksi berbasis layanan dalam bentuk sistem informasi berplatform website atau mobile yang menawarkan barang – barang sembako secara online. Bermacam – macamnya daya beli masyarakat dan frekuensi pembeliannya membuat pengusaha ecommerce sembako tersebut harus dapat mencari celah agar layanan platform ecommercenya tetap terus dipergunakan, salah satunya dengan memberikan sistem rekomendasi bagi user pengguna untuk membeli barang sembako berdasarkan budget yang dimiliki. Algoritma Greedy merupakan salah satu algoritma optimasi yang sangat popular, selain karena tergolong jenis algoritma optimasi sederhana, juga kemampuan explainablenya yang tinggi, membuat algoritma ini sangat mudah untuk diterapkan, dipahami bahkan hingga dimodifikasi. Penulis menggunakan model algoritma Greedy by Weight dimana diterapkan ke dalam bahasa query SQL di Ms SQL Server sebagai tool testbed simulasinya. Hasil penerapannya algoritma Greedy mampu membuat sejumlah set solusi rekomendasi sembako berdasarkan budget yang diinputkan oleh user pengguna
Стилі APA, Harvard, Vancouver, ISO та ін.
28

Chen, Yao Fei. "Research of SQL Server Automatic Marking Based on Logical Formal." Advanced Materials Research 328-330 (September 2011): 2376–79. http://dx.doi.org/10.4028/www.scientific.net/amr.328-330.2376.

Повний текст джерела
Анотація:
The author proposes a scheme of SQL Server Automatic Marking based on logical formal. The scheme consists of three parts: generating paper, skill assessment and automatic marking. Describe the question's Marking information by using the logical formal method. Achieve automatic Marking by building the logical formal system. Focus on three components of the scheme: logical formal description, get information of database based on ADOX(Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security) and automatic marking of three database operations:Creat,Modify and Delete. Describes the whole process of logical formal Marking with example. Analysis the assessment effect of the results about the example. Analysis between manual and automatic Marking shows that: logical Formal automatic Marking is better than the average artificial error and close to the minimum artificial error.
Стилі APA, Harvard, Vancouver, ISO та ін.
29

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.

Повний текст джерела
Анотація:
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 та ін.
30

Rymarski, Piotr, and Grzegorz Kozieł. "Analysis of the possibilities of optimizing SQL queries." Journal of Computer Sciences Institute 19 (June 30, 2021): 151–58. http://dx.doi.org/10.35784/jcsi.2641.

Повний текст джерела
Анотація:
Most of today's web applications run on relational database systems. Communication with them is possible through statements written in Structured Query Language (SQL). This paper presents the most popular relational database management systems and describes common ways to optimize SQL queries. Using the research environment based on fragment of the imdb.com database, implementing OracleDb, MySQL, Microsoft SQL Server and PostgreSQL engines, a number of test scenarios were performed. The aim was to check the performance changes of SQL queries resulting from syntax modication while maintaining the result, the impact of database organization, indexing and advanced mechanisms aimed at increasing the eciency of operations performed, delivered in the systems used. The tests were carried out using a proprietary application written in Java using the Hibernate framework.
Стилі APA, Harvard, Vancouver, ISO та ін.
31

Xue, Fei, and Xiao Feng Zhang. "Research on Machining Knowledge Base for Numerical Control System." Applied Mechanics and Materials 271-272 (December 2012): 1628–31. http://dx.doi.org/10.4028/www.scientific.net/amm.271-272.1628.

Повний текст джерела
Анотація:
According to the rapid and efficient requirement of numerical control machining process, a machining knowledge base is developed by building the parameterized models based on the Pro/Engineering three-dimensional design software, using the Visual C++. NET and Microsoft SQL Server software as knowledge base background server. Because of the renewable, large capacity, and three-dimensional model characteristics, the machining knowledge base has the ability of reducing tool stock and preserving optimized parameters, which greatly increase productivity and decrease manufacturing costs.
Стилі APA, Harvard, Vancouver, ISO та ін.
32

Rubhiyati, Rini, and Retno Lestianawati. "SISTEM INFORMASI PENGELOLAAN PERSEDIAAN BAHAN BAKU BERBASIS CLIENT SERVER PADA CV. ALINEA JAVA SEMARANG." JURNAL TEKNOLOGI INFORMASI DAN KOMUNIKASI 9, no. 1 (March 6, 2018): 11–18. http://dx.doi.org/10.51903/jtikp.v9i1.163.

Повний текст джерела
Анотація:
Abstract The management of raw material inventory is a very important part for a company. In the process of inventory management of raw materials conducted on CV.Alinea Java until now still using conventional system using Microsoft Excel 2007, starting from material estimation, ordering process of goods to supplier, process of receipt and expenditure of raw materials, raw material returns, addressed to the leadership and related sections. And the utilization of wireless networks that are less effective because only connected computer warehouse administration and purchasing, not all users, to overcome the above problems, it is necessary information that utilizes the inventory management information system raw materials with computer network based client server using a new system of mutual terintregrasi all users so that all interested parties can access the desired data of course with certain restrictions, according to the status entered. Then created a system of inventory management information raw materials server client base on CV.Alinea Java by using Microsoft Visual Basic 6.0 and Microsoft SQL Server 2000 database that will assist in the process of data processing system.
Стилі APA, Harvard, Vancouver, ISO та ін.
33

Jankauskas, Robertas, and Dmitrij Šešok. "Duomenų migravimo iš OLTP į OLAP duomenų bazę greitaveikos tyrimas." Jaunųjų mokslininkų darbai 47, no. 2 (December 8, 2017): 42–49. http://dx.doi.org/10.21277/jmd.v47i2.136.

Повний текст джерела
Анотація:
Duomenų sinchronizacija tarp kelių sistemų yra vienas iš dažniausiai pasitaikančių procesų. Iš esamų duomenų norima atlikti analizę, kuria naudojantis būtų galima priimti tam tikrus sprendimus, padėsiančius pateikti išvadas apie organizacijų veiklas. Šiame darbe analizuojamas duomenų migravimo procesas tarp „Oracle“ ir „Microsoft SQL Server“ duomenų bazių valdymo sistemų naudojantis skirtingomis duomenų įkėlimo metodologijomis ir sistemų teikiamomis technologijomis.
Стилі APA, Harvard, Vancouver, ISO та ін.
34

Стецюк, В. З., А. М. Чиж, Л. Ю. Бабінцева, М. В. Чиж та І. П. Муха. "СИСТЕМА ДЛЯ ОБЛІКУ ДОНОРСЬКОЇ КРОВІ ТА ЇЇ КОМПОНЕНТІВ". Medical Informatics and Engineering, № 4 (4 червня 2020): 62–64. http://dx.doi.org/10.11603/mie.1996-1960.2019.4.11020.

Повний текст джерела
Анотація:
Представлено основні компоненти комп'ютерного десктопного програмного забезпечення для оптимізації процесу обліку та автоматизації статистичного аналізу руху донорської крові та її компонентів на станції переливання крові. Об'єктом дослідження стала база даних електронної медичної облікової документації Черкаської обласної станції переливання крові, способи оброблення інформації, спрямовані на отримання оперативної та періодичної статистичної звітності з використанням основних елементів архітектури Microsoft SQL Server.
Стилі APA, Harvard, Vancouver, ISO та ін.
35

Sutama, Tata. "SISTEM INFORMASI PEGAWAI BERBASIS WEB PADA KANTOR CAMAT GAUNG ANAK SERKA." JURNAL PERANGKAT LUNAK 3, no. 1 (February 21, 2021): 16–21. http://dx.doi.org/10.32520/jupel.v3i1.1619.

Повний текст джерела
Анотація:
Kantor Camat Gaung Anak Serrka memiliki 27 orang pegawai Pns dan 9 orang pegawai honorer. Pengolahan data pegawai pada Kantor Camat Gaung Anak Serka masih menggunakan microsoft word dan excel yang masih kurang efisien dalam pengolahan data pegawai di mana proses penyimpanan data pegawai masih mengguanakn arsip yang mempersulit dalam proses pencarian data dan pengolahan data pegawai. Maka penulis memutuskan untuk membuat suatu Sistem informasi dengan judul: “Sistem Informasi Pegawai Pada Kantor Camat Gaung Anak Serka Berbasis web. Perancangan sistem informasi pegawai ini akan dirancang menggunakan Macro Media Dremweaver dan Microsoft SQL Server .
Стилі APA, Harvard, Vancouver, ISO та ін.
36

Wang, Cai Xia. "Building the Platform of Teacher Professional Development in Vocational College to Convert Tacit Knowledge." Applied Mechanics and Materials 380-384 (August 2013): 2906–10. http://dx.doi.org/10.4028/www.scientific.net/amm.380-384.2906.

Повний текст джерела
Анотація:
Due to the particularity of vocational education, vocational colleges teacher had a lot of tacit knowledge in skill, which was very difficult to be coded, summed and expressed. The platform was built to promote the conversion of tacit knowledge and improve teacher professional development by some tools and technology. The structure of the platform used B/S mode, and there were some functional modules which were Resource Database, Teacher Studio, Teaching Activities Room and Watching the Video Room. The platform had been developed by Microsoft Visual Studio 2010, C#. Net and Microsoft SQL Server 2008.
Стилі APA, Harvard, Vancouver, ISO та ін.
37

Li, Xiu Ying. "Design and Implementation of the .NET-Based Online Learning System." Applied Mechanics and Materials 427-429 (September 2013): 2874–77. http://dx.doi.org/10.4028/www.scientific.net/amm.427-429.2874.

Повний текст джерела
Анотація:
Using the internet to provide learning exchange services for students has become a need now. This paper introduces the frame structure and the main functions of each module of the campus online learning system with a three-layered B/S structure based on .NET and Microsoft SQL Server 2000, and lays stress on implementing the course management and courseware management of the system.
Стилі APA, Harvard, Vancouver, ISO та ін.
38

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.

Повний текст джерела
Анотація:
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 та ін.
39

Purfini, Apriani Puti, Nuri Nurjannah, and Dony Waluya Firdaus. "Design of Accounting Information System Raw Material Inventory At PT Warung Pasta With Software Microsoft Visual Basic 6.0 And SQL Server 2000 Bases Of Client Server." is The Best Accounting Information Systems and Information Technology Business Enterprise this is link for OJS us 1, no. 2 (December 29, 2012): 186–203. http://dx.doi.org/10.34010/aisthebest.v1i2.1810.

Повний текст джерела
Анотація:
PT Warung Pasta located at Ganesha No. 04 Bandung, Phone. 022-2500416 is a manufacturing company moving on the culinary area. At the time of implementing the accounting records and updating the inventory of raw material to the company's use Microsoft Office Excel software. These problems result in ineffective and optimal performance of all divions of the company contained in the provider of information and reports required. From the matter above, the writer take the title "Design of Accounting information System Raw Material Inventory at PT warung Pasta with Software Microsoft Visual Basic 6.0 and MySQL Server 2000 Bases of Client Server".
Стилі APA, Harvard, Vancouver, ISO та ін.
40

Guan, Da Shu, Yu Qi Li, Zhi Xing Huang, and Shuai Dong Yang. "The early Warning System of Embankment Slope Deformation Based on IBIS-L." Applied Mechanics and Materials 556-562 (May 2014): 3148–51. http://dx.doi.org/10.4028/www.scientific.net/amm.556-562.3148.

Повний текст джерела
Анотація:
This paper introduces IBIS-L (Image by Interferometric Survey-L) and its application on early warning system of embankment slope deformation. Visual Basic programming language and Microsoft SQL Server are used to develop the software of early warning system of embankment slope’s deformation, which can build the model to predict and early warn of the deformation of embankment slope with considering the parameters obtained both by IBIS-L and routine monitoring.
Стилі APA, Harvard, Vancouver, ISO та ін.
41

Nguyen, Thi Ngoc Thanh. "Concurrency Control in Database Management System." European Journal of Electrical Engineering and Computer Science 5, no. 4 (August 21, 2021): 76–79. http://dx.doi.org/10.24018/ejece.2021.5.4.352.

Повний текст джерела
Анотація:
Nowadays, most application software systems are aimed at multi-user environments and simultaneous access to the same database. Therefore, concurrency controllers are an integral part of any database management system. The concurrency controller plays an important role in controlling transactions which perform simultaneous access to the database without conflict. This paper presents an overview and illustration how to use concurrency control in database management system of Microsoft SQL Server.
Стилі APA, Harvard, Vancouver, ISO та ін.
42

Стецюк, В. З., Л. Ю. Бабінцева, Т. П. Іванова, Г. М. Федушка, Ю. М. Чиж та І. П. Муха. "СИСТЕМА ОБЛІКУ ТА СТАТИСТИЧНОГО АНАЛІЗУ ДАНИХ ПРО ПАЦІЄНТІВ ІЗ ДІАГНОЗОМ ЕПІЛЕПСІЯ". Medical Informatics and Engineering, № 1 (22 червня 2020): 66–70. http://dx.doi.org/10.11603/mie.1996-1960.2020.1.11130.

Повний текст джерела
Анотація:
Представлено опис основні компоненти комп'ютерного десктопного програмного забезпечення для автоматизації ведення обліку пацієнтів і статистичної періодичної звітності «Облік даних про пацієнтів із діагнозом епілепсія». Об'єктом дослідження стала база даних електронної медичної облікової документації відділення неврології НДСЛ «ОХМАТДИТ», способи оброблення інформації, спрямовані на отримання оперативної та періодичної статистичної звітності з використанням основних елементів архітектури Microsoft SQL Server. Програмне забезпечення розроблено для оптимізації процесу реєстрації пацієнтів із діагнозом епілепсія у відділені дитячої неврології.
Стилі APA, Harvard, Vancouver, ISO та ін.
43

Dziewit, Grzegorz, Jakub Korczyński, and Maria Skublewska-Paszkowska. "Performance analysis of relational databases Oracle and MS SQL based on desktop application." Journal of Computer Sciences Institute 8 (November 30, 2018): 263–69. http://dx.doi.org/10.35784/jcsi.693.

Повний текст джерела
Анотація:
Comparison of efficiency is not a trivial phenomenon because of disparities between different database systems. This paper presents a methodology of comparing relational database systems in respect of mean time of execution individual DML queries containing subqueries and conjunction of tables. The presented methodology can be additionally accommodated to studies of efficiency in a range of database system itself (study of queries executed directly in database engine). The described methodology allows to receive statement telling which database system is better in comparison to another in dependency of functionalities fulfilled by external application. In the article the analysis of mean time of execution individual DML queries was performed.Two research hypotheses have been put forward: "Microsoft SQL Server database system needs less time to execute INSERT and UPDATE queries than Oracle database" and "Oracle database system needs less time to execute DML queries with binary data than SQL Server"
Стилі APA, Harvard, Vancouver, ISO та ін.
44

Isman, Reza Kamaluddin, Desi Dyah Sulistyarini, and Prihatin Oktivasari. "RANCANG BANGUN APLIKASI BARANG JASA MENGGUNAKAN C#, WPF, DAN SQL SERVER 2012." Jurnal Teknologi Informasi dan Terapan 4, no. 1 (March 13, 2019): 53–60. http://dx.doi.org/10.25047/jtit.v4i1.22.

Повний текст джерела
Анотація:
Barang Jasa is an application that used for Divisi Pengadaan Barang dan Jasa. Barang Jasa serves to record every purchase of goods and services used to meet the needs of both fleet and crew in the long term. Barang Jasa also serves to make the Nota Dinas to be processed by Divisi Keuangan on the purchase of goods and services that have been performed. This application was created by using Windows Presentation Foundation (WPF), which is a Microsoft technology to create desktop applications. This application was made using the method protoyping development,C# as a programming language, WPF as a interface design technology, and SQL Server 2012 as the database. WPF can present the appearance that can be tailored to user needs. This study discusses the interface, backend applications, and database design. After testing the flexibility of the interface on the screen with a resolution of 1366 x 768, 1024 x 768 and 1280 x 720, proves that WPF can adjust the screen resolution being tested. The test results showed that the backend of Barang Jasa application are functioning properly, the test is done using sql query by entering the required parameters, for example username and password to log in and match the query returns results with what is displayed by the application.
Стилі APA, Harvard, Vancouver, ISO та ін.
45

Grudzień, Mateusz, Konrad Korgol, and Dariusz Gutek. "Porównanie możliwości wykorzystania oraz analiza wydajności baz danych na systemach mobilnych." Journal of Computer Sciences Institute 2 (December 30, 2016): 133–39. http://dx.doi.org/10.35784/jcsi.129.

Повний текст джерела
Анотація:
Artykuł przedstawia wybrane formy składowania danych tj. Local Storage, Shared Preferences, pliki płaskie oraz SQLite w kontekście dwóch systemów mobilnych – Android oraz Windows Mobile. Opisuje on również sposoby, poprzez które możliwe jest połączenie z zewnętrznymi systemami bazodanowymi takimi jak Microsoft SQL Server, PostgreSQL czy MySQL i stara się odpowiedzieć na pytanie, użycie której z tych opcji ma największy sens w poszczególnych przypadkach. Całość argumentuje badaniami wydajności, którym poddane zostały wszystkie z wymienionych opcji.
Стилі APA, Harvard, Vancouver, ISO та ін.
46

Lu, Xiao Hong, Wen Yi Wu, Peng Zhuo Han, Guang Jun Li, and Jie Wei. "Study on Master Production Schedule in Manufacturing System for Medium and Small Manufacture Enterprises." Applied Mechanics and Materials 252 (December 2012): 349–53. http://dx.doi.org/10.4028/www.scientific.net/amm.252.349.

Повний текст джерела
Анотація:
According to the existing problems in production planning management mode and management processes of Chinese medium and small manufacture enterprise, referring to the advanced management concept of MRPII/ERP, a master production schedule system which is suitable for management state of Chinese medium and small manufacture enterprise is researched and developed. The operation process, data flow and ER model of the master production schedule system are discussed and researched. Finally, Microsoft vb.net is selected as the development tool of the master production schedule system and Microsoft SQL Server 2000 is used as the database management system, a master production schedule prototype system is designed and implemented.
Стилі APA, Harvard, Vancouver, ISO та ін.
47

N. Gedam, Madhuri, and B. B. Meshram. "Database Private Security Jurisprudence: A Case Study using Oracle." International Journal of Database Management Systems 13, no. 03 (June 30, 2021): 01–21. http://dx.doi.org/10.5121/ijdms.2021.13301.

Повний текст джерела
Анотація:
Oracle is one of the largest vendors and the best DBMS solution of Object Relational DBMS in the IT world. Oracle Database is one of the three market-leading database technologies, along with Microsoft SQL Server's Database and IBM's DB2. Hence in this paper, we have tried to answer the million-dollar question “What is user’s responsibility to harden the oracle database for its security?” This paper gives practical guidelines for hardening the oracle database, so that attacker will be prevented to get access into the database. The practical lookout for protecting TNS, Accessing Remote Server and Prevention, Accessing Files on Remote Server, Fetching Environment Variables, Privileges and Authorizations, Access Control, writing security policy, Database Encryption, Oracle Data Mask, Standard built in Auditing and Fine Grained Auditing (FGA) is illustrated with SQL syntax and executed with suitable real life examples and its output is tested and verified. This structured method acts as Data Invictus wall for the attacker and protect user’s database.
Стилі APA, Harvard, Vancouver, ISO та ін.
48

Mustafayev, V. A., I. S. Zeynalabdiyeva, and O. Ja Kravets. "Control model of parallel functioning production modules as fuzzy Petri nets." Journal of Physics: Conference Series 2094, no. 2 (November 1, 2021): 022003. http://dx.doi.org/10.1088/1742-6596/2094/2/022003.

Повний текст джерела
Анотація:
Abstract The article presents the results of research of Data Mining methods with Microsoft SQL Server. Microsoft Clustering algorithm was used for improving the effectiveness of medical prevention and treatment in a cohort of patients with arterial hypertension. There are rationales for monitoring of cardiovascular risk and desire to correct the risk with Data Mining at medical decision support systems. Authors used medical and sociological monitoring data from regional clinical hospital. The segmentation of arterial hypertension patients was performed using Microsoft Clustering algorithm. As a result, a quantitative assessment of the population profile for patients with arterial hypertension was obtained. The authors presented diagrams and profiles of clusters. They were compared. The developed approach is applied for decision support at regional health information management system for reduce of cardiovascular risk.
Стилі APA, Harvard, Vancouver, ISO та ін.
49

Rapakov, G. G., A. A. Sukonshchikov, A. N. Shvetsov, V. A. Gorbunov, and O. Ja Kravets. "Applied aspects of data mining for decision support at the regional health system." Journal of Physics: Conference Series 2094, no. 3 (November 1, 2021): 032006. http://dx.doi.org/10.1088/1742-6596/2094/3/032006.

Повний текст джерела
Анотація:
Abstract The article presents the results of research of Data Mining methods with Microsoft SQL Server. Microsoft Clustering algorithm was used for improving the effectiveness of medical prevention and treatment in a cohort of patients with arterial hypertension. There are rationales for monitoring of cardiovascular risk and desire to correct the risk with Data Mining at medical decision support systems. Authors used medical and sociological monitoring data from regional clinical hospital. The segmentation of arterial hypertension patients was performed using Microsoft Clustering algorithm. As a result, a quantitative assessment of the population profile for patients with arterial hypertension was obtained. The authors presented diagrams and profiles of clusters. They were compared. The developed approach is applied for decision support at regional health information management system for reduce of cardiovascular risk.
Стилі APA, Harvard, Vancouver, ISO та ін.
50

Li, Ping. "Operating Mechanism of Teaching Quality Information System." Applied Mechanics and Materials 496-500 (January 2014): 2220–23. http://dx.doi.org/10.4028/www.scientific.net/amm.496-500.2220.

Повний текст джерела
Анотація:
Teaching quality information management system is an important part. In this paper, according the characteristics of Jiujiang University's teaching management, the design purpose and design idea of campus management information system are introduced. taking the way of combination of C/S and B/S structure, using a modular design method for systems design and development,choosing SQL Server of the Microsoft company as a database management system, the teaching quality information management system is designed and implated.
Стилі APA, Harvard, Vancouver, ISO та ін.
Ми пропонуємо знижки на всі преміум-плани для авторів, чиї праці увійшли до тематичних добірок літератури. Зв'яжіться з нами, щоб отримати унікальний промокод!

До бібліографії