Posts in category: Databases
By Rick Copeland
"'Essential SQLAlchemy' richtet sich an Python-Entwickler, die eine SQL-Schnittstelle sowie einen item Relational Mapper nutzen wollen - die SQLAlchemy-Bibliothek [...]" - iX, August 2009 "SQLAlchemy ist in Python-Kreisen verbreitet und erfreut sich mittlerweile großer Beliebtheit - leider fehlte bisher aber eine umfassende Dokumentation, die die Möglichkeiten von SQLAlchemy angemessen darstellt. Das vorliegende Buch aus dem O'Reilly Verlag schafft hier Abhilfe, erläutert den Umgang und die Handhabung auf nachvollziehbare Weise und liefert diesbezüglich jede Menge nützlicher Beispiele sowie viel fabric für die sofortige Verwendung." - entwickler-magazin, Februar 2009
Essential SQLAlchemy introduces a high-level open-source code library that makes it more uncomplicated for Python programmers to entry relational databases reminiscent of Oracle, DB2, MySQL, PostgreSQL, and SQLite. SQLAlchemy has develop into more and more renowned when you consider that its unencumber, however it nonetheless lacks sturdy offline documentation. This useful booklet fills the space, and since a developer wrote it, you get an goal examine SQLAlchemy's instruments instead of an advocate's description of all of the "cool" positive aspects. SQLAlchemy comprises either a database server-independent SQL expression language and an object-relational mapper (ORM) that permits you to map "plain previous Python items" (POPOs) to database tables with no considerably altering your latest Python code. crucial SQLAlchemy demonstrates tips to use the library to create an easy database software, walks you thru uncomplicated queries, and explains how you can use SQLAlchemy to connect with a number of databases concurrently with an analogous Metadata. you furthermore mght the right way to: * Create customized varieties for use on your schema, and while it is valuable to exploit customized instead of integrated kinds * Run queries, updates, and deletes with SQLAlchemy's SQL expression language * construct an item mapper with SQLAlchemy, and comprehend the variations among this and lively checklist styles utilized in different ORMs * Create gadgets, retailer them to a consultation, and flush them to the database * Use SQLAlchemy to version item orientated inheritance * supply a declarative, lively list development to be used with SQLAlchemy utilizing the Elixir extension * Use the SQLSoup extension to supply an automated metadata and item version in response to database mirrored image furthermore, you will learn the way and while to exploit different extensions to SQLAlchemy, together with AssociationProxy, OrderingList, and extra. crucial SQLAlchemy is the much-needed consultant for each Python developer utilizing this code library. rather than a feature-by-feature documentation, this booklet takes an "essentials" method that offers you precisely what you want to develop into efficient with SQLAlchemy instantly.
By Moran R
By Glenn Berry
By Markus Winand
By Biju Thomas, Bob Bryla
Oracle is the best database out there, placing Oracle database directors in excessive call for. Oracle lately restructured their certification software into 3 ranges - OCA (Oracle qualified Associate), OCP (...Professional), and OCM (...Master). the 1st stages are examination dependent, whereas the 3rd tier (Master) calls for the candidate to cross a hands-on examination in a lab setting. applicants needs to move assessments for the OCA certification, and an extra for the OCP. This booklet covers the Oracle9i DBA basics I examination, the second one examination required for all 3 degrees.
By Stefan Büttcher
Information retrieval is the basis for contemporary se's. This textbook deals an advent to the middle subject matters underlying smooth seek applied sciences, together with algorithms, information buildings, indexing, retrieval, and evaluate. The emphasis is on implementation and experimentation; every one bankruptcy comprises routines and proposals for pupil initiatives. Wumpus -- a multiuser open-source details retrieval approach constructed by means of one of many authors and on hand on-line -- presents version implementations and a foundation for scholar paintings. The modular constitution of the e-book permits teachers to take advantage of it in numerous graduate-level classes, together with classes taught from a database platforms standpoint, conventional details retrieval classes with a spotlight on IR idea, and classes overlaying the fundamentals of net retrieval. as well as its school room use, Information Retrieval might be a worthy reference for pros in machine technological know-how, machine engineering, and software program engineering.
By Geoff Ingram
"Geoff Ingram has met the problem of proposing the advanced technique of handling Oracle functionality. This booklet can help each technical individual trying to unravel Oracle8i and Oracle9i functionality issues."
-Aki Ratner, President, unique software program Solutions
making sure high-performance and non-stop availability of Oracle software program is a key concentration of database managers. a minimum of a dozen books tackle the topic of "performance tuning"-- that's, find out how to fine-tune the Oracle database for its maximum processing potency. Geoff Ingram argues that this procedure easily isn't really sufficient. He believes that functionality has to be addressed correct from the layout level, and it must disguise the full system--not simply the database.
High-Performance Oracle is a hands-on ebook, loaded with assistance and strategies for making sure that the complete Oracle database procedure runs successfully and does not holiday down. Written for Oracle builders and DBAs, and masking either Oracle8i and Oracle9i, the e-book is going past conventional performance-tuning books and covers the major thoughts for making sure 24/7 functionality and availability of the total Oracle system.
The ebook offers sensible strategies for:
* determining actual structure for ease of management and effective use of space
* handling indexes, together with detecting unused indexes and automating rebuilds
* SQL and process tuning utilizing the robust new beneficial properties in Oracle9i unlock 2
* bettering SQL functionality with out enhancing code
* working Oracle genuine software Clusters (RAC) for functionality and availability
* holding information utilizing recuperate supervisor (RMAN), and actual and logical standby databases
The better half website offers the whole resource code for examples within the booklet, updates on suggestions, and extra documentation for optimizing your Oracle process.
By Toby J. Teorey
Database Modeling and layout specializes in suggestions for database layout in relational database structures. The ebook discusses the entity-relationship strategy and the unified modeling language strategy; either are used during the booklet while it refers to logical database layout for the specification of information specifications and conceptual modeling.
The booklet starts off with an outline of the existence cycle of databases, and it is going directly to speak about the entity-relationship version and unified modeling languages. It demonstrates how info modeling strategies are utilized in the method of database layout. The booklet covers database normalization, together with information regarding equivalence at the functionality of the entity-relationship and unified modeling language conceptual versions, and the relational version of the Boyce Codd common shape.
The publication explores the variation among object-oriented database platforms and relational database platforms. It contains a description on dealing with the impedance mismatch challenge via the extensions made to relational platforms. internet applied sciences, together with an outline and particular database layout matters on XML, also are lined during this e-book. finally, IBMs Rational facts Architect, laptop affiliates AllFusion ERwin facts Modeler, and Sysbases PowerDesigner are mentioned, and their makes use of for dealing with advanced info modeling difficulties are validated.
This booklet will function a consultant for either amateur and skilled expert database practitioners.
- In-depth aspect and many real-world, functional examples throughout
- Loaded with layout ideas and illustrative case experiences which are acceptable to any SQL, UML, or XML-based approach
- Immediately priceless to an individual tasked with the construction of information types for the combination of large-scale firm information.