Applications of Folding Flat Sheets of Materials into 3-D ...
14 pages
English

Applications of Folding Flat Sheets of Materials into 3-D ...

-

Le téléchargement nécessite un accès à la bibliothèque YouScribe
Tout savoir sur nos offres
14 pages
English
Le téléchargement nécessite un accès à la bibliothèque YouScribe
Tout savoir sur nos offres

Description

  • exposé - matière potentielle : to two methods
Applications of Folding Flat Sheets of Materials into 3-D Intricate Engineering Designs E. A. Elsayed and Basily B. Basily Department of Industrial and Systems Engineering Rutgers University 96 Frelinghuysen Road Piscataway, NJ 08854-8018 Abstract Folding of flat sheets of material into intricate three-dimensional structures provides a new technology for production of cores and sandwich structures of high strength/weight and/or strength/volume ratios. Geometric patterns are generated by transforming flat sheets of materials (traditional or composite) by imposing a permanent fold at specific edges of tessellated sheets.
  • impact energy
  • continuous folding
  • core structure
  • core structures
  • simulation of composite sandwich structures for civil transportation
  • b.b.
  • b. b.
  • patterns
  • material
  • load
  • 3 materials
  • materials

Sujets

Informations

Publié par
Nombre de lectures 27
Langue English

Exrait





JustOneDB 1.0 Cloud Reference
Documentation
JustOne Database Inc.
Release 1.0 Cloud Reference Documentation 1



JustOneDB 1.0 Reference Documentation
Copyright © 2011 JustOne Database Inc. All rights reserved.

This document pertains to JustOneDB software and to any subsequent release until otherwise
indicated. Information in this document is subject to change without notice. The software described
herein is furnished under a license agreement, and it may be used or copied only in accordance with
the terms of that agreement. No part of this publication may be reproduced, transmitted, or
translated in any form or by any means, electronic, mechanical, manual, optical, or otherwise,
without the prior written permission of JustOne Database Inc. JustOne Database Inc. makes no
warranty of any kind with respect to the completeness or accuracy of this document.

PostgreSQL is a trademark of Marc Fournier held in trust for The PostgreSQL Development Group. All
other company and product names used herein may be trademarks or registered trademarks of their
respective companies.

PostgreSQL is Copyright © 1996-2010 by the PostgreSQL Global Development Group and is
distributed under the terms of the license of the University of California below.

Postgres95 is Copyright © 1994-5 by the Regents of the University of California.

Release 1.0 Cloud Reference Documentation 2


Contents
Preface .................................................................................................................................................... 4
Conventions ............ 4
Overview ................. 5
Tablespaces ..................................................................................................................................... 5
Tables .............. 5
Indexes ............................................................................................................................................ 5
Partitioning...... 5
Statistics .......... 6
Inheritance ...................................................................................................................................... 6
Objects ............ 6
Release 1.0 Limitations ........................................................................................................................... 7
Reference ................................................ 8
Data Type Reference ........................... 8
SQL Reference ................................................................................................................................... 10


Release 1.0 Cloud Reference Documentation 3


Preface

This document provides information and instructions for using a JustOneDB database system in the
Cloud.
This document assumes some knowledge of relational database systems, structured query language
(SQL) and the standard interfaces for the PostgreSQL database.
This document contains the following sections
 Overview – provides an introduction to the JustOneDB system
 Release 1.0 Limitations – summarizes the temporary restrictions in this early release
 Reference – provides a reference for environment variables, data types and SQL commands.
 Support – details about the process for communicating product bugs

Throughout the document there are links to PostgreSQL documents for providing detailed
information about standard PostgreSQL features.
Conventions

This document uses the following typographical conventions throughout:
 Commands and responses are represented in Courier font.
 Placeholders that require replacement with an actual value are shown in italics font.
 Differences and emphasis are shown with a bold font.
 Square brackets [] are used to indicate optional parts of command or statement syntax.
 Braces {} and pipes | are used to indicate alternatives in command or statement syntax.
 Ellipses … are used to indicate repetition in a command or statement syntax.
 Dollar $ is used to represent an operating system prompt.

Release 1.0 Cloud Reference Documentation 4


Overview

