Shulou(Shulou.com)06/01 Report--

This article mainly introduces "what is the application support of the operation database". In daily operation, I believe many people have doubts about what problems there are in the application support of the operation database. The editor has consulted various materials and sorted out simple and easy operation methods. I hope to help you answer the doubts about "what is the application support of the operation database"! Next, please follow the small series to learn together!

The Microsoft.Phoenix.Client nuget package provides you with a collection of compatible classes that you can use to develop. Net applications. You can use the C#client library to develop applications for Phoenix Query Server. The. Net application you developed uses the Avatica API and Google Protocol Buffer Serialization Format with the Phoenix Query Server interface.

Java2(J2EE) Support Java 2 Enterprise Edition and Eclipse plug-ins.

You can use Java client APIs to perform operations on Apache HBase tables. You can develop Java applications that can be used to create tables and insert data. The native Java client API provides programmatic access.

Language Support In addition to Java and C#, Operational Database allows you to build applications using a variety of programming languages. The following languages are supported:

· C

· C ++

· Groovy

· Python

· Scala

· Jython

· PHP

REST for API support

Open Database Connectivity (ODBC) support

You can access the operational database using the ODBC interface. ODBC drivers are out-of-the-box or available from third-party vendors. Java Database Connectivity (JDBC) Support You can access operational databases using the JDBC interface. Apache Phoenix in OpDB provides JDBC SQL endpoints to interact with data stored in Apache HBase. Apache Phoenix is super optimized for Apache HBase rather than optimized for various architectures (think Drill) and supports SQL ANSI-92 standards. You can create and interact with Apache HBase tables in the form of typical DDL / DML statements through its standard JDBC API. Apache Phoenix JDBC driver can be easily embedded into any application that supports JDBC. The JDBC interface is out of the box.

SQL extension user-defined functions (UDFs) for stored procedures can be used in SQL statements. UDFs can be used in queries just like built-in functions, such as select, insert up, delete, create function index. Temporary features are session/connection specific and cannot be accessed in other sessions/connections. Persistent function element information is stored in a system table named SYSTEM.FUNCTION. We are supporting tenant-specific features. Features created in tenant-specific connections are invisible to other tenant-specific connections. All connections are visible only for global tenant (no tenant) specific features. CDP data centers support hybrid solutions where compute tasks are separated from data storage and data can be accessed from remote clusters. Cloudera's Shared Data Experience (SDX) helps you have consistent data and metadata security and governance policies across all instances of your test application, saving you the time to reconfigure security and governance for each instance. When developing OpDB applications deployed on CDP data centers, you have the option to create your own application deployment lifecycle and deploy it on multiple instance types (test, phase, production). Test your application in a new version of CDP's data center and access the built-in metrics system from Cloudera Manager to see if everything is working as expected. A column family in Apache HBase may contain one or more columns. You must define the column series when you create the table, but you can add columns dynamically later. This feature of Apache HBase allows you to add a new column to a column family and change your application to start using the new column. Apache Phoenix for OpDB allows you to change the Schema of a table and gives you the flexibility to read schemas. This helps you take advantage of all the power of NoSQL and the flexibility of reading Schema. REST API Access You can interact with OpDB using Apache HBase REST Server. If you don't want to use Java APIs, this is a good option. Interact using URLs and REST APIs. REST uses HTTP to perform various operations, which makes it easy to interface with OpDB using multiple programming languages. You can create, delete tables, and perform other operations with REST endpoints using REST servers You can configure SSL to encrypt between clients and REST servers. This helps you ensure security during transmission. Using REST servers also allows data to be accessed across networks. For example, if your OpDB runs in a "private network" and you don't want to expose it to your company's "public network," a REST server can act as a "gateway" between the "private" and "public" networks. At this point, the study of "what is the application support of the operation database" is over, hoping to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.