database

  • Basic terms and definitions for the web developer: Database, Web Sites, User

    Use MySQL and PHP for Interactive Web Sites development This article introduces the concept of a database and other important components and definitions for the web developer. This material will be useful for novice web programmers to organize and systematize their knowledge.

  • Building Your Essbase Database: from Source to Completed database

    Build Essbase Database in Oracle StudioLet me introduce potential architectures for Essbase implementations, components of the overall solution (both required and optional), and fundamental design methodology. Now we present a hands-on demonstration of how to build an Essbase database.

    To get started, we'll start with an overview of the components and files used in the demonstration. During the demonstration, we walk you through how to build and deploy an Essbase database using Oracle Essbase Studio. Then we talk about how to calculate the database and validate the data in the database using reports. After the demonstration, we discuss some Essbase features you can take advantage of, such as custom load rules and member calculations. 

  • Business and Technology Benefits of Having DBaaS Enabled

    advantages of DBaaS implementing for BusinessDBaaS, or a database cloud, is becoming a very popular concept with organizations of all sizes across the spectrum of industry. Placing database infrastructure concerns with the DBaaS provider frees an organization’s IT and technology departments to focus at an organization level rather than at an application or department level. With the focus at an organizational level, the IT and technology teams are more closely aligned with the organizational and business needs. The fundamental requirements of an organization have never really changed—they have always aimed for lowered operational expenses (OPEX) and total cost of ownership (TCO). What has changed is the emergence of new platform architecture and software technologies that, working together, deliver on those needs. The opportunity to reduce OPEX and TCO is precisely what is driving the improved acceptance and adoption rate of DBaaS.

  • Choosing a Database for PHP

    Database Choosing for PHPDatabases and PHP go together like cake and ice cream, Trinidad and Tobago, green eggs and ham - you get the picture.

    After all, what’s the Web about? Making vast stores of information available to a more or less wide public, that’s what. Not that there aren’t small brochureware sites galore, but the bigger and more frequently updated the data source, the more comparative value is provided by the Web over other media.

  • Choosing a database for your application: MySQL, Oracle, SQL Server or DB2?

    How to Choosing a database for your application?All but the simplest application will connect to a database to store and retrieve data. Some applications utilize a proprietary database, but the majority will connect to one of the major commercially available relational database management systems. Oracle, Microsoft’s SQL Server, IBM DB2, and MySQL are some of the most commonly used database products.

    As the Application Administrator, you will want to know as much about the database as you can. Some of the details that you want to learn about are listed here.

  • Database News: DBMS, Storage, Big Data

    This section publishes news related to databases (DBMS). The release of new versions, patches, updates. Press releases, tests.

  • Database Systems We Considered

    Although you saw in the my previous article that there are standards for SQL, that is not to say that all DBMSs are the same. The Web site DB-Engines collects and presents information on DBMSs and provides a monthly listing of them, ranked by their current popularity, at this link.

    For many months now, their rankings have presented six DBMSs as consistently the most popular, listed in alphabetical order here (the versions that we used for our testing are in parentheses):

  • Designing an Oracle Essbase Database

    How to Design an Oracle Essbase DatabaseEarlier in our blogs, we covered general principles for designing effective OLAP applications. In this article, we expand on those general principles as they apply to the process of designing an Essbase database.

     

    Who Designs Essbase Databases?

    As mentioned in this blog, Essbase is often "owned" by line-of-business users, rather than by IT departments. Essbase databases are therefore designed and built either by an Oracle solutions consultant contracted by the line of business or by a business user within the organization itself.

  • Getting Started with MySQL: installing and working

    How to work with MySQL databasePerhaps you’ve never used a database system before or maybe you’ve used one as a user but have never had any need to set up one from scratch. Or perhaps you’ve decided to discover what all the fuss is about database systems in general. Or maybe you’ve used MySQL only as a developer never seeing how to setup and configure the server.

    In this bloge note, I present a short introduction to MySQL in the general SQL interface sense (traditional MySQL). Not only will you see how MySQL 8 is setup, you will also be introduced to some of the basics of the SQL interface, which is necessary and indeed required to fully manage a MySQL server. That is, the new shell, X protocol, X DevAPI, and the features that build on it but do not offer a complete mechanism for managing the server; you will need to continue to use SQL commands for those tasks.

  • How enterprises use and store data and Java Data Access capabilities

    enterprise data stores  and Java Data AccessNow more than ever, Java developers need to understand how to create data-centric applications. Data is an important commodity and organizations now try to capture, store, and analyze all the information they generate. As a result, many different forms of data exist and an equal number of different methods exist to store it. As a Java developer, you will likely face the challenge of writing an application that enables an organization to effectively use its data stored in either a single source or multiple sources.

  • Introducing MS SQL 2017 database server components: CPU

    CPUs component in MS SQL 2017 database server The Central Processing Unit, or CPU, and often called the “brain” of a computer, is the most important part of a system. CPU speed is measured in hertz (Hz), or cycles per second. Current processor speed is measured in GHz, or billions of cycles per second.

    Modern systems can have more than one CPU, and each CPU in turn can have more than one CPU core (which, in turn, might be split up into virtual cores).

    For a typical SQL Server workload, single-core speed matters. It is better to have fewer cores with higher clock speeds than more cores with lower speeds, especially for non-Enterprise editions.

  • Introducing MS SQL 2017 database server components: Memory

    Memory component in MS SQL 2017 database server In this blog, we cover the components that make up a typical database infrastructure. This article is introductory: this blog that follow provide more detail about designing, implementing, and provisioning databases.

    Although Microsoft SQL Server is new to Linux, Microsoft has, as much as possible, crafted it to work the same way that it does on Windows. We highlight places where there are differences.

  • Introducing MS SQL 2017 database server components: storing system

    Storage component in MS SQL 2017 database server When data is not in memory, it is at rest, and must be saved somewhere. Storage technology has evolved rapidly over the past few years, so we no longer think of storage as a mechanical hard drive containing one or more spinning metal disks with a magnetic surface. But, old habits die hard, and colloquially we still refer to a nonvolatile storage subsystem as “the disk,” even if it might take another form. In this book, however, we refer to it as a “drive.”

  • Introduction to ERP Systems

    ERP Systems what is this?I remember attending my first Oracle Applications Users Group (OAUG) conference in 1999. I believe this was the year that Larry Ellison, CEO of Oracle Corporation, declared that the internet would change everything. The use of the internet in everyday business life was in full swing at that time and the dot.com boom was roaring with start ups in 90% of all garages in the bay area (slight exaggeration...), some of which had turned into enormously successful corporations. Indeed the internet has changed life throughout the world. Most of us arc just as lost without internet access as wc arc without our cell phones.

    The advent and evolution of ERP (Enterprise Resource Planning) systems have had and are still having almost as significant an impact on organizations as the internet has had on the individual. ERP systems such as SAP and Oracle’s suite of products (E-Business Suite (EBS), PeopleSoft, JD Edwards, Siebel, Hyperion, Fusion, etc) continue to cause a dramatic change in business and IT processes.

  • Introduction to NoSQL Databases

    NoSQL system introduceSince the invention of the transistor, the proliferation and application of computer technologies has been shaped by Moore’s Law. The growth in CPU compute capacity, high-density memory, and low-cost data storage has resulted in the invention and mass adoption of a variety of computing devices over time. These devices have become ubiquitous in our life and provide various modes of communication, computation, and intelligent sensing. As more and more of these devices are connected to the cloud, the amount of online data generated by these devices is growing tremendously. Until recently, there did not exist a very cost-effective means for businesses to store, analyze, and utilize this data to improve competitiveness and efficiency. In fact, the sheer volume and sparse nature of this data has necessitated the development of new technologies to store and analyze the data.

  • Methods for Developing and Maintaining MySQL Databases with PHP

    Tools for  MysQL database development with phpThe four methods for managing databases are as follows (with the easiest method on the left and hardest on the right):

    • PhpMyAdmin
    • PHP
    • SQL command line
    • MS-DOS style command line

    Most web developers mainly using the first two methods, but not the MS-DOS-style command line. For interactive databases, you will need some PHP files. You do not need an extensive knowledge of PHP before you can create interactive databases. I introduce the PHP you require in the appropriate place in each project—that is, in context. The step-by-step, fully-worked examples will show you what MySQL and PHP can do and how to do it.

  • MySQL Crash Course - book


    Book MySQL Crash Course Author:Ben Forta
    Publisher: Sams Publishing

    Year: 2005
    Pages: 336
    Language: english
    Format: eBook (PDF)
    ISBN: 0672327120

  • MySQL Database Overview

    Data storage and retrieval is a core element of most applications today. In the early days of software development, programmers wrote their own low-level code to accomplish this. However, they quickly realized that in each application they were essentially reinventing the wheel. Through the usual cycle of trial, error, and subsequent refinement a solution was developed: the data storage and retrieval engine was abstracted into a stand-alone data­base server with the clients connecting to it and sending requests in a custom language called SQL (Structured Query Language).

  • Oracle Applications E-Business Suite introduction

    Oracle E-Business Suite ERP Applications familyOracle E-Business Suite is an Enterprise Resource Planning, which is also abbreviated as ERP. What exactly do we mean by an ERP? The three words themselves describe the meaning of this. You have an Enterprise that is a company, an organization, or even a small start-up. You need manpower to run this enterprise. Hence the word resource. In order to function effectively and efficiently, you need to manage and plan these resources.

    In short, you need to plan your resources in your enterprise to meet the objective of your enterprise. Hence, you need an ERP. There are numerous benefits of Oracle E-Business Suite in today's world. Each business today has various aspects, and managing those aspects is, in its own way, very challenging. Almost every enterprise today is dependent on software technology and applications to perform their day–to-day operations.

  • Oracle Berkeley DB overview

    Oracle Berkeley DB introductionOracle NoSQL Database uses Oracle Berkeley DB Java Edition as the underlying data storage engine. Berkeley DB Java Edition is a mature product that also provides many, but not all, of the features and characteristics that are necessary for building a distributed key-value store such as Oracle NoSQL Database.

    The Berkeley DB family of embeddable database products was developed by Sleepycat Software, Inc., beginning in the early 1990s. Sleepycat Software, Inc. was later acquired by Oracle in 2006. Since the acquisition, Oracle has continued to invest in the Berkeley DB family of products by adding features and enhancements to meet the needs of a large and growing base of users. In addition to a SQL interface (the SQL API is available for Berkeley DB, but not for Berkeley DB Java Edition) for supporting ad hoc queries, there have been major performance and reliability enhancements as well as support for enterprise mobility. Enterprise mobility support is available through the SQL API for Berkeley DB.

Page 1 of 2