CISSE 2009 - Paper Submission Deadline Extended to October 26, 2009.

Dear Colleagues,

Due to numerous deadline extension requests from potential CISSE 2009
authors, the CISSE organizing committee has decided to extend the paper
submission deadline to 10/26/2009. Please note that this is a hard
deadline, so that the technical committees can perform their paper
reviewing duties in a timely manner.

If you received this email in error, please forward it to the appropriate
department at your institution. If you wish to unsubscribe please follow
the unsubscribe link at bottom of the email.

Please do not reply to this message. If you need to contact us please email
us at info(at)cisse2009(dot)org

*********************************************************************
* The Fifth International Joint Conferences on Computer, *
* Information, and Systems Sciences, and Engineering (CISSE 2009) *
* *
* *
* *
* http://www.cisse2009.org *
* *
* *
* *
*********************************************************************

December 4-12, 2009

Sponsored by the University of Bridgeport
Technically co-sponsored by the IEEE Computer Society, Communications
Society and Education Society (Connecticut Section)

---------------------------------------------------------------------
CONFERENCE OVERVIEW
---------------------------------------------------------------------

CISSE 2009 provides a virtual forum for presentation and discussion of the
state-of the-art research on computers, information and systems sciences
and engineering. CISSE 2009 is the fifth conference of the CISSE series of
e-conferences. CISSE is the World's first Engineering/Computing and Systems
Research E-Conference. CISSE 2005 was the first high-caliber Research
Conference in the world to be completely conducted online in real-time via
the internet. CISSE 2005 received 255 research paper submissions and the
final program included 140 accepted papers, from more than 45 countries.
CISSE 2006 received 691 research paper submissions and the final program
included 390 accepted papers, from more than 70 countries. CISSE 2007
received 750 research paper submissions and the final program included 406
accepted papers. A total of 948 paper submissions were received for CISSE
2008 and the final program included 382 accepted papers, from more than 80
countries.

The virtual conference will be conducted through the Internet using
web-conferencing tools, made available by the conference. Authors will be
presenting their PowerPoint, audio or video presentations using
web-conferencing tools without the need for travel. Conference sessions
will be broadcast to all the conference participants, where session
participants can interact with the presenter during the presentation and
(or) during the Q&A slot that follows the presentation. This international
conference will be held entirely on-line. The accepted and presented
papers will be made available and sent to the authors after the conference
both on a DVD (including all papers, powerpoint presentations and audio
presentations) and as a book publication. Springer, the official publisher
for CISSE, published the 2005 proceedings in 2 books and the CISSE 2006,
CISSE 2007 and CISSE 2008 proceedings in four books each.

Conference participants - authors, presenters and attendees - only need an
internet connection and sound available on their computers in order to be
able to contribute and participate in this international ground-breaking
conference. The on-line structure of this high-quality event will allow
academic professionals and industry participants to contribute their work
and attend world-class technical presentations based on rigorously refereed
submissions, live, without the need for investing significant travel funds
or time out of the office.

The concept and format of CISSE is ground-breaking. The PowerPoint
presentations, final paper manuscripts and time schedule for live
presentations over the web are available for two weeks prior to the start
of the conference for all registrants, so that the participants can choose
the presentations they want to attend and think about questions that they
might want to ask. The live audio presentations were also recorded and are
part of the permanent CISSE on-line archive - accessible to all
registrants- which also includes all the papers, PowerPoint and audio
presentations.

Potential non-author conference attendees who cannot make the on-line
conference dates are encouraged to register, as the entire joint
conferences will be archived for future viewing.

The CISSE conference audio room provides superb audio even over low speed
internet connections, the ability to display PowerPoint presentations, and
cross-platform compatibility (the conferencing software runs on Windows,
Mac, and any other operating system that supports Java). In addition, the
conferencing system allows for an unlimited number of participants, which
in turn granted us the opportunity to allow all CISSE participants to
attend all presentations, as opposed to limiting the number of available
seats for each session.

Prospective authors are invited to submit full papers electronically in
Microsoft Word or Adobe PDF format through the website of the conference at
http://www.cisse2009.org. Accepted papers must be presented in the virtual
conference by one of the authors. To submit your paper, please visit
http://www.cisse2009.org

CISSE 2009 is composed of the following four conferences:

