China
Africa
Explore chapters and articles related to this topic
.NET, ActiveX, and COM
Published in Rick Bitter, Taqi Mohiuddin, Matt Nawrocki, LabVIEW™ Advanced Programming Techniques, 2017
Rick Bitter, Taqi Mohiuddin, Matt Nawrocki
Another alternative available is the SQL Toolkit, an add-on package that can be purchased to perform database operations on various commercial databases. The toolkit simplifies the process of creating databases, inserting data, and performing queries. The SQL Toolkit comes with drivers for many popular databases. It requires you to conFigure your ODBC (Open Database Connectivity) settings by specifying a data source. This DSN (Data Source Name) is then used as a reference or pointer to the database. The DSN is a user-defined name that represents the database that will be used. This user-defined name is used in the SQL Toolkit VIs to perform the necessary actions programmatically. The toolkit comes with several template VIs that can be customized to get you up and running quickly with a database.
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.
The System Components
Published in David Austerberry, Digital Asset Management, 2012
Originally, each database product required a different driver for the applications to perform operations on the data. Microsoft developed the language-independent open database connectivity (ODBC) interface that rationalized the database connections into a single standard. This was later joined by Java database connectivity (JDBC), which exposes a Java application program interface to the database drivers. These technologies have much simplified the connection between the business logic and the database. There are limitations to ODBC; it was designed to use SQL for access to relational databases. There are now many data sources that are not relational, mail systems, object databases, and file servers. There have been newer and more efficient components that can provide a more universal data access than ODBC.
The Role of 4D Historic Building Information Modelling and Management in the Analysis of Constructive Evolution and Decay Condition within the Refurbishment Process
Published in International Journal of Architectural Heritage, 2021
Silvana Bruno, Antonella Musicco, Fabio Fatiguso, Guido Raffaele Dell’Osso
Subsequently, each macrogroup has been matched to the categories of properties (‘External Database Links’ n.d.). These categories of properties can be manually added or automatically inserted linking external databases. The proposed information system connects the geometric HBIM model to external relational database, which were created as Excel spreadsheets or exported from the HBIM model, through the database management tools and compatible with the ODBC Driver of the employed multi-model-based management system. Indeed, Autodesk® Revit® permits the export of object parameters as external database via database management tools (i.e. the Ideate BIM link plug-ins (‘Ideate BIM Link Software’ n.d.), Revit DB link (‘Access Autodesk Revit DB Link’ n.d.), and the export tools embedded in the software.
Cracking the Achilles’ heel of energy performance contracting projects: the credit risk identification method for clients
Published in International Journal of Green Energy, 2020
Tiancheng Shang, Xiaotong Sun, Peihong Liu, Junqing Gao
Rosetta software was used to discretize the data according to the established discretization model. The attribute and decision values for the 120 companies in Utrain were entered into an Excel spreadsheet and acquired by the Rosetta software using an ODBC database. An algorithm combining Boolean logic and rough set theory was chosen to discretize the data, and the discretization results are simple and convenient. These results are shown in Tables 2 and 3. Based on the breakpoints and attribute assignments, new decision tables were created, but, due to limitations of this article, they are not provided here.
Logical object structure and system implementation for BIM database in civil infrastructures
Published in Architectural Engineering and Design Management, 2023
Under the same workload, we compare the performance between the logical object structure and the traditional relation model (see Section ‘Introduction’). We choose SQL Server 2022 to represent the BIM database developed using the traditional relation model. Load the workloads in Section ‘Workload selection’ to SQL Server through ODBC (Open Database Connectivity). Open the BIM database (take workload 2# as an example), and then enumerate the database state (See Figure 24).