BigTeddy's Playground

Oracle 20c Preview Release, only available on OCI 1. 20c云端上线     February 14, 2020  Version 20.2.0     May 14, 2020 Version 20.3.0 2. 20c区块链表     区块链技术使用Hash加密技术，将记录连接在一起。      Oracle 20c中作为数据库产品的一部分，无需额外安装     只允许插入操作， 区块链上的参与者都可以对链上数据进行验证     create blockchain table ssn_records     (bank varchar2(128), deposit_date date, deposit_amout number)     no drop unitl 31 days idle       --- day min = 16     no delete locked     hashing using "sha2_512" version 'v1"     partition by range(deposit_date)     (     partition p1 values less than (to_date('2020/01/01','yyyy/mm/dd')),     partition p2 values less than (to_date('2021/01/01','yyyy/mm/dd'))     ); 3. 20c In-Memory增强     基于Oracle 向量连接      inmemory_automatic_level  [HIGH, middle, low], 根据数据被访问的热度，进行对象压缩，调整     混合扫描， buff...

Identity and Access Management (IAM) --IAM Policies --IAM compartment --Policy Inheritance and Attachment --IAM-Tags Virtual Cloud Network(VCN) --CIDR --Intro VCN --Routing and Gateway --Peering --Security VCN --DNS Connectivity - VPN Connect & FastConnect --Conectivity to On-Premises Networks --VPN Connect --FastConnect Load Balancer --Public, Private --Primary, Standby Compute --Compute Intro --Images --Boot Volumne --Autoscalling --Instance Metadata and lifecycle OCI Storage Services       Type, Durability, Capacity, Unit Size, Use cases --Local NVMe --Block Volume --File Storage --Object Storage --Archive Storage Oracle Database on OCI --OCI Databasse services       Bring your won license, OCI paltform integration, Security, Storage, Scaling,  RAC/ADG --VM Database System --Bare Metal DB system  --Exadata DB systems       All benefits of Public Cloud, full Oracle DB with advanced options --Database Editions     ...

#####LACS日志采集方式#####                      通过安装Cloud Agent           通过Log server/Duplicated server/syslog           手动上传， LACS客户端命令行 Customer Proxy #####技术点一览##### 解析器：从非结构化日志中获取有用信息并结构化，内容转换成Key-Value                 引导式的解析日志，正则表达式                 开箱即用的解析工具                            Oracle ebusiness, Database, Middleware                        Non-Oracle (SAP, Apache, DB2, MS-SQL, NetApp, Juniper)                       手工书写 日志源：目标/主机上目录位置                 关联目标和日志源，将日志与实体（对象）项相关联                 有利于从应用application 角度分析日志 人工上传： 命令行，交互式， UI   ...

传统意义上的基础设施主要是公路、铁路、桥梁、隧道、机场、港口、电网、供水等设施， “新型基础设施”则包含 5G网络 、 物联网 、 特高压，城际铁路，工业联网， 数据中心等数字化设施                新基建分为三类，分别是通信网络及 高性能计算 、应用 大数据 等技术的传统基础设施、支撑科研创新的设施。 高捕获率工作负载案例： SK Telecom，纽约股票交易所。。。 NoSQL vs Oracle 优化设计，配置，性能优于NoSQL Database 主要需求： 可扩展，灵活性，实时分析。 --------------快速加载------------------ Oracle RAC， Sharding 使用Oracle bigfile 表空间。 使用autoallocate扩展管理， 注意在表上指定较大的扩展大小，防止等待事件 enq：HW 单行插入 vs 数组插入， 允许通过数据库API使用单个语句插入多行，适用于所有编程语言，降低redo生成和CPU需求，减少网络通信量，每个绘画 18000/s 禁用表级锁定，防止DDL命令 使用异步提交 Oracle Direct Path Loads + 外部表， 采用分区扩展语法防止表级锁 外部临时文件的位置，格式可能会对加载效率有很大影响。单字节分隔符。。。 数据压缩。 IoT的特点： 一次捕获，数据很少改变，包含大量重复的值        compress for direct_load operations        compress for all operations        DMLcompress for [query|archive] [high|low] Memoptimized Rowstore: 快速捕获支持         DBMS_MEMOPTIMIZE， 直接写入内存，需要application确认数据装载一致性和完整性 alter table meter_readings memeoptimize for wri...

A data curator's job is to understand and prepare data for use in analytics and reports. SAS has several of ferings that can aid in this ef fort. The technology components that comprise SAS data quality offerings include: • DataFlux Data Management Studio – a Windows-based desktop client application that enables you to create and manage processes for ensuring the accuracy and consistency of data during the data management life cycle. Typically, Data Management Studio is thought of as the development environment. • DataFlux Data Management Server – provides a scalable server environment for executing the processes created in Data Management Studio. Typically, Data Management Server is thought of as the production environment. • SAS Quality Knowledge Base (QKB) – a collection of files and algorithms that provide the data cleansing and data management functionality that is surfaced through the nodes in Data Management Studio processes. • Reference data source(s) – third-party address ...

The Analytics Applications and other SAS tools help analysts make and manage models, forecast trends, and generate statistics and visualizations on data. --SAS Enterprise Miner --SAS Forecast Server --SAS Model manager --JMP The Reporting Applications available in the SAS platform and other SAS applications allow users to generate complex dashboards and reports on their data as well as access data and generate reports with Microsoft Office tools like Excel or Word. --SAS Add-In for Microsoft Office --SAS Visual Analytics The Programming Interfaces available in the SAS platform allow users to write and edit SAS code, which can be used to manage, analyze, and report on data. SAS code will be used in this course to generate custom transformations and can be used in the tool to customize jobs and existing transformations. --SAS Studio --SAS Enterprise Guide The Data Management Applications available in the SAS platform.  --SAS Data Integration Studio application --DataFlux Data Managem...

### Data Curation Professional    (4 courses) Learn about data curation, data management and Hadoop – everything you need to manage big data. -----Introduction to Data Curation for SAS Data Scientists -----SAS Data Management Tools and Applications -----SAS and Hadoop -----Advanced SAS Data Management Tools and Applications ### Advanced Analytics Professional   (9 courses) Expand your analytical skill set by learning analytical modeling, machine learning, experimentation, forecasting and optimization. ===Predictive Modeler Using SAS Enterprise Miner=== -----Applied Analytics Using SAS® Enterprise Miner ==Advanced Predictive Modeling Using SAS 9.4=== -----Predictive Modeling Using Logistic Regression -----Neural Network Modeling -----Data Mining Techniques: Predictive Analytics on Big Data -----Using SAS® to Put Open Source Models into Production ===Text Analytics, Time Series, Experimentation, and Optimization=== -----Text Analytics Using SAS® Text Miner -----Time Se...