International Conference on Systems, Computing Sciences and Software
Engineering (SCSS 09)

Topics: Grid Computing, Internet-based Computing Models, Resource
Discovery, Programming Models and tools, e-Science and Virtual
Instrumentation, Biometric Authentication, Computers for People of Special
Needs, Human Computer Interaction, Information and Knowledge Engineering,
Algorithms, Parallel and Distributed processing, Modeling and Simulation,
Services and Applications, Embedded Systems and Applications, Databases,
Programming Languages, Signal Processing Theory and Methods, Signal
Processing for Communication, Signal Processing Architectures and
Implementation, Information Processing, Geographical Information Systems,
Object Based Software Engineering, Parallel and Distributed Computing, Real
Time Systems,
Multiprocessing, File Systems and I/O, Kernel and OS Structures.

International Conference on Telecommunications and Networking (TeNe 09)

Topics: Optical Networks and Switching, Computer Networks, Network
architectures and Equipment, Access Technologies, Telecommunication
Technology, Coding and Modulation technique, Modeling and Simulation,
Spread Spectrum and CDMA Systems, OFDM technology, Space-time Coding, Ultra
Wideband Communications, Medium Access Control, Spread Spectrum, Wireless
LAN: IEEE 802.11, HIPERLAN, Bluetooth, Cellular Wireless Networks, Cordless
Systems and Wireless Local Loop, Mobile Network Layer, Mobile Transport
Layer, Support for Mobility, Conventional Encryption and Message
Confidentiality, Block Ciphers Design Principles, Block Ciphers Modes of
Operation, Public-Key Cryptography and Message Authentication,
Authentication Application, Stenography, Electronic Mail Security, Web
Security, IP Security, Firewalls, Computer Forensics.

International Conference on Engineering Education, Instructional
Technology, Assessment, and E-learning (EIAE 09)

Topics: Instructional Design, Accreditation, Curriculum Design, Educational
Tools, 2-2-2 Platforms, Teaching Capstone Design, Teaching Design at the
Lower Levels, Design and Development of e-Learning tools, Assessment
Methods in Engineering, Development and Implementation of E-learning tools,
Ethics in Education, Economical and Social Impacts of E-learning.

International Conference on Industrial Electronics, Technology & Automation
(IETA 09)

Topics: Advanced and Distributed Control Systems, Intelligent Control
Systems (NN, FL, GA, .etc), Expert Systems, Man Machine Interaction, Data
Fusion, Factory Automation, Robotics, Motion Control, Machine Vision, MEMS
Sensors and Actuators, Sensors Fusion, Power Electronics, High Frequency
Converters, Motors and Drives, Power Converters, Power Devices and
Components, Electric Vehicles and Intelligent Transportation, Process
Automation, Factory Communication, Manufacturing Information System
Advances in Manufacturing Systems, Industrial Applications of Multi Media,
Intelligent Systems Instrumentation, Industrial Instrumentation, Modeling
and Simulation, Signal Processing, Image and Data Processing, VR and
Parallel systems..

Paper Submission
=================

Prospective authors are invited to submit full papers electronically in
Microsoft Word or Adobe PDF format through the website of the conference at
http://www.cisse2009.org.

Accepted papers must be presented in the virtual conference by one of the
authors. To submit your paper, visit http://www.cisse2009.org

New Paper submission Deadline: October 26th, 2009
Notification of Acceptance: November 12th, 2009
Final Manuscript and Registration: November 26th, 2009

------------------------------------------------------------------------
S. Patel
CISSE 2009 Support Team
University of Bridgeport e-mail:
info(at)cisse2009(dot)org
Bridgeport, CT 06604, U.S.A. http://www.cisse2009.org
------------------------------------------------------------------------

