China
Africa
Explore chapters and articles related to this topic
Software Technology for A/V Systems
Published in Al Kovalick, Video Systems in an IT Environment, 2013
The granddaddy of the database query is SQL. This is a language for accessing databases and doing adds/deletes and queries of the contents. By itself, SQL does not define how to connect to a database. Over the years several mature protocols have evolved to connect clients to databases. Highlighting the most significant, the following are in daily use: ODBC (Open Database Connectivity). This is an open standard defining how clients can connect to vendor-neutral databases. Microsoft defined it, but now it is an international standard and is used universally. Under the hood, ODBC uses SQL for operations on the database. Also, clients do not need to know where the database is located on a network or what brand of database is accessed. Of course, ODBC allows users to access vendor-specific features if needed.ADO.NET (ActiveX Data Objects). This is the cornerstone of Microsoft’s .NET framework for database access. This is an ODBC-compliant API that exposes the features of modern databases to client applications. It was designed for the .NET programming environment.JDBC (Java Database Connectivity). This provides database access to programs written in Java and JavaScript. It uses ODBC as the core of connectivity.
An Integrated Model-Based Bridge Management System
Published in Nigel Powers, Dan M. Frangopol, Riadh Al-Mahaidi, Colin Caprani, Maintenance, Safety, Risk, Management and Life-Cycle Performance of Bridges, 2018
Java database connectivity (JDBC) is a programming framework for Java developers writing programs that access information stored in databases. The system connects with MySQL to present bridge information of the name, type, location, properties, components and other data in specific functions. MangoDB system is designed to store the sensor data in corresponding tables (Hammad et al. 2006). Android application is developed in Java software platform for the inspection, the data captured on mobile phones could be stored in the MySQL database mentioned above.
Fundamentals of Database Technology and Database-Driven Web Applications
Published in Barney L. Capehart, Timothy Middelkoop, Paul J. Allen, David C. Green, Handbook of Web Based Energy Information and Control Systems, 2020
JDBC architecture contains a driver manager and database-specific drivers to provide transparent connectivity to databases from different vendors. This is shown in Figure 15-6. A JDBC driver translates standard JDBC calls into a protocol that the underlying database can understand. This translation function makes JDBC applications able to access many different databases. There are four distinct types of JDBC drivers. Details about the four drivers and their mechanisms are beyond this chapter but can be found in reference 5.
Application of Human-Computer Interaction Technology in Remote Language Learning Platform
Published in International Journal of Human–Computer Interaction, 2023
On the basis of the above architecture design, the interactive technology of the language learning system is analyzed and designed. In the implementation of system interaction function, the user can input data through the browser, and the browser can also use the graphical interface to present the data processing results to the user; The control function of presentation layer is implemented by SpringMVC(SpringWebMVC) as the controller of the framework, and uses (JavaServerPages, dynamic web page technology) technology to generate the view of data processing results. The business logic layer is used to realize all the functions of the system. The persistence layer uses Hibernate (open source object relational mapping framework) framework and Spring JDBC (Spring Java Database Connectivity Standard) to realize the interaction between business logic layer and data layer, as shown in Figure 5:
Research on procedure optimisation for composite grinding based on Digital Twin technology
Published in International Journal of Production Research, 2023
Nanyan Shen, Yang Wu, Jing Li, Tianqiang He, Yushun Lu, Yingjie Xu
The implement of data communication between the NC system and the DT system is shown in Figure 3. The required data of the DT system are collected from the variables and parameters of the open NC system through OPC UA protocol, integrated and stored locally in a well-designed database. It is worth mentioning that the DITTEL online monitoring system based on AE sensor is installed on the composite grinding centre for monitoring the status of grinding and grinding wheel as shown in Figure 4, and it updates RMS value of AE signal into programmable logic controller (PLC) variable of the NC system in real time through Profibus protocol. The DT system communicates with the database as a client to complete data access. In the consideration of communication security, the message middleware is also developed to add, delete, modify, and query data through Java Database Connectivity (JDBC). Besides, the two-way communication between the DT system and the message middleware is realised based on WebSocket protocol.
Interactive Media Information Security Immersive Experience System Based on Virtual Reality Technology
Published in IETE Journal of Research, 2021
J2EE's enterprise application-oriented architecture has been adopted by more than half of the world's top 500 companies. J2EE has many advantages of the standard version, such as “write once, run anywhere”, convenient access to the JDBC(database), API(Application Programming Interface), CORBA (Common Object Request Breaker Architecture) technology, and a security model that can protect data in Internet applications, etc., and also provides support for EJB, Java Servlet API(Application Programming Interface), Full support of JSP(java server page) and XML(Extensible Markup Language) technology [17,18]. J2ZZ uses a multi-layer distributed framework. In the development of actual enterprise applications, the application can usually be divided into a persistence layer, a business logic layer and a presentation layer. Each layer is independent. The following figure is a typical layered framework of J2ZZ [19].