以这种方式控制ETL工作,对于保证按适当次序装载包含主键或外键依赖的数据仓库表十分有用。
Controlling the ETL work in this manner can be useful for guaranteeing the proper sequence for loading data warehouse tables that contain primary or foreign key dependencies.
以数组形式检索工作表数据。
根据对工作表数据的处理方式,需要根据用途选择相应的提要。
Depending on how you want to process the data from the worksheet, you need to select the appropriate feed for your purposes.
您可以通过添加列和行、包括其他来源的数据、创建用于计算的公式等,从而操作工作表。
You can manipulate the worksheet by adding columns and rows, including data from other sources, creating formulas for computations, and so on.
Jim和Stack工作的地方Powerset,需要一个类似Bigtable的数据存储系统来保存他们的web表格(webtable),一个存放web文档及其以url作为关键字的属性的宽泛的表。
Powerset, where Jim and Stack work, needed a Bigtable-like data store to hold its webtable, a wide table of web documents and their attributes keyed by URL.
论述车流组织计算机辅助设计系统(WFOCADS)的功能模块、工作流程,并阐述数据库表结构。
The essay expounds the function module and working process of wagon flow organization CAD system (WFOCADS), as well as database framework.
连接信息保留在工作表中,以便在接收者打开它的时候,它将自动连接到服务器并刷新数据。
The connection information is kept in the worksheet so that, when the receiver opens it up, it connects to the server automatically and the data is refreshed.
介绍德国Q系列燃气表的结构及工作原理、技术数据、试验记录、选型与施工要求、实际应用。
The structure and operating principles, technical data , test records, type selection and demands in installation , and actual application of German Q series quantometers are described.
TeradataEnterprise 工作台使用 FastLoad协议将数据加载到表中。
The Teradata Enterprise stage uses the FastLoad protocol to load data into a table.
图31展示了Teradata Load工作台用于将数据加载到数据库表中时的工作台定义。
Figure 31 shows the stage definition for the Teradata load stage when the stage is used to load data into a database table.
在摄取数据之前采用暂存表来加载和转换数据,这可以最大程度地减少对查询工作负载的干扰。
Employing staging tables to load and transform data ahead of ingest minimizes interference with query workloads.
到达的工作(比如平面文件适配器的文件系统中的文件或JDBC适配器的数据库表中的数据)不应该以超常的速度增长。
Inbound work, like number of files in the file system for a flat file adapter or data in a database table for a JDBC adapter, should not grow unusually.
将XML数据与关系数据库结合是非常有意义的工作,而将XML文档存储为关系表一直是数据库领域研究的热点问题。
It's a meaningful work to combine XML data with a relational database, and storing XML documents into relational tables has been one of the hot topics in the area of database research.
该系统一方面能完全代替人工到现场抄表的工作,另一方面,还能对数据进行存储、计算、分析。
The system can not only relieve artificial meter reading on site but also store, compute and analyze the data.
如果您再次在工作表中搜索数据,但是找不到您知道一定存在的字符,那么您可能需要清除上一次搜索的格式选项。
If you search the worksheet for data again and cannot find characters that you know to be there, you may need to clear the formatting options from the previous search.
工作负载中使用的9个表分布在两个后端db 2数据库中。
The nine tables used in the workload are split across the two back end DB2 databases.
随着数据库的老化,性能将逐渐下降,因为表会越来越大,使用模式也发生了变化,并且工作量也有所增加。
As the database ages, performance can slowly degrade as tables get bigger, usage patterns change, and workload volume increases.
比方说,如果在应用领域采用哈希表或者其他无序数据结构管理数据,可能会面临着将元素按照模式中的顺序设定重新装配的额外工作。
For example, if you manage data in hash tables or other unordered data structures in the application domain, you might face additional work re-assembling elements into the order set by a schema.
因为TPC - H工作负载中表扫描和表排序的数量较多,所以为获得最佳性能将数据从磁盘预取到内存是很重要的。
Because of the number of table scans and table sorts in the TPC-H workload, prefetching data from disks into memory is important for optimal performance.
选择“工具”菜单中的“方案”命令,可保存可变单元格中的数据,从而不用保存多张分析工作表。
You can store different values for the same worksheet cells without making multiple copies of the file. Choose Scenarios from the Tools menu.
这儿是本例中数据源数据行返回的截图,当执行“扩展到明细”操作时,这些数据行被放在新的工作表中。
Here is a screenshot of the source data rows returned in the example when performing the "expand to detail" operation. The rows are placed in a new worksheet.
清单5设置了目标电子表格和工作表,然后创建了一个行数据数组,包含列-值映射。
Listing 5 sets the target spreadsheet and worksheet and then creates an array of row data containing column-value mappings.
工作表中的数据定期刷新,因此您可以获得最新的信息,就像是在查看仪表板一样。
The data in the worksheet is refreshed periodically and, therefore, you get the latest information as though you are looking at a dashboard.
面对它的所有绘图、排序和其他数据操作功能,许多人无疑会希望将监视数据放到Excel工作表中,这正是我们所做的事情。
With all of its graphing, sorting, and other data manipulation capabilities, it is little wonder that many would desire to put monitor data into an Excel worksheet, which is exactly what we did.
必须指定此电子数据表的ID和电子数据表中的工作表的ID。
You must specify the ID of the spreadsheet and the ID of the worksheet within the spreadsheet.
于是,对于大型的表,工作负载可以分布在多个分区上,而更小的表也可以存储在一个或多个数据库分区上。
A workload can then be spread across multiple partitions for large tables, while allowing smaller tables to be stored on one or more database partitions.
但我们的表单不仅限于在单个表中工作;单个表单可以通过关系对象为多个表显示和编辑数据。
But our form is not limited to working within a single table; a single form can display and edit data for many tables through relation objects.
您还可以从一个PHP应用程序中查看电子表格数据,并添加、编辑、删除单元格、行和工作表。
With the Google Spreadsheets data API, you can view spreadsheet data from a PHP application and change it, by adding, editing, and deleting cells, rows, and worksheets.
您还可以从一个PHP应用程序中查看电子表格数据,并添加、编辑、删除单元格、行和工作表。
With the Google Spreadsheets data API, you can view spreadsheet data from a PHP application and change it, by adding, editing, and deleting cells, rows, and worksheets.
应用推荐