JustOneDB is a fully functional relational database management system (RDBMS) that supports
multi-user transactional updates and analytical queries concurrently within the same database
instance.
JustOneDB does not require the design, build or maintenance of indexes, partitions or schema
transformations to efficiently service queries for fast response times and/or high throughput. This
ability to service arbitrary queries directly against operational data makes JustOneDB rapidly
adaptable to new requirements and provides analytical results in near real-time.
JustOneDB is built upon the open source PostgreSQL database. While the standard PostgreSQL
storage engine and optimizer have been replaced with the JustOneDB storage engine, the functional
features of PostgreSQL have been retained to provide the full functionality expected of a feature-
rich relational database.
Therefore JustOneDB functions in the same way as PostgreSQL except that users are able to create
tables and perform arbitrary queries against them without any need to think about indexing,
partitioning or data transformation (such as de-normalization).
JustOneDB is accessible through the standard PostgreSQL database drivers for DBI.
Note that JustOneDB is a relational database (RDBMS) rather than an object relational database
(ORDBMS) and therefore does not support the object extensions found in standard PostgreSQL such
as data type and operator extensions.
Tablespaces
The default tablespace in JustOneDB is called “jo_tablespace” and user tables will be created in this
tablespace unless specified otherwise. For this release of the product it is strongly recommended
that the tablespace NOT be explicitly specified for the creation of a user table or a temporary table.
Tables
The WITH clause is not relevant for JustOne tables and is silently ignored. See CREATE TABLE for
details of the WITH clause.
Indexes
JustOne tables do not require the definition of any indexes. While it is still possible to define an
index for a JustOne table, the definition will have no effect and is not required. However, the ability
to define such indexes allows legacy schemas to be imported with minimal change to the schema
definitions.
Partitioning
JustOne tables do not require partitioning. Partitioning in standard PostgreSQL is achieved through
table inheritance and this is not supported for JustOne tables. See Inheritance below.
Release 1.0 Cloud Reference Documentation 5


Statistics
JustOne tables do not require statistics to be gathered, maintained or analysed to optimize query
performance.
Inheritance
JustOne tables cannot be created using the INHERITS clause to link parent and child tables. Note that
JustOne tables do not require partitioning. An attempt to create an inheritance link will cause an
exception for the CREATE TABLE command.
Objects
JustOneDB is a pure relational database and does not support the object extensions available within
standard PostgreSQL. While the definition of new data types and operators are allowed, they cannot
be applied to JustOne tables.




Release 1.0 Cloud Reference Documentation 6


Release 1.0 Limitations
Release 1.0 is a first release which contains a subset of the functions that will be supported in
subsequent releases of the product.
Therefore there are some notable differences from standard PostgreSQL which are temporary
limitations specific to release 1.0. These limitations will be removed in subsequent releases. These
limitations are summarized in the table below.
Limitation Effect
The first column in a table cannot be NULL Currently, it is not possible to insert a NULL value into
the first column of a table.
Triggers are not currently supported. An attempt to execute a trigger will currently raise an
exception. This limitation will be removed in a
subsequent release.
Analytical queries use standard PostgreSQL Analytical queries are currently performed by
row scanning. PostgreSQL scanning the JustOneDB storage engine.
Therefore, analytical queries will perform like standard
PostgreSQL queries. This limitation will be removed in
a subsequent release.
Joins currently use standard PostgreSQL Joins are currently performed by PostgreSQL using its
join strategies. standard join strategies. This limitation will be
removed in a subsequent release.
Savepoints are not currently supported. Setting a savepoint is permitted; but rolling back to a
savepoint currently rolls back the entire transaction.
This also means that setting ON_ERROR_ROLLBACK
may not work as expected. This limitation will be
removed in a subsequent release.
Nested transactions are not supported. Nested transactions are not supported. This limitation
will be removed in a subsequent release.
Unique and key constraints are not Currently, it is possible to insert rows that violate
currently enforced. unique or key constraints. This limitation will be
removed in a subsequent release.
Exclude constraints are not currently Currently, it is possible to insert rows that violate
enforced. exclude constraints. This limitation will be removed in
a subsequent release.
Deferred constraints are not currently Currently, it is not possible to defer a constraint. This
supported. limitation will be removed in a subsequent release.
Column types Geometric, text search, network address, XML, array
and UUID types are not currently supported. This
limitation will be removed in a subsequent release.

The limitations above are also documented in the SQL reference section under each relevant
command.


Release 1.0 Cloud Reference Documentation 7


