MPP分析数据库——Jaspersoft支持IBM的Netezza MPP分析数据库数据仓库,不久还会提供商业的分析支持。
MPP analytic database - Jaspersoft supports IBM's Netezza MPP analytic database data warehouse and soon will add commercial analysis support.
因此当来自临时数据库的信息通过存储过程被转移到数据仓库中时,这个沿袭出现了一个断点。
So when information from the staging database is moved to the data warehouse through stored procedures, there is a gap in the lineage.
有许多主题未在本文中进行介绍,但它们同样是交付良好数据仓库解决方案的基础,包括系统和数据库设计、管理、性能调优等。
There are many topics not covered here that are also fundamental in delivering a good data warehouse solution, including system and database design, administration, performance tuning, and others.
数据仓库数据库设计的重点在于查询性能。
The design of a data warehouse database is focused on query performance.
数据仓库是集成的数据库集合,而非单个数据库。
A data warehouse is an integrated collection of databases rather than a single database.
既可以用关系数据库,也可以用任意模式的LDAP目录,来实现数据仓库。
The data repository can be implemented with either a relational database or an LDAP directory with arbitrary schemas.
EDM通常用作信息集成的参考模型,或者用作持久性数据库和数据仓库的基础。
EDM is often used as a reference model for information integration or as a basis for persistent databases and data warehousing.
每个业务系统数据库和数据仓库经常访问许多非常小的表(往往不超过u盘的容量)。
Just about every business system database and data warehouse has a large number of frequently accessed small tables that would fit on USB jump drives.
这些主题领域可以是将数据仓库逻辑划分成几个不同(概念的,甚至或者是物理的)数据库的基础。
These subject areas can be the basis for logically partitioning the data warehouse in several different (conceptual or even physical) databases.
数据仓库是更适合于新的,解决问题的具体的商务智能数据库。
Data warehouses are more suited to new, problem-specific BI databases.
Design Advisor 非常适合为数据仓库优化数据库设计,因为除了关于索引的建议之外,它还可以提供关于MQT、MDC和DPF分区键的建议。
The Design Advisor is well suited for optimizing database design for data warehouses as it provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
例如Oracle数据库,无论是联机事务处理(OLTP)或者数据仓库应用程序,都可以从大型页面的使用中获益。
For example, an Oracle database, either Online Transaction Processing (OLTP) or a data Warehouse application, can benefit when using large pages.
为简化测试,目标数据仓库数据库也配置为TPoX。
For testing simplicity, the target data warehouse database is also configured to be TPoX.
IWA是一个令人振奋的突破,它将新的数据仓库技术和传统的Informix关系数据库服务器相结合,产生一种非常快的性能。
IWA is an exciting breakthrough-combining new data warehouse technology with traditional Informix relational database servers-that results in very fast performance.
就在4年前,WinterCorp评定世界最大的数据库是超过100TB的数据仓库。
Just four years ago, WinterCorp identified the world's largest databases, which were data warehouses measuring over 100 TB.
Sun的数据仓库合作伙伴关系以及开源数据库前景均未可知。
Unknown future for Sun's data warehouse partnerships, open source database.
QueryPatroller语句(更适用于数据仓库数据库)。
Query Patroller statements (more applicable to data warehouse databases).
以下脚本可被编辑并在您的数据仓库数据库上运行,来生成一个脚本跨所有AW创建的事实表启动行压缩。
The following script can be edited and run on your warehouse database to generate a script to enable row compression across all AW created fact tables.
系统管理:数据管理、数据仓库安全性、系统和数据库的备份和恢复,等等。
System management: data management, data warehouse security, system and database backup and recovery, and so on.
物理数据模型是与数据库系统以及您将使用的数据仓库工具紧密相关的。
The physical data model is tightly related to the database system and data warehouse tools that you will use.
数据仓库的数据库——特别是数据集市——与终端用户非常接近,它通常不具有固定的查询。
A data warehouse database — especially a data mart — is very near to the end user, and it usually does not have fixed queries.
因为在处理大数据时,只有传统的数据库管理器和数据仓库是不够的,所以许多组织都在调整他们的系统以应付大量“行为不良”数据。
Because traditional database managers and warehouses alone are often inadequate when dealing with big data, many organizations are adapting their systems to cope with a world of "badly behaved" data.
循环日志记录通常在数据仓库环境中使用,在该环境中,恢复数据库需要的只是恢复数据库映象的问题。
Circular logging is typically used in data warehouse environments where the need to recover a database is just a matter of restoring a database image.
从企业的角度来说,日益增长的信息已经很难存储在标准关系型数据库甚至数据仓库中。
From an enterprise standpoint, all of this information has been getting increasingly difficult to store in traditional relational databases and even data warehouses.
如果是在数据库中,若用于脱机处理的数据(例如数据仓库)与用于联机处理的数据存储在一起,就会降低系统速度。
In the case of a database, data used for offline processing (such as data warehousing) might slow down the system if stored along with data for online processing.
然后数据被发送到目标DB (ods),在这里,它被解析、写进数据库,转换并发送至数据仓库DB。
Data is then sent to target DB (ODS) where it is parsed, written to data sets, transformed, and sent to the warehouse DB.
在该模型中,业务数据仓库是数据存储库数据库(模块)的集合,而数据集市则是数据集市层中的数据库。
In this model, the business data warehouse is the collection of data repository databases (module), and the data marts are the databases from the data mart tier.
但糟糕的是,为这种数据仓库开发详细的数据库设计是很困难的。
Unfortunately, developing a detailed database design for such a warehouse can be challenging.
HIWAS将经过切除的数据转换为关系- XML混合数据库或纯关系数据库的数据仓库架构。
HIWAS converts the excised data into warehouse schemas for hybrid relational-XML or pure relational databases, Knoop explains.
当此表加载到目标数据仓库表customer中,该表位于数据库 stores_demo 中,目标表可能会具有比表 customer_trans更多或者更少的列。
When this table is loaded into the target warehouse table customer, which is in the stores_demo database, the target table might have more or fewer columns than the customer_trans table.
应用推荐