Click here on http://server1.streamsend.com/streamsend/unsubscribe.php?cd=3326&md=362&ud=9a1a9c3940fb37e1d923567f247d1449 <http://server1.streamsend.com/streamsend/unsubscribe.php?cd=3326&md=362&ud=9a1a9c3940fb37e1d923567f247d1449> to update your profile or Unsubscribe
>From pgsql-general-owner(at)postgresql(dot)org Sun Oct 11 23:20:45 2009
Received: from maia.hub.org (unknown [200.46.204.183])
by mail.postgresql.org (Postfix) with ESMTP id BFF4763502F
for <pgsql-general-postgresql(dot)org(at)mail(dot)postgresql(dot)org>; Sun, 11 Oct 2009 23:20:44 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
with ESMTP id 32234-04-7
for <pgsql-general-postgresql(dot)org(at)mail(dot)postgresql(dot)org>;
Mon, 12 Oct 2009 02:20:35 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from westnet.com (westnet.com [216.187.52.2])
by mail.postgresql.org (Postfix) with ESMTP id C87046354F6
for <pgsql-general(at)postgresql(dot)org>; Sun, 11 Oct 2009 22:41:36 -0300 (ADT)
Received: from westnet.com (localhost [127.0.0.1])
by westnet.com (8.14.0/8.14.0) with ESMTP id n9C1fYMc004847;
Sun, 11 Oct 2009 21:41:34 -0400 (EDT)
Received: from localhost (gsmith(at)localhost)
by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id n9C1fYNk004844;
Sun, 11 Oct 2009 21:41:34 -0400 (EDT)
X-Authentication-Warning: westnet.com: gsmith owned process doing -bs
Date: Sun, 11 Oct 2009 21:41:34 -0400 (EDT)
From: Greg Smith <gsmith(at)gregsmith(dot)com>
X-X-Sender: gsmith(at)westnet(dot)com
To: =?ISO-2022-JP?Q?=1B$B00IL=1B=28J_=1B$Bjj=1B=28J?= <peixubin(at)yahoo(dot)com(dot)cn>
cc: pgsql-general(at)postgresql(dot)org
Subject: Re: table full scan or index full scan?
In-Reply-To: <274837(dot)92053(dot)qm(at)web15001(dot)mail(dot)cnb(dot)yahoo(dot)com>
Message-ID: <alpine(dot)GSO(dot)2(dot)01(dot)0910112125160(dot)3309(at)westnet(dot)com>
References: <274837(dot)92053(dot)qm(at)web15001(dot)mail(dot)cnb(dot)yahoo(dot)com>
User-Agent: Alpine 2.01 (GSO 1184 2008-12-16)
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
tests=BAYES_00=-2.599
X-Spam-Level:
Content-Type: TEXT/PLAIN; CHARSET=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8BIT
Content-ID: <alpine(dot)GSO(dot)2(dot)01(dot)0910112131091(dot)3918(at)westnet(dot)com>
X-Archive-Number: 200910/419
X-Sequence-Number: 154113

On Mon, 12 Oct 2009, ?? ? wrote:

> perf=# select count(*) from test;

In PostgreSQL, if you're selecting every record from the table for a count
of them, you have to visit them all no matter what. The most efficient
way to do that is with a full table scan. Using an index instead requires
more disk I/O, because you have to read both the index blocks and the disk
blocks.

> The postgresql database uses the table full scan.but in oracle, the similar SQL uses the index full
> scanning,speed quickly many than postgresql.

Some other database systems can do just an index scan instead to compute
aggregates like count, but even there the rules are pretty complicated;
http://www.jlcomp.demon.co.uk/faq/count_rows.html covers a lot of the
material there for Oracle's implementation. Unfortunately this particular
optimization isn't available in Postgres yet, and you'll only switch to an
index scan if you're running a query that only selects a small number of
records where an index on the condition you're checking for exists.

