Skip to main content

Posts

SQL Server Database Audit Queries

When we work with a single table in SQL Server, it is very easy to perform audit queries. But, while dealing with multiple tables of the same database, it becomes a very tedious job for new database developers. We need data from multiple sources(for example : all tables of a single database). As a newcomer to this field, i too got stuck in the same kind of queries, so, I have searched the web and have listed down a few queries that can help in retrieving data through audit queries. 

Event Automation in mysql

A MySQL event is a task that runs based on a predefined schedule therefore sometimes it is referred to as a scheduled event. MySQL event is also known as “temporal trigger” because it is triggered by time, not by table update like a trigger. A MySQL event is similar to a cron job in UNIX or a task scheduler in Windows. You can use MySQL events in many cases such as optimizing database tables, cleaning up logs, archiving data, or generate complex reports during off-peak time.

Usage of Float,Double and Decimal Data Types in MySql

When we start developing a database, we have to use the most appropriate data types for all the columns to store data values of the respective tables in it. For dealing with the floating type data values, most of the times, we get confused about which data type to go for, as we have Float, Decimal and Double as well. I, myself, as a new DBA, got confused about the usage of the same. So, i have re-searched through some websites over internet and have concluded some facts about these data types' usage. i want to share my experience with all of you.

What is Avro Schema

Avro schema generally used to define the data schema for a record's value. This schema describes the fields allowed in the value, along with their data types. We can apply a schema to the value portion of an Oracle NoSQL Database record using Avro bindings. These bindings are used to serialize values before writing them, and to deserialize values after reading them. The usage of these bindings requires our applications to use the Avro data format, which means that each stored value is associated with a schema. The use of Avro schemas allows serialized values to be stored in a very space-efficient binary format. Each value is stored without any metadata other than a small internal schema identifier, between 1 and 4 bytes in size. One such reference is stored per key-value pair. In this way, the serialized Avro data format is always associated with the schema used to serialize it, with minimal overhead. This association is made transparently to the application, and the internal sche

Difference between key-value stores and key-value pairs

Difference between key-value stores and key-value pairs or Difference between  Key-value stores  and document db or Difference between Redias and mongoDb .   Key Values always Conf us ed me that's why i decided to share my some short of experience , In NoSQL Databases KV Pair and KV Stores are different. Event they are related to different database vendors too. Key-Value stores ; store keys value pairs  in buckets, exactly like a hash table data structure; where each key must be unique.  They are extremely fast for writing, and extremely fast for reading and updating. if you have the key.  They are slow on multiple updates and if you have to query the entire store.  You see Key-value stores used a lot as caching stores because of their fast reads. eg: Redis, Riak, memcached, Azure's tablestore, etc Document Stores ; store data in "documents", typically XML or JSON documents. They're typically schema-less, so each document can contain any data that you want

First Day with Neo4j Graph Database

Hi friends, 2015 is the year when I started working on noSQL databases, I have shared my few post earlier on same . Today my post is related to one more nosql database which came into my skill recently. This is a popular Graph Database Neo4j. Neo4j is a popular noSQL, open-source, graph database which is implemented in Java and accessible from software written in other languages using CQL. Neo4j Support ACID. What is Graph Database ? In computing, a graph database is a database that uses graph structures for semantic queries with nodes, edges and properties to represent and store data. Graph databases employ nodes, properties, and edges.

Two way to execute javaScript in mongod

Hi friends, We can automate things of mongdb using javascript procedures . Mongodb allows to execute javaScript through two ways . This post will demonstrate how to automate mongodb administration work. First of all write mongodb queries or procedure, which we have to performe and then save into .js file and then consider any process out of below 2. 1.) We can execute from command shell, without login mongo shell. So we can schedule script of administering tasks that will run automatically like below : c:\>mongo localhost:27017/test admin.js This operation executes the admin.js script in a mongo shell that connects to the test database on the mongod instance accessible via the localhost interface on port 27017. 2.) We can execute a .js file from within the mongo shell, using the load() function, as in the following: load("admin.js") Thanks for reading