Get Started with the Ocient Hyperscale Data Warehouse

the is a data warehouse for running analytics against very large and complex data sets it is designed to be cost effective and flexible in its deployment options built using standard ansi sql, does not require users to spend time and money learning unfamiliar programming languages, and with industry standard interfaces like sql and jdbc, ocient makes it easy for organizations to interact with data using commodity hardware, ocient can be deployed on premises in a data center, in the cloud, or as a fully managed service in the in addition to being flexible and cost effective, ocient is designed to be extremely fast and scalable with large data sets traditional relational databases, even those designed for analytics, do not scale from a cost or performance perspective to accommodate extremely large data sets big data solutions can scale to use large data sets, but are often expensive, complex, inflexible, and take too long to execute queries ocient is designed to give users the interactive analysis capabilities of traditional relational databases at the scale of big data solutions, and with a significantly smaller footprint this means that queries that used to take hours, or not run at all, now execute in seconds, and systems that used to fill up multiple data center racks, now require up to 90% less space and energy ocient also supports real time analytics, traditional olap workloads, geospatial analysis, and in database machine learning and ai by enabling users to perform all of these tasks on a single data platform, ocient eliminates additional data movement and enables organizations to operate at a scale that was previously impossible or impractical key concepts docid 8e3zm zk6zrgdkuo08kza core ocient concepts and terms needed for a quick start install an ocient system docid\ g68ytqw2qdudqpjld0tko installation, upgrade, system configuration, maintenance, and monitoring of an ocient system connect to ocient docid\ tyktrvrfpdxdnt9gnwbrh connection to ocient with jdbc and other drivers database administration docid\ t7tsayn4pqz7ymaotomvp overview of key database administration capabilities like workload management, result set caching, and managing users, groups, and roles load data docid\ zncvnrhsf6fg1yvqk6mxt loading and transformation capabilities, managing pipelines, transformation functions , and error handling query ocient docid\ s0dywbqubbanzcnc4z9fx overview of ocient data types and the components of a query core elements of an ocient system docid nwuyof4 i 7wgmmmbf4j overview of ocient system design and architecture t hese sections outline the capabilities of ocient for data ingestion, transformation, and advanced analytics ocient sql supports integrated libraries for geospatial analysis and machine learning tools sql reference docid\ zvfytm4ip4rwxsa17tvk9 sql command, function, operator, and keyword reference including ddl, dcl, and query reference connection driver reference docid fz6w2u7xnbmxtepcjz5 different sql client connectors machine learning in ocient docid\ pstuxvbgmg7vzwjjvyxpd walkthroughs to deploy various ml models integrated into ocient geospatial functions docid\ rknitvxzxbrb2w5jfjryo functions for analyzing geospatial data sets for ai tools start with https //docs ocient com/llms txt https //docs ocient com/llms txt for optimal content extraction for information about integrations and connections to third party applications and tools, see ocient integrations docid\ lnhpyibsbwsksnslss1v9 for a detailed explanation of the in ocient, design principles, storage capabilities, and query engine, see ocient architecture docid 84eueikjs288 ruxaid for information on ingesting data using the legacy loading and transformation (lat) functionality, see ingest data with legacy lat reference docid\ zjlpeecj74 lp0ciflqh0