Architecture FAQ

Frequently asked questions about DataStax Enterprise.

  • How do I interact with DataStax Enterprise?

    DataStax Enterprise’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.5 DSE protocol v2). For ease of use, CQL uses a similar syntax to SQL. The most basic way to interact with DataStax Enterprise (DSE) is using the CQL shell, cqlsh. Using cqlsh, you can create keyspaces and tables, insert and query tables, plus much more. Other ways to interact with DSE are:

    • DataStax Enterprise 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.

  • How is DataStax Enterprise different from relational databases?

    DataStax Enterprise 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.

  • 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 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 DataStax Enterprise will fail. See Migrating data to DataStax Enterprise.

  • 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 DataStax Enterprise 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?.

  • How do I configure DataStax Enterprise?

    The Admin guide and Dev guide provide information about 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; plus much more.

  • 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?

    You can use the same DataStax drivers for DataStax Enterprise, Astra DB, and Apache Cassandra® (OSS). DataStax has unified the DSE and OSS drivers to avoid user confusion and enhance the OSS drivers with some of the features in the DSE drivers. For more information, see the Better Drivers for Cassandra blog.

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,