Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 3

Displaying posts with tag: dataset (reset)

Advantages of weighted lists in RDBMS processing
+1 Vote Up -0Vote Down
posted by Justin Swanhart on Fri 17 Jun 2011 21:17 UTC
Tags:
(edit) mysql, database, data warehousing, computing, dataset, aggregation
A list is simply a list of things. The list has no structure, except in some cases, the length of the list may be known. The list may contain duplicate items. In the following example the number 1 is included twice.

Example list:
1
2
3
1

A set is similar to a list, but has the following differences:
  • The size of the set is always known

  • A set may not contain duplicates

    • You can convert a list to a set by creating a 'weighted list'. The weighted list includes a count column so that you can determine when an item in the list appears more than once:
    1,2
2,1
3,1
    Notice that there are two number 1 values in the weighted list. In order to make insertions into such a list scalable, consider using partitioning to avoid






      [Read more...]
    MySQL: Using Views as Performance Improvement Tools
    +0 Vote Up -0Vote Down
    posted by Ovais Tariq on Mon 30 May 2011 19:16 UTC
    Tags:
    (edit) mysql, sql, database, performance, views, DBA, joins, planning, slow log, dataset, patterns, mysql resources, data access, suboptimal
    The most basic and most oft-repeated task that a DBA has to accomplish is to look at slow logs and filter out queries that are suboptimal, that consume lots of unnecessary resources and that hence slow down the database server. This post looks at why and how VIEWs can help against such suboptimal operations.
    Tools to generate large synthetic data sets for testing?
    +0 Vote Up -0Vote Down
    posted by Justin Swanhart on Mon 12 May 2008 22:29 UTC
    Tags:
    (edit) mysql, data warehousing, Testing, dataset
    I need to generate large (1TB-3TB) synthetic MySQL datasets for testing, with a number of requirements:

    a) custom output formatting (SQL, CSV, fixed-len row, etc)
    b) referential integrity support (ie, child tables should reference PK values, no orphans,etc)
    c) able to generate multiple tables in parallel
    d) preferably able to operate without a GUI and/or manual intervention
    e) uses a well defined templating construct for data generation
    f) preferably open source

    Does anyone out there know of a product that meets at least most of these requirements?

    *edit*
    I found a PHP based data generation script (www.generatedata.com) that is extensible in its output formatting, so it should do everything I need it to do.
    Showing entries 1 to 3

    Planet MySQL © 1995, 2013, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.