Get Started with the Ocient Hyperscale Data Warehouse
{{ocienthyperscaledatawarehouse}} is a data warehouse for r unning analytics a gainst the world’s largest time series data sets it is designed to be flexible in its deployment options and cost effective {{ocient}} does not require knowledge of unfamiliar programming languages that require additional learning time and cost with industry standard interfaces like sql and jdbc, ocient makes it easy for organizations to interact with data in ocient running on commodity hardware, ocient can run on premise in an organization’s data center, in the cloud, or as a fully managed service by ocient while flexible and cost effective, ocient is also designed to be extremely fast and scalable with time series data sets larger than 100 terabytes traditional relational databases, even those designed for analytics, don’t scale from a cost or performance perspective to petabyte and exabyte sized data sets big data solutions can scale to large data sets but are often complex, inflexible, and require too much time to execute queries ocient is designed to give users the interactive analysis of traditional relational databases at the scale of big data solutions this means that queries that used to take hours, or not run at all, now execute in seconds ocient achieves this performance through its distributed architecture, where storage and computing are collocated the collocation of storage and computing also allows ocient to perform other valuable operations on the data stored in the data warehouse, such as machine learning and geospatial analysis by executing machine learning and geospatial analysis within the data warehouse, ocient eliminates additional data movement and enables organizations to run machine learning and geospatial analysis at a scale that was previously impossible or impractical key concepts docid\ khg5hvbqlyjvozwfm2gkj core ocient concepts and terms needed for a quick start install an ocient system docid\ qhvyfg5eqo7rz8ssuvk1p installation, upgrade, system configuration, maintenance, and monitoring of an ocient system connect to ocient docid 3ogdk ko9evjyfqgs6n5h connection to ocient with jdbc and other drivers database administration docid\ j6asvjrinigbqmzjeartr overview of key database administration capabilities like workload management, result set caching, and managing users, groups, and roles load data docid 1nw163anqyhk58cqmepjs loading and transformation capabilities, managing pipelines, transformation functions , and error handling query ocient docid\ irpwvlqbnvw azqozjr0a overview of ocient data types and the components of a query core elements of an ocient system docid\ nbt9zpvnjmg9wrym0onbl 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\ eaohxmozywvukdfizfpel sql command, function, operator, and keyword reference including ddl, dcl, and query reference connection driver reference docid 7x2o5ty 0rd4pdmnxmg different sql client connectors machine learning in ocient docid\ bf qzmquriwhdwhbl6ezw walkthroughs to deploy various ml models integrated into ocient geospatial functions docid\ hpngsvdeojhofhdmpyrmh functions for analyzing geospatial data sets for information about integrations and connections to third party applications and tools, see ocient integrations docid\ lbwkjbkyfpui bkxdhdwa for a detailed explanation of the {{casa}} in ocient, design principles, storage capabilities, and query engine, see ocient architecture docid\ cjagrvaamhder8tjykuoy for information on ingesting data using the legacy loading and transformation (lat) functionality, see ingest data with legacy lat reference docid ul5nilgyd7y wjccg59d