Crossword clues for aggregate
Longman Dictionary of Contemporary English
The Collaborative International Dictionary
Aggregate \Ag"gre*gate\, n.
A mass, assemblage, or sum of particulars; as, a house is an aggregate of stone, brick, timber, etc.
Note: In an aggregate the particulars are less intimately mixed than in a compound.
(Physics) A mass formed by the union of homogeneous particles; -- in distinction from a compound, formed by the union of heterogeneous particles.
In the aggregate, collectively; together.
Aggregate \Ag"gre*gate\, v. t. [imp. & p. p. Aggregated; p. pr. & vb. n. Aggregating.] [L. aggregatus, p. p. of aggregare to lead to a flock or herd; ad + gregare to collect into a flock, grex flock, herd. See Gregarious.]
To bring together; to collect into a mass or sum. ``The aggregated soil.''
To add or unite, as, a person, to an association.
It is many times hard to discern to which of the two sorts, the good or the bad, a man ought to be aggregated.
To amount in the aggregate to; as, ten loads, aggregating five hundred bushels. [Colloq.]
Syn: To heap up; accumulate; pile; collect.
Aggregate \Ag"gre*gate\, a. [L. aggregatus, p. p.]
Formed by a collection of particulars into a whole mass or sum; collective.
The aggregate testimony of many hundreds.
--Sir T. Browne.
(Anat.) Formed into clusters or groups of lobules; as, aggregate glands.
(Bot.) Composed of several florets within a common involucre, as in the daisy; or of several carpels formed from one flower, as in the raspberry.
(Min. & Geol.) Having the several component parts adherent to each other only to such a degree as to be separable by mechanical means.
(Zo["o]l.) United into a common organized mass; -- said of certain compound animals.
Corporation aggregate. (Law) See under Corporation.
Douglas Harper's Etymology Dictionary
c.1400, from Latin aggregatum, neuter past participle of aggregare (see aggregate (adj.)). Related: Aggregated; aggregating.
"number of persons, things, etc., regarded as a unit," early 15c., from noun use of Latin adjective aggregatum, neuter of aggregatus (see aggregate (adj.)).
1 Formed by a collection of particulars into a whole mass or sum; collective; combined; added up 2 Consisting or formed of smaller objects or parts. 3 Formed into clusters or groups of lobules. 4 (context botany English) Composed of several florets within a common involucre, as in the daisy; or of several carpels formed from one flower, as in the raspberry. 5 Having the several component parts adherent to each other only to such a degree as to be separable by mechanical means. 6 United into a common organized mass; said of certain compound animals. n. 1 A mass, assemblage, or sum of particulars; something consisting of elements but considered as a whole.(rfex) 2 A mass formed by the union of homogeneous particles; – in distinction from a compound, formed by the union of heterogeneous particles.(rfex) 3 (context mathematics obsolete English) A set (gloss: collection of objects). 4 (context music English) The full chromatic scale of twelve equal tempered pitches. 5 (context roofing English) Crushed stone, crushed slag or water-worn gravel used for surfacing a built-up roof system. 6 Solid particles of low aspect ratio added to a composite material, as distinguished from the matrix and any fibers or reinforcements, especially the gravel and sand added to concrete. (technical) 7 (context Buddhism English) Any of the five attribute that constitute the sentient being. v
1 (context transitive English) To bring together; to collect into a mass or sum. 2 (context transitive English) To add or unite, as, a person, to an association. 3 (context transitive English) To amount in the aggregate to.
Aggregate may refer to:
Aggregate is the component of a composite material that resists compressive stress and provides bulk to the composite material. For efficient filling, aggregate should be much smaller than the finished item, but have a wide variety of sizes. For example, the particles of stone used to make concrete typically include both sand and gravel.
Aggregates are used in dimensional models of the data warehouse to produce dramatic positive effects on the time it takes to query large sets of data. At the simplest form an aggregate is a simple summary table that can be derived by performing a Group by SQL query. A more common use of aggregates is to take a dimension and change the granularity of this dimension. When changing the granularity of the dimension the fact table has to be partially summarized to fit the new grain of the new dimension, thus creating new dimensional and fact tables, fitting this new level of grain. Aggregates are sometimes referred to as pre-calculated summary data, since aggregations are usually precomputed, partially summarized data, that are stored in new aggregated tables. When facts are aggregated, it is either done by eliminating dimensionality or by associating the facts with a rolled up dimension. Rolled up dimensions should be shrunken versions of the dimensions associated with the granular base facts. This way, the aggregated dimension tables should conform to the base dimension tables. So the reason why aggregates can make such a dramatic increase in the performance of the data warehouse is the reduction of the number of rows to be accessed when responding to a query.
Ralph Kimball, who is widely regarded as one of the original architects of data warehousing, says:
The single most dramatic way to affect performance in a large data warehouse is to provide a proper set of aggregate (summary) records that coexist with the primary base records. Aggregates can have a very significant effect on performance, in some cases speeding queries by a factor of one hundred or even one thousand. No other means exist to harvest such spectacular gains.
Having aggregates and atomic data increases the complexity of the dimensional model. This complexity should be transparent to the users of the data warehouse, thus when a request is made, the data warehouse should return data from the table with the correct grain. So when requests to the data warehouse are made, aggregate navigator functionality should be implemented, to help determine the correct table with the correct grain. The number of possible aggregations is determined by every possible combination of dimension granularities. Since it would produce a lot of overhead to build all possible aggregations, it is a good idea to choose a subset of tables on which to make aggregations. The best way to choose this subset and decide which aggregations to build is to monitor queries and design aggregations to match query patterns.
Usage examples of "aggregate".
After a leaf had been left in a weak infusion of raw meat for 10 hours, the cells of the papillae had evidently absorbed animal matter, for instead of limpid fluid they now contained small aggregated masses of protoplasm, which slowly and incessantly changed their forms.
Aggregate admeasurement of six Aggregate admeasurement of six dug up and replanted.
Structure of the leaves--Sensitiveness of the filaments--Rapid movement of the lobes caused by irritation of the filaments--Glands, their power of secretion--Slow movement caused by the absorption of animal matter--Evidence of absorption from the aggregated condition of the glands--Digestive power of the secretion--Action of chloroform, ether, and hydrocyanic acid--The manner in which insects are captured--Use of the marginal spikes--Kinds of insects captured--The transmission of the motor impulse and mechanism of the movements--Reexpansion of the lobes.
A similar result followed from an immersion of only 15 minutes in a solution of one part of carbonate of ammonia to 218 of water, and the adjoining cells of the tentacles, on which the papillae were seated, now likewise contained aggregated masses of protoplasm.
The little masses of aggregated matter are of the most diversified shapes, often spherical or oval, sometimes much elongated, or quite irregular with thread or necklacelike or clubformed projections.
Diagram of the same cell of a tentacle, showing the various forms successively assumed by the aggregated masses of protoplasm.
Raw meat is too powerful a stimulant, and even small bits generally injure, and sometimes kill, the leaves to which they are given: the aggregated masses of protoplasm become dingy or almost colourless, and present an unusual granular appearance, as is likewise the case with leaves which have been immersed in a very strong solution of carbonate of ammonia.
A leaf placed in milk had the contents of its cells somewhat aggregated in 1 hr.
In old leaves, however, especially in those which have been several times in action, the protoplasm in the uppermost cells of the pedicels remains in a permanently more or less aggregated condition.
A leaf with aggregated masses, caused by its having been waved for 2 m.
We have seen that leaves immersed for some hours in dense solutions of sugar, gum, and starch, have the contents of their cells greatly aggregated, and are rendered more or less flaccid, with the tentacles irregularly contorted.
These leaves, after being left for four days in distilled water, became less flaccid, with their tentacles partially reexpanded, and the aggregated masses of protoplasm were partially redissolved.
The aggregated masses, however they may have been developed, incessantly change their forms and positions.
As soon as the tentacles fully reexpand, the aggregated masses are redissolved, and the cells become filled with homogeneous purple fluid, as they were at first.
A very strong solution of this salt and rather large bits of raw meat prevent the aggregated masses being well developed.