5.1 Architecture FAQ

How do I interact with DataStax Enterprise (DSE)?

DSE’s architecture allows any authorized user to connect to any node in any datacenter and access data using the Cassandra Query Language (CQL 3.4 + DSE enhancements). For ease of use, CQL uses a similar syntax to SQL. The most basic way to interact with DSE is using the CQL create keyspaces and tables, insert and query tables, plus much more. Other ways to interact with DSE are:

  • DataStax Studio provides an IDE for syntax validation, type checking, validations specific to the domain, and content assistance for CQL and DSE Graph.

  • The DataStax Spark Cassandra Connector provides integration for Spark and access to the Spark shell. There is also SQL access with Spark’s ODBC/JDBC support.

  • For production, DataStax supplies a number of drivers in various programming languages, so that CQL statements can be passed from client to cluster and back. See DataStax drivers.

What is Apache Spark™ and how is DSE Analytics different?

Apache Spark is an open source analytics project that provides a fast and general engine for large-scale data processing. DataStax Enterprise integrates Apache Spark real-time and batch analytics processing to more easily manage both database and analytics with a single operational system.

What is Apache Solr™ and how is DSE Search different? Apache Solr is an open source search project that produces a highly reliable, scalable, and distributed search system that provides search for databases. DSE Search integrates Solr to manage search indexes with a persistent store. DSE Search provide enterprises with the ability to perform text search and text analysis.

How is DataStax Enterprise different from relational databases?

DSE is a distributed and highly available database that uses peer-to-peer communication. Data modeling in DataStax Enterprise is similar to relational databases while differing in key areas to provide blazingly fast interaction. Relational databases use joins between tables for relationships. DataStax Enterprise uses denormalization to achieve more robust querying.

What is NoSQL?

The NoSQL term originally referred to a new generation of databases that shunned SQL for other interfaces. The term NoSQL has recently become a catch-all term for post-relational "not-only SQL" databases that use a method of storage different from a relational, or SQL, database.

How do I move data to and from DataStax Enterprise?

See Migrating data to DataStax Enterprise. You can use the COPY command to read CSV data to DSE and write CSV data from DSE to a file system. The sstableloader provides the ability to bulk load external data into a cluster. However, before moving data to DSE, you need to consider how your client application will query the tables, and do data modeling first. The paradigm shift between relational databases and NoSQL means that a straight move of data from an RDBMS database to DSE will fail.

What operational tools are included with DataStax Enterprise?
What developer tools are available?
How do I test DataStax Enterprise?
What kind of hardware do I need to run DataStax Enterprise?

See Planning and testing cluster deployments for hardware requirements. The distributed nature of DSE can actively utilize multiple datacenters across several geographic regions, supporting highly available data under even the most trying circumstances.

How do I install DataStax Enterprise?

You can install DataStax Enterprise in several ways, depending on the purpose of the installation, the type of operating system, and the available permissions. See Which install method should I use?.

What tools can I use to load data into DataStax Enterprise?
How do I configure DataStax Enterprise?

This guide provides information including but not limited to:

  • using virtual nodes

  • setting up security

  • storing and accessing data exclusively from memory

  • setting up distributed data replication from remote clusters

  • running multiple DataStax Enterprise nodes on a single host machine

  • automating the movement of data across different types of storage media

How do I upgrade DataStax Enterprise?

The Upgrade Guide provides instructions for upgrading DataStax Enterprise. This guide also provides instructions on how to upgrade from Apache Cassandra to DataStax Enterprise.

What drivers work with DataStax Enterprise?

DataStax drivers come in two types: DataStax drivers for DataStax Enterprise 5.0 and later, and DataStax drivers for Apache Cassandra™. The DataStax drivers for DSE are enhanced to ease the development of applications powered by DataStax Enterprise. These drivers support full functionality for DSE, including DSE Graph, unified authentication, and geospatial types.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com