Reference
This section is a reference section for data types and SQL commands.
Data Type Reference
The following reference table identifies which standard PostgreSQL column types are supported by
release 1.0.
Number All of the number types are supported
smallint Supported
integer Supported
bigint Supported
decimal Supported
numeric Supported (with and without precision or scale)
real Supported.
The standard PostgreSQL accuracy limitations apply.
double precision Supported.
The standard PostgreSQL accuracy limitations apply.
float Supported (with and without precision).
The standard PostgreSQL accuracy limitations apply.
serial Supported
bigserial Supported
money Supported
String All of the string types are supported
character Supported
varchar Supported
char Supported
text Supported
bytea Supported
Date & Time All of the date and time types are supported
Timestamp Supported (with and without time zone)
Date Supported
Time Supported (without time zone).
Note that “time with time zone” is not supported because time does not
have a date component and therefore the time offset cannot be
adequately resolved.
Interval Supported
Boolean All Boolean types are supported
boolean Supported
bit Supported
bit string Supported
Enumerated User-defined enumerated types are not supported by release 1.0.
Object Object types are not supported
BLOB Not supported
CLOB Not supported
Geometric Geometric types are not supported by release 1.0.
point Not supported
line Not supported
lseg Not supported
box Not supported
Release 1.0 Cloud Reference Documentation 8


path Not supported
polygon Not supported
circle Not supported
Network Address Network address types are not supported by release 1.0.
cidr Not supported
Inet Not supported
macaddr Not supported
Text Search Text search types are not supported by release 1.0.
tsvector Not supported
tsquery Not supported
UUID The UUID type is not supported by release 1.0.
XML The XML type is not supported by release 1.0.
Arrays Array types are not supported by release 1.0.


Release 1.0 Cloud Reference Documentation 9


SQL Reference
Statement Description
ABORT Aborts the current transaction. Equivalent to ROLLBACK.
Operates as standard PostgreSQL. See ABORT
ALTER AGGREGATE Not available in the Cloud environment.
ALTER CONVERSION Not available in the Cloud environment.
ALTER DATABASE Not available in the Cloud environment.
ALTER DEFAULT PRIVILEGES Not available in the Cloud environment.
ALTER DOMAIN Not available in the Cloud environment.
ALTER FOREIGN DATA WRAPPER Not supported.
ALTER FUNCTION Changes the definition of a function. Operates as standard
PostgreSQL. See ALTER FUNCTION
ALTER GROUP Not available in the Cloud environment.
ALTER INDEX Has no effect on objects on JustOne tables.
ALTER LANGUAGE Not supported.
ALTER LARGE OBJECT Not supported.
ALTER OPERATOR Not supported.
ALTER OPR CLASS Not supported.
ALTER OPERATOR FAMILY Not supported.
ALTER ROLE Not available in the Cloud environment.
ALTER SCHEMA Changes the definition of a schema. Operates as standard
PostgreSQL. See ALTER SCHEMA
ALTER SEQUENCE Changes the definition of a sequence generator. Operates as
standard PostgreSQL. See ALTER SEQUENCE
ALTER SERVER Not available in the Cloud environment.
ALTER TABLE Alters a table definition. Operates as standard PostgreSQL except
for the following differences in release 1.0
 It is not possible to change a table’s schema
 It is not possible to add or drop a column
 It is not possible to alter a column data type
 SET STATISTICS is ignored
 Storage parameters are ignored
 Triggers cannot be enabled or disabled
 Clustering is not supported
 OIDs are not supported
 Inheritance is not supported
 It is not possible to change the tablespace
See ALTER TABLE
ALTER TABLESPACE Not available in the Cloud environment.
ALTER TEXT SEARCH Not supported.
CONFIGURATION
ALTER TEXT SEARCH DICTIONARY Not supported.
ALTER TEXT SEARCH PARSER Not supported.
ALTER TEXT SEARCH TEMPLATE Not supported.
ALTER TRIGGER Not supported in release 1.0.
ALTER TYPE Not supported.
ALTER USER Not available in the Cloud environment.
ALTER USER MAPPING Not available in the Cloud environment.
ALTER VIEW Changes the definition of a view. Operates as standard
Release 1.0 Cloud Reference Documentation 10

  • Accueil Accueil
  • Univers Univers
  • Ebooks Ebooks
  • Livres audio Livres audio
  • Presse Presse
  • BD BD
  • Documents Documents