ORACLE数据库的大数据处理有些什么方式

发布网友发布时间：2022-04-07 20:48

共4个回答

懂视网时间：2022-04-08 01:09

x1 as (select userid,startdate,coalesce(min(case when type=-1 then add_months(startdate,-1) else startdate end) over(partition by userid order by vid rows between 1 following and unbouded following),startdate+1) as minsdate, enddate as orgenddate, case when enddate is null and (lead(type) over(partition by userid order by vid))=-1 then add_months((lead(startdate) over(partition by userid order by vid)),-1) else enddate end as enddate,type,vid, max(vid) over(partition by userid) as max_id from test, x2 as (select userid,startdate,minsdate,enddate,type,vid,max_id, case when (lag(enddate) over(partition by userid order by vid))<add_months(startdate,-1) then 1 when (lag(type) over(partition by userid order by vid))=1 then null else 1 end as so from x1), x3 as (select userid,vid,max_id,type,sum(so) over(partition by userid order by vid) as so, startdate,minsdate, case when minsdate<enddate and minsdate>=startdate then minsdate else enddate end as enddate from x2 where type=1 and startdate<=minsdate), x4 as (select userid,max_id,max(vid) as max_id2,sum(type) as type, min(startdate) keep(dense_rank first order by vid) as startdate, max(enddate) keep(dense_rank last order by vid) as enddate from x3) select userid,to_char(startdate,‘yyyymm‘)||‘--‘||coalesce(to_char(enddate,‘yyyymm‘),‘NULL‘) as rangeSpace from x4 where (max_id=max_id2 or startdate<=enddate) and type>-1;

Oracle数据整理

标签：

热心网友时间：2022-04-07 22:17

大数据的概念很广，不知道你说的是那种！
如果是数据库里面比如说像数据仓库这种：
一般是用一下几种方法：
分区，压缩，并行。
如果是广义的大数据，oracle的解决方案是：
oracle 的nosql
extradata
加上hadoop这种！

热心网友时间：2022-04-07 23:35

大数据的概念很广，不知道你说的是那种，
如果是数据库里面比如说像数据仓库这种:
一般是用一下几种方法:
分区，压缩，并行。
如果是广义的大数据，oracle的解决方案是:
oracle 的nosql。

热心网友时间：2022-04-08 01:10

http://wenku.baidu.com/view/bc7a6d5677232f60ddcca11e.html

看下这个文档希望有帮助