Databases

Get up to speed on the nuances of NoSQL databases and what they mean for your organization This easy to read guide to NoSQL databases provides the type of no-nonsense overview and analysis that you need to learn, including what NoSQL is and which database is right for you. Featuring specific evaluation criteria for NoSQL databases, along with a look into the pros and cons of the most popular options, NoSQL For Dummies provides the fastest and easiest way to dive into the details of this incredible technology. You'll gain an understanding of how to use NoSQL databases for mission-critical enterprise architectures and projects, and real-world examples reinforce the primary points to create an action-oriented resource for IT pros. If you're planning a big data project or platform, you probably already know you need to select a NoSQL database to complete your architecture. But with options flooding the market and updates and add-ons coming at a rapid pace, determining what you require now, and in the future, can be a tall task. This is where NoSQL For Dummies comes in! Learn the basic tenets of NoSQL databases and why they have come to the forefront as data has outpaced the capabilities of relational databases Discover major players among NoSQL databases, including Cassandra, MongoDB, MarkLogic, Neo4J, and others Get an in-depth look at the benefits and disadvantages of the wide variety of NoSQL database options Explore the needs of your organization as they relate to the capabilities of specific NoSQL databases Big data and Hadoop get all the attention, but when it comes down to it, NoSQL databases are the engines that power many big data analytics initiatives. With NoSQL For Dummies, you'll go beyond relational databases to ramp up your enterprise's data architecture in no time.

Let Hadoop For Dummies help harness the power of your data and rein in the information overload Big data has become big business, and companies and organizations of all sizes are struggling to find ways to retrieve valuable information from their massive data sets with becoming overwhelmed. Enter Hadoop and this easy-to-understand For Dummies guide. Hadoop For Dummies helps readers understand the value of big data, make a business case for using Hadoop, navigate the Hadoop ecosystem, and build and manage Hadoop applications and clusters. Explains the origins of Hadoop, its economic benefits, and its functionality and practical applications Helps you find your way around the Hadoop ecosystem, program MapReduce, utilize design patterns, and get your Hadoop cluster up and running quickly and easily Details how to use Hadoop applications for data mining, web analytics and personalization, large-scale text processing, data science, and problem-solving Shows you how to improve the value of your Hadoop cluster, maximize your investment in Hadoop, and avoid common pitfalls when building your Hadoop cluster From programmers challenged with building and maintaining affordable, scaleable data systems to administrators who must deal with huge volumes of information effectively and efficiently, this how-to has something to help you with Hadoop.

Demystifying the power of the Oracle 12c database The Oracle database is the industry-leading relational database management system (RDMS) used from small companies to the world’s largest enterprises alike for their most critical business and analytical processing. Oracle 12c includes industry leading enhancements to enable cloud computing and empowers users to manage both Big Data and traditional data structures faster and cheaper than ever before. Oracle 12c For Dummies is the perfect guide for a novice database administrator or an Oracle DBA who is new to Oracle 12c. The book covers what you need to know about Oracle 12c architecture, software tools, and how to successfully manage Oracle databases in the real world. Highlights the important features of Oracle 12c Explains how to create, populate, protect, tune, and troubleshoot a new Oracle database Covers advanced Oracle 12c technologies including Oracle Multitenant—the "pluggable database" concept—as well as several other key changes in this release Make the most of Oracle 12c's improved efficiency, stronger security, and simplified management capabilities with Oracle 12c For Dummies.

Here's what you should know to manage data records efficiently With proper electronic data management, your business can lower costs, improve efficiency, eliminate duplication, and be protected in the event of a lawsuit. This book provides an overview of records management solutions and implementation strategies in plain, non-technical English. Step-by-step instructions show you how to begin managing records and information and how to maintain the program once you have it established. Sample forms for inventory, scheduling, and necessary documentation are also available on the companion website. Electronic records management offers cost savings, greater efficiency, and protection in case of legal action; this book gets you started on an effective data management system This plain-English guide helps you determine what constitutes a record, shows you how to inventory records and create an efficient way to file both electronic and paper copies, and explains how to create a retention schedule Walks you through switching to electronic record-keeping, what to look for in a records management system, implementing best practices, ensuring that your system will stay current, and using the system effectively Helps you assure that the destruction of any sensitive information is conducted and documented correctly Records Management For Dummies helps your business save money and improve efficiency with effective electronic records management.

