Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
1001 things you wanted to know about Visual FoxPro [[electronic resource] /] / Marcia Akins, Andy Kramek, Rick Schummer
| 1001 things you wanted to know about Visual FoxPro [[electronic resource] /] / Marcia Akins, Andy Kramek, Rick Schummer |
| Autore | Akins Marcia |
| Pubbl/distr/stampa | Whitefish Bay, Wis., : Hentzenwerke Publishing, c2000 |
| Descrizione fisica | 1 online resource (584 p.) |
| Disciplina | 005.75/75 |
| Altri autori (Persone) | SchummerRick |
| Soggetto topico | Database management |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-280-54412-0
9786610544127 1-930919-09-3 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910456211203321 |
Akins Marcia
|
||
| Whitefish Bay, Wis., : Hentzenwerke Publishing, c2000 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
1001 things you wanted to know about Visual FoxPro [[electronic resource] /] / Marcia Akins, Andy Kramek, Rick Schummer
| 1001 things you wanted to know about Visual FoxPro [[electronic resource] /] / Marcia Akins, Andy Kramek, Rick Schummer |
| Autore | Akins Marcia |
| Pubbl/distr/stampa | Whitefish Bay, Wis., : Hentzenwerke Publishing, c2000 |
| Descrizione fisica | 1 online resource (584 p.) |
| Disciplina | 005.75/75 |
| Altri autori (Persone) | SchummerRick |
| Soggetto topico | Database management |
| ISBN |
1-280-54412-0
9786610544127 1-930919-09-3 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910780262903321 |
|
Akins Marcia
|
||
| Whitefish Bay, Wis., : Hentzenwerke Publishing, c2000 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
1001 things you wanted to know about Visual FoxPro / / Marcia Akins, Andy Kramek, Rick Schummer
| 1001 things you wanted to know about Visual FoxPro / / Marcia Akins, Andy Kramek, Rick Schummer |
| Autore | Akins Marcia |
| Pubbl/distr/stampa | Whitefish Bay, Wis., : Hentzenwerke Publishing, c2000 |
| Descrizione fisica | 1 online resource (584 p.) |
| Disciplina | 005.75/75 |
| Altri autori (Persone) | SchummerRick |
| Soggetto topico | Database management |
| ISBN |
1-280-54412-0
9786610544127 1-930919-09-3 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Intro -- Dedications -- List of Chapters -- Table of Contents -- Our Contract with You, The Reader -- Acknowledgements -- About Us -- How to Download the Files -- Introduction -- What is this book? -- A word about the code in this book -- So who is this book for? -- What is in this book? -- What is not in this book? -- Where do you start? -- Chapter 1 Controlling the VFP Environment -- Starting Visual FoxPro -- Configuration files -- How to specify a config.fpw file -- How VFP locates its configuration file -- How VFP starts up when no configuration file is found -- Including a configuration file in the project -- How to suppress a configuration file -- How to determine which configuration file is being used -- What goes into the configuration file? -- Special settings -- SET Commands -- Commands -- Giving VFP a path -- How VFP looks for files -- Setting the default directory -- Using the SET PATH command -- Where am I? -- How to set a path programmatically -- Making sure VFP is only started once -- Using a 'semaphore' file -- Using the Windows API -- Combination of semaphore and Windows API -- SET Commands and DataSessions -- What exactly does "Default DataSession" mean? -- So can I have a "public" Datasession? -- How can I ensure SET commands apply to a private data session? -- Adding code to BeforeOpenTables() -- Suppressing auto-open tables -- Creating an environment setting class -- How do I get rid of the system toolbars? -- The system toolbar "Gotcha! -- Can I make use of keyboard macros in VFP? -- How can I construct a more complex macro? -- What is a "Macro Set"? -- What's the difference between a macro and an On Key Label? -- How do I create a 'Splash' screen? -- How do I run my splash screen? -- An alternative to the splash screen -- How to wallpaper your desktop -- So how can I get the size of the current _Screen area?.
Do I really need to create all these bitmaps? -- A toolbar 'gotcha!' -- Tidying up your development environment -- Closing VFP down -- What is an On ShutDown procedure? -- What triggers an On Shutdown procedure? -- What goes into an On Shutdown procedure? -- Chapter 2 Functions and Procedures -- How shall we proceed? -- Parameters (an aside) -- By reference, by value? -- How do I know what was passed? -- How should I position my parameters? -- How can I return multiple values from a function? -- What about using named parameters? -- Passing parameters optionally -- Date and time functions -- Elapsed time -- Date in words -- Calculating Age -- What date is the second Tuesday in October of 2000? -- Setting up a payment schedule -- What date is ten business days from today? -- Gotcha! Strict date format and parameterized views -- Working with numbers -- Converting numbers to strings -- Gotcha! calculations that involve money -- String functions -- Gotcha! string concatenation -- Converting between strings and data -- Other useful functions -- How do I determine if a tag exists? -- How do I determine if a string contains at least one alphabetic character? -- How to convert numbers to words -- How to extract a specified item from a list -- Is there a simple way of encrypting passwords? -- Where do you want to GOTO? -- Chapter 3 Design, Design and Nothing Else -- So why all the fuss about OOP anyway? -- So, just what does all this OOP jargon mean? -- Property -- Method -- Event -- Messages -- Classes and Objects -- Inheritance -- Composition -- Aggregation -- Delegation -- Encapsulation -- Polymorphism -- Hierarchies -- Practical object oriented programming (POOP) -- When should you define a class? -- So how do you go about designing a class? -- This all sounds very good but what does it mean in practice? -- How do you go about building your classes?. But does all this design stuff really work in practice? -- How does the design actually translate into code? -- Working with your classes -- How do I get my classes into the form controls toolbar? -- While we're at it, how can I identify my custom classes in the toolbar? -- But whenever I want white in my bitmaps it shows up gray! -- How do I make Visual FoxPro use my classes instead of base classes? -- How do I change the caption of the label that VFP adds? -- So can I get a browse to show the field name when a caption is set? -- User interface design -- Perception governs acceptance -- Keep your users focussed -- Use the right control for the job -- Chapter 4 Basic Controls -- What do we mean by 'basic'? -- Text boxes -- Text box label class -- Date text box -- Incremental search text box -- Numeric text box -- Handling time -- A time entry text box -- A time entry composite class -- The true time spinner -- Blinking labels -- The expanding edit box -- Calendar combo -- Command buttons -- Gotcha! Programming the logical controls -- Pages and page frames -- Chapter 5 Combos and Lists -- Combo and list box basics -- List and ListItem collections -- When do the events fire? -- How do I bind my combo and list boxes? -- How do I refer to the items in my combo and list boxes? -- What is the difference between DisplayValue and Value? -- What's the difference between RowSourceTypes "alias" and "fields"? -- How do I make my combo and list boxes point to a particular item? -- Quickfill combos -- How do I add new items to my combo and list boxes? -- How do I filter the items displayed in a second combo or list box based on the selection made in the first? -- A word about lookup tables -- Generic lookup combos and lists -- So what if I want to bind my combo to a value that isn't in the list? -- How do I disable individual items in a combo or list?. How do I create a list box with check boxes like the one displayed by Visual FoxPro when I select "View Toolbars" from the menu? -- A mover list class -- What if I need to display hundreds of items in my combo box? -- Chapter 6 Grids: The Misunderstood Controls -- When do the events fire? -- Gotcha! Grid's valid fires before the valid of the current control -- What is the difference between ActiveRow and RelativeRow? -- Gotcha! ActiveColumn does not really tell you which is the active column -- How do I highlight the current grid row? -- How do I keep my grid from scrolling when the user tabs off the last column? -- How do I create multiline headers? -- Gotcha! Scrolled event does not fire when cursor keys scroll the grid -- Using tool tip text instead of multiline headers -- How do I change the grid's display order? -- How do I control the cursor? -- How do I display the last full page of a grid? -- How do I use a grid to select one or more rows? -- How do I give my multiselect grid incremental search capability? -- How do I use DynamicCurrentControl? -- How do I filter the contents of a grid? -- So what about data entry grids? -- How do I add new records to my grid? -- How do I handle row level validation in my data entry grid? -- How do I delete records in my data entry grid? -- How do I add a combo box to my grid? -- Conclusion -- Chapter 7 Working with Data -- Tables in Visual FoxPro -- Some basics -- How to open the specific table you want to use -- How to get the structure of a table -- How to compare the structures of two tables? -- How to test for the presence of a field in a table -- How to check if a table is being used by another user -- What is exactly is a cursor? -- Indexes in Visual FoxPro -- Types of indexes -- How to get information about an index -- How to test for the existence of an index tag -- Using candidate (and primary) keys. What is a "surrogate key"? -- Managing user-entered keys -- Using indexes with bound tables -- How to index mixed data types when creating a compound key -- How to index a buffered table -- Working with the database container -- Using long table names -- Using long field names - don't!!! -- Using database containers -- How to validate a database container -- How to pack a database container -- Moving a database container -- Renaming a database container -- Managing referential integrity in Visual FoxPro -- Limitations of the generated RI Code -- Using compound keys in relationships -- What about other RI options? -- Using triggers and rules in Visual FoxPro -- So what's the practical difference between a 'trigger' and a 'rule'? -- Why, when adding a trigger to a table, does VFP sometimes reject it? -- Can I temporarily disable a trigger or rule then? -- How do I actually create my trigger and rule procedures? -- How do I add a trigger to a table? -- So when should I use a trigger? -- And when should I use a rule? -- Must a trigger or rule always refer to a single function? -- Chapter 8 Data Buffering and Transactions -- Using data buffering -- Where are we coming from? -- What do we mean by 'buffering' anyway? -- What does all this mean when creating data-bound forms? -- So just how do I set up buffering in a form? -- So what mode of buffering should I use in my forms? -- Changing the buffer mode of a table -- IsChanged() - another function that FoxPro forgot? -- Using TableUpdate() and TableRevert() -- Managing the scope of updates -- TableUpdate()'s second (force) parameter -- Specifying the table to be updated or reverted -- Conclusion -- How can I handle 'save' and 'undo' functionality generically? -- The design of the form class -- Using the new form class -- Detecting and resolving conflicts -- The role of OldVal() and CurVal(). So how do I actually detect conflicts?. |
| Altri titoli varianti | Thousand and one things you wanted to know about Visual FoxPro |
| Record Nr. | UNINA-9910970090203321 |
|
Akins Marcia
|
||
| Whitefish Bay, Wis., : Hentzenwerke Publishing, c2000 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Deploying Oracle 9iRAC on IBM e-server Cluster 1600 with GPFS [[electronic resource] /] / [Octavian Lascu ... et al.]
| Deploying Oracle 9iRAC on IBM e-server Cluster 1600 with GPFS [[electronic resource] /] / [Octavian Lascu ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Poughkeepsie, NY, : IBM, International Technical Support Organization, c2003 |
| Descrizione fisica | xii, 248 p. : ill |
| Disciplina | 005.75/75 |
| Altri autori (Persone) | LascuOctavian |
| Collana | IBM redbooks |
| Soggetto topico |
Database design
Web servers |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910450250103321 |
| Poughkeepsie, NY, : IBM, International Technical Support Organization, c2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Deploying Oracle 9iRAC on IBM e-server Cluster 1600 with GPFS [[electronic resource] /] / [Octavian Lascu ... et al.]
| Deploying Oracle 9iRAC on IBM e-server Cluster 1600 with GPFS [[electronic resource] /] / [Octavian Lascu ... et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Poughkeepsie, NY, : IBM, International Technical Support Organization, c2003 |
| Descrizione fisica | xii, 248 p. : ill |
| Disciplina | 005.75/75 |
| Altri autori (Persone) | LascuOctavian |
| Collana | IBM redbooks |
| Soggetto topico |
Database design
Web servers |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783394703321 |
| Poughkeepsie, NY, : IBM, International Technical Support Organization, c2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
OCA [[electronic resource] ] : Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052) / / Biju Thomas
| OCA [[electronic resource] ] : Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052) / / Biju Thomas |
| Autore | Thomas Biju |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Indianapolis, Ind., : Wiley Pub., 2009 |
| Descrizione fisica | 1 online resource (1158 p.) |
| Disciplina | 005.75/75 |
| Collana | Serious skills |
| Soggetto topico |
Electronic data processing personnel - Certification
Database management - Examinations |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-118-05942-5
1-282-55025-X 9786612550256 0-470-48834-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
OCA Oracle® Database 11g Administrator Certified Associate Study Guide; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; SQL Fundamentals I Assessment Test; Answers to SQL Fundamentals I Assessment Test; Administration I Assessment Test; Answers to Administration I Assessment Test; Part I: Oracle Database 11g: SQL Fundamentals I; Chapter 1: Introducing SQL; SQL Fundamentals; Writing Simple Queries; Accepting Values at Runtime; Summary; Exam Essentials; Untitled; Review Questions; Answers to Review Questions; Chapter 2: Using Single-Row Functions
Single-Row Function FundamentalsUsing Single-Row Character Functions; Using Single-Row Numeric Functions; Using Single-Row Date Functions; Using Single-Row Conversion Functions; Using Other Single-Row Functions; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 3: Using Group Functions; Group-Function Fundamentals; Utilizing Aggregate Functions; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 4: Using Joins and Subqueries; Writing Multiple-Table Queries; Using Set Operators; Subqueries; Summary; Exam Essentials; Review Questions Answers to Review QuestionsChapter 5: Manipulating Data; Using DML Statements; Understanding Transaction Control; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 6: Creating Tables and Constraints; Database Objects Overview; Built-in Datatypes; Creating Tables; Modifying Tables; Managing Constraints; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 7: Creating Schema Objects; Creating and Modifying Views; Creating and Managing Sequences; Creating and Managing Synonyms; Creating and Managing Indexes; Summary; Exam Essentials Review QuestionsAnswers to Review Questions; Part II: Oracle Database 11g: Administration I; Chapter 8: Introducing Oracle Database 11g Components and Architecture; Oracle Database Fundamentals; Oracle 11g Architecture; Installing Oracle 11g; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 9: Creating an Oracle 11g Database; Using DBCA to Create Oracle 11g Databases; Working with Oracle 11g Metadata; Managing Initialization-Parameter Files; Starting Up and Shutting Down an Oracle Instance; Monitoring the Database Alert Log; Summary; Exam Essentials Review QuestionsAnswers to Review Questions; Chapter 10: Allocating Database Storage and Creating Schema Objects; Tablespaces and Data Files Overview; Managing Tablespaces; Managing Data Files; Working with Schema Objects; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 11: Understanding Network Architecture; Introducing Network Configurations; An Overview of Oracle Net Features; Configuring Oracle Net on the Server; Configuring Oracle Net for the Client; An Overview of Oracle Shared Server; Oracle Shared Server Infrastructure; Summary; Exam Essentials Review Questions |
| Record Nr. | UNINA-9910459480003321 |
|
Thomas Biju
|
||
| Indianapolis, Ind., : Wiley Pub., 2009 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
OCA [[electronic resource] ] : Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052) / / Biju Thomas
| OCA [[electronic resource] ] : Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052) / / Biju Thomas |
| Autore | Thomas Biju |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Indianapolis, Ind., : Wiley Pub., 2009 |
| Descrizione fisica | 1 online resource (1158 p.) |
| Disciplina | 005.75/75 |
| Collana | Serious skills |
| Soggetto topico |
Electronic data processing personnel - Certification
Database management - Examinations |
| ISBN |
1-118-05942-5
1-282-55025-X 9786612550256 0-470-48834-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
OCA Oracle® Database 11g Administrator Certified Associate Study Guide; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; SQL Fundamentals I Assessment Test; Answers to SQL Fundamentals I Assessment Test; Administration I Assessment Test; Answers to Administration I Assessment Test; Part I: Oracle Database 11g: SQL Fundamentals I; Chapter 1: Introducing SQL; SQL Fundamentals; Writing Simple Queries; Accepting Values at Runtime; Summary; Exam Essentials; Untitled; Review Questions; Answers to Review Questions; Chapter 2: Using Single-Row Functions
Single-Row Function FundamentalsUsing Single-Row Character Functions; Using Single-Row Numeric Functions; Using Single-Row Date Functions; Using Single-Row Conversion Functions; Using Other Single-Row Functions; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 3: Using Group Functions; Group-Function Fundamentals; Utilizing Aggregate Functions; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 4: Using Joins and Subqueries; Writing Multiple-Table Queries; Using Set Operators; Subqueries; Summary; Exam Essentials; Review Questions Answers to Review QuestionsChapter 5: Manipulating Data; Using DML Statements; Understanding Transaction Control; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 6: Creating Tables and Constraints; Database Objects Overview; Built-in Datatypes; Creating Tables; Modifying Tables; Managing Constraints; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 7: Creating Schema Objects; Creating and Modifying Views; Creating and Managing Sequences; Creating and Managing Synonyms; Creating and Managing Indexes; Summary; Exam Essentials Review QuestionsAnswers to Review Questions; Part II: Oracle Database 11g: Administration I; Chapter 8: Introducing Oracle Database 11g Components and Architecture; Oracle Database Fundamentals; Oracle 11g Architecture; Installing Oracle 11g; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 9: Creating an Oracle 11g Database; Using DBCA to Create Oracle 11g Databases; Working with Oracle 11g Metadata; Managing Initialization-Parameter Files; Starting Up and Shutting Down an Oracle Instance; Monitoring the Database Alert Log; Summary; Exam Essentials Review QuestionsAnswers to Review Questions; Chapter 10: Allocating Database Storage and Creating Schema Objects; Tablespaces and Data Files Overview; Managing Tablespaces; Managing Data Files; Working with Schema Objects; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 11: Understanding Network Architecture; Introducing Network Configurations; An Overview of Oracle Net Features; Configuring Oracle Net on the Server; Configuring Oracle Net for the Client; An Overview of Oracle Shared Server; Oracle Shared Server Infrastructure; Summary; Exam Essentials Review Questions |
| Record Nr. | UNINA-9910792353103321 |
|
Thomas Biju
|
||
| Indianapolis, Ind., : Wiley Pub., 2009 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
OCA : Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052) / / Biju Thomas
| OCA : Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052) / / Biju Thomas |
| Autore | Thomas Biju |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Indianapolis, Ind., : Wiley Pub., 2009 |
| Descrizione fisica | 1 online resource (1158 p.) |
| Disciplina | 005.75/75 |
| Collana | Serious skills |
| Soggetto topico |
Electronic data processing personnel - Certification
Database management - Examinations |
| ISBN |
9786612550256
9781118059425 1118059425 9781282550254 128255025X 9780470488348 0470488344 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
OCA Oracle® Database 11g Administrator Certified Associate Study Guide; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; SQL Fundamentals I Assessment Test; Answers to SQL Fundamentals I Assessment Test; Administration I Assessment Test; Answers to Administration I Assessment Test; Part I: Oracle Database 11g: SQL Fundamentals I; Chapter 1: Introducing SQL; SQL Fundamentals; Writing Simple Queries; Accepting Values at Runtime; Summary; Exam Essentials; Untitled; Review Questions; Answers to Review Questions; Chapter 2: Using Single-Row Functions
Single-Row Function FundamentalsUsing Single-Row Character Functions; Using Single-Row Numeric Functions; Using Single-Row Date Functions; Using Single-Row Conversion Functions; Using Other Single-Row Functions; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 3: Using Group Functions; Group-Function Fundamentals; Utilizing Aggregate Functions; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 4: Using Joins and Subqueries; Writing Multiple-Table Queries; Using Set Operators; Subqueries; Summary; Exam Essentials; Review Questions Answers to Review QuestionsChapter 5: Manipulating Data; Using DML Statements; Understanding Transaction Control; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 6: Creating Tables and Constraints; Database Objects Overview; Built-in Datatypes; Creating Tables; Modifying Tables; Managing Constraints; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 7: Creating Schema Objects; Creating and Modifying Views; Creating and Managing Sequences; Creating and Managing Synonyms; Creating and Managing Indexes; Summary; Exam Essentials Review QuestionsAnswers to Review Questions; Part II: Oracle Database 11g: Administration I; Chapter 8: Introducing Oracle Database 11g Components and Architecture; Oracle Database Fundamentals; Oracle 11g Architecture; Installing Oracle 11g; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 9: Creating an Oracle 11g Database; Using DBCA to Create Oracle 11g Databases; Working with Oracle 11g Metadata; Managing Initialization-Parameter Files; Starting Up and Shutting Down an Oracle Instance; Monitoring the Database Alert Log; Summary; Exam Essentials Review QuestionsAnswers to Review Questions; Chapter 10: Allocating Database Storage and Creating Schema Objects; Tablespaces and Data Files Overview; Managing Tablespaces; Managing Data Files; Working with Schema Objects; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 11: Understanding Network Architecture; Introducing Network Configurations; An Overview of Oracle Net Features; Configuring Oracle Net on the Server; Configuring Oracle Net for the Client; An Overview of Oracle Shared Server; Oracle Shared Server Infrastructure; Summary; Exam Essentials Review Questions |
| Altri titoli varianti | Oracle database 11g administrator certified associate study guide |
| Record Nr. | UNINA-9910967902403321 |
|
Thomas Biju
|
||
| Indianapolis, Ind., : Wiley Pub., 2009 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle Warehouse Builder 11g [[electronic resource] ] : getting started : extract, transform, and load data to build a dynamic, operational data warehouse / / Bob Griesemer ; reviewers, Anitha Kadaru, Yasodarani Venkatesan
| Oracle Warehouse Builder 11g [[electronic resource] ] : getting started : extract, transform, and load data to build a dynamic, operational data warehouse / / Bob Griesemer ; reviewers, Anitha Kadaru, Yasodarani Venkatesan |
| Autore | Griesemer Bob |
| Pubbl/distr/stampa | Birmingham, UK, : Packt Publishing, 2009 |
| Descrizione fisica | 1 online resource (368 p.) |
| Disciplina | 005.75/75 |
| Altri autori (Persone) |
KadaruAnitha
VenkatesanYasodarani |
| Collana | From technologies to solutions |
| Soggetto topico |
Data warehousing
Database management |
| Soggetto genere / forma | Electronic books. |
| ISBN |
9786612257292
1-282-25729-3 1-84719-575-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Table of Contents; Preface; Chapter 1: An Introduction to Oracle Warehouse Builder; Introduction to data warehousing; Introduction to our fictional organization; What is a data warehouse?; Where does OWB fit in?; Installation of the database and OWB; Downloading the Oracle software; A word about hardware and operating systems; Installing Oracle database software; Configuring the listener; Creating the database; Installing the OWB standalone software; OWB components and architecture; Configuring the repository and workspaces; Summary
Chapter 2: Defining and Importing Source Data StructuresPreliminary analysis; ACME Toys and Gizmos source data; The POS transactional source database; The web site order management database; An overview of Warehouse Builder Design Center; Importing/defining source metadata; Creating a project; Creating a module; Creating an Oracle Database module; Creating a SQL Server database module; Importing source metadata from a database; Defining source metadata manually with the Data Object Editor; Importing source metadata from files; Summary; Chapter 3: Designing the Target Structure Data warehouse designDimensional design; Cube and dimensions; Implementation of a dimensional model in a database; Relational implementation (star schema); Multidimensional implementation (OLAP); Designing the ACME data warehouse; Identifying the dimensions; Designing the cube; Data warehouse design in OWB; Creating a target user and module; Create a target user; Create a target module; OWB design objects; Summary; Chapter 4: Creating the Target Structure in OWB; Creating dimensions in OWB; The Time dimension; Creating a Time dimension with the Time Dimension Wizard; The Product dimension Product Attributes (attribute type)Product Levels; Product Hierarchy (highest to lowest); Creating the Product dimension with the New Dimension Wizard; The Store dimension; Store Attributes (attribute type), data type and size, and (Identifier); Store Levels; Store Hierarchy (highest to lowest); Creating the Store dimension with the New Dimension Wizard; Creating a cube in OWB; Creating a cube with the wizard; Using the Data Object Editor; Summary; Chapter 5: Extract, Transform, and Load Basics; ETL; Manual ETL processes; Staging; To stage or not to stage; Configuration of a staging area Mappings and operators in OWBThe canvas layout; OWB operators; Source and target operators; Data flow operators; Pre/post-processing operators; Summary; Chapter 6: ETL: Putting it Together; Designing and building an ETL mapping; Designing our staging area; Designing the staging area contents; Building the staging area table with the Data Object Editor; Designing our mapping; Review of the Mapping Editor; Creating a mapping; Summary; Chapter 7: ETL: Transformations and Other Operators; STORE mapping; Adding source and target operators; Adding Transformation Operators Using a Key Lookup operator |
| Record Nr. | UNINA-9910456634703321 |
|
Griesemer Bob
|
||
| Birmingham, UK, : Packt Publishing, 2009 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle Warehouse Builder 11g [[electronic resource] ] : getting started : extract, transform, and load data to build a dynamic, operational data warehouse / / Bob Griesemer ; reviewers, Anitha Kadaru, Yasodarani Venkatesan
| Oracle Warehouse Builder 11g [[electronic resource] ] : getting started : extract, transform, and load data to build a dynamic, operational data warehouse / / Bob Griesemer ; reviewers, Anitha Kadaru, Yasodarani Venkatesan |
| Autore | Griesemer Bob |
| Pubbl/distr/stampa | Birmingham, UK, : Packt Publishing, 2009 |
| Descrizione fisica | 1 online resource (368 p.) |
| Disciplina | 005.75/75 |
| Altri autori (Persone) |
KadaruAnitha
VenkatesanYasodarani |
| Collana | From technologies to solutions |
| Soggetto topico |
Data warehousing
Database management |
| ISBN |
9786612257292
1-282-25729-3 1-84719-575-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Table of Contents; Preface; Chapter 1: An Introduction to Oracle Warehouse Builder; Introduction to data warehousing; Introduction to our fictional organization; What is a data warehouse?; Where does OWB fit in?; Installation of the database and OWB; Downloading the Oracle software; A word about hardware and operating systems; Installing Oracle database software; Configuring the listener; Creating the database; Installing the OWB standalone software; OWB components and architecture; Configuring the repository and workspaces; Summary
Chapter 2: Defining and Importing Source Data StructuresPreliminary analysis; ACME Toys and Gizmos source data; The POS transactional source database; The web site order management database; An overview of Warehouse Builder Design Center; Importing/defining source metadata; Creating a project; Creating a module; Creating an Oracle Database module; Creating a SQL Server database module; Importing source metadata from a database; Defining source metadata manually with the Data Object Editor; Importing source metadata from files; Summary; Chapter 3: Designing the Target Structure Data warehouse designDimensional design; Cube and dimensions; Implementation of a dimensional model in a database; Relational implementation (star schema); Multidimensional implementation (OLAP); Designing the ACME data warehouse; Identifying the dimensions; Designing the cube; Data warehouse design in OWB; Creating a target user and module; Create a target user; Create a target module; OWB design objects; Summary; Chapter 4: Creating the Target Structure in OWB; Creating dimensions in OWB; The Time dimension; Creating a Time dimension with the Time Dimension Wizard; The Product dimension Product Attributes (attribute type)Product Levels; Product Hierarchy (highest to lowest); Creating the Product dimension with the New Dimension Wizard; The Store dimension; Store Attributes (attribute type), data type and size, and (Identifier); Store Levels; Store Hierarchy (highest to lowest); Creating the Store dimension with the New Dimension Wizard; Creating a cube in OWB; Creating a cube with the wizard; Using the Data Object Editor; Summary; Chapter 5: Extract, Transform, and Load Basics; ETL; Manual ETL processes; Staging; To stage or not to stage; Configuration of a staging area Mappings and operators in OWBThe canvas layout; OWB operators; Source and target operators; Data flow operators; Pre/post-processing operators; Summary; Chapter 6: ETL: Putting it Together; Designing and building an ETL mapping; Designing our staging area; Designing the staging area contents; Building the staging area table with the Data Object Editor; Designing our mapping; Review of the Mapping Editor; Creating a mapping; Summary; Chapter 7: ETL: Transformations and Other Operators; STORE mapping; Adding source and target operators; Adding Transformation Operators Using a Key Lookup operator |
| Record Nr. | UNINA-9910780781803321 |
|
Griesemer Bob
|
||
| Birmingham, UK, : Packt Publishing, 2009 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