There's some information about alternative ways to solve this problem at
http://wiki.postgresql.org/wiki/Slow_Counting

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
>From pgsql-general-owner(at)postgresql(dot)org Sun Oct 11 23:25:20 2009
Received: from localhost (unknown [200.46.208.211])
by mail.postgresql.org (Postfix) with ESMTP id C4156634E95
for <pgsql-general-postgresql(dot)org(at)mail(dot)postgresql(dot)org>; Sun, 11 Oct 2009 23:25:19 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
with ESMTP id 97421-01-6
for <pgsql-general-postgresql(dot)org(at)mail(dot)postgresql(dot)org>;
Mon, 12 Oct 2009 02:24:59 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-iw0-f186.google.com (mail-iw0-f186.google.com [209.85.223.186])
by mail.postgresql.org (Postfix) with ESMTP id 84C11636B46
for <pgsql-general(at)postgresql(dot)org>; Sun, 11 Oct 2009 23:07:36 -0300 (ADT)
Received: by iwn16 with SMTP id 16so4025454iwn.29
for <pgsql-general(at)postgresql(dot)org>; Sun, 11 Oct 2009 19:07:34 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=gamma;
h=domainkey-signature:mime-version:received:in-reply-to:references
:date:message-id:subject:from:to:cc:content-type
:content-transfer-encoding;
bh=d4Hx/x1ZRnU0e+9IgZsaPSmHJPl/N2ouzCFdUuMUMcU=;
b=l5JSpS83/M44Jt91tyK3ViVMVNIA+UkuSX0bpbbe9VtyOMEwV00WON/95oj4PQA+Ik
OP21q6w3HSkiRa9N0PXsZOB0wUnNxoTdrJcK4xFxCgSKhvB3sNXHS2OGzQn4hvDNCwrd
jIzL/duNADYQ1tNrUrhTZltl+cLn4r/u1Dj4k=
DomainKey-Signature: a=rsa-sha1; c=nofws;
d=gmail.com; s=gamma;
h=mime-version:in-reply-to:references:date:message-id:subject:from:to
:cc:content-type:content-transfer-encoding;
b=gYgMNyuEZVUyk2iEf0pZHTqkuji3hsvjbvNZuwlVupOs09gv7EnZEvS41hCYRKxlRk
rp73TWibIvr5mPoAk1AlwbL25EJSRUeAO8bHHqUkTgDJ4s4jpOD9fLpQgw5nMsFMKCRY
w4bZisOjlBPHYWCJ5X0e6V7nGORpigDvKfHbY=
MIME-Version: 1.0
Received: by 10.231.28.143 with SMTP id m15mr5780355ibc.23.1255313254669; Sun,
11 Oct 2009 19:07:34 -0700 (PDT)
In-Reply-To: <274837(dot)92053(dot)qm(at)web15001(dot)mail(dot)cnb(dot)yahoo(dot)com>
References: <274837(dot)92053(dot)qm(at)web15001(dot)mail(dot)cnb(dot)yahoo(dot)com>
Date: Sun, 11 Oct 2009 20:07:34 -0600
Message-ID: <dcc563d10910111907t52bd4725waa388a90c234ae59(at)mail(dot)gmail(dot)com>
Subject: Re: table full scan or index full scan?
From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: =?GB2312?B?0PGx8yDF4Q==?= <peixubin(at)yahoo(dot)com(dot)cn>
Cc: pgsql-general(at)postgresql(dot)org
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.471 tagged_above=-10 required=5 tests=AWL=0.128,
BAYES_00=-2.599
X-Spam-Level:
X-Archive-Number: 200910/420
X-Sequence-Number: 154114

Real quick, plain text is preferred on these lists over html. I don't
care myself so much.

On Sun, Oct 11, 2009 at 7:17 PM, =D0=F1=B1=F3 =C5=E1 <peixubin(at)yahoo(dot)com(dot)cn=
> wrote:
>
> I have a 30,000,000 records table, counts the record number to need for 4=
0 seconds.
> The table has a primary key on column id;
>
> perf=3D# explain select count(*) from test;
> ...
> -----------------------------------------
> Aggregate (cost=3D603702.80..603702.81 rows=3D1 width=3D0)
> -> Seq scan on test (cost=3D0.00..527681.04 rows=3D30408704 width=3D0)
> ...
> perf=3D# select count(*) from test;
> count
> ------------
> 30408704
>
> perf=3D#
>
>
> The postgresql database uses the table full scan.but in oracle, the simil=
ar SQL uses the index full scanning,speed quickly many than postgresql.

Yep, PostgreSQL isn't Oracle. It's a trade off. In pgsql indexes
don't contain visibility info, so all index lookups have to eventually
hit the table itself. So you either do indexlookup -> table lookup,
repeat as many times as you have index lookups or you just hit the
table since you gotta go there anyway.

On the bright side, this makes updates faster since you don't have to
lock both table and index and write to both at the same time anymore.

> postgresql's optimizer whether to have the necessity to make the adjustme=
nt?

Sorry, it's an architectural difference. Are you testing in a
realistic scenario including both reads and writes to the database to
see if postgresql is faster overall and identify problem areas that
pop up there?