The fun and easy way to learn to use this leading business intelligence tool Written by an author team who is directly involved with SAS, this easy-to-follow guide is fully updated for the latest release of SAS and covers just what you need to put this popular software to work in your business. SAS allows any business or enterprise to improve data delivery, analysis, reporting, movement across a company, data mining, forecasting, statistical analysis, and more. SAS For Dummies, 2nd Edition  gives you the necessary background on what SAS can do for you and explains how to use the Enterprise Guide. SAS provides statistical and data analysis tools to help you deal with all kinds of data: operational, financial, performance, and more Places special emphasis on Enterprise Guide and other analytical tools, covering all commonly used features Covers all commonly used features and shows you the practical applications you can put to work in your business Explores how to get various types of data into the software and how to work with databases Covers producing reports and Web reporting tools, analytics, macros, and working with your data In the easy-to-follow, no-nonsense For Dummies format, SAS For Dummies gives you the knowledge and the confidence to get SAS working for your organization. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Data warehousing is one of the hottest business topics, and there’s more to understanding data warehousing technologies than you might think. Find out the basics of data warehousing and how it facilitates data mining and business intelligence with Data Warehousing For Dummies, 2nd Edition. Data is probably your company’s most important asset, so your data warehouse should serve your needs. The fully updated Second Edition of Data Warehousing For Dummies helps you understand, develop, implement, and use data warehouses, and offers a sneak peek into their future. You’ll learn to: Analyze top-down and bottom-up data warehouse designs Understand the structure and technologies of data warehouses, operational data stores, and data marts Choose your project team and apply best development practices to your data warehousing projects Implement a data warehouse, step by step, and involve end-users in the process Review and upgrade existing data storage to make it serve your needs Comprehend OLAP, column-wise databases, hardware assisted databases, and middleware Use data mining intelligently and find what you need Make informed choices about consultants and data warehousing products Data Warehousing For Dummies, 2nd Edition also shows you how to involve users in the testing process and gain valuable feedback, what it takes to successfully manage a data warehouse project, and how to tell if your project is on track. You’ll find it’s the most useful source of data on the topic!

If you’ve asked yourself “Why can’t I develop database and XML queries in a language I already know?”, then Language INtegrated Query, or LINQ, is for you. LINQ For Dummies introduces you to LINQ and the .NET Framework technologies, so you can use LINQ to query any object, any data set, any kind of XML, and SQL Server—no questions asked. This plain-English guide gives you a thorough overview of LINQ, from understanding the tasks it performs to making LINQ work with both Visual Basic and Visual Studio 2005. It explains the four LINQ providers in the .NET Framework, the easiest ways to go about accessing data, and how to write more efficient applications with less code using LINQ. There’s also clear guidance on combining third-party providers with LINQ to create even more powerful apps. With this single, comprehensive guide, you’ll discover how to: Use one query language with all Microsoft languages Examine .NET language extensions and work with extension methods, partial methods, lambda expressions, and query expressions LINQ to DataSet operators, SQL server operations, XML API, or Active Directory Deal with databases — download and install the Northwind database, generate Northwind entity classes, and create the Northwind XML mapping file Create the partial class example, the partial method example, and the database modification example Use objects with LINQ Query databases in Visual Basic and C# As an added bonus, you can visit the companion Web site for LINQ examples in C# and Visual Basic. With LINQ For Dummies, you’ll link up with LINQ in no time and see how you can query almost anything! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Get the scoop on designing databases for Mac and Windows Use FileMaker Pro design and scripting to quickly, easily build databases that solve real problems FileMaker Pro has grown up, and it's better than ever! This easy-to-use guide shows you how to design a great FileMaker application, build a database that works, add the functionality you need, populate your database, and venture into programming with ScriptMaker. You'll find out how to share and protect your database, too. Discover how to * Build a layout that works * Create custom triggers and calculated fields * Generate reports automatically * Manage security * Publish your database on the Web * Embed pictures, sound, and video

Powerful, low-cost database development tools make it possible for virtually anybody to create their own database—and this hands-on guide makes it fun and easy Databases permeate every nook and cranny of our highly connected, information-intensive world, from ATMs to personal finance, online shopping, and networked information management. Databases have become so integral to the business environment that, nowadays, it's next to impossible to stay competitive without the assistance of some sort of database technology—no matter what type or size of business you run. But developing your own database can be tricky. Whether you want to keep records for a small business or run a large e-commerce website, developing the right database system can be a major challenge. Which is where Database Development For Dummies comes in. From data modeling methods and development tools to Internet accessibility and security, this comprehensive guide shows you, step-by-step and with illustrations, everything you need to know about building a custom system from the ground up. You'll learn to: Model data accurately Design a reliable functional database Deliver robust relational databases on time and on budget Build a user-friendly database application Put your database on the Web The book acquaints you with the most popular data modeling methods and shows you how to systematically design and develop a system incorporating a database and one or more applications that operate on it. Here's more of what you'll discover in the book: Database architecture and how it has evolved How database technology affects everyday life A structured approach to database development How to create an appropriate data model How to develop a reliable relational design The complexities that you're likely to encounter in designing a database and how to simplify them Implementing your design using Microsoft Access 2000, SQL Server, and other powerful database development tools Database security Ten rules to know when creating a database Another ten rules to know when creating a database application If you need a database tailored to you and your company's current and future data storage and management needs, this is the book for you. Get Database Development For Dummies and discover what it takes to design, develop, and implement a sophisticated database system.