大数据
-
A Detailed Explanation of ODI Knowledge Modules LKM & IKM
by Ashok Das Another article in Ashok's series where he examines Oracle Data Integrator (ODI) Knowledge Modules (KM). For an basic introductory overview, check out 'What is an ODI Knowledg…
-
NYPD Analytics: Fighting Crime With A Business Intelligence Dashboard
by Jaime Seagraves The New York Police Department has developed what they are calling a hi-tech analytical dashboard tool that collects crime and event data around the city. This Domain Awareness Sys…
-
A Detailed Explanation of ODI Knowledge Modules LKM & IKM
by Ashok Das Another article in Ashok's series where he examines Oracle Data Integrator (ODI) Knowledge Modules (KM). For an basic introductory overview, check out 'What is an ODI Knowledg…
-
NYPD Analytics: Fighting Crime With A Business Intelligence Dashboard
by Jaime Seagraves The New York Police Department has developed what they are calling a hi-tech analytical dashboard tool that collects crime and event data around the city. This Domain Awareness Sys…
-
Converting Hyperion IR (Brio) to OBIEE
by Sridhar Kasthuri Converting Hyperion Interactive Reporting (Brio) to OBIEE What is Hyperion Interactive Reporting (Brio)? Interactive Reporting was originally developed by Brio Software and distri…
-
索引-缺失、使用情况SQL语句
查询当前数据库中缺失的索引，知道你进行优化的参考 SELECT user_seeks * avg_total_user_cost * ( avg_user_impact * 0.01 ) AS [index_advantage] , migs.last_user_seek , --上一次访问时间 mid.[statement] AS …
-
MySQL备份
MySQL备份 为什么要备份： 保证重要的数据不丢失 数据转移 MySQL数据库备份的方式 直接拷贝物理文件 在sqlyog这种可视化工具中手动导出 在想要导出的表或者库中，右键，选择备份或导出 使用命令行导出 mysqldump 命…
-
修改ASQLite3D2010 支持中文显示
使用ASQLite3组件时： 将中文保存到ansichar 字段.有些情况正常,有些情况不正常.建议将中文保存到unicode 字段.使用tdbgrid+TASqlite3Table保存,显示正常.使用TASqlite3Query SQl语句直接插入values('中文'),在tdbg…
-
规范数据库设计
规范数据库设计 9.1、为什么需要设计 当数据库比较复杂的时候，我们就需要设计了 糟糕的数据库设计： 数据冗余， 浪费空间 数据库插入和删除都会麻烦、异常[屏蔽使用物理外键] 程序的性能差 良好的数据库设计： 节…
-
Redis脑裂问题 和 处理办法
背景假设现在有三台机器，分别安装了redis服务，结构如图 故障发生：如果此时master服务器所在区域网络通信出现异常，导致和两台slave机器无法正常通信，但是和客户端的连接是正常的。那么sentinel就会从